PPRC_BREAK(SQL Table) |
Index Back |
|---|---|
Price BreaksThis table stores the price breaks for a Product on the Pricing Sets. |
| # | 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 | PRICE_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Price Set ID |
| 3 | BREAK_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Price Break ID
Default Value: 1 |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
Prompt Table: CURRENCY_CD_TBL |
| 5 | 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 |
| 6 | DATE_BEGIN | Date(10) | DATE NOT NULL | Start Date |
| 7 | DATE_END | Date(10) | DATE NOT NULL | End Date |
| 8 | BEG_ORDER_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 9 | END_ORDER_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 10 | BEG_REQ_ARR_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 11 | END_REQ_ARR_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 12 | BEG_SCH_SHP_DT | Date(10) | DATE | View used by the enterprise pricer. |
| 13 | END_SCH_SHP_DT | Date(10) | DATE | Field used by the enterprise pricer integration. |
| 14 | BREAK_QTY_LOW | Number(15,4) | DECIMAL(14,4) NOT NULL | Low Quantity/Amount |
| 15 | BREAK_QTY_HIGH | Number(15,4) | DECIMAL(14,4) NOT NULL | Upper Quantity/Amount |
| 16 | PRICE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | This is price per unit for calculating the service charge. |
| 17 | ADJUSTMENT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment Percent |
| 18 | OM_ADJST_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Adjustment Amount |
| 19 | TAKE_ADJUSTMENT | Character(1) | VARCHAR2(1) NOT NULL |
Take Adjustment
Y/N Table Edit Default Value: Y |
| 20 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 21 | PPRC_ADJUST_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Pricing adjustment type
AC=Bill Back OI=Off-Invoice Default Value: OI |
| 22 | PPRC_FREEBIE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Pricing giveaway type.
LINE=Per Line ORD=Per Order |
| 23 | PRODUCT_ID_PROMO | Character(18) | VARCHAR2(18) NOT NULL |
Product ID Promotion
Prompt Table: PROD_ITEM |
| 24 | 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. |
| 25 | UOM_PROMO | Character(4) | VARCHAR2(4) NOT NULL |
Unit of Measure (promo prod)
Prompt Table: PROD_UOM_PRC_VW |
| 26 | DTTIME_ADDED | DateTime(26) | TIMESTAMP | Date Time Added |
| 27 | DTTIME_LAST_MAINT | DateTime(26) | TIMESTAMP | Date Time Last Maintained |
| 28 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |