SETIDPrompt Table: SP_SETID_NONVW
PRICE_SET_IDBUSINESS_UNIT_OMPPRC_ADJUST_TYPEAC=Bill Back
OI=Off-Invoice
Default Value: OI
DST_ID_DISDST_ID_SURPPRC_SET_DST(SQL Table) |
Index Back |
|---|
| # | 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 | PRICE_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Price Set ID |
| 3 | BUSINESS_UNIT_OM |
Character(5) | VARCHAR2(5) NOT NULL | Order Management Business Unit |
| 4 | PPRC_ADJUST_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Pricing adjustment type
AC=Bill Back OI=Off-Invoice Default Value: OI |
| 5 | DST_ID_DIS |
Character(10) | VARCHAR2(10) NOT NULL | Discount Dist Code |
| 6 | DST_ID_SUR |
Character(10) | VARCHAR2(10) NOT NULL | Surcharge Dist Code |
| 7 | DST_ID_REV | Character(10) | VARCHAR2(10) NOT NULL | Revenue Dist Code |
| 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 |