Tables That are Accessed by the Voucher Build Process

The following table lists the tables that the Voucher Build process accesses for each source transaction:

Source Transactions Tables Accessed

  • PeopleSoft eSettlements self-service invoices.

  • Summary invoices.

  • Quick invoices.

  • XML invoices.

  • Document Management invoices

Quick invoice tables:

  • VCHR_HDR_QV

  • VCHR_LINE_QV

  • VCHR_DIST_QV

  • VCHR_PYMT_QV

  • VCHR_MSCH_QV

  • PeopleSoft Billing (interunit) invoices.

  • Debit memo vouchers.

  • Electronic data interchange (EDI) invoice transactions.

  • PeopleSoft Pay/Bill Management transactions.

  • Procurement card invoices.

  • PeopleSoft Receivables refunds.

  • Spreadsheet vouchers.

  • Voucher enterprise integration point (EIP) transactions.

Voucher staging tables:

  • VCHR_HDR_STG

  • VCHR_LINE_STG

  • VCHR_DIST_STG

  • VCHR_PYMNT_STG

  • VCHR_MSCH_STG

  • VCHR_BANK_STG

  • VCHR_IBANK_STG

  • VCHR_VNDR_STG

Evaluated receipt settlement (ERS) vouchers.

Receiver and purchase order tables:

  • RECV_HDR

  • RECV_LN_SHIP

  • RECV_LN_DISTRIB

  • PO_HDR

  • PO_LINE

  • PO_LINE_SHIP

Return to vendor (RTV) adjustments.

RTV tables:

  • RTV_HDR

  • RTV_LN

  • RTV_LN_DISTRIB

  • RTV_LN_FEE

Voucher contracts.

Contract staging tables:

  • CNTRCT_RLS_HDR

  • CNTRCT_RLS_LN

  • CNTRCT_RLS_DTL

Purchase order (PO) voucher contracts.

Contract staging tables and PO tables:

  • CNTRCT_RLS_HDR

  • CNTRCT_RLS_LN

  • CNTRCT_RLS_DTL

  • CNTRCT_EVT_PO

  • PO_HDR

  • PO_LINE

  • PO_LINE_SHIP

  • PO_LINE_DISTRIB

Consigned inventory items.

  • CM_DEPLETE

  • CM_ACTUAL_COST

  • RECV_HDR

  • RECV_LN_SHIP

  • RECV_LN_DISTRIB

  • VENDOR_LOC

  • BUS_UNIT_TBL_IN

  • PeopleSoft Lease Administration vouchers.

  • Vendor Rebate transactions.

Voucher staging tables:

  • VCHR_HDR_STG

  • VCHR_LINE_STG

  • VCHR_DIST_STG

  • VCHR_PYMT_STG

PeopleSoft Order Management claim transactions.

Voucher staging tables:

  • VCHR_HDR_STG

  • VCHR_LINE_STG

  • VCHR_DIST_STG

Payment Request Vouchers

Payment Request Tables:

  • PR_REQUEST

  • PR_LINE

  • PR_DIST

IPAC Vouchers

IPAC Voucher Staging Tables

  • AP_IPAC_HDR

  • IPAC_HDR_STG

  • AP_IPAC_DETAIL_