Address Table

Id: 1

Label: Alt. address

Security key: BasicTables

Settings shown are initial values.

NoteNote

At the time of publication, portions of this topic were intentionally left blank. For the most current information, visit Microsoft Dynamics AX Online.


Field

Description

AddrTableId

ID: 1

Type: Integer

Extended data type: RefTableId Extended Data Type

Label: Table ID of the main table

This field is used together with address record ID and line number to form a unique key.

AddrRecId

ID: 2

Type: Int64

Extended data type: RefRecId Extended Data Type

Label: Reference

Reference field in a different table.

LineNum

ID: 3

Type: Real

Extended data type: LineNum Extended Data Type

Label: Line No

Identification of line.

type

ID: 4

Enum: AddressType Enumeration

Label: Address type

Current address type.

Name

ID: 6

Type: String Size: 60

Extended data type: Name Extended Data Type

Label: Name

Name of the current address.

Address

ID: 7

Type: String Size: 250

Extended data type: Addressing Extended Data Type

Configuration key: LedgerBasic

Label: Address

Addressee - Enter address and ZIP/postal Code; the rest will be inserted if the postal code exists in the postal code table.

Phone

ID: 8

Type: String Size: 20

Extended data type: Phone Extended Data Type

Label: Telephone

Phone number for current address.

TeleFax

ID: 9

Type: String Size: 20

Extended data type: TeleFax Extended Data Type

Label: Fax

Fax number for current address

CountryRegionId

ID: 10

Type: String Size: 10

Extended data type: AddressCountryRegionId Extended Data Type

Label: Country/region

Specifies default native country/region in connection with addresses.

ZipCode

ID: 12

Type: String Size: 10

Extended data type: AddressZipCodeId Extended Data Type

Configuration key: LedgerBasic

Label: ZIP/postal Code

Identify ZIP/postal Code district.

State

ID: 13

Type: String Size: 10

Extended data type: AddressStateId Extended Data Type

Label: State

Identification of state.

County

ID: 14

Type: String Size: 10

Extended data type: AddressCountyId Extended Data Type

Label: County

Specifies a county within a state in the current country/region.

Telex

ID: 15

Type: String Size: 20

Extended data type: Telex Extended Data Type

Label: Telex number

Telex number of the current address.

URL

ID: 16

Type: String Size: 255

Extended data type: URL Extended Data Type

Label: WWW address

WWW address for Internet homepage.

PhoneLocal

ID: 17

Type: String Size: 10

Extended data type: PhoneLocal Extended Data Type

Label: Extension

Employee's extension at work.

CellularPhone

ID: 18

Type: String Size: 20

Extended data type: PhoneMobile Extended Data Type

Label: Mobile phone

Mobile phone number.

Email

ID: 19

Type: String Size: 80

Extended data type: Email Extended Data Type

Label: E-mail

Internet e-mail address.

TaxGroup

ID: 20

Type: String Size: 10

Extended data type: TaxGroup Extended Data Type

Configuration key: LedgerBasicSalesTax

Label: Sales tax group

Group of sales tax codes that can be calculated for sale and purchase.

City

ID: 21

Type: String Size: 60

Extended data type: AddressCity Extended Data Type

Configuration key: LedgerBasic

Label: City

City for ZIP/postal Code.

Street

ID: 22

Type: String Size: 250

Extended data type: AddressStreet Extended Data Type

Configuration key: LedgerBasic

Label: Street name

Enter the street name of the address.

Pager

ID: 23

Type: String Size: 20

Extended data type: Pager Extended Data Type

Label: Pager

Number of pager.

SMS

ID: 24

Type: String Size: 80

Extended data type: SMS Extended Data Type

Label: SMS

E-mail address for sending SMS to a mobile phone.

DEL_RefZipCode

ID: 26

Type: Int64

Extended data type: RefRecId Extended Data Type

Configuration key: SysDeletedObjects40

Label: Reference

Reference field in a different table.

SalesCalendarId

ID: 29

Type: String Size: 10

Extended data type: SalesCalendarId Extended Data Type

Configuration key: SalesDeliveryDateControl

Label: Receipt calendar

Days that customers can receive their orders

FRCARAddressing

ID: 30

Type: String Size: 250

Extended data type: Addressing Extended Data Type

Configuration key: SysDeletedObjects40

Label: Address

Addressee - Enter address and ZIP/postal Code; the rest will be inserted if the postal code exists in the postal code table.

Field Group

Fields

Address

Street

ZipCode

City

County

State

CountryRegionId

AddressDisplay

Address

FRCARAddressing

AutoReport

Name

CountryRegionId

Phone

TeleFax

ContactInfo

Phone

PhoneLocal

CellularPhone

Pager

TeleFax

Email

SMS

URL

Telex

Delivery

SalesCalendarId

Description

Name

Identification

AddrTableId

AddrRecId

LineNum

type

SalesTax

TaxGroup

Relation

Lines

CompanyData

Address.AddrRecId==CompanyInfo.RecId

Address.AddrTableId==CompanyInfo.TableId

County

Address.CountryRegionId==AddressCounty.CountryRegionId

Address.State==AddressCounty.StateId

Address.County==AddressCounty.CountyId

CustTable

Address.AddrRecId==CustTable.RecId

Address.AddrTableId==CustTable.TableId

HRMOrganization

Address.AddrTableId==HRMOrganization.TableId

Address.AddrRecId==HRMOrganization.RecId

InventLocation

Address.AddrRecId==InventLocation.RecId

Address.AddrTableId==InventLocation.TableId

ProjTable

Address.AddrRecId==ProjTable.RecId

Address.AddrTableId==ProjTable.TableId

PurchLine

Address.AddrTableId==PurchLine.TableId

SalesLine

Address.AddrTableId==SalesLine.TableId

SalesQuotationLine

Address.AddrTableId==SalesQuotationLine.TableId

SalesQuotationTable

Address.AddrRecId==SalesQuotationTable.RecId

Address.AddrTableId==SalesQuotationTable.TableId

SalesTable

Address.AddrRecId==SalesTable.RecId

Address.AddrTableId==SalesTable.TableId

smmRelationTable

Address.AddrTableId==DEL_smmRelationTable.TableId

Address.AddrRecId==DEL_smmRelationTable.RecId

State

Address.CountryRegionId==AddressState.CountryRegionId

Address.State==AddressState.StateId

VendTable

Address.AddrRecId==VendTable.RecId

Address.AddrTableId==VendTable.TableId

WMSBillOfLading

Address.AddrRecId==WMSBillOfLading.RecId

Address.AddrTableId==WMSBillOfLading.TableId

Index

Fields

AddrIdx

AllowDuplicates: Yes

Enabled: Yes

AddrTableId

AddrRecId

LineNum

TypeIdx

AllowDuplicates: Yes

Enabled: Yes

AddrTableId

AddrRecId

type

RecId

AllowDuplicates: No

Enabled: Yes

RecId

Community Additions

ADD
Show: