Maintain Contents - Example

 

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.