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 OR41 OR41001 OrderNo STRING 10 10 0 Order Number
3 OR41 OR41002 LineNumber STRING 6 6 0 Line Number
4 OR41 OR41003 StructLineNo STRING 6 6 0 Sub-line Number
OR41 OR41004 LineType INTEGER 1 0 0 Line Type 0 - Normal Order Line Related to Stock Item
1 - Non Stock Item Line (dot item)
OR41 OR41005 StockCode VSTRING 35 35 0 Stock Item Code
OR41 OR41006 DescrLine1 VSTRING 25 25 0 Description Line 1
OR41 OR41007 DescrLine2 VSTRING 25 25 0 Description Line 2
OR41 OR41008 UnitPrice MONEY 20 28 8 Unit Price (Order Currency)
OR41 OR41009 UnitCostPric MONEY 20 28 8 Unit Cost Price (Local Currency)
OR41 OR41010 UnitCode INTEGER 4 0 0 Unit Code
OR41 OR41011 ORQtyOrdered X_NUMERIC 12 20 8 Quantity Ordered
OR41 OR41012 QtyShipped X_NUMERIC 12 20 8 Quantity Delivered
OR41 OR41013 FlagPickList 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
OR41 OR41014 AcctingCode1 STRING 2 2 0 Accounting Code 1
OR41 OR41015 FLAGBackOrFl 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.
OR41 OR41016 FLAGLinePrn 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).
OR41 OR41017 VolDiscount VSTRING 6 6 0 Volume Discount %
OR41 OR41018 CustDiscount VSTRING 6 6 0 Customer Discount %
OR41 OR41019 IntrPlanning DATE 8 0 0 Internal Planning Date
OR41 OR41020 QtyUnitInDel X_NUMERIC 10 18 8 Items per Package (Purchase)
OR41 OR41021 QtyUniOutDel X_NUMERIC 10 18 8 Items per Package (Sales)
OR41 OR41022 SellPrMultip X_NUMERIC 10 18 8 Selling Price Multiplier
OR41 OR41023 CostPrMultip X_NUMERIC 10 18 8 Cost Price Multiplier
OR41 OR41024 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
OR41 OR41025 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)
OR41 OR41026 DistriCostCo INTEGER 1 0 0 Distribution Cost Code
OR41 OR41027 ReptOrPriceC 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
OR41 OR41028 AccCodString ACCSTR 120 120 0 Accounting String
OR41 OR41029 FLAGDelStat INTEGER 1 0 0 Delivery Status
OR41 OR41030 FLAGInvStat INTEGER 1 0 0 Invoice Status
OR41 OR41031 StockStatus INTEGER 1 0 0 Stock Item Status
OR41 OR41032 ShipmentRoul 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.
OR41 OR41033 QtyAlloc X_NUMERIC 12 20 8 Quantity Allocated
OR41 OR41034 HasSubitemin 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
OR41 OR41035 ItemType VSTRING 8 8 0 Item Type
OR41 OR41036 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.
OR41 OR41037 DelDateReque DATE 8 0 0 Delivery Date Requested
OR41 OR41038 FLAGCurrComp SWITCH 1 1 0 Currency Compensation
OR41 OR41039 CompCurrNo INTEGER 2 0 0 Currency Code Compensation
OR41 OR41040 OrDExchRate X_NUMERIC 20 28 8 Order Date Exchange Rate
OR41 OR41041 DelivDExRate X_NUMERIC 20 28 8 Delivery Date Exchange Rate
OR41 OR41042 IntrPlanningBO DATE 8 0 0 Internal Planning Date Back Order
OR41 OR41043 NetWeight X_NUMERIC 10 18 8 Net Weight
OR41 OR41044 GrossWeight X_NUMERIC 10 18 8 Gross Weight
OR41 OR41045 Volume X_NUMERIC 10 18 8 Volume
OR41 OR41046 WarehouseNo VSTRING 6 6 0 Warehouse
OR41 OR41047 StatisPrice MONEY 20 28 8 Statistical Price (Local Currency)
OR41 OR41048 StatisDisco X_NUMERIC 6 14 8 Statistical Discount
OR41 OR41049 StatisCost MONEY 20 28 8 Statistical Cost Price (Local Currency)
OR41 OR41050 QtyOrig X_NUMERIC 12 20 8 Original Quantity
OR41 OR41051 PickListNo VSTRING 6 6 0 Picking List Number
OR41 OR41052 DiscountsFrozen STRING 1 1 0 Discounts Frozen
OR41 OR41053 QtyAllocated X_NUMERIC 12 20 8 Quantity Allocated
OR41 OR41054 QtyDelivered X_NUMERIC 12 20 8 Quantity Delivered
OR41 OR41055 FLAGStatupda SWITCH 1 1 0 Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.
OR41 OR41056 QtyReservded X_NUMERIC 12 20 8 Quantity Ordered
OR41 OR41057 UnitConvFact X_NUMERIC 10 18 8 UOM Conversion Factor Conversion factor used to convert between sales unit of measurement and stock unit of measurement.
OR41 OR41058 CustDiscoun1 X_NUMERIC 4 12 8 Customer Discount Calculation Item 1
OR41 OR41059 CustDiscoun2 X_NUMERIC 4 12 8 Customer Discount Calculation Item 2
OR41 OR41060 CustDiscoun3 X_NUMERIC 4 12 8 Customer Discount Calculation Item 3
OR41 OR41061 VATCode1 INTEGER 2 0 0 VAT Code 1
OR41 OR41062 VATCode2 INTEGER 2 0 0 VAT Code 2
OR41 OR41063 OrigDefaulPr MONEY 20 28 8 Original Default Price (Original Currency) The original price that was given when the order line was created.
OR41 OR41064 OrigDefaCust X_NUMERIC 6 14 8 Original Default Discount The original line discount given when the order line was created.
OR41 OR41065 InvNoDummy VSTRING 15 15 0 Invoice Number
OR41 OR41066 SuborderNo VSTRING 10 10 0 Sub-order Number
OR41 OR41067 PurchaseOrNo VSTRING 10 10 0 Purchase Order Number
OR41 OR41068 PurchaLineNo VSTRING 12 12 0 Purchase Order Line Number
OR41 OR41069 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
OR41 OR41070 Status1 STRING 1 1 0 Status 1
OR41 OR41071 Status2 STRING 1 1 0 Status 2
OR41 OR41072 Status3 STRING 1 1 0 Status 3
OR41 OR41073 SubType STRING 1 1 0 Sub-type
OR41 OR41074 Contract VSTRING 27 27 0 Contract Number
OR41 OR41075 SearchField VSTRING 35 35 0 Search Key
OR41 OR41076 PickingList NUMBER 10 20 0 Picking List Number
OR41 OR41077 CurrExchgRate2 X_NUMERIC 10 18 8 Currency Exchange Rate 2
OR41 OR41078 CurrExchgAlgtm STRING 3 3 0 Currency Exchange Algorithm
OR41 OR41079 OrderDateExchgRate2 X_NUMERIC 10 18 8 Order Date Exchange Rate 2
OR41 OR41080 OrderDateExchgAlgtm STRING 3 3 0 Order Date Exchange Algorithm
OR41 OR41081 DlvryDateExchgRate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
OR41 OR41082 DlvryDateExchgAlgtm STRING 3 3 0 Delivery Date Exchange Algorithm
OR41 OR41083 CurrencyCode INTEGER 2 0 0 Currency Code Order
OR41 OR41084 EDIContractSwitch SWITCH 1 1 0 EDI Contract
OR41 OR41085 OrigPriceCurCode INTEGER 2 0 0 Currency Code Original Price
OR41 OR41086 OrigUnitPrice MONEY 20 28 8 Original Unit Price (Original Currency)
OR41 OR41087 PriceDiscountHistory VSTRING 11 11 0 Price/Discount History
OR41 OR41088 CostPriceCC MONEY 20 28 8 Unit Cost Price (Order Currency)
OR41 OR41089 SiteCode STRING 25 25 0 Site Code
OR41 OR41090 TargetDate DATE 8 0 0 Target Date
OR41 OR41091 GRPAltRout VSTRING 2 2 0 Graphical Alternative Routing
OR41 OR41092 GRPStartDate DATE 8 0 0 Graphical Planning Start Date
OR41 OR41093 GRPDueDate DATE 8 0 0 Graphical Planning Due Date
OR41 OR41094 GRPStatus INTEGER 1 0 0 Graphical Status
OR41 OR41095 DropShipmentline VSTRING 1 1 0 Drop Shipment Line
OR41 OR41096 ORBOMNodeID STRING 38 38 0 Order BoM Node
OR41 OR41097 SCBOMNodeID STRING 38 38 0 Stock BoM Node
OR41 OR41098 CustPOLineNo VSTRING 20 20 0 Customer Purchase Order Line Number
OR41 OR41099 DelCustPOLineNo VSTRING 20 20 0 Delivery Customer Purchase Order Line Number
OR41 OR41100 DiscountGroupNumber INTEGER 9 0 0 Discount Group
OR41 OR41101 DateConfirmationPrinted DATE 8 0 0 Date Confirmation Printed
OR41 OR41102 DatePickListPrinted DATE 8 0 0 Date Picking List Printed
OR41 OR41103 DateDeliveryProposalPrinted DATE 8 0 0 Date Delivery Proposal Printed
OR41 OR41104 BlockForProcess STRING 1 1 0 BOM Blocked for Processing
2 OR41 OR41105 VersionNumber STRING 4 4 0 Version Number
OR41 OR41106 UnitCostPriceCC MONEY 20 28 8 Unit Cost Price (Alternative Currency)
OR41 OR41107 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
OR41 OR41108 TaxCode STRING 6 6 0 Tax Code Order Line
OR41 OR41109 PriceInclTax MONEY 20 28 8 Unit Price Including Tax (Order Currency)
OR41 OR41110 UseLocalBalance SWITCH 1 1 0 Use local balance
OR41 OR41111 DeliveryWithoutStockTrans SWITCH 1 1 0 Delivery Without Stock Trans
OR41 OR41112 StatisticsLineID STRING 8 8 0 Statistics Line ID
OR41 OR41113 BlockPriceChange SWITCH 1 1 0 Block Price Change Blocked for automatic price change
OR41 OR41114 ConfDD DATE 8 0 0 Confirmed Delivery Date
OR41 OR41115 ConfDDBO DATE 8 0 0 Confirmed Delivery Date Back Order
OR41 OR41116 OriginalConfDD DATE 8 0 0 Original Confirmed Delivery Date
OR41 OR41117 NomenclatureNo VSTRING 25 25 0 NomenclatureNo
OR41 OR41118 DelDateAccepted DATE 8 0 0 Accepted Delivery Date
OR41 OR41119 OrderCustomerCode STRING 10 10 0 Order Customer Code
OR41 OR41120 FinOperationCode VSTRING 10 10 0 FinOperationCode
OR41 OR41121 OrderLinePricingDate DATE 8 0 0 Order Line Pricing Date
OR41 OR41122 OrderPricingNumber STRING 10 10 0 Order Pricing Number
OR41 OR41123 RequestedDeliveryTime VSTRING 20 20 0 Requested Delivery Time
OR41 OR41124 AcceptedDeliveryTime VSTRING 20 20 0 Accepted Delivery Time
OR41 OR41125 ExternalStatus INTEGER 4 0 0 External status
OR41 OR41126 LinePriceType INTEGER 1 0 0 Line Price Type 0 –> Gross price + Discount (existing model)
1 –> Gross price + Net price (new)
OR41 OR41127 NetUnitPrice MONEY 20 28 8 Net Unit Price
OR41 OR41128 ConfirmedProductionDate DATE 8 0 0 Confirmed Production Date
OR41 OR41129 ExemptTaxCode STRING 2 2 0 Exempt Tax Code
OR41 OR41130 ExemptLimit MONEY 20 28 8 Exempt Limit Tax exemption limit used for order line
OR41 OR41131 TaxablePrice MONEY 20 28 8 Taxable Price Taxable Price for FOC items
OR41 OR41132 AcctingCode2 STRING 2 2 0 Accounting Code 2
OR41 OR41133 DeliveryBlocked SWITCH 1 1 0 Delivery Blocked
OR41 OR41134 Spare SWITCH 1 1 0 Spare
OR41 OR41135 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
OR41 OR41136 ApprovedCreditLimit SWITCH 1 1 0 Approved credit limit
OR41 OR41137 ProductTaxType VSTRING 10 10 0 Product Tax Type
OR41 OR41138 LineFreightOCU MONEY 20 28 8 Line Freight OCU
OR41 OR41139 LineFreightICU MONEY 20 28 8 Line Freight ICU
OR41 OR41140 InvPrefix STRING 4 4 0 Inv Prefix
OR41 OR41141 TaxReasonCode STRING 3 3 0 Tax Reason Code
OR41 OR41142 ConfirmedbyPlanner SWITCH 1 1 0 Confirmed by Planner
OR41 OR41143 ExtendedUDF1 VSTRING 150 150 0 Extended User defined field 1
OR41 OR41144 ExtendedUDF2 VSTRING 150 150 0 Extended User defined field 2
OR41 OR41145 ExtendedUDF3 VSTRING 150 150 0 Extended User defined field 3
OR41 OR41146 ExtendedUDF4 VSTRING 150 150 0 Extended User defined field 4
OR41 OR41147 ExtendedUDF5 VSTRING 150 150 0 Extended User defined field 5
OR41 OR41148 ExtendedUDF6 VSTRING 150 150 0 Extended User defined field 6
OR41 OR41149 ExtendedUDF7 VSTRING 150 150 0 Extended User defined field 7
OR41 OR41150 ExtendedUDF8 VSTRING 150 150 0 Extended User defined field 8
OR41 OR41151 ExtendedUDF9 VSTRING 150 150 0 Extended User defined field 9
OR41 OR41152 ExtendedUDF10 VSTRING 150 150 0 Extended User defined field 10
OR41 OR41153 ExtendedUDF11 VSTRING 150 150 0 Extended User defined field 11
OR41 OR41154 ExtendedUDF12 VSTRING 150 150 0 Extended User defined field 12
OR41 OR41155 ExtendedUDF13 VSTRING 150 150 0 Extended User defined field 13
OR41 OR41156 ExtendedUDF14 VSTRING 150 150 0 Extended User defined field 14
OR41 OR41157 ExtendedUDF15 VSTRING 150 150 0 Extended User defined field 15
OR41 OR41158 ExtendedUDF16 VSTRING 150 150 0 Extended User defined field 16
OR41 OR41159 ExtendedUDF17 VSTRING 150 150 0 Extended User defined field 17
OR41 OR41160 ExtendedUDF18 VSTRING 150 150 0 Extended User defined field 18
OR41 OR41161 ExtendedUDF19 VSTRING 150 150 0 Extended User defined field 19
OR41 OR41162 ExtendedUDF20 VSTRING 150 150 0 Extended User defined field 20