PeopleSoft 9.0
Cash Management

Table Name VAT_ACCT_TBL

Table Description
VAT_ACCT_TBL
Columns
Name Datatype Is PK Is FK
SETID CHAR(5) Yes Yes
TAX_CD CHAR(8) Yes Yes
VAT_DST_ACCT_TYPE CHAR(4) Yes Yes
VAT_TXN_TYPE_CD CHAR(4) Yes No
ACCOUNT CHAR(10) No No
ALTACCT CHAR(10) No No
DEPTID CHAR(10) No No
OPERATING_UNIT CHAR(8) No No
PRODUCT CHAR(6) No No
FUND_CODE CHAR(5) No No
CLASS_FLD CHAR(5) No No
PROGRAM_CODE CHAR(5) No No
BUDGET_REF CHAR(8) No No
AFFILIATE CHAR(5) No No
AFFILIATE_INTRA1 CHAR(10) No No
AFFILIATE_INTRA2 CHAR(10) No No
CHARTFIELD1 CHAR(10) No No
CHARTFIELD2 CHAR(10) No No
CHARTFIELD3 CHAR(10) No No
DISTRIB_LINE_NUM INT No No
PROJECT_ID CHAR(15) No No
Index
Name Type Unique Member
XPKVAT_ACCT_TBL PK Yes
PS_VAT_ACCT_TBL AK1 Yes
Member(s) of "XPKVAT_ACCT_TBL" Index
SETID
TAX_CD
VAT_DST_ACCT_TYPE
VAT_TXN_TYPE_CD
Member(s) of "PS_VAT_ACCT_TBL" Index
SETID
TAX_CD
VAT_DST_ACCT_TYPE
VAT_TXN_TYPE_CD

Published April 30, 2007