|
|
SAINVCAOC FILE
SA Invoice AOC
The Sales Analysis Invoice Add-On Charge file stores add-on charges for
historic invoices.
UPDATED BY
SA100 SA101 SA110 SA300 SA991
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIA-COMPANY Numeric 4 SA100 SA110
Company The company number represents an SA300
established company and is entered on
all function codes.
SIA-INVC-PREFIX Alpha 2 SA100 SA110
Invoice Prefix Contains the invoice prefix that is SA300
assigned from either the company or
process level, depending on the
invoice-level option chosen.
SIA-INVC-NUMBER Numeric 8 SA100 SA110
Invoice Number Contains the invoice number assigned by SA300
the system. Invoice numbers are
assigned at the company or process
level, depending on an invoice-level
option on the company file.
SIA-LINE-NBR Numeric 6 SA100 SA110
Line Number Contains the line number. SA300
SIA-SEQ Numeric 3 SA100 SA110
Sequence Contains the record sequence number. SA300
SIA-MISC Alpha 16 SA100 SA110
Miscellaneous Contains the add-on charge code. SA300
SIA-YEAR Numeric 4 SA991
Year Contains the fiscal year for the data
stored on this record.
SIA-PERIOD Numeric 2 SA991
Period Contains period when booked or actual
sales occurred.
SIA-SALES-MAJCL Alpha 4 SA100 SA110
Major Sales Class Major sales class used to summarize SA300
actual data.
SIA-SALES-MINCL Alpha 4 SA100 SA110
Minor Sales Class Minor sales class used to summarize SA300
actual data.
SIA-TOTAL-SALE Signed 15.2 SA100 SA110
Total Sale Total sales amount for this add-on SA300
charge.
SIA-TOTAL-COST Signed 15.2 SA100 SA110
Total Cost Total cost amount for this add-on SA300
charge code.
SIA-ACTIVITY Alpha 15 SA100 SA110
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.
SIA-ACCT-CATEGORY Alpha 5 SA100 SA110
Account Category Used 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.
SIA-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.
SIA-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.
SAINVCAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SIASET1 COMPANY SA100 SA101
INVC-PREFIX SA110 SA300
INVC-NUMBER SA991
LINE-NBR
SEQ
SIASET2 COMPANY
YEAR
PERIOD
MISC
INVC-PREFIX
INVC-NUMBER
LINE-NBR
SEQ
SAINVCAOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
SIA-COMPANY -> ICC-COMPANY (ICCSET1)
Majorcl MAJORCL Required
ICC-ITEM-GROUP -> MAJ-ITEM-GROUP
"S" -> MAJ-CLASS-TYPE
SIA-SALES-MAJCL -> MAJ-MAJOR-CLASS
Minorcl MINORCL Required
ICC-ITEM-GROUP -> MIN-ITEM-GROUP
"S" -> MIN-CLASS-TYPE
SIA-SALES-MAJCL -> MIN-MAJOR-CLASS
SIA-SALES-MINCL -> MIN-MINOR-CLASS
Sacompany SACOMPANY Required
SIA-COMPANY -> SAC-COMPANY
Sainvcline SAINVCLINE Required
When SIA-LINE-NBR != Zeroes
SIA-COMPANY -> SIL-COMPANY
SIA-INVC-PREFIX -> SIL-INVC-PREFIX
SIA-INVC-NUMBER -> SIL-INVC-NUMBER
SIA-LINE-NBR -> SIL-LINE-NBR
Sainvoice SAINVOICE Required
SIA-COMPANY -> SAI-COMPANY
SIA-INVC-PREFIX -> SAI-INVC-PREFIX
SIA-INVC-NUMBER -> SAI-INVC-NUMBER
|