PeopleSoft 9
Account Payables

Table Name VCHR_LN_TX_DTL

Table Description
VCHR_LN_TX_DTL
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
SUT_PRODUCT_TYPE VARCHAR(1) No No
TAX_CD_TYPE VARCHAR(1) No No
TAX_AUTHORITY_CD VARCHAR(3) No No
TAX_CD_SUT_PCT decimal(7,4) No No
TAX_AMT decimal(26,3) No No
SALETX_CALC_AMT decimal(26,3) No No
Index
Name Type Unique Member
PS_VCHR_LN_TX_DTL PK Yes
Member(s) of "PS_VCHR_LN_TX_DTL" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
SEQ_NUM

Published June 06, 2007