ICCTRNLIN FILE

UPDATED BY

IC500     IC54.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITN-COMPANY          Numeric 4                                   IC54.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ITN-LOCATION         Alpha 5                                     IC54.2
Location Code        This field contains a valid stocking
                     location within the company inventory.

ITN-RECRD-TYPE       Numeric 2                                   IC54.2
Recrd Type

ITN-DOC-TYPE         Alpha 2                                     IC54.2
Document Type        This field contains the type of
                     transaction.

ITN-DOCUMENT         Alpha 10  (Right Justified)                 IC54.2
Document ID          This field identifies the document from
                     which this transaction record was
                     created.

ITN-LINE-NBR         Numeric 6                                   IC54.2
Line Number          This field contains the line number.

ITN-SEQ              Numeric 3                                   IC54.2
Sequence Number      This field contains the record sequence
                     number.

ITN-ITEM             Alpha 32                                    IC54.2
Item Number          This field contains the item
                     identifier.

ITN-QUANTITY         Signed 13.4                                 IC54.2
Quantity             This field contains the requested
                     quantity.

ITN-UNIT-COST        Signed 13.5                                 IC54.2
Unit Cost            This field contains the unit cost.

ITN-AOC-UCOST        Signed 13.5                                 IC54.2
Aoc Ucost

ITN-TRAN-UOM         Alpha 4                                     IC54.2
Transaction Unit of
Measure

ITN-REFERENCE        Alpha 10  (Lower Case)                      IC54.2
Reference            The reference number associated with
                     the transaction.

ITN-BIN              Alpha 7                                     IC54.2
Bin                  This field contains a storage area for
                     an item or any number of items.

ITN-REASON-CODE      Alpha 4                                     IC54.2
Reason Code          This field contains the reason code,
                     which indicates the cause for credit
                     memos.

ITN-ACTIVITY         Alpha 15                                    IC54.2
Activity             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 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 kinds 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.

ITN-ACCT-CAT         Alpha 5                                     IC54.2
Acct Cat

ITN-LINE-COMM        Alpha 30                                    IC54.2
Line Comm

ITN-OFFSET-ACCTUNI   Alpha 15                                    IC54.2
Offset Acctuni

ITN-OFFSET-ACCT      Numeric 6                                   IC54.2
Offset Acct

ITN-OFFSET-SUBACCT   Numeric 4                                   IC54.2
Offset Subacct

ITN-AOC-ACCTUNIT     Alpha 15                                    IC54.2
Aoc Acctunit

ITN-AOC-ACCT         Numeric 6                                   IC54.2
Aoc Acct

ITN-AOC-SUBACCT      Numeric 4                                   IC54.2
Aoc Subacct

ITN-FR-TO-BIN        Alpha 7                                     IC54.2
Fr To Bin

ITN-LST-ISS-FL       Alpha 1                                     IC54.2
Lst Iss Fl

ITN-SEC-QTY          Signed 13.4                                 IC54.2
Sec Qty

ITN-ORIG-QTY         Signed 13.4                                 IC54.2
Orig Qty

ITN-USER-ANALYSIS    Alpha 103
User Analysis

                         ICCTRNLIN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITNSET1   COMPANY                                                IC500   IC54.2
          LOCATION
          RECRD-TYPE
          DOC-TYPE
          DOCUMENT
          LINE-NBR

                         ICCTRNLIN FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icctrndtl      ICCTRNDTL

                            ITN-COMPANY       -> ITD-COMPANY
                            ITN-LOCATION      -> ITD-LOCATION
                            ITN-RECRD-TYPE    -> ITD-RECRD-TYPE
                            ITN-DOC-TYPE      -> ITD-DOC-TYPE
                            ITN-DOCUMENT      -> ITD-DOCUMENT
                            ITN-LINE-NBR      -> ITD-LINE-NBR
                                                 ITD-SEQ