PeopleSoft 9
Account Payables

Table Name VENDOR_INVOICE

Table Description
VENDOR_INVOICE
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_ID VARCHAR(10) Yes Yes
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
DUP_INVOICE_IND VARCHAR(1) No No
DUP_INVOICE_ACTION VARCHAR(1) No No
DUP_INV_NUM_FLG VARCHAR(1) No No
DUP_INV_VENDOR_NUM VARCHAR(1) No No
DUP_INV_GROSS_AMT VARCHAR(1) No No
DUP_INV_DT VARCHAR(1) No No
DUP_INV_BUS_UNIT VARCHAR(1) No No
DUP_INV_COMB_CODE SMALLINT No No
Index
Name Type Unique Member
PS_VENDOR_INVOICE PK Yes
Member(s) of "PS_VENDOR_INVOICE" Index
SETID
VENDOR_ID
EFFDT

Published June 06, 2007