PeopleSoft 9
Asset Management

Table Name AM_VAT_TRANS

Table Description
AM_VAT_TRANS
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
BOOK char(10) Yes Yes
DTTM_STAMP PSDATETIME Yes Yes
VAT_ENTITY char(20) No No
ASSET_CLASS char(10) No No
VAT_APPLICABILITY char(1) No No
VAT_CALC_TYPE char(1) No No
VAT_TXN_TYPE_CD char(4) No No
TAX_CD_VAT char(8) No No
VAT_DCLRTN_DT PSDATE No No
VAT_BASIS_AMT decimal(26,3) No No
VAT_BASIS_AMT_BSE decimal(26,3) No No
VAT_DISTRIB_STATUS char(1) No No
TAX_CD_VAT_PCT decimal(7,4) No No
VAT_AMT decimal(26,3) No No
VAT_AMT_BSE decimal(26,3) No No
TXN_CURRENCY_CD 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_DST_ACCT_TYPE char(4) No No
VAT_TRANS_AMT decimal(26,3) No No
VAT_TRANS_AMT_BSE decimal(26,3) No No
VAT_ROUND_RULE char(1) No No
VAT_CALC_TXN_ID char(22) No No
PROCESS_INSTANCE decimal(10) No No
COUNTRY_VAT_BILLFR char(3) No No
COUNTRY_VAT_BILLTO char(3) No No
PHYSICAL_NATURE char(1) No No
VAT_CALC_GROSS_NET char(1) No No
VAT_DCLRTN_DT_SRC char(1) No No
VAT_DCLRTN_POINT char(1) No No
VAT_EXCPTN_CERTIF char(20) No No
VAT_EXCPTN_TYPE char(1) No No
VAT_RECALC_FLG char(1) No No
VAT_RGSTRN_BUYER char(12) No No
VAT_RGSTRN_SELLER char(12) No No
VAT_TREATMENT char(4) No No
VAT_TREATMENT_GRP char(4) No No
CATEGORY_ID char(5) No No
STATE_VAT_DEFAULT char(6) No No
COUNTRY_SHIP_FROM char(3) No No
COUNTRY_SHIP_TO char(3) No No
STATE_SHIP_FROM char(6) No No
STATE_SHIP_TO char(6) No No
Index
Name Type Unique Member
PS_AM_VAT_TRANS PK Yes
Member(s) of "PS_AM_VAT_TRANS" Index
BUSINESS_UNIT
ASSET_ID
BOOK
DTTM_STAMP

Published December 16, 2006