Integrated Business Solutions - Vision Point Enhancements

Home < Vision Point < UPS Online and ACCPAC Link

Printable Page

Download Page

UPS Online and ACCPAC Link

Back to index

Description

Documentation

Technical

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.

Program and Form Changes:

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

top