TransactionJournals: Transaction Journals |
Name: TransactionJournals
Catalog: XAF
Label: Transaction Journals
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
AUDIT_FILE_VERSION |
string(60) |
Audit File Version |
☑ |
|
BANKACCNR |
string(35) |
Bank Account Number |
|
|
COMPANY_ADDRESS |
string(240) |
Company Address |
☐ |
|
COMPANY_CITY |
string(240) |
Company City |
☐ |
|
COMPANY_ID |
string(240) |
Company ID |
☑ |
|
COMPANY_NAME |
string(1000) |
Company Name |
☐ |
{res:itgen_xaf_company_name_def} |
COMPANY_POSTAL_CODE |
string(240) |
Company Postal Code |
☐ |
|
COMPANY_TAX_REG_IDENT |
string(60) |
Tax Registration Identification |
☑ |
|
DESCRIPTION |
string |
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 |
☑ |
{res:itgen_interface_url_def} |
JRNID |
string(35) |
Journal ID |
|
|
JRNTP |
string(2) |
Journal Type |
|
|
OFFSETACCID |
string(35) |
Offset Account ID |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☑ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☑ |
|
TRANSACTIONS_LINESCOUNT |
int64 |
Transaction Lines Count |
|
|
TRANSACTIONS_TOTALCREDIT |
decimal |
Transaction Total Credit |
|
|
TRANSACTIONS_TOTALDEBIT |
decimal |
Transaction Total Debit |
|
|
Generated 11-01-2019 19:54 on version 17.30.0-PROD+1821.