IN_SW_KITDTL_VW(SQL View) |
Index Back |
|---|
| SELECT A.QTY_PER , A.QTY_CODE , A.QTY_REQUESTED_BASE , A.QTY_ALLOC_BASE , A.QTY_PICK_OVR_BASE , A.QTY_PROMISED_BASE ,A.QTY_BACKORDER_BASE , B.PROMISE_OPTION ,C.SOFT_ALLOC_FLG FROM PS_IN_DEMAND A , PS_MASTER_ITEM_TBL B , PS_DF_SETUP_IT_INV C |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 2 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 3 | QTY_REQUESTED_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested Base |
| 4 | QTY_ALLOC_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity allocation |
| 5 | QTY_PICK_OVR_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items. |
| 6 | QTY_PROMISED_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Promised Base |
| 7 | QTY_BACKORDER_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Backorder Base Qty |
| 8 | PROMISE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Order Promise Option
2=Perform ATP Reservations |
| 9 | SOFT_ALLOC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Soft Reserve |