PRORD_NSTK_DST(SQL View) |
Index Back |
|---|---|
Nonstocked Order Line -Dist.122701 yb R-JKIRSC-XX7CW SQL has been modified. |
| SELECT o.business_unit , o.order_no , o.order_int_line_no , s.sched_line_nbr , p.inv_item_id , o.config_code , p.cost_element , s.currency_cd_base , oh.order_grp , oh.source_cd , oh.sold_to_cust_id , oh.order_date , oh.direct_invoicing , p.inventory_item , o.ord_line_status , oh.ship_partial_ord , s.ship_partial_flag , o.product_id , o.product_id_orig , s.qty_scheduled , s.ship_prior_flag , o.unit_of_measure , p.unit_measure_std , p.non_own_flag , p.physical_nature FROM PS_ORD_SCHEDULE s , ps_ord_header oh , ps_prod_invitem_vw p , ps_ord_line o WHERE p.setid = ( SELECT setid FROM ps_set_cntrl_rec WHERE SETCNTRLVALUE = o.business_unit AND recname = 'PROD_ITEM') AND o.product_id = p.product_id AND (p.inventory_item = 'N' OR s.drop_ship_flag = 'Y' OR oh.bill_only = 'Y') AND oh.business_unit = o.business_unit AND oh.order_no = o.order_no AND oh.order_type_cd = 'SO' AND s.business_unit = o.business_unit AND s.order_no = o.order_no AND s.order_int_line_no = o.order_int_line_no AND s.ord_sch_status = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
| 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 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 7 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 8 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 9 | ORDER_GRP | Character(6) | VARCHAR2(6) NOT NULL | Order Group |
| 10 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 11 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 12 | DEMAND_DATE | Date(10) | DATE | Demand Date |
| 13 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL | Direct Invoicing |
| 14 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 15 | ORD_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Line Status
C=Closed O=Open P=Pending X=Canceled |
| 16 | PARTIAL_ORDER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Partial Orders Can Ship
N=No Y=Yes |
| 17 | PARTIAL_QTY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Partial Qtys Can Ship |
| 18 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 19 | PRODUCT_ID_ORIG | Character(18) | VARCHAR2(18) NOT NULL | Original Product |
| 20 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |
| 21 | SHIP_PRIOR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Ship Prior to Sched Date |
| 22 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 23 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 24 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 25 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |