PW_RULE_DST(SQL Table) |
Index Back |
|---|---|
Price Rule DistributionPrice Rule D |
| # | 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.
Prompt Table: SP_SETID_NONVW |
| 2 | PW_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Price Rule ID
Prompt Table: PW_RULE |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 4 | PW_ADJUST_BILL_INV |
Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Type Bill-Back or Off-Invoice
AC=Bill Back OI=Off-Invoice |
| 5 | DST_ID_DIS |
Character(10) | VARCHAR2(10) NOT NULL |
Discount Dist Code
Prompt Table: %EDITTABLE3 |
| 6 | DST_ID_SUR |
Character(10) | VARCHAR2(10) NOT NULL |
Surcharge Dist Code
Prompt Table: %EDITTABLE4 |
| 7 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL |
Revenue Dist Code
Prompt Table: %EDITTABLE5 |
| 8 | DST_PCT_DIS | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Discount Dist Percentage |
| 9 | DST_PCT_SUR | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Surcharge Dist Percentage |
| 10 | DST_PCT_REV | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Revenue Dist Percentage |