Module List > Module RM tables RM00102
You are currently viewing the COMPANY database.
Change

COMPANY..RM00102 Table Definition

(COMPANY..Customer Master Address File)

The Customer Address Master holds the Primary Address ID as well as additional addresses for the Customer.  The Primary Address ID (and any additional ID’s) from the Customer Card must exist in this table.

Table description:
This table contains the address records for each customer. Users can enter an unlimited number of addresses for each customer. Address records are linked to the customer record with the Customer Number field. In addition, each address has an address ID, used in customer master table windows to specify shipping and billing addresses. The same address ID can't be used twice for the same customer record, but can be used for other customers.

Required fields:
Customer Number
Address Code
Shipping Method
Tax Schedule ID
City
State
Zip
Modified Date


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
UserDefined1

N/A...(more) Join Now
CUSTNMBR char(15)
''
Customer I...(more) Join Now
join ... more text available
ADRSCODE char(15)
''
Address Co...(more) Join Now
SLPRSNID char(15)
''
The salesp...(more) Join Now
join ... more text available
UPSZONE char(3)
''
UPS Zone: ...(more) Join Now
SHIPMTHD char(15)
''
Shipping M...(more) Join Now
join ... more text available
TAXSCHID char(15)
''
Tax Schedu...(more) Join Now
join ... more text available
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now
ADDRESS1 char(61)
''
Address li...(more) Join Now
ADDRESS2 char(61)
''
Address li...(more) Join Now
ADDRESS3 char(61)
''
Address li...(more) Join Now
COUNTRY char(61)
''
Country: C...(more) Join Now
CITY char(35)
''
City: City...(more) Join Now
STATE char(29)
''
4 characte...(more) Join Now
ZIP char(11)
''
ZIP code o...(more) Join Now
PHONE1 char(21)
''
10 digit p...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now
PHONE3 char(21)
''
Phone 3: ...(more) Join Now
FAX char(21)
''
Fax: Same...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CREATDDT datetime
'1/1/1900'
Date this ...(more) Join Now
GPSFOINTEGRATIONID char(31)
''
GPSFO Inte...(more) Join Now
INTEGRATIONSOURCE smallint
0
Integratio...(more) Join Now
INTEGRATIONID char(31)
''
Integratio...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
DECLID char(15)
''
Declarant ...(more) Join Now
LOCNCODE char(11)
''
Location C...(more) Join Now
join ... more text available
SALSTERR char(15)
''
Territory ...(more) Join Now
join ... more text available
USERDEF1 char(21)
''
UserDefine...(more) Join Now
USERDEF2 char(21)
''
User Defin...(more) Join Now
DEX_ROW_TS datetime
(getutcdate())
Time Stamp...(more) Join Now
ShipToName char
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Print_Phone_NumberGB smallint
0
Print_Phon...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3