PW_FORMULA(SQL Table) |
Index Back |
|---|---|
Price FormulaPrice Formula |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | PW_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 3 | PW_FORMULA_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Pricing Formula ID |
| 4 | ADJUSTMENT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment Percent |
| 5 | BEG_ORDER_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 6 | END_ORDER_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 7 | BEG_REQ_ARR_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 8 | END_REQ_ARR_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 9 | BEG_SCH_SHP_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 10 | END_SCH_SHP_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 11 | BREAK_QTY_LOW | Number(15,4) | DECIMAL(14,4) NOT NULL | Low Quantity/Amount |
| 12 | BREAK_QTY_HIGH | Number(15,4) | DECIMAL(14,4) NOT NULL |
Upper Quantity/Amount
Default Value: 9999999999 |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 14 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 15 | DATE_END | Date(10) | DATE | End Date |
| 16 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 17 | PRODUCT_ID_PROMO | Character(18) | VARCHAR2(18) NOT NULL |
Product ID Promotion
Prompt Table: PROD_ITEM |
| 18 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: %EDITTABLE |
| 19 | PW_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 20 | PW_ADJUST_BILL_INV | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back OI=Off-Invoice Default Value: OI |
| 21 | PW_FREEBIE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Pricing giveaway type.
LINE=Per Line ORD=Per Order |
| 22 | PW_MAX_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Maximum Amount |
| 23 | PW_MAX_PERCENT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Maximum percent adjustment |
| 24 | PW_MIN_AMOUNT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Minimum Amount |
| 25 | PW_MIN_PERCENT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Minimum percent adjustment |
| 26 | PW_MAX_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 27 | PW_MIN_PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 28 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 29 | TAKE_ADJUSTMENT | Character(1) | VARCHAR2(1) NOT NULL |
Take Adjustment
Y/N Table Edit Default Value: Y |
| 30 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDITTABLE2 |
| 31 | UOM_PROMO | Character(4) | VARCHAR2(4) NOT NULL |
Unit of Measure (promo prod)
Prompt Table: PROD_UOM_PRC_VW |
| 32 | DTTIME_ADDED | DateTime(26) | TIMESTAMP | Date Time Added |
| 33 | DTTIME_LAST_MAINT | DateTime(26) | TIMESTAMP |
Date Time Last Maintained
Default Value: %DATETIME |
| 34 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |