|
|
SABOOKED FILE
Booked Order
The Booked Order file stores booking information applicable to an entire
order.
UPDATED BY
SA100 SA101 SA110 SA300 SA990
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAB-COMPANY Numeric 4 SA100 SA110
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
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
Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SAB-LOCATION Alpha 5 SA100 SA110
Location This field contains a valid stocking SA300
location within the company inventory.
SAB-SALESMAN Numeric 4 SA100 SA110
Salesman The primary sales representative for SA300
this order.
SAB-SALESMAN-2 Numeric 4 SA100 SA110
Salesman 2 The secondary sales representative (if SA300
any) for this order.
SAB-COMM-RATE-1 Percent 7.5 (Percent)
Commission Rate 1 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)
Commission Rate 2 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
split. This defaults from the customer
file.
SAB-TERRITORY Alpha 4 SA100 SA110
Territory The territory this order has been SA300
booked under.
SAB-ORDER-TYPE Alpha 2 SA100 SA110
Order Type The order type for this booked order. SA300
SAB-ORDER-DATE Numeric 8 (yyyymmdd) SA100 SA110
Order Date The date this booked order was entered SA300
into the system.
SAB-OPR-CODE Alpha 10 (Lower Case) SA100 SA110
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 20 SA100 SA110
Customer Purchase Customer purchase order number for this SA300
Order Number booked order.
SAB-LETTER-OF-CR Alpha 20 SA100 SA110
Letter of Credit This field contains the letter of SA300
credit.
SAB-CURRENCY-CODE Alpha 5 SA100 SA110
Currency Code The currency this order was billed in. SA300
SAB-CURR-RATE Signed 13.6
Currency Rate The currency exchange rate in effect
when the order was booked.
SAB-CUSTOMER-CODE Alpha 4 SA100 SA110
Customer Code The customer code for the bill-to SA300
customer for this booked order.
SAB-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer This field contains the number that SA300
represents a customer.
SAB-SHIP-TO Numeric 4 SA100 SA110
Ship To Customer's ship-to number. SA300
SAB-CC-TYPE Alpha 2 SA100 SA110
Credit Card Type Credit card type. Only present if the SA300
order is to be paid via credit card.
SAB-CC-NUMBER Alpha 17 SA100 SA110
Credit Card Number Credit card number. Only valid if the SA300
order is to be paid via credit card.
SAB-CC-EXP-DATE Numeric 6 SA100 SA110
Credit Card Credit card expiration date. SA300
Expiration Date
SAB-PAYMNT-AMT Signed 15.2 SA100 SA110
Payment Amount Down payment amount booked for this SA300
order.
SAB-ORDER-SOURCE Alpha 2 SA100 SA110
Order Source Order source the order is booked for. SA300
Not required.
SAB-FRT-CODE Alpha 2 SA100 SA110
Freight Code Freight code for this booked order. SA300
SAB-FRT-CHARGE Signed 15.2 SA100 SA110
Freight Charge Freight charges booked for this order. SA300
SAB-CARRIER Alpha 9 SA100 SA110
Carrier Carrier vendor number. Carriers are SA300
set up in the Lawson Accounts Payable
system.
SAB-METHOD Alpha 10 SA100 SA110
Method Shipping method. Shipping methods are SA300
set up in WH11 (Shipping Method).
SAB-TRANS-ID Alpha 10 SA100 SA110
Transportation 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
List Name Price list this customer is assigned. SA300
SAB-TRANS-USER1 Alpha 10 SA100 SA110
Transaction User 1 Transaction user field 1. SA300
SAB-TRANS-USER2 Alpha 15 SA100 SA110
Transaction User 2 Transaction user field 2. SA300
SAB-TRANS-USER3 Numeric 8 (yyyymmdd) SA100 SA110
Transaction User 3 Transaction user field 3. SA300
SAB-TRANS-USER4 Numeric 9 SA100 SA110
Transactoin User 4 Transaction user field 4. SA300
SAB-TRANS-USER5 Signed 13.2 SA100 SA110
Transaction User 5 Transaction user field 5. SA300
SAB-USER-DATE-1 Numeric 8 (yyyymmdd) SA100 SA110
User Date 1 User date 1. SA300
SAB-USER-DATE-2 Numeric 8 (yyyymmdd) SA100 SA110
User Date 2 User date 2. SA300
SAB-ORD-DISC-CODE Alpha 4 SA100 SA110
Order Discount Code Order discount code. Determines order SA300
level discount, if any. Order discount
codes are set up in OE59 (Order Discount
Code).
SAB-DISC-AMT Signed 15.2 SA100 SA110
Discount Amount Order level discount in base currency. SA300
SAB-ADDL-DISCOUNT Signed 15.2 SA100 SA110
Additional Discount Additional discount in base currency. SA300
SAB-INV-GOODS Signed 15.2 SA100 SA110
Inventory Goods Inventoried goods total in base SA300
currency.
SAB-NON-INV-GOODS Signed 15.2 SA100 SA110
Non-inventory Goods Non-inventoried goods amount in base SA300
currency.
SAB-MISC-TOTAL Signed 15.2 SA100 SA110
Miscellaneous Total Total of add-on charges in base SA300
currency.
SAB-GROSS-AMOUNT Derived
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
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
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
Year Contains the fiscal year for the data SA300 SA990
stored on this record.
SAB-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300 SA990
sales occurred.
SABOOKED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SABSET1 COMPANY SA100 SA101
ORDER-NBR SA110 SA300
SA990
SABSET2 COMPANY Duplicates
YEAR
PERIOD
CUSTOMER
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
Oecredcard OECREDCARD Required
When SAB-CC-TYPE != Spaces
SAB-COMPANY -> OCR-COMPANY
SAB-CC-TYPE -> OCR-CC-TYPE
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
|