OPRIDRUN_CNTL_IDSEQ_NUMDefault Value: 1
C=Reprint
I=Invoice
P=Pro Forma
RUN_BI_PRFRMA(SQL Table) |
Index Back |
|---|---|
Run Proforma control recordUsed in App. Engine program BIIVC100 to denote which invoice to run through. |
| # | 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 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 1 |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 6 | INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Action
C=Reprint I=Invoice P=Pro Forma |
| 7 | CONSOLIDATE | Character(1) | VARCHAR2(1) NOT NULL | Consolidate Headers |
| 8 | ADD_DT | Date(10) | DATE | Customer Added On |