|
|
SAINVCLINE FILE
SA Invoice Line
The Sales Analysis Invoice Line file stores historic information for invoice
lines.
REFERENCED BY
SA252 SA253 SA254 SA255 SA256 SAA3.1
SA250 SA258 SA251
UPDATED BY
SA100 SA101 SA110 SA300 SA961 SA991
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIL-COMPANY Numeric 4 SA100 SA110
Company The company number represents an SA300 SA961
established company and is entered on
all function codes.
SIL-INVC-PREFIX Alpha 2 SA100 SA110
Invoice Prefix Contains the invoice prefix that is SA300 SA961
assigned from either the company or
process level, depending on the
invoice-level option chosen.
SIL-INVC-NUMBER Numeric 8 SA100 SA110
Invoice Number Contains the invoice number assigned by SA300 SA961
the system. Invoice numbers are
assigned at the company or process
level, depending on an invoice-level
option on the company file.
SIL-LINE-NBR Numeric 6 SA100 SA110
Line Number Contains the line number. SA300 SA961
SIL-PROCESS-LEVEL Alpha 5 SA100 SA110
Process Level This field contains the process level, SA300 SA961
which is the reporting hierarchy below
company.
SIL-TERRITORY Alpha 4 SA100 SA110
Territory Territory this sale was for. SA300 SA961
SIL-SALESMAN Numeric 4 SA100 SA110
Salesman Primary sales representative for this SA300 SA961
invoice line.
SIL-SALESMAN-2 Numeric 4 SA100 SA110
Salesman 2 Secondary sales representative (if any) SA300 SA961
for this invoice line.
SIL-COMM-RATE-1 Percent 7.5 (Percent) SA100 SA110
Commission Rate 1 Commission rate for sales SA300 SA961
representative 1.
SIL-COMM-RATE-2 Percent 7.5 (Percent) SA100 SA110
Commission Rate 2 Commission rate for the second sales SA300 SA961
representative.
SIL-COMM-SPLIT Percent 5.3 (Percent) SA100 SA110
Commission Split Commission split for the second sales SA300 SA961
representative.
SIL-CUSTOMER Alpha 9 (Right Justified) SA100 SA110
Customer Contains the number that represents a SA300 SA961
customer.
SIL-SHIP-TO Numeric 4 SA100 SA110
Ship To Customer's ship-to number for this SA300 SA961
invoice line.
SIL-REASON-CODE Alpha 4 SA100 SA110
Reason Code This field contains the reason code, SA300 SA961
which indicates the cause for credit
memos.
SIL-SHIP-DATE Numeric 8 (yyyymmdd) SA100 SA110
Ship Date Actual date that inventory was shipped SA300 SA961
on.
SIL-SALES-MAJCL Alpha 4 SA100 SA110
Major Sales Class Major sales class for this invoice line. SA300 SA961
SIL-SALES-MINCL Alpha 4 SA100 SA110
Minor Sales Class Minor sales class for this invoice line. SA300 SA961
SIL-ITEM Alpha 32 SA100 SA110
Item Contains the item identifier. SA300 SA961
SIL-ITEM-DESC Alpha 30 SA100 SA110
Item Description Contains the item description. SA300 SA961
SIL-LINE-TYPE Alpha 1 SA100 SA110
Line Type Line type. Indicates whether this is a SA300 SA961
stock, non-stock, or special order line.
SIL-INV-LOCATION Alpha 5 SA100 SA110
Inventory Location Ship-from inventory location. SA300 SA961
SIL-QUANTITY Signed 13.4 SA100 SA110
Quantity Quantity sold. SA300 SA961
SIL-QTY-TRACK-FL Alpha 1 SA100 SA110
Quantity Track Flag Flag to indicate whether the quantity SA300 SA961
for this line is to be summarized. Only
invoices that are system generated will
have their quantity summarized.
S = System generated invoice
SIL-SELL-UOM Alpha 4 SA100 SA110
Sell Unit of Measure Selling unit of measure. SA300 SA961
SIL-SELL-UNIT-PRC Signed 15.7 SA100 SA110
Sell Unit Price Unit price in selling unit of measure. SA300 SA961
SIL-SPR-UOM Alpha 4 SA100 SA110
Sell Price Unit of Pricing unit of measure. SA300 SA961
Measure
SIL-SELL-TO-STOCK Signed 13.7 SA100 SA110
Sell to Stock Conversion factor from selling to stock SA300 SA961
unit of measure.
SIL-SPR-TO-STOCK Signed 13.7 SA100 SA110
Sell Price to Stock Conversion factor from pricing to stock SA300 SA961
unit of measure.
SIL-UNIT-COST Signed 13.5 SA100 SA110
Unit Cost Unit cost for this invoice line. SA300 SA961
SIL-CATCH-WT-QTY Signed 13.4 SA100 SA110
Catch Weight Contains the quantity shipped for SA300 SA961
Quantity catch weight items.
SIL-DISC-AMT Signed 15.2 SA100 SA110
Discount Amount Calculated discount amount for this SA300 SA961
invoice line.
SIL-ADDL-DISCOUNT Signed 15.2 SA100 SA110
Additional Discount Additional discount amount entered for SA300 SA961
this invoice line.
SIL-CONTRACT-NBR Alpha 14 SA100 SA110
Contract Number If this invoice line was priced via a SA300 SA961
contract, this is the contract number.
SIL-PROMOTION Alpha 10 SA100 SA110
Promotion If this invoice line was priced via a SA300 SA961
promotion, this is the promotion number.
SIL-ACTIVITY Alpha 15 SA100 SA110
Activity Used for Revenue (Sales) postings SA300 SA961
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.
SIL-ACCT-CATEGORY Alpha 5 SA100 SA110
Account Category Used for Revenue (Sales) postings SA300 SA961
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.
SIL-FINAL-INVC-FL Alpha 1 SA100 SA110
Final Invoice Flag Flag to indicate that this is the last SA300 SA961
invoice for the order. Only valid for
system-generated invoices.
Y = Yes
N = No
SIL-USER-FLD1 Alpha 2 SA100 SA110
User Field 1 User field 1. SA300 SA961
SIL-USER-FLD2 Alpha 30 (Lower Case) SA100 SA110
User Field 2 User field 2. SA300 SA961
SIL-USER-FLD3 Alpha 15 (Lower Case) SA100 SA110
User Field 3 User field 3. SA300 SA961
SIL-USER-DATE-3 Numeric 8 (yyyymmdd) SA100 SA110
User Date 3 User date 3. SA300 SA961
SIL-USER-DATE-4 Numeric 8 (yyyymmdd) SA100 SA110
User Date 4 User date 4. SA300 SA961
SIL-YEAR Numeric 4 SA100 SA110
Year Contains the fiscal year for the data SA300 SA961
stored on this record. SA991
SIL-PERIOD Numeric 2 SA100 SA110
Period Contains period when booked or actual SA300 SA961
sales occurred. SA991
SIL-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.
SIL-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.
SIL-LINE-GROSS Derived
Line Gross Gross sales amount for this invoice
line.
SIL-LINE-NET Derived
Line Net Net sales amount for this invoice line.
SIL-LINE-COST Derived
Line Cost Cost amount for this invoice line.
SIL-LINE-PROFIT Derived
Line Profit Profit dollar amount for this invoice
line.
SIL-LINE-SALES Derived
Line Sales Sales amount for this invoice line.
Either gross sales amount or net sales
amount, depending on the Sales Analysis
company option.
SIL-LINE-MARKUP Derived
Line Markup Markup percentage for this invoice line.
SIL-LINE-MARGIN Derived
Line Margin Profit margin for this invoice line.
SAINVCLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SILSET1 COMPANY SA100 SA101
INVC-PREFIX SA110 SA252
INVC-NUMBER SA253 SA254
LINE-NBR SA255 SA256
SA300 SA961
SA991 SAA3.1
SILSET2 COMPANY Duplicates SA250 SA258
TERRITORY
YEAR
PERIOD
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SILSET3 COMPANY SA251
SALES-MAJCL
SALES-MINCL
ITEM
YEAR
PERIOD
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SAINVCLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
SIL-COMPANY -> ACO-COMPANY
Arcustomer ARCUSTOMER Required
SIL-COMPANY -> ACM-COMPANY
SIL-CUSTOMER -> ACM-CUSTOMER
Contract OEPRCLIST Not Required
SIL-COMPANY -> OPL-COMPANY
SIL-CUSTOMER -> OPL-CUSTOMER
SIL-CONTRACT-NBR -> OPL-LIST-NAME
Spaces -> OPL-PROMOTION
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
SIL-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Required
SIL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Not Required
Valid When SIL-LINE-TYPE = "S"
SIL-COMPANY -> ICL-COMPANY
SIL-INV-LOCATION -> ICL-LOCATION
Itemmast ITEMMAST Required
When SIL-LINE-TYPE = "S"
Or SIL-LINE-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
SIL-ITEM -> ITE-ITEM
Majorcl MAJORCL Not Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
SIL-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Not Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
SIL-SALES-MAJCL -> MIN-MAJOR-CLASS
SIL-SALES-MINCL -> MIN-MINOR-CLASS
Oecustcode OECUSTCODE Required
SIL-COMPANY -> OCD-COMPANY
SAI-CUSTOMER-CODE -> OCD-CUSTOMER-CODE
Oeproclev OEPROCLEV Required
SIL-COMPANY -> OEP-COMPANY
SIL-PROCESS-LEVEL -> OEP-PROCESS-LEVEL
Oereason OEREASON Required
When SIL-REASON-CODE != Spaces
SIL-COMPANY -> OER-COMPANY
SIL-REASON-CODE -> OER-REASON-CODE
Sacompany SACOMPANY Required
SIL-COMPANY -> SAC-COMPANY
Sainvoice SAINVOICE Required
SIL-COMPANY -> SAI-COMPANY
SIL-INVC-PREFIX -> SAI-INVC-PREFIX
SIL-INVC-NUMBER -> SAI-INVC-NUMBER
Salesrep SALESREP Required
SIL-COMPANY -> SAW-COMPANY
SIL-SALESMAN -> SAW-SALESMAN
Salesrep2 SALESREP Required
When SIL-SALESMAN-2 != Zeroes
SIL-COMPANY -> SAW-COMPANY
SIL-SALESMAN-2 -> SAW-SALESMAN
Shipto SHIPTO Not Required
SIL-COMPANY -> SHP-COMPANY
SIL-CUSTOMER -> SHP-CUSTOMER
SIL-SHIP-TO -> SHP-SHIP-TO
Teritory TERITORY Not Required
SIL-COMPANY -> TRY-COMPANY
SIL-TERRITORY -> TRY-TERRITORY
SAINVCLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sainvcaoc SAINVCAOC
SIL-COMPANY -> SIA-COMPANY
SIL-INVC-PREFIX -> SIA-INVC-PREFIX
SIL-INVC-NUMBER -> SIA-INVC-NUMBER
SIL-LINE-NBR -> SIA-LINE-NBR
SIA-SEQ
|