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
OR01 Sales Order Head Company OR010100
OR03 Sales Order Lines Company OR030100
OR04 Sales Order Delivery Addresses Company OR040100
OR05 Order Parameters Company OR050100
OR06 Document Text File Company OR060100
OR07 Phrase File Company OR070100
OR09 Export Document Parameters Company OR090100
OR10 Transport Document Parameters Company OR100100
OR11 Transport Documents Company OR110100
OR12 Order History (Compressed) Company OR120100
OR13 External Programs Company OR130100
OR14 Order Status Company OR140100
OR16 ECC doc.printout OR160000
OR17 Order Text Lines Company OR170100
OR18 Order History Text (Compressed) Company OR180100
OR19 Order Delivery Lines Company OR190100
OR20 Sales Order Head History Company OR200100
OR21 Sales Order Lines History Company OR210100
OR22 Sales Order Delivery Addresses History Company OR220100
OR23 Order Delivery Lines History Company OR230100
OR24 Order Text Lines History Company OR240100
OR25 Order Line Amount History Company OR250100
OR26 Order Total Amounts History Company OR260100
OR27 Discount Groups Company OR270100
OR29 Order Lines Lead Time Details History Company OR290100
OR2A Discount Group Descriptions Company OR2A0100
OR2E History Transport Documents Company OR2E0100
OR33 Sales Order Discount Lines Company OR330100
OR34 Sales Order Discount Lines History Company OR340100
OR3L Order Lines Lead Time Details Company OR3L0100
OR40 Sales Order Header Historical Versions Company OR400100
OR41 Sales Order Lines Historical Versions Company OR410100
OR42 Sales Order Text Line Historical Versions Company OR420100
OR43 Sales Order Delivery Address Historical Version Company OR430100
OR44 Sales Order Discount Lines Historical Version Company OR440100
OR45 Order Lines Lead Time Details Historical Versions Company OR450100
OR50 Company OR500100
OR51 Company OR510100
OR52 Company OR520100
OR91 Export Invoice Company OR910100
OR92 Freight Document (Finnish) Company OR920100
ORB1 Sales Order BOM Node Company ORB10100
ORB2 Sales Order BOM Name Company ORB20100
ORB3 Sales Order BOM Link Company ORB30100
ORB4 Sales Order BOM Branch Company ORB40100
ORD0 Drop Shipment, Template Company ORD00100
ORD2 Drop Shipment Lines Company ORD20100
ORD3 Drop Shipment History Company ORD30100
ORDW Wrk Documents ORDW0000
ORH1 Sales Order BOM Node History Company ORH10100
ORH2 Sales Order BOM Node Name History Company ORH20100
ORH3 Sales Order BOM Link History Company ORH30100
ORH4 Sales Order BOM Branch History Company ORH40100
ORI2 Instalments Company ORI20100
ORI4 Instalments History Company ORI40100
ORMT Business Transaction Type Sales Order Mapping Company ORMT0100
ORN1 Order Notes Company ORN10100
ORN2 Order Notes history Company ORN20100
ORN3 Company ORN30100
ORR1 Original Order Link Company ORR10100
ORR2 History Original Order Link Company ORR20100
ORT1 Sales Order Tax Transactions Company ORT10100
ORTF Order Template foreign description Company ORTF0100
ORTH Order Template header Company ORTH0100
ORTL Order Template columns Company ORTL0100
ORV1 Sale Order BOM Node Version History Company ORV10100
ORV2 Sales Order BOM Node Name Version History Company ORV20100
ORV3 Sales Order BOM Node Link Version History Company ORV30100
ORV4 Sales Order BOM Node Branch Version History Company ORV40100
ORWA Order Work A ORWA0000
ORWK Order Work K ORWK0000
ORXM Order Merge wrk Company ORXM0100
ORXX External Upd.Wr ORXX0000
ORXY Closing Ord.Wrk ORXY0000
sca_trg_Audit_OR01 Audit trigger for OR01 table Company sca_trg_Audit_OR010100
sca_trg_Audit_OR03 Audit trigger for OR03 table Company sca_trg_Audit_OR030100
sca_trg_Audit_OR04 Audit trigger for OR04 table Company sca_trg_Audit_OR040100
sca_trg_Audit_OR33 Audit trigger for OR33 table Company sca_trg_Audit_OR330100
SLIN Invoice Based Intrastat SL Company SLIN0100

Fields
PK Table Name Description Type Length Precision Note
1 OR21 OR21001 OrderNo STRING 10 10 0 Order Number
3 OR21 OR21002 LineNo STRING 6 6 0 Line Number
4 OR21 OR21003 StrucLineNo STRING 6 6 0 Sub-line Number
OR21 OR21004 LineType INTEGER 1 0 0 Line Type 0 - Normal Order Line Related to Stock Item
1 - Non Stock Item Line (dot item)
OR21 OR21005 StockCode VSTRING 35 35 0 Stock Item Code
OR21 OR21006 DescripLine1 VSTRING 25 25 0 Description Line 1
OR21 OR21007 DescripLine2 VSTRING 25 25 0 Description Line 2
OR21 OR21008 UnitPrice MONEY 20 28 8 Unit Price (Order Currency)
OR21 OR21009 UnitCostPric MONEY 20 28 8 Unit Cost Price (Local Currency)
OR21 OR21010 UnitCode INTEGER 4 0 0 Unit Code
OR21 OR21011 QtyOrdered X_NUMERIC 12 20 8 Quantity Ordered
OR21 OR21012 QtyShipped X_NUMERIC 12 20 8 Quantity Delivered
OR21 OR21013 Spare INTEGER 1 0 0 Picking List Status 0 - Line not ready for printing
1 - Line ready for printing on picking list
2 - Line sent on picking list
OR21 OR21014 AccountCode1 STRING 2 2 0 Accounting Code 1
OR21 OR21015 BackOrdrFlag SWITCH 1 1 0 Back Order Only used temporary during stock withdraw to indicate the lines that has been delivered during the process, lines with '1' will not be issued when pressing '+' or 'A' to deliver all lines.
OR21 OR21016 LinePrntFlag INTEGER 1 0 0 Line Layout 0 - The line is NOT printed on order documents.
1 - The line is printed with quantity, unit price and line total (Controlled by DDF file).
2 - The line is printed with line total amount only on the documents (Controlled by DDF file).
OR21 OR21017 VolDiscount VSTRING 6 6 0 Volume Discount %
OR21 OR21018 CustDiscount VSTRING 6 6 0 Customer Discount %
OR21 OR21019 IntrPlanning DATE 8 0 0 Internal Planning Date
OR21 OR21020 QtyUnInDeliv X_NUMERIC 10 18 8 Items per Package (Purchase)
OR21 OR21021 QtyUnOutDeli X_NUMERIC 10 18 8 Items per Package (Sales)
OR21 OR21022 SellPrMultip X_NUMERIC 10 18 8 Selling Price Multiplier
OR21 OR21023 CostPrMultip X_NUMERIC 10 18 8 Cost Price Multiplier
OR21 OR21024 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
OR21 OR21025 ExtraTaxCode INTEGER 1 0 0 Extra Tax Code 0 - Line is not liable for extra tax
1-3 Line is liable for extra tax (rate is defined in stock control)
OR21 OR21026 DistCostCode INTEGER 1 0 0 Distribution Cost Code
OR21 OR21027 RepOrPrcCode INTEGER 1 0 0 Repeat Order Price Option 0 - Use the price defined on the order line when invoicing the order
1 - Get current prices when invoicing the order
OR21 OR21028 AccounString ACCSTR 120 120 0 Accounting String
OR21 OR21029 FLAGDeliStat INTEGER 1 0 0 Delivery Status
OR21 OR21030 FLAGInvStat INTEGER 1 0 0 Invoice Status
OR21 OR21031 StockStatus INTEGER 1 0 0 Stock Item Status
OR21 OR21032 ShipmRoule BINSTRING 1 1 0 Delivery Rule 0 - No test of the stock balance.
1 - Test on positive stock balance .
2 - Closed stock item, blocked orders.
3 - Direct delivery from supplier to customer.
4 - No over delivery.
5 - Back-delivery to purchase control.
OR21 OR21033 QyAllocated X_NUMERIC 12 20 8 Quantity Allocated
OR21 OR21034 FLAGHasSubIt SWITCH 1 1 0 Has Sub-items in structure Indicates if the order line is a BoM and there are sub-items attached to the item
OR21 OR21035 ItemType VSTRING 8 8 0 Item Type
OR21 OR21036 Spare MONEY 20 28 8 Sales Tax Amount (Order Currency) Sales tax amount for the order line, this is only applicable when using country code 1 (US) and there the system has been setup to use an external tax system.
OR21 OR21037 DelivDateReq DATE 8 0 0 Delivery Date Requested
OR21 OR21038 FLAGCurrComp SWITCH 1 1 0 Currency Compensation
OR21 OR21039 CompensCurr INTEGER 2 0 0 Currency Code Compensation
OR21 OR21040 OrDateExch MONEY 20 28 8 Order Date Exchange Rate
OR21 OR21041 OR2141SPARE X_NUMERIC 20 28 8 Delivery Date Exchange Rate
OR21 OR21042 IntrPlanningBO DATE 8 0 0 Internal Planning Date Back Order
OR21 OR21043 NetWeight X_NUMERIC 10 18 8 Net Weight
OR21 OR21044 GrossWeight X_NUMERIC 10 18 8 Gross Weight
OR21 OR21045 Volume X_NUMERIC 10 18 8 Volume
OR21 OR21046 WarehouseID VSTRING 6 6 0 Warehouse
OR21 OR21047 StatistPrice MONEY 20 28 8 Statistical Price (Local Currency)
OR21 OR21048 StatiDiscou X_NUMERIC 6 14 8 Statistical Discount
OR21 OR21049 StatCostPrc MONEY 20 28 8 Statistical Cost Price (Local Currency)
OR21 OR21050 QtyOriginal X_NUMERIC 12 20 8 Original Quantity
OR21 OR21051 Spare VSTRING 6 6 0 Picking List Number
OR21 OR21052 DiscountsFrozen STRING 1 1 0 Discounts Frozen
OR21 OR21053 Spare X_NUMERIC 12 20 8 Quantity Allocated
OR21 OR21054 Spare X_NUMERIC 12 20 8 Quantity Delivered
OR21 OR21055 FLAGStatNot SWITCH 1 1 0 Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.
OR21 OR21056 Spare X_NUMERIC 12 20 8 Quantity Ordered
OR21 OR21057 UnitConvFact X_NUMERIC 10 18 8 UOM Conversion Factor Conversion factor used to convert between sales unit of measurement and stock unit of measurement.
OR21 OR21058 CusDisCalIt1 X_NUMERIC 4 12 8 Customer Discount Calculation Item 1
OR21 OR21059 CusDisCalIt2 X_NUMERIC 4 12 8 Customer Discount Calculation Item 2
OR21 OR21060 CusDisCalIt3 X_NUMERIC 4 12 8 Customer Discount Calculation Item 3
OR21 OR21061 VATCode1099 INTEGER 2 0 0 VAT Code 1
OR21 OR21062 VATCode2099 INTEGER 2 0 0 VAT Code 2
OR21 OR21063 OrigDefaPri MONEY 20 28 8 Original Default Price (Original Currency) The original price that was given when the order line was created.
OR21 OR21064 OriDefCusCod X_NUMERIC 6 14 8 Original Default Discount The original line discount given when the order line was created.
2 OR21 OR21065 InvoiceNo VSTRING 15 15 0 Invoice Number
OR21 OR21066 SuborderNo VSTRING 10 10 0 Sub-order Number
OR21 OR21067 PurchaseOrNo VSTRING 10 10 0 Purchase Order Number
OR21 OR21068 PurchaLineNo VSTRING 12 12 0 Purchase Order Line Number
OR21 OR21069 PurcStatFlag INTEGER 1 0 0 Purchase Order Status 0 - Purchase order line created
1 - Purchase order printed
2 - Purchase order line confirmed
3 - Delivery entered for purchase order line
OR21 OR21070 Status1 STRING 1 1 0 Status 1
OR21 OR21071 Status2 STRING 1 1 0 Status 2
OR21 OR21072 Status3 STRING 1 1 0 Status 3
OR21 OR21073 SubType STRING 1 1 0 Sub-type
OR21 OR21074 Contract VSTRING 27 27 0 Contract Number
OR21 OR21075 SearchField VSTRING 35 35 0 Search Key
OR21 OR21076 PickingList NUMBER 10 20 0 Picking List Number
OR21 OR21077 Curexrate2 X_NUMERIC 10 18 8 Currency Exchange Rate 2
OR21 OR21078 Curexalgm STRING 3 3 0 Currency Exchange Algorithm
OR21 OR21079 Orddtexrate2 X_NUMERIC 10 18 8 Order Date Exchange Rate 2
OR21 OR21080 Orddtexalgm STRING 3 3 0 Order Date Exchange Algorithm
OR21 OR21081 Deldtexrate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
OR21 OR21082 Deldtexalgm STRING 3 3 0 Delivery Date Exchange Algorithm
OR21 OR21083 Currcode INTEGER 2 0 0 Currency Code Order
OR21 OR21084 Ediswitch SWITCH 1 1 0 EDI Contract
OR21 OR21085 OrigPriceCurCode INTEGER 2 0 0 Currency Code Original Price
OR21 OR21086 OrigUnitPrice MONEY 20 28 8 Original Unit Price (Original Currency)
OR21 OR21087 PriceDiscountHistory VSTRING 11 11 0 Price/Discount History
OR21 OR21088 CostPriceCC MONEY 20 28 8 Unit Cost Price (Order Currency)
OR21 OR21089 SiteCode STRING 25 25 0 Site Code
OR21 OR21090 TargetDate DATE 8 0 0 Target Date
OR21 OR21091 GRPAltRout VSTRING 2 2 0 Graphical Alternative Routing
OR21 OR21092 GRPStartDate DATE 8 0 0 Graphical Planning Start Date
OR21 OR21093 GRPDueDate DATE 8 0 0 Graphical Planning Due Date
OR21 OR21094 GRPStatus INTEGER 1 0 0 Graphical Status
OR21 OR21095 DropShipmentline VSTRING 1 1 0 Drop Shipment Line
OR21 OR21096 ORBOMNodeID STRING 38 38 0 BoM Node ID Order
OR21 OR21097 SCBOMNodeID STRING 38 38 0 BoM Node ID Stock
OR21 OR21098 CustPOLineNo VSTRING 20 20 0 Customer Purchase Order Line Number
OR21 OR21099 DelCustPOLineNo VSTRING 20 20 0 Delivery Customer Purchase Order Line Number
OR21 OR21100 DiscountGroupNumber INTEGER 9 0 0 Discount Group
OR21 OR21101 DateConfirmationPrinted DATE 8 0 0 Date Confirmation Printed
OR21 OR21102 DatePickListPrinted DATE 8 0 0 Date Picking List Printed
OR21 OR21103 DateDeliveryProposalPrinted DATE 8 0 0 Date Delivery Proposal Printed
OR21 OR21104 BlockForProcess STRING 1 1 0 BOM Blocked for Processing
OR21 OR21105 VersionNumber STRING 4 4 0 Version Number
OR21 OR21106 UnitCostPriceCC MONEY 20 28 8 Unit Cost Price (Alternative Currency)
OR21 OR21107 DSIssueOnGRR VSTRING 1 1 0 Drop Shipment Issue on 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
OR21 OR21108 TaxCode STRING 6 6 0 Tax Code Order Line
OR21 OR21109 PriceInclTax MONEY 20 28 8 Unit Price Including Tax (Order Currency)
OR21 OR21110 UseLocalBalance SWITCH 1 1 0 Use local balance
OR21 OR21111 DeliveryWithoutStockTrans SWITCH 1 1 0 Delivery Without Stock Trans
OR21 OR21112 StatisticsLineID STRING 8 8 0 Statistics Line ID
OR21 OR21113 BlockPriceChange SWITCH 1 1 0 Block Price Change Blocked for automatic price change
OR21 OR21114 ConfDD DATE 8 0 0 Confirmed Delivery Date
OR21 OR21115 ConfDDBO DATE 8 0 0 Confirmed Delivery Date Back Order
OR21 OR21116 OriginalConfDD DATE 8 0 0 Original Confirmed Delivery Date
OR21 OR21117 NomenclatureNo VSTRING 25 25 0 NomenclatureNo
OR21 OR21118 DelDateAccepted DATE 8 0 0 Accepted Delivery Date
OR21 OR21119 OrderCustomerCode STRING 10 10 0 Order Customer Code
OR21 OR21120 FinOperationCode VSTRING 10 10 0 FinOperationCode
OR21 OR21121 OrderLinePricingDate DATE 8 0 0 Order Line Pricing Date
OR21 OR21122 OrderPricingNumber STRING 10 10 0 Order Pricing Number
OR21 OR21123 RequestedDeliveryTime VSTRING 20 20 0 Requested Delivery Time
OR21 OR21124 AcceptedDeliveryTime VSTRING 20 20 0 Accepted Delivery Time
OR21 OR21125 ExternalStatus INTEGER 4 0 0 External status
OR21 OR21126 LinePriceType INTEGER 1 0 0 Line Price Type 0 –> Gross price + Discount (existing model)
1 –> Gross price + Net price (new)
OR21 OR21127 NetUnitPrice MONEY 20 28 8 Net Unit Price
OR21 OR21128 ConfirmedProductionDate DATE 8 0 0 Confirmed Production Date
OR21 OR21129 ExemptTaxCode STRING 2 2 0 Exempt Tax Code
OR21 OR21130 ExemptLimit MONEY 20 28 8 Exempt Limit Tax exemption limit used for order line
OR21 OR21131 TaxablePrice MONEY 20 28 8 Taxable Price Taxable Price for FOC items
OR21 OR21132 AccountCode2 STRING 2 2 0 Accounting Code 2
OR21 OR21133 DeliveryBlocked SWITCH 1 1 0 Delivery Blocked
OR21 OR21134 Spare SWITCH 1 1 0 Spare
OR21 OR21135 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
OR21 OR21136 ApprovedCreditLimit SWITCH 1 1 0 Approved credit limit
OR21 OR21137 ProductTaxType VSTRING 10 10 0 Product Tax Type
OR21 OR21138 LineFreightOCU MONEY 20 28 8 Line Freight OCU
OR21 OR21139 LineFreightICU MONEY 20 28 8 Line Freight ICU
OR21 OR21140 InvPrefix STRING 4 4 0 Inv Prefix
OR21 OR21141 TaxReasonCode STRING 3 3 0 Tax Reason Code
OR21 OR21142 ConfirmedbyPlanner SWITCH 1 1 0 Confirmed by Planner
OR21 OR21143 ExtendedUDF1 VSTRING 150 150 0 Extended User defined field 1
OR21 OR21144 ExtendedUDF2 VSTRING 150 150 0 Extended User defined field 2
OR21 OR21145 ExtendedUDF3 VSTRING 150 150 0 Extended User defined field 3
OR21 OR21146 ExtendedUDF4 VSTRING 150 150 0 Extended User defined field 4
OR21 OR21147 ExtendedUDF5 VSTRING 150 150 0 Extended User defined field 5
OR21 OR21148 ExtendedUDF6 VSTRING 150 150 0 Extended User defined field 6
OR21 OR21149 ExtendedUDF7 VSTRING 150 150 0 Extended User defined field 7
OR21 OR21150 ExtendedUDF8 VSTRING 150 150 0 Extended User defined field 8
OR21 OR21151 ExtendedUDF9 VSTRING 150 150 0 Extended User defined field 9
OR21 OR21152 ExtendedUDF10 VSTRING 150 150 0 Extended User defined field 10
OR21 OR21153 ExtendedUDF11 VSTRING 150 150 0 Extended User defined field 11
OR21 OR21154 ExtendedUDF12 VSTRING 150 150 0 Extended User defined field 12
OR21 OR21155 ExtendedUDF13 VSTRING 150 150 0 Extended User defined field 13
OR21 OR21156 ExtendedUDF14 VSTRING 150 150 0 Extended User defined field 14
OR21 OR21157 ExtendedUDF15 VSTRING 150 150 0 Extended User defined field 15
OR21 OR21158 ExtendedUDF16 VSTRING 150 150 0 Extended User defined field 16
OR21 OR21159 ExtendedUDF17 VSTRING 150 150 0 Extended User defined field 17
OR21 OR21160 ExtendedUDF18 VSTRING 150 150 0 Extended User defined field 18
OR21 OR21161 ExtendedUDF19 VSTRING 150 150 0 Extended User defined field 19
OR21 OR21162 ExtendedUDF20 VSTRING 150 150 0 Extended User defined field 20