VCH_DUP_INV_REG

(SQL Table)
Index Back

Vchr Dupl Invoice Register

Used to determine Duplicate Invoices

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher

Default Value: REG

4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
7 ERS_INV_SEQ Number(5,0) INTEGER NOT NULL ERS Invoice Sequence
8 INVOICE_DT Date(10) DATE Invoice Date
9 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount