PDCHRGDTL

REFERENCED BY
AP145 AP146 AP245 AP246


UPDATED BY
PD130 PD20.1 PD20.2 PD20.3 PD21.1 PD22.1
PD570 PD01.1 PD01.2 PD10.2 PD10.3 PD230
PD235

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXD-PCARD-PROGRAM
Element: Pcard Program		Alpha 10
PD20.2 PD21.1
PD570
PXD-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.
PD20.2 PD21.1
PD570
PXD-STATEMENT
Element: Invoice		Alpha 22
Used to identify the invoice.
PD130 PD20.2
PD21.1 PD570
PXD-TXN-NBR
Element: Transaction		Alpha 22
PD130 PD20.2
PD21.1 PD570
PXD-LST-DST-SEQ
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
PD21.1 PD22.1
PD570
PXD-PCARD-NBR
Element: Pcard Nbr		Alpha 16
PD21.1 PD570
PXD-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
PD21.1 PD570
PXD-MCC-CODE
Element: Mcc Code		Alpha 4
PD21.1 PD570
PXD-MERCHANT
Element: Merchant		Alpha 32
PD21.1 PD570
PXD-TRAN-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD570
PXD-POST-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD570
PXD-CARD-USER-NAME
Element: Card User Name		Alpha 30
PD570
PXD-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
PD21.1 PD570
PXD-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
PD21.1 PD570
PXD-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
PD21.1 PD570
PXD-PO-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
PD21.1 PD570
PXD-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
PD21.1 PD570
PXD-VEN-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
PD570
PXD-ITEM-DESC
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PD570
PXD-VEN-ITEM-DESC
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PXD-QUANTITY
Element: Quantity		Signed 13.4
This field contains the desired quantity.
PD570
PXD-VBUY-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
PD570
PXD-VPRI-UOM
Element: Uom		Alpha 4
This field contains the valid stock unit of measure for this item.
PD570
PXD-ITEM-CHARGE
Element: Intl Amt		Signed 18.2
PD21.1 PD570
PXD-TAX-AMT
Element: Intl Amt		Signed 18.2
PD21.1 PD22.1
PD570
PXD-TOT-AOC-COST
Element: Intl Amt		Signed 18.2
PD570
PXD-TAX-INDICATOR
Element: Tax Indicator		Numeric 1

0 = Exempt
1 = Taxable
PD570
PXD-TAX-CODE
Element: Tax Code		Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
PXD-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Unreleased
1 = Released
2 = Approved
3 = Disapproved
8 = Rejected
9 = Closed
7 = Cancelled
PD130 PD20.1
PD20.2 PD20.3
PD570
PXD-APPROVED-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PD130
PXD-REASON-CODE
Element: Reason Code		Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
PD21.1
PXD-COM-CODE
Element: Commodity Code		Alpha 35
PD21.1
PXD-USER-FLD-01
Element: Item User1		Alpha 20
PD21.1
PXD-USER-FLD-02
Element: Item User1		Alpha 20
PD21.1
PXD-USER-FLD-03
Element: Item User1		Alpha 20
PD21.1
PXD-USER-FLD-04
Element: Item User1		Alpha 20
PD21.1
PXD-USER-FLD-05
Element: Item User1		Alpha 20
PD21.1
PXD-DISPUTED-QTY
Element: Quantity		Signed 13.4
This field contains the desired quantity.
PXD-DISPUTED-AMT
Element: Intl Amt		Signed 18.2
PXD-INCOME-CODE
Element: Income Code		Alpha 4
A user-defined code that represents a type of income withholding. Used to track reportable income for reporting or withholding.
PD21.1 PD570
PXD-PFLO-APPR-LVL
Element: Aprv Level		Numeric 1
This is the approval level that this requisition has attained so far via RQ12.
PD20.2
PXD-IC-SEGMENT
Element: Icsegment		Alpha 2
PD21.1
PXD-IC-FAMILY
Element: Icfamily		Alpha 2
PD21.1
PXD-IC-CLASS
Element: Icclass		Alpha 2
PD21.1
PXD-IC-COMMODITY
Element: Iccommodity		Alpha 2
PD21.1
PXD-DIST-CODE
Element: Dist Code		Alpha 9
A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.
PD21.1 PD22.1
PD570
PXD-DIST-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.
PD570
PXD-MANUF-CODE
Element: Manuf Code		Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
PD21.1
PXD-MANUF-DIV
Element: Manuf Division		Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.
PD21.1
PXD-MANUF-NBR
Element: Manuf Nbr		Alpha 35
This is the identifier that the manufacturer has assigned to an item.
PD21.1
PXD-ATN-OBJ-ID
Element: Obj Id		Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
PXD-DIVERSE-CODE
Element: Diverse Code		Alpha 5
Diversity Code for Account Payable Vendors
PD21.1
PXD-CARD-USER-ID
Element: Card User Id		Alpha 10 (Lower Case)
PD570
PXD-SEC-WTH-CODE1
Element: Sec Wth Code		Alpha 10
PXD-SEC-WTH-PCT1
Element: Withhold Pct		Percent 5.3 (Percent)
PXD-BASE-SEC-WTH1
Element: Intl Amt		Signed 18.2
PXD-TRAN-SEC-WTH1
Element: Intl Amt		Signed 18.2
PXD-SEC-WTH-CODE2
Element: Sec Wth Code		Alpha 10
PXD-SEC-WTH-PCT2
Element: Withhold Pct		Percent 5.3 (Percent)
PXD-BASE-SEC-WTH2
Element: Intl Amt		Signed 18.2
PXD-TRAN-SEC-WTH2
Element: Intl Amt		Signed 18.2
PXD-SEC-WTH-CODE3
Element: Sec Wth Code		Alpha 10
PXD-SEC-WTH-PCT3
Element: Withhold Pct		Percent 5.3 (Percent)
PXD-BASE-SEC-WTH3
Element: Intl Amt		Signed 18.2
PXD-TRAN-SEC-WTH3
Element: Intl Amt		Signed 18.2
PXD-UNIT-COST
Element: Intl Cost		Signed 18.5
PD570
PXD-ITEM-TOTAL
Element: Intl Amt		Signed 18.2
PD570
PXD-FOR-ECON-CODE
Element: Code		Alpha 10


PDCHRGDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXDSET1 PCARD-PROGRAM
STATEMENT
COMPANY
TXN-NBR
PD01.1 PD01.2
PD10.2 PD10.3
PD130 PD20.1
PD20.2 PD20.3
PD21.1 PD22.1
PD230 PD235
PD570
PXDSET2 COMPANY
STATEMENT
MERCHANT
TXN-NBR
PCARD-PROGRAM
Subset
Where(PO-NUMBER =Spaces)
AP145 AP146
AP245 AP246
PXDSET3 PCARD-PROGRAM
COMPANY
STATEMENT
VENDOR
MERCHANT
TXN-NBR
KeyChange
PD130
PXDSET4 PCARD-PROGRAM
PCARD-NBR
STATEMENT
COMPANY
TXN-NBR
PD20.1 PD20.3
PD21.1
PXDSET6 PCARD-PROGRAM
PCARD-NBR
STATEMENT
TRAN-DATE*
COMPANY
TXN-NBR
PD20.1 PD20.3
PXDSET7 PCARD-PROGRAM
PCARD-NBR
STATEMENT
MERCHANT
COMPANY
TXN-NBR
PD20.1
PXDSET8 PCARD-PROGRAM
PCARD-NBR
TRAN-DATE*
COMPANY
TXN-NBR
STATEMENT
PD20.1
PXDSET9 PCARD-PROGRAM
PCARD-NBR
MERCHANT
COMPANY
TXN-NBR
STATEMENT
PD20.1


PDCHRGDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pdchrghdr PDCHRGHDR Required
PXD-PCARD-PROGRAM->PXH-PCARD-PROGRAM
PXD-STATEMENT->PXH-STATEMENT


PDCHRGDTL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdistrib APDISTRIB
Valid When (PXD-PO-NUMBER =Spaces )
PXD-COMPANY->APD-COMPANY
PXD-STATEMENT->APD-STATEMENT
PXD-TXN-NBR->APD-TXN-NBR
  APD-API-OBJ-ID
  APD-DIST-SEQ-NBR
Pdchrgdist PDCHRGDIST
PXD-PCARD-PROGRAM->PDS-PCARD-PROGRAM
PXD-STATEMENT->PDS-STATEMENT
PXD-COMPANY->PDS-COMPANY
PXD-TXN-NBR->PDS-TXN-NBR
  PDS-SEQ-NBR

File created: Thu Jun 09 02:26:28 2016

Home
Contact Us



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