|
|
SABOOKLINE FILE
Booked Order Line
The Booked Order Line file stores booking information for individual customer
order lines.
UPDATED BY
SA100 SA101 SA110 SA300 SA960 SA990
SA999
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAL-COMPANY Numeric 4 SA100 SA110
Company The company number represents the SA300 SA960
highest organizational level and is SA999
required on all form action codes.
SAL-ORDER-NBR Numeric 8 SA100 SA110
Order Number Each order is assigned a unique number. SA300 SA960
Order numbers are either manually SA999
assigned or system assigned based on a
company-level option.
SAL-LINE-NBR Numeric 6 SA100 SA110
Line Number This field contains the line number. SA300 SA960
SA999
SAL-PROCESS-LEVEL Alpha 5 SA100 SA110
Process Level This field contains the process level, SA300 SA960
which is the reporting hierarchy below SA999
company.
SAL-TERRITORY Alpha 4 SA100 SA110
Territory Booked line's territory. SA300 SA960
SA999
SAL-SALESMAN Numeric 4 SA100 SA110
Salesman Booked line's primary sales SA300 SA960
representative. SA999
SAL-SALESMAN-2 Numeric 4 SA100 SA110
Salesman 2 Booked line's secondary sales SA300 SA960
representative (if any). SA999
SAL-COMM-RATE-1 Percent 7.5 (Percent) SA100 SA110
Commission Rate 1 Commission rate for sales SA300 SA960
representative 1. SA999
SAL-COMM-RATE-2 Percent 7.5 (Percent) SA100 SA110
Commission Rate 2 Commission rate for the second sales SA300 SA960
representative. SA999
SAL-COMM-SPLIT Percent 5.3 (Percent) SA100 SA110
Commission Split Percentage of this line's net amount SA300 SA960
the second sales representative's SA999
commission is based on.
SAL-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer This field contains the number that SA300 SA960
represents a customer. SA999
SAL-SHIP-TO Numeric 4 SA100 SA110
Ship To Ship-to for this booked order line. SA300 SA960
SA999
SAL-SALES-MAJCL Alpha 4 SA100 SA110
Major Sales Class Major sales class for this booked order SA300 SA960
line. Used for summarization. SA999
SAL-SALES-MINCL Alpha 4 SA100 SA110
Minor Sales Class Minor sales class for this booked order SA300 SA960
line. Used for summarization. SA999
SAL-ITEM Alpha 32 SA100 SA110
Item This field contains the item SA300 SA960
identifier. SA999
SAL-ITEM-DESC Alpha 30 SA100 SA110
Item Description Item description. SA300 SA960
SA999
SAL-BOOKED-DATE Numeric 8 (yyyymmdd) SA100 SA110
Booked Date Date this line is booked for. Used to SA300 SA960
determine the period this line is SA999
summarized into.
SAL-LINE-TYPE Alpha 1 SA100 SA110
Line Type The line type can be entered. Valid SA300 SA960
values are: SA999
I = Inventoried. Default value.
N = Non-stock.
X = Special order.
SAL-INV-LOCATION Alpha 5 SA100 SA110
Inventory Location Ship-from inventory location. SA300 SA960
SA999
SAL-QUANTITY Signed 13.4 SA100 SA110
Quantity This is the booked quantity. SA300 SA960
SA999
SAL-CXL-QTY Signed 13.4 SA100 SA110
Cancel Quantity Quantity canceled for this order line. SA300 SA960
SA999
SAL-CXL-REASON Alpha 4 SA100 SA110
Cancel Reason Reason code used when any amount was SA300 SA960
canceled for this order line. SA999
SAL-SELL-UOM Alpha 4 SA100 SA110
Sell Unit of Measure This field contains the stock unit of SA300 SA960
measure for the item. If entered, it SA999
must be a valid stock unit of measure
for this line's item. If not entered,
the default stock unit of measure for
this line item is assigned.
SAL-SELL-UNIT-PRC Signed 15.7 SA100 SA110
Sell Unit Price Unit price in selling unit of measure. SA300 SA960
SA999
SAL-SPR-UOM Alpha 4 SA100 SA110
Sell Price Unit of Pricing unit of measure. SA300 SA960
Measure SA999
SAL-UNIT-COST Signed 13.5 SA100 SA110
Unit Cost The booked unit cost for this order SA300 SA960
line item. SA999
SAL-SELL-TO-STOCK Signed 13.7 SA100 SA110
Sell to Stock Conversion factor from selling to stock SA300 SA960
unit of measure. SA999
SAL-SPR-TO-STOCK Signed 13.7 SA100 SA110
Sell Price to Stock Conversion factor from pricing to stock SA300 SA960
unit of measure. SA999
SAL-DISC-AMT Signed 15.2 SA100 SA110
Discount Amount Calculated discount amount booked for SA300 SA960
this order line. SA999
SAL-ADDL-DISCOUNT Signed 15.2 SA100 SA110
Additional Discount Additional discount booked for this SA300 SA960
order line. SA999
SAL-CARRIER Alpha 9 SA100 SA110
Carrier Carrier vendor number. SA300 SA960
SA999
SAL-DROPSHIP-FL Alpha 1 SA100 SA110
Dropship Flag Flag to indicate whether this line is SA300 SA960
to be shipped directly from the vendor SA999
to the customer.
SAL-PO-NUMBER Alpha 7 (Right Justified) SA100 SA110
Purchase Order If this item is to be purchased via a SA300 SA960
Number purchase order number, this is the SA999
number of that purchase order.
SAL-VENDOR Alpha 9 SA100 SA110
Vendor The vendor for the purchase order used SA300 SA960
to purchase this item. SA999
SAL-ROUTE Numeric 4 SA100 SA110
Route Route this line is to be delivered via. SA300 SA960
SA999
SAL-STOP Numeric 4 SA100 SA110
Stop The lines stop within the delivery SA300 SA960
route. SA999
SAL-EXP-SHIP-DT Numeric 8 (yyyymmdd) SA100 SA110
Expected Ship Date Expected ship date this line was booked SA300 SA960
for. SA999
SAL-RQST-DATE Numeric 8 (yyyymmdd) SA100 SA110
Request Date Customer's requested delivery date. SA300 SA960
SA999
SAL-CONTRACT-NBR Alpha 14 SA100 SA110
Contract Number If this line was priced via a customer SA300 SA960
contract, this is the contract number. SA999
SAL-PROMOTION Alpha 10 SA100 SA110
Promotion If this line was priced via a SA300 SA960
promotion, this is the promotion number. SA999
SAL-ACTIVITY Alpha 15 SA100 SA110
Activity Used for Revenue (Sales) postings SA300 SA960
whereas the Activity-C field is used for
Cost (COGS) postings.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
SAL-ACCT-CATEGORY Alpha 5 SA100 SA110
Account Category Used for Revenue (Sales) postings SA300 SA960
whereas the Acct-Categ-C field is used
for Cost (COGS) postings.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
SAL-USER-FLD1 Alpha 2 SA100 SA110
User Field 1 User field 1. SA300 SA960
SA999
SAL-USER-FLD2 Alpha 30 (Lower Case) SA100 SA110
User Field 2 User field 2. SA300 SA960
SA999
SAL-USER-FLD3 Alpha 15 (Lower Case) SA100 SA110
user Field 3 User field 3. SA300 SA960
SA999
SAL-USER-DATE-3 Numeric 8 (yyyymmdd) SA100 SA110
User Date 3 User date field 3. SA300 SA960
SA999
SAL-USER-DATE-4 Numeric 8 (yyyymmdd) SA100 SA110
User Date 4 User date field 4. SA300 SA960
SA999
SAL-YEAR Numeric 4 SA100 SA110
Year Contains the fiscal year for the data SA300 SA990
stored on this record.
SAL-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300 SA990
sales occurred.
SAL-ACTIVITY-C Alpha 15 SA100 SA110
Activity C Used for Cost (COGS) postings whereas SA300
the Activity field is used for Revenue
(Sales) postings.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
SAL-ACCT-CATEG-C Alpha 5 SA100 SA110
Account Category C Used for Cost (COGS) postings whereas SA300
the Acct-Category field is used for
Revenue (Sales) postings.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Lawson Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
SAL-BOOK-GROSS Derived
Book Gross Gross amount booked for this line.
SAL-BOOK-COST Derived
Book Cost Cost booked for this order line.
SAL-BOOK-NET Derived
Book Net Net amount booked for this order line.
SAL-BOOK-SALES Derived
Book Sales Sales amount booked for this line.
Either gross or net sales amount,
depending on option on the Sales
Analysis company record.
SAL-BOOK-PROFIT Derived
Book Profit Profit dollar amount for this line.
SAL-BOOK-MARKUP Derived
Book Markup Markup percentage for this line.
SAL-BOOK-MARGIN Derived
Book Margin Profit margin for this line.
SABOOKLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SALSET1 COMPANY SA100 SA101
ORDER-NBR SA110 SA300
LINE-NBR SA960 SA990
SA999
SALSET2 COMPANY Duplicates
YEAR
PERIOD
SALES-MAJCL
SALES-MINCL
ITEM
SABOOKLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
When SAL-CARRIER != Spaces
SAL-COMPANY -> CPY-COMPANY
Arcomp ARCOMP Required
SAL-COMPANY -> ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
SAL-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
SAL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
When SAL-LINE-TYPE = "I"
SAL-COMPANY -> ICL-COMPANY
SAL-INV-LOCATION -> ICL-LOCATION
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
SAL-ITEM -> ITE-ITEM
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
SAL-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
SAL-SALES-MAJCL -> MIN-MAJOR-CLASS
SAL-SALES-MINCL -> MIN-MINOR-CLASS
Sabooked SABOOKED Required
SAL-COMPANY -> SAB-COMPANY
SAL-ORDER-NBR -> SAB-ORDER-NBR
Sacompany SACOMPANY Required
SAL-COMPANY -> SAC-COMPANY
Salesrep SALESREP Required
SAL-COMPANY -> SAW-COMPANY
SAL-SALESMAN -> SAW-SALESMAN
Salesrep 2 SALESREP Required
When SAL-SALESMAN-2 != Zeroes
SAL-COMPANY -> SAW-COMPANY
SAL-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Required
When SAL-SHIP-TO != Zeroes
SAL-COMPANY -> SHP-COMPANY
SAL-CUSTOMER -> SHP-CUSTOMER
SAL-SHIP-TO -> SHP-SHIP-TO
Territory TERITORY Required
SAL-COMPANY -> TRY-COMPANY
SAL-TERRITORY -> TRY-TERRITORY
SABOOKLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sabookaoc SABOOKAOC
SAL-COMPANY -> SAA-COMPANY
SAL-ORDER-NBR -> SAA-ORDER-NBR
SAL-LINE-NBR -> SAA-LINE-NBR
SAA-SEQ
|