|
|
SAINVCAOC FILE
SA Invoice AOC
The Sales Analysis Invoice Add-On Charge file stores add-on charges for
historic invoices.
REFERENCED BY
SA251 SA252
UPDATED BY
SA100 SA101 SA110 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIA-COMPANY Numeric 4 SA100 SA110
Element: Company Identifies the AP company if the SA300
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
SIA-INVC-PREFIX Alpha 2 SA100 SA110
Element: Invoice PrefixContains 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
Element: Invc 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
Element: Line Number Contains the line number. SA300
SIA-SEQ Numeric 3 SA100 SA110
Element: Sequence NumbeContains the record sequence number. SA300
SIA-MISC Alpha 16 SA100 SA110
Element: Misc Contains the add-on charge code. SA300
SIA-YEAR Numeric 4 SA100 SA110
Element: Last Closed YeContains the fiscal year for the data SA300
stored on this record.
SIA-PERIOD Numeric 2 SA100 SA110
Element: Last Closed PeContains period when booked or actual SA300
sales occurred.
SIA-SALES-MAJCL Alpha 4 SA100 SA110
Element: Major Class Major sales class used to summarize SA300
actual data.
SIA-SALES-MINCL Alpha 4 SA100 SA110
Element: Minor Class Minor sales class used to summarize SA300
actual data.
SIA-TOTAL-SALE Signed 18.2 SA100 SA110
Element: Intl Amt Total sales amount for this add-on SA300
charge.
SIA-TOTAL-COST Signed 18.2 SA100 SA110
Element: Intl Amt Total cost amount for this add-on SA300
charge code.
SIA-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.
SIA-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.
SIA-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.
SIA-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.
SAINVCAOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SIASET1 COMPANY SA100 SA101
INVC-PREFIX SA110 SA251
INVC-NUMBER SA252 SA300
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
|
