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
Company              The company number represents an
                     established company and is entered on
                     all function codes.

SIC-INVC-PREFIX      Alpha 2                                     SA100   SA300
Invoice Prefix       Contains 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
Invoice 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
Line Number          Contains the line number.

SIC-COMPONENT-SEQ    Numeric 3                                   SA100   SA300
Component Sequence   Contains the component sequence number.

SIC-ITEM             Alpha 32                                    SA100   SA300
Item                 Contains the item identifier.

SIC-QUANTITY         Signed 13.4                                 SA100   SA300
Quantity             Quantity sold for this kit component
                     for this invoice line.

SIC-UNIT-COST        Signed 13.5                                 SA100   SA300
Unit Cost            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