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 |
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 |