Apicosoft

ERP iScala Database Structure

iScala Supprort & Customization

Business processes implementation, ad-hock services, end-users training and education, maintenance support.

Read More Contact Us
Epicor Service Connect

Integration with any third-party services. Customize internal workflows.

Read More Contact Us
Reporting

SAP Crystal Reports, SQL Server Reporting Services, Excel.

Read More Contact Us
Tables
Name Description Dependences Example
SC01 Stock Item Master Table Company SC010100
SC03 Item Warehouse Company SC030100
SC04 Stock Extra Information Company SC040100
SC05 Serial Numbers Company SC050100
SC07 Stock Transactions Company SC070100
SC08 Discount per Product Group Company SC080100
SC10 Stock Parameters 1 Company SC100100
SC11 Stock Planning Company SC110100
SC13 Distribution Fees Company SC130100
SC14 Price Calculations Company SC140100
SC15 Calculation Parameters 1 Company SC150100
SC16 Serial Number History Company SC160100
SC19 Customer Order Discounts Company SC190100
SC1B Stock Budget Profiles 0-4 Company SC1B0100
SC1C Stock Budget Profiles 5-9 Company SC1C0100
SC1D Calculation Parameters 2 Company SC1D0100
SC22 Price Calculations Customers Company SC220100
SC23 Warehouse Master Table Company SC230100
SC24 Automatic Accounting Table SC Company SC240100
SC25 General Ledger Transactions Company Year SC250112
SC26 Transaction Index File Company SC260100
SC27 EC Trade Statistics Company SC270100
SC28 EC Tax Rep. wrk SC280000
SC2A Work File for EC Tax Reports Definition SC2A0000
SC30 Serial Number Remarks Company SC300100
SC33 Batch Information Company SC330100
SC34 Batch Costs Company SC340100
SC36 Bin Information Company SC360100
SC37 Stock Item Templates Company SC370100
SC38 Stock Item Volume Discount Templates Company SC380100
SC39 Price Lists Company SC390100
SC42 Stock Taking Lists Company SC420100
SC43 Batch Extra Description Company SC430100
SC45 Customer Discounts Company SC450100
SC46 Discount Templates Company SC460100
SC47 Discount Codes Company SC470100
SC48 Discount Descriptions Company SC480100
SC49 Discount Setup Company SC490100
SC4A Template Names Company SC4A0100
SC4B Discount Setup Descriptions Company SC4B0100
SC50 Discount Ranges Company SC500100
SC51 Template Values Company SC510100
SC52 Discount Accounting Company SC520100
SC53 Discount Schemas Company SC530100
SC54 Discount Scheme Descriptions Company SC540100
SC55 Schema Structure Company SC550100
SC56 Discount Setup Statistics Company SC560100
SC60 Shipment Company SC600100
SC61 Packing List Company SC610100
SC62 Box Header Company SC620100
SC63 Box Line Company SC630100
SC64 Box Element Company SC640100
SC65 Cycle Count Item Parameters Company SC650100
SC66 Cycle Counting Class Company SC660100
SC67 Cycle Counting Campaigns Company Year SC670112
SC68 Counting Parameters Company SC680100
SC69 Counting Proposal Header Company Year SC690112
SC70 Allocation History Company SC700100
SC71 Campaign Parameter Header Details Company Year SC710112
SC72 Counting Proposal Header History Company Year SC720112
SC73 Counting Proposal List Lines History Company Year SC730112
SC74 Cycle Counting Parameters Company SC740100
SC75 Counting Proposal List Lines Company Year SC750112
SC76 iScala Stock Balance History Company SC760100
SC77 WMS stock balance History Company SC770100
SC78 Box Handling Picking Proposal Company SC780100
SC79 Box Handling Reciept work file structure Company SC790100
SC7A SC Box Handling Reciept work file structure Company SC7A0100
SC7B Box Handling User-defined fields Company SC7B0100
SC7C Company SC7C0100
SC7D Company SC7D0100
SC7E Company SC7E0100
SC7F Company SC7F0100
SC7G Stock transfer order serial number Company SC7G0100
SC80 Company SC800100
SC81 Company SC810100
SC82 Company SC820100
SC83 Company SC830100
SC85 Company SC850100
SC86 Company SC860100
SC87 Company SC870100
SC88 Company SC880100
SC89 Company SC890100
SC8A Company SC8A0100
SC8B Company SC8B0100
SC8C Company SC8C0100
SC8D Company SC8D0100
SC90 Company SC900100
sca_trg_Audit_SC01 Audit trigger for SC01 table Company sca_trg_Audit_SC010100
sca_trg_Audit_SC03 Audit trigger for SC03 table Company sca_trg_Audit_SC030100
sca_trg_Audit_SC04 Audit trigger for SC04 table Company sca_trg_Audit_SC040100
sca_trg_Audit_SC10 Audit trigger for SC10 table Company sca_trg_Audit_SC100100
sca_trg_Audit_SC23 Audit trigger for SC23 table Company sca_trg_Audit_SC230100
sca_trg_Audit_SC39 Audit trigger for SC39 table Company sca_trg_Audit_SC390100
sca_trg_Audit_SCP3 Audit trigger for SCP3 table Company sca_trg_Audit_SCP30100
sca_trg_Audit_SCP5 Audit trigger for SCP5 table Company sca_trg_Audit_SCP50100
sca_trg_Audit_SCP6 Audit trigger for SCP6 table Company sca_trg_Audit_SCP60100
sca_trg_Audit_SCP7 Audit trigger for SCP7 table Company sca_trg_Audit_SCP70100
sca_trg_Audit_SCT1 Audit trigger for SCT1 table Company sca_trg_Audit_SCT10100
SCA1 Rules for MPC WO allocations Company SCA10100
SCB0 Box headers for Picking module Company SCB00100
SCB1 Stock Control BOM Node Company SCB10100
SCB2 Stock Control BOM Name Company SCB20100
SCB3 Stock Control BOM Link Company SCB30100
SCB4 Stock Control BOM Branch Company SCB40100
SCB5 BOM Template Names Company SCB50100
SCB6 Work file for ATP Rescheduling SCB60000
SCB7 Temporary Stock planning table,ATP SCB70000
SCB8 Work file for splitted lines, ATP SCB80000
SCB9 BOM Printing Options Company SCB90100
SCBA Company SCBA0100
SCBG Temporary ATP Period table SCBG0000
SCBH Box headers history for Picking module Company SCBH0100
SCBP Bin Location Proposals Company SCBP0100
SCCF Commodity code description Company SCCF0100
SCCT Commodity code Company SCCT0100
SCDA Default Accounting Matrix Company SCDA0100
SCDB Default Bins Company SCDB0100
SCDF Commodity code segment description Company SCDF0100
SCDT Commodity code segment definition Company SCDT0100
SCF1 Exposed Stock Item Company SCF10100
SCGL General Ledger Transactions (History) Company SCGL0100
SCH0 Stock Withdrawal Parameters Company SCH00100
SCH3 Stock Account Matrix Company SCH30100
SCH4 Credit Account Matrix Company SCH40100
SCH5 Department Company SCH50100
SCI1 Reason Codes descriptions Company SCI10100
SCI2 Reason Code features Company SCI20100
SCII Inwarding Information Company SCII0100
SCK4 Supplier Priorities for Quality Control Company SCK40100
SCL1 Batch Tax Transactions Company SCL10100
SCLC Logistic form Connections Company SCLC0100
SCLF Logistic forms Company SCLF0100
SCP1 Life Cycle Phase Definition Company SCP10100
SCP2 Life Cycle Phase Strings Company SCP20100
SCP3 Stock Item Life Cycle Phase Company SCP30100
SCP5 Discount per Stock Code Company SCP50100
SCP6 Price and Discount per Stock code - Customer Company SCP60100
SCP7 Price and Discount per Stock code - Supplier Company SCP70100
SCRE REACH Report Company SCRE0100
SCSW Company SCSW0100
SCT1 Stock Item Extra Batch Information Company SCT10100
SCT2 Batch User Authorization Company SCT20100
SCT5 Customer/Supplier Control Company SCT50100
SCT6 Trace Batch Changes Company SCT60100
SCT7 Batch Price List Company SCT70100
SCT8 Batch Templates Company SCT80100
SCT9 Company SCT90100
SCUC unit codes Company SCUC0100
SCUN unit names in different languages Company SCUN0100
SCW1 Central Warehouse Definition SCW10000
SCW2 Transaction Warehouse Definition SCW20000
SCW3 Central Warehouse Picking List Head Company SCW30100
SCW4 Central Warehouse Order Process Status SCW40000
SCW5 Company SCW50100
SCW6 Company SCW60100
SCW7 Company SCW70100
SCW8 Central Warehouse Order Head Extension SCW80000
SCW9 Central Warehouse Order Line Extension SCW90000
SCWA Warehouse Area Company SCWA0100
SCWB Central Warehouse Picking List Line Company SCWB0100
SCWC Central Warehouse Customer Values SCWC0000
SCWD Central Warehouse Order Status and Parameters SCWD0000
SCWE Company SCWE0100
SCWF Intercompany Serial Number Transfer Transactions SCWF0000
SCWG Delivery Errors SCWG0000
SCWH Central Warehouse Picking List Allocations SCWH0000
SCWI Central Warehouse Merged Picking Lists Company SCWI0100
SCWL Central Warehouse Serial Number Transfer Company SCWL0100
SCWM Central Warehouse Delivery Transactions SCWM0000
SCWQ Central Warehouse Picking List Log Company SCWQ0100
SCWS Central Warehouse Central VAT Codes SCWS0000
SCWT Central Warehouse Central VAT Code References SCWT0000
SCWU Central Warehouse VAT Macro References SCWU0000
SCWW Central Warehouse Intercompany Delivery Transaction History SCWW0000
SCXP Extra Parameters Company SCXP0100
SCXX Work File for Batch Trace SCXX0000
SCXZ Work File for ABC-Analysis SCXZ0000
SCZ5 Tax Exemptions Company SCZ50100
SCZ6 Tax exemption settings on NCM code level Company SCZ60100
SL61 Reminder Proposal Company SL610100
ST30 Stock Item - Packaging Codes Company ST300100
ST31 Temporary ST310000

Fields
PK Table Name Description Type Length Precision Note
1 SC37 SC37001 StockCode VSTRING 35 35 0 Stock Item Template Code
SC37 SC37002 Description1 VSTRING 25 25 0 Description Line 1
SC37 SC37003 Description2 VSTRING 25 25 0 Description Line 1
SC37 SC37004 PriceLocCurr MONEY 20 28 8 Price (Local Currency)
SC37 SC37005 NewPriceLCU MONEY 20 28 8 New Price (Local Currency)
SC37 SC37006 DateNewPrice DATE 8 0 0 Date to Activate New Price
SC37 SC37007 Lenght X_NUMERIC 10 18 8 Length
SC37 SC37008 Width X_NUMERIC 10 18 8 Width
SC37 SC37009 Height X_NUMERIC 10 18 8 Height
SC37 SC37010 UserDefined1 VSTRING 10 10 0 User Defined Field 1
SC37 SC37011 UserDefined2 VSTRING 10 10 0 User Defined Field 2
SC37 SC37012 UserDefined3 VSTRING 8 8 0 User Defined Field 3
SC37 SC37013 UserDefined4 VSTRING 6 6 0 User Defined Field 4
SC37 SC37014 UserDefined5 VSTRING 4 4 0 User Defined Field 5
SC37 SC37015 UserDefined6 VSTRING 4 4 0 User Defined Field 6
SC37 SC37016 UserDefined7 VSTRING 2 2 0 User Defined Field 7
SC37 SC37017 UserDefined8 VSTRING 2 2 0 User Defined Field 8
SC37 SC37018 UserDefined9 VSTRING 2 2 0 User Defined Field 9
SC37 SC37019 UserDefine10 VSTRING 2 2 0 User Defined Field 10
SC37 SC37020 AllowNegQty SWITCH 1 1 0 Allow Negative Balances
SC37 SC37021 TestSNqty INTEGER 1 0 0 Test Serial Number Quantity
SC37 SC37022 AllwAlphaSN SWITCH 1 1 0 Allow Alphanumeric Serial Numbers
SC37 SC37023 ExtProdGroup VSTRING 20 20 0 Extended Product Group
SC37 SC37024 AlphSerchKey VSTRING 25 25 0 Alpha Search Key
SC37 SC37025 UnConvSalPr VSTRING 10 10 0 (obsolete)
SC37 SC37026 Purchaser VSTRING 6 6 0 Purchaser Code
SC37 SC37027 Planner VSTRING 3 3 0 Planner
SC37 SC37028 SC0128SPARE VSTRING 27 27 0 (obsolete)
SC37 SC37029 SC0129SPARE VSTRING 8 8 0 (obsolete)
SC37 SC37030 ReplacemItem VSTRING 1 1 0 Replacement Item
SC37 SC37031 DiscountCode INTEGER 3 0 0 Discount Code
SC37 SC37032 FLAGusesBatc SWITCH 1 1 0 Batch Controlled
SC37 SC37033 ExtraTaxCode INTEGER 1 0 0 Extra Tax Code
SC37 SC37034 DistCharCode INTEGER 1 0 0 Distribution Charge Code
SC37 SC37035 AccountCode STRING 2 2 0 Accounting Code
SC37 SC37036 DelCalenCode VSTRING 4 4 0 (obsolete)
SC37 SC37037 ProductGroup VSTRING 4 4 0 Product Group
SC37 SC37038 AltProdGroup VSTRING 4 4 0 Alternative Product Group
SC37 SC37039 AccCodeStrg ACCSTR 120 120 0 Accounting String
SC37 SC37040 MinPurchQty X_NUMERIC 12 20 8 Minimum Purchase Quantity
SC37 SC37041 MaxPurchQty X_NUMERIC 12 20 8 Maximum Purchase Quantity
SC37 SC37042 StockBalance X_NUMERIC 12 20 8 Stock Balance Total balance for all warehouses
SC37 SC37043 ReservedQty X_NUMERIC 12 20 8 Reserved Quantity Total reserved quantity for all warehouses
SC37 SC37044 BackOrdeQty X_NUMERIC 12 20 8 Back-Ordered Quantity Total back-ordered quantity for all warehouses
SC37 SC37045 SCQtyOrder X_NUMERIC 12 20 8 Quantity Ordered Quantity Total quantity ordered from supplier, for all warehouses
SC37 SC37046 StockTakDiff X_NUMERIC 12 20 8 Stock Tacking Difference Total stocktaking difference in quantity, for all warehouses
SC37 SC37047 UnitCodSalPr VSTRING 2 2 0 (obsolete)
SC37 SC37048 StockTakDate DATE 8 0 0 Latest Stock Taking Date
SC37 SC37049 DelDateSuppl DATE 8 0 0 Last Delivery Date from Suppliers
SC37 SC37050 DelDateCust DATE 8 0 0 Last Delivery Date to Customers
SC37 SC37051 OrdDateSuppl DATE 8 0 0 Last Order Date from Suppliers
SC37 SC37052 AverCostPri1 X_NUMERIC 20 28 8 Average Cost Price (Local Currency) Average cost price in base currency, this is always the same as for the standard warehouse defined in the stock control parameters.
SC37 SC37053 StdCostPric1 MONEY 20 28 8 Standard Cost Price (Local Currency) Standard cost price in base currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default standard cost for new warehouses.
SC37 SC37054 QtyRecSuppl X_NUMERIC 12 20 8 Quantity Received from Suppliers
SC37 SC37055 PurchasePric MONEY 20 28 8 Purchase Price (Purchase Currency)
SC37 SC37056 CurrCodePurc VSTRING 2 2 0 Currency Code Purchase
SC37 SC37057 CalcSurcharg X_NUMERIC 6 14 8 Estimated On-cost % Purchase surcharge expressed as a percentage, this increase the stock value when receiving goods and represents shipping, customs etc... The value on the stock item is only used as default value that will be inherited by new warehouse, the actual percentage used is defined on the warehouse.
SC37 SC37058 SupplierCode VSTRING 10 10 0 Supplier Code
SC37 SC37059 AlternSuppl VSTRING 10 10 0 Alternative Supplier Code
SC37 SC37060 SupplStockCo VSTRING 35 35 0 Supplier Stock Code
SC37 SC37061 ReOrdLevel X_NUMERIC 12 20 8 Re-order Level This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating purchase proposals is the value defined on the warehouse.
SC37 SC37062 DelTimeWeek INTEGER 3 0 0 Delivery Time This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating delivery time is the value defined on the warehouse.
SC37 SC37063 OptPurchQty X_NUMERIC 12 20 8 Economic Order Quantity This value will only be used as default value that will be inherited for new warehouses, the actual value used when calculating purchase proposals is the value defined on the warehouse.
SC37 SC37064 BudgQTYYear X_NUMERIC 12 20 8 Budgeted Ship Quantity per Year This is the total budgeted quantity to ship per year and it includes budget from all warehouses.
SC37 SC37065 BudgetModel INTEGER 1 0 0 Budget Model
SC37 SC37066 ArticlStatus INTEGER 1 0 0 Stock Item Status
SC37 SC37067 CountOfOrgin VSTRING 3 3 0 Country of Origin
SC37 SC37068 DelTimeUnit INTEGER 1 0 0 Delivery Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
SC37 SC37069 NetWeight X_NUMERIC 10 18 8 Net Weight
SC37 SC37070 GrossWeight X_NUMERIC 10 18 8 Gross Weight
SC37 SC37071 Volume X_NUMERIC 10 18 8 Volume
SC37 SC37072 QtyUnitInDel X_NUMERIC 10 18 8 Items per Package (Purchase)
SC37 SC37073 QtyUniOutDel X_NUMERIC 10 18 8 Items per Package (Sales)
SC37 SC37074 ABCCode VSTRING 1 1 0 ABC Code
SC37 SC37075 FrequenCode VSTRING 1 1 0 Frequency Code
SC37 SC37076 AttachedFlag SWITCH 1 1 0 Frequency Flag
SC37 SC37077 ProfitLCUPer MONEY 20 28 8 Profit Period (Local Currency)
SC37 SC37078 ProfitLCUYTD MONEY 20 28 8 Profit YTD (Local Currency)
SC37 SC37079 ProYTDPrevYr MONEY 20 28 8 Profit YTD Previous Year (Local Currency)
SC37 SC37080 ProfYTDPrYr1 MONEY 20 28 8 Profit YTD Previous Year - 1 (Local Currency)
SC37 SC37081 SalesLCUPer MONEY 20 28 8 Sales Period (Local Currency)
SC37 SC37082 SalesLCUYTD MONEY 20 28 8 Sales YTD (Local Currency)
SC37 SC37083 SalYTDPrevYr MONEY 20 28 8 Sales YTD Previous Year (Local Currency)
SC37 SC37084 SaleYTDPrYr1 MONEY 20 28 8 Sales YTD Previous Year - 1 (Local Currency)
SC37 SC37085 QtyLCUPeriod X_NUMERIC 12 20 8 Quantity Sold Period
SC37 SC37086 QtyLCUYTD X_NUMERIC 12 20 8 Quantity Sold YTD
SC37 SC37087 QtyYTDPreYr X_NUMERIC 12 20 8 Quantity Sold Previous Year
SC37 SC37088 QtyYTDPrYr1 X_NUMERIC 12 20 8 Quantity Sold Previous Year - 1
SC37 SC37089 ReplStocCode VSTRING 35 35 0 Replacement Stock Code
SC37 SC37090 PurchRoule INTEGER 1 0 0 Purchase Rule 0 - Purchase proposals are based on entered sales orders
1 - Purchase proposals are based on budgeted quantity.
SC37 SC37091 ShipmRoule INTEGER 1 0 0 Shipment Rule 0 - No test of the stock balance.
1 - Test on positive stock balance.
2 - Closed stock item, blocked for orders.
3 - Direct delivery from Supplier to customers (no stock transactions/planning is created)
4 - No over delivery allowed
5 - Back delivery to purchase control
SC37 SC37092 DesNewPrice DATE 8 0 0 Date to Deactivate New Price
SC37 SC37093 InternRem1 VSTRING 25 25 0 Internal Remark Line 1
SC37 SC37094 InternRem2 VSTRING 25 25 0 Internal Remark Line 2
SC37 SC37095 CommissCode INTEGER 1 0 0 Commission Code 1 Related to commission setup in statistic module and are used for calculating commissions for salesmen.
SC37 SC37096 StructurFlag INTEGER 1 0 0 BOM Flag
SC37 SC37097 QueryQueNo INTEGER 1 0 0 Query Queue Number
SC37 SC37098 SellPricMult X_NUMERIC 10 18 8 Selling Price Multiple
SC37 SC37099 PurcPricMult X_NUMERIC 10 18 8 Cost Price Multiple
SC37 SC37100 StatCodeExte VSTRING 14 14 0 Statistical Code Extended
SC37 SC37101 CustWarrMont INTEGER 3 0 0 Customer Warranty
SC37 SC37102 InspecInterv STRING 4 4 0 Inspection Interval Used in service order and defines the interval between inspections for this stock item. The value is used as default for new serial numbers but can be changed on each item.
The leading character specifies the time unit used where 'W' stands for weeks, 'M' for month and no leading character for number of days.
SC37 SC37103 MaintenInter STRING 4 4 0 Maintenance Interval Used in service order and defines the maintenance interval for this stock item. The value is used as default for new serial numbers but can be changed on each item.
The leading character specifies the time unit used where 'W' stands for weeks, 'M' for month and no leading character for number of days.
SC37 SC37104 AccrualCode INTEGER 2 0 0 Bonus Code Used for calculating bonus for customers. The value can be between 0 and 99 and this is combined in a matrix with bonus code on the customer to determine the percentage to use.
SC37 SC37105 CommisCode2 INTEGER 2 0 0 Commission Code 2 Used for calculating commissions to salesmen. The value can be between 0 and 99 and this is combined in a matrix with bonus code on the customer to determine the percentage to use.
SC37 SC37106 LandedCost MONEY 20 28 8 Landed Cost (Local Currency) Landed cost in base currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default landed cost for new warehouses.
SC37 SC37107 ServiceLevel VSTRING 1 1 0 Service Level
SC37 SC37108 PrfLCUNxtPer MONEY 20 28 8 Profit Next Period (Local Currency)
SC37 SC37109 PrfLCUNetYTD MONEY 20 28 8 Profit Next YTD (Local Currency)
SC37 SC37110 SalLCUNxtPer MONEY 20 28 8 Sales Next Period (Local Currency)
SC37 SC37111 SalLCUNxtYTD MONEY 20 28 8 Sales Next YTD (Local Currency)
SC37 SC37112 QtyLCUNxtPer X_NUMERIC 12 20 8 Quantity Sold Next Period
SC37 SC37113 QtyLCUNxtYTD X_NUMERIC 12 20 8 Quantity Sold Next YTD
SC37 SC37114 DefaultBinNo VSTRING 6 6 0 Default Bin Code
SC37 SC37115 MaintContCod VSTRING 1 1 0 Maintenance Contract Code
SC37 SC37116 RecCreatDate DATE 8 0 0 Date Created
SC37 SC37117 ContrDistrib SWITCH 1 1 0 Controlled Distribution
SC37 SC37118 StarContDist DATE 8 0 0 Start Date Controlled Distribution
SC37 SC37119 EndContDist DATE 8 0 0 End Date Controlled Distribution
SC37 SC37120 HoldStatus SWITCH 1 1 0 Product on Hold
SC37 SC37121 HldStaSrtDat DATE 8 0 0 Hold Status Start Date
SC37 SC37122 HldStaEndDat DATE 8 0 0 Hold Status End Date
SC37 SC37123 EndOfLifeDat DATE 8 0 0 End of Life Date
SC37 SC37124 ObsoleteDate DATE 8 0 0 Obsolete Date
SC37 SC37125 ReplacemDate DATE 8 0 0 Replacement Date
SC37 SC37126 EquiStckCode VSTRING 35 35 0 Equivalent Stock Code
SC37 SC37127 SerNoStatus INTEGER 1 0 0 Serial Number Status
SC37 SC37128 ProductCateg VSTRING 10 10 0 Product Category
SC37 SC37129 BudgetMode INTEGER 1 0 0 Service Priorities
SC37 SC37130 ApplicCode1 VSTRING 2 2 0 Application Code 1
SC37 SC37131 ApplicCode2 VSTRING 2 2 0 Application Code 2
SC37 SC37132 EANCode VSTRING 35 35 0 EAN Code
SC37 SC37133 UnitCodeStoc INTEGER 4 0 0 Unit Code Stock
SC37 SC37134 UnitCodePurc INTEGER 4 0 0 Unit Code Purchase
SC37 SC37135 UnitCodeSale INTEGER 4 0 0 Unit Code Sales
SC37 SC37136 UnitCodeMPC INTEGER 4 0 0 Unit Code MPC
SC37 SC37137 UnitCodeSpar INTEGER 4 0 0 Unit Code Other
SC37 SC37138 SPARE VSTRING 4 4 0 (obsolete)
SC37 SC37139 UnitConvStoc X_NUMERIC 14 22 8 Unit Factor for Stock Unit
SC37 SC37140 UnitConvPurc X_NUMERIC 14 22 8 Unit Factor for Purchase Unit
SC37 SC37141 UnitConvSale X_NUMERIC 14 22 8 Unit Factor for Sales Unit
SC37 SC37142 UnitConvMPC X_NUMERIC 14 22 8 Unit Factor for MPC Unit
SC37 SC37143 UnitConvSpar X_NUMERIC 14 22 8 Unit Factor for Other Unit
SC37 SC37144 SalesTaxCodeSTE INTEGER 2 0 0 Sales Tax Code STE
SC37 SC37145 PurchaseTaxCodeSTE INTEGER 2 0 0 Purchase Tax Code STE
SC37 SC37146 StandRepCost MONEY 20 28 8 Standard Repair Cost (Local Currency)
SC37 SC37147 FlagReparab SWITCH 1 1 0 Reparable
SC37 SC37148 StanCostPric MONEY 20 28 8 Standard Cost Price (Alternative Currency) Average cost price in alternative currency, this is always the same as for the standard warehouse defined in the stock control parameters.
(Alternative currency is used for keeping stock accounting values if two currencies where the alternative is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.)
SC37 SC37149 AverCostPric MONEY 20 28 8 Average Cost Price (Alternative Currency) Standard cost price in alternative currency, this is always the same as for the standard warehouse defined in the stock control parameters. It will also be used as default standard cost for new warehouses.
(Alternative currency is used for keeping stock accounting values if two currencies where the alternative is intended to be used together with consolidation. The alternative currency to use is defined in the stock control parameters.)
SC37 SC37150 ComplStockIt VSTRING 35 35 0 Complementary Stock Item
SC37 SC37151 FlagExchRule INTEGER 1 0 0 Exchange Rule 0 - No test is performed for exchange items.
1 - Test for exchange items is performed when releasing service orders.
2 - Exchange item must be in stock before releasing service orders.
SC37 SC37152 BatcNoPrefix STRING 2 2 0 Batch Number Prefix
SC37 SC37153 BatchNumber NUMBER 6 20 0 Batch Number
SC37 SC37154 BatcNOSuffix NUMBER 3 20 0 Batch Number Suffix
SC37 SC37155 QCOnHand X_NUMERIC 12 20 8 QC On-hand
SC37 SC37156 BOANumber STRING 3 3 0 BOA-number
SC37 SC37157 ABCCost1 MONEY 20 28 8 ABC-Cost 1 (Local Currency)
SC37 SC37158 ABCCost2 MONEY 20 28 8 ABC-Cost 2 (Local Currency)
SC37 SC37159 DirectCost MONEY 20 28 8 Direct Cost
SC37 SC37160 ExtUserDefFld1 VSTRING 150 150 0 Ext. User defined field 1
SC37 SC37161 ExtUserDefFld2 VSTRING 150 150 0 Ext. User defined field 2
SC37 SC37162 ExtUserDefFld3 VSTRING 150 150 0 Ext. User defined field 3
SC37 SC37163 ExtUserDefFld4 VSTRING 150 150 0 Ext. User defined field 4
SC37 SC37164 ExtUserDefFld5 VSTRING 150 150 0 Ext. User defined field 5
SC37 SC37165 ExtUserDefFld6 VSTRING 150 150 0 Ext. User defined field 6
SC37 SC37166 ExtUserDefFld7 VSTRING 150 150 0 Ext. User defined field 7
SC37 SC37167 ExtUserDefFld8 VSTRING 150 150 0 Ext. User defined field 8
SC37 SC37168 ExtUserDefFld9 VSTRING 150 150 0 Ext. User defined field 9
SC37 SC37169 ExtUserDefFld10 VSTRING 150 150 0 Ext. User defined field 10
SC37 SC37170 ExtUserDefFld11 VSTRING 150 150 0 Ext. User defined field 11
SC37 SC37171 ExtUserDefFld12 VSTRING 150 150 0 Ext. User defined field 12
SC37 SC37172 ExtUserDefFld13 VSTRING 150 150 0 Ext. User defined field 13
SC37 SC37173 ExtUserDefFld14 VSTRING 150 150 0 Ext. User defined field 14
SC37 SC37174 ExtUserDefFld15 VSTRING 150 150 0 Ext. User defined field 15
SC37 SC37175 ExtUserDefFld16 VSTRING 150 150 0 Ext. User defined field 16
SC37 SC37176 ExtUserDefFld17 VSTRING 150 150 0 Ext. User defined field 17
SC37 SC37177 ExtUserDefFld18 VSTRING 150 150 0 Ext. User defined field 18
SC37 SC37178 ExtUserDefFld19 VSTRING 150 150 0 Ext. User defined field 19
SC37 SC37179 ExtUserDefFld20 VSTRING 150 150 0 Ext. User defined field 20
SC37 SC37180 DelMarginRule INTEGER 1 0 0 Delivery Margin Rule
SC37 SC37181 DelMargin X_NUMERIC 6 14 8 Delivery Margin %
SC37 SC37182 OverDeliveryQty X_NUMERIC 12 20 8 (obsolete)
SC37 SC37183 AllocatedQty X_NUMERIC 12 20 8 Allocated Quantity Total quantity allocated to orders, for all warehouses
SC37 SC37184 DropShipment VSTRING 1 1 0 Drop Shipment Rule 0 - No drop shipment
1 - Manually select drop shipment at time of order
2 - Automatically create drop shipment order
3 - Optional drop shipment
SC37 SC37185 POReceipt VSTRING 1 1 0 Purchase Order Receipt Rule, Drop Shipment 0 - Receive into Inventory
1 - Receive into Inventory and hard allocate to sales/service order
2 - Receive into Inventory and issue to sales/service order
3 - Issue to sales/service order without inventory update
SC37 SC37186 DelLeadTime INTEGER 3 0 0 Delivery Lead Time
SC37 SC37187 DelLeadTimeUnit INTEGER 1 0 0 Delivery Lead Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
SC37 SC37188 POAdjustment INTEGER 1 0 0 Purchase Order Adjustment, Drop Shipment
SC37 SC37189 AvailableServices INTEGER 1 0 0 Available Services
SC37 SC37190 RepairCostRange STRING 25 25 0 Repair Cost Range
SC37 SC37191 RepairCostRange2 STRING 25 25 0 Repair Cost Range
SC37 SC37192 CostProposalRequiredFlag INTEGER 1 0 0 Cost Proposal Required
SC37 SC37193 DefaultExchangePriceList STRING 2 2 0 Default Exchange Price List
SC37 SC37194 DefaultEngineer STRING 10 10 0 Default Engineer
SC37 SC37195 DefaultWarrantyCustShopOrders STRING 10 10 0 Default Warranty Customer Shop Orders
SC37 SC37196 ATPcheckItem INTEGER 1 0 0 ATP Check Item
SC37 SC37197 QualityControl SWITCH 1 1 0 Quality Control
SC37 SC37198 DangerousGoods SWITCH 1 1 0 Dangerous Goods
SC37 SC37199 BatchPickingOrder INTEGER 1 0 0 Batch Picking Order 0 - FIFO order (first in first out)
1 - LIFO order (last in first out)
2 - FEFO order (first expire first out)
3 - Best before date order
4 - Bin number order
SC37 SC37200 RentalTimeUnitDefault INTEGER 2 0 0 Default Rental Time Unit 1 - Years
2 - Month
3 - Weeks
4 - Days
5 - Hours
6 - Minutes
SC37 SC37201 ECVATExemptFlag INTEGER 1 0 0 EC VAT Exempt
SC37 SC37202 BinControl INTEGER 1 0 0 Bin Controlled
SC37 SC37203 ItemBranchPlacement INTEGER 1 0 0 Item/Branch Placement 0 - No restrictions
1 - One stock item per bin
2 - One batch per bin
3 - One batch per stock item and bin, but different stock items allowed.
SC37 SC37204 MinTemperature INTEGER 3 0 0 Minimum Storage Temperature
SC37 SC37205 MaxTemperature INTEGER 3 0 0 Maximum Storage Temperature
SC37 SC37206 MinHumidity INTEGER 3 0 0 Minimum Storage Humidity
SC37 SC37207 MaxHumidity INTEGER 3 0 0 Maximum Storage Humidity
SC37 SC37208 StorageType1 STRING 1 1 0 Storage Type 1
SC37 SC37209 StorageType2 STRING 1 1 0 Storage Type 2
SC37 SC37210 StorageType3 STRING 1 1 0 Storage Type 3
SC37 SC37211 StorageType4 STRING 1 1 0 Storage Type 4
SC37 SC37212 BinLocationRuleType VSTRING 4 4 0 Bin Location Rule Type
SC37 SC37213 DSSuppSelRuleType STRING 2 2 0 Drop Shipment Supplier Selection Rule 0 - Supplier from stock item is used.
1 - Supplier with the lowest purchase price is used.
2 - Supplier with the shortest delivery time is used.
3 - If stock item has no defined supplier the supplier with the lowest purchase price is used.
4 - If stock item has no defined supplier the supplier with the shortest delivery time is used.
SC37 SC37214 CreateConfiguration INTEGER 1 0 0 Create Configuration 0 - System will not create a configuration with the current stock item as a top one
1 - System will ask whether if should create a configuration with the current stock item as a top one
2 - System will always create a configuration with the current stock item as a top one
SC37 SC37215 ConfigurationCode STRING 35 35 0 Configuration Code
SC37 SC37216 SaveConfigurationHistory STRING 1 1 0 Save Configuration History
SC37 SC37217 IssueExpiredBatch INTEGER 1 0 0 Allow Issue from Expired Batches
SC37 SC37218 SalesTaxCodeATE STRING 6 6 0 Sales Tax Code ATE
SC37 SC37219 FEFOOrder SWITCH 1 1 0 FEFO Order
SC37 SC37220 PortionSize X_NUMERIC 20 28 8 Portion Size
SC37 SC37221 MultipleFactor X_NUMERIC 20 28 8 Multiple Factor
SC37 SC37222 CalorificValue X_NUMERIC 20 28 8 Calorific Value
SC37 SC37223 ProteinValue X_NUMERIC 20 28 8 Protein Value
SC37 SC37224 FatValue X_NUMERIC 20 28 8 Fat Value
SC37 SC37225 CarbohydrateValue X_NUMERIC 20 28 8 Carbohydrate Value
SC37 SC37226 PLAccount VSTRING 12 12 0 P&L Account
SC37 SC37227 BOMDefaultUOMCode INTEGER 4 0 0 BOM default UOM code
SC37 SC37228 BOMDefaultUOMFactor X_NUMERIC 18 26 8 BOM default UOM factor
SC37 SC37229 ItemType VSTRING 10 10 0 Item Type Item Type
SC37 SC37230 TariffNo VSTRING 25 25 0 Tariff Number Tariff Number
SC37 SC37231 OriginCode STRING 1 1 0 Origin Code
SC37 SC37232 NomenclatureNo VSTRING 25 25 0 Nomenclature No
SC37 SC37233 GoodsType STRING 2 2 0 Goods Type
SC37 SC37234 StockValModel VSTRING 1 1 0 Valuation Model
SC37 SC37235 StockValModelForCC VSTRING 1 1 0 Valuation Model for Alternative Currency
SC37 SC37236 BOMDiscountMethod VSTRING 1 1 0 BOM discount method
SC37 SC37237 LTMGroupOR STRING 6 6 0 LTM Group OR
SC37 SC37238 LTMGroupPC STRING 6 6 0 LTM Group PC
SC37 SC37239 BOMCost X_NUMERIC 20 28 8 BOM Cost
SC37 SC37240 GTIN VSTRING 35 35 0 GTIN
SC37 SC37241 UDefBarCodeIdent VSTRING 150 150 0 Udef Barcode identities
SC37 SC37242 DTF INTEGER 3 0 0 Demand Time Fence
SC37 SC37243 IncomingPropertiesControl SWITCH 1 1 0 Incoming Properties Control
SC37 SC37244 TemperatureRequiredFlag INTEGER 1 0 0 Temperature required flag
SC37 SC37245 Humidityrequiredflag INTEGER 1 0 0 Humidity required flag
SC37 SC37246 TemperatureEnforceFlag INTEGER 1 0 0 Temperature enforce flag
SC37 SC37247 HumidityEnforce INTEGER 1 0 0 Humidity enforce flag
SC37 SC37248 TemperatureUnit INTEGER 2 0 0 Temperature unit code
SC37 SC37249 ExtendedCommissionCode STRING 2 2 0 Extended Commission Code
SC37 SC37250 ExportStatus INTEGER 1 0 0 Export Status
SC37 SC37251 ChargeCostForPackMtrl SWITCH 1 1 0 Charge Cost per Packaging Materials?
SC37 SC37252 FixedChargeWeight SWITCH 1 1 0 Fixed charge per weight?
SC37 SC37253 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
SC37 SC37254 CommodityCode VSTRING 35 35 0 Commodity Code
SC37 SC37255 CreatedBy VSTRING 8 8 0 Created By
SC37 SC37256 PurchaseTaxCodeATE STRING 6 6 0 Purchase Tax Code ATE
SC37 SC37257 ProductTaxType VSTRING 10 10 0 Product Tax Type
SC37 SC37258 REACHUUID VSTRING 45 45 0 REACH UUID
SC37 SC37259 REACHWeight X_NUMERIC 10 18 8 REACH Weight
SC37 SC37260 REACHWeightUnit INTEGER 4 0 0 REACH Weight Unit
SC37 SC37261 REACHFromDate DATE 8 0 0 REACH From Date
SC37 SC37262 REACHToDate DATE 8 0 0 REACH To Date
SC37 SC37263 AssetPurchase INTEGER 1 0 0 Asset Purchase
SC37 SC37264 AssetAccount VSTRING 12 12 0 Asset Account
SC37 SC37265 AssetPerUnit INTEGER 1 0 0 Asset Per Unit
SC37 SC37266 TaxReasonCode STRING 3 3 0 Tax Reason Code
SC37 SC37267 Deactivated SWITCH 1 1 0 Deactivated Deactivated