ICICTUF

UPDATED BY
IC20.1 IC20.2 IC21.1 IC21.2 IC21.5 IC22.1
IC22.2 IC23.1 IC23.2 IC24.1 IC24.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFT-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.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-DOC-TYPE
Element: Doc Type		Alpha 2
This field contains the type of transaction.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-SYSTEM-CD
Element: System Cd		Alpha 2
This field indicates on what system the transaction originated.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-DOCUMENT
Element: Document		Alpha 10 (Right Justified)
This field identifies the document from which this transaction record was created.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-COMPONENT-SEQ
Element: Seq		Numeric 3
This field contains the record sequence number.
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-ICT-USR-FLD-01
Element: Ict Usr Fld 01		Alpha 20
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-ICT-USR-FLD-02
Element: Ict Usr Fld 02		Alpha 20
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-ICT-USR-FLD-03
Element: Ict Usr Fld 03		Alpha 20
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-ICT-USR-FLD-04
Element: Ict Usr Fld 04		Alpha 20
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2
UFT-ICT-USR-FLD-05
Element: Ict Usr Fld 05		Alpha 20
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2


ICICTUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFTSET1 COMPANY
LOCATION
DOC-TYPE
SYSTEM-CD
DOCUMENT
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
IC20.1 IC20.2
IC21.1 IC21.2
IC21.5 IC22.1
IC22.2 IC23.1
IC23.2 IC24.1
IC24.2


ICICTUF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Ictrans ICTRANS Required
UFT-COMPANY->ICT-COMPANY
UFT-LOCATION->ICT-LOCATION
UFT-DOC-TYPE->ICT-DOC-TYPE
UFT-SYSTEM-CD->ICT-SYSTEM-CD
UFT-DOCUMENT->ICT-DOCUMENT
UFT-SHIPMENT-NBR->ICT-SHIPMENT-NBR
UFT-LINE-NBR->ICT-LINE-NBR
UFT-COMPONENT-SEQ->ICT-COMPONENT-SEQ

File created: Thu Jun 09 02:18:39 2016

Home
Contact Us



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