UNIQUE_IDENTIFIERCHARTFIELDPrompt Table: LED_DRILL_CF_VW
Default Value: %date
JRNL_DRILL_CF(SQL Table) |
Index Back |
|---|---|
RTBL Journal Drill ChartFields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UNIQUE_IDENTIFIER |
Character(36) | VARCHAR2(36) NOT NULL | Generated unique identifier for accessing ledger scenario inquiry drill down criteria. |
| 2 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL |
ChartField
Prompt Table: LED_DRILL_CF_VW |
| 3 | CHARTFIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |
| 4 | CREATE_DATE | Date(10) | DATE |
Creation Date
Default Value: %date |