|
|
ICCTRNLIN FILE
UPDATED BY
IC500 IC54.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITI-COMPANY Numeric 4 IC54.2
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.
ITI-LOCATION Alpha 5 IC54.2
Element: Location Code This field contains a valid stocking
location within the company inventory.
ITI-RECRD-TYPE Numeric 2 IC54.2
Element: Recrd Type
ITI-DOC-TYPE Alpha 2 IC54.2
Element: Document Type This field contains the type of
transaction.
ITI-DOCUMENT Alpha 10 (Right Justified) IC54.2
Element: Document ID This field identifies the document from
which this transaction record was
created.
ITI-LINE-NBR Numeric 6 IC54.2
Element: Line Number This field contains the line number.
ITI-SEQ Numeric 3 IC54.2
Element: Sequence NumbeThis field contains the record sequence
number.
ITI-ITEM Alpha 32 IC54.2
Element: Item Number This field contains the item
identifier.
ITI-QUANTITY Signed 13.4 IC54.2
Element: Quantity This field contains the desired
quantity.
ITI-UNIT-COST Signed 18.5 IC54.2
Element: Intl Cost This field contains the unit cost.
ITI-AOC-UCOST Signed 18.5 IC54.2
Element: Intl Cost
ITI-TRAN-UOM Alpha 4 IC54.2
Element: Unit of Measure
ITI-REFERENCE Alpha 10 (Lower Case) IC54.2
Element: Reference The reference number associated with
the transaction.
ITI-BIN Alpha 7 IC54.2
Element: Bin This field contains a storage area for
an item or any number of items.
ITI-REASON-CODE Alpha 4 IC500 IC54.2
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
ITI-ACTIVITY Alpha 15 IC54.2
Element: 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.
ITI-ACCT-CAT Alpha 5 IC54.2
Element: Acct Cat
ITI-LINE-COMM Alpha 30 IC54.2
Element: Line Comm
ITI-OFFSET-ACCTUNI Alpha 15 IC500 IC54.2
Element: Offset Acctuni
ITI-OFFSET-ACCT Numeric 6 IC500 IC54.2
Element: Offset Acct
ITI-OFFSET-SUBACCT Numeric 4 IC500 IC54.2
Element: Offset Subacct
ITI-AOC-ACCTUNIT Alpha 15 IC500 IC54.2
Element: Aoc Acctunit
ITI-AOC-ACCT Numeric 6 IC500 IC54.2
Element: Aoc Acct
ITI-AOC-SUBACCT Numeric 4 IC500 IC54.2
Element: Aoc Subacct
ITI-FR-TO-BIN Alpha 7 IC500 IC54.2
Element: Fr To Bin
ITI-LST-ISS-FL Alpha 1 IC500 IC54.2
Element: Lst Iss Fl
ITI-SEC-QTY Signed 13.4 IC54.2
Element: Sec Qty
ITI-ORIG-QTY Signed 13.4 IC54.2
Element: Orig Qty
ITI-USER-ANALYSIS Alpha 103
Element: User Analysis
ICCTRNLIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITISET1 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
ITI-COMPANY -> ITJ-COMPANY
ITI-LOCATION -> ITJ-LOCATION
ITI-RECRD-TYPE -> ITJ-RECRD-TYPE
ITI-DOC-TYPE -> ITJ-DOC-TYPE
ITI-DOCUMENT -> ITJ-DOCUMENT
ITI-LINE-NBR -> ITJ-LINE-NBR
ITJ-SEQ
|
