itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data ModelCatalog: XAF
Label: Transaction Lines
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/xaf:journal/xaf:transaction
XPath: /xaf:trLine
Table Columns
The columns of the table TransactionLines are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
ACCID |
string(240) |
Account ID |
|
|
AMNT |
decimal |
Amount |
|
|
AMNTTP |
string(240) |
Amount Type |
|
|
ARTGRPID |
string(240) |
Article Group ID |
|
|
AUDIT_FILE_VERSION |
string(240) |
Audit File Version |
☐ |
|
BALANCE |
decimal |
Balance |
☐ |
|
BANKACCNR |
string(240) |
Bank Account Number |
|
|
BANKIDCD |
string(240) |
Bank ID Code |
|
|
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 |
☐ |
|
COSTID |
string(240) |
Cost ID |
|
|
CURRENCY_CURAMNT |
decimal |
Currency Amount |
|
|
CURRENCY_CURCODE |
string(240) |
Currency Currency Code |
|
|
CUSTSUPID |
string(240) |
ID |
|
|
DESCRIPTION |
string |
Description |
|
|
DOCREF |
string(999) |
Document Reference |
|
|
EFFDATE |
datetime |
Effective Date |
|
|
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 |
☑ |
|
INVREF |
string(999) |
Invoice Reference |
|
|
MATCHKEYID |
string(240) |
Match Key ID |
|
|
NR |
string(240) |
Number |
|
|
ORDERREF |
string(999) |
Order Reference |
|
|
PRODID |
string(240) |
Product ID |
|
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
PROJID |
string(240) |
Project ID |
|
|
QNTITY |
int64 |
Quantity |
|
|
QNTITYID |
string(240) |
Quantity ID |
|
|
RECEIVINGDOCREF |
string(999) |
Receiving Document Reference |
|
|
RECREF |
string(999) |
Record Reference |
|
|
SHIPDOCREF |
string(999) |
Shipping Document Reference |
|
|
TRANSACTION_AMNT |
decimal |
Transaction Amount |
|
|
TRANSACTION_AMNTTP |
string(240) |
Transaction Amount Type |
|
|
TRANSACTION_DESC |
string |
Transaction Description |
|
|
TRANSACTION_NR |
string(240) |
Transaction Number |
|
|
TRANSACTION_PERIODNUMBER |
int64 |
Transaction Period Number |
|
|
TRANSACTION_SOURCEID |
string(240) |
Transaction Source ID |
|
|
TRANSACTION_TRDT |
datetime |
Transaction Date |
|
|
TRANSACTION_USERID |
string(240) |
Transaction User ID |
|
|
WORKCOSTARRREF |
string(999) |
Work Cost Arrangement Reference |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
