SRBT_PRCS_TMP(SQL Table) |
Index Back |
|---|---|
Rebates/Penalties Price Temp TRebates/Penalties Price Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | SRBT_ID | Character(6) | VARCHAR2(6) NOT NULL | Sales Rebate ID |
| 4 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 5 | COMPARE_TO_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Compare To Criteria
F=Fixed Amount/Quantity P=Previous Period S=Same Period Last Year |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | PRC_BREAK_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date O=Order Date S=Schedule Ship Date |
| 11 | REBATE_ID | Character(6) | VARCHAR2(6) NOT NULL | Rebate ID |
| 12 | PENALTY_ID | Character(6) | VARCHAR2(6) NOT NULL | Penalty ID |
| 13 | SRBT_AMOUNT | Number(16,2) | DECIMAL(15,2) NOT NULL | Compare Amount |
| 14 | SRBT_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Compare Quantity |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |