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