xMsg javascript has not been loaded.
Catalog: Nmbrs
Schema: Company
Label: Company Current Addresses
The data in this table is partitioned per value of the COMPANY_CODE column.
This is a read-only table. The NMBRS API may not support changing the data or the Invantive SQL driver for NMBRS does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NMBRS API.
NMBRS API URL: CompanyService.asmx
Topic: Address_GetCurrent
Base XPath: /soap:Envelope/soap:Body/ncs:Address_GetCurrentResponse
XPath: /ncs:Address_GetCurrentResult
Filters on API Server: CompanyId
Default Namespace Prefix: ncs
The columns of the table CompanyCurrentAddresses are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CITY |
string |
City |
☐ |
|
COMPANY_CODE |
int64 |
Company ID |
☑ |
|
COUNTRYISOCODE |
string |
Country ISO Code |
☐ |
|
DEFAULT |
boolean |
Default |
☐ |
|
HOUSENUMBER |
string |
House Number |
☐ |
|
HOUSENUMBERADDITION |
string |
House Number Addition |
☐ |
|
ID |
int32 |
ID |
☐ |
|
POSTALCODE |
string |
Postal Code |
☐ |
|
STATEPROVINCE |
string |
State/Province |
☐ |
|
STREET |
string |
Street |
☐ |
|
06-04-2021 14:38 Version 20.1.393-BETA+3152