DP_PUBRLFCITVW3

(SQL View)
 Index Back

DP_PUBRLFCITVW3

DP_PUBRLFCITVW3

SELECT B.DP_PUBLISHNAME , B.DP_PUBLISH_DATE , B.DP_FORECASTITEM , B.DP_FCITEMCAPTION , B.DP_DESCRIPTION , B.DP_CONTROLGROUP , B.DP_SEASONALITYPROF , B.DP_BASEUOM , B.DP_PUBLISHUOM , B.DP_STDUOMCONVFACT , B.DP_WEIGHT , B.DP_WEIGHTUOM , B.DP_VOLUME , B.DP_VOLUMEUOM , B.DP_CONVFACTOR , B.DP_STANDARDCOST , B.DP_STANDARDPRICE , B.DP_AVGPRICE , B.UTILIZ_CD , B.UTILIZ_GROUP , B.DP_FORECASTANALYST , B.DP_STATFOREDEV , B.DP_PRORATEDFOREDEV , B.DP_ADJFOREDEV , B.DP_CURRENTMODELPD , B.DP_CURRENTMODELYR , B.DP_FC_EFFPD , B.DP_FC_EFFYR , B.DP_LIFEPROFILE , B.DP_WEIGHTPROFILE , B.DP_INHIBITED , B.DP_DEMANDAVERAGE , B.DP_KEYFLDNAMES , B.BILL_TO_CUST_ID , B.BUSINESS_UNIT_BI , B.BUSINESS_UNIT_IN , B.BUSINESS_UNIT_OM , B.CATEGORY_ID , B.CORP_CUST_ID , B.CLASSIFICATION , B.CURRENCY_CD , B.CUSTOMER_GROUP , B.CUST_CHANNEL , B.CUST_FIELD_C10_A , B.CUST_FIELD_C10_B , B.CUST_FIELD_C10_C , B.CUST_FIELD_C10_D , B.CUST_FIELD_C1_A , B.CUST_FIELD_C1_B , B.CUST_FIELD_C1_C , B.CUST_FIELD_C1_D , B.CUST_FIELD_C2 , B.CUST_FIELD_C4 , B.CUST_FIELD_C6 , B.CUST_FIELD_C8 , B.CUST_FIELD_C30_A , B.CUST_FIELD_C30_B , B.CUST_FIELD_C30_C , B.CUST_FIELD_C30_D , B.INVOICE , B.INV_ITEM_COLOR , B.INV_ITEM_GROUP , B.INV_ITEM_ID , B.INV_ITEM_TYPE , B.INV_PROD_FAM_CD , B.ITEM_FIELD_C10_A , B.ITEM_FIELD_C10_B , B.ITEM_FIELD_C10_C , B.ITEM_FIELD_C10_D , B.ITEM_FIELD_C1_A , B.ITEM_FIELD_C1_B , B.ITEM_FIELD_C1_C , B.ITEM_FIELD_C1_D , B.ITEM_FIELD_C2 , B.ITEM_FIELD_C4 , B.ITEM_FIELD_C6 , B.ITEM_FIELD_C8 , B.ITEM_FIELD_C30_A , B.ITEM_FIELD_C30_B , B.ITEM_FIELD_C30_C , B.ITEM_FIELD_C30_D , B.MITBL_DESCR , B.PM_DIVISION , B.PM_TERRITORY , B.PM_REGION , B.PRDITM_DESCR , B.PRICE_PROGRAM , B.PROD_BRAND , B.PROD_CATEGORY , B.PROD_FIELD_C10_A , B.PROD_FIELD_C10_B , B.PROD_FIELD_C10_C , B.PROD_FIELD_C10_D , B.PROD_FIELD_C2 , B.PROD_FIELD_C4 , B.PROD_FIELD_C6 , B.PROD_FIELD_C8 , B.PROD_FIELD_C1_A , B.PROD_FIELD_C1_B , B.PROD_FIELD_C1_C , B.PROD_FIELD_C1_D , B.PROD_FIELD_C30_A , B.PROD_FIELD_C30_B , B.PROD_FIELD_C30_C , B.PROD_FIELD_C30_D , B.PRODUCT_ID , B.REGION_CD , B.SHIP_TO_CUST_ID , B.SOLD_TO_CUST_ID , B.SOURCE_CODE , B.SUBCUST_QUAL1 , B.SUBCUST_QUAL2 , B.DP_NEXTLEVELUOM , B.DP_ITEMCODE , B.DP_LOCATION , B.DP_NEXTLEVELCONV , B.DP_EFFDEMANDPDS , B.DP_NEXTFCITEM , B.DP_SUSPENDEDITEM , B.DP_FCMETHOD , B.DP_LIFEPROFILEITEM , B.DP_PRORATE , B.DP_CALCULATIONTYPE , B.DP_USESSEASONPROF , B.DP_DETSEASPROFILE , B.DP_HISTDEMANDPDS , B.DP_PERIODCREATED , B.DP_YEARCREATED , B.DP_LASTRESETPD , B.DP_LASTRESETYR , B.DP_TEMPLATEITEM , B.DP_EVALPERIODS , B.DP_UPDATETOINVPOL , B.DP_AUDITREVIEWDONE , B.DP_ROUNDDECIMALS , B.DP_ROLLBACKPERIODS , B.DP_SEASONALITYTYPE , B.DP_LASTEVALPDS , C.DP_UD01 , C.DP_UD02 , C.DP_UD03 , C.DP_UD04 , C.DP_UD05 , C.DP_UD06 , C.DP_UD07 , C.DP_UD08 , C.DP_UD09 , C.DP_UD10 , C.DP_UD11 , C.DP_UD12 , C.DP_UD13 , C.DP_UD14 , C.DP_UD15 , C.DP_UD16 , C.DP_UD17 , C.DP_UD18 , C.DP_UD19 , C.DP_UD20 , C.DP_UD21 , C.DP_UD22 , C.DP_UD23 , C.DP_UD24 , C.DP_UD25 , C.DP_UD26 , C.DP_UD27 , C.DP_UD28 , C.DP_UD29 , C.DP_UD30 , C.DP_UD31 , C.DP_UD32 , C.DP_UD33 , C.DP_UD34 , C.DP_UD35 , C.DP_UD36 , C.DP_UD37 , C.DP_UD38 , C.DP_UD39 , C.DP_UD40 , C.DP_UD41 , C.DP_UD42 , C.DP_UD43 , C.DP_UD44 , C.DP_UD45 , C.DP_UD46 , C.DP_UD47 , C.DP_UD48 , C.DP_UD49 , C.DP_UD50 , B.PRODUCT_GROUP , B.SETID , B.CM_UNIT_COST , B.CONVERSION_RATE , B.UPC_ID FROM PS_DP_PUB_FCITEMS B , PS_DP_PUB_FCITEMS2 C , PS_DP_PUB_FCAST D WHERE B.DP_PUBLISHNAME = D.DP_PUBLISHNAME AND B.DP_PUBLISH_DATE = D.DP_PUBLISH_DATE AND C.DP_PUBLISHNAME = B.DP_PUBLISHNAME AND C.DP_PUBLISH_DATE = B.DP_PUBLISH_DATE AND C.DP_FORECASTITEM = B.DP_FORECASTITEM

  • Parent record: DP_PUB_FCAST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
    2 DP_PUBLISH_DATE Date(10) DATE NOT NULL DP_PUBLISH_DATE
    3 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM
    4 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION
    5 DP_DESCRIPTION Character(120) VARCHAR2(120) NOT NULL Description
    6 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP
    7 DP_SEASONALITYPROF Character(20) VARCHAR2(20) NOT NULL DP_SEASONALITYPROF

    Prompt Table: DP_SEASPROFILES

    8 DP_BASEUOM Character(3) VARCHAR2(3) NOT NULL DP_BASEUOM

    Prompt Table: UNITS_TBL

    9 DP_PUBLISHUOM Character(3) VARCHAR2(3) NOT NULL DP_PUBLISHUOM
    10 DP_STDUOMCONVFACT Number(17,6) DECIMAL(16,6) NOT NULL DP_STDUOMCONVFACT
    11 DP_WEIGHT Number(13,2) DECIMAL(12,2) NOT NULL DP_WEIGHT
    12 DP_WEIGHTUOM Character(3) VARCHAR2(3) NOT NULL DP_WEIGHTUOM

    Prompt Table: UNITS_TBL

    13 DP_VOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_VOLUME
    14 DP_VOLUMEUOM Character(3) VARCHAR2(3) NOT NULL DP_VOLUMEUOM

    Prompt Table: UNITS_TBL

    15 DP_CONVFACTOR Number(17,6) DECIMAL(16,6) NOT NULL DP_CONVFACTOR
    16 DP_STANDARDCOST Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDCOST
    17 DP_STANDARDPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_STANDARDPRICE
    18 DP_AVGPRICE Number(15,4) DECIMAL(14,4) NOT NULL DP_AVGPRICE
    19 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type
    20 UTILIZ_GROUP Character(4) VARCHAR2(4) NOT NULL Utilization Group
    CYCL=Cycle Count
    21 DP_FORECASTANALYST Character(20) VARCHAR2(20) NOT NULL DP_FORECASTANALYST

    Prompt Table: DP_FORECASTER

    22 DP_STATFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_STATFOREDEV
    23 DP_PRORATEDFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_PRORATEDFOREDEV
    24 DP_ADJFOREDEV Number(21,4) DECIMAL(20,4) NOT NULL DP_ADJFOREDEV
    25 DP_CURRENTMODELPD Number(2,0) SMALLINT NOT NULL DP_CURRENTMODELPD
    26 DP_CURRENTMODELYR Number(4,0) SMALLINT NOT NULL DP_CURRENTMODELYR
    27 DP_FC_EFFPD Number(3,0) SMALLINT NOT NULL DP_FC_EFFPD
    28 DP_FC_EFFYR Number(4,0) SMALLINT NOT NULL DP_FC_EFFYR
    29 DP_LIFEPROFILE Character(10) VARCHAR2(10) NOT NULL DP_LIFEPROFILE
    30 DP_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE

    Prompt Table: DP_WTPROFILES

    31 DP_INHIBITED Character(1) VARCHAR2(1) NOT NULL DP_INHIBITED

    Y/N Table Edit

    Default Value: N

    32 DP_DEMANDAVERAGE Number(13,2) DECIMAL(12,2) NOT NULL DP_DEMANDAVERAGE
    33 DP_KEYFLDNAMES Character(254) VARCHAR2(254) NOT NULL DP_KEYFLDNAMES
    34 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    35 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    36 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
    37 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit
    38 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    39 CORP_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
    40 CLASSIFICATION Character(10) VARCHAR2(10) NOT NULL Classification
    41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    42 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
    43 CUST_CHANNEL Character(15) VARCHAR2(15) NOT NULL Customer Channel
    44 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
    45 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
    46 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
    47 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
    48 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
    49 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
    50 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
    51 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
    52 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
    53 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
    54 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
    55 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
    56 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
    57 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
    58 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
    59 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
    60 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
    61 INV_ITEM_COLOR Character(10) VARCHAR2(10) NOT NULL Item Color
    62 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group
    63 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    64 INV_ITEM_TYPE Character(5) VARCHAR2(5) NOT NULL Item Type
    65 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family
    66 ITEM_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    67 ITEM_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    68 ITEM_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    69 ITEM_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL User-defined item field - Character 10
    70 ITEM_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    71 ITEM_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    72 ITEM_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    73 ITEM_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User-defined item field - Character 1
    74 ITEM_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User-defined item field - Character 2
    75 ITEM_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User-defined item field - Character 4
    76 ITEM_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User-defined item field - Character 6
    77 ITEM_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User-defined item field - Character 8
    78 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    79 ITEM_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    80 ITEM_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    81 ITEM_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30
    82 MITBL_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    83 PM_DIVISION Character(15) VARCHAR2(15) NOT NULL Division
    84 PM_TERRITORY Character(15) VARCHAR2(15) NOT NULL Territory
    85 PM_REGION Character(10) VARCHAR2(10) NOT NULL Region
    86 PRDITM_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    87 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL
    88 PROD_BRAND Character(15) VARCHAR2(15) NOT NULL Product Brand
    89 PROD_CATEGORY Character(15) VARCHAR2(15) NOT NULL Product Category
    90 PROD_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Product Char 10 A
    91 PROD_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Product Char 10 B
    92 PROD_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Product Char 10 C
    93 PROD_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Product Char 10 D
    94 PROD_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Product Char 2
    95 PROD_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Product Char 8
    96 PROD_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Product Char 6
    97 PROD_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Product Char 8
    98 PROD_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Product Char1 A
    99 PROD_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Product Char1 B
    100 PROD_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Product Char1 C
    101 PROD_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Product Char1 D
    102 PROD_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Product Char 30 A
    103 PROD_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Product Char 30 B
    104 PROD_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Product Char 30 C
    105 PROD_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Product Char 30 D
    106 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    107 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
    108 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
    109 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
    110 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
    1=Make
    2=Buy
    3=Expense
    4=Service
    5=Floor Stock
    6=Planning
    111 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    112 SUBCUST_QUAL2 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
    113 DP_NEXTLEVELUOM Character(3) VARCHAR2(3) NOT NULL DP_NEXTLEVELUOM
    114 DP_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE
    115 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION
    116 DP_NEXTLEVELCONV Number(13,2) DECIMAL(12,2) NOT NULL DP_NEXTLEVELCONV
    117 DP_EFFDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_EFFDEMANDPDS
    118 DP_NEXTFCITEM Character(120) VARCHAR2(120) NOT NULL DP_NEXTFCITEM
    119 DP_SUSPENDEDITEM Character(1) VARCHAR2(1) NOT NULL DP_SUSPENDEDITEM

    Y/N Table Edit

    120 DP_FCMETHOD Character(4) VARCHAR2(4) NOT NULL DP_FCMETHOD
    0=No Model Selected
    10=Tpl Exponential Smoothing - Br
    14=Holt Winters
    15=Weighted Moving Average
    18=Box Jenkins/ARIMA
    19=Census X-11
    24=Croston
    4=Moving Average
    5=Exponential Smoothing
    6=Linear Regression
    7=Adaptive Exponential Smoothing
    8=Dbl Exponential Smoothing - Br
    9=Dbl Exponential Smoothing - Ho
    121 DP_LIFEPROFILEITEM Character(1) VARCHAR2(1) NOT NULL DP_LIFEPROFILEITEM
    122 DP_PRORATE Character(1) VARCHAR2(1) NOT NULL DP_PRORATE Date Initials Reference # Description 06/08/07 TH ICE 1614042000 Modified Proration to allow Proration based upon the Number of Child Items
    123 DP_CALCULATIONTYPE Character(1) VARCHAR2(1) NOT NULL DP_CALCULATIONTYPE
    0=Best Fit
    1=Reoptimize
    2=No Calculation
    124 DP_USESSEASONPROF Character(1) VARCHAR2(1) NOT NULL DP_USESSEASONPROF

    Y/N Table Edit

    125 DP_DETSEASPROFILE Character(1) VARCHAR2(1) NOT NULL DP_DETSEASPROFILE

    Y/N Table Edit

    126 DP_HISTDEMANDPDS Number(3,0) SMALLINT NOT NULL DP_HISTDEMANDPDS
    127 DP_PERIODCREATED Number(2,0) SMALLINT NOT NULL DP_PERIODCREATED
    128 DP_YEARCREATED Number(4,0) SMALLINT NOT NULL DP_YEARCREATED
    129 DP_LASTRESETPD Number(2,0) SMALLINT NOT NULL DP_LASTRESETPD
    130 DP_LASTRESETYR Number(4,0) SMALLINT NOT NULL DP_LASTRESETYR
    131 DP_TEMPLATEITEM Character(1) VARCHAR2(1) NOT NULL DP_TEMPLATEITEM

    Y/N Table Edit

    132 DP_EVALPERIODS Number(2,0) SMALLINT NOT NULL DP_EVALPERIODS
    133 DP_UPDATETOINVPOL Character(1) VARCHAR2(1) NOT NULL DP_UPDATETOINVPOL

    Y/N Table Edit

    134 DP_AUDITREVIEWDONE Character(1) VARCHAR2(1) NOT NULL DP_AUDITREVIEWDONE

    Y/N Table Edit

    135 DP_ROUNDDECIMALS Signed Number(3,0) DECIMAL(2) NOT NULL DP_ROUNDDECIMALS
    136 DP_ROLLBACKPERIODS Number(3,0) SMALLINT NOT NULL DP_ROLLBACKPERIODS
    1=Additive
    2=Multiplicative
    137 DP_SEASONALITYTYPE Character(1) VARCHAR2(1) NOT NULL DP_SEASONALITYTYPE
    1=Additive
    2=Multiplicative

    Default Value: 2

    138 DP_LASTEVALPDS Number(3,0) SMALLINT NOT NULL DP_LASTEVALPDS
    139 DP_UD01 Character(30) VARCHAR2(30) NOT NULL DP_UD01
    140 DP_UD02 Character(30) VARCHAR2(30) NOT NULL DP_UD02
    141 DP_UD03 Character(30) VARCHAR2(30) NOT NULL DP_UD03
    142 DP_UD04 Character(30) VARCHAR2(30) NOT NULL DP_UD04
    143 DP_UD05 Character(30) VARCHAR2(30) NOT NULL DP_UD05
    144 DP_UD06 Character(30) VARCHAR2(30) NOT NULL DP_UD06
    145 DP_UD07 Character(30) VARCHAR2(30) NOT NULL DP_UD07
    146 DP_UD08 Character(30) VARCHAR2(30) NOT NULL DP_UD08
    147 DP_UD09 Character(30) VARCHAR2(30) NOT NULL DP_UD09
    148 DP_UD10 Character(30) VARCHAR2(30) NOT NULL DP_UD10
    149 DP_UD11 Character(20) VARCHAR2(20) NOT NULL DP_UD11
    150 DP_UD12 Character(20) VARCHAR2(20) NOT NULL DP_UD12
    151 DP_UD13 Character(20) VARCHAR2(20) NOT NULL DP_UD13
    152 DP_UD14 Character(20) VARCHAR2(20) NOT NULL DP_UD14
    153 DP_UD15 Character(20) VARCHAR2(20) NOT NULL DP_UD15
    154 DP_UD16 Character(20) VARCHAR2(20) NOT NULL DP_UD16
    155 DP_UD17 Character(20) VARCHAR2(20) NOT NULL DP_UD17
    156 DP_UD18 Character(20) VARCHAR2(20) NOT NULL DP_UD18
    157 DP_UD19 Character(20) VARCHAR2(20) NOT NULL DP_UD19
    158 DP_UD20 Character(20) VARCHAR2(20) NOT NULL DP_UD20
    159 DP_UD21 Character(10) VARCHAR2(10) NOT NULL DP_UD21
    160 DP_UD22 Character(10) VARCHAR2(10) NOT NULL DP_UD22
    161 DP_UD23 Character(10) VARCHAR2(10) NOT NULL DP_UD23
    162 DP_UD24 Character(10) VARCHAR2(10) NOT NULL DP_UD24
    163 DP_UD25 Character(10) VARCHAR2(10) NOT NULL DP_UD25
    164 DP_UD26 Character(10) VARCHAR2(10) NOT NULL DP_UD26
    165 DP_UD27 Character(10) VARCHAR2(10) NOT NULL DP_UD27
    166 DP_UD28 Character(10) VARCHAR2(10) NOT NULL DP_UD28
    167 DP_UD29 Character(10) VARCHAR2(10) NOT NULL DP_UD29
    168 DP_UD30 Character(10) VARCHAR2(10) NOT NULL DP_UD30
    169 DP_UD31 Character(10) VARCHAR2(10) NOT NULL DP_UD31
    170 DP_UD32 Character(10) VARCHAR2(10) NOT NULL DP_UD32
    171 DP_UD33 Character(10) VARCHAR2(10) NOT NULL DP_UD33
    172 DP_UD34 Character(10) VARCHAR2(10) NOT NULL DP_UD34
    173 DP_UD35 Character(10) VARCHAR2(10) NOT NULL DP_UD35
    174 DP_UD36 Character(10) VARCHAR2(10) NOT NULL DP_UD36
    175 DP_UD37 Character(10) VARCHAR2(10) NOT NULL DP_UD37
    176 DP_UD38 Character(10) VARCHAR2(10) NOT NULL DP_UD38
    177 DP_UD39 Character(10) VARCHAR2(10) NOT NULL DP_UD39
    178 DP_UD40 Character(10) VARCHAR2(10) NOT NULL DP_UD40
    179 DP_UD41 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD41
    180 DP_UD42 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD42
    181 DP_UD43 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD43
    182 DP_UD44 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD44
    183 DP_UD45 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD45
    184 DP_UD46 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD46
    185 DP_UD47 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD47
    186 DP_UD48 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD48
    187 DP_UD49 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD49
    188 DP_UD50 Number(21,4) DECIMAL(20,4) NOT NULL DP_UD50
    189 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
    190 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    191 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    192 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
    193 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID