PeopleSoft 9.0
Cash 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
XPKGL_ACCOUNT_TBL PK Yes
PS_GL_ACCOUNT_TBL AK1 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 "XPKGL_ACCOUNT_TBL" Index
SETID
ACCOUNT
EFFDT
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 April 30, 2007