PW_RULE(SQL Table) |
Index Back |
|---|---|
Price RuleA price rule is the combination of a Price Condition and a Price Formula. This is the entity that the pricing manager creates. |
| # | 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 Prompt Table: SP_SETID_NONVW |
| 2 | PW_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 3 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table: %EDITTABLE6 |
| 6 | PRICEPGM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Exclusive Pricing Only
N=No Y=Yes |
| 7 | PRICE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Pricing type
P=Extended Price Q=Quantity V=Volume W=Weight Default Value: Q |
| 8 | PW_ACTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Action Type
Default Value: 1 |
| 9 | PW_APP_CD | Character(4) | VARCHAR2(4) NOT NULL | Transaction Code |
| 10 | PW_ADJ_METHOD | Character(1) | VARCHAR2(1) NOT NULL | Adjustment Method |
| 11 | PW_KEY_CD | Character(50) | VARCHAR2(50) NOT NULL | Rule Key Code |
| 12 | PW_ORD_DT_PROC | Character(1) | VARCHAR2(1) NOT NULL |
Arbitration Date
Default Value: 1 |
| 13 | PW_PTD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Period To Date flag
Default Value: N |
| 14 | PW_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Rule Status
D=Deployed I=Inactive P=Pending R=Ready To Test Default Value: P |
| 15 | PW_STOP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stop Processing
Default Value: N |
| 16 | PW_TD_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Period to date pricing |
| 17 | PW_USE_GRC_DAYS | Character(1) | VARCHAR2(1) NOT NULL |
Use Grace Days
Default Value: N |
| 18 | PW_LONG | Long Character | CLOB | Price Rule |
| 19 | DTTIME_ADDED | DateTime(26) | TIMESTAMP | Date Time Added |
| 20 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 21 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |