PeopleSoft 9
Account Payables

Table Name VCH_DUP_INV_REG

Table Description
VCH_DUP_INV_REG
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VENDOR_ID VARCHAR(10) No No
INVOICE_ID VARCHAR(30) No No
ERS_INV_SEQ SMALLINT No No
INVOICE_DT PSDATE No No
GROSS_AMT decimal(26,3) No No
Index
Name Type Unique Member
PS_VCH_DUP_INV_REG PK Yes
PSAVCH_DUP_INV_REG IE1 No
Member(s) of "PS_VCH_DUP_INV_REG" Index
BUSINESS_UNIT
VOUCHER_ID
Member(s) of "PSAVCH_DUP_INV_REG" Index
VENDOR_ID
INVOICE_ID
ERS_INV_SEQ
INVOICE_DT
GROSS_AMT

Published June 06, 2007