CB_PROFIT_STG

(SQL Table)
Index Back

CB- Profitability Stage

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
8 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
9 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
10 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
13 NET_SALES Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Sales
14 REV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Reveune Amount
15 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
16 UNIT_COST_ALT Signed Number(16,4) DECIMAL(14,4) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks
17 CB_TOTAL_PADDING Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Padding
18 CB_AMOUNT Number(27,3) DECIMAL(26,3) NOT NULL Total Claim
19 CB_GP_PERCENT Signed Number(7,2) DECIMAL(5,2) NOT NULL Gross Profit Percent
20 CB_GP_PCT_REAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Gross Profit Percent Real
21 CB_GP_PCT_ACTUAL Signed Number(7,2) DECIMAL(5,2) NOT NULL Gross Profit Percent Actual
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
23 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure