XAF 3.2 Data Model
XAF Forums
Catalog: XAF
Label: Transactions
The data in this table is partitioned per value of the COMPANY_NAME column.
Retrieve: true
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 |
|
|
27-12-2021 11:01 Version 20.2.169-PROD+3633
