OMBI_PROCESS

(SQL Table)
Index Back

OM Bill Process

This record keeps track of the Populate Billing background process when it is run from Order Management.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

5 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

8 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
9 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
10 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
11 POST_SHIP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cancel Instance
12 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
13 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance
14 INTFC_OM_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status