PRODUCT_MASTER
Product Master
tableFINPRODUCT
PRODUCT_MASTER — Product Master. FIN table in the standard Ross ERP 8.0 schema: 224 columns, used by 833 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCT_MASTER in the interactive Data Dictionary →Part of PRODUCT tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | COMPANY_CODE | varchar(10) | PK | Company Code |
| 3 | PART_CODE | varchar(15) | PK | Product |
| 4 | PART_DESC_1 | varchar(60) | Product Description | |
| 5 | PART_DESC_2 | varchar(60) | Product Description | |
| 6 | UNIT_SALES | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Sales) |
| 7 | UNIT_PRICE | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Pricing) |
| 8 | UNIT_PUR | varchar(4) | FK→UNITS_OF_MEASURE | Purchase/Transfer Unit Of Measure |
| 9 | UNIT_PRD | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Production) |
| 10 | CUBIC_SIZE | numeric(20,4) | Cubic Size of Product | |
| 11 | CUBIC_SIZE_UOM | varchar(4) | FK→UNITS_OF_MEASURE | Cubic Size Unit of Measure |
| 12 | FREIGHT_CLASS | varchar(4) | FK→FREIGHT_CLASSES | Freight Class |
| 13 | WEIGHT_GROSS | numeric(20,4) | Gross Weight of Product | |
| 14 | WEIGHT_UOM | varchar(4) | FK→UNITS_OF_MEASURE | Weight Unit of Measure |
| 15 | PRODUCT_CLASS | varchar(6) | FK→PRODUCT_CLASSES | Product Class |
| 16 | PRODUCT_GROUP | varchar(6) | FK→PRODUCT_GROUPS | Product Group |
| 17 | PRODUCT_TYPE | varchar(6) | FK→PRODUCT_TYPES | Product type |
| 18 | PART_CODE_ALT | varchar(15) | Alternate Part Code | |
| 19 | MSDS_FLAG | varchar(1) | MSDS available Flag | |
| 20 | BATCHES_EXIST | varchar(1) | Lot Part | |
| 21 | BOM_GHOST_PART | varchar(1) | Ghost Prod | |
| 22 | MAKE_BUY | varchar(1) | Make, Buy or Transfer flag | |
| 23 | CREATION_DATE | datetime | Creation Date | |
| 24 | STATUS_FLAG | varchar(1) | Status Flag | |
| 25 | BATCH_REPLENISH_ALLOWED | varchar(1) | Lot Replenish Allowed | |
| 26 | BATCHES_AT_SALES_ORDERS | varchar(1) | Batches required at Sales Orders | |
| 27 | BATCHES_AT_PICK_SELECT | varchar(1) | Batches required at pick select | |
| 28 | BATCHES_AT_PICK_CONFIRM | varchar(1) | Lots required at Ship Create | |
| 29 | BATCHES_AT_DESPATCH_CONFIRM | varchar(1) | Lots required at Ship Amend | |
| 30 | BATCHES_AT_INVOICING | varchar(1) | Batches required at Invoicing | |
| 31 | BATCHES_AT_PURCHASE_ORDERS | varchar(1) | Batches required during Purchase Order Entry | |
| 32 | BATCHES_AT_MANU_ORDERS | varchar(1) | Batches required during Manufacturing Order Entry | |
| 33 | BATCHES_AT_GRN_ALLOC | varchar(1) | Batches required at Goods Received Allocation | |
| 34 | BATCHES_AT_QR_ALLOC | varchar(1) | Batches required at Quarantine Allocation | |
| 35 | BATCHES_AT_QC_ALLOC | varchar(1) | Batches required at Quality Control Allocation | |
| 36 | BATCH_STOCK | varchar(1) | Batches required at Quantity on Hand Allocation | |
| 37 | BATCH_EXPIRY | varchar(1) | Lot Expiry used for this part | |
| 38 | SHELF_LIFE | int | Average Shelf Life Days | |
| 39 | DISTRIBUTION_DAYS | smallint | Number of days allowed before product life is expired | |
| 40 | QUARANTINE_PERIOD | smallint | Number of days for quarantine | |
| 41 | WAREHOUSED_FLAG | varchar(1) | Warehoused Product Y/N | |
| 42 | SALES_PRICE | numeric(20,4) | Standard Sales Price | |
| 43 | AVERAGE_COST | numeric(20,4) | Weighted Average Cost | |
| 44 | LAST_COST | numeric(20,4) | Last Cost | |
| 45 | PURCHASE_COST | numeric(20,4) | Purchase Cost | |
| 46 | STANDARD_COST | numeric(20,6) | Standard Cost | |
| 47 | GL_INV | varchar(50) | FK→GL_ACCOUNTS | GL Code Inventory |
| 48 | GL_INV_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Code Inventory |
| 49 | GL_SALES | varchar(50) | FK→GL_ACCOUNTS | GL Code Sales |
| 50 | GL_SALES_CODE | varchar(6) | FK→GL_SHORT_CODES | Sales Code |
| 51 | GL_COS | varchar(50) | FK→GL_ACCOUNTS | GL Code Cost of Sales |
| 52 | GL_COS_CODE | varchar(6) | FK→GL_SHORT_CODES | Cost of Sales Code |
| 53 | TAXABLE | varchar(1) | Taxable | |
| 54 | TAXABLE_VALUE | numeric(20,2) | Taxable Value | |
| 55 | PRODUCT_TAX_CODE | varchar(5) | FK→TAX_CODES | Product Tax Code |
| 56 | BATCHES_AT_RECEIPT | varchar(1) | Batches required at Goods Receipt | |
| 57 | SALES_TAX_CODE | varchar(5) | Sales Tax Code | |
| 58 | PRODUCT_DISCOUNT_GROUP | varchar(6) | FK→PRODUCT_DISCOUNT_GROUPS | Product Discount Group |
| 59 | EAN_NUMBER | varchar(15) | GTIN | |
| 60 | GRN_IN_USE | varchar(1) | Goods Received Notes in Use | |
| 61 | CHARACTERISTICS_AT_ORDER_ENTRY | varchar(1) | Batch Characteristics Required At Order Entry | |
| 62 | STD_VARIANCE_CODE | varchar(6) | FK→GL_SHORT_CODES | Std Cost Variance Code |
| 63 | STD_VARIANCE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Std Cost Variance Account |
| 64 | SYS_PART_DETAIL | text | Product Detail | |
| 65 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 66 | SYS_TARIFF_CODE | varchar(11) | Tariff Code | |
| 67 | SYS_EC_PROCESSED_INDICATOR | varchar(1) | EC Tax Process Indicator | |
| 68 | IC_MULTIPLE_LOT_STATES | varchar(1) | Multiple Lot States Allowed | |
| 69 | IC_RETEST_DAYS | smallint | Retest Days | |
| 70 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 71 | SF_BRAND | varchar(5) | FK→SF_BRANDS | Brand |
| 72 | IC_NORMAL_STATUS | varchar(8) | FK→IC_STATUS_CODES | |
| 73 | SF_FORECAST_FLAG | varchar(1) | Sales Forecast this Product? | |
| 74 | SYS_QC_SPEC | varchar(8) | Quality Control Specification | |
| 75 | IC_NEW_LOT_ON_RETURN | varchar(1) | New Lot on return of material from production | |
| 76 | PM_POTENT_CHARACTERISTIC | varchar(6) | FK→CHARACTERISTIC_CODES | |
| 77 | HAZARDOUS_INGREDIENT | varchar(1) | ||
| 78 | PROCESS_SPEC | varchar(15) | Process Specification | |
| 79 | FACTORY | varchar(2) | Factory Code | |
| 80 | SYS_VERSION_NUMBER | int | Version Number | |
| 81 | MSDS_USE_PROCESS_SPEC | varchar(1) | MSDS Use Process Specification | |
| 82 | SYS_CURRENCY_METHOD | varchar(1) | Currency Method | |
| 83 | BT_COMMODITY_CLASS | varchar(15) | FK→BT_COMMODITY_CLASSES | Commodity Class |
| 84 | SYS_POST_AT_RECV_CODE | varchar(1) | Postings At Receiving Code | |
| 85 | SYS_PPV_AT_RECV_FLAG | varchar(1) | PPV At Receiving Flag | |
| 86 | GRN_NOT_INV_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods Received not Invoiced |
| 87 | GRN_NOT_INV_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received not Invoiced |
| 88 | GRN_QC_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods received into Quality Control |
| 89 | GRN_QC_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received to Quality Control |
| 90 | GRN_QR_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods received into Quarantine |
| 91 | GRN_QR_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received to Quarantine |
| 92 | SYS_EDI_PRODUCT_ID | varchar(40) | Industry Product ID | |
| 93 | SYS_EDI_PRODUCT_ID_QUAL | varchar(2) | Industry Product ID Qualifier | |
| 94 | IC_PRODUCT_UOM_CONTROL | varchar(1) | The type of product | |
| 95 | IC_PACKAGED_PRODUCT | varchar(1) | Packaged product flag. | |
| 96 | IC_SPECIFIC_GRAVITY | numeric(10,6) | The specific gravity for a product. | |
| 97 | IC_UNIT_REQUIRE | varchar(4) | ||
| 98 | IC_UNIT_COST | varchar(4) | ||
| 99 | IC_UNIT_CAPACITY | varchar(4) | ||
| 100 | IC_CATCHWEIGHT_TOLERANCES | varchar(1) | Tolerances are to be used for catchweight products. | |
| 101 | IC_UNIT_WEIGHT_FROM | varchar(4) | FK→UNITS_OF_MEASURE | |
| 102 | IC_UNIT_VOLUME_FROM | varchar(4) | FK→UNITS_OF_MEASURE | |
| 103 | IC_CATCHWEIGHT_MAXIMUM | numeric(20,6) | Maximum qty in non-capacity UOM allowed per Capacity unit | |
| 104 | IC_CATCHWEIGHT_MINIMUM | numeric(20,6) | ||
| 105 | IC_WEIGHT_FROM_CONTROL | varchar(1) | ||
| 106 | IC_VOLUME_FROM_CONTROL | varchar(1) | ||
| 107 | IC_CHARACTERISTIC_COUNT | smallint | Number of characteristics for a product | |
| 108 | POP_NOMINATED_UNIT | varchar(4) | Inventory unit which Purchase unit converts to | |
| 109 | POP_UNIT_PRICE | varchar(4) | FK→UNITS_OF_MEASURE | Unit of Measure (Purchase Price) |
| 110 | POP_NOMINATED_PRICE_UNIT | varchar(4) | Inventory unit which Purchase Price unit converts to | |
| 111 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Normal Inventory Status for Received stock |
| 112 | IC_COUNT_CATCHWEIGHT_AVERAGING | varchar(1) | Indicates if catchweight averaging permitted during counts | |
| 113 | SOP_NORMAL_CREDIT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Sales Credit stock |
| 114 | PM_NORMAL_OUTPUT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Job Outputs |
| 115 | PM_NORMAL_RETURN_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Job Returned stock |
| 116 | SOP_NOMINATED_UNIT | varchar(4) | Inventory unit which Sales unit converts to | |
| 117 | SOP_NOMINATED_PRICE_UNIT | varchar(4) | Inventory unit which Sales Pricing unit converts to | |
| 118 | PM_NOMINATED_UNIT | varchar(4) | Nominated unit of measure in PM | |
| 119 | PP_NOMINATED_UNIT | varchar(4) | Inventory unit which process planning unit converts to | |
| 120 | GL_USER_DEFINED_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for a User-Defined status |
| 121 | GL_USER_DEFINED_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | GL Account for a User-Defined status |
| 122 | GL_LOT_ADJUSTMENT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for Lot Adjustment |
| 123 | GL_LOT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Lot Adjustment | |
| 124 | GL_COUNT_ADJUSTMENT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for Inventory Counting adjustments |
| 125 | GL_COUNT_ADJUSTMENT_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | GL Account for Inventory Counting adjustments |
| 126 | GL_RECONCILIATION_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for inventory quantity reconciliation |
| 127 | GL_RECONCILIATION_ACCOUNT | varchar(50) | GL Account for inventory quantity reconciliation | |
| 128 | IC_DEFAULT_CATCHWEIGHT_AVERAGE | numeric(20,6) | ||
| 129 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 130 | ATP_IN_USE | varchar(1) | Available To Promise In Use | |
| 131 | SYS_USER_DEFINED_1 | varchar(25) | User Defined Field 1 | |
| 132 | SYS_USER_DEFINED_2 | varchar(25) | User Defined Field 2 | |
| 133 | SYS_USER_DEFINED_3 | varchar(25) | User Defined Field 3 | |
| 134 | SYS_USER_DEFINED_4 | numeric(20,2) | User Defined Field 4 | |
| 135 | SYS_USER_DEFINED_5 | numeric(20,2) | User Defined Field 5 | |
| 136 | ATP_WINDOW_LIMIT | varchar(1) | Available To Promise Window Limit | |
| 137 | ATP_WINDOW_DAYS | smallint | Available To Promise Window Days | |
| 138 | GL_VAR_IN_INV_ACCT | varchar(50) | FK→GL_ACCOUNTS | The account used to post a variation in inventory |
| 139 | GL_VAR_IN_INV_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the variation in inventory account |
| 140 | GL_INV_EXPENSE_ACCT | varchar(50) | FK→GL_ACCOUNTS | The Expense Account used in place of the Inventory Asset A/c |
| 141 | GL_INV_EXPENSE_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the inventory expense account |
| 142 | GL_LINE_DISCOUNT_ACCT | varchar(50) | FK→GL_ACCOUNTS | The line specific discount account |
| 143 | GL_LINE_DISCOUNT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the line discount account |
| 144 | IC_ATP_FROM_EXISTING | varchar(1) | Promise from Existing Inventory | |
| 145 | IC_ATP_SOURCE_PURCHASE | varchar(1) | Promise made against Purchase Orders | |
| 146 | IC_ATP_SOURCE_FORECAST | varchar(1) | Promise made against production forecast | |
| 147 | IC_ATP_SOURCE_PLAN_JOBS | varchar(1) | Promise made against planned jobs | |
| 148 | IC_ATP_SOURCE_LIVE_JOBS | varchar(1) | Promise made against live jobs | |
| 149 | SOP_CLOSE_OFF_MINIMUM | numeric(10,2) | Order Close-Off Minimum | |
| 150 | SOP_INVOICE_DESPATCH_OVERRIDE | varchar(1) | Allow overriding of ship qty for invoicing | |
| 151 | SOP_INVOICE_DESPATCH_TOLERANCE | numeric(10,2) | %age variance of invoice qty from ship qty | |
| 152 | RCS_CONVERSION_STATUS | varchar(1) | Ren/CS Data Conversion Status | |
| 153 | MP_PROMOTIONS_ALLOWED | varchar(1) | Promotions Allowed | |
| 154 | MP_PRIVATE_LABEL | varchar(1) | Private Label | |
| 155 | IC_DUN14 | varchar(14) | DUN14 | |
| 156 | IC_PART_MHU_TRACE | varchar(1) | Product MHU Trace | |
| 157 | PL_OPEN_ACCOUNT | varchar(50) | Opening Inventory Account | |
| 158 | PL_OPEN_CODE | varchar(6) | Opening Inventory Code | |
| 159 | PL_CLOSE_ACCOUNT | varchar(50) | Closing Inventory Account | |
| 160 | PL_CLOSE_CODE | varchar(6) | Closing Inventory Code | |
| 161 | COSTING_TYPE | varchar(8) | Inventory Costing Type | |
| 162 | PL_WRITE_OFF_ACCOUNT | varchar(50) | Write Off Account | |
| 163 | PL_WRITE_OFF_CODE | varchar(6) | Write Off Code | |
| 164 | INV_VALUE_RESERVE_ACCOUNT | varchar(50) | Reserve for Product Low Cost Account | |
| 165 | INV_VALUE_RESERVE_CODE | varchar(6) | Reserve for Product Low Cost Code | |
| 166 | INV_VALUE_RESERVE_REPAY_ACCOUNT | varchar(50) | Low Cost Reserve Repayment Account | |
| 167 | INV_VALUE_RESERVE_REPAY_CODE | varchar(6) | Low Cost Reserve Repayment Code | |
| 168 | SYS_QC_RESULTS_GROUP | varchar(6) | QC Test Results Group | |
| 169 | TP_PRODUCT_FLOOR_INDICATOR | smallint | Product Floor Indicator | |
| 170 | TP_PRODUCT_FLOOR_PRICE | numeric(20,4) | Product Floor Price | |
| 171 | TP_PRODUCT_FLOOR_PERCENT | numeric(10,2) | Product Floor Percent | |
| 172 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 173 | SCM_SEND_FLAG | varchar(1) | The flag indicate whether send data to SCM | |
| 174 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 175 | SOP_OVERSHIP_PERCENT | numeric(10,2) | Over-Ship Maximum | |
| 176 | GL_QC_WRITE_OFF_CODE | varchar(6) | GL QC Write Off Code | |
| 177 | GL_QC_WRITE_OFF_ACCOUNT | varchar(50) | GL QC Write Off Account | |
| 178 | GL_QR_WRITE_OFF_CODE | varchar(6) | GL QR Write Off Code | |
| 179 | GL_QR_WRITE_OFF_ACCOUNT | varchar(50) | GL QR Write Off Account | |
| 180 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 181 | SYS_CREATE_USER | varchar(20) | User who new this record | |
| 182 | SYS_MODIFIED_DATE | datetime | Last Modification Date | |
| 183 | SYS_MODIFY_USER | varchar(20) | The last user who modified this record | |
| 184 | TAX_PRICE_VARIANCE_CODE | varchar(6) | FK→GL_SHORT_CODES | Short code for tax inc price variance |
| 185 | TAX_PRICE_VARIANCE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full account for tax inc price variance |
| 186 | SALES_PRICE_INC_TAX | numeric(20,4) | Standard Sales Price Including Tax | |
| 187 | PURCHASE_COST_INC_TAX | numeric(20,4) | Purchase Cost Including Tax | |
| 188 | REQ_QUALIFIED_SUPPLIER | smallint | Qualified Supplier required flag | |
| 189 | SYS_ECCN | varchar(10) | Export Classification Control Number | |
| 190 | SYS_VEHICLE_LICENSE_NUMBER | varchar(30) | License Number | |
| 191 | SYS_HS_TARIFF | varchar(30) | Harmonized System Tariff Number | |
| 192 | SYS_SHIP_PACK_TYPE_CODE | varchar(20) | Shipping Package Type Code | |
| 193 | SYS_SCHEDULE_B | varchar(14) | Schedule B Identifier | |
| 194 | SYS_COUNTRY_OF_ORIGIN | varchar(6) | ||
| 195 | TEST_QC_TEST_GROUP | varchar(6) | Inventory Test Group | |
| 196 | LS_DEA_CONTROLLED | varchar(1) | DEA Controlled | |
| 197 | INHERIT_EXPIRY | varchar(1) | Inherit Best Before | |
| 198 | PASS_ON_EXPIRY | varchar(1) | Pass On Best Before | |
| 199 | INCLUDE_IN_BRACKET_QTY | varchar(1) | Include Quantity in Bracket Price Level | |
| 200 | BRACKET_PRICE_ONLY | varchar(1) | Bracket Price Only | |
| 201 | GL_SIT | varchar(50) | FK→GL_ACCOUNTS | GL account Shipments in Transit |
| 202 | GL_SIT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL short code Shipments in Transit |
| 203 | SYS_AUTO_QOH_UPDATE_FLAG | varchar(1) | Auto QOH/CQOH Update | |
| 204 | MERGED_LOT_ACTION | smallint | Merged Lot Action | |
| 205 | MERGED_LOT_CHARACTERISTIC | smallint | Characteristic setting for Merged with New Lot | |
| 206 | FOOD_ALLERGEN_FACTORY | varchar(2) | ||
| 207 | FOOD_ALLERGEN_SPEC | varchar(15) | ||
| 208 | FOOD_ALLERGEN_SPEC_VERSION | int | ||
| 209 | PLM_IN_USE | varchar(1) | PLM Interface in use | |
| 210 | PLM_MAT_TYPE | varchar(20) | PLM Material type | |
| 211 | DC_PLPN_LEVEL | smallint | Indicates at which level PLPN is applied. | |
| 212 | DC_CLPN_COUNT | smallint | Count of CLPN per PLPN. | |
| 213 | DC_CLPN_DEFAULT_QUANTITY | numeric(20,6) | Default quantity per CLPN. | |
| 214 | AUTO_CLOSE_PCT | numeric(10,2) | ||
| 215 | OVER_RECEIPT_PCT | numeric(10,2) | ||
| 216 | DISCONTINUE_FLAG | varchar(1) | Discontinue Master Record | |
| 217 | SO_MINIMUM_QTY | numeric(20,6) | Minimum Sales Quantity | |
| 218 | SO_INCREMENTAL_QTY | numeric(20,6) | Sales Incremental Quantity | |
| 219 | CONTRACT_OVER_INVOICED_PERCENT | numeric(10,2) | Contract Order Over Invoiced Maximum | |
| 220 | GS1_IN_USE | varchar(1) | Serialization in Use | |
| 221 | BOM_LOW_LEVEL_CODE | smallint | BOM Low Level Code | |
| 222 | MERGED_LOT_OLD_DATES | varchar(1) | Merged with new Lots but use old expiry | |
| 223 | CONSTRAINT_TYPE | varchar(1) | Constraint Type | |
| 224 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 29 foreign keys
BT_BID_LINESBT_BID_RESPONSE_LINESIC_MSDS_HAZARDOUS_INGREDIENTSIC_MSDS_HAZARDOUS_INGREDIENTSIC_PRODUCT_CHARACTERISTICSIC_PRODUCT_MSDS_LANGUAGEIC_XREF_PRODUCT_MSDS_ITEMSIC_XREF_PRODUCT_MSDS_REASONSIC_XREF_PROD_MSDS_STATEMENTSINV_TRANSACTION_DETAILSINV_TRANSACTION_LINESBIN_LOCATION_DETAILSGOODS_RECEIVED_LINESPURCHASE_INVOICE_LINESPRODUCT_MASTER_BY_VENDORPOP_LINESPOP_REQUISITION_LINESPOP_CONTRACT_PRICESPRODUCT_WAREHOUSEPROMOTION_PRICESPURCHASE_CREDIT_NOTE_LINESSALES_CONTRACT_PRICESSALES_ORDER_LINESSALES_PRICESSA_DETAIL_LINESSF_FORECASTING_GROUP_ITEMSSF_FCAST_ITEM_PARMSSF_ITEM_BUDGETSSF_ITEM_PERIOD_SPLITS