xMsg javascript has not been loaded.
Catalog: XAF
Label: Companies
The data in this table is partitioned per value of the COMPANY_NAME column.
This is a read-only table. The XAF 3.2 API may not support changing the data or the Invantive SQL driver for XAF 3.2 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the XAF 3.2 API.
Topic: auditfile
Base XPath: /xaf:auditfile
XPath: /xaf:company
The columns of the table Companies are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_CITY |
string(240) |
Company City |
☐ |
|
COMPANY_ID |
string(240) |
Company ID |
☐ |
|
COMPANY_NAME |
string(1000) |
Company Name |
☐ |
|
COMPANY_POSTAL_CODE |
string(240) |
Company Postal Code |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
Tax Registration Identification |
☐ |
|
COMPANYIDENT |
string(240) |
Company Identification |
|
|
COMPANYNAME |
string(999) |
Company Name |
|
|
FILE_CURRENCY_CODE |
string(240) |
File Currency Code |
☐ |
|
FILE_DATE_CREATED |
string(240) |
File Creation Date |
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
Fiscal Year End Date |
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
Fiscal Year Number |
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
Fiscal Year Start Date |
☐ |
|
INTERFACE_URL |
string(4000) |
Interface URL |
☑ |
|
OPENINGBALANCE_LINESCOUNT |
int64 |
Opening Balance Lines Count |
|
|
OPENINGBALANCE_OPBALDATE |
datetime |
Opening Balance Date |
|
|
OPENINGBALANCE_OPBALDESC |
string(999) |
Opening Balance Description |
|
|
OPENINGBALANCE_TOTALCREDIT |
decimal |
Opening Balance Total Credit |
|
|
OPENINGBALANCE_TOTALDEBIT |
decimal |
Opening Balance Total Debit |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
TAXREGIDENT |
string(240) |
Tax Registration Identification |
|
|
TAXREGISTRATIONCOUNTRY |
string(240) |
Tax Registration Country |
|
|
TRANSACTIONS_LINESCOUNT |
int64 |
Transactions Lines Count |
|
|
TRANSACTIONS_TOTALCREDIT |
decimal |
Transactions Total Credit |
|
|
TRANSACTIONS_TOTALDEBIT |
decimal |
Transactions Total Debit |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023