PeopleSoft 9
Account Payables

Table Name VCHR_LN_SUTD

Table Description
VCHR_LN_SUTD
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
VOUCHER_ID VARCHAR(8) Yes Yes
VOUCHER_LINE_NUM int Yes Yes
SEQ_NUM SMALLINT Yes No
TAX_TYPE VARCHAR(1) No No
TAX_AUTHORITY_CD VARCHAR(3) No No
TAX_JURISDICTION VARCHAR(10) No No
TAX_PCT decimal(6,4) No No
TAX_AMT decimal(26,3) No No
TAX_AMT_BSE decimal(26,3) No No
TAX_BASIS_AMT decimal(26,3) No No
TAX_BASIS_AMT_BSE decimal(26,3) No No
CURRENCY_CD VARCHAR(3) No No
CURRENCY_CD_BASE VARCHAR(3) No No
Index
Name Type Unique Member
PS_VCHR_LN_SUTD PK Yes
Member(s) of "PS_VCHR_LN_SUTD" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
SEQ_NUM

Published June 06, 2007