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
PR01 Project Master Table Company PR010100
PR02 Project Activities Company PR020100
PR03 Project Activity Transactions Company PR030100
PR10 Activity Master Table Company PR100100
PR11 Activity Price Lists Company PR110100
PR13 Project Module Parameters Company PR130100
PR14 Project Invoice Text File Company PR140100
PR15 Project Delivery Addresses Company PR150100
PR17 Project Text Lines Company PR170100
PR18 Project Account Rule On-charges Company PR180100
PR19 Project Sub-project/Resource/Activity Price/Markup Company PR190100
PR23 Project Planning Calendar Company Year PR230112
PR24 Project User Database File Company PR240100
PR25 User Database Definitions Company PR250100
PR26 User Database Field Definitions Company PR260100
PR27 Project Invoice Proposal Transactions Company PR270100
PR28 Project Invoice Proposal Head Company PR280100
PR29 Project Invoice History Company PR290100
PR30 Project User Code File Definition Company PR300100
PR31 Project Invoice Plan Company PR310100
PR32 Project Accounting Journal Company Year PR320112
PR33 Project Automatic Account Coding Schedule Company Year PR330112
PR34 Project Budgets and Forecasts Company PR340100
PR35 Project Sub-projects Company PR350100
PR36 Main Projects Company PR360100
PR37 Project Templates Company PR370100
PR38 Project Invoice History Details Company PR380100
PR39 Company Year PR390112
PR41 Transaction Journal Company PR410100
PR42 Transaction Journal Text Lines Company PR420100
PR43 Resource Time Cards Company PR430100
PR44 Project Delivered Material Company PR440100
PR45 Invoice Statistics Head Company PR450100
PR46 Invoice Statistics Lines Company PR460100
PR47 Invoice Statistics Material Company PR470100
PR48 Import/Export definitions Company PR480100
PR49 WIP History Company PR490100
PR50 Sales Order Template Company PR500100
PR51 Project Activity Descriptions Company PR510100
PR52 Invoice Specification Company PR520100
PR53 Company PR530100
PRGL Company PRGL0100
PRI0 Project Instalments Company PRI00100
PRI2 Project Instalment Lines Company PRI20100
PRI4 Project Instalment Lines History Company PRI40100
PRX1 Wrk. PR0162 PRX10000
PRX2 Time Planning w PRX20000
PRX3 Cl.Pj.Inv. wrk. PRX30000
PRX4 Ed.Inv.Prop.wrk PRX40000
PRX5 Ed.Inv.Prop.wr1 PRX50000
PRX6 PRX60000
PRX7 Ed.Inv.Hist.wr1 PRX70000
PRX8 View Activites PRX80000
PRX9 Pj.Int.Debit w. PRX90000
PRXX Tr.Entries wrk. PRXX0000
PRXY Tr.Entries txt. PRXY0000
PRXZ Reports wrk. PRXZ0000

Fields
PK Table Name Description Type Length Precision Note
1 PR44 PR44001 ProjectNo VSTRING 12 12 0 Project Number
2 PR44 PR44002 SubProject VSTRING 6 6 0 Sub-Project
3 PR44 PR44003 ActivityLine VSTRING 6 6 0 Activity Line Number
4 PR44 PR44004 ActivStrLine VSTRING 6 6 0 Activity Sub-line Number
5 PR44 PR44005 TransactDate DATE 8 0 0 Transaction Date
6 PR44 PR44006 ResourceCode VSTRING 10 10 0 Resource Code
7 PR44 PR44007 TransactLine VSTRING 6 6 0 Transaction Line Number
8 PR44 PR44008 DelivTransLn VSTRING 6 6 0 Delivery Line Number
PR44 PR44009 StoItemAcCod VSTRING 2 2 0 Accounting Code Stock Item
PR44 PR44010 AccounString ACCSTR 120 120 0 Accounting String
PR44 PR44011 StockItem VSTRING 35 35 0 Stock Item Code
PR44 PR44012 BatchNoDeliv VSTRING 12 12 0 Batch ID
PR44 PR44013 OrderNumber VSTRING 10 10 0 Order Number
PR44 PR44014 LineNumber VSTRING 6 6 0 Order Line Number
PR44 PR44015 StructLineNo VSTRING 6 6 0 Order Sub-line Number
PR44 PR44016 AutSubStrLNo VSTRING 4 4 0 Order Delivery Line Number
PR44 PR44017 QtyOrdered X_NUMERIC 12 20 8 Quantity Ordered (Order Unit)
PR44 PR44018 QtyDelivered X_NUMERIC 12 20 8 Quantity Delivered (Order Unit)
PR44 PR44019 QtyOrderedSC X_NUMERIC 12 20 8 Quantity Ordered (Stock Unit)
PR44 PR44020 QtyDelivSC X_NUMERIC 12 20 8 Quantity Delivered (Stock Unit)
PR44 PR44021 Spare VSTRING 12 12 0 (obsolete)
PR44 PR44022 Spare VSTRING 12 12 0 (obsolete)
PR44 PR44023 UnitPriceExclDisc MONEY 20 28 8 Unit Price Excluding Discount (Project Currency)
PR44 PR44024 UnitPriceInclDisc MONEY 20 28 8 Unit Price Including Discount (Project Currency)
PR44 PR44025 UnitPriceExclDiscLCU MONEY 20 28 8 Unit Price Excluding Discount (Local Currency)
PR44 PR44026 UnitPriceInclDiscLCU MONEY 20 28 8 Unit Price Including Discount (Local Currency)
PR44 PR44027 DelivDaExRat X_NUMERIC 20 28 8 Delivery Date Exchange Rate
PR44 PR44028 CostUnit MONEY 20 28 8 Unit Cost (Local Currency)
PR44 PR44029 DeliDateRequ DATE 8 0 0 Delivery Date Requested
PR44 PR44030 DeliDateComm DATE 8 0 0 Delivery Date Committed
PR44 PR44031 DeliDateActu DATE 8 0 0 Delivery Date Actual
PR44 PR44032 DeliNoteNo VSTRING 20 20 0 Delivery Note Number
PR44 PR44033 DelivNotePrn VSTRING 1 1 0 Delivery Note Print Status 0/1 - Delivery note was not printed for the delivery line
2 - Delivery note has been printed for the delivery line
PR44 PR44034 PickListPrin VSTRING 1 1 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).
PR44 PR44035 DeliPropPrin VSTRING 1 1 0 BOM Level 0 - Not a BOM line
5 - The order line is the top level in a BOM structure
6 - The order line is the lowest level in a BOM structure
7 - The order line is a intermediate level in a BOM structure
PR44 PR44036 NetWeight X_NUMERIC 10 18 8 Net Weight
PR44 PR44037 GrossWeight X_NUMERIC 10 18 8 Gross Weight
PR44 PR44038 Volume X_NUMERIC 10 18 8 Volume
PR44 PR44039 PickListNo VSTRING 10 10 0 Picking List Number
PR44 PR44040 DelivPropNo VSTRING 10 10 0 Delivery Proposal Number
PR44 PR44041 ConsCostType MONEY 20 28 8 Unit Cost (Alternative Currency)
PR44 PR44042 VATCode VSTRING 6 6 0 VAT Code
PR44 PR44043 Warehouse VSTRING 6 6 0 Warehouse
PR44 PR44044 LineDiscount X_NUMERIC 6 14 8 Line Discount %
PR44 PR44045 OrdDiscount X_NUMERIC 6 14 8 Order Discount %
PR44 PR44046 ItemType STRING 1 1 0 Item Type
PR44 PR44047 CloseDate DATE 8 0 0 Close Date
PR44 PR44048 TaxationReasonCode STRING 3 3 0 Taxation Reason Code