DRAFT_BUDRAFT_IDDTTM_CREATEDDefault Value: %Date
Prompt Table: DR_LOCATION_TBL
DRAFT_NOTES_TBL(SQL Table) |
Index Back |
|---|---|
Draft Notes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DRAFT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. |
| 2 | DRAFT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 3 | DTTM_CREATED |
DateTime(26) | TIMESTAMP |
Datetime Created
Default Value: %Date |
| 4 | ENTERED_DT | Date(10) | DATE | Entered on |
| 5 | ENTERED_TM | Time(15) | TIMESTAMP | Entered Time |
| 6 | DRAFT_LOCATION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Physical Location
Prompt Table: DR_LOCATION_TBL |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |