C3DTLRET

REFERENCED BY
API1.1 POI3.1


UPDATED BY
PO30.1 WH32.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
C3D-COMPANY
Element: Company		Numeric 4
PO30.1 WH32.1
C3D-TRANS-TYPE
Element: Type		Alpha 2
PO30.1 WH32.1
C3D-RECORD-TYPE
Element: Type		Alpha 2
PO30.1 WH32.1
C3D-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
PO30.1 WH32.1
C3D-INVOICE
Element: Invoice		Alpha 22
PO30.1 WH32.1
C3D-SUFFIX
Element: Suffix		Numeric 3
PO30.1 WH32.1
C3D-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
PO30.1 WH32.1
C3D-PO-RELEASE
Element: Po Release		Numeric 4
PO30.1 WH32.1
C3D-PO-CODE
Element: Po Code		Alpha 4
PO30.1 WH32.1
C3D-PO-LINE-NUMBER
Element: Line Nbr		Numeric 6
PO30.1 WH32.1
C3D-SEQ-NBR
Element: Seq Nbr		Numeric 4
PO30.1 WH32.1
C3D-REC-NUMBER
Element: Rec Number		Numeric 10
PO30.1 WH32.1
C3D-ORDER-NUMBER
Element: Order Nbr		Numeric 8
PO30.1 WH32.1
C3D-ORDER-LINE-NBR
Element: Line Nbr		Numeric 6
PO30.1 WH32.1
C3D-LINE-NBR
Element: Line Nbr		Numeric 6
PO30.1 WH32.1
C3D-FISC-REF-LINE
Element: Line Nbr		Numeric 6
PO30.1 WH32.1
C3D-FISC-RF-LN-SEQ
Element: Seq Nbr		Numeric 4
PO30.1 WH32.1
C3D-ITEM
Element: Item		Alpha 32
PO30.1 WH32.1
C3D-ITEM-DESC
Element: Item Desc		Alpha 30
PO30.1 WH32.1
C3D-MATCH-QTY
Element: Quantity		Signed 13.4
PO30.1 WH32.1
C3D-MATCH-UNIT-CST
Element: Intl Cost		Signed 18.5
PO30.1 WH32.1
C3D-VPRI-UOM
Element: Uom		Alpha 4
PO30.1 WH32.1
C3D-TOT-DIST-AMT
Element: Intl Amt		Signed 18.2
PO30.1 WH32.1
C3D-WH-REC-NUMBER
Element: Rec Number		Numeric 10
PO30.1 WH32.1
C3D-WH-REC-LINE-NB
Element: Line Nbr		Numeric 6
PO30.1 WH32.1
C3D-MULT-PO-FL
Element: Alpha		Alpha 1
PO30.1 WH32.1
C3D-GLBL-LINE-TYPE
Element: Glbl Line Type		Alpha 15
PO30.1 WH32.1
C3D-FREIGHT-TOT
Element: Freight Total		Signed 18.2
PO30.1 WH32.1
C3D-INSRNC-TOT
Element: Insurance Tot		Signed 18.2
PO30.1 WH32.1
C3D-CSTMS-TOT
Element: Cstms Total		Signed 18.2
PO30.1 WH32.1
C3D-OTHER-AOC-TOT
Element: Other Aoc Tot		Signed 18.2
PO30.1 WH32.1
C3D-BOD-ACCT-ENT
Element: Notice Nbr		Alpha 22
PO30.1 WH32.1
C3D-BOD-LOCATION
Element: Notice Nbr		Alpha 22
PO30.1 WH32.1
C3D-BOD-DOC-ID
Element: Alpha 100		Alpha 100
PO30.1 WH32.1
C3D-FREIGHT-AOC
Element: Aoc Code		Alpha 2
PO30.1 WH32.1
C3D-INSRNC-AOC
Element: Aoc Code		Alpha 2
PO30.1 WH32.1
C3D-CSTMS-AOC
Element: Aoc Code		Alpha 2
PO30.1 WH32.1
C3D-OTHER-AOC
Element: Aoc Code		Alpha 2
PO30.1 WH32.1


C3DTLRET FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
C3DSET1 COMPANY
TRANS-TYPE
RECORD-TYPE
VENDOR
INVOICE
PO-NUMBER
PO-LINE-NUMBER
API1.1 PO30.1
POI3.1 WH32.1


C3DTLRET FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Mainvdtl MAINVDTL Not Required
C3D-COMPANY->MAD-COMPANY
C3D-VENDOR->MAD-VENDOR
C3D-INVOICE->MAD-INVOICE
C3D-SUFFIX->MAD-SUFFIX
C3D-PO-NUMBER->MAD-PO-NUMBER
C3D-PO-RELEASE->MAD-PO-RELEASE
C3D-PO-CODE->MAD-PO-CODE
C3D-PO-LINE-NUMBER->MAD-LINE-NBR
C3D-SEQ-NBR->MAD-SEQ-NBR

File created: Thu Jun 09 02:11:49 2016

Home
Contact Us



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