BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_OM
ORDER_NOORDER_INT_LINE_NOLANGUAGE_CDORD_LINE_LANG(SQL View) |
Index Back |
|---|---|
Order Line PricingRelated languge View for the pricing views at the line level |
| SELECT L.BUSINESS_UNIT , L.ORDER_NO , L.ORDER_INT_LINE_NO , P.LANGUAGE_CD , P.DESCR FROM PS_ORD_LINE L , PS_PROD_ITEM_LNG P , PS_SET_CNTRL_REC SC WHERE L.PRODUCT_ID = P.PRODUCT_ID AND L.BUSINESS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'FS_18' AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = P.SETID AND P.PRODUCT_ID = L.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_OM |
| 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 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |