SETIDPRODUCT_IDASY=Assembly
ORD=Order
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
IN_SW_INVKIT_VW(SQL View) |
Index Back |
|---|
| SELECT ' ' , A.PRODUCT_ID , A.INV_ITEM_ID , A.QTY_PER , A.QTY_CODE , A.UNIT_OF_MEASURE , A.OPTIONAL_SHIP ,' ' ,A.QTY_REQUESTED ,A.DP_KIT_PARENT_UOM ,A.DP_KIT_PARENT_QTY ,A.IN_KIT_PROTECTED FROM PS_IN_DEMAND A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 5 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 6 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 7 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL | OK to Ship Without |
| 8 | UPDATE_IMAGE_BTN | Character(1) | VARCHAR2(1) NOT NULL | Update Image |
| 9 | QTY_REQUESTED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Requested |
| 10 | DP_KIT_PARENT_UOM | Character(3) | VARCHAR2(3) NOT NULL | DP Kit Parent Unit of Measure |
| 11 | DP_KIT_PARENT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Demand Planning Kit Parent Qty |
| 12 | IN_KIT_PROTECTED | Character(1) | VARCHAR2(1) NOT NULL | Kit protected flag |