RUN_BI_EIVC(SQL Table) |
Index Back |
|---|---|
Create e-inv file run recordCreate electronic invoice file run control record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | RECREATE_FILE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag that indicates whether the federal highway extract file is to be recreated. |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 5 | FROM_INVOICE | Character(30) | VARCHAR2(30) NOT NULL |
From Invoice Number
Prompt Table: BI_EIVC_INV_VW |
| 6 | TO_INVOICE | Character(30) | VARCHAR2(30) NOT NULL |
To Invoice Number
Default Value: RUN_BI_EIVC.FROM_INVOICE Prompt Table: BI_EIVC_INV_VW |
| 7 | FROM_CUSTOMER_ID | Character(15) | VARCHAR2(15) NOT NULL |
From Customer ID
Prompt Table: BI_EIVC_CUS_VW |
| 8 | TO_CUSTOMER_ID | Character(15) | VARCHAR2(15) NOT NULL |
To Customer ID
Default Value: RUN_BI_EIVC.FROM_CUSTOMER_ID Prompt Table: BI_EIVC_CUS_VW |
| 9 | SERVERNAME | Character(8) | VARCHAR2(8) NOT NULL |
Server Name
Prompt Table: PYCYCL_SERVERS |
| 10 | OUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Process Scheduler Output Destination |
| 11 | SELECTION_GRP_LBL | Character(1) | VARCHAR2(1) NOT NULL | Selection Options |