PeopleSoft 9
Account Payables

Table Name VCHR_LN_EXS_DTL

Table Description
VCHR_LN_EXS_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
EXS_TAX_TYPE VARCHAR(1) Yes No
EXS_TAX_RATE_SEQ SMALLINT Yes No
EXS_TAX_CMPNT_CD VARCHAR(10) No No
EXS_TAX_DEP_CD VARCHAR(10) No No
EXS_CALC_SCHEME VARCHAR(1) No No
EXS_TAX_RATE_PCT decimal(7,4) No No
EXS_TXRTAMT_TRC decimal(26,3) No No
EXS_CURRENCY_TRC VARCHAR(3) No No
EXS_TAX_RATE_UOM VARCHAR(3) No No
EXS_RCVRY_PCT decimal(7,4) No No
EXS_CALC_BASE_FLG VARCHAR(1) No No
EXS_CALC_FRGHT_FLG VARCHAR(1) No No
EXS_CALC_MISC_FLG VARCHAR(1) No No
EXS_TAX_RATE_CD VARCHAR(10) No No
MISC_CHARGE_CODE VARCHAR(10) No No
EXS_TAX_AMT decimal(26,3) No No
EXS_TAX_AMT_BSE decimal(26,3) No No
EXS_TAX_AMT_RPT decimal(26,3) No No
EXS_BASIS_AMT decimal(26,3) No No
EXS_BASIS_AMT_BSE decimal(26,3) No No
EXS_BASIS_AMT_RPT decimal(26,3) No No
EXS_RCVRY_AMT decimal(26,3) No No
EXS_RCVRY_AMT_BSE decimal(26,3) No No
EXS_RCVRY_AMT_RPT decimal(26,3) No No
EXS_NRCVRY_AMT decimal(26,3) No No
EXS_NRCVRY_AMT_BSE decimal(26,3) No No
EXS_NRCVRY_AMT_RPT decimal(26,3) No No
EXS_CURRENCY_RPTG VARCHAR(3) No No
TXN_CURRENCY_CD VARCHAR(3) No No
BASE_CURRENCY VARCHAR(3) No No
EXS_TAXRT_AMT decimal(26,3) No No
EXS_TAXRT_AMT_BSE decimal(26,3) No No
EXS_TAXRT_AMT_RPT decimal(26,3) No No
LC_COMP_FLAG VARCHAR(1) No No
DST_ACCT_TYPE VARCHAR(4) No No
LC_EXTRCT_STATUS VARCHAR(1) No No
Index
Name Type Unique Member
PS_VCHR_LN_EXS_DTL PK Yes
Member(s) of "PS_VCHR_LN_EXS_DTL" Index
BUSINESS_UNIT
VOUCHER_ID
VOUCHER_LINE_NUM
EXS_TAX_TYPE
EXS_TAX_RATE_SEQ

Published June 06, 2007