BI_RUN_INVOICE

(SQL Table)
Index Back

Record for BUselection for XML

# 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 REQUEST_ID 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