Data files and program files modified by UniDevCo products.

UniDevCo products create a data directory named UNI within the ACCPAC company database directory.   Within this directory we put our DDF files and data files along with, for some products, an additional directory named TEMPDB which contains temporary files required for processing. 

We add fields and indexes to some existing ACCPAC data files.  You will find a listing of the files and the indexes and fields we add below.

Please note that while ACCPAC does provide for the adding and removing of indexes, only adding of fields is allowed.  Indexes are added and removed by activating and deactivating our products.  Once a field is added, it can not be removed. 

Files Modified by UniDevCo Product Installs

Stock Card:

Affects one ACCPAC file and adds 2 fields and 2 indexes. 

Inventory Control

File: ICHIST - IC History

Fields:  (2)

UNISTOCKCD - True/False - Record imported or not.

ICEXTCOST - Actual extended cost for Standard Costing items.  IC puts the STD cost in the HOMEEXTCST rather than the actual cost posted.

Indexes:  (2)

ITEMNO;LOCATION;FISCYEAR;FISCPERIOD

UNISTOCKCD;ITEMNO;LOCATION;FISCYEAR;FISCPERIOD;TRANSDATE;DAYENDSEQ;ENTRYSEQ

Sales Analysis:

Affects four ACCPAC files and adds 4 fields and 4 indexes. 

Accounts Receivable:

File: ARIBC - AR Invoice Batch Control

Fields:  (1)

UNISALES - True/False - Record imported or not.

Indexes:  (1)

UNISALES;CNTBTCH 

Order Entry:

File: OEINVH - OE Invoices

Fields: (1)

UNISALES - True/False - Record imported or not.

Indexes: (1)

UNISALES;INVNUMBER

File: OECRDH - OE Credit Notes

Fields:(1)

UNISALES - True/False - Record imported or not.

Indexes:(1)

UNISALES;CRDNUMBER 

Inventory Control:

File: ICSHIPH - IC Shipments

Fields: (1)

UNISALES - True/False - Record imported or not.

Indexes: (1)

UNISALES;DAYENDSEQ;TRANSSEQ 

Ops Inquiry:

Affects nine ACCPAC files adding no fields and 9 indexes.

Inventory Control:

File: ICHIST - IC History

Fields: (0)

Indexes: (1)

ITEMNO;LOCATION;FISCYEAR;FISCPERIOD

File: ICSRLN - IC Serial Numbers

Fields: (0)

Indexes: (1)

ITEMNO;LOCATION;SEQUENCE;LINENO

File: ICPRTX - IC Price Tax

Fields: (0)

Indexes: (1)

ITEMNO;CURRENCY;PRICELIST;AUTHORITY

File: ICCUPR - IC Contract Pricing

Fields:(0)

Indexes:(1)

PRICEBY;ITEMNO;CATEGORY;CUSTNO;PRICELIST 

Order Entry:

File: OEORDD - OE Order Details

Fields: (0)

Indexes: (1)

ITEM;ORDUNIQ;LINENUM

File: OEORDDD - OE Order Kitting Details

Fields: (0)

Indexes: (1)

COMPONENT, ORDUNIQ, LINENUM, COMPNUM

File: OEORDDB - OE Order BOM Details

Fields: (0)

Indexes: (1)

COMPONENT, ORDUNIQ, LINENUM, PRNCOMPNUM, COMPNUM

File: OESHID - OE Shipment Details

Fields: (0)

Indexes: (1)

ITEM, SHIUNIQ, LINENUM

OE Program files: [ACCPAC 4.2 only]

If the OE Link is installed, two existing OE program files have been renamed to *.org and new modified ones have been put in place.:

Files: OE1100F6.RDO and OE1100F7.RDO

Location: \OE42A\ENG 

Purchase Orders:

File: POPORL - PO Line Details

Fields: (0)

Indexes: (1)

ITEMNO;PORHSEQ;PORLREV 

AR Inquiry:

Affects four ACCPAC files adding 2 fields and 3 indexes. 

Accounts Receivable:

File: ARCMM – Customer comments

            Fields: (2)
            NOTETYPE – type of note set up in AR Inquiry Setup
            USERID – user name for entered note
            Indexes: (0)

File: AROBP - Document Payments

Fields: (0)

Indexes: (1)

IDCUST;IDRMIT;ICINVC;CNTSEQNCE

File: ARIBH - Invoices

Fields:(0)

Indexes:(1)

IDCUST;IDINVC

File: ARIBD - Invoice Details

Fields:(0)

Indexes:(1)

IDINVC;CNTLINE 

UniSerials:

Affects one MISys file adds 1 field and 1 index. 

MISys SLT:

File: MXHIST - MISys SLT History

Fields: (1)

UNISERIALS - True/False - Record imported or not.

Indexes: (1)

UNISERIALS

or email info@unidevco.com with questions or comments about this web. Last modified: November 22, 2006 Copyright © 2000 - 2005 Uni Development Company Inc. All rights reserved.  All other marks are trademarks or registered trademarks of their respective companies.