ORD_LINE_EC_SRC

(SQL View)
Index Back

OM Ord Line Staging

OM Ord Line Staging Date Initials Issue Description 091301 dms F-CJORGENS-11 Add REASON_CD 101201 dms R-BLOVE-XT8WQ Change product_id, prod_id_entered properties

SELECT EIP_PROGRAM , EIP_CTL_ID , ORDER_INT_LINE_NO , EIP_DTA_STATUS , BUSINESS_UNIT , ORDER_NO , PRODUCT_ID , CUSTOMER_ITEM_NBR , CUSTOMER_PO_LINE , SHIP_TO_CUST_ID FROM PS_ORD_LINE_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync

Prompt Table: OMEC_ALLPROG_VW

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

Prompt Table: OMEC_ALLCTRL_VW

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 EIP_DTA_STATUS Character(1) VARCHAR2(1) NOT NULL EIP Dta status
0=New
1=Error
2=Complete
3=In Process
4=Reprocess
5=Incomplete
6=Cancelled
7=Hold
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_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
7 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

8 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
9 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line
10 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SLDSHP1_VW