|
|
PDCHRGDTL FILE
REFERENCED BY
PD01.1 PD01.2 PD10.2 PD10.3 PD230 PD235
AP145 AP146 AP245
UPDATED BY
PD130 PD20.1 PD20.2 PD20.3 PD21.1 PD22.1
PD570
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXD-PCARD-PROGRAM Alpha 10 PD20.2 PD21.1
Element: Pcard Program PD570
PXD-COMPANY Numeric 4 PD20.2 PD21.1
Element: Company Identifies the AP company if the PD570
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PXD-STATEMENT Alpha 22 PD20.2 PD21.1
Element: Invoice Used to identify the invoice. PD570
PXD-TXN-NBR Alpha 22 PD20.2 PD21.1
Element: Transaction PD570
PXD-LST-DST-SEQ Numeric 4 PD21.1 PD22.1
Element: Seq Nbr An automatically assigned sequence PD570
number.
PXD-PCARD-NBR Alpha 16 PD21.1 PD570
Element: Pcard Nbr
PXD-VENDOR Alpha 9 (Right Justified) PD21.1 PD570
Element: Vendor The vendor's identification code.
PXD-MCC-CODE Alpha 4 PD21.1 PD570
Element: Mcc Code
PXD-MERCHANT Alpha 32 PD21.1 PD570
Element: Merchant
PXD-TRAN-DATE Numeric 8 (yyyymmdd) PD570
Element: Date This field displays the system date
when this was created.
PXD-POST-DATE Numeric 8 (yyyymmdd) PD570
Element: Date This field displays the system date
when this was created.
PXD-CARD-USER-NAME Alpha 30 PD570
Element: Card User Name
PXD-PO-NUMBER Alpha 14 (Right Justified) PD21.1 PD570
Element: Po Number This field contains the number
representing the purchase order.
PXD-PO-CODE Alpha 4 PD21.1 PD570
Element: Po Code This is the purchase order code.
PXD-PO-RELEASE Numeric 4 PD21.1 PD570
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
PXD-PO-LINE-NBR Numeric 6 PD21.1 PD570
Element: Line Nbr This field contains the line number.
PXD-ITEM Alpha 32 PD21.1 PD570
Element: Item This field contains the item
identifier.
PXD-VEN-ITEM Alpha 32 PD21.1 PD570
Element: Item This field contains the item
identifier.
PXD-ITEM-DESC Alpha 30 (Lower Case) PD570
Element: Description This field displays the description.
PXD-VEN-ITEM-DESC Alpha 30 (Lower Case)
Element: Description This field displays the description.
PXD-QUANTITY Signed 13.4 PD570
Element: Quantity This field contains the desired
quantity.
PXD-VBUY-UOM Alpha 4 PD570
Element: Uom This field contains the valid stock
unit of measure for this item.
PXD-VPRI-UOM Alpha 4 PD570
Element: Uom This field contains the valid stock
unit of measure for this item.
PXD-ITEM-CHARGE Signed 18.2 PD21.1 PD570
Element: Intl Amt
PXD-TAX-AMT Signed 18.2 PD21.1 PD22.1
Element: Intl Amt PD570
PXD-TOT-AOC-COST Signed 18.2 PD570
Element: Intl Amt
PXD-TAX-INDICATOR Numeric 1 PD570
Element: Tax Indicator 0 = Exempt
1 = Taxable
PXD-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
PXD-STATUS Numeric 1 PD130 PD20.1
Element: Status This field displays the status of the PD20.2 PD20.3
transaction. PD570
0 = unreleased
1 = Released
2 = Approved
3 = Disapproved
8 = Rejected
9 = Closed
7 = Cancelled
PXD-APPROVED-DATE Numeric 8 (yyyymmdd) PD130
Element: Date This field displays the system date
when this was created.
PXD-REASON-CODE Alpha 4 PD21.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
PXD-COM-CODE Alpha 35 PD21.1
Element: Commodity Code
PXD-USER-FLD-01 Alpha 20 PD21.1
Element: Item User1
PXD-USER-FLD-02 Alpha 20 PD21.1
Element: Item User1
PXD-USER-FLD-03 Alpha 20 PD21.1
Element: Item User1
PXD-USER-FLD-04 Alpha 20 PD21.1
Element: Item User1
PXD-USER-FLD-05 Alpha 20 PD21.1
Element: Item User1
PXD-DISPUTED-QTY Signed 13.4
Element: Quantity This field contains the desired
quantity.
PXD-DISPUTED-AMT Signed 18.2
Element: Intl Amt
PXD-INCOME-CODE Alpha 4 PD21.1 PD570
Element: Income Code A user-defined code that represents a
type of income withholding. Used to
track reportable income for reporting or
withholding.
PXD-PFLO-APPR-LVL Numeric 1 PD20.2
Element: Aprv Level This is the approval level that this
requisition has attained so far via
RQ12.
PXD-IC-SEGMENT Alpha 2 PD21.1
Element: Icsegment
PXD-IC-FAMILY Alpha 2 PD21.1
Element: Icfamily
PXD-IC-CLASS Alpha 2 PD21.1
Element: Icclass
PXD-IC-COMMODITY Alpha 2 PD21.1
Element: Iccommodity
PXD-DIST-CODE Alpha 9 PD21.1 PD22.1
Element: Dist Code 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 Numeric 4
Element: Company 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 Alpha 4 PD21.1
Element: Manuf Code This field contains a user defined code
that indicates the manufacturer of an
item.
PXD-MANUF-DIV Alpha 4 PD21.1
Element: Manuf DivisionThis is a user defined code that
indicates which division of a
manufacturer is tied to an item.
PXD-MANUF-NBR Alpha 15 PD21.1
Element: Manuf Nbr This is the identifier that the
manufacturer has assigned to an item.
PXD-ATN-OBJ-ID Numeric 12
Element: Obj Id 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 Alpha 5 PD21.1
Element: Diverse Code Diversity Code for Account Payable
Vendors
PDCHRGDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXDSET1 PCARD-PROGRAM PD01.1 PD01.2
STATEMENT PD10.2 PD10.3
COMPANY PD130 PD20.1
TXN-NBR PD20.2 PD20.3
PD21.1 PD22.1
PD230 PD235
PD570
PXDSET2 COMPANY Subset AP145 AP146
STATEMENT Where (PO-NUMBER = Spaces ) AP245
MERCHANT
TXN-NBR
PCARD-PROGRAM
PXDSET3 PCARD-PROGRAM KeyChange PD130
COMPANY
STATEMENT
VENDOR
MERCHANT
TXN-NBR
PXDSET4 PCARD-PROGRAM PD20.1 PD20.3
PCARD-NBR PD21.1
STATEMENT
COMPANY
TXN-NBR
PXDSET6 PCARD-PROGRAM PD20.1 PD20.3
PCARD-NBR
STATEMENT
TRAN-DATE*
COMPANY
TXN-NBR
PXDSET7 PCARD-PROGRAM PD20.1
PCARD-NBR
STATEMENT
MERCHANT
COMPANY
TXN-NBR
PDCHRGDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
