RUN_CNTL_SF_UNB(SQL Table) |
Index Back |
|---|---|
Run Cntl for Bill Cancellation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: BUS_UNIT_TBL_SF.BUSINESS_UNIT Prompt Table: BUS_UNIT_TBL_SF |
| 4 | BI_REQ_NBR | Number(10,0) | DECIMAL(10) NOT NULL |
Billing Request Nbr
Default Value: BI_HDR_CANC_VW2.BI_REQ_NBR Prompt Table: BI_HDR_CANC_VW2 |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH_SF |
| 6 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_SF_VW2 |
| 7 | INVOICE_ID | Character(22) | VARCHAR2(22) NOT NULL |
Invoice Number
Default Value: BI_HDR_CANC_VW.INVOICE_ID Prompt Table: %EDITTABLE |
| 8 | BI_CANC_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Run Option
B=Bill Request Nbr C=Invoice ID |
| 9 | BI_CANC_LOG_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Bill Cancellation Log Option
A=Log All Activity C=Log Successful Cancels Only F=Log Failed Cancels only N=None |
| 10 | BI_CANC_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Billing Cancellation Number |