PeopleSoft 9
Account Payables

Table Name ALTACCT_TBL

Table Description
ALTACCT_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
ALTACCT VARCHAR(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
DESCR254 VARCHAR(254) No No
SYSTEM_MAINT_ACCT VARCHAR(1) No No
PAYROLL_ACCOUNT VARCHAR(1) No No
ACCOUNTING_OWNER VARCHAR(30) No No
ACCOUNT_TYPE VARCHAR(1) No No
UNIT_OF_MEASURE VARCHAR(3) No No
OPEN_ITEM VARCHAR(1) No No
OPEN_ITEM_DESCR VARCHAR(10) No No
OPEN_ITEM_EDIT_REC VARCHAR(15) No No
OPEN_ITEM_EDIT_FLD VARCHAR(18) No No
STATISTICS_ACCOUNT VARCHAR(1) No No
BALANCE_FWD_SW VARCHAR(1) No No
CONTROL_FLAG VARCHAR(1) No No
BAL_SHEET_IND VARCHAR(2) No No
BOOK_CODE VARCHAR(4) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_ALTACCT_TBL PK Yes
PS0ALTACCT_TBL IE1 No
PS1ALTACCT_TBL IE2 No
PSAALTACCT_TBL IE3 No
Member(s) of "PS_ALTACCT_TBL" Index
SETID
ALTACCT
EFFDT
Member(s) of "PS0ALTACCT_TBL" Index
DESCR
SETID
ALTACCT
EFFDT
Member(s) of "PS1ALTACCT_TBL" Index
ACCOUNT_TYPE
SETID
ALTACCT
EFFDT
Member(s) of "PSAALTACCT_TBL" Index
SYNCID

Published June 06, 2007