CONTRACT_NUMDefault Value: PC_TIER.CONTRACT_NUM
CONTRACT_LINE_NUMDefault Value: PC_TIER.CONTRACT_LINE_NUM
SEQ_NBRPC_TRANS_IDPrompt Table: PC_TRANS_ID
LINE_NODefault Value: 1
PC_TIER_DTL(SQL Table) |
Index Back |
|---|---|
Tiered Pricing Line DetailTiered Pricing detail with tier break ranges and adjustment percentages. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Default Value: PC_TIER.CONTRACT_NUM |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Default Value: PC_TIER.CONTRACT_LINE_NUM |
| 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 |