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 SC01 SC01001 StockCode VSTRING 35 35 0 Stock Item Code
SC01 SC01002 Description1 VSTRING 25 25 0 Description Line 1
SC01 SC01003 Description2 VSTRING 25 25 0 Description Line 2
SC01 SC01004 PriceLocCurr MONEY 20 28 8 Selling Price (Local Currency)
SC01 SC01005 NewPriceLCU MONEY 20 28 8 New Selling Price (Local Currency)
SC01 SC01006 DateNewPrice DATE 8 0 0 Date to Activate New Price
SC01 SC01007 Lenght X_NUMERIC 10 18 8 Length
SC01 SC01008 Width X_NUMERIC 10 18 8 Width
SC01 SC01009 Height X_NUMERIC 10 18 8 Height
SC01 SC01010 UserDefined1 VSTRING 10 10 0 User Defined Field 1
SC01 SC01011 UserDefined2 VSTRING 10 10 0 User Defined Field 2
SC01 SC01012 UserDefined3 VSTRING 8 8 0 User Defined Field 3
SC01 SC01013 UserDefined4 VSTRING 6 6 0 User Defined Field 4
SC01 SC01014 UserDefined5 VSTRING 4 4 0 User Defined Field 5
SC01 SC01015 UserDefined6 VSTRING 4 4 0 User Defined Field 6
SC01 SC01016 UserDefined7 VSTRING 2 2 0 User Defined Field 7
SC01 SC01017 UserDefined8 VSTRING 2 2 0 User Defined Field 8
SC01 SC01018 UserDefined9 VSTRING 2 2 0 User Defined Field 9
SC01 SC01019 UserDefine10 VSTRING 2 2 0 User Defined Field 10
SC01 SC01020 AllowNegQty SWITCH 1 1 0 Allow Negative Balances
SC01 SC01021 TestSNqty INTEGER 1 0 0 Test Serial Number Quantity
SC01 SC01022 AllwAlphaSN SWITCH 1 1 0 Allow Alphanumeric Serial Numbers
SC01 SC01023 ExtProdGroup VSTRING 20 20 0 Extended Product Group
SC01 SC01024 AlphSerchKey VSTRING 25 25 0 Alpha Search Key
SC01 SC01025 UnConvSalPr VSTRING 10 10 0 Unit Convert for SALES PRICES
SC01 SC01026 Purchaser VSTRING 6 6 0 Purchaser Code
SC01 SC01027 Planner VSTRING 3 3 0 Planner
SC01 SC01028 SC0128SPARE VSTRING 27 27 0 Spare
SC01 SC01029 SC0129SPARE VSTRING 8 8 0 Spare
SC01 SC01030 ReplacemItem VSTRING 1 1 0 Replacement Item flag
SC01 SC01031 DiscountCode INTEGER 3 0 0 Discount Code
SC01 SC01032 FLAGusesBatc SWITCH 1 1 0 Batch Controlled
SC01 SC01033 ExtraTaxCode INTEGER 1 0 0 Other Tax Code
SC01 SC01034 DistCharCode INTEGER 1 0 0 Distribution Charge Code
SC01 SC01035 AccountCode STRING 2 2 0 Accounting Code
SC01 SC01036 DelCalenCode VSTRING 4 4 0 Delivery Calendar Code
SC01 SC01037 ProductGroup VSTRING 4 4 0 Product Group
SC01 SC01038 AltProdGroup VSTRING 4 4 0 Alternative Product Group
SC01 SC01039 AccCodeStrg ACCSTR 120 120 0 Accounting String
SC01 SC01040 MinPurchQty X_NUMERIC 12 20 8 Min purchase quantity
SC01 SC01041 MaxPurchQty X_NUMERIC 12 20 8 Max purchase quantity
SC01 SC01042 StockBalance X_NUMERIC 12 20 8 Stock balance Total balance for all warehouses
SC01 SC01043 ReservedQty X_NUMERIC 12 20 8 Reserved stock Total reserved quantity for all warehouses
SC01 SC01044 BackOrdeQty X_NUMERIC 12 20 8 Back-ordered quantity Total back-ordered quantity for all warehouses
SC01 SC01045 SCQtyOrder X_NUMERIC 12 20 8 Purchase order quantity Total quantity ordered from supplier, for all warehouses
SC01 SC01046 StockTakDiff X_NUMERIC 12 20 8 Stock taking difference Total stocktaking difference in quantity, for all warehouses
SC01 SC01047 UnitCodSalPr VSTRING 2 2 0 Sales price unit code
SC01 SC01048 StockTakDate DATE 8 0 0 Latest stock taking date
SC01 SC01049 DelDateSuppl DATE 8 0 0 Latest date stock received
SC01 SC01050 DelDateCust DATE 8 0 0 Latest date stock issue
SC01 SC01051 OrdDateSuppl DATE 8 0 0 Latest purchase order date
SC01 SC01052 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.
SC01 SC01053 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.
SC01 SC01054 QtyRecSuppl X_NUMERIC 12 20 8 Quantity received
SC01 SC01055 PurchasePric MONEY 20 28 8 Purchase Price (Purchase Currency)
SC01 SC01056 CurrCodePurc VSTRING 2 2 0 Currency Code Purchase
SC01 SC01057 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.
SC01 SC01058 SupplierCode VSTRING 10 10 0 Supplier Code
SC01 SC01059 AlternSuppl VSTRING 10 10 0 Alternative Supplier Code
SC01 SC01060 SupplStockCo VSTRING 35 35 0 Supplier Stock Code
SC01 SC01061 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.
SC01 SC01062 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.
SC01 SC01063 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.
SC01 SC01064 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.
SC01 SC01065 BudgetModel INTEGER 1 0 0 Budget Model
SC01 SC01066 ArticlStatus INTEGER 1 0 0 Stock Item Status
SC01 SC01067 CountOfOrgin VSTRING 3 3 0 Country of Origin
SC01 SC01068 DelTimeUnit INTEGER 1 0 0 Delivery Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
SC01 SC01069 NetWeight X_NUMERIC 10 18 8 Net Weight
SC01 SC01070 GrossWeight X_NUMERIC 10 18 8 Gross Weight
SC01 SC01071 Volume X_NUMERIC 10 18 8 Volume
SC01 SC01072 QtyUnitInDel X_NUMERIC 10 18 8 Items per Package (Purchase)
SC01 SC01073 QtyUniOutDel X_NUMERIC 10 18 8 Items per Package (Sales)
SC01 SC01074 ABCCode VSTRING 1 1 0 ABC Code
SC01 SC01075 FrequenCode VSTRING 1 1 0 Frequency Code
SC01 SC01076 AttachedFlag SWITCH 1 1 0 Attached flag
SC01 SC01077 ProfitLCUPer MONEY 20 28 8 Gross profit period
SC01 SC01078 ProfitLCUYTD MONEY 20 28 8 Gross profit YTD
SC01 SC01079 ProYTDPrevYr MONEY 20 28 8 Gross profit previous year
SC01 SC01080 ProfYTDPrYr1 MONEY 20 28 8 Gross profit previous year -1
SC01 SC01081 SalesLCUPer MONEY 20 28 8 Turnover period
SC01 SC01082 SalesLCUYTD MONEY 20 28 8 Turnover YTD
SC01 SC01083 SalYTDPrevYr MONEY 20 28 8 Turnover previous year
SC01 SC01084 SaleYTDPrYr1 MONEY 20 28 8 Turnover previous year -1
SC01 SC01085 QtyLCUPeriod X_NUMERIC 12 20 8 Delivered quantity period
SC01 SC01086 QtyLCUYTD X_NUMERIC 12 20 8 Delivered quantity YTD
SC01 SC01087 QtyYTDPreYr X_NUMERIC 12 20 8 Delivered quantity previous year
SC01 SC01088 QtyYTDPrYr1 X_NUMERIC 12 20 8 Delivered quantity previous year -1
SC01 SC01089 ReplStocCode VSTRING 35 35 0 Replacement Stock Code
SC01 SC01090 PurchRoule INTEGER 1 0 0 Purchase Rule 0 - Purchase proposals are based on entered sales orders
1 - Purchase proposals are based on budgeted quantity.
SC01 SC01091 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
SC01 SC01092 DesNewPrice DATE 8 0 0 Date to Deactivate New Price
SC01 SC01093 InternRem1 VSTRING 25 25 0 Remark 1
SC01 SC01094 InternRem2 VSTRING 25 25 0 Remark 2
SC01 SC01095 CommissCode INTEGER 1 0 0 Commission Code 1 Related to commission setup in statistic module and are used for calculating commissions for salesmen.
SC01 SC01096 StructurFlag INTEGER 1 0 0 Structure flag
SC01 SC01097 QueryQueNo INTEGER 1 0 0 Query Queue Number
SC01 SC01098 SellPricMult X_NUMERIC 10 18 8 Selling Price Multiple
SC01 SC01099 PurcPricMult X_NUMERIC 10 18 8 Cost Price Multiple
SC01 SC01100 StatCodeExte VSTRING 14 14 0 Statistical Code Extended
SC01 SC01101 CustWarrMont INTEGER 3 0 0 Warranty Month
SC01 SC01102 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.
SC01 SC01103 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.
SC01 SC01104 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.
SC01 SC01105 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.
SC01 SC01106 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.
SC01 SC01107 ServiceLevel VSTRING 1 1 0 Service Level
SC01 SC01108 PrfLCUNxtPer MONEY 20 28 8 Gross profit next period
SC01 SC01109 PrfLCUNetYTD MONEY 20 28 8 Gross profit next year
SC01 SC01110 SalLCUNxtPer MONEY 20 28 8 Turnover next period
SC01 SC01111 SalLCUNxtYTD MONEY 20 28 8 Turnover next year
SC01 SC01112 QtyLCUNxtPer X_NUMERIC 12 20 8 Delivery quantity next period
SC01 SC01113 QtyLCUNxtYTD X_NUMERIC 12 20 8 Delivery quantity next year
SC01 SC01114 DefaultBinNo VSTRING 6 6 0 Default Bin Code
SC01 SC01115 MaintContCod VSTRING 1 1 0 Maintenance Contract Code
SC01 SC01116 RecCreatDate DATE 8 0 0 Date Created
SC01 SC01117 ContrDistrib SWITCH 1 1 0 Controlled Distribution
SC01 SC01118 StarContDist DATE 8 0 0 Start Date Controlled Distribution
SC01 SC01119 EndContDist DATE 8 0 0 End Date Controlled Distribution
SC01 SC01120 HoldStatus SWITCH 1 1 0 Product on Hold
SC01 SC01121 HldStaSrtDat DATE 8 0 0 Hold Status Start Date
SC01 SC01122 HldStaEndDat DATE 8 0 0 Hold Status End Date
SC01 SC01123 EndOfLifeDat DATE 8 0 0 End of Life Date
SC01 SC01124 ObsoleteDate DATE 8 0 0 Obsolete Date
SC01 SC01125 ReplacemDate DATE 8 0 0 Replacement Date
SC01 SC01126 EquiStckCode VSTRING 35 35 0 Equivalent Stock Code
SC01 SC01127 SerNoStatus INTEGER 1 0 0 Serial Number Usage
SC01 SC01128 ProductCateg VSTRING 10 10 0 Product Category
SC01 SC01129 BudgetMode INTEGER 1 0 0 Service Priority
SC01 SC01130 ApplicCode1 VSTRING 2 2 0 Application code 1
SC01 SC01131 ApplicCode2 VSTRING 2 2 0 Application code 2
SC01 SC01132 EANCode VSTRING 35 35 0 EAN Code
SC01 SC01133 UnitCodeStoc INTEGER 4 0 0 Unit Code Stock
SC01 SC01134 UnitCodePurc INTEGER 4 0 0 Unit Code Purchase
SC01 SC01135 UnitCodeSale INTEGER 4 0 0 Unit Code Sales
SC01 SC01136 UnitCodeMPC INTEGER 4 0 0 Unit Code MPC
SC01 SC01137 UnitCodeSpar INTEGER 4 0 0 Unit Code Other
SC01 SC01138 SPARE VSTRING 4 4 0 Spare
SC01 SC01139 UnitConvStoc X_NUMERIC 14 22 8 Unit Factor for Stock Unit
SC01 SC01140 UnitConvPurc X_NUMERIC 14 22 8 Unit Factor for Purchase Unit
SC01 SC01141 UnitConvSale X_NUMERIC 14 22 8 Unit Factor for Sales Unit
SC01 SC01142 UnitConvMPC X_NUMERIC 14 22 8 Unit Factor for MPC Unit
SC01 SC01143 UnitConvSpar X_NUMERIC 14 22 8 Unit Factor for Other Unit
SC01 SC01144 SalesTaxCodeSTE INTEGER 2 0 0 Sales Tax Code STE
SC01 SC01145 PurchaseTaxCodeSTE INTEGER 2 0 0 Purchase Tax Code STE
SC01 SC01146 StandRepCost MONEY 20 28 8 Standard Repair Cost (Local Currency)
SC01 SC01147 FlagReparab SWITCH 1 1 0 Reparable
SC01 SC01148 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.)
SC01 SC01149 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.)
SC01 SC01150 ComplStockIt VSTRING 35 35 0 Complementary Stock Item
SC01 SC01151 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.
SC01 SC01152 BatcNoPrefix STRING 2 2 0 Batch number prefix
SC01 SC01153 BatchNumber NUMBER 6 20 0 Batch number
SC01 SC01154 BatcNOSuffix NUMBER 3 20 0 Batch number suffix
SC01 SC01155 QCOnHand X_NUMERIC 12 20 8 QC on hand balance
SC01 SC01156 BOANumber STRING 3 3 0 BOA Number
SC01 SC01157 ABCCost1 MONEY 20 28 8 ABC-Cost 1
SC01 SC01158 ABCCost2 MONEY 20 28 8 ABC-Cost 2
SC01 SC01159 DirectCost MONEY 20 28 8 Direct Cost
SC01 SC01160 ExtUserDefFld1 VSTRING 150 150 0 Extended User defined 1
SC01 SC01161 ExtUserDefFld2 VSTRING 150 150 0 Extended User defined 2
SC01 SC01162 ExtUserDefFld3 VSTRING 150 150 0 Extended User defined 3
SC01 SC01163 ExtUserDefFld4 VSTRING 150 150 0 Extended User defined 4
SC01 SC01164 ExtUserDefFld5 VSTRING 150 150 0 Extended User defined 5
SC01 SC01165 ExtUserDefFld6 VSTRING 150 150 0 Extended User defined 6
SC01 SC01166 ExtUserDefFld7 VSTRING 150 150 0 Extended User defined 7
SC01 SC01167 ExtUserDefFld8 VSTRING 150 150 0 Extended User defined 8
SC01 SC01168 ExtUserDefFld9 VSTRING 150 150 0 Extended User defined 9
SC01 SC01169 ExtUserDefFld10 VSTRING 150 150 0 Extended User defined 10
SC01 SC01170 ExtUserDefFld11 VSTRING 150 150 0 Extended User defined 11
SC01 SC01171 ExtUserDefFld12 VSTRING 150 150 0 Extended User defined 12
SC01 SC01172 ExtUserDefFld13 VSTRING 150 150 0 Extended User defined 13
SC01 SC01173 ExtUserDefFld14 VSTRING 150 150 0 Extended User defined 14
SC01 SC01174 ExtUserDefFld15 VSTRING 150 150 0 Extended User defined 15
SC01 SC01175 ExtUserDefFld16 VSTRING 150 150 0 Extended User defined 16
SC01 SC01176 ExtUserDefFld17 VSTRING 150 150 0 Extended User defined 17
SC01 SC01177 ExtUserDefFld18 VSTRING 150 150 0 Extended User defined 18
SC01 SC01178 ExtUserDefFld19 VSTRING 150 150 0 Extended User defined 19
SC01 SC01179 ExtUserDefFld20 VSTRING 150 150 0 Extended User defined 20
SC01 SC01180 DelMarginRule INTEGER 1 0 0 Delivery margin rule
SC01 SC01181 DelMargin X_NUMERIC 6 14 8 Delivery margin %
SC01 SC01182 OverDeliveryQty X_NUMERIC 12 20 8 Over delivered quantity
SC01 SC01183 AllocatedQty X_NUMERIC 12 20 8 Allocated quantity Total quantity allocated to orders, for all warehouses
SC01 SC01184 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
SC01 SC01185 POReceipt VSTRING 1 1 0 Drop Shipment Issue/Receipt Rule 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
SC01 SC01186 DelLeadTime INTEGER 3 0 0 Drop Shipment Delivery Lead Time
SC01 SC01187 DelLeadTimeUnit INTEGER 1 0 0 Drop Shipment Delivery Lead Time Unit 2 - Days
3 - Weeks
4 - Month
5 - Years
SC01 SC01188 POAdjustment INTEGER 1 0 0 PO Adjustment, Drop Shipment
SC01 SC01189 AvailableServices INTEGER 1 0 0 Available service
SC01 SC01190 RepairCostRange STRING 25 25 0 Repair Cost Range 1
SC01 SC01191 RepairCostRange2 STRING 25 25 0 Repair Cost Range 2
SC01 SC01192 CostProposalRequiredFlag INTEGER 1 0 0 Cost Proposal Required Flag
SC01 SC01193 DefaultExchangePriceList STRING 2 2 0 Default Exchange Price List
SC01 SC01194 DefaultEngineer STRING 10 10 0 Default Engineer
SC01 SC01195 DefaultWarrantyCustShopOrders STRING 10 10 0 Default warranty
SC01 SC01196 ATPcheckItem INTEGER 1 0 0 ATP Check Item
SC01 SC01197 QualityControl SWITCH 1 1 0 Quality Control
SC01 SC01198 DangerousGoods SWITCH 1 1 0 Controlled Goods
SC01 SC01199 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
SC01 SC01200 RentalTimeUnitDefault INTEGER 2 0 0 Default Rental Time Unit 1 - Years
2 - Month
3 - Weeks
4 - Days
5 - Hours
6 - Minutes
SC01 SC01201 ECVATExemptFlag INTEGER 1 0 0 EC VAT Exemption
SC01 SC01202 BinControl INTEGER 1 0 0 Bin Controlled
SC01 SC01203 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.
SC01 SC01204 MinTemperature INTEGER 3 0 0 Minimum Storage Temperature
SC01 SC01205 MaxTemperature INTEGER 3 0 0 Maximum Storage Temperature
SC01 SC01206 MinHumidity INTEGER 3 0 0 Minimum Storage Humidity
SC01 SC01207 MaxHumidity INTEGER 3 0 0 Maximum Storage Humidity
SC01 SC01208 StorageType1 STRING 1 1 0 Storage Type 1
SC01 SC01209 StorageType2 STRING 1 1 0 Storage Type 2
SC01 SC01210 StorageType3 STRING 1 1 0 Storage Type 3
SC01 SC01211 StorageType4 STRING 1 1 0 Storage Type 4
SC01 SC01212 BinLocationRuleType VSTRING 4 4 0 Bin Location Rule Type
SC01 SC01213 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.
SC01 SC01214 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
SC01 SC01215 ConfigurationCode STRING 35 35 0 Configuration Code
SC01 SC01216 SaveConfigurationHistory STRING 1 1 0 Save Configuration History
SC01 SC01217 IssueExpiredBatch INTEGER 1 0 0 Allow Issue from Expired Batches
SC01 SC01218 SalesTaxCodeATE STRING 6 6 0 Sales Tax Code ATE
SC01 SC01219 SC01217 SWITCH 1 1 0 FEFO Order
SC01 SC01220 PortionSize X_NUMERIC 20 28 8 Portion Size
SC01 SC01221 MultipleFactor X_NUMERIC 20 28 8 Multiple Factor
SC01 SC01222 CalorificValue X_NUMERIC 20 28 8 Calorific Value
SC01 SC01223 ProteinValue X_NUMERIC 20 28 8 Protein Value
SC01 SC01224 FatValue X_NUMERIC 20 28 8 Fat Value
SC01 SC01225 CarbohydrateValue X_NUMERIC 20 28 8 Carbohydrate Value
SC01 SC01226 PLAccount VSTRING 12 12 0 P&L Account
SC01 SC01227 BOMDefaultUOMCode INTEGER 4 0 0 BOM default UOM code
SC01 SC01228 BOMDefaultUOMFactor X_NUMERIC 18 26 8 BOM default UOM factor
SC01 SC01229 ItemType VSTRING 10 10 0 NCM Code Item Type
SC01 SC01230 TariffNo VSTRING 25 25 0 NCM Sub Code Tariff Number
SC01 SC01231 OriginCode STRING 1 1 0 Origin Code
SC01 SC01232 NomenclatureNo VSTRING 25 25 0 Nomenclature Number
SC01 SC01233 GoodsType STRING 2 2 0 Goods Type
SC01 SC01234 StockValuationModel VSTRING 1 1 0 Valuation Model
SC01 SC01235 StockValModelCC VSTRING 1 1 0 Valuation Model for Alternative Currency
SC01 SC01236 BOMDiscountMethod VSTRING 1 1 0 BOM discount method
SC01 SC01237 LTMGroupOR STRING 6 6 0 LTM Group - OR
SC01 SC01238 LTMGroupPC STRING 6 6 0 LTM Group - PC
SC01 SC01239 BOMCost X_NUMERIC 20 28 8 BOM Cost
SC01 SC01240 GTIN VSTRING 35 35 0 GTIN Code
SC01 SC01241 UDefBarCodeIdent VSTRING 150 150 0 Barcode identities
SC01 SC01242 DTF INTEGER 3 0 0 DTF
SC01 SC01243 IncomingPropertiesControl SWITCH 1 1 0 Incoming Properties Control
SC01 SC01244 TemperatureRequiredFlag INTEGER 1 0 0 Temperature required flag
SC01 SC01245 Humidityrequiredflag INTEGER 1 0 0 Humidity required flag
SC01 SC01246 TemperatureEnforceFlag INTEGER 1 0 0 Temperature enforce flag
SC01 SC01247 HumidityEnforce INTEGER 1 0 0 Humidity enforce flag
SC01 SC01248 TemperatureUnit INTEGER 2 0 0 Temperature unit code
SC01 SC01249 ExtendedCommissionCode STRING 2 2 0 Extended Commission Code
SC01 SC01250 ExportStatus INTEGER 1 0 0 Export Status
SC01 SC01251 ChargeCostForPackMtrl SWITCH 1 1 0 Charge Cost for Packaging Materials
SC01 SC01252 FixedChargeWeight SWITCH 1 1 0 Fixed charge per weight
SC01 SC01253 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
SC01 SC01254 CommodityCode VSTRING 35 35 0 Commodity Code
SC01 SC01255 CreatedBy VSTRING 8 8 0 Created By
SC01 SC01256 PurchaseTaxCodeATE STRING 6 6 0 Purchase Tax Code ATE
SC01 SC01257 ProductTaxType VSTRING 10 10 0 Product Tax Type
SC01 SC01258 REACHUUID VSTRING 45 45 0 REACH UUID
SC01 SC01259 REACHWeight X_NUMERIC 10 18 8 REACH Weight
SC01 SC01260 REACHWeightUnit INTEGER 4 0 0 REACH Weight Unit
SC01 SC01261 REACHFromDate DATE 8 0 0 REACH From Date
SC01 SC01262 REACHToDate DATE 8 0 0 REACH To Date
SC01 SC01263 AssetPurchase INTEGER 1 0 0 Asset Purchase
SC01 SC01264 AssetAccount VSTRING 12 12 0 Asset Account
SC01 SC01265 AssetPerUnit INTEGER 1 0 0 Asset Per Unit
SC01 SC01266 TaxReasonCode STRING 3 3 0 Reason Code for Non-Standard Taxation
SC01 SC01267 Deactivated SWITCH 1 1 0 Deactivated Deactivated