|
Description:
|
If the
programs are previously unmodified and the same versions,
these new programs may just be copied over. As with all modifications,
it is recommended that the ACCPAC versions be checked to assure
they are the same. Programs that have been modified are distributed
in the same manner as described in the ACCPAC Installation Guide.
Programs beginning with "TO", "T0", and "P0" should be treated
the same as "SYS" files in ACCPAC, and should be located in the
same directory as "SYSDATA.DBF". If there are any databases
on the distribution disk that begin with "TO" they should
also be located in the system directory. Please refer to the
installation instructions. The TOINST program will normally
rename and locate programs as required, but some files may
need to be moved depending on the individual system configuration.
A new
database has been established as documented here. It includes
all the mandatory fields, and a few that are not mandatory.
If the fields not marked as mandatory should not be included,
delete them from the database after installation, or from
the dictionary (EPDICD) if they have not already been installed.
To add other fields, they can be added manually or added to
the dictionary and the installation will add them in all current
and future companies.
|
|
Program
and Form Changes:
|
The following
programs and forms have either been changed or added:
ARIMPCnn.DBF
Customer
File for Import Reference
Tags:
CUSTNO
Key: custno
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ADDRESS1
|
C |
30 |
0 |
|
| ADDRESS2
|
C |
30 |
0 |
|
| BALANCE
|
N |
12 |
2 |
|
| CITY
|
C |
20 |
0 |
|
| CODE
|
C |
2 |
0 |
|
| COMMENT
|
C |
65 |
0 |
|
| COMPANY
|
C |
35 |
0 |
|
| CONTACT
|
C |
20 |
0 |
|
| COUNTRY
|
C |
15 |
0 |
|
| CREDIT
|
N |
12 |
2 |
|
| CSTNUM1
|
N |
9 |
0 |
|
| CSTNUM2
|
N |
9 |
0 |
|
| CURRENCY
|
C |
3 |
0 |
|
| CUSTNO
|
C |
6 |
0 |
|
| DEALER
|
C |
6 |
0 |
|
| DISC
|
N |
7 |
3 |
|
| ENTERED
|
C |
8 |
0 |
|
| FAXNO
|
C |
20 |
0 |
|
| FLAGS
|
C |
10 |
0 |
|
| FORWARD
|
N |
12 |
2 |
|
| GLLINK
|
C |
3 |
0 |
|
| HISTORY
|
C |
1 |
0 |
|
| INDUST
|
C |
5 |
0 |
|
| LASTPAY
|
C |
8 |
0 |
|
| LDATE
|
C |
8 |
0 |
|
| LIMIT
|
N |
7 |
0 |
|
| LPYMT
|
N |
12 |
2 |
|
| LSALE
|
N |
12 |
2 |
|
| LSTCALL
|
C |
8 |
0 |
|
| ONORDER
|
N |
12 |
2 |
|
| PDAYS
|
N |
3 |
0 |
|
| PDISC
|
N |
7 |
3 |
|
| PHONE
|
C |
20 |
0 |
|
| PNET
|
N |
3 |
0 |
|
| PRICECODE
|
C |
1 |
0 |
|
| PTDSLS
|
N |
12 |
2 |
|
| PTERMS
|
C |
20 |
0 |
|
| SALESMN
|
C |
2 |
0 |
|
| SIGNATURE
|
N |
2 |
0 |
|
| SOURCE
|
C |
5 |
0 |
|
| STATE
|
C |
10 |
0 |
|
| STATFMT
|
C |
1 |
0 |
|
| SVC
|
N |
7 |
3 |
|
| TAX
|
N |
7 |
3 |
|
| TAXCODE
|
C |
1 |
0 |
|
| TAXDIST
|
C |
4 |
0 |
|
| TERR
|
C |
2 |
0 |
|
| TITLE
|
C |
20 |
0 |
|
| TYPE
|
C |
8 |
0 |
|
| YTDSLS
|
N |
12 |
2 |
|
| ZIP
|
C |
10 |
0 |
|
| |
|
|
ARIMPInn.DBF
Item
File for Import
Tags:
ITEM
Key: item
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ALOC
|
N |
12 |
3 |
|
| CLASS
|
C |
2 |
0 |
|
| CODE
|
C |
2 |
0 |
|
| COST
|
N |
12 |
3 |
|
| DECNUM
|
N |
1 |
0 |
|
| DESCRIP
|
C |
35 |
0 |
|
| DISCRATE
|
N |
7 |
3 |
|
| GLLINK
|
C |
3 |
0 |
|
| HISTORY
|
C |
1 |
0 |
|
| ITEM
|
C |
15 |
0 |
|
| LASTORDR
|
C |
8 |
0 |
|
| LDATE
|
C |
8 |
0 |
|
| LEAD
|
N |
3 |
0 |
|
| LEVEL2
|
N |
12 |
3 |
|
| LEVEL3
|
N |
12 |
3 |
|
| ONHAND
|
N |
12 |
3 |
|
| ONORDER
|
N |
12 |
3 |
|
| ORDERPT
|
N |
12 |
3 |
|
| ORDERQTY
|
N |
12 |
3 |
|
| PRICE
|
N |
12 |
2 |
|
| PRICE2
|
N |
12 |
2 |
|
| PRICE3
|
N |
12 |
2 |
|
| PTDQTY
|
N |
12 |
3 |
|
| PTDSLS
|
N |
12 |
2 |
|
| REC1
|
N |
12 |
3 |
|
| REC2
|
N |
12 |
3 |
|
| REC3
|
N |
12 |
3 |
|
| REC4
|
N |
12 |
3 |
|
| REC5
|
N |
12 |
3 |
|
| REC6
|
N |
12 |
3 |
|
| REQ1
|
N |
12 |
3 |
|
| REQ2
|
N |
12 |
3 |
|
| REQ3
|
N |
12 |
3 |
|
| REQ4
|
N |
12 |
3 |
|
| REQ5
|
N |
12 |
3 |
|
| REQ6
|
N |
12 |
3 |
|
| SEQ
|
C |
4 |
0 |
|
| SIGNATURE
|
N |
2 |
0 |
|
| STKCODE
|
C |
1 |
0 |
|
| SUPPLIER
|
C |
6 |
0 |
|
| TAXCODE
|
C |
1 |
0 |
|
| UNITMS
|
C |
2 |
0 |
|
| VPARTNO
|
C |
15 |
0 |
|
| WEIGHT
|
N |
12 |
4 |
|
| WIP
|
N |
12 |
3 |
|
| YTDQTY
|
N |
12 |
3 |
|
| YTDSLS
|
N |
12 |
2 |
|
| |
|
|
ARMIMPnn.DBF
AR External
Posting File
Tags:
ARMIMP
Key: artype + custno + invno
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ARTYPE
|
C |
1 |
0 |
Type
of Invoice C= credit memo F = finance charge blank for
normal invoices. Mandatory Field |
| COMMID
|
C |
6 |
0 |
Comment
ID |
| CUSTNO
|
C |
6 |
0 |
Customer
Number - Mandatory |
| ERRORMES
|
C |
25 |
0 |
Error
Message |
| FOB
|
C |
12 |
0 |
FOB |
| INVDTE
|
C |
8 |
0 |
Invoice
Date |
| INVNO
|
C |
8 |
0 |
Leave
blank to put all of one customer's together |
| ITEM
|
C |
15 |
0 |
Item
Number - Field Mandatory |
| ORDATE
|
C |
8 |
0 |
Order
Date |
| ORNUM
|
C |
8 |
0 |
Order
Number |
| QTYORD
|
N |
12 |
3 |
Quantity
Ordered - Field mandatory |
| QTYSHP
|
N |
12 |
3 |
Quantity
Shipped - Field Mandatory |
| SHIPVIA
|
C |
12 |
0 |
Ship
Via |
| |
|
|
SOMIMPnn.DBF
Sales
Order Import File
Tags:
SOTYPE
Key: sotype + custno + sono
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| COMMID
|
C |
6 |
0 |
Comment
ID |
| CUSTNO
|
C |
6 |
0 |
Customer
Number - Mandatory |
| ERRORMES
|
C |
25 |
0 |
Error
Message |
| FOB
|
C |
12 |
0 |
FOB |
| ITEM
|
C |
15 |
0 |
Item
Number - Field Mandatory |
| ORDATE
|
C |
8 |
0 |
Order
Date |
| ORNUM
|
C |
8 |
0 |
Order
Number |
| QTYORD
|
N |
12 |
3 |
Quantity
Ordered - Field mandatory |
| QTYSHP
|
N |
12 |
3 |
Quantity
Shipped - Field Mandatory |
| SHIPVIA
|
C |
12 |
0 |
Ship
Via |
| SODATE
|
C |
8 |
0 |
Sales
Order Date |
| SONO
|
C |
8 |
0 |
Sales
Order Number if pre-defined |
| SOTYPE
|
C |
1 |
0 |
Type
of Order ( B = Bid ) blank for normal invoices. Mandatory
Field |
| |
|
|
|
