itgendoc001X
xMsg javascript has not been loaded.
XAA 3.1 Data Model|
CounterPartyPostalAddresses: XAA 3.1 Counter Party Postal Addresses |
Contents Previous Home Next More |
Catalog: XAA
Label: Counter Party Postal Addresses
The data in this table is partitioned per value of the COMPANY_NAME column.
This is a read-only table. The XAA 3.1 API may not support changing the data or the Invantive SQL driver for XAA 3.1 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAA 3.1 API.
Topic: auditfile
Base XPath: /xaa:auditfile/xaa:company/xaa:customersSuppliers/xaa:customerSupplier
XPath: /xaa:postalAddress
Table Columns
The columns of the table CounterPartyPostalAddresses are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
CITY |
string(50) |
City |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_NAME |
string(1000) |
Name |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identity |
☐ |
|
COUNTRY |
string(2) |
Country |
|
|
CUSTOMERSUPPLIER_CONTACT |
string(50) |
Counter Party Contact Person |
|
|
CUSTOMERSUPPLIER_CUSTSUPID |
string(35) |
Counter Party ID |
|
|
CUSTOMERSUPPLIER_EMAIL |
string |
Counter Party Email |
|
|
CUSTOMERSUPPLIER_FAX |
string(30) |
Counter Party Fax |
|
|
CUSTOMERSUPPLIER_TAXREGIDENT |
string(30) |
Counter Party Tax Registration Identity |
|
|
CUSTOMERSUPPLIER_TAXREGISTRATIONCOUNTRY |
string(2) |
Counter Party Tax Registration Country |
|
|
CUSTOMERSUPPLIER_TELEPHONE |
string(30) |
Counter Party Telephone |
|
|
CUSTOMERSUPPLIER_WEBSITE |
string |
Counter Party Website |
|
|
FILE_CURRENCY_CODE |
string(240) |
File Currency Code |
☐ |
|
FILE_DATE_CREATED |
string(240) |
File Creation Date |
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
File End Date |
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
File Start Date |
☐ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
NUMBER |
string(15) |
Number |
|
|
NUMBEREXTENSION |
string(999) |
Number Extension |
|
|
POSTALCODE |
string(10) |
Postal Code |
|
|
PROPERTY |
string(50) |
Property |
|
|
REGION |
string(50) |
Region |
|
|
STREETNAME |
string(999) |
Street Name |
|
|
12-12-2020 18:39 Version 20.1.301-BETA+3023
