BI_RUN_INVOICE(SQL Table) |
Index Back |
|---|---|
Record for BUselection for XML |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Request ID | |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_BI_NONVW |
| 6 | IVC_PRINTED_DT | Date(10) | DATE | Invoice Printed Date |
| 7 | RETRANSMIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Y implies re-transmission of invoices
N implies a new transmission or a re-run of the Publish Outbound Message
Y/N Table Edit Default Value: N |
| 8 | CONSOLIDATED | Character(1) | VARCHAR2(1) NOT NULL |
C implies a Consolidated Invoice
N implies a Non-consolidated Invoice
C=Consolidated N=Non-Consolidated Default Value: N |
| 9 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 10 | FROM_INVOICE | Character(30) | VARCHAR2(30) NOT NULL | From Invoice Number |
| 11 | TO_INVOICE | Character(30) | VARCHAR2(30) NOT NULL | To Invoice Number |