SETIDDefault Value: PC_TIER_TPL_SEQ.SETID
Prompt Table: SP_SETID_NONVW
TIER_TEMPLATEDefault Value: PC_TIER_TPL_SEQ.TIER_TEMPLATE
SEQ_NBRPC_TRANS_IDPrompt Table: PC_TRANS_ID
LINE_NODefault Value: 1
PC_TIER_TPL_BRK(SQL Table) |
Index Back |
|---|---|
Tiered Pricing Template BreaksTiered Pricing Template for quantity range breaks. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: PC_TIER_TPL_SEQ.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TIER_TEMPLATE |
Character(15) | VARCHAR2(15) NOT NULL |
Tiered Pricing Template
Default Value: PC_TIER_TPL_SEQ.TIER_TEMPLATE |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | PC_TRANS_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Transaction Identifier
Prompt Table: PC_TRANS_ID |
| 5 | LINE_NO |
Number(3,0) | SMALLINT NOT NULL |
Line Number
Default Value: 1 |
| 6 | PC_BREAK_QTY_LOW | Number(15,2) | DECIMAL(14,2) NOT NULL | Low Quantity/Amount |
| 7 | PC_BREAK_QTY_HIGH | Number(15,2) | DECIMAL(14,2) NOT NULL | Upper Quantity/Amount |
| 8 | ADJUSTMENT_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Adjustment Percent |