ICCTRNLIN

UPDATED BY
IC500 IC54.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITI-COMPANY
Element: Company
Numeric 4
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.
IC54.2
ITI-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
IC54.2
ITI-RECRD-TYPE
Element: Recrd Type
Numeric 2
IC54.2
ITI-DOC-TYPE
Element: Doc Type
Alpha 2
This field contains the type of transaction.
IC54.2
ITI-DOCUMENT
Element: Document
Alpha 10 (Right Justified)
This field identifies the document from which this transaction record was created.
IC54.2
ITI-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
IC54.2
ITI-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
IC54.2
ITI-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
IC54.2
ITI-QUANTITY
Element: Quantity
Signed 13.4
This field contains the desired quantity.
IC54.2
ITI-UNIT-COST
Element: Intl Cost
Signed 18.5
IC54.2
ITI-AOC-UCOST
Element: Intl Cost
Signed 18.5
IC54.2
ITI-TRAN-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
IC54.2
ITI-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
IC54.2
ITI-BIN
Element: Bin
Alpha 7
This field contains a storage area for an item or any number of items.
IC54.2
ITI-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
IC500 IC54.2
ITI-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
IC54.2
ITI-ACCT-CAT
Element: Acct Cat
Alpha 5
IC54.2
ITI-LINE-COMM
Element: Line Comm
Alpha 30
IC54.2
ITI-OFFSET-ACCTUNI
Element: Offset Acctuni
Alpha 15
IC500 IC54.2
ITI-OFFSET-ACCT
Element: Offset Acct
Numeric 6
IC500 IC54.2
ITI-OFFSET-SUBACCT
Element: Offset Subacct
Numeric 4
IC500 IC54.2
ITI-AOC-ACCTUNIT
Element: Aoc Acctunit
Alpha 15
IC500 IC54.2
ITI-AOC-ACCT
Element: Aoc Acct
Numeric 6
IC500 IC54.2
ITI-AOC-SUBACCT
Element: Aoc Subacct
Numeric 4
IC500 IC54.2
ITI-FR-TO-BIN
Element: Fr To Bin
Alpha 7
IC500 IC54.2
ITI-LST-ISS-FL
Element: Lst Iss Fl
Alpha 1
IC500 IC54.2
ITI-SEC-QTY
Element: Sec Qty
Signed 13.4
IC54.2
ITI-ORIG-QTY
Element: Orig Qty
Signed 13.4
IC54.2
ITI-USER-ANALYSIS
Element: User Analysis
Alpha 103
IC54.2


ICCTRNLIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITISET1 COMPANY
LOCATION
RECRD-TYPE
DOC-TYPE
DOCUMENT
LINE-NBR
IC500 IC54.2


ICCTRNLIN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:16:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.