ACCOUNTBS=Balance Sheet
OB=Off Balance Sheet
IU_ACCTALL_VW(SQL View) |
Index Back |
|---|---|
View of all account RLR |
| SELECT A.ACCOUNT ,L.DESCR ,L.LANGUAGE_CD ,A.STATISTICS_ACCOUNT ,A.SETID ,A.BAL_SHEET_IND ,A.BOOK_CODE FROM PS_GL_ACCOUNT_TBL A ,PS_GL_ACCOUNT_LANG L WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GL_ACCOUNT_TBL B WHERE A.SETID = B.SETID AND A.ACCOUNT = B.ACCOUNT AND B.EFFDT <= %CurrentDateIn) AND L.SETID = A.SETID AND L.ACCOUNT = A.ACCOUNT AND L.EFFDT = A.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | STATISTICS_ACCOUNT | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a general ledger account is used to track statistical amounts rather than monetary amounts. Statistical amounts represent information such as square footage, head count, or number of units. A unit of measure (UNIT_OF_MEASURE) must be specified with a statistical account. |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | BAL_SHEET_IND | Character(2) | VARCHAR2(2) NOT NULL |
Balance Sheet Indicator
BS=Balance Sheet OB=Off Balance Sheet |
| 7 | BOOK_CODE | Character(4) | VARCHAR2(4) NOT NULL | Book Code |