|
|
SAINVCCOMP FILE
SA Invoice Component
The Sales Analysis Invoice Component file stores kit component information
for historic invoice lines.
REFERENCED BY
SA250 SA251 SA252 SA253 SA254 SA255
UPDATED BY
SA100 SA101 SA300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIC-COMPANY Numeric 4 SA100 SA300
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
SIC-INVC-PREFIX Alpha 2 SA100 SA300
Element: Invoice PrefixContains the invoice prefix that is
assigned from either the company or
process level, depending on the
invoice-level option chosen.
SIC-INVC-NUMBER Numeric 8 SA100 SA300
Element: Invc Number Contains the invoice number assigned by
the system. Invoice numbers are
assigned at the company or process
level, depending on an invoice-level
option on the company file.
SIC-LINE-NBR Numeric 6 SA100 SA300
Element: Line Number Contains the line number.
SIC-COMPONENT-SEQ Numeric 3 SA100 SA300
Element: Sequence NumbeContains the component sequence number.
SIC-ITEM Alpha 32 SA100 SA300
Element: Item Number Contains the item identifier.
SIC-QUANTITY Signed 13.4 SA100 SA300
Element: Quantity Quantity sold for this kit component
for this invoice line.
SIC-UNIT-COST Signed 18.2 SA100 SA300
Element: Intl Amt Unit cost for this kit component for
this invoice.
SAINVCCOMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SICSET1 COMPANY SA100 SA101
INVC-PREFIX SA250 SA251
INVC-NUMBER SA252 SA253
LINE-NBR SA254 SA255
COMPONENT-SEQ SA300
SAINVCCOMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sainvcline SAINVCLINE Required
SIC-COMPANY -> SIL-COMPANY
SIC-INVC-PREFIX -> SIL-INVC-PREFIX
SIC-INVC-NUMBER -> SIL-INVC-NUMBER
SIC-LINE-NBR -> SIL-LINE-NBR
|
