ORD_SCHD_EC_SRC(SQL View) |
Index Back |
|---|---|
Order Schedule LineThis record is the child of ORD_LINE. It holds all the delivery information for the order line. It also allows multiple schedules per order line so that an order line quantity may be broken out into multiple shipments on different dates, to different destinations from different warehouses. Date Initials Issue Description 091301 dms F-CJORGENS-11 Add REASON_CD |
| SELECT EIP_PROGRAM , EIP_CTL_ID , ORDER_INT_LINE_NO , SCHED_LINE_NBR , EIP_DTA_STATUS , BUSINESS_UNIT , ORDER_NO , SHIP_TO_CUST_ID , CUSTOMER_PO_SCHED FROM PS_ORD_SCHEDULE_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
Default Value: 1 |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | 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 |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 7 | 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 |
| 8 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: CUST_SLDSHP1_VW |
| 9 | CUSTOMER_PO_SCHED | Character(11) | VARCHAR2(11) NOT NULL | Customer PO Schedule |