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