|
|
SABOOKLINE FILE
Booked Order Line
The Booked Order Line file stores booking information for individual customer
order lines.
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SAL-COMPANY Numeric 4 SA100 SA110
Element: Company The company number represents the SA300
highest organizational level and is
required on all form action codes.
SAL-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.
SAL-LINE-NBR Numeric 6 SA100 SA110
Element: Line Number This field contains the line number. SA300
SAL-PROCESS-LEVEL Alpha 5 SA100 SA110
Element: Process Level This field contains the process level, SA300
which is the reporting hierarchy below
company.
SAL-TERRITORY Alpha 4 SA100 SA110
Element: Sales TerritorBooked line's territory. SA300
SAL-SALESMAN Numeric 4 SA100 SA110
Element: Salesman NumbeBooked line's primary sales SA300
representative.
SAL-SALESMAN-2 Numeric 4 SA100 SA110
Element: Salesman NumbeBooked line's secondary sales SA300
representative (if any).
SAL-COMM-RATE-1 Percent 7.5 (Percent) SA100 SA110
Element: Chrg Rate Commission rate for sales SA300
representative 1.
SAL-COMM-RATE-2 Percent 7.5 (Percent) SA100 SA110
Element: Chrg Rate Commission rate for the second sales SA300
representative.
SAL-COMM-SPLIT Percent 5.3 (Percent) SA100 SA110
Commission Split Percentage of this line's net amount SA300
Percentage the second sales representative's
commission is based on.
SAL-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Element: Customer NumbeThis field contains the number that SA300
represents a customer.
SAL-SHIP-TO Numeric 4 SA100 SA110
Element: Ship-to Code Ship-to for this booked order line. SA300
SAL-SALES-MAJCL Alpha 4 SA100 SA110
Element: Major Class Major sales class for this booked order SA300
line. Used for summarization.
SAL-SALES-MINCL Alpha 4 SA100 SA110
Element: Minor Class Minor sales class for this booked order SA300
line. Used for summarization.
SAL-ITEM Alpha 32 SA100 SA110
Element: Item Number This field contains the item SA300
identifier.
SAL-ITEM-DESC Alpha 30 SA100 SA110
Element: Item DescriptiItem description. SA300
SAL-BOOKED-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Date Date this line is booked for. Used to SA300
determine the period this line is
summarized into.
SAL-LINE-TYPE Alpha 1 SA100 SA110
Element: Line Type The line type can be entered. Valid SA300
values are:
I = Inventoried. Default value.
N = Non-stock.
X = Special order.
SAL-INV-LOCATION Alpha 5 SA100 SA110
Element: Location Code Ship-from inventory location. SA300
SAL-QUANTITY Signed 13.4 SA100 SA110
Element: Quantity This is the booked quantity. SA300
SAL-CXL-QTY Signed 13.4 SA100 SA110
Element: Receiving QuanQuantity canceled for this order line. SA300
SAL-CXL-REASON Alpha 4 SA100 SA110
Element: Cb Reason Reason code used when any amount was SA300
canceled for this order line.
SAL-SELL-UOM Alpha 4 SA100 SA110
Element: Unit of MeasurThis field contains the stock unit of SA300
measure for the item. If entered, it
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 18.5 SA100 SA110
Element: Sell Unit Prc Unit price in selling unit of measure. SA300
SAL-SPR-UOM Alpha 4 SA100 SA110
Element: Unit of MeasurPricing unit of measure. SA300
SAL-UNIT-COST Signed 18.2 SA100 SA110
Element: Intl Amt The booked unit cost for this order SA300
line item.
SAL-SELL-TO-STOCK Signed 13.7 SA100 SA110
Element: Sell To Stock Conversion factor from selling to stock SA300
unit of measure.
SAL-SPR-TO-STOCK Signed 13.7 SA100 SA110
Element: Sell To Stock Conversion factor from pricing to stock SA300
unit of measure.
SAL-DISC-AMT Signed 18.2 SA100 SA110
Element: Intl Amt Calculated discount amount booked for SA300
this order line.
SAL-ADDL-DISCOUNT Signed 18.2 SA100 SA110
Element: Intl Amt Additional discount booked for this SA300
order line.
SAL-CARRIER Alpha 9 (Right Justified) SA100 SA110
Element: Vendor ID Carrier vendor number. SA300
SAL-DROPSHIP-FL Alpha 1 SA100 SA110
Element: Dropship Flag Flag to indicate whether this line is SA300
to be shipped directly from the vendor
to the customer.
SAL-PO-NUMBER Alpha 14 (Right Justified) SA100 SA110
Element: PO Number If this item is to be purchased via a SA300
purchase order number, this is the
number of that purchase order.
SAL-PO-CODE Alpha 4 SA100 SA110
Element: Po Code This is the purchase order code. SA300
SAL-VENDOR Alpha 9 (Right Justified) SA100 SA110
Element: Vendor ID The vendor for the purchase order used SA300
to purchase this item.
SAL-PURCH-FR-LOC Alpha 4
Purchase From The vendor's purchase from location.
Location Code
SAL-ROUTE Numeric 4 SA100 SA110
Element: Route Route this line is to be delivered via. SA300
SAL-STOP Numeric 4 SA100 SA110
Element: Stop The lines stop within the delivery SA300
route.
SAL-EXP-SHIP-DT Numeric 8 (yyyymmdd) SA100 SA110
Element: Date Expected ship date this line was booked SA300
for.
SAL-RQST-DATE Numeric 8 (yyyymmdd) SA100 SA110
Element: Date Customer's requested delivery date. SA300
SAL-CONTRACT-NBR Alpha 14 SA100 SA110
Element: Contract NumbeIf this line was priced via a customer SA300
contract, this is the contract number.
SAL-PROMOTION Alpha 10 SA100 SA110
Element: Promotion If this line was priced via a SA300
promotion, this is the promotion number.
SAL-ACTIVITY Alpha 15 SA100 SA110
Element: Activity Used for Revenue (Sales) postings SA300
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
Element: Account CategoUsed for Revenue (Sales) postings SA300
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-ACTIVITY-C Alpha 15 SA100 SA110
Element: Activity 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
Element: Account CategoUsed 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-USER-FLD1 Alpha 2 SA100 SA110
Purchase Order User User field 1. SA300
Field 2
SAL-USER-FLD2 Alpha 30 (Lower Case) SA100 SA110
Element: User Defined FUser field 2. SA300
SAL-USER-FLD3 Alpha 15 (Lower Case) SA100 SA110
Element: User Defined FUser field 3. SA300
SAL-USER-DATE-3 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date field 3. SA300
SAL-USER-DATE-4 Numeric 8 (yyyymmdd) SA100 SA110
Element: Date User date field 4. SA300
SAL-YEAR Numeric 4 SA100 SA110
Element: Last Closed YeContains the fiscal year for the data SA300
stored on this record.
SAL-PERIOD Numeric 2 SA100 SA110
Element: Last Closed PeContains period when booked or actual SA300
sales occurred.
SAL-BOOK-GROSS Derived
Element: Book Gross Gross amount booked for this line.
SAL-BOOK-COST Derived
Element: Book Cost Cost booked for this order line.
SAL-BOOK-NET Derived
Element: Book Net Net amount booked for this order line.
SAL-BOOK-SALES Derived
Element: 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
Element: Book Profit Profit dollar amount for this line.
SAL-BOOK-MARKUP Derived
Element: Book Markup Markup percentage for this line.
SAL-BOOK-MARGIN Derived
Element: Book Margin Profit margin for this line.
SAL-INTR-COMP Alpha 1 SA100 SA110
Element: Intr Comp This field indicates whether the order SA300
line is an inter-company order line. If
the value is N this is not an
inter-company order line. If the value
is O this is an inter-company order line
on a customer order. If the value is S
this is an inter-company order from
another company.
SABOOKLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SALSET1 COMPANY SA100 SA101
ORDER-NBR SA110 SA300
LINE-NBR
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
|
