|
The following programs
and forms have either been changed or added:
| TYPE |
FILE NAME |
DESCRIPTION |
| MENUS |
|
|
| |
SOMAIN.MPR |
Sales Main Menu |
| PROGRAMS |
|
|
| |
APMENU.PRG |
Main Menu for Accounts Payable |
| |
ARCREA.PRG |
Set Up File Variables and Delete/Check Data Files |
| |
ARSYST.PRG |
AR Setup Information Menu |
| |
GLMENU.PRG |
Main Menu for GL |
| |
MAMENU.PRG |
Main Menu for MA |
| |
POMENU.PRG |
Main Menu |
| |
PRMENU.PRG |
Payroll Menu |
| |
SMMENU.PRG |
Main Menu for SM |
| |
SOCREA.PRG |
Set Up Files Varibles and Create/Delete/Check Data Files |
| |
SOMANE.PRG |
Edit SO Header |
| |
SOMANT.PRG |
Edit SO Detail |
| |
SOMENU.PRG |
Main Menu |
| |
SOPOST.PRG |
Create Sales Order |
| |
SOSYST.PRG |
Update System Information |
| |
SYSCADD.PRG |
Add a new Customer |
| |
SYSCDSP.PRG |
Display Customer Record |
| |
SYSCSRN.PRG |
Customer Maintenance Screen |
| |
SYSCSSE.PRG |
Customer Address Maintenance |
| |
SYSCUST.PRG |
Customer Maintenance |
| |
SYSTBLE.PRG |
Lookup Table Maintenance |
| |
SYSTBLV.PRG |
System Table |
| |
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 |
| |
TOINST.PRG |
Install Dictionary |
| |
TOLIST.PRG |
List and Select Based on Data Dictionary |
| |
TOMNB9.PRG |
Menu Program |
| |
TOMNU9.PRG |
Menu Program |
| |
TOSYST.PRG |
Setup Information |
| |
TOUPOL.PRG |
Update UPS Online database |
| |
TOUPSTAT.PRG |
Shipment Status Information |
| |
UOUPDATE.PRG |
One time Update of the AF related files |
| |
|
|
Database Changes
ARADDRnn.DBF
Address File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| CITY |
C |
20 |
0 |
City Shipping to |
| CNTRYBL |
C |
6 |
0 |
Zone for out of continental US Expedited/2nd Day |
| CNTRYRD |
C |
6 |
0 |
Zone for out of continental US Express/Next Day |
| COUNTRY |
C |
15 |
0 |
Country Shipping to |
| STATE |
C |
2 |
0 |
State of Shipment |
| ZIP |
C |
10 |
0 |
Zip Code of Shipment |
| |
|
|
ARCUSTnn.DBF
Customer Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| CNTRYBL |
C |
6 |
0 |
Zone for out of continental US Expedited/2nd Day |
| CNTRYRD |
C |
6 |
0 |
Zone for out of continental US Express/Next Day |
| DEFFOB |
C |
12 |
0 |
Default FOB Location |
| DEFSHIP |
C |
6 |
0 |
Default Shipping Address |
| DEFSHVIA |
C |
12 |
0 |
Default Ship Via Code |
| |
|
|
ARMASTnn.DBF
Current Invoice Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| UPINFO |
C |
20 |
0 |
UPS Shipping Information |
| |
|
|
SOADDRnn.DBF
Ship To Address File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| CITY |
C |
20 |
0 |
City to ship to |
| CNTRYBL |
C |
6 |
0 |
Zone for out of continental US Expedited/2nd Day |
| CNTRYRD |
C |
6 |
0 |
Zone for out of continental US Express/Next Day |
| COUNTRY |
C |
15 |
0 |
Country to ship to |
| STATE |
C |
2 |
0 |
State to ship to |
| ZIP |
C |
10 |
0 |
Zip Code Shipping to |
| |
|
|
SOMASTnn.DBF
Sales Order Master File
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ACTARRV |
D |
8 |
0 |
Actual Arrival Date |
| ACTSHIP |
D |
8 |
0 |
Actual Ship Date |
| ARRDATE |
D |
8 |
0 |
Expected Arrival Date |
| SERVICE |
C |
6 |
0 |
UPS Service Level 1-16 UPS = Pkg_Service_Type |
| SHIPCOST |
N |
10 |
2 |
Shipping Cost |
| SHIPNO |
C |
6 |
0 |
Different Ship To Address |
| SHIPWGHT |
N |
8 |
2 |
Shipping Weight of the order |
| SIGNED |
C |
30 |
0 |
Who signed for the shipment |
| TRACKNO |
C |
30 |
0 |
Tracking Number UPS = NULL |
| UPINFO |
C |
20 |
0 |
UPS Shipping Information |
| |
|
|
SYSONLnn.DBF
UPS Online Data - not yet transferred
Tags:
SONO Key: sono
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| ADDRESS1 |
C |
35 |
0 |
Address Line 1 - UPS= Shipto_address_1 |
| ADDRESS2 |
C |
35 |
0 |
Address Line 2 UPS = Shipto_Address_2 |
| CITY |
C |
30 |
0 |
City UPS = Shipto_City |
| COMPANY |
C |
35 |
0 |
Company - UPS = Shipto_Name |
| COUNTRY |
C |
3 |
0 |
Country - UPS = Shipto_Country_ID |
| INVNO |
C |
8 |
0 |
Invoice Number - UPS = NULL |
| ORDERID |
C |
10 |
0 |
Order ID = Company# + Sales Order Number UPS = Pkg_Package_ID |
| SERVICE |
C |
6 |
0 |
UPS Service Level 1-16 UPS = Pkg_Service_Type |
| SONO |
C |
8 |
0 |
Sales Order Number - UPS = NULL |
| SOURCE |
C |
3 |
0 |
Source (For UPS Use - Always UOL) UPS = Uol Source |
| STATE |
C |
5 |
0 |
State UPS = Shipto_State_Prov |
| TRACKNO |
C |
30 |
0 |
Tracking Number UPS = NULL |
| VALUE |
N |
10 |
2 |
Declared Value - UPS = Pkg_Decl_Value_Ins |
| WEIGHT |
N |
10 |
0 |
Weight of Package - UPS = Pkg_Weight_Actual |
| ZIP |
C |
5 |
0 |
Zip Code UPS = Shipto_Postal_Code |
| |
|
|
SYSTABLnn.DBF
System Validation Table
Tags:
| Name |
TYPE |
WID |
DEC |
DESCRIPTION |
| TBLTYPE |
C |
15 |
0 |
Table Type for Credit card and other term setups |
| |
|
|
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 |
|
| |
|
|
|