itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data ModelCatalog: XAF
Label: Transactions
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/xaf:company/xaf:transactions
XPath: /xaf:journal/xaf:transaction
Table Columns
The columns of the table Transactions are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
AMNT |
decimal |
Amount |
|
|
AMNTTP |
string(240) |
Amount Type |
|
|
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 |
☐ |
|
DESC |
string |
Description |
|
|
DESCRIPTION |
string |
Journal Description |
|
|
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 |
☑ |
|
JOURNAL_BANKACCNR |
string(240) |
Journal Bank Account Number |
|
|
JOURNAL_JRNID |
string(240) |
Journal Journal ID |
|
|
JOURNAL_JRNTP |
string(240) |
Journal Journal Type |
|
|
JOURNAL_OFFSETACCID |
string(240) |
Journal Offset Account ID |
|
|
JOURNAL_TRANSACTIONS_LINESCOUNT |
int64 |
Transaction Lines Count |
|
|
JOURNAL_TRANSACTIONS_TOTALCREDIT |
decimal |
Transaction Total Credit |
|
|
JOURNAL_TRANSACTIONS_TOTALDEBIT |
decimal |
Transaction Total Debit |
|
|
NR |
string(240) |
Number |
|
|
PERIODNUMBER |
int64 |
Period Number |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
SOURCEID |
string(240) |
Source ID |
|
|
TRDT |
datetime |
Date |
|
|
USERID |
string(240) |
User ID |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
