|
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 |
| |
|
|
|