PeopleSoft 9.0
Cash Management

Table Name TRV_VAT_TRAN

Table Description
TRV_VAT_TRAN
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT CHAR(5) Yes Yes
TR_SOURCE_CD CHAR(1) Yes No
TR_SOURCE_ID CHAR(12) Yes No
EVENT_ID CHAR(20) Yes No
TRANSACTION_DT PSDATE Yes No
SEQ_NBR DECIMAL(15) Yes No
TRANSACTION_LEG SMALLINT Yes No
ACCTG_EVENT_TYPE CHAR(2) Yes No
BANK_ACCOUNT_NUM CHAR(17) Yes No
TRAN_REF_ID CHAR(20) Yes No
ACCTG_TMPL_ID CHAR(15) Yes No
ACCTG_TMPL_LINE SMALLINT Yes No
ACCT_BUS_UNIT_GL CHAR(5) No No
FOREIGN_CURRENCY CHAR(3) No No
CURRENCY_CD CHAR(3) No No
RT_TYPE CHAR(5) No No
RATE_MULT DECIMAL(15,8) No No
RATE_DIV DECIMAL(15,8) No No
VAT_ENTITY CHAR(20) No No
COUNTRY_VAT_BILLFR CHAR(3) No No
VAT_RGSTRN_SELLER CHAR(12) No No
COUNTRY_VAT_BILLTO CHAR(3) No No
VAT_RCRD_INPT_FLG CHAR(1) No No
VAT_RCRD_OUTPT_FLG CHAR(1) No No
VAT_DCLRTN_DT PSDATE No No
VAT_CALC_TYPE CHAR(1) No No
VAT_ROUND_RULE CHAR(1) No No
VAT_APPLICABILITY CHAR(1) No No
TAX_CD_VAT CHAR(8) No No
TAX_CD_VAT_PCT DECIMAL(7,4) No No
VAT_TXN_TYPE_CD CHAR(4) No No
VAT_USE_ID CHAR(6) No No
VAT_RCVRY_PCT_SRC CHAR(1) No No
VAT_REBATE_PCT_SRC CHAR(1) No No
VAT_RECOVERY_PCT DECIMAL(5,2) No No
VAT_REBATE_PCT DECIMAL(5,2) No No
VAT_NRCVR_PRO_FLG CHAR(1) No No
VAT_NRCVR_ALL_FLG CHAR(1) No No
VAT_RPTG_CURR_FLG CHAR(1) No No
CURRENCY_RPTG CHAR(3) No No
VAT_INV_AMT_RPTG DECIMAL(26,3) No No
VAT_TRANS_AMT_RPTG DECIMAL(26,3) No No
RATE_MULT_VAT DECIMAL(15,8) No No
RATE_DIV_VAT DECIMAL(15,8) No No
VAT_AMT DECIMAL(26,3) No No
VAT_AMT_BSE DECIMAL(26,3) No No
VAT_BASIS_AMT DECIMAL(26,3) No No
VAT_BASIS_AMT_BSE DECIMAL(26,3) No No
VAT_ENTRD_AMT DECIMAL(26,3) No No
VAT_ENTRD_AMT_BSE DECIMAL(26,3) No No
VAT_CALC_AMT DECIMAL(26,3) No No
VAT_CALC_AMT_BSE DECIMAL(26,3) No No
VAT_RCVRY_AMT DECIMAL(26,3) No No
VAT_RCVRY_AMT_BSE DECIMAL(26,3) No No
VAT_REBATE_AMT DECIMAL(26,3) No No
VAT_REBATE_AMT_BSE DECIMAL(26,3) No No
BANK_SETID char(5) No Yes
BANK_CD CHAR(5) No Yes
PHYSICAL_NATURE CHAR(1) No No
VAT_TREATMENT CHAR(4) No No
COUNTRY_VAT_SUPPLY CHAR(3) No No
STATE_VAT_SUPPLY CHAR(6) No No
STATE_VAT_DEFAULT CHAR(6) No No
VAT_DFLT_DONE_FLG CHAR(1) No No
VAT_EXCPTN_TYPE CHAR(1) No No
VAT_EXCPTN_CERTIF CHAR(20) No No
COUNTRY_BANK CHAR(3) No No
Index
Name Type Unique Member
PS_TRV_VAT_TRAN PK Yes
Member(s) of "PS_TRV_VAT_TRAN" Index
BUSINESS_UNIT
TR_SOURCE_CD
TR_SOURCE_ID
EVENT_ID
TRANSACTION_DT
SEQ_NBR
TRANSACTION_LEG
ACCTG_EVENT_TYPE
BANK_ACCOUNT_NUM
TRAN_REF_ID
ACCTG_TMPL_ID
ACCTG_TMPL_LINE

Published April 30, 2007