|
The following programs and forms have either been changed
or added:
| TYPE |
FILE NAME |
DESCRIPTION |
| FORMS |
|
|
| |
ICATTRC.* |
|
| |
ICATTSI.* |
|
| |
ICSITOH.* |
On Hand By Site |
| |
ICSITSI.* |
Listing of Sales and Issues |
| MENUS |
|
|
| |
ARMAIN.MPR |
AR Main Menu |
| |
POMAIN.MPR |
PO Main Menu |
| |
SOMAIN.MPR |
Sales Main Menu |
| PROGRAMS |
|
|
| |
ARCREA.PRG |
Set Up File Variables and Delete/Check Data Files |
| |
ARICUPD.PRG |
Reverse Invoice information when cancelled |
| |
ARMENU.PRG |
Main Menu |
| |
ARPCLS.PRG |
Period Closing |
| |
ARPOSD.PRG |
Enter Invoice Detail |
| |
ARPOSE.PRG |
Edit Invoice Detail |
| |
ARPOST.PRG |
Create Invoice |
| |
ARPSTM.PRG |
Print Invoice & Credit Memo |
| |
ARPSTMD.PRG |
Print Detailed Invoice Information |
| |
ARPSTMM.PRG |
Invoice Printing for All |
| |
BAUPDATE.PRG |
Update program for BA |
| |
ICATED.PRG |
Edit Detailed Attribute Information |
| |
ICATTOH.PRG |
|
| |
ICATTR.PRG |
Attribute Entry |
| |
ICATUP.PRG |
Update the Detailed Inventory Information |
| |
ICAUTO.PRG |
Update additional fields |
| |
ICISSU.PRG |
Issue items with attributes |
| |
ICMNTV.PRG |
Void detailed postings |
| |
ICPCLS.PRG |
Close out Attribute Files |
| |
ICRECP.PRG |
Receive items with attributes |
| |
ICSADD.PRG |
Add new sites |
| |
ICSDSP.PRG |
Display site information |
| |
ICSITE.PRG |
Site Maintenance |
| |
ICSITRC.PRG |
Receipts By Site |
| |
ICSSRN.PRG |
Display and update site information |
| |
ICTRAN.PRG |
Transaction Processing for Inventory Attributes |
| |
ICUPDATE.PRG |
Update existing databases |
| |
POCREA.PRG |
Create/Check/Delete Data Files |
| |
POMENU.PRG |
Main Menu |
| |
PORCPE.PRG |
Detailed PO Processing |
| |
PORECP.PRG |
Purchase Order Receipt Entries |
| |
SMCREA.PRG |
System Manager Creation Program |
| |
SMDTBL.PRG |
|
| |
SMKPMN.PRG |
Program to set up the keys for processing |
| |
SMKPOC.PRG |
Processes the key changes |
| |
SOCREA.PRG |
Set Up Files Varibles and Create/Delete/Check Data Files |
| |
SOICUPD.PRG |
Reverse or complete sales order shipment updates |
| |
SOMENU.PRG |
Main Menu |
| |
SOPSTM.PRG |
Sales Order Header Printing |
| |
SOSHIP.PRG |
Enter Shipment |
| |
SOSHPE.PRG |
Enter Shipment Detail |
| |
SOSHPP.PRG |
Shipment Processing |
| |
SYSIADD.PRG |
Add Inventory Item |
| |
SYSIADJ.PRG |
Inventory Adjustment |
| |
SYSINVT.PRG |
Maintain Inventory Record |
| |
SYSISRN.PRG |
Inventory Maintenance Screen |
| |
T0CHKL.PRG |
Count Matching Lines for Printout purposes |
| |
T0LSTL.PRG |
List Detailed Attribute Breakdown |
| |
TOBOX.PRG |
Draws a Box on the Screen |
| |
TOCRE1.PRG |
File Creation Program |
| |
TOCREA.PRG |
Create/Delete/Check Data Files From Data Dictionary |
| |
TODBCK.PRG |
Build/Update Fields for Database Files |
| |
TOFLOC.PRG |
Locate Directory Placement of Files |
| |
TOIADD.PRG |
Inventory Add Program |
| |
TOIDLT.PRG |
Delete Inventory Item |
| |
TOIMOR.PRG |
Additional Choices for Inventory |
| |
TOINST.PRG |
Install Dictionary |
| |
TOIRCL.PRG |
Vendor Inquiry Reports |
| |
TOLIST.PRG |
List for Selection |
| |
TOMNB9.PRG |
|
| |
TOMNU9.PRG |
|
| |
TOSMKP.PRG |
Sets up the key field databases with dictionaries |
| |
TOTGPK.PRG |
|
| |
|
|
Database Changes
ARINVTnn.DBF
Inventory Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ATTRIB |
C |
10 |
0 |
Attribute Indicator Pos 1 = Sites 2 = Locations .t. |
| |
|
|
ARTRANnn.DBF
Invoice Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Invoice May not be consecutive .t. |
| |
|
|
ARYTRNnn.DBF
Year-to-Date Invoice Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Invoice May not be consecutive .t. |
| |
|
|
ICCMNTnn.DBF
Inventory Control - Attribute Detail
Tags:
ATTRIB1 Key: attrib1 + attrib2 + attrib3
IATTRIB1 Key: item + attrib1 + attrib2 + attrib3
IATTRIB2 Key: item + attrib2 + attrib3 + attrib1
IATTRIB3 Key: item + attrib3 + attrib1 + attrib2
ICNO Key: icno
ITEM Key: item
ITEMLOC Key:
ITEMSIT Key: item + site + location
LOCATION Key: location + item
SITE Key: site + item
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ATTRIB1 |
C |
6 |
0 |
Site !!!!!! l_sitechk |
| ATTRIB2 |
C |
12 |
0 |
Location !!!!!!!!!!!! l_locchk |
| ATTRIB3 |
C |
12 |
0 |
Lot !!!!!!!!!!!! l_lotchk |
| ATTRIB4 |
C |
1 |
0 |
.t. |
| ATTRIB5 |
C |
1 |
0 |
.t. |
| ATTRIB6 |
C |
1 |
0 |
.t. |
| ATTRIB7 |
C |
1 |
0 |
.t. |
| ATTRIB8 |
C |
1 |
0 |
.t. |
| ATTRIB9 |
C |
1 |
0 |
.t. |
| COST |
N |
12 |
3 |
Cost #######.### .t. |
| DATEADD |
D |
8 |
0 |
Date Added to Inventory .t. |
| EXPIRES |
D |
8 |
0 |
Expiration Date (Blank for None) .t. |
| ICNO |
C |
10 |
0 |
Unique Number Assigned to this record .t. |
| ITEM |
C |
15 |
0 |
Item Number .t. |
| LOCATION |
C |
10 |
0 |
Location of Item within site .t. |
| LOT |
C |
12 |
0 |
Lot Number Assigned .t. |
| MFGNO |
C |
6 |
0 |
Manufacturer Code (Corresponds to MFG database) .t. |
| PRICE |
N |
12 |
2 |
Price when sold |
| QTYAL |
N |
12 |
3 |
Quantity Allocated (Not currently used) .t. |
| QTYOH |
N |
12 |
3 |
Quantity On Hand .t. |
| QTYOO |
N |
12 |
3 |
Quantity On Order (Not currently used) .t. |
| SERNO |
C |
15 |
0 |
Serial Number Assigned .t. |
| SITE |
C |
6 |
0 |
Site Where Located .t. |
| |
|
|
ICCTRNnn.DBF
Detailed Transaction File
Tags:
CUSTNO Key: custno + item
IATTRIB1 Key: item + attrib1 + attrib2 + attrib3
ICNO Key: icno
INVNO Key: invno + STR(lineno,3,0)
ITEM Key: item
ITEMLOC Key: item + location
ITEMSL Key: item + site + location
PURNO Key: purno + STR(lineno,3,0)
SONO Key: sono + STR(lineno,3,0)
TYPETRAN Key: typetran
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ATTRIB1 |
C |
6 |
0 |
Site !!!!!! l_sitechk |
| ATTRIB2 |
C |
12 |
0 |
Location !!!!!!!!!!!! l_locchk |
| ATTRIB3 |
C |
12 |
0 |
Lot !!!!!!!!!!!! .t. |
| ATTRIB4 |
C |
1 |
0 |
.t. |
| ATTRIB5 |
C |
1 |
0 |
.t. |
| ATTRIB6 |
C |
1 |
0 |
.t. |
| ATTRIB7 |
C |
1 |
0 |
.t. |
| ATTRIB8 |
C |
1 |
0 |
.t. |
| ATTRIB9 |
C |
1 |
0 |
.t. |
| CUSTNO |
C |
6 |
0 |
Customer Number .t. |
| DATEADD |
D |
8 |
0 |
Date Added .t. |
| EXPIRES |
D |
8 |
0 |
Expiration Date .t. |
| ICNO |
C |
10 |
0 |
Unique ID for this record .t. |
| INVNO |
C |
8 |
0 |
Invoice Number .t. |
| ITEM |
C |
15 |
0 |
Item Number .t. |
| LINENO |
N |
4 |
0 |
Line Number on Invoice May not be consecutive .t. |
| LOCATION |
C |
10 |
0 |
Bin Location .t. |
| LOT |
C |
12 |
0 |
Lot Number .t. |
| MFGNO |
C |
6 |
0 |
Manufacturer Number .t. |
| PURNO |
C |
8 |
0 |
Purchase Order Number .t. |
| QTYAL |
N |
12 |
3 |
Quantity Allocated (Not currently used) .t. |
| QTYOH |
N |
12 |
3 |
Quantity On Hand .t. |
| QTYOO |
N |
12 |
3 |
Quantity on order (not currently used) .t. |
| SERNO |
C |
15 |
0 |
Serial Number .t. |
| SITE |
C |
6 |
0 |
Site .t. |
| SONO |
C |
8 |
0 |
Sales Order Number .t. |
| SOURCE |
C |
2 |
0 |
Program transaction originated from .t. |
| TRANQTY |
N |
12 |
3 |
Transaction Quantity .t. |
| TYPETRAN |
C |
1 |
0 |
Type of Transaction .t. |
| VENDNO |
C |
6 |
0 |
Vendor Number .t. |
| |
|
|
ICSITEnn.DBF
Inventory Sites (Warehouses, Stores etc..)
Tags:
SITE Key: site
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ADDRESS1 |
C |
30 |
0 |
Address Line 1 .t. |
| ADDRESS2 |
C |
30 |
0 |
Address Line 2 .t. |
| CITY |
C |
20 |
0 |
City .t. |
| COMMENT |
C |
65 |
0 |
.t. |
| CONTACT |
C |
20 |
0 |
Point of Contact .t. |
| COUNTRY |
C |
15 |
0 |
Country .t. |
| DATEADD |
D |
8 |
0 |
Date Added to File .t. |
| FAXNO |
C |
20 |
0 |
Fax Number .t. |
| PHONE |
C |
20 |
0 |
Phone Number .t. |
| SIGNATURE |
N |
2 |
0 |
.t. |
| SITE |
C |
6 |
0 |
Site Where Located .t. |
| SITENAME |
C |
35 |
0 |
Site Name .t. |
| STATE |
C |
2 |
0 |
State .t. |
| TITLE |
C |
20 |
0 |
Contact Title .t. |
| ZIP |
C |
10 |
0 |
Zip Code .t. |
| |
|
|
ICYMNTnn.DBF
History Inventory Control Detail
Tags:
ATTRIB1 Key: attrib1 + attrib2 + attrib3
IATTRIB1 Key: item + attrib1 + attrib2 + attrib3
IATTRIB2 Key: item + attrib2 + attrib3 + attrib1
IATTRIB3 Key: item + attrib3 + attrib1 + attrib2
ICNO Key: icno
ITEM Key: item
ITEMLOC Key:
ITEMSIT Key: item + site + location
LOCATION Key: location + item
SITE Key: site + item
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ATTRIB1 |
C |
6 |
0 |
Site !!!!!! l_sitechk |
| ATTRIB2 |
C |
12 |
0 |
Location !!!!!!!!!!!! l_locchk |
| ATTRIB3 |
C |
12 |
0 |
Lot !!!!!!!!!!!! .t. |
| ATTRIB4 |
C |
1 |
0 |
.t. |
| ATTRIB5 |
C |
1 |
0 |
.t. |
| ATTRIB6 |
C |
1 |
0 |
.t. |
| ATTRIB7 |
C |
1 |
0 |
.t. |
| ATTRIB8 |
C |
1 |
0 |
.t. |
| ATTRIB9 |
C |
1 |
0 |
.t. |
| DATEADD |
D |
8 |
0 |
Date Added to Inventory .t. |
| EXPIRES |
D |
8 |
0 |
Expiration Date (Blank for None) .t. |
| ICNO |
C |
10 |
0 |
Unique Number Assigned to this record .t. |
| ITEM |
C |
15 |
0 |
Item Number .t. |
| LOCATION |
C |
10 |
0 |
Location of Item within site .t. |
| LOT |
C |
12 |
0 |
Lot Number Assigned .t. |
| MFGNO |
C |
6 |
0 |
Manufacturer Code (Corresponds to MFG database) .t. |
| QTYAL |
N |
12 |
3 |
Quantity Allocated .t. |
| QTYOH |
N |
12 |
3 |
Quantity On Hand .t. |
| QTYOO |
N |
12 |
3 |
Quantity On Order .t. |
| SERNO |
C |
15 |
0 |
Serial Number Assigned .t. |
| SITE |
C |
6 |
0 |
Site Where Located .t. |
| |
|
|
ICYTRNnn.DBF
History Detailed Transaction File
Tags:
CUSTNO Key: custno + item
IATTRIB1 Key: item + attrib1 + attrib2 + attrib3
ICNO Key: icno
INVNO Key: invno + STR(lineno,3,0)
ITEM Key: item
ITEMLOC Key: item + location
ITEMSL Key: item + site + location
PURNO Key: purno + STR(lineno,3,0)
SONO Key: sono + STR(lineno,3,0)
TYPETRAN Key: typetran
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ATTRIB1 |
C |
6 |
0 |
Site !!!!!! l_sitechk |
| ATTRIB2 |
C |
12 |
0 |
Location !!!!!!!!!!!! l_locchk |
| ATTRIB3 |
C |
12 |
0 |
Lot !!!!!!!!!!!! .t. |
| ATTRIB4 |
C |
1 |
0 |
.t. |
| ATTRIB5 |
C |
1 |
0 |
.t. |
| ATTRIB6 |
C |
1 |
0 |
.t. |
| ATTRIB7 |
C |
1 |
0 |
.t. |
| ATTRIB8 |
C |
1 |
0 |
.t. |
| ATTRIB9 |
C |
1 |
0 |
.t. |
| CUSTNO |
C |
6 |
0 |
Customer Number .t. |
| DATEADD |
D |
8 |
0 |
.t. |
| EXPIRES |
D |
8 |
0 |
.t. |
| ICNO |
C |
10 |
0 |
.t. |
| INVNO |
C |
8 |
0 |
Invoice Number .t. |
| ITEM |
C |
15 |
0 |
.t. |
| LINENO |
N |
4 |
0 |
Line Number on Invoice May not be consecutive .t. |
| LOCATION |
C |
10 |
0 |
.t. |
| LOT |
C |
12 |
0 |
.t. |
| MFGNO |
C |
6 |
0 |
.t. |
| PURNO |
C |
8 |
0 |
Purchase Order Number .t. |
| QTYAL |
N |
12 |
3 |
.t. |
| QTYOH |
N |
12 |
3 |
.t. |
| QTYOO |
N |
12 |
3 |
.t. |
| SERNO |
C |
15 |
0 |
.t. |
| SITE |
C |
6 |
0 |
.t. |
| SONO |
C |
8 |
0 |
Sales Order Number .t. |
| SOURCE |
C |
2 |
0 |
Program transaction originated from .t. |
| TRANQTY |
N |
12 |
3 |
Transaction Quantity .t. |
| TYPETRAN |
C |
1 |
0 |
Type of Transaction .t. |
| VENDNO |
C |
6 |
0 |
Vendor Number .t. |
| |
|
|
POMASTnn.DBF
Purchase Order Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Highest Line Number Used on the Purchase Order .t. |
| |
|
|
POTRANnn.DBF
Purchase Order Transfer File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Purchase Order May not be consecutive
.t. |
| |
|
|
POYTRNnn.DBF
Year-to-Date Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Purchase Order May not be consecutive
.t. |
| |
|
|
SOMASTnn.DBF
Sales Order Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Highest Line Number Used on the Order .t. |
| |
|
|
SOTRANnn.DBF
Sales Order Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Sales Order May not be consecutive .t. |
| |
|
|
SOYTRNnn.DBF
Year-to-Date Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
4 |
0 |
Line Number on Sales Order May not be consecutive .t. |
| |
|
|
SYSPIKnn.DBF
Browse Assistance Database
Tags:
SEQNO Key: tablid + tagnm + STR(seqno)
TABLID Key: tablid + tagnm + fieldname
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| FHEADING |
C |
20 |
0 |
Browse field heading |
| FIELDNAME |
C |
10 |
0 |
Field name to display |
| PICCLS |
C |
30 |
0 |
Picture Clause for the numeric fields |
| SEQNO |
N |
3 |
0 |
Sequence number to display browse |
| TABLID |
C |
8 |
0 |
Database name for the browser |
| TAGNM |
C |
8 |
0 |
Tag name for the order the file is displayed in |
| WFONT |
C |
10 |
0 |
Windows Font |
| WIDTH |
N |
3 |
0 |
Width of field display for Character Fields |
| WSTYLE |
C |
10 |
0 |
Windows Style for the list |
| |
|
|
|
