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 |