BUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
PW_APP_CDPW_TEST_IDORD_LINE_TAGPW_RULE_IDPW_FORMULA_IDPW_TST_GIVEAWAY(SQL Table) |
Index Back |
|---|---|
Simulator - Giveaways |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | PW_APP_CD |
Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 3 | PW_TEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Simulation ID |
| 4 | ORD_LINE_TAG |
Number(5,0) | INTEGER NOT NULL | Order Line tag for Giveaways Products. Identifies which lines have a giveaway. |
| 5 | PW_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 6 | PW_FORMULA_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Pricing Formula ID |
| 7 | PRODUCT_ID_PROMO | Character(18) | VARCHAR2(18) NOT NULL | Product ID Promotion |
| 8 | UOM_PROMO | Character(4) | VARCHAR2(4) NOT NULL | Unit of Measure (promo prod) |
| 9 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 10 | BREAK_QTY_HIGH | Number(15,4) | DECIMAL(14,4) NOT NULL | Upper Quantity/Amount |
| 11 | BREAK_QTY_LOW | Number(15,4) | DECIMAL(14,4) NOT NULL | Low Quantity/Amount |