PRODUCT_WAREHOUSE
Product Warehouse
tableFINPRODUCT
PRODUCT_WAREHOUSE — Product Warehouse. FIN table in the standard Ross ERP 8.0 schema: 213 columns, used by 468 programs. Columns, data types, keys, foreign keys and relationships.
Open PRODUCT_WAREHOUSE 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 FK→PRODUCT_MASTER | Product |
| 4 | WAREHOUSE | varchar(2) | PK FK→WAREHOUSE_CONTROLS | Warehouse Code |
| 5 | QTY_COMMITTED_CURRENT | numeric(20,6) | Quantity Committed (current Release) | |
| 6 | QTY_COMMITTED_FORWARD | numeric(20,6) | Quantity Committed Forward | |
| 7 | QTY_COMMITTED_BACK | numeric(20,6) | Quantity Committed on Backorder | |
| 8 | QTY_ORDERED_CURRENT | numeric(20,6) | Quantity on PO - Current | |
| 9 | QTY_ORDERED_FORWARD | numeric(20,6) | Quantity Ordered Forward | |
| 10 | QTY_ORDERED_BACK | numeric(20,6) | Quantity on Puchase BackOrder | |
| 11 | QTY_RECEIVED | numeric(20,6) | Qty Received | |
| 12 | SALES_PRICE | numeric(20,4) | Standard Sales Price | |
| 13 | AVERAGE_COST | numeric(20,4) | Weighted Average Cost | |
| 14 | LAST_COST | numeric(20,4) | Last Cost | |
| 15 | PURCHASE_COST | numeric(20,4) | Purchase Cost | |
| 16 | STANDARD_COST | numeric(20,6) | Standard Cost | |
| 17 | PLANNER_CODE | varchar(4) | FK→PLANNER_CODES | Planner Code |
| 18 | BUYER_CODE | varchar(4) | Buyer Code | |
| 19 | GL_INV | varchar(50) | FK→GL_ACCOUNTS | GL Code Inventory |
| 20 | GL_INV_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Code Inventory |
| 21 | GL_SALES | varchar(50) | FK→GL_ACCOUNTS | GL Code Sales |
| 22 | GL_SALES_CODE | varchar(6) | FK→GL_SHORT_CODES | Sales Code |
| 23 | GL_COS | varchar(50) | FK→GL_ACCOUNTS | GL Code Cost of Sales |
| 24 | GL_COS_CODE | varchar(6) | FK→GL_SHORT_CODES | Cost of Sales Code |
| 25 | GL_WIP | varchar(50) | FK→GL_ACCOUNTS | GL Code Work in Process |
| 26 | ABC_CODE | varchar(1) | ABC Code | |
| 27 | PURCHASE_LEAD_TIME | int | Purchase Order or Warehouse Transfer Lead Time | |
| 28 | MANU_LEAD_TIME | int | Manufacture Lead Time | |
| 29 | ECONOMIC_ORDER_QTY | numeric(20,6) | Economic Order Quantity | |
| 30 | EOQ_UPDATE_FLAG | varchar(10) | EOQ Update Flag | |
| 31 | MAXIMUM_LEVEL | numeric(20,6) | Maximum Inventory Level | |
| 32 | MINIMUM_LEVEL | numeric(20,6) | Minimum Inventory Level | |
| 33 | REORDER_LOT_SIZE | numeric(20,6) | Reorder Lot Size | |
| 34 | REORDER_MIN_QTY | numeric(20,6) | Reorder Minimum | |
| 35 | REORDER_POLICY_CODE | varchar(2) | Reorder Policy Code | |
| 36 | SAFETY_LEVEL | numeric(20,6) | Safety Stock Level | |
| 37 | TOTAL_USAGE | numeric(20,4) | Total Usage Work Field | |
| 38 | PERIODS_FOR_USAGE_TOT | varchar(2) | Number of Periods for Usage Total Calcs | |
| 39 | SALES_ORDERS_FLAG | varchar(1) | Sales Orders Permitted Flag | |
| 40 | PURCHASE_ORDERS_FLAG | varchar(1) | Purchase Orders Permitted Flag | |
| 41 | TAXABLE_VALUE | numeric(20,2) | Taxable Value | |
| 42 | LAST_COUNT_DATE | datetime | Last Inventory Count Date | |
| 43 | BIN_LOCATION | varchar(15) | Bin Location | |
| 44 | PICKING_LOCATION | varchar(15) | Picking Location | |
| 45 | PREFERRED_WH_ZONE_1 | varchar(6) | Preferred Warehouse Zone | |
| 46 | PREFERRED_WH_ZONE_2 | varchar(6) | Preferred Warehouse Zone | |
| 47 | PREFERRED_WH_ZONE_3 | varchar(6) | Preferred Warehouse Zone | |
| 48 | PREFERRED_WH_ZONE_4 | varchar(6) | Preferred Warehouse Zone | |
| 49 | PREFERRED_WH_ZONE_5 | varchar(6) | Preferred Warehouse Zone | |
| 50 | PREFERRED_WH_ZONE_6 | varchar(6) | Preferred Warehouse Zone | |
| 51 | PREFERRED_WH_ZONE_7 | varchar(6) | Preferred Warehouse Zone | |
| 52 | PREFERRED_WH_ZONE_8 | varchar(6) | Preferred Warehouse Zone | |
| 53 | PREFERRED_WH_ZONE_9 | varchar(6) | Preferred Warehouse Zone | |
| 54 | PREFERRED_WH_ZONE_10 | varchar(6) | ||
| 55 | LAST_BATCH_NUMBER | int | Last Batch Number Used | |
| 56 | SCRAP_FACTOR | numeric(20,4) | Scrap Percentage | |
| 57 | OLD_ABC_CODE | varchar(1) | Old ABC Code | |
| 58 | NEXT_COUNT_DATE | datetime | Next Inventory Count Date | |
| 59 | OLD_NEXT_COUNT_DATE | datetime | Previous 'Next Count Date' B4 our ABC update | |
| 60 | DISCRETE_REORDER | varchar(1) | Discrete Reorder (Y/N) | |
| 61 | PHYS_COUNT_NUMBER | int | Count Number | |
| 62 | COUNT_SEQ_NUMBER | int | Inventory Count Sequence Number | |
| 63 | AM_FLAG | varchar(1) | Auto/Manual Allocations to Bins | |
| 64 | CREATION_DATE | datetime | Creation Date | |
| 65 | PERMIT_RESERVATION | varchar(1) | Permit Reservation Of Inventory | |
| 66 | VENDOR_NUMBER | varchar(12) | Supplier Number (or ID) | |
| 67 | VENDOR_NUMBER_ALT | varchar(12) | Alternate Supplier Code | |
| 68 | GL_WIP_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code - Work in Progress |
| 69 | TAXABLE | varchar(1) | Taxable | |
| 70 | QC_RECEIVING_DAYS | smallint | QC Receiving Days | |
| 71 | MRP_DAMPING_DAYS | smallint | MRP Damping days | |
| 72 | DEMAND_FENCE_DAYS | smallint | Demand Time Fence Days | |
| 73 | ORDER_INTERVAL_DAYS | smallint | Order Interval Days | |
| 74 | SAFETY_DAYS | smallint | Safety Days | |
| 75 | QTY_TRANSIT_IN | numeric(20,6) | Quantity in Transit - Inwards | |
| 76 | QTY_TRANSIT_OUT | numeric(20,6) | Quantity in Transit - Outwards | |
| 77 | MH_UNIT | varchar(4) | FK→UNITS_OF_MEASURE | Material Handling Unit |
| 78 | GL_INV_QC | varchar(50) | GL QC Inventory Asset Account | |
| 79 | GL_INV_CODE_QC | varchar(6) | FK→GL_SHORT_CODES | QC Inventory Asset |
| 80 | GL_INV_QR | varchar(50) | GL QR Inventory Asset Account | |
| 81 | GL_INV_CODE_QR | varchar(6) | FK→GL_SHORT_CODES | QR Inventory Asset |
| 82 | PRODUCT_TAX_CODE | varchar(5) | Product Tax Code | |
| 83 | BARCODE_LABEL_FORMAT_CODE | varchar(8) | Barcoded Label Print Format Code | |
| 84 | ATP_WINDOW_DAYS | smallint | Available To Promise Window Days | |
| 85 | ATP_WINDOW_LIMIT | varchar(1) | Available To Promise Window Limit | |
| 86 | ATP_IN_USE | varchar(1) | Available To Promise In Use | |
| 87 | NEXT_ATP_REFERENCE | int | Next ATP Reference Number | |
| 88 | SYS_TARIFF_CODE | varchar(11) | Tariff Code | |
| 89 | SYS_EC_PROCESSED_INDICATOR | varchar(1) | EC Tax Process Indicator | |
| 90 | ACTIVATION_STATUS | varchar(1) | Activation Status | |
| 91 | MAKE_BUY | varchar(1) | Make, Buy or Transfer flag | |
| 92 | PP_SOURCE_WAREHOUSE | varchar(2) | ||
| 93 | SYS_POST_AT_RECV_CODE | varchar(1) | Postings At Receiving Code | |
| 94 | SYS_PPV_AT_RECV_FLAG | varchar(1) | PPV At Receiving Flag | |
| 95 | GRN_NOT_INV_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods Received not Invoiced |
| 96 | GRN_NOT_INV_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received not Invoiced |
| 97 | GRN_QC_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods received into Quality Control |
| 98 | GRN_QC_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received to Quality Control |
| 99 | GRN_QR_CODE | varchar(6) | FK→GL_SHORT_CODES | Default Short Code for Goods received into Quarantine |
| 100 | GRN_QR_FULL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full Account for Default Goods Received to Quarantine |
| 101 | STD_VARIANCE_CODE | varchar(6) | FK→GL_SHORT_CODES | Std Cost Variance Code |
| 102 | STD_VARIANCE_ACCOUNT | varchar(50) | Std Cost Variance Account | |
| 103 | IC_CATCHWEIGHT_AVERAGE | numeric(20,6) | ||
| 104 | IC_MHU_TYPE | varchar(1) | Type of MHU: None, Fixed or Variable | |
| 105 | IC_LAST_SPOT_COUNT_DATE | datetime | Last Spot Check Count Date | |
| 106 | IC_LAST_CYCLE_COUNT_DATE | datetime | ||
| 107 | IC_LAST_PHYSICAL_COUNT_DATE | datetime | ||
| 108 | IC_NEXT_CYCLE_COUNT_DATE | datetime | ||
| 109 | POP_NORMAL_RECEIPT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Normal Inventory Status for Received stock |
| 110 | SOP_NORMAL_CREDIT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Sales Credit stock |
| 111 | PM_NORMAL_OUTPUT_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Job Outputs |
| 112 | PM_NORMAL_RETURN_STATUS | varchar(8) | FK→IC_STATUS_CODES | Inventory status for Job Returned stock |
| 113 | GL_USER_DEFINED_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for a User-Defined status |
| 114 | GL_USER_DEFINED_ACCOUNT | varchar(50) | GL Account for a User-Defined status | |
| 115 | GL_LOT_ADJUSTMENT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for Lot Adjustment |
| 116 | GL_LOT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Lot Adjustment | |
| 117 | GL_COUNT_ADJUSTMENT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for Inventory Counting adjustments |
| 118 | GL_COUNT_ADJUSTMENT_ACCOUNT | varchar(50) | GL Account for Inventory Counting adjustments | |
| 119 | GL_RECONCILIATION_CODE | varchar(6) | FK→GL_SHORT_CODES | GL Short Code for inventory quantity reconciliation |
| 120 | GL_RECONCILIATION_ACCOUNT | varchar(50) | GL Account for inventory quantity reconciliation | |
| 121 | REF_BIN_LOCATION | varchar(15) | ||
| 122 | MIN_ORDER_QTY | numeric(20,6) | Minimum Order Quantity | |
| 123 | MAX_ORDER_QTY | numeric(20,6) | Maximum Order Quantity | |
| 124 | IC_ATP_FROM_EXISTING | varchar(1) | Promise from Existing Inventory | |
| 125 | GL_VAR_IN_INV_ACCT | varchar(50) | FK→GL_ACCOUNTS | The account used to post a variation in inventory |
| 126 | GL_VAR_IN_INV_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the variation in inventory account |
| 127 | GL_INV_EXPENSE_ACCT | varchar(50) | FK→GL_ACCOUNTS | The Expense Account used in place of the Inventory Asset A/c |
| 128 | GL_INV_EXPENSE_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the inventory expense account |
| 129 | GL_LINE_DISCOUNT_ACCT | varchar(50) | FK→GL_ACCOUNTS | The line specific discount account |
| 130 | GL_LINE_DISCOUNT_SHORT_CODE | varchar(6) | FK→GL_SHORT_CODES | The short code for the line discount account |
| 131 | IC_ATP_SOURCE_PURCHASE | varchar(1) | Promise made against Purchase Orders | |
| 132 | IC_ATP_SOURCE_FORECAST | varchar(1) | Promise made against production forecast | |
| 133 | IC_ATP_SOURCE_PLAN_JOBS | varchar(1) | Promise made against planned jobs | |
| 134 | IC_ATP_SOURCE_LIVE_JOBS | varchar(1) | Promise made against live jobs | |
| 135 | IC_ATP_PERCENT_EXISTING | numeric(10,2) | Percentage of source available to promise against | |
| 136 | IC_ATP_PERCENT_PURCHASE | numeric(10,2) | Percent of source available to promise against | |
| 137 | IC_ATP_PERCENT_FORECAST | numeric(10,2) | Percentage of source available to promise against | |
| 138 | IC_ATP_PERCENT_PLAN_JOBS | numeric(10,2) | Percentage of source available to promise against | |
| 139 | IC_ATP_PERCENT_LIVE_JOBS | numeric(10,2) | Percentage of source avaible to promise against | |
| 140 | IC_ATP_AUTO_HORIZON | smallint | Time in which it is permissible to automatically promise inv | |
| 141 | TM_FREIGHT_ACCRUAL_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for Freight Accrual Postings |
| 142 | TM_FREIGHT_ACCRUAL_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | TM Full Account for Freight Accrual Postings |
| 143 | TM_FREIGHT_EXPENSE_CODE | varchar(6) | FK→GL_SHORT_CODES | Short Code for TM Expense Postings |
| 144 | TM_FREIGHT_EXPENSE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full GL Account for TM Expense Postings |
| 145 | SOP_FREIGHT_RECOVERY_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Freight Recovery Account |
| 146 | SOP_FREIGHT_RECOVERY_CODE | varchar(6) | FK→GL_SHORT_CODES | Freight Recovery code |
| 147 | SOP_FREIGHT_ALLOWANCE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Freight allowance account |
| 148 | SOP_FREIGHT_ALLOWANCE_CODE | varchar(6) | FK→GL_SHORT_CODES | Freight Allowance Code |
| 149 | COSTING_TYPE | varchar(8) | Inventory Costing Type | |
| 150 | PL_OPEN_ACCOUNT | varchar(50) | Opening Inventory Account | |
| 151 | PL_OPEN_CODE | varchar(6) | Opening Inventory Code | |
| 152 | PL_CLOSE_ACCOUNT | varchar(50) | Closing Inventory Account | |
| 153 | PL_CLOSE_CODE | varchar(6) | Closing Inventory Code | |
| 154 | PL_WRITE_OFF_ACCOUNT | varchar(50) | Write Off Account | |
| 155 | PL_WRITE_OFF_CODE | varchar(6) | Write Off Code | |
| 156 | INV_VALUE_RESERVE_ACCOUNT | varchar(50) | Reserve for Product Low Cost Account | |
| 157 | INV_VALUE_RESERVE_CODE | varchar(6) | Reserve for Product Low Cost Code | |
| 158 | INV_VALUE_RESERVE_REPAY_ACCOUNT | varchar(50) | Low Cost Reserve Repayment Account | |
| 159 | INV_VALUE_RESERVE_REPAY_CODE | varchar(6) | Low Cost Reserve Repayment Code | |
| 160 | TRANSFER_COST_METHOD_FLAG | smallint | Transfer cost method indicator | |
| 161 | TRANSFER_COST_INCREMENT_VALUE | numeric(20,4) | Increment value to increase unit cost for transfers | |
| 162 | TRANSFER_COST_MULTIPLIER_VALUE | numeric(20,4) | Multiplier value to increase unit cost for transfers | |
| 163 | TRANSFER_COST_FIXED_VALUE | numeric(20,4) | Absolute Value used as the unit cost for transfers | |
| 164 | TRANSIT_LOSS_GL_ACCOUNT | varchar(50) | Transit Loss GL Account | |
| 165 | TRANSIT_LOSS_GL_CODE | varchar(6) | FK→GL_SHORT_CODES | Transit Loss GL Code |
| 166 | TRANSFER_COST_ADJ_GL_ACCOUNT | varchar(50) | Transfer Cost Adjustment GL Account | |
| 167 | TRANSFER_COST_ADJ_GL_CODE | varchar(6) | FK→GL_SHORT_CODES | Transfer Cost Adjustment GL Code |
| 168 | SYS_QC_RESULTS_GROUP | varchar(6) | QC Test Results Group | |
| 169 | INV_REVALUATION_CODE | varchar(6) | Inventory Revaluation Short Code | |
| 170 | INV_REVALUATION_ACCOUNT | varchar(50) | Inventory Revaluation Account | |
| 171 | GEM_TRANSACTION_ID | varchar(64) | System transaction identifier stamped by GEMBASE when the row was written. | |
| 172 | ES_INQUIRY_GEM_TRANSACTION_ID | varchar(64) | ||
| 173 | VERIFY_LOT_ON_PICK | varchar(1) | Indicates if Lot must be entered at time of Pick | |
| 174 | ADDED_TO_EXTERNAL | varchar(1) | Record has been updated to an external system | |
| 175 | GL_QC_WRITE_OFF_CODE | varchar(6) | GL QC Write Off Code | |
| 176 | GL_QC_WRITE_OFF_ACCOUNT | varchar(50) | GL QC Write Off Account | |
| 177 | GL_QR_WRITE_OFF_CODE | varchar(6) | GL QR Write Off Code | |
| 178 | GL_QR_WRITE_OFF_ACCOUNT | varchar(50) | GL QR Write Off Account | |
| 179 | SYSTEM_DATE | datetime | System Date Transaction Made | |
| 180 | SYS_CREATE_USER | varchar(20) | User who new this record | |
| 181 | SYS_MODIFIED_DATE | datetime | Last Modification Date | |
| 182 | SYS_MODIFY_USER | varchar(20) | The last user who modified this record | |
| 183 | TAX_PRICE_VARIANCE_CODE | varchar(6) | FK→GL_SHORT_CODES | Short code for tax inc price variance |
| 184 | TAX_PRICE_VARIANCE_ACCOUNT | varchar(50) | FK→GL_ACCOUNTS | Full account for tax inc price variance |
| 185 | SALES_PRICE_INC_TAX | numeric(20,4) | Standard Sales Price Including Tax | |
| 186 | PURCHASE_COST_INC_TAX | numeric(20,4) | Purchase Cost Including Tax | |
| 187 | INV_VALUATION_METHOD | varchar(4) | Inventory Valuation Method | |
| 188 | REVERSE_WAC_METHOD | varchar(3) | Reverse WAC calculation method | |
| 189 | LANDED_COST_IN_USE | varchar(1) | Flag to indicate landed cost in use | |
| 190 | PI_WINDOW_WEEKS | smallint | Projected Inventory Window Weeks | |
| 191 | EXCHANGE_RATE_VARIANCE_CODE | varchar(6) | Inventory Exchange Rate Variance Code | |
| 192 | EXCHANGE_RATE_VARIANCE_ACCOUNT | varchar(50) | Inventory Exchange Rate Variance Account | |
| 193 | SYS_ZERO_SHIP_SETTING | smallint | Zero Ship Setting | |
| 194 | TEST_QC_TEST_GROUP | varchar(6) | Inventory Test Group | |
| 195 | INCLUDE_IN_BRACKET_QTY | varchar(1) | Include Quantity in Bracket Price Level | |
| 196 | BRACKET_PRICE_ONLY | varchar(1) | Bracket Price Only | |
| 197 | GL_SIT | varchar(50) | FK→GL_ACCOUNTS | GL account Shipments in Transit |
| 198 | GL_SIT_CODE | varchar(6) | FK→GL_SHORT_CODES | GL short code Shipments in Transit |
| 199 | TOTAL_UNCONFIRMED_QTY | computed | ||
| 200 | QTY_OFFSET | computed | ||
| 201 | QTY_ORDERED_TOTAL | computed | ||
| 202 | QTY_COMMITTED_TOTAL | computed | ||
| 203 | DC_RECEIVING_PALLETS | varchar(1) | DC Receiving Pallets | |
| 204 | DISCONTINUE_FLAG | varchar(1) | Discontinue Master Record | |
| 205 | SO_MINIMUM_QTY | numeric(20,6) | Minimum Sales Quantity | |
| 206 | SO_INCREMENTAL_QTY | numeric(20,6) | Sales Incremental Quantity | |
| 207 | TW_STATUS | varchar(1) | Ross TabWare Send Flag | |
| 208 | DAIRY_COSTING_IN_USE | varchar(1) | Dairy costing in use | |
| 209 | MAKE_TO_ORDER | varchar(1) | Make to order jobs on Product Warehouse | |
| 210 | MTO_DAYS | smallint | Make to Order days Buffer | |
| 211 | REC_DAYS_TO_QOH | smallint | QC Receiving Days to QOH | |
| 212 | MANU_DAYS_TO_QOH | smallint | QC Manufacturing Days to QOH | |
| 213 | GEM_MODIFY_DATE | datetime | System timestamp of the most recent modification to the row, maintained by GEMBASE. |
Referenced by · 13 foreign keys
IC_PRODUCT_STATUSINVENTORY_TAGSINV_TRANSACTION_LINESBIN_LOCATION_DETAILSPOP_LINESPURCHASE_INVOICE_LINESPOP_REQUISITION_LINESPART_BATCHESPERIOD_USAGEPROMOTION_PRICESREORDERSSALES_ORDER_LINESSA_DETAIL_LINES