PDCHRGDTL

UPDATED BY
AP145 AP146 AP245

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

0 = Exempt
1 = Taxable
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
PXD-APPROVED-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
PXD-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
PXD-COM-CODE
Element: Commodity Code
Alpha 35
PXD-USER-FLD-01
Element: Item User1
Alpha 20
PXD-USER-FLD-02
Element: Item User1
Alpha 20
PXD-USER-FLD-03
Element: Item User1
Alpha 20
PXD-USER-FLD-04
Element: Item User1
Alpha 20
PXD-USER-FLD-05
Element: Item User1
Alpha 20
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.
PXD-PFLO-APPR-LVL
Element: Aprv Level
Numeric 1
This is the approval level that this requisition has attained so far via RQ12.
PXD-IC-SEGMENT
Element: Icsegment
Alpha 2
PXD-IC-FAMILY
Element: Icfamily
Alpha 2
PXD-IC-CLASS
Element: Icclass
Alpha 2
PXD-IC-COMMODITY
Element: Iccommodity
Alpha 2
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.
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.
PXD-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
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.
PXD-MANUF-NBR
Element: Manuf Nbr
Alpha 35
This is the identifier that the manufacturer has assigned to an item.
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
PXD-CARD-USER-ID
Element: Card User Id
Alpha 10 (Lower Case)


PDCHRGDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXDSET1 PCARD-PROGRAM
STATEMENT
COMPANY
TXN-NBR
PXDSET2 COMPANY
STATEMENT
MERCHANT
TXN-NBR
PCARD-PROGRAM
Subset
Where(PO-NUMBER =Spaces)
AP145 AP146
AP245
PXDSET3 PCARD-PROGRAM
COMPANY
STATEMENT
VENDOR
MERCHANT
TXN-NBR
KeyChange
PXDSET4 PCARD-PROGRAM
PCARD-NBR
STATEMENT
COMPANY
TXN-NBR
PXDSET6 PCARD-PROGRAM
PCARD-NBR
STATEMENT
TRAN-DATE*
COMPANY
TXN-NBR
PXDSET7 PCARD-PROGRAM
PCARD-NBR
STATEMENT
MERCHANT
COMPANY
TXN-NBR
PXDSET8 PCARD-PROGRAM
PCARD-NBR
TRAN-DATE*
COMPANY
TXN-NBR
STATEMENT
PXDSET9 PCARD-PROGRAM
PCARD-NBR
MERCHANT
COMPANY
TXN-NBR
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


File created: Wed Jun 08 20:50:43 2016

Home
Contact Us



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