TRTVENTAR processing: Manual Entry Reason Loading
RECHTARIF: Intervention before the price list search
Use this entry point to intervene in the price list search (normal or component):
- by modifying the value of the reference date: DATREF,
- by modifying the value of the rate type: LCHGTYP.
You can also use this entry point to perform several search loops in order to obtain the best net price.
This entry point is called in the TRTVENTAR processing (RECH_TARIF subprogram):
- in price list simulation: to calculate the normal price list,
- in quote management: to calculate the normal or component price list,
- in order management: to calculate the normal or component price list,
- in delivery management: to calculate the normal or component price list,
- in invoice management: to calculate the normal or component price list.
Context and operating mode
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Different call cases
This entry point is called:
· in price list simulation upon activating the "Apply" button. The date entered is stored in the [M:SOH0]ORDDAT, [M:SOH2]DEMDLVDAT, [M:SOH4]DDEMDLVDAT(0) data
· in quote, order, delivery and invoice management, after entering the product quantity.
Available variables and masks
The following variables are loaded and used to identify the call context.
. TYPRECH: 1= for a standard product, 2= for a component
. ITMREF: Product reference
. NLIG: Table line index (nolign-1)
. QTY: Quantity in sales units
. TYPALI: Loading type
= SQH for quotes
= SOH for orders and price list simulation
= SDH for deliveries
= SIH for invoices
The screen classes loaded are as follows:
|
Context |
TYPALI |
Screens |
|
Price list simulation |
SOH |
SOH0 SOH1 SOH2 SOH3 SOH4 SPSIMUL0 SPSIMUL1 |
|
Quote |
SQH |
SQH0 SQH1 SQH2 SQH3 |
|
Orders |
SOH |
SOH0 SOH1 SOH2 SOH3 SOH4 |
|
Deliveries |
SDH |
SDH0 SDH1 SDH2 SDH3 |
|
Invoices |
SIH |
SIH0 SIH1 SIH2 SIH4 |
The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.
Open tables
In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.
|
Table |
Simu |
Quote |
Ord |
Del |
Inv |
Significant content |
Table title |
|
BPARTNER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
BP |
|
BPCUSTOMER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer |
|
BPCUSMVT |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer transactions |
|
BPDLVCUST |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Ship-to customer |
|
BPCARRIER |
|
|
Yes |
|
|
No |
Carrier |
|
CONTACT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Contact |
|
ITMMASTER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
|
ITMSALES |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales product |
|
ITMBPC |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Customer product |
|
ITMMVT |
Yes |
|
Yes |
Yes |
Yes |
No |
Product totals |
|
ITMFACILITY |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Product-site |
|
ITMCOST |
|
Yes |
Yes |
|
|
No |
Product cost |
|
SALESREP |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Sales representative |
|
SPRICLINK |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list search (link) |
|
FACILITY |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Site |
|
ATABDIV |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Miscellaneous tables |
|
TABCUR |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Currency table |
|
TABVAC |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax determination table |
|
TABVAT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax code table |
|
TABRATVAT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax rate table |
|
TABCHANGE |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Currency rate table |
|
TABUNIT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Unit table |
|
TABSOHTYP |
|
|
Yes |
Yes |
|
No |
Order type table |
|
TABSIVTYP |
|
|
|
|
Yes |
No |
Invoice type table |
|
TABDEPAGIO |
|
Yes |
Yes |
|
Yes |
No |
Early discount/late charge table |
|
TABPAYTERM |
|
Yes |
Yes |
|
Yes |
No |
Payment term table |
|
TABUNAVAIL |
|
|
Yes |
Yes |
|
No |
Unavailable periods table |
|
TABMODELIV |
|
|
Yes |
Yes |
|
No |
Delivery methods table |
|
|
|
|
|
|
|
|
|
|
SQUOTE |
|
Yes |
Yes |
|
|
No |
Quote header |
|
SQUOTED |
|
Yes |
Yes |
|
|
No |
Quote detail |
|
SORDER |
Yes |
|
Yes |
Yes |
Yes |
No |
Order header |
|
SORDERP |
|
|
Yes |
Yes |
Yes |
No |
Order detail (price) |
|
SORDERQ |
|
|
Yes |
Yes |
Yes |
No |
Order detail (quantities) |
|
SDELIVERY |
|
|
|
Yes |
Yes |
No |
Delivery header |
|
SDELIVERYD |
|
|
|
Yes |
Yes |
No |
Delivery detail |
|
SINVOICE |
|
|
|
|
Yes |
No |
Invoice header |
|
SINVOICEV |
|
|
|
|
Yes |
No |
Invoice header (valuation) |
|
SINVOICED |
|
|
|
|
Yes |
No |
Invoice detail |
|
|
|
|
|
|
|
|
|
|
GTYPACCENT |
|
|
|
|
Yes |
No |
Entry type |
|
GACCCODE |
|
|
|
|
Yes |
No |
Accounting codes |
|
GACCOUNT |
|
|
|
|
Yes |
No |
General ledger accounts |
|
GJOURNAL |
|
|
|
|
Yes |
No |
Journals |
|
|
|
|
|
|
|
|
|
Search loops
Reminder:
In the price list search, the best value for the customer is only delivered for an equal priority and for a column (price or charges/discounts).
Some customers may benefit from sales conditions that are more favorable than promotional price lists, but the application of priorities always delivers the promotional price list.
Aim :
Performing several search loops and delivering the best net price.
It is necessary to assign each price list to a search loop. This code (from 0 to 8) will be defined in the setup in a future version.
Example:
It is necessary to start a specific loop for the PROMO price list (assignment of search code 1).
$ACTION
Case ACTION
When "RECHTARIF" : Gosub RECHTARIF
Endcase
Return
$RECHTARIF
Local Integer ZII
ZII=find("PROMO",GPLI)
If ZII: GPLISEA(ZII-1)=1: Endif
Return
RECHTARIF1: Intervene on the values returned by the price list search
Use this entry point to intervene in the values returned by the price list search (standard or component).
This entry point is called in the TRTVENTAR processing (RECH_TARIF subprogram)
- in price list simulation: to calculate the standard price list. (SOH loading type)
- in quote management: to calculate the standard or component price list (SQH loading type)
- in order management: to calculate the standard or component price list (SOH loading type)
- in delivery management: to calculate the standard or component price list (SDH loading type)
- in invoice management: to calculate the standard or component price list (SIH loading type)
- in service response management: to calculate the standard price list (CRM loading type)
- in intersite transfer management: to calculate the standard price list (SCS loading type)
Fields available for modification:
- The gross price (GROPRI), which is one of the parameters of the RECH_TARIF subprogram. You should never directly modify the value defined in the [M]GROPRI (NLIG) class as it can be overwritten depending on the call context.
- If loading type: SQH, SOH, SDH, SIH
o the values stored in the [M] class
§ [M]PRIREN (NLIG) Price reason
§ [M]DISCRGVALx (NLIG) Charge/discount (x=1 to 9)
§ [M]DISCRGRENx (NLIG) Charge/discount reason (x=1 to 9)
§ [M]REPCOE (NLIG) Sales representative commission coef. (except for quotes)
- If loading type: CRM
o the values stored in the [M:SPSW] class
§ [M:SPSW]PRIREN (NLIG) Price reason
§ [M:SPSW]DISCRGVALx (NLIG) Charge/discount (x=1 to 9)
§ [M:SPSW]DISCRGRENx (NLIG) Charge/discount reason (x=1 to 9)
§ [M:SPSW]REPCOE (NLIG) Sales representative commission coef. (except for quotes)
- If loading type: SCS
o the values stored in the [M:SCS1] class
§ [M:SCS1]DISCRGVALx (NLIG) Charge/discount (x=1 to 9)
Context and operating mode
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Different call cases
This entry point is called:
· in price list simulation upon activating the "Apply" button. The date entered is stored in the [M:SOH0]ORDDAT, [M:SOH2]DEMDLVDAT, [M:SOH4]DDEMDLVDAT(0) data
· in quote, order, delivery and invoice management, after entering the product quantity.
Available variables and masks
The following variables are loaded and used to identify the call context.
. TYPRECH: 1= for a standard product, 2= for a component
tab. ITMREF: Product reference
. NLIG: Table line index (nolign-1)
. QTY: Quantity in sales units
. TYPALI: Loading type
= SQH for quotes
= SOH for orders and price list simulation
= SDH for deliveries
= SIH for invoices
= CRM for interventions
= SCS for inter-site transfers
The screen classes loaded are as follows:
|
Context |
TYPALI |
Screens |
|
Price list simulation |
SOH |
SOH0 SOH1 SOH2 SOH3 SOH4 SPSIMUL0 SPSIMUL1 |
|
Quote |
SQH |
SQH0 SQH1 SQH2 SQH3 |
|
Orders |
SOH |
SOH0 SOH1 SOH2 SOH3 SOH4 |
|
Deliveries |
SDH |
SDH0 SDH1 SDH2 SDH3 |
|
Invoices |
SIH |
SIH0 SIH1 SIH2 SIH4 |
|
Service responses |
CRM |
SPSW |
|
Transfers |
SCS |
SCS1 |
The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.
Open tables
In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.
|
Table |
Simu |
Quote |
Ord |
Del |
Inv |
Significant content |
Table title |
|
BPARTNER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
BP |
|
BPCUSTOMER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer |
|
BPCUSMVT |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer transactions |
|
BPDLVCUST |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Ship-to customer |
|
BPCARRIER |
|
|
Yes |
|
|
No |
Carrier |
|
CONTACT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Contact |
|
ITMMASTER |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
|
ITMSALES |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales product |
|
ITMBPC |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Customer product |
|
ITMMVT |
Yes |
|
Yes |
Yes |
Yes |
No |
Product totals |
|
ITMFACILITY |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Product-site |
|
ITMCOST |
|
Yes |
Yes |
|
|
No |
Product cost |
|
SALESREP |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Sales representative |
|
SPRICLINK |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list search (link) |
|
FACILITY |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Site |
|
ATABDIV |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Miscellaneous tables |
|
TABCUR |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Currency table |
|
TABVAC |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax determination table |
|
TABVAT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax code table |
|
TABRATVAT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Tax rate table |
|
TABCHANGE |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Currency rate table |
|
TABUNIT |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Unit table |
|
TABSOHTYP |
|
|
Yes |
Yes |
|
No |
Order type table |
|
TABSIVTYP |
|
|
|
|
Yes |
No |
Invoice type table |
|
TABDEPAGIO |
|
Yes |
Yes |
|
Yes |
No |
Early discount/late charge table |
|
TABPAYTERM |
|
Yes |
Yes |
|
Yes |
No |
Payment term table |
|
TABUNAVAIL |
|
|
Yes |
Yes |
|
No |
Unavailable periods table |
|
TABMODELIV |
|
|
Yes |
Yes |
|
No |
Delivery methods table |
|
|
|
|
|
|
|
|
|
|
SQUOTE |
|
Yes |
Yes |
|
|
No |
Quote header |
|
SQUOTED |
|
Yes |
Yes |
|
|
No |
Quote detail |
|
SORDER |
Yes |
|
Yes |
Yes |
Yes |
No |
Order header |
|
SORDERP |
|
|
Yes |
Yes |
Yes |
No |
Order detail (price) |
|
SORDERQ |
|
|
Yes |
Yes |
Yes |
No |
Order detail (quantities) |
|
SDELIVERY |
|
|
|
Yes |
Yes |
No |
Delivery header |
|
SDELIVERYD |
|
|
|
Yes |
Yes |
No |
Delivery detail |
|
SINVOICE |
|
|
|
|
Yes |
No |
Invoice header |
|
SINVOICEV |
|
|
|
|
Yes |
No |
Invoice header (valuation) |
|
SINVOICED |
|
|
|
|
Yes |
No |
Invoice detail |
|
|
|
|
|
|
|
|
|
|
GTYPACCENT |
|
|
|
|
Yes |
No |
Entry type |
|
GACCCODE |
|
|
|
|
Yes |
No |
Accounting codes |
|
GACCOUNT |
|
|
|
|
Yes |
No |
General ledger accounts |
|
GJOURNAL |
|
|
|
|
Yes |
No |
Journals |
|
|
|
|
|
|
|
|
|
RECHGROUP: Intervene in the values returned by the price list search
Use this entry point to intervene in the thee types of modifications performed by the grouped price lists.
Line modification
The value 1 in the [M]GRPFLG variable (line no.) indicates that a modification occurred on this line.
The fields available for modification are:
[M]GROPRI (line no.) Gross price
[M]PRIREN (line no.) Price reason
[M]DISCRGVALx (line no.) Discount/charge (x=1 à 9)
[M]DISCRGRENx (line no.) Discount/charge reasons (x=1 à 9)
[M]REPCOE (line no.) Coef. Sales representative commission (except for quotes)
However it is not possible to identify the fields actually modified by the grouped price list. Moreover, the net unit price for the [M]NETPRI line (line no.), is not re-calculated yet.
Modification of the invoicing elements
The grouped price lists can modify the content of the invoicing elements (see the paragraph on the Calculation basis by document in the price list structure). The internal MOTIF and MONTANT tables are used for the update of the table for invoicing elements. MOTIF(x) contains the invoicing element code; MONTANT(x) contains the value returned by the search. At this level, the transfer to the table for elements has already been performed.
Creation of the grouped price list lines
If the search returns free products, the data necessary for the creation of the lines are contained in the following tables:
- FOCITMREF Product reference
- FOCUOM Sales unit
- FOCQTY Quantity
- FOCMOTIF Free product allocation reason
The free lines are not yet created. By setting the GPE variable to 1, you can cancel this creation.
Context and operating mode
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Different call cases
This entry point is called:
· in quote, order, delivery and invoice management.
Available variables and masks
. GFONCTION: Loading type
= GESSQH for quotes
= GESSOH for orders and price list simulation
= GESSDH for deliveries
= GESSIH for invoices
The screen classes loaded are as follows:
|
Context |
GFONCTION |
Screens |
|
Quote |
GESSQH |
SQH0 SQH1 SQH2 SQH3 |
|
Orders |
GESSOH |
SOH0 SOH1 SOH2 SOH3 SOH4 |
|
Deliveries |
GESSDH |
SDH0 SDH1 SDH2 SDH3 |
|
Invoices |
GESSIH |
SIH0 SIH1 SIH2 SIH4 |
The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.
Open tables
In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.
|
Table |
Quote |
Ord |
Del |
Inv |
Significant content |
Table title |
|
BPARTNER |
Yes |
Yes |
Yes |
Yes |
Yes |
BP |
|
BPCUSTOMER |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer |
|
BPCUSMVT |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer transactions |
|
BPDLVCUST |
Yes |
Yes |
Yes |
Yes |
Yes |
Ship-to customer |
|
BPCARRIER |
|
Yes |
|
|
No |
Carrier |
|
CONTACT |
Yes |
Yes |
Yes |
Yes |
No |
Contact |
|
ITMMASTER |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
|
ITMSALES |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales product |
|
ITMBPC |
Yes |
Yes |
Yes |
Yes |
No |
Customer product |
|
ITMMVT |
|
Yes |
Yes |
Yes |
No |
Product totals |
|
ITMFACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Product-site |
|
ITMCOST |
Yes |
Yes |
|
|
No |
Product cost |
|
PRICSTRUCT |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list structure |
|
SALESREP |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales representative |
|
SPRICLIST |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list lines |
|
SPRICLINK |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list search (link) |
|
FACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Site |
|
ATABDIV |
Yes |
Yes |
Yes |
Yes |
No |
Miscellaneous tables |
|
TABCUR |
Yes |
Yes |
Yes |
Yes |
No |
Currency table |
|
TABVAC |
Yes |
Yes |
Yes |
Yes |
No |
Tax determination table |
|
TABVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax code table |
|
TABRATVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax rate table |
|
TABCHANGE |
Yes |
Yes |
Yes |
Yes |
No |
Currency rate table |
|
TABUNIT |
Yes |
Yes |
Yes |
Yes |
No |
Unit table |
|
TABSOHTYP |
|
Yes |
Yes |
|
No |
Order type table |
|
TABSIVTYP |
|
|
|
Yes |
No |
Invoice type table |
|
TABDEPAGIO |
Yes |
Yes |
|
Yes |
No |
Early discount/late charge table |
|
TABPAYTERM |
Yes |
Yes |
|
Yes |
No |
Payment term table |
|
TABUNAVAIL |
|
Yes |
Yes |
|
No |
Unavailable periods table |
|
TABMODELIV |
|
Yes |
Yes |
|
No |
Delivery methods table |
|
|
|
|
|
|
|
|
|
SQUOTE |
Yes |
Yes |
|
|
No |
Quote header |
|
SQUOTED |
Yes |
Yes |
|
|
No |
Quote detail |
|
SORDER |
|
Yes |
Yes |
Yes |
No |
Order header |
|
SORDERP |
|
Yes |
Yes |
Yes |
No |
Order detail (price) |
|
SORDERQ |
|
Yes |
Yes |
Yes |
No |
Order detail (quantities) |
|
SDELIVERY |
|
|
Yes |
Yes |
No |
Delivery header |
|
SDELIVERYD |
|
|
Yes |
Yes |
No |
Delivery detail |
|
SINVOICE |
|
|
|
Yes |
No |
Invoice header |
|
SINVOICEV |
|
|
|
Yes |
No |
Invoice header (valuation) |
|
SINVOICED |
|
|
|
Yes |
No |
Invoice detail |
|
|
|
|
|
|
|
|
|
GTYPACCENT |
|
|
|
Yes |
No |
Entry type |
|
GACCCODE |
|
|
|
Yes |
No |
Accounting codes |
|
GACCOUNT |
|
|
|
Yes |
No |
General ledger accounts |
|
GJOURNAL |
|
|
|
Yes |
No |
Journals |
|
|
|
|
|
|
|
|
RECHGROUP1: Modification of those values coming from the search for a grouped pr
Use this entry point to intervene in the values returned when applying a grouped price list.
After selecting a line on which the grouped price list can be applied (if CODENTPNT=S1)
- It is possible to assign the value 1 to the NONSEL variable in order to reject the selection of the line. In this case, the CUMQTY and CUMAMT variables are not adjusted with the quantity and net price of the line.
Between the line selection loop and the price list application to the selected line (if CODENTPNT=S2)
- This allows you to modify the values for amount total (CUMAMT) and quantity total (CUMQTY), which will be used as a basis for the application of the grouped price list.
- This allows you to intervene during the rounding of the quantity total (CUMQTY) based on the price list unit so that you can prevent it by setting the WARR_CUMQTY variable to 0.
On updating a line (if CODENTPNT=G1 )
- by modifying directly the values stored in the line ([M] class)
[M]GROPRI (NLG) Gross price
[M]PRIREN (NLG) Price reason
[M]DISCRGVALx (NLG) Charge/discount (x=1 to 9)
[M]DISCRGRENx (NLG) Charge/discount reason (x=1 to 9)
[M]REPCOE (NLG) Coef. Sales representative commission (except for quotes)
- by using the references for the applied price list
|
|
Price list |
Price list record |
Line no. |
|
Gross price |
PLI(0) |
PLICRD(0) |
PLILIN(0) |
|
Discount/charge (x=1 to 9) |
PLI(x) |
PLICRD(x) |
PLILIN(x) |
On the update of the free product (if CODENTPNT=G2)
- by directly modifying the values returned before the creation of the free line
FOCITMREF(IGR-1) Free product reference
FOCITMQTY(IGR-1) Free quantity
FOCMOTIF(IGR-1) Free reason
- by using the references for the applied price list
|
Price list |
Price list record |
Line no. |
|
[F:SPL]PLI |
[F:SPL]PLICRD |
[F:SPL]PLILIN |
Note:
Do not modify the IGR value, which is the index for the free item table
Do not use the NLG value, since it is not significant in the context of free products.
This entry point is called in the TRTVENTAR processing from the generated processes WBTxxxxxx (xxxxxx=price list code)
- in quote management
- in order management
- in delivery management
- in invoice management
Context and operating mode
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Different call cases
This entry point is called:
· in quote, order, delivery and invoice management, after entering the product quantity.
Available variables and masks
The following variables are loaded and used to identify the call context.
tab. CODENTPNT: Type of call to the entry point
= G0 no update for the line
= G1 if call when a line is updated
= G2 if call when a free product is updated
. NLG: Table line index (nolign-1) on update of a line
. GFONCTION: Loading type
= GESSQH for quotes
= GESSOH for orders and price list simulation
= GESSDH for deliveries
= GESSIH for invoices
The screen classes loaded are as follows:
|
Context |
GFONCTION |
Screens |
|
Quote |
GESSQH |
SQH0 SQH1 SQH2 SQH3 |
|
Orders |
GESSOH |
SOH0 SOH1 SOH2 SOH3 SOH4 |
|
Deliveries |
GESSDH |
SDH0 SDH1 SDH2 SDH3 |
|
Invoices |
GESSIH |
SIH0 SIH1 SIH2 SIH4 |
The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.
Open tables
In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.
|
Table |
Quote |
Ord |
Del |
Inv |
Significant content |
Table title |
|
BPARTNER |
Yes |
Yes |
Yes |
Yes |
Yes |
BP |
|
BPCUSTOMER |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer |
|
BPCUSMVT |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer transactions |
|
BPDLVCUST |
Yes |
Yes |
Yes |
Yes |
Yes |
Ship-to customer |
|
BPCARRIER |
|
Yes |
|
|
No |
Carrier |
|
CONTACT |
Yes |
Yes |
Yes |
Yes |
No |
Contact |
|
ITMMASTER |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
|
ITMSALES |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales product |
|
ITMBPC |
Yes |
Yes |
Yes |
Yes |
No |
Customer product |
|
ITMMVT |
|
Yes |
Yes |
Yes |
No |
Product totals |
|
ITMFACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Product-site |
|
ITMCOST |
Yes |
Yes |
|
|
No |
Product cost |
|
PRICSTRUCT |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list structure |
|
SALESREP |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales representative |
|
SPRICLIST |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list lines |
|
SPRICLINK |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list search (link) |
|
FACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Site |
|
ATABDIV |
Yes |
Yes |
Yes |
Yes |
No |
Miscellaneous tables |
|
TABCUR |
Yes |
Yes |
Yes |
Yes |
No |
Currency table |
|
TABVAC |
Yes |
Yes |
Yes |
Yes |
No |
Tax determination table |
|
TABVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax code table |
|
TABRATVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax rate table |
|
TABCHANGE |
Yes |
Yes |
Yes |
Yes |
No |
Currency rate table |
|
TABUNIT |
Yes |
Yes |
Yes |
Yes |
No |
Unit table |
|
TABSOHTYP |
|
Yes |
Yes |
|
No |
Order type table |
|
TABSIVTYP |
|
|
|
Yes |
No |
Invoice type table |
|
TABDEPAGIO |
Yes |
Yes |
|
Yes |
No |
Early discount/late charge table |
|
TABPAYTERM |
Yes |
Yes |
|
Yes |
No |
Payment term table |
|
TABUNAVAIL |
|
Yes |
Yes |
|
No |
Unavailable periods table |
|
TABMODELIV |
|
Yes |
Yes |
|
No |
Delivery methods table |
|
|
|
|
|
|
|
|
|
SQUOTE |
Yes |
Yes |
|
|
No |
Quote header |
|
SQUOTED |
Yes |
Yes |
|
|
No |
Quote detail |
|
SORDER |
|
Yes |
Yes |
Yes |
No |
Order header |
|
SORDERP |
|
Yes |
Yes |
Yes |
No |
Order detail (price) |
|
SORDERQ |
|
Yes |
Yes |
Yes |
No |
Order detail (quantities) |
|
SDELIVERY |
|
|
Yes |
Yes |
No |
Delivery header |
|
SDELIVERYD |
|
|
Yes |
Yes |
No |
Delivery detail |
|
SINVOICE |
|
|
|
Yes |
No |
Invoice header |
|
SINVOICEV |
|
|
|
Yes |
No |
Invoice header (valuation) |
|
SINVOICED |
|
|
|
Yes |
No |
Invoice detail |
|
|
|
|
|
|
|
|
|
GTYPACCENT |
|
|
|
Yes |
No |
Entry type |
|
GACCCODE |
|
|
|
Yes |
No |
Accounting codes |
|
GACCOUNT |
|
|
|
Yes |
No |
General ledger accounts |
|
GJOURNAL |
|
|
|
Yes |
No |
Journals |
|
|
|
|
|
|
|
|
RECHGROUP0: Intervention before the grouped price list search
Use this entry point to intervene before the grouped price lists are searched.
This entry point is called in TRTVENTAR (RECH_GROUPE subprogram).
Context and operating mode
Transaction
There is no transaction in progress.
Log file
There is no open log file.
Different call cases
This entry point is called in the management of quotes, orders, deliveries, invoices when using "Create" or "Save".
Available variables and masks
The following variables are populated:
. TYPALI: Loading type
= SQH for quotes
= SOH for orders and price list simulation
= SDH for deliveries
= SIH for invoices
tab. DATREF: Reference date
tab. LCHGTYP: Exchange rate type
tab. LPRITYP: Price type
. LCUR: Currency
The screen classes loaded are as follows:
|
Context |
GFONCTION |
Screens |
|
Quote |
GESSQH |
SQH0 SQH1 SQH2 SQH3 |
|
Orders |
GESSOH |
SOH0 SOH1 SOH2 SOH3 SOH4 |
|
Deliveries |
GESSDH |
SDH0 SDH1 SDH2 SDH3 |
|
Invoices |
GESSIH |
SIH0 SIH1 SIH2 SIH4 |
The SQH3, SOH4, SDH1, SIH4 screens contain the table of the lines.
Open tables
In the table shown below, the flag (significant content = yes) indicates that the data in the classes concerned are consistent with the context and must not be modified by the entry point.
|
Table |
Quote |
Ord |
Del |
Inv |
Significant content |
Table title |
|
BPARTNER |
Yes |
Yes |
Yes |
Yes |
Yes |
BP |
|
BPCUSTOMER |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer |
|
BPCUSMVT |
Yes |
Yes |
Yes |
Yes |
Yes |
Customer transactions |
|
BPDLVCUST |
Yes |
Yes |
Yes |
Yes |
Yes |
Ship-to customer |
|
BPCARRIER |
|
Yes |
|
|
No |
Carrier |
|
CONTACT |
Yes |
Yes |
Yes |
Yes |
No |
Contact |
|
ITMMASTER |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
|
ITMSALES |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales product |
|
ITMBPC |
Yes |
Yes |
Yes |
Yes |
No |
Customer product |
|
ITMMVT |
|
Yes |
Yes |
Yes |
No |
Product totals |
|
ITMFACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Product-site |
|
ITMCOST |
Yes |
Yes |
|
|
No |
Product cost |
|
PRICSTRUCT |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list structure |
|
SALESREP |
Yes |
Yes |
Yes |
Yes |
Yes |
Sales representative |
|
SPRICLIST |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list lines |
|
SPRICLINK |
Yes |
Yes |
Yes |
Yes |
Yes |
Price list search (link) |
|
FACILITY |
Yes |
Yes |
Yes |
Yes |
No |
Site |
|
ATABDIV |
Yes |
Yes |
Yes |
Yes |
No |
Miscellaneous tables |
|
TABCUR |
Yes |
Yes |
Yes |
Yes |
No |
Currency table |
|
TABVAC |
Yes |
Yes |
Yes |
Yes |
No |
Tax determination table |
|
TABVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax code table |
|
TABRATVAT |
Yes |
Yes |
Yes |
Yes |
No |
Tax rate table |
|
TABCHANGE |
Yes |
Yes |
Yes |
Yes |
No |
Currency rate table |
|
TABUNIT |
Yes |
Yes |
Yes |
Yes |
No |
Unit table |
|
TABSOHTYP |
|
Yes |
Yes |
|
No |
Order type table |
|
TABSIVTYP |
|
|
|
Yes |
No |
Invoice type table |
|
TABDEPAGIO |
Yes |
Yes |
|
Yes |
No |
Early discount/late charge table |
|
TABPAYTERM |
Yes |
Yes |
|
Yes |
No |
Payment term table |
|
TABUNAVAIL |
|
Yes |
Yes |
|
No |
Unavailable periods table |
|
TABMODELIV |
|
Yes |
Yes |
|
No |
Delivery methods table |
|
|
|
|
|
|
|
|
|
SQUOTE |
Yes |
Yes |
|
|
No |
Quote header |
|
SQUOTED |
Yes |
Yes |
|
|
No |
Quote detail |
|
SORDER |
|
Yes |
Yes |
Yes |
No |
Order header |
|
SORDERP |
|
Yes |
Yes |
Yes |
No |
Order detail (price) |
|
SORDERQ |
|
Yes |
Yes |
Yes |
No |
Order detail (quantities) |
|
SDELIVERY |
|
|
Yes |
Yes |
No |
Delivery header |
|
SDELIVERYD |
|
|
Yes |
Yes |
No |
Delivery detail |
|
SINVOICE |
|
|
|
Yes |
No |
Invoice header |
|
SINVOICEV |
|
|
|
Yes |
No |
Invoice header (valuation) |
|
SINVOICED |
|
|
|
Yes |
No |
Invoice detail |
|
|
|
|
|
|
|
|
|
GTYPACCENT |
|
|
|
Yes |
No |
Entry type |
|
GACCCODE |
|
|
|
Yes |
No |
Accounting codes |
|
GACCOUNT |
|
|
|
Yes |
No |
General ledger accounts |
|
GJOURNAL |
|
|
|
Yes |
No |
Journals |
|
|
|
|
|
|
|
|