RUN_OM_BILLING

(SQL Table)
Index Back

OM Billing Interface

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_BI_NONVW

5 BUSINESS_UNIT_TO Character(5) VARCHAR2(5) NOT NULL 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT

Prompt Table: SP_BU_BI_NONVW

6 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

Prompt Table: SP_BU_OM_NONVW

7 BUSINESS_UNIT_OMTO Character(5) VARCHAR2(5) NOT NULL To Order Management Unit

Prompt Table: SP_BU_OM_NONVW

8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUIN_NONVW

9 BUSINESS_UNIT_INTO Character(5) VARCHAR2(5) NOT NULL To Inventory Business Unit

Prompt Table: SP_BUIN_NONVW

10 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

Prompt Table: CUST_SLD_VW

11 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A1_VW

12 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

Prompt Table: %EDIT_RUN_OMBIL

13 POST_SHIP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cancel Instance
14 RESTART_PI Number(10,0) DECIMAL(10) NOT NULL Restart Process Instance

Prompt Table: OMBI_PRC_VW

15 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
16 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
17 PAID_ORDERS_FLG Character(1) VARCHAR2(1) NOT NULL Paid Orders Flag.

Y/N Table Edit

Default Value: N

18 ADD_DT Date(10) DATE Customer Added On
19 NULL_DATE Date(10) DATE Date field with NULL value
20 NULL_DTTM DateTime(26) TIMESTAMP Null Date Time