OPRIDRUN_CNTL_IDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
Prompt Table: STL_SCHEDULE_VW
NET_AUTO_RQST(SQL Table) |
Index Back |
|---|---|
Automatic Netting SelectionThis record is used as the run control record to Automatic Netting Selection. Business Unit field was added to this table to derive SETID and subsequently Auto Generated Net_ref_id. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | DUE_DT_START | Date(10) | DATE NOT NULL | Start Due Date |
| 4 | DUE_DT_END | Date(10) | DATE NOT NULL | End Due Date |
| 5 | NETTING_DATE | Date(10) | DATE NOT NULL | Netting Date. Used to Define the date that the netting will take place. |
| 6 | NETTING_STL_DATE | Date(10) | DATE NOT NULL | Netting Settlement Date. This date becomes the due date of the Netting Balance for AP and AR transactions. |
| 7 | STL_NETSCHED_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 8 | SCHEDULE | Character(10) | VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table: STL_SCHEDULE_VW |