SRBTTBL_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for SRBT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_OM.BUSINESS_UNIT Prompt Table: SP_BU_OM_NONVW |
| 3 | SRBT_ID | Character(6) | VARCHAR2(6) NOT NULL |
Sales Rebate ID
Default Value: NEXT Prompt Table: SRBT_TBL |
| 4 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: CAL_DEFN_TBL |
| 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 Default Value: P |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: SRBT_TBL.DESCR |
| 8 | SRBT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Sales Rebate Status
A=Active C=Closed H=Hold X=Cancelled Default Value: A |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | PRC_BREAK_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date O=Order Date S=Schedule Ship Date Default Value: O |
| 12 | REBATE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Rebate ID
Prompt Table: RBT_PNLTY_TBL |
| 13 | PENALTY_ID | Character(6) | VARCHAR2(6) NOT NULL |
Penalty ID
Prompt Table: RBT_PNLTY_TBL |
| 14 | SRBT_AMOUNT | Number(16,2) | DECIMAL(15,2) NOT NULL | Compare Amount |
| 15 | SRBT_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Compare Quantity |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 17 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |