SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PRODUCT_IDPrompt Table: PROD_ITEM
PRIORITY_NBRDefault Value: 1
UNIT_MEASURE_ORDPrompt Table: %EDITTABLE
Default Value: 1
Y/N Table Edit
Default Value: Y
Default Value: %date
ORD_PRODALT2_VW(SQL View) |
Index Back |
|---|---|
Product Alt Priority-nonstk |
| SELECT A.SETID ,A.PRODUCT_ID ,A.PRIORITY_NBR ,B.UNIT_OF_MEASURE ,A.PRODUCT_ID_ALT ,A.QTY_PER ,A.INTERCHANGABLE ,A.START_DT ,A.END_DT FROM PS_MASTER_ITEM_TBL M, PS_PROD_UOM B, PS_PROD_ITEM P, PS_PROD_ALT A WHERE P.SETID = A.SETID AND P.PRODUCT_ID = A.PRODUCT_ID_ALT AND B.SETID = A.SETID AND B.PRODUCT_ID = A.PRODUCT_ID_ALT AND M.SETID = P.SETID AND M.INV_ITEM_ID = P.INV_ITEM_ID AND M.INVENTORY_ITEM = 'N' AND P.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PROD_ITEM |
| 3 | PRIORITY_NBR |
Number(3,0) | SMALLINT NOT NULL |
Priority
Default Value: 1 |
| 4 | UNIT_MEASURE_ORD |
Character(3) | VARCHAR2(3) NOT NULL | Ordering UOM |
| 5 | PRODUCT_ID_ALT | Character(18) | VARCHAR2(18) NOT NULL |
Alternate Product ID
Prompt Table: %EDITTABLE |
| 6 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL |
Quantity
Default Value: 1 |
| 7 | INTERCHANGABLE | Character(1) | VARCHAR2(1) NOT NULL |
Interchangeable
Y/N Table Edit Default Value: Y |
| 8 | START_DT | Date(10) | DATE NOT NULL |
Start Date
Default Value: %date |
| 9 | END_DT | Date(10) | DATE NOT NULL | End Date |