DATE_CODEOI_DATECD_VW(SQL View) |
Index Back |
|---|---|
Date CodeOTBI Date Code View |
| SELECT A.DATE_CODE , A.FIELDNAME , A.DESCR , A.POST_LEDGER , A.POST_LDG_ADB FROM %Table(DATE_CODE_TBL) A UNION SELECT ' ' , '-' , 'Not Available' , '-' , '-' FROM %Table(INSTALLATION) B |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATE_CODE |
Character(1) | VARCHAR2(1) NOT NULL | This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements. |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | POST_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | Post to Ledger |
| 5 | POST_LDG_ADB | Character(1) | VARCHAR2(1) NOT NULL | Post to Ledger ADB |