BUSINESS_UNITSRBT_IDF=Fixed Amount/Quantity
P=Previous Period
S=Same Period Last Year
A=Requested Arrival Date
O=Order Date
S=Schedule Ship Date
A=Active
C=Closed
H=Hold
X=Cancelled
SRBT_VW(SQL View) |
Index Back |
|---|---|
Sales Rebate Calendar ViewView for OMSRBT.SQR |
| SELECT a.business_unit , a.srbt_id , a.calendar_id , a.compare_to_crit , a.descr , a.descrshort , a.start_date , a.end_date , a.prc_break_date , a.rebate_id , a.penalty_id , a.srbt_amount , a.srbt_qty , a.currency_cd , b.number_of_periods ,a.srbt_status FROM PS_SRBT_TBL a , ps_cal_defn_tbl b , ps_set_cntrl_rec s WHERE a.calendar_id = b.calendar_id AND b.setid = s.setid AND s.setcntrlvalue = a.business_unit AND s.recname = 'CAL_DEFN_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SRBT_ID |
Character(6) | VARCHAR2(6) NOT NULL | Sales Rebate ID |
| 3 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL | Calendar ID |
| 4 | COMPARE_TO_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Compare To Criteria
F=Fixed Amount/Quantity P=Previous Period S=Same Period Last Year |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_DATE | Date(10) | DATE | End Date |
| 9 | PRC_BREAK_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Price Break Date Type
A=Requested Arrival Date O=Order Date S=Schedule Ship Date |
| 10 | REBATE_ID | Character(6) | VARCHAR2(6) NOT NULL | Rebate ID |
| 11 | PENALTY_ID | Character(6) | VARCHAR2(6) NOT NULL | Penalty ID |
| 12 | SRBT_AMOUNT | Number(16,2) | DECIMAL(15,2) NOT NULL | Compare Amount |
| 13 | SRBT_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Compare Quantity |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | NUMBER_OF_PERIODS | Number(3,0) | SMALLINT NOT NULL | Periods in a Year |
| 16 | SRBT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Sales Rebate Status
A=Active C=Closed H=Hold X=Cancelled |