BI_HDR_MULTISEL

(SQL Table)
Index Back

Invoice Multi-Select List

For use by components like WorkCenter to store the invoices that were selected to be processed in batch. For use by batch programs.

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_BI_NONVW

4 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

Prompt Table: BI_HDR

5 BI_PROCESS_SOURCE Character(2) VARCHAR2(2) NOT NULL Process Source
1=WorkCenter
6 ADD_DT Date(10) DATE Customer Added On