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 OR03 OR03001 OrderNo STRING 10 10 0 Order Number
2 OR03 OR03002 LineNumber STRING 6 6 0 Line Number
3 OR03 OR03003 StructLineNo STRING 6 6 0 Sub-line Number
OR03 OR03004 LineType INTEGER 1 0 0 Line Type 0 - Normal Order Line Related to Stock Item
1 - Non Stock Item Line (dot item)
OR03 OR03005 StockCode VSTRING 35 35 0 Stock Item Code
OR03 OR03006 DescrLine1 VSTRING 25 25 0 Description Line 1
OR03 OR03007 DescrLine2 VSTRING 25 25 0 Description Line 2
OR03 OR03008 UnitPrice MONEY 20 28 8 Unit Price (Order Currency)
OR03 OR03009 UnitCostPric MONEY 20 28 8 Unit Cost Price (Local Currency)
OR03 OR03010 UnitCode INTEGER 4 0 0 Unit Code
OR03 OR03011 ORQtyOrdered X_NUMERIC 12 20 8 Quantity Ordered (Order Unit)
OR03 OR03012 QtyShipped X_NUMERIC 12 20 8 Quantity Delivered (Order Unit)
OR03 OR03013 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
OR03 OR03014 AcctingCode1 STRING 2 2 0 Accounting Code 1
OR03 OR03015 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.
OR03 OR03016 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).
OR03 OR03017 VolDiscount VSTRING 6 6 0 Volume Discount %
OR03 OR03018 CustDiscount VSTRING 6 6 0 Customer Discount %
OR03 OR03019 IntrPlanning DATE 8 0 0 Intermal Planning Date
OR03 OR03020 QtyUnitInDel X_NUMERIC 10 18 8 Items per Package (Purchase)
OR03 OR03021 QtyUniOutDel X_NUMERIC 10 18 8 Items per Package (Sales)
OR03 OR03022 SellPrMultip X_NUMERIC 10 18 8 Selling Price Multiplier
OR03 OR03023 CostPrMultip X_NUMERIC 10 18 8 Cost Price Multiplier
OR03 OR03024 CurrExchRate X_NUMERIC 20 28 8 Currency Exchange Rate
OR03 OR03025 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)
OR03 OR03026 DistriCostCo INTEGER 1 0 0 Distribution Cost Code
OR03 OR03027 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
OR03 OR03028 AccCodString ACCSTR 120 120 0 Accounting String
OR03 OR03029 FLAGDelStat INTEGER 1 0 0 Delivery Status
OR03 OR03030 FLAGInvStat INTEGER 1 0 0 Invoice Status
OR03 OR03031 StockStatus INTEGER 1 0 0 Stock Item Status
OR03 OR03032 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.
OR03 OR03033 QtyAlloc X_NUMERIC 12 20 8 Quantity Allocated (Order Unit)
OR03 OR03034 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
OR03 OR03035 ItemType VSTRING 8 8 0 Item Type
OR03 OR03036 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.
OR03 OR03037 DelDateReque DATE 8 0 0 Delivery Date Requested
OR03 OR03038 FLAGCurrComp SWITCH 1 1 0 Currency Compensation
OR03 OR03039 CompCurrNo INTEGER 2 0 0 Currency Code Compensation
OR03 OR03040 OrDExchRate X_NUMERIC 20 28 8 Order Date Exchange Rate
OR03 OR03041 DelivDExRate X_NUMERIC 20 28 8 Delivery Date Exchange Rate
OR03 OR03042 IntrPlanningBO DATE 8 0 0 Internal Planning Back Order Date
OR03 OR03043 NetWeight X_NUMERIC 10 18 8 Net Weight
OR03 OR03044 GrossWeight X_NUMERIC 10 18 8 Gross Weight
OR03 OR03045 Volume X_NUMERIC 10 18 8 Volume
OR03 OR03046 WarehouseNo VSTRING 6 6 0 Warehouse
OR03 OR03047 StatisPrice MONEY 20 28 8 Statistical Price (Local Currency)
OR03 OR03048 StatisDisco X_NUMERIC 6 14 8 Statistical Discount
OR03 OR03049 StatisCost MONEY 20 28 8 Statistical Cost Price (Local Currency)
OR03 OR03050 QtyOrig X_NUMERIC 12 20 8 Original Quantity (Order Unit)
OR03 OR03051 PickListNo VSTRING 6 6 0 Picking List Number
OR03 OR03052 DiscountsFrozen STRING 1 1 0 Discounts Frozen
OR03 OR03053 QtyAllocated X_NUMERIC 12 20 8 Quantity Allocated (Stock Unit)
OR03 OR03054 QtyDelivered X_NUMERIC 12 20 8 Quantity Delivered (Stock Unit)
OR03 OR03055 FLAGStatupda SWITCH 1 1 0 Statistics Not Updated Used internally during order line entry to indicate if statistics has been updated or not.
OR03 OR03056 QtyReservded X_NUMERIC 12 20 8 Quantity Ordered (Stock Unit)
OR03 OR03057 UnitConvFact X_NUMERIC 10 18 8 UOM Conversion Factor Conversion factor used to convert between sales unit of measurement and stock unit of measurement.
OR03 OR03058 CustDiscoun1 X_NUMERIC 4 12 8 Customer Discount Calculation Item 1
OR03 OR03059 CustDiscoun2 X_NUMERIC 4 12 8 Customer Discount Calculation Item 2
OR03 OR03060 CustDiscoun3 X_NUMERIC 4 12 8 Customer Discount Calculation Item 3
OR03 OR03061 VATCode1 INTEGER 2 0 0 VAT Code 1
OR03 OR03062 VATCode2 INTEGER 2 0 0 VAT Code 2
OR03 OR03063 OrigDefaulPr MONEY 20 28 8 Original Default Price (Original Currency) The original price that was given when the order line was created.
OR03 OR03064 OrigDefaCust X_NUMERIC 6 14 8 Original Default Discount The original line discount given when the order line was created.
OR03 OR03065 InvNoDummy VSTRING 15 15 0 Invoice Number
OR03 OR03066 SuborderNo VSTRING 10 10 0 Sub-order Number
OR03 OR03067 PurchaseOrNo VSTRING 10 10 0 Purchase Order Number
OR03 OR03068 PurchaLineNo VSTRING 12 12 0 Purchase Order Line Number
OR03 OR03069 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
OR03 OR03070 Status1 STRING 1 1 0 Status 1
OR03 OR03071 Status2 STRING 1 1 0 Status 2
OR03 OR03072 Status3 STRING 1 1 0 Status 3
OR03 OR03073 SubType STRING 1 1 0 Sub-type
OR03 OR03074 Contract VSTRING 27 27 0 Contract Number
OR03 OR03075 SearchField VSTRING 35 35 0 Search Key
OR03 OR03076 PickingList NUMBER 10 20 0 Picking List Number
OR03 OR03077 CurrExchgRate2 X_NUMERIC 10 18 8 Currency Exchange Rate 2
OR03 OR03078 CurrExchgAlgtm STRING 3 3 0 Currency Exchange Algorithm
OR03 OR03079 OrderDateExchgRate2 X_NUMERIC 10 18 8 Order Date Exchange Rate 2
OR03 OR03080 OrderDateExchgAlgtm STRING 3 3 0 Order Date Exchange Algorithm
OR03 OR03081 DlvryDateExchgRate2 X_NUMERIC 10 18 8 Delivery Date Exchange Rate 2
OR03 OR03082 DlvryDateExchgAlgtm STRING 3 3 0 Delivery Date Exchange Algorithm
OR03 OR03083 CurrencyCode INTEGER 2 0 0 Currency Code Order
OR03 OR03084 EDIContractSwitch SWITCH 1 1 0 EDI Contract
OR03 OR03085 OrigPriceCurCode INTEGER 2 0 0 Currency Code Original Price
OR03 OR03086 OrigUnitPrice MONEY 20 28 8 Original Unit Price (Original Currency)
OR03 OR03087 PriceDiscountHistory VSTRING 11 11 0 Price/Discount History
OR03 OR03088 CostPriceCC MONEY 20 28 8 Unit Cost Price (Order Currency)
OR03 OR03089 SiteCode STRING 25 25 0 Site Code
OR03 OR03090 TargetDate DATE 8 0 0 Target Date
OR03 OR03091 GRPAltRout VSTRING 2 2 0 Graphical Alternative Routing
OR03 OR03092 GRPStartDate DATE 8 0 0 Graphical Planning Start Date
OR03 OR03093 GRPDueDate DATE 8 0 0 Graphical Planning Due Date
OR03 OR03094 GRPStatus INTEGER 1 0 0 Graphical Status
OR03 OR03095 DropShipmentline VSTRING 1 1 0 Drop Shipment Line
OR03 OR03096 ORBOMNodeID STRING 38 38 0 BoM Node ID Order
OR03 OR03097 SCBOMNodeID STRING 38 38 0 BoM Node ID Stock
OR03 OR03098 CustPOLineNo VSTRING 20 20 0 Customer Purchase Order Line Number
OR03 OR03099 DelCustPOLineNo VSTRING 20 20 0 Delivery Customer Purchase Order Line Number
OR03 OR03100 DiscountGroupNumber INTEGER 9 0 0 Discount Group
OR03 OR03101 DateConfirmationPrinted DATE 8 0 0 Date Confirmation Printed
OR03 OR03102 DatePickListPrinted DATE 8 0 0 Date Picking List Printed
OR03 OR03103 DateDeliveryProposalPrinted DATE 8 0 0 Date Delivery Proposal Printed
OR03 OR03104 BlockForProcess STRING 1 1 0 BOM Blocked for Processing
OR03 OR03105 VersionNumber STRING 4 4 0 Version Number
OR03 OR03106 UnitCostPriceCC MONEY 20 28 8 Unit Cost Price (Alternative Currency)
OR03 OR03107 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
OR03 OR03108 TaxCode STRING 6 6 0 Tax Code Order Line
OR03 OR03109 PriceInclTax MONEY 20 28 8 Unit Price Including Tax (Order Currency)
OR03 OR03110 UseLocalBalance SWITCH 1 1 0 Use local balance
OR03 OR03111 DeliveryWithoutStockTrans SWITCH 1 1 0 Delivery Without Stock Trans
OR03 OR03112 StatisticsLineID STRING 8 8 0 Statistics Line ID
OR03 OR03113 BlockPriceChange SWITCH 1 1 0 Block Price Change Blocked for automatic price change
OR03 OR03114 ConfDD DATE 8 0 0 Confirmed Delivery Date
OR03 OR03115 ConfDDBO DATE 8 0 0 Confirmed Delivery Date Back Order
OR03 OR03116 OriginalConfDD DATE 8 0 0 Original Confirmed Delivery Date
OR03 OR03117 NomenclatureNo VSTRING 25 25 0 NomenclatureNo
OR03 OR03118 DelDateAccepted DATE 8 0 0 Accepted Delivery Date
OR03 OR03119 OrderCustomerCode STRING 10 10 0 Order Customer Code
OR03 OR03120 FinOperationCode VSTRING 10 10 0 FinOperationCode
OR03 OR03121 OrderLinePricingDate DATE 8 0 0 Order Line Pricing Date
OR03 OR03122 OrderPricingNumber STRING 10 10 0 Order Pricing Number
OR03 OR03123 RequestedDeliveryTime VSTRING 20 20 0 Requested Delivery Time
OR03 OR03124 AcceptedDeliveryTime VSTRING 20 20 0 Accepted Delivery Time
OR03 OR03125 ExternalStatus INTEGER 4 0 0 External status
OR03 OR03126 LinePriceType INTEGER 1 0 0 Line Price Type 0 –> Gross price + Discount (existing model)
1 –> Gross price + Net price (new)
OR03 OR03127 NetUnitPrice MONEY 20 28 8 Net Unit Price
OR03 OR03128 ConfirmedProductionDate DATE 8 0 0 Confirmed Production Date
OR03 OR03129 ExemptTaxCode STRING 2 2 0 Exempt Tax Code
OR03 OR03130 ExemptLimit MONEY 20 28 8 Exempt Limit Tax exemption limit used for order line
OR03 OR03131 TaxablePrice MONEY 20 28 8 Taxable Price Taxable Price for FOC items
OR03 OR03132 AcctingCode2 STRING 2 2 0 Accounting Code 2
OR03 OR03133 DeliveryBlocked SWITCH 1 1 0 Delivery block flag
OR03 OR03134 ExportBlocked SWITCH 1 1 0 Export blocked
OR03 OR03135 PackageTaxAmntPerKg MONEY 20 28 8 Packaging Tax Amount per kg
OR03 OR03136 ApprovedCreditLimit SWITCH 1 1 0 Approved credit limit
OR03 OR03137 ProductTaxType VSTRING 10 10 0 Product Tax Type
OR03 OR03138 LineFreightOCU MONEY 20 28 8 Line Freight OCU
OR03 OR03139 LineFreightICU MONEY 20 28 8 Line Freight ICU
OR03 OR03140 InvPrefix STRING 4 4 0 Inv Prefix
OR03 OR03141 TaxReasonCode STRING 3 3 0 Tax Reason Code
OR03 OR03142 ConfirmedbyPlanner SWITCH 1 1 0 Confirmed by Planner
OR03 OR03143 ExtendedUDF1 VSTRING 150 150 0 Extended User defined field 1
OR03 OR03144 ExtendedUDF2 VSTRING 150 150 0 Extended User defined field 2
OR03 OR03145 ExtendedUDF3 VSTRING 150 150 0 Extended User defined field 3
OR03 OR03146 ExtendedUDF4 VSTRING 150 150 0 Extended User defined field 4
OR03 OR03147 ExtendedUDF5 VSTRING 150 150 0 Extended User defined field 5
OR03 OR03148 ExtendedUDF6 VSTRING 150 150 0 Extended User defined field 6
OR03 OR03149 ExtendedUDF7 VSTRING 150 150 0 Extended User defined field 7
OR03 OR03150 ExtendedUDF8 VSTRING 150 150 0 Extended User defined field 8
OR03 OR03151 ExtendedUDF9 VSTRING 150 150 0 Extended User defined field 9
OR03 OR03152 ExtendedUDF10 VSTRING 150 150 0 Extended User defined field 10
OR03 OR03153 ExtendedUDF11 VSTRING 150 150 0 Extended User defined field 11
OR03 OR03154 ExtendedUDF12 VSTRING 150 150 0 Extended User defined field 12
OR03 OR03155 ExtendedUDF13 VSTRING 150 150 0 Extended User defined field 13
OR03 OR03156 ExtendedUDF14 VSTRING 150 150 0 Extended User defined field 14
OR03 OR03157 ExtendedUDF15 VSTRING 150 150 0 Extended User defined field 15
OR03 OR03158 ExtendedUDF16 VSTRING 150 150 0 Extended User defined field 16
OR03 OR03159 ExtendedUDF17 VSTRING 150 150 0 Extended User defined field 17
OR03 OR03160 ExtendedUDF18 VSTRING 150 150 0 Extended User defined field 18
OR03 OR03161 ExtendedUDF19 VSTRING 150 150 0 Extended User defined field 19
OR03 OR03162 ExtendedUDF20 VSTRING 150 150 0 Extended User defined field 20