PeopleSoft 9
Account Payables

Table Name TSE_VCHR

Table Description
TSE_VCHR
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
TSE_JOBID VARCHAR(10) No No
TSE_PROC_INSTANCE decimal(10) No No
ORIGIN VARCHAR(3) No No
GRP_AP_ID VARCHAR(10) No No
VENDOR_ID VARCHAR(10) No No
CNTRCT_ID VARCHAR(25) No No
INVOICE_ID VARCHAR(30) No No
INVOICE_DT PSDATE No No
GROSS_AMT decimal(26,3) No No
TXN_CURRENCY_CD VARCHAR(3) No No
VCHR_SRC VARCHAR(4) No No
Index
Name Type Unique Member
PS_TSE_VCHR PK Yes
Member(s) of "PS_TSE_VCHR" Index
BUSINESS_UNIT
VOUCHER_ID

Published June 06, 2007