|
You want to export a list of customer names and addresses for merging into a standard word processing letter using the Customer Address List program in Debtors Ledger as the startpoint. |
|
You define a row specifying the columns you want to export, based on the fields in the Global AD (Address) record. The row will not contain a column for each field in the AD record because some are internal programming fields, and others are not relevant to your needs; for example you do not want to export the country, because the mailshot is only going out to local customers, and you will select the customers on this basis prior to exporting the data. |
|
The definitions of the fields in the AD (Address) record are shown in Maintain Contents - Example. The definitions of the columns in the row you create are shown Maintain Contents - Example. |
Field Structure of Global AD (Address) Record
Field |
Description |
Type |
Size |
ADSYMN |
"D"ebtors, "C"reditors, blank if company |
Text |
1 |
ADCSCD |
Customer, supplier or company id |
Text |
7 |
ADADDR |
Numerics RJF not 0-filled |
Text |
4 |
ADNAME |
Name |
Text |
30 |
ADADD1 |
Street |
Text |
30 |
ADADD2 |
Suburb |
Text |
30 |
ADADD3 |
State |
Text |
30 |
ADADD4 |
Country |
Text |
30 |
ADPOST |
Post Code |
Text |
10 |
ADCTRY |
Country Code |
Text |
2 |
ADEXTC |
External customer/supplier acc. code |
Text |
20 |
Note
The AD (Address) record is used for supplier and company addresses as well as for customer addresses. The value of the ADSYMN field indicates whether the address belongs to a customer, a supplier or a company. You do not need to be concerned about this however, because only customer addresses are available at the Customer Address List startpoint.
Example Column Structure of Row for Export of Customer Names & Addresses
Column |
Description |
Type |
Size |
Name |
Name |
Text |
30 |
Address1 |
Street |
Text |
30 |
Address2 |
Suburb |
Text |
30 |
Address3 |
State |
Text |
30 |
Postcode |
Post Code |
Text |
10 |
Constants |
You can give fixed values to column, rather than Global data items. These are called 'constants'. The fixed values can be text, a hexadecimal string, spaces or zero. |
Example |
You can use text constants to insert sub-headings into a spreadsheet. An example of this can be seen in the Sample Data in the DL340-A Aged Debt contents list. |