RUN_OM_DEL_FRT

(SQL Table)
 Index Back

OM Demand Interface

Date Init. Issue # Description 120701 dms ADA 508 Set default for business unit 052504 twh F-KNANN-V59N4 Fulfillment Redesign

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

Prompt Table: SP_BU_OM_NONVW

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

Prompt Table: SP_BUIN_NONVW

6 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: OM_DELFR_ORD_VW

7 ORDER_NO_TO Character(10) VARCHAR2(10) NOT NULL To Order No

Prompt Table: OM_DELFR_ORD_VW

8 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

Prompt Table: OMH_SRC_PR_VW
Set Control Field: BUSINESS_UNIT_OM

9 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID_VW
Set Control Field: BUSINESS_UNIT_OM

10 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD_VW
Set Control Field: BUSINESS_UNIT_OM

11 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHP_A1_VW
Set Control Field: BUSINESS_UNIT_OM

12 FROM_SCH_ARRV_DATE Date(10) DATE From Scheduled Arrival Date
13 FROM_SCH_SHIP_DATE Date(10) DATE From Scheduled Ship Date
14 TO_SCH_ARRV_DATE Date(10) DATE Prompt for schedule arrival date
15 TO_SCH_SHIP_DATE Date(10) DATE To Scheduled Ship Date
16 DEL_VALIDATE_OPT Character(2) VARCHAR2(2) NOT NULL Delivery validation option
10=Validate Only
20=Validate/Assign to New
30=Validate/Auto Assign Open
40=Validate/Auto Assign All
50=Reassign/Consolidate
60=Do Not Validate

Default Value: 30

17 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code

Prompt Table: IN_FRT_DFLT

18 RESEND_FRT_RQST Character(1) VARCHAR2(1) NOT NULL 02/02/09 EGS: Created

Y/N Table Edit

Default Value: N

19 RESEND_FRT_RECV Character(1) VARCHAR2(1) NOT NULL 02/02/09 EGS: Created

Y/N Table Edit

Default Value: N

20 RUN_FREIGHT Character(1) VARCHAR2(1) NOT NULL Perform Freight

Y/N Table Edit

Default Value: N