|
|
SABOOKED FILE
Booked Order
The Booked Order file stores booking information applicable to an entire
order.
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAB-COMPANY Numeric 4 SA100 SA110
Element: Company The company number represents the SA300
highest organizational level and is
required on all form action codes.
SAB-ORDER-NBR Numeric 8 SA100 SA110
Element: Order Number Each order is assigned a unique number. SA300
Order numbers are either manually
assigned or system assigned based on a
company-level option.
SAB-PROCESS-LEVEL Alpha 5 SA100 SA110
Element: Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SAB-LOCATION Alpha 5 SA100 SA110
Element: Location Code This field contains a valid stocking SA300
location within the company inventory.
SAB-SALESMAN Numeric 4 SA100 SA110
Element: Salesman NumbeThe primary sales representative for SA300
this order.
SAB-SALESMAN-2 Numeric 4 SA100 SA110
Element: Salesman NumbeThe secondary sales representative (if SA300
any) for this order.
SAB-COMM-RATE-1 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
of the primary sales representative.
This defaults from the sales
representative file.
SAB-COMM-RATE-2 Percent 7.5 (Percent)
Element: Chrg Rate This field contains the commission rate
for the second sales representative.
This defaults from the sales
representative file.
SAB-COMM-SPLIT Percent 5.3 (Percent)
Commission Split This field contains the commission
Percentage split. This defaults from the customer
file.
SAB-TERRITORY Alpha 4 SA100 SA110
Element: Sales TerritorThe territory this order has been SA300
booked under.
SAB-ORDER-TYPE Alpha 2 SA100 SA110
Element: Order Type CodThe order type for this booked order. SA300
SAB-ORDER-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Date The date this booked order was entered SA300
into the system.
SAB-OPR-CODE Alpha 10 (Lower Case) SA100 SA110
Element: Operator Code Operator code. This is set to the SA300
security user ID of the user who created
this booked order.
SAB-CUST-PO-NBR Alpha 22 SA100 SA110
Element: Customer P.O. Customer purchase order number for this SA300
booked order.
SAB-LETTER-OF-CR Alpha 20 SA100 SA110
Element: Letter of CredThis field contains the letter of SA300
credit.
SAB-CURRENCY-CODE Alpha 5 SA100 SA110
Element: Currency Code The currency this order was billed in. SA300
SAB-CURR-RATE Signed 14.7
Element: Currency Rate The currency exchange rate in effect
when the order was booked.
SAB-CUSTOMER-CODE Alpha 4 SA100 SA110
Element: Customer Code The customer code for the bill-to SA300
customer for this booked order.
SAB-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Element: Customer NumbeThis field contains the number that SA300
represents a customer.
SAB-SHIP-TO Numeric 4 SA100 SA110
Element: Ship-to Code Customer's ship-to number. SA300
SAB-PAYMNT-AMT Signed 18.2 SA100 SA110
Element: Intl Amt Down payment amount booked for this SA300
order.
SAB-ORDER-SOURCE Alpha 2 SA100 SA110
Element: Order Source Order source the order is booked for. SA300
Not required.
SAB-FRT-CODE Alpha 2 SA100 SA110
Element: Add On Cost CoFreight code for this booked order. SA300
SAB-FRT-CHARGE Signed 18.2 SA100 SA110
Element: Intl Amt Freight charges booked for this order. SA300
SAB-CARRIER Alpha 9 (Right Justified) SA100 SA110
Element: Vendor ID Carrier vendor number. Carriers are SA300
set up in the Lawson Accounts Payable
system.
SAB-METHOD Alpha 10 SA100 SA110
Element: Method Code Shipping method. Shipping methods are SA300
set up in WH11 (Shipping Method).
SAB-TRANS-ID Alpha 20 SA100 SA110
Element: Trans Id Transportation ID. User defined. For SA300
example, if the shipping method is
truck, this could be the truck number.
SAB-LIST-NAME Alpha 14 SA100 SA110
Element: List Name Price list this customer is assigned. SA300
SAB-TRANS-USER1 Alpha 10 SA100 SA110
Element: Trans User1 Transaction user field 1. SA300
SAB-TRANS-USER2 Alpha 15 SA100 SA110
Element: Agent Transaction user field 2. SA300
SAB-TRANS-USER3 Numeric 8 (yyyymmdd) SA100 SA110
Element: Trans User3 Transaction user field 3. SA300
SAB-TRANS-USER4 Numeric 9 SA100 SA110
Element: Trans User4 Transaction user field 4. SA300
SAB-TRANS-USER5 Signed 18.2 SA100 SA110
Element: Intl Amt Transaction user field 5. SA300
SAB-USER-DATE-1 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date 1. SA300
SAB-USER-DATE-2 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date 2. SA300
SAB-ORD-DISC-CODE Alpha 4 SA100 SA110
Element: Order DiscountOrder discount code. Determines order SA300
level discount, if any. Order discount
codes are set up in OE59 (Order Discount
Code).
SAB-DISC-AMT Signed 18.2 SA100 SA110
Element: Intl Amt Order level discount in base currency. SA300
SAB-ADDL-DISCOUNT Signed 18.2 SA100 SA110
Element: Intl Amt Additional discount in base currency. SA300
SAB-INV-GOODS Signed 18.2 SA100 SA110
Element: Intl Amt Inventoried goods total in base SA300
currency.
SAB-NON-INV-GOODS Signed 18.2 SA100 SA110
Element: Intl Amt Non-inventoried goods amount in base SA300
currency.
SAB-MISC-TOTAL Signed 18.2 SA100 SA110
Element: Intl Amt Total of add-on charges in base SA300
currency.
SAB-GROSS-AMOUNT Derived
Element: Gross Amount The gross amount of the order in base
currency. This is a derived field and,
as such, does not take up physical
space.
SAB-DISCOUNTS Derived
Element: Discounts The total discounts booked for the
order in base currency. This is a
computed field and, as such, does not
take up physical space.
SAB-NET-AMOUNT Derived
Element: Net Amount The net amount booked for this order in
base currency. This is a computed field
and, as such, does not take up physical
space.
SAB-YEAR Numeric 4 SA100 SA110
Element: Last Closed YeContains the fiscal year for the data SA300
stored on this record.
SAB-PERIOD Numeric 2 SA100 SA110
Element: Last Closed PeContains period when booked or actual SA300
sales occurred.
SAB-EP-TYPE Alpha 5 SA100 SA110
Element: Ep Type SA300
SAB-EP-ACCOUNT Alpha 32 SA100 SA110
Element: Ep Account SA300
SAB-EP-EXP-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Ep Exp Date SA300
SABOOKED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SABSET1 COMPANY SA100 SA101
ORDER-NBR SA110 SA300
SABOOKED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When SAB-CARRIER != Spaces
SAB-COMPANY -> CPY-COMPANY
Arcomp ARCOMP Required
SAB-COMPANY -> ACO-COMPANY
Carrier APVENMAST Required
When SAB-CARRIER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
SAB-CARRIER -> VEN-VENDOR
Cucodes CUCODES Required
SAB-CURRENCY-CODE -> CUC-CURRENCY-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
SAB-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
SAB-COMPANY -> ICC-COMPANY
Oecustcode OECUSTCODE Required
SAB-COMPANY -> OCD-COMPANY
SAB-CUSTOMER-CODE -> OCD-CUSTOMER-CODE
Oefrtcode OEFRTCODE Required
SAB-COMPANY -> OFR-COMPANY
SAB-FRT-CODE -> OFR-FRT-CODE
Oemethod OEMETHOD Required
When SAB-METHOD != Spaces
SAB-COMPANY -> OMT-COMPANY
SAB-METHOD -> OMT-METHOD
Oeproclev OEPROCLEV Required
SAB-COMPANY -> OEP-COMPANY
SAB-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oesource OESOURCE Required
When SAB-ORDER-SOURCE != Spaces
SAB-COMPANY -> OSR-COMPANY
SAB-ORDER-SOURCE -> OSR-ORDER-SOURCE
Ordertype ORDERTYPE Required
SAB-COMPANY -> OTP-COMPANY
SAB-ORDER-TYPE -> OTP-ORDER-TYPE
Sabookaddr SABOOKADDR Not Required
SAB-COMPANY -> SBA-COMPANY
SAB-ORDER-NBR -> SBA-ORDER-NBR
Sacompany SACOMPANY Required
SAB-COMPANY -> SAC-COMPANY
Salesrep SALESREP Required
SAB-COMPANY -> SAW-COMPANY
SAB-SALESMAN -> SAW-SALESMAN
Salesrep 2 SALESREP Required
When SAB-SALESMAN-2 != Zeroes
SAB-COMPANY -> SAW-COMPANY
SAB-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When SAB-SHIP-TO != Zeroes
SAB-COMPANY -> SHP-COMPANY
SAB-CUSTOMER -> SHP-CUSTOMER
SAB-SHIP-TO -> SHP-SHIP-TO
Territory TERITORY Required
SAB-COMPANY -> TRY-COMPANY
SAB-TERRITORY -> TRY-TERRITORY
SABOOKED FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sabookaoc SABOOKAOC
SAB-COMPANY -> SAA-COMPANY
SAB-ORDER-NBR -> SAA-ORDER-NBR
Zeroes -> SAA-LINE-NBR
SAA-SEQ
Sabookline SABOOKLINE
SAB-COMPANY -> SAL-COMPANY
SAB-ORDER-NBR -> SAL-ORDER-NBR
SAL-LINE-NBR
|
