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 OR05 OR05001 YearKey STRING 2 2 0 Year
OR05 OR05002 ORCountA NUMBER 1 20 0 (obsolete)
OR05 OR05003 ORCountB NUMBER 1 20 0 (obsolete)
OR05 OR05004 ORCountC NUMBER 1 20 0 (obsolete)
OR05 OR05005 InvNoCount NUMBER 1 20 0 (obsolete)
OR05 OR05006 CredNoteCoun NUMBER 1 20 0 (obsolete)
OR05 OR05007 IntInvCount NUMBER 1 20 0 (obsolete)
OR05 OR05008 DispNotCoun NUMBER 1 20 0 (obsolete)
OR05 OR05009 NooInvCop INTEGER 2 0 0 Number of Invoice Copies
OR05 OR05010 NoDisNotCop INTEGER 2 0 0 Number of Dispatch Note Copies
OR05 OR05011 NoConfQuCop INTEGER 2 0 0 Number of Confirmation/Quotation Copies
OR05 OR05012 AcCodNStItm STRING 2 2 0 Accounting Code None Stock Items
OR05 OR05013 DefStOrConf INTEGER 1 0 0 Default Status Order Confirmation
OR05 OR05014 DefStaPickLs INTEGER 1 0 0 Default Status Picking List
OR05 OR05015 DefaOrType INTEGER 1 0 0 Default Order Type
OR05 OR05016 DiscouMethod INTEGER 1 0 0 Discount Method 0 - No discount is calculated.
1 - Customer and volume discount added.
2 - Volume discount only if customer discount is zero.
3 - Multiplied discount (each disc. deducted in turn from net amount)
OR05 OR05017 InvoiceFee MONEY 20 28 8 Invoicing Fee (Local Currency)
OR05 OR05018 LimitInvoFee MONEY 20 28 8 Limit on Invoicing Fee (Local Currency)
OR05 OR05019 DefLimCurCla X_NUMERIC 10 18 8 Default Limit Currency Clause
OR05 OR05020 DefFacCurCla X_NUMERIC 10 18 8 Default Factor Currency Clause
OR05 OR05021 DefCurrClaus INTEGER 2 0 0 Default Currency Clause
OR05 OR05022 IncreOrdPosi INTEGER 3 0 0 Increment for order positions
OR05 OR05023 DefDelivTime INTEGER 3 0 0 Default Delivery Time
OR05 OR05024 ALevLineAdju INTEGER 1 0 0 (obsolete)
OR05 OR05025 ALevPricAdju INTEGER 1 0 0 (obsolete)
OR05 OR05026 FreigSurCha X_NUMERIC 10 18 8 Calculated Freight Charges
OR05 OR05027 WeekBooStat INTEGER 2 0 0 Weeks for Booking Statistics
OR05 OR05028 CodStruArtic INTEGER 1 0 0 Coding of Structured Articles Receipt and Cost Distribution in Bill of Materials:
0 - Receipts on main product, costs on subsidiary products.
1 - Receipts and costs on main product.
2 - Receipts and costs on subsidiary product.
OR05 OR05029 IncrStruLine INTEGER 2 0 0 Increment for Structure Lines
OR05 OR05030 ORCountD NUMBER 1 20 0 (obsolete)
OR05 OR05031 ORCountE NUMBER 1 20 0 (obsolete)
OR05 OR05032 ORCountF NUMBER 1 20 0 (obsolete)
OR05 OR05033 RepORInd X_NUMERIC 6 14 8 Repeat Order Index
OR05 OR05034 PickListCoun NUMBER 1 20 0 (obsolete)
OR05 OR05035 IncrBatchLin INTEGER 2 0 0 Increment for Batch Lines
OR05 OR05036 IncrTexLine INTEGER 2 0 0 Increment for Text Lines
OR05 OR05037 SaveHistMod SWITCH 1 1 0 History Option 0 - Order history not saved.
1 - Compressed order history saved.
2 - Detailed order history saved.
3 - Compressed and detailed Order history are saved.
OR05 OR05038 DelPropNoCou NUMBER 1 20 0 (obsolete)
OR05 OR05039 Spare VSTRING 1 1 0 (obsolete)
OR05 OR05040 OrNoCountG NUMBER 1 20 0 (obsolete)
OR05 OR05041 OrNoCountH NUMBER 1 20 0 (obsolete)
OR05 OR05042 OrNoCountI NUMBER 1 20 0 (obsolete)
OR05 OR05043 OrNoCountJ NUMBER 1 20 0 (obsolete)
OR05 OR05044 OrNoCountK NUMBER 1 20 0 (obsolete)
OR05 OR05045 OrNoCountL NUMBER 1 20 0 (obsolete)
OR05 OR05046 OrNoCountM NUMBER 1 20 0 (obsolete)
OR05 OR05047 OrNoCountN NUMBER 1 20 0 (obsolete)
OR05 OR05048 OrNoCountO NUMBER 1 20 0 (obsolete)
OR05 OR05049 OrNoCountP NUMBER 1 20 0 (obsolete)
OR05 OR05050 OrNoCountQ NUMBER 1 20 0 (obsolete)
OR05 OR05051 OrNoCountR NUMBER 1 20 0 (obsolete)
OR05 OR05052 OrNoCountS NUMBER 1 20 0 (obsolete)
OR05 OR05053 OrNoCountT NUMBER 1 20 0 (obsolete)
OR05 OR05054 OrNoCountU NUMBER 1 20 0 (obsolete)
OR05 OR05055 OrNoCountV NUMBER 1 20 0 (obsolete)
OR05 OR05056 OrNoCountW NUMBER 1 20 0 (obsolete)
OR05 OR05057 OrNoCountX NUMBER 1 20 0 (obsolete)
OR05 OR05058 OrNoCountY NUMBER 1 20 0 (obsolete)
OR05 OR05059 OrNoCountZ SWITCH 1 1 0 (obsolete)
OR05 OR05060 StockAccng SWITCH 1 1 0 Stock Accounting 0 - Cost of material sold not booked.
1 - When the order is booked, stock issued and cost of material sold are noted via the Automatic Accounting Schedule in the Sales Ledger.
2 - Stock accounting with date stamping
3 - Stock accounting with value stamping
OR05 OR05061 PrnTotConfir SWITCH 1 1 0 BOM Allocation on Costs
OR05 OR05062 DispNotPickL SWITCH 1 1 0 Quantity Option on Delivery Note 0 - Print delivery note using delivered quantity
1 - Print delivery note using ordered quantity
2 - Print delivery note with only delivered lines
3 - Print delivery note with only last delivery
OR05 OR05063 AutRelAftDel SWITCH 1 1 0 Release Invoice after Stock Issue
OR05 OR05064 DiscOnInvo SWITCH 1 1 0 Show Discounts on Invoice
OR05 OR05065 DiscAccing SWITCH 1 1 0 Discount Accounting
OR05 OR05066 DelDateWee SWITCH 1 1 0 Delivery Date as Weeks
OR05 OR05067 ItemsDispNot SWITCH 1 1 0 Print No of items on dispatch Notes
OR05 OR05068 CustCredLim SWITCH 1 1 0 Check Customer Credit Limit
OR05 OR05069 WeVolCalc SWITCH 1 1 0 Weight and volume calculation per unit
OR05 OR05070 PrnDispNot SWITCH 1 1 0 Print Dispatch Notes for Order Type 2
OR05 OR05071 DiscPriOrLi SWITCH 1 1 0 Enter discount and price on order lines
OR05 OR05072 QyShipUniN SWITCH 1 1 0 Enter qty as no of shipment units
OR05 OR05073 CrPOrProp SWITCH 1 1 0 Create purchase order proposals
OR05 OR05074 OrlineDelDat SWITCH 1 1 0 Update line delivery date when Order Head Delivery Date Changed
OR05 OR05075 TermsDelCus SWITCH 1 1 0 Use terms from delivery customer
OR05 OR05076 OrEntryStat SWITCH 1 1 0 Generate order entry statistics
OR05 OR05077 InvoicStat SWITCH 1 1 0 Generate invoicing statistics
OR05 OR05078 CurrClausStd SWITCH 1 1 0 Currency Clause as Standard
OR05 OR05079 CurrClItem SWITCH 1 1 0 Currency Clause per Item
OR05 OR05080 AdInvRepOr SWITCH 1 1 0 Advance Invoice Repeat Orders
OR05 OR05081 PrcDelDate SWITCH 1 1 0 Pricing on Delivery Date 0 - Price will be calculated when entering order lines
1 - Price will be calculated when delivering
2 - Price will be calculated when invoicing
OR05 OR05082 GenBookSt SWITCH 1 1 0 Generate Booking Statistics
OR05 OR05083 DelivSched SWITCH 1 1 0 Delivery Planning 0 - No stock planning
1 - Standard stock planning
2 - Lead time model based stock planning
OR05 OR05084 StDelCust SWITCH 1 1 0 Statistics on Delivery Customer
OR05 OR05085 DelNoteProp SWITCH 1 1 0 (obsolete)
OR05 OR05086 ShipOnInv SWITCH 1 1 0 Only Shipped Lines/Quantity on Invoices
OR05 OR05087 AutStrPrep SWITCH 1 1 0 Automatic Structure Prepare
OR05 OR05088 SortPickLst SWITCH 1 1 0 Sorted Picking List
OR05 OR05089 Spare SWITCH 1 1 0 Keep historical BoM distribution
OR05 OR05090 GrpVolDisc SWITCH 1 1 0 Group Volume Discounts
OR05 OR05091 OrMergeSL SWITCH 1 1 0 Order Merge via SL
OR05 OR05092 CurrFrCust SWITCH 1 1 0 Source of Currency 0 - Order and invoice currency determined by Price List Currency.
1 - Order and invoice currency determined by customer currency.
2 - Order currency determined by price list currency, invoice currency determined by customer currency
OR05 OR05093 TextLnOrEnt SWITCH 1 1 0 Show Text Lines at Order entry
OR05 OR05094 ConvPriceToOrdCurr SWITCH 1 1 0 Convert price to order currency
OR05 OR05095 PrnDocInvCuO SWITCH 1 1 0 Print Documents in Invoice Customer Order
OR05 OR05096 PickDispNWH SWITCH 1 1 0 Sort Picking List/Dispatch Note per Warehouse
OR05 OR05097 SectnsQuote VSTRING 1 1 0 Sections on Quote
OR05 OR05098 BEdatDelDat VSTRING 1 1 0 BE-date= delivery date
OR05 OR05099 BEdaOrClosg VSTRING 1 1 0 Check BE-Date on Order Closing
OR05 OR05100 PricingInvDt VSTRING 1 1 0 Pricing on Invoice Date
OR05 OR05101 ValidateDates VSTRING 1 1 0 Validate Dates
OR05 OR05102 AccLevel VSTRING 1 1 0 (obsolete)
OR05 OR05103 AllowZeroEffect SWITCH 1 1 0 Allow zero effective price
OR05 OR05104 Spare VSTRING 1 1 0 Reservation for Backorders
OR05 OR05105 Spare VSTRING 1 1 0 Sales Slips printing
OR05 OR05106 Spare VSTRING 1 1 0 Prices for internal customer Effect only sales prices for internal customers but not production orders.
0 - Prices cannot be adjusted and are equal to the cost of stock item according to the current stock valuation model
1 - Prices cannot be adjusted and are equal to zero
2 - Prices can be adjusted
OR05 OR05107 Spare VSTRING 1 1 0 Split Cost of Goods Sold
OR05 OR05108 AdditParam1 VSTRING 10 10 0 Greece: verification period for 30-days rule
OR05 OR05109 AdditParam2 VSTRING 10 10 0 (obsolete)
OR05 OR05110 AdditParam3 VSTRING 10 10 0 (obsolete)
OR05 OR05111 AdditParam4 VSTRING 10 10 0 (obsolete)
OR05 OR05112 AdditParam5 VSTRING 10 10 0 (obsolete)
OR05 OR05113 AdditParam6 VSTRING 10 10 0 (obsolete)
OR05 OR05114 AdditParam7 VSTRING 10 10 0 (obsolete)
OR05 OR05115 AdditParam8 VSTRING 10 10 0 (obsolete)
OR05 OR05116 AdditParam9 VSTRING 10 10 0 (obsolete)
OR05 OR05117 AdditParam10 VSTRING 10 10 0 (obsolete)
OR05 OR05118 AdditParam11 SWITCH 1 1 0 Allow change of Backorder Date
OR05 OR05119 AdditParam12 SWITCH 1 1 0 Close Condition Traditional Orders 0 - Invoice was printed
1 - Invoice was printed or XML send
2 - Invoice was printed and XML sent
OR05 OR05120 AdditParam13 SWITCH 1 1 0 Close Condition Electronic Orders 0 - Invoice was printed
1 - Invoice was printed or XML send
2 - Invoice was printed and XML sent
3 - XML was sent
OR05 OR05121 AdditParam14 SWITCH 1 1 0 Create Electronic Order Option 0 - If any customer (order, invoice or delivery) is market as electronic
1 - If order customer is marked as electronic
2 - If Invoice customer is marked as electronic
3 - If Delivery customer is marked as electronic
OR05 OR05122 AdditParam15 SWITCH 1 1 0 Automatic Grouping Method 0 - Manual sales orders grouping
1 - Semi-automatic sales orders grouping
2 - Automatic sales orders grouping
OR05 OR05123 DefaultInvoiceSplit SWITCH 1 1 0 Default Invoice Split
OR05 OR05124 AdditParam17 SWITCH 1 1 0 (obsolete)
OR05 OR05125 AdditParam18 SWITCH 1 1 0 (obsolete)
OR05 OR05126 AdditParam19 SWITCH 1 1 0 (obsolete)
OR05 OR05127 AdditParam20 SWITCH 1 1 0 (obsolete)
OR05 OR05128 FlagSiteCodeAdjustmentinOrderLine INTEGER 1 0 0 Site Code Adjustment in an Order Line
OR05 OR05129 WeightCustomerPriority INTEGER 3 0 0 Weight Customer Priority for Order
OR05 OR05130 WeightServiceOrderPriority INTEGER 3 0 0 Weight Order Priority
OR05 OR05131 DefaultOrderPriority INTEGER 1 0 0 Default Order Priority
OR05 OR05132 FlagAllowSiteCodeEmpty SWITCH 1 1 0 Site Code Can be Empty
OR05 OR05133 FlagAllowErrorLogonOrderClose SWITCH 1 1 0 BOM Price View 0 - Price for top order line is displayed; prices for components are set to zero.
1 - Price for top order line is set to zero; prices for components are displayed.
2 - Prices for both top order line and components are displayed.
OR05 OR05134 FlagDSSplitperSalesOrder INTEGER 1 0 0 Drop Shipment Split per Sales Order?
OR05 OR05135 SaveVersionHistory INTEGER 1 0 0 Save Version History
OR05 OR05136 DefaultStructQueryStockItem NUMBER 1 20 0 Default Structure Query 0 - BOM Configurations query will be shown by default for Stock Item.
1 - BOM Templates query will be shown by default for Stock Item.
2 - Both BOM Templates and BOM Configurations will be shown by default for Stock Item.
OR05 OR05137 FlexibleBOMPricing SWITCH 1 1 0 Flexible BOM Pricing
OR05 OR05138 TaxCodeNonStockItem STRING 6 6 0 Tax code Non-Tangible Items
OR05 OR05139 ConsolidatedDSDelivery SWITCH 1 1 0 Consolidated DS Delivery
OR05 OR05140 DefaultStructQryBOMConfigurator SWITCH 1 1 0 Default Structure Query in BOM Configurator
OR05 OR05141 SaveInvoiceImage SWITCH 1 1 0 Save Invoice Image
OR05 OR05142 DeliveryMilestone SWITCH 1 1 0 Milestone related to Delivery Date
OR05 OR05143 LTAPStartBeforeToday SWITCH 1 1 0 LT AP start before today
OR05 OR05144 CreateInvFutureBookDate SWITCH 1 1 0 Create Invoices with Future Booking Date
OR05 OR05145 CloseInvFutureBookDate SWITCH 1 1 0 Close Invoices with Future Booking Date
OR05 OR05146 ATPCancellationCode VSTRING 4 4 0 ATP Cancellation Code
OR05 OR05147 EDIProcessLeadTime X_NUMERIC 10 18 8 EDI Process Lead Time
OR05 OR05148 DistrChargeTaxSwitch SWITCH 1 1 0 Distr Charge Tax Switch Distribution Charge Tax on Line Level
OR05 OR05149 UpdateWO INTEGER 1 0 0 Update work order
OR05 OR05150 UpdateWOTill INTEGER 1 0 0 Update work order till
OR05 OR05151 CostDSItemBeforeDelivery INTEGER 1 0 0 Cost of drop shipment items before delivery
OR05 OR05152 FreightTaxCodeSrc INTEGER 1 0 0 Freight tax code source
OR05 OR05153 CostCheckFlag SWITCH 1 1 0 Cost Check Flag
OR05 OR05154 CustomerForPrice SWITCH 1 1 0 Customer for price
OR05 OR05155 PackMtrlChargePerOR SWITCH 1 1 0 Pack. Material charge per Sales Order?
OR05 OR05156 PackagingTaxAmountperOrder MONEY 20 28 8 Packaging Tax Amount per Order
OR05 OR05157 TaxCodePackMtrlPerOrder STRING 2 2 0 Tax Code, Pack. Material per Order
OR05 OR05158 BlockConvQuotOrd SWITCH 1 1 0 Block conversion quotation to order if customer is blocked by credit control
OR05 OR05159 BlockOREntry SWITCH 1 1 0 Block Sales Order entry if customer is blocked by credit control
OR05 OR05160 CrCheckORLineEntry SWITCH 1 1 0 Credit check at Sales order line entry
OR05 OR05161 CrCheckORExit SWITCH 1 1 0 Credit check at Sales order exit
OR05 OR05162 BlockAlloc SWITCH 1 1 0 Block allocation if customer is blocked by credit control
OR05 OR05163 BlockDeliv SWITCH 1 1 0 Block delivery if customer is blocked by credit control
OR05 OR05164 BlockDSPO SWITCH 1 1 0 Block drop shipment PO creation if customer is blocked by credit control
OR05 OR05165 SkipCrCheck SWITCH 1 1 0 Skip additional credit checks after order entry
OR05 OR05166 ExcludeDO SWITCH 1 1 0 Exclude Credit blocked, Direct orders at Purchase proposal creation
OR05 OR05167 BlockWO SWITCH 1 1 0 Block Work Order creation if customer is blocked by credit control
OR05 OR05168 ProductTaxTypeNonStockItem VSTRING 10 10 0 Product Tax Type Non Stock Item
OR05 OR05169 RedStornoDef SWITCH 1 1 0 Red Storno Default
OR05 OR05170 DefTaxPoint STRING 1 1 0 DefTaxPoint
OR05 OR05171 NoReturnNoteCopies INTEGER 2 0 0 Number of Copies for Return Note Print Return Notes functionality
OR05 OR05172 BlockPLPrintCRC SWITCH 1 1 0 Block picking list printing if customer is blocked by credit control
OR05 OR05173 TaxReasonCode STRING 3 3 0 Tax Reason Code
OR05 OR05174 ConfirmationControlledbyPlanner SWITCH 1 1 0 Confirmation Controlled by Planner
OR05 OR05175 DefValidPeriodQuot INTEGER 3 0 0 Default validity period for quotations Default validity period for quotations
OR05 OR05176 FreightTaxCode INTEGER 2 0 0 Freight Tax Code
OR05 OR05177 ControlStockReturn SWITCH 1 1 0 Control Stock Return