SRBT_CUST_TMP

(SQL Table)
Index Back

OMSRBT temp table

This is a working temporary table for SQR OMSRBT. Is contains customer info for each rebate calculation.

# 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
5 START_DATE Date(10) DATE Start Date for Gen Standing PO
6 END_DATE Date(10) DATE End Date
7 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime
8 ENDDATETIME DateTime(26) TIMESTAMP End Datetime
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 RBT_PNLTY_ORD_TYPE Character(1) VARCHAR2(1) NOT NULL Qualified Orders
A=All Orders
I=Invoiced Orders
13 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
14 COMPARE_TO_CRIT Character(1) VARCHAR2(1) NOT NULL Compare To Criteria
F=Fixed Amount/Quantity
P=Previous Period
S=Same Period Last Year
15 SRBT_AMOUNT Number(16,2) DECIMAL(15,2) NOT NULL Compare Amount
16 SRBT_QTY Number(16,4) DECIMAL(15,4) NOT NULL Compare Quantity
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
18 CALC_PERIODS Character(1) VARCHAR2(1) NOT NULL Calculation Periods
C=Current Period
L=Previous Period
P=Current and Previous Period
19 SETID Character(5) VARCHAR2(5) NOT NULL SetID