PeopleSoft 9
Asset Management

Table Name GL_ACCOUNT_TBL

Table Description
GL_ACCOUNT_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
ACCOUNT char(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
DESCRSHORT char(10) No No
BUDG_OVERRIDE_ACCT char(1) No No
ACCOUNTING_OWNER char(30) No No
AB_ACCOUNT_SW char(1) No No
GL_ACCOUNT_SW char(1) No No
PF_ACCOUNT_SW char(1) No No
ACCOUNT_TYPE char(1) No No
UNIT_OF_MEASURE char(3) No No
OPEN_ITEM char(1) No No
OPEN_ITEM_DESCR char(10) No No
OPEN_ITEM_EDIT_REC char(15) No No
OPEN_ITEM_EDIT_FLD char(18) No No
OPEN_ITEM_PROMPT char(15) No No
OPEN_ITEM_TOL_AMT decimal(26,3) No No
CURRENCY_CD char(3) No No
STATISTICS_ACCOUNT char(1) No No
BALANCE_FWD_SW char(1) No No
CONTROL_FLAG char(1) No No
BOOK_CODE char(4) No No
BOOK_CODE_OVERRIDE char(1) No No
BAL_SHEET_IND char(2) No No
VAT_ACCOUNT_FLG char(1) No No
PHYSICAL_NATURE char(1) No No
BUDGETARY_ONLY char(1) No No
KK_OVERRIDE_ACCT char(1) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_GL_ACCOUNT_TBL PK Yes
PS0GL_ACCOUNT_TBL IE1 No
PS1GL_ACCOUNT_TBL IE2 No
PSAGL_ACCOUNT_TBL IE3 No
PSBGL_ACCOUNT_TBL IE4 No
PSCGL_ACCOUNT_TBL IE5 No
PSDGL_ACCOUNT_TBL IE6 No
PSEGL_ACCOUNT_TBL IE7 No
PSFGL_ACCOUNT_TBL IE8 No
Member(s) of "PS_GL_ACCOUNT_TBL" Index
SETID
ACCOUNT
EFFDT
Member(s) of "PS0GL_ACCOUNT_TBL" Index
DESCR
SETID
ACCOUNT
EFFDT
Member(s) of "PS1GL_ACCOUNT_TBL" Index
ACCOUNT_TYPE
SETID
ACCOUNT
EFFDT
Member(s) of "PSAGL_ACCOUNT_TBL" Index
ACCOUNT
Member(s) of "PSBGL_ACCOUNT_TBL" Index
SETID
EFF_STATUS
OPEN_ITEM
ACCOUNT
EFFDT
Member(s) of "PSCGL_ACCOUNT_TBL" Index
SETID
EFF_STATUS
BUDGETARY_ONLY
ACCOUNT
EFFDT
Member(s) of "PSDGL_ACCOUNT_TBL" Index
SETID
STATISTICS_ACCOUNT
ACCOUNT
EFFDT
Member(s) of "PSEGL_ACCOUNT_TBL" Index
SETID
EFF_STATUS
ACCOUNT
EFFDT
Member(s) of "PSFGL_ACCOUNT_TBL" Index
SYNCID

Published December 16, 2006