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 |