DD_WORKSHEET_IDDD_RQST_SEQUENCEPrompt Table:
SP_BUARDS_NONVW
Set Control Field: BUSINESS_UNIT
Default Value: N
Default Value: N
DD_WORKSHEET(SQL Table) |
Index Back |
|---|---|
Direct Debit Request Group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DD_WORKSHEET_ID |
Number(10,0) | DECIMAL(10) NOT NULL | DD Worksheet Id |
| 2 | DD_RQST_SEQUENCE |
Number(5,0) | INTEGER NOT NULL | Request Sequence Number |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BUARDS_NONVW
|
| 5 | LAST_RUN_DTM | DateTime(26) | TIMESTAMP | Last Run On |
| 6 | DD_EFT_SW | Character(1) | VARCHAR2(1) NOT NULL |
EFT File Created
Default Value: N |
| 7 | DD_REMIT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Direct Debit Remitted Switch
Default Value: N |