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 PRX5 PRX5001 TransactDate VSTRING 8 8 0 TransactDate
2 PRX5 PRX5002 VATcode VSTRING 2 2 0 VAT_code
3 PRX5 PRX5003 CurrencyCode VSTRING 2 2 0 CurrencyCode
4 PRX5 PRX5004 OrderNo VSTRING 10 10 0 Order_No
5 PRX5 PRX5005 OrderLine VSTRING 6 6 0 Order_Line
6 PRX5 PRX5006 OrdStruLine VSTRING 6 6 0 OrdStruLine
7 PRX5 PRX5007 OrdDelivLine VSTRING 4 4 0 OrdDelivLine
PRX5 PRX5008 StoItAccCode VSTRING 2 2 0 StoItAccCode
PRX5 PRX5009 AccounString ACCSTR 120 120 0 AccounString
PRX5 PRX5010 StockItem VSTRING 35 35 0 StockItem
PRX5 PRX5011 BatchNoDeliv VSTRING 12 12 0 BatchNoDeliv
PRX5 PRX5012 QtyOrdered VSTRING 12 12 0 QtyOrdered
PRX5 PRX5013 QtyDelivered VSTRING 12 12 0 QtyDelivered
PRX5 PRX5014 QtyOrderSC VSTRING 12 12 0 QtyOrdered
PRX5 PRX5015 QtyDelivSC VSTRING 12 12 0 QtyDelivered
PRX5 PRX5016 PrUnWoDisc VSTRING 20 20 0 PrUnWoDisc
PRX5 PRX5017 PrUnWDisc VSTRING 20 20 0 PrUnWDisc
PRX5 PRX5018 PrUnWoDiscLCU VSTRING 20 20 0 PrUnWoDisc
PRX5 PRX5019 PrUnWDiscLCU VSTRING 20 20 0 PrUnWDisc
PRX5 PRX5020 DeliDatExRat VSTRING 20 20 0 DeliDatExRat
PRX5 PRX5021 CostUnit VSTRING 20 20 0 CostUnit
PRX5 PRX5022 DeliDateRequ VSTRING 8 8 0 DeliDateRequ
PRX5 PRX5023 DeliDateComm VSTRING 8 8 0 DeliDateComm
PRX5 PRX5024 DeliDateActu VSTRING 8 8 0 DeliDateActu
PRX5 PRX5025 DeliNoteNo VSTRING 20 20 0 DeliNoteNo
PRX5 PRX5026 DeliNotePrin VSTRING 1 1 0 DeliNotePrin
PRX5 PRX5027 PickListPrin VSTRING 1 1 0 PickListPrin
PRX5 PRX5028 DeliPropPrin VSTRING 1 1 0 DeliPropPrin
PRX5 PRX5029 NetWeight VSTRING 10 10 0 NetWeight
PRX5 PRX5030 GrossWeght VSTRING 10 10 0 GrossWeght
PRX5 PRX5031 Volume VSTRING 10 10 0 Volume
PRX5 PRX5032 PickListNo VSTRING 10 10 0 PickListNo
PRX5 PRX5033 DelivPropNo VSTRING 10 10 0 DelivPropNo
PRX5 PRX5034 ConsCostPric VSTRING 20 20 0 ConsCostPric
PRX5 PRX5035 VATCode2 VSTRING 6 6 0 VAT_Code
PRX5 PRX5036 Warehouse VSTRING 6 6 0 Warehouse
PRX5 PRX5037 LineDiscount VSTRING 6 6 0 LineDiscount
PRX5 PRX5038 OrderDiscou VSTRING 6 6 0 OrderDiscou
PRX5 PRX5039 ItemType STRING 1 1 0 Item Type
PRX5 PRX5040 OperationType VSTRING 10 10 0 Operation Type
PRX5 PRX5041 FinancialOperationCode VSTRING 10 10 0 Financial Operation Code
PRX5 PRX5042 NomenclatureNumber VSTRING 25 25 0 Nomenclature Number
PRX5 PRX5043 ProductTaxType VSTRING 10 10 0 Product Tax Type
PRX5 PRX5044 TaxationReasonCode STRING 3 3 0 Taxation Reason Code