PV_CC_RECON_TM4

(SQL Table)
Index Back

Temporary table used in AE

Temporary table used in AE Auto Reconcile Pcard process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
4 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
5 PV_CC_RCN_DIFF Number(27,3) DECIMAL(26,3) NOT NULL Reconciliation Amt Difference
6 PV_CC_RCN_PRC1 Number(27,3) DECIMAL(26,3) NOT NULL Percent Tolerance Calculation
7 PV_CC_RCN_PRC2 Number(27,3) DECIMAL(26,3) NOT NULL Percent Tolerance Calculation