BUSINESS_UNITORDER_NODELIVERY_IDLANGUAGE_CDOM_RCPT_FR_LANG(SQL View) |
Index Back |
|---|
| SELECT E.BUSINESS_UNIT , E.ORDER_NO , E.DELIVERY_ID , PL.LANGUAGE_CD , PL.DESCR FROM %Table(IN_DELIVERY_ORD) E , %Table(PROD_ITEM) P , %Table(PROD_ITEM_LNG) PL , %Table(SET_CNTRL_REC) SC , PS_IN_DELIVERY D WHERE E.SOURCE_BUS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'FS_18' AND SC.RECNAME = 'PROD_ITEM' AND P.SETID = SC.SETID AND P.PRODUCT_ID = E.IDENTIFIER AND P.SETID = PL.SETID AND P.PRODUCT_ID = PL.PRODUCT_ID AND E.FREIGHT_CHARGE_CNV <> 0 AND E.FREIGHT_APP = 'OM' AND E.SHIP_ID = ' ' AND D.BUSINESS_UNIT = E.BUSINESS_UNIT AND D.DELIVERY_ID = E.DELIVERY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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 |
| 3 | DELIVERY_ID |
Character(10) | VARCHAR2(10) NOT NULL | Delivery ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |