Location Table

The Location Table (Location_tb) contains a record for every location table in the Sterling Gentran:Server® system.

Location tables in Sterling Gentran:Server enable you to insert names and addresses into outbound data. Partner Editor creates a record in the Location Table each time a location table is created in Partner Editor. Each time a location table is changed, Partner Editor updates the corresponding record in the Location Table. Partner Editor deletes a record from the Location Table when the corresponding location table is deleted in Partner Editor.

Table 1. Location Table field information
Field Name	Type	Size	Use
PartnerKEY	string	25	Unique identifier for the partner to which the location table belongs.
Name	string	255	Name of the partner location.
PrimaryReference Code	string	255	Primary reference code that the system uses to identify this location.
SecondaryReference Code	string	255	Secondary reference code that the system uses to identify this location.
Address1	string	35	First line of the address.
Address2	string	35	Second line of the address.
Address3	string	35	Third line of the address.
City	string	20	City for this location.
State	string	10	State for this location.
Zip	string	10	Country code for this location.
Country	string	10	Zip or postal code for this location.
ContactName	string	35	Name of a personal contact at this partner's office.
Telephone	string	20	Telephone number.
Fax	string	20	Fax number.