|
The following programs and forms have either been changed
or added:
| TYPE |
FILE NAME |
DESCRIPTION |
| MENUS |
|
|
| |
ARMAIN.MPR |
AR Main Menu |
| |
POMAIN.MPR |
PO Menu Display |
| |
SOMAIN.MPR |
Sales Main Menu |
| PROGRAMS |
|
|
| |
ARCREA.PRG |
Set Up File Variables and Delete/Check Data Files |
| |
ARMANV.PRG |
Void Invoice/Credit Memo |
| |
ARMENU.PRG |
Main Menu |
| |
ARPOSD.PRG |
Enter Invoice Detail |
| |
ARPOSE.PRG |
Revise Current Invoice/Credit Memo |
| |
ARPOST.PRG |
Create Invoice |
| |
ARPSTM.PRG |
Print Invoice & Credit Memo |
| |
ARSYST.PRG |
System Maintenance |
| |
BAUPDATE.PRG |
Update Browse Assist |
| |
POCREA.PRG |
Create/Check/Delete Data Files |
| |
POMAND.PRG |
Edit PO Detail Lines |
| |
POMENU.PRG |
Main Menu |
| |
POPOSD.PRG |
Enter PO Detail |
| |
PORCPE.PRG |
Recurring PO Processing |
| |
POSNRC.PRG |
Entry of serial numbers for PO receipts |
| |
SMCREA.PRG |
System Manager Creation Program |
| |
SMDTBL.PRG |
System Manager table maintenance |
| |
SMKPMN.PRG |
Program to set up the keys for processing |
| |
SMKPOC.PRG |
Processes the key changes |
| |
SNUPDATE.PRG |
Update prior files on installation |
| |
SNUPDATE.PRG |
One time update of inventory file |
| |
SOCREA.PRG |
Set Up Files Varibles and Create/Delete/Check Data Files |
| |
SOMAND.PRG |
Edit SO Detail Lines |
| |
SOMENU.PRG |
Main Menu |
| |
SOPOSD.PRG |
Enter SO Detail |
| |
SOPOSE.PRG |
Revise Current SO |
| |
SOPOST.PRG |
Create Sales Order |
| |
SOSHPE.PRG |
Enter Shipment Detail |
| |
SOSHPP.PRG |
Sales Order Shipping |
| |
SYSBCAL.PRG |
Recalculate File Balances |
| |
SYSIADD.PRG |
Add Inventory Item |
| |
SYSIADJ.PRG |
Inventory Adjustment |
| |
SYSINVT.PRG |
Maintain Inventory Record |
| |
SYSIRPT.PRG |
Inventory Item reports |
| |
SYSISRN.PRG |
Inventory Maintenance Screen |
| |
SYSSSRN.PRG |
Serial Number Screen |
| |
TOBOX.PRG |
Draws a Box on the Screen |
| |
TOCRE1.PRG |
Create Databases for a module |
| |
TOCREA.PRG |
Set Up Files Varibles and Create/Delete/Check Data Files |
| |
TODBCK.PRG |
Build/Update Fields for Database Files |
| |
TOFLOC.PRG |
Locate Directory Placement of Files |
| |
TOIMOR.PRG |
Additional Choices for Inventory |
| |
TOINST.PRG |
Install Dictionary |
| |
TOIOHRP.PRG |
Inventory on hand report with serial numbers |
| |
TOISSU.PRG |
Issue serial numbers |
| |
TOLIST.PRG |
List and Select Based on Data Dictionary |
| |
TOMNB9.PRG |
Menu Programs |
| |
TOMNU9.PRG |
Menu Programs |
| |
TOMSELT.PRG |
Seletion routine |
| |
TORECAP.PRG |
Apply received serial numbers to outstanding records |
| |
TORECP.PRG |
Receive Serial Number Items |
| |
TOSELNK.PRG |
Serial Number Categories Report |
| |
TOSERMT.PRG |
Serial Number Management |
| |
TOSERRP.PRG |
Serial Number reports |
| |
TOSESAL.PRG |
Serial Number Sales Report |
| |
TOSMKP.PRG |
Sets up the key field databases with dictionaries |
| |
TOSNAL.PRG |
Serial Number updates |
| |
TOSNRC.PRG |
Update serial numbers after receipt or sale |
| |
TOSNTUP.PRG |
Serial Number Updates |
| |
TOSNUP.PRG |
Serial Number Updates |
| |
TOSYST.PRG |
Tool Setup Maintenance |
| |
TOTGPK.PRG |
Select tagged records |
| |
|
|
Database Changes
ARINVTnn.DBF
Inventory Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| NEXTSER |
C |
25 |
0 |
Next Serial Number (if serialized & sequential) |
| SNSEQ |
C |
1 |
0 |
Sequential Serial Numbers |
| SNUSED |
C |
1 |
0 |
Serialized Item? (Y/N) |
| |
|
|
ARITRNnn.DBF
Inventory Transfer File
Tags:
TRANSNO Key: transno
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| TRANSNO |
C |
8 |
0 |
Transaction Number for reference |
| |
|
|
ARSERNnn.DBF
Serial Number File
Tags:
CUSTINV Key: custno + invno + item + serial
CUSTNOI Key: custno + item + serial
CUSTNOS Key: custno + serial + item
INVNO Key: invno + STR(invline,3,0) + serial
ITEM Key: item + serial
LINKCUS Key: linkcode + custno + invno + serial
LINKSER Key: linkcode + serial
PURNO Key: purno + STR(poline,3,0) + serial
SERIAL Key: serial
SONO Key: sono + STR(soline,3,0) + serial
STATUS Key: item + status + serial
USER Key: user + item + serial
VENDNOI Key: vendno + item + serial
VENDNOS Key: vendno + serial + item
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| COST |
N |
12 |
3 |
Actual cost of this item |
| CUSTNO |
C |
6 |
0 |
Customer Number sold to |
| DATEADD |
D |
8 |
0 |
Date added to the file |
| DATEINV |
D |
8 |
0 |
Date Invoiced |
| DATEORD |
D |
8 |
0 |
Date Ordered |
| DATERECV |
D |
8 |
0 |
Date received into stock |
| DATEREG |
D |
8 |
0 |
Date Registered |
| DATESOLD |
D |
8 |
0 |
Date Sold |
| DESC |
C |
35 |
0 |
Additional description |
| EXPIRES |
D |
8 |
0 |
Expiration Date |
| INVLINE |
N |
3 |
0 |
Line Number on Invoice |
| INVNO |
C |
8 |
0 |
Invoice Number |
| ITEM |
C |
15 |
0 |
Item Number |
| KITNO |
C |
8 |
0 |
Kit Number it belongs to if applicable |
| LASTUP |
D |
8 |
0 |
Date Last updated |
| LINKCODE |
C |
3 |
0 |
Link code for inventory valuation |
| LOCATION |
C |
12 |
0 |
Bin or Other Location |
| LOT |
C |
12 |
0 |
Lot Number |
| MFG |
C |
6 |
0 |
Manufacturer |
| MFGNO |
C |
15 |
0 |
Manufacturer Number for the item |
| NOTES |
C |
40 |
0 |
Notes |
| PARENT |
C |
15 |
0 |
Parent Item number if applicable (Included in another
item or kit) |
| PARSER |
C |
25 |
0 |
Parent Serial Number if appropriate (Included in another
item with a serial number) |
| POLINE |
N |
3 |
0 |
Line Number on the PO |
| PRICE |
N |
12 |
2 |
Price sold for |
| PRINTED |
C |
1 |
0 |
Label is printed (Y/N) |
| PURNO |
C |
8 |
0 |
Purchase Order purchased on |
| QTY |
N |
10 |
0 |
Quantity not yet accounted for (no serial numbers) |
| SCRATCH |
N |
12 |
0 |
For computations |
| SELECTED |
L |
1 |
0 |
For transaction use |
| SEQUEN |
C |
1 |
0 |
Sequentially numbered |
| SERIAL |
C |
25 |
0 |
Serial Number |
| SITE |
C |
6 |
0 |
Site where located |
| SOLINE |
N |
3 |
0 |
Line Number on Sales Order |
| SONO |
C |
8 |
0 |
Sales Order Number if allocated |
| STATUS |
C |
1 |
0 |
Serial Number Status A=Available H=Hold S=Sold V=Voided
D=Designated to an order or invoice |
| TRANSNO |
C |
8 |
0 |
Transaction Number for reference |
| UNITMS |
C |
2 |
0 |
Unit of Measure |
| USER |
C |
6 |
0 |
User Customer Number registered to |
| USERID |
C |
10 |
0 |
User who updated |
| VENDNO |
C |
6 |
0 |
Vendor Purchased from |
| VPARTNO |
C |
15 |
0 |
Vendor Part Number |
| |
|
|
ARTRANnn.DBF
Invoice Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Invoice (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
ARYTRNnn.DBF
Year-to-Date Invoice Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Invoice (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
POMASTnn.DBF
Purchase Order Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| NXTLINE |
N |
3 |
0 |
Next Line Number for the Purchase Order |
| |
|
|
PORECPnn.DBF
Purchase Order Receipt File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| POLINE |
N |
3 |
0 |
Line Number on the PO |
| |
|
|
POTRANnn.DBF
Purchase Order Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Order (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
POYTRNnn.DBF
Year-to-Date Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Order (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
SOMASTnn.DBF
Sales Order Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| NXTLINE |
N |
3 |
0 |
Next Line Number for the Sales Order |
| |
|
|
SOTRANnn.DBF
Sales Order Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Invoice (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
SOYTRNnn.DBF
Year-to-Date Transaction File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| LINENO |
N |
3 |
0 |
Line Number on Invoice (May not be sequential) |
| LNSTAT |
C |
1 |
0 |
Line Status: * = Additional Description entered + =
Item includes additional descriptions |
| |
|
|
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 |
| |
|
|
SYSTOMnn.DBF
Extension Menu Selections for Vision Point
Tags:
MODULE Key: module + prgid
SEQ Key: module + STR(seq,3,0) + prgid
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| COND |
L |
1 |
0 |
|
| MENUID |
C |
1 |
0 |
|
| MODULE |
C |
2 |
0 |
|
| PRGAR |
C |
40 |
0 |
|
| PRGID |
C |
8 |
0 |
|
| REPBOTT |
N |
5 |
0 |
|
| REPDISP |
C |
1 |
0 |
|
| SEQ |
N |
3 |
0 |
|
| TITLE |
C |
30 |
0 |
|
| |
|
|
SYSTOSnn.DBF
Extension Reports Options Grids
Tags:
MODULE Key: module + prgid + STR(repseq,3,0)
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| MODULE |
C |
2 |
0 |
|
| PRGID |
C |
8 |
0 |
|
| REPCHOICE |
C |
34 |
0 |
|
| REPCOND |
C |
100 |
0 |
|
| REPDEF |
C |
40 |
0 |
|
| REPOPT |
C |
17 |
0 |
|
| REPPIC |
C |
17 |
0 |
|
| REPREAD |
L |
1 |
0 |
|
| REPSEQ |
N |
3 |
0 |
|
| REPTYPE |
C |
1 |
0 |
|
| REPVAL |
C |
10 |
0 |
|
| REPVALDT |
C |
200 |
0 |
|
| REPVERR |
C |
78 |
0 |
|
| |
|
|
|
