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.