PDCCHRGDTL

UPDATED BY
PD57.1 PD57.2 PD570

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PX2-PCARD-PROGRAM
Element: Pcard Program		Alpha 10
PD57.1 PD570
PX2-STATEMENT
Element: Invoice		Alpha 22
PD57.1 PD570
PX2-COMPANY
Element: Company		Numeric 4
PD57.1 PD570
PX2-STMT-FR-DATE
Element: Date		Numeric 8 (yyyymmdd)
PX2-STMT-TO-DATE
Element: Date		Numeric 8 (yyyymmdd)
PX2-TXN-NBR
Element: Transaction		Alpha 22
PD57.1 PD570
PX2-PCARD-NBR
Element: Pcard Nbr		Alpha 16
PD57.1 PD570
PX2-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
PX2-MCC-CODE
Element: Mcc Code		Alpha 4
PD57.1 PD570
PX2-MERCHANT
Element: Merchant		Alpha 32
PD57.1 PD570
PX2-TRAN-DATE
Element: Date		Numeric 8 (yyyymmdd)
PD57.1 PD570
PX2-POST-DATE
Element: Date		Numeric 8 (yyyymmdd)
PD57.1 PD570
PX2-CARD-USER-ID
Element: Card User Id		Alpha 10 (Lower Case)
PX2-CARD-USER-NAME
Element: Card User Name		Alpha 30
PD570
PX2-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
PD57.1 PD570
PX2-PO-RELEASE
Element: Po Release		Numeric 4
PD57.1 PD570
PX2-PO-CODE
Element: Po Code		Alpha 4
PD57.1 PD570
PX2-PO-LINE-NBR
Element: Line Nbr		Numeric 6
PD57.1 PD570
PX2-ITEM
Element: Item		Alpha 32
PD57.1 PD570
PX2-VEN-ITEM
Element: Item		Alpha 32
PD57.1 PD570
PX2-ITEM-DESC
Element: Description		Alpha 30 (Lower Case)
PD570
PX2-VEN-ITEM-DESC
Element: Description		Alpha 30 (Lower Case)
PX2-QUANTITY
Element: Quantity		Signed 13.4
PD57.1 PD570
PX2-VBUY-UOM
Element: Uom		Alpha 4
PD57.1 PD570
PX2-VPRI-UOM
Element: Uom		Alpha 4
PD570
PX2-ITEM-CHARGE
Element: Intl Amt		Signed 18.2
PD57.1 PD570
PX2-TAX-AMT
Element: Intl Amt		Signed 18.2
PD57.1 PD57.2
PD570
PX2-TOT-AOC-COST
Element: Intl Amt		Signed 18.2
PD57.1 PD570
PX2-LAST-DIST-SEQ
Element: Seq Nbr		Numeric 4
PD57.2
PX2-TAX-INDICATOR
Element: Tax Indicator		Numeric 1

0 = Exempt
1 = Taxable
PD570
PX2-TAX-CODE
Element: Tax Code		Alpha 10
PX2-STATUS
Element: Status		Numeric 1

0 = Unreleased
1 = Released
PD570
PX2-REASON-CODE
Element: Reason Code		Alpha 4
PX2-COM-CODE
Element: Commodity Code		Alpha 35
PX2-USER-FIELD1
Element: Item User1		Alpha 20
PX2-USER-FIELD2
Element: Item User1		Alpha 20
PX2-USER-FIELD3
Element: Item User1		Alpha 20
PX2-USER-FIELD4
Element: Item User1		Alpha 20
PX2-USER-FIELD5
Element: Item User1		Alpha 20


PDCCHRGDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PX2SET1 PCARD-PROGRAM
STATEMENT
COMPANY
TXN-NBR
PD57.1 PD57.2
PD57.3 PD570
PX2SET2 PCARD-PROGRAM
STATEMENT
TRAN-DATE
COMPANY
TXN-NBR
KeyChange


PDCCHRGDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcchrghdr PDCCHRGHDR Required
PX2-PCARD-PROGRAM->PX1-PCARD-PROGRAM (PX1SET1)
PX2-STATEMENT->PX1-STATEMENT


PDCCHRGDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdcchrgdst PDCCHRGDST
PX2-PCARD-PROGRAM->PX3-PCARD-PROGRAM
PX2-STATEMENT->PX3-STATEMENT
PX2-COMPANY->PX3-COMPANY
PX2-TXN-NBR->PX3-TXN-NBR
  PX3-SEQ-NBR
Pdcchrgerr PDCCHRGERR
PX2-PCARD-PROGRAM->PXE-PCARD-PROGRAM
PX2-STATEMENT->PXE-STATEMENT
PX2-COMPANY->PXE-COMPANY
PX2-TXN-NBR->PXE-TXN-NBR
  PXE-SEQ-NBR
  PXE-ERROR-SEQ

File created: Thu Jun 09 11:23:36 2016

Home
Contact Us



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