Address Table
Id: 1
Label: Alt. address
Security key: BasicTables
Settings shown are initial values.
Note |
|---|
|
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. |
|
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 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 |
Note