itgendoc001X
xMsg javascript has not been loaded.
XAF 3.2 Data ModelCatalog: XAF
Label: Transaction Line VATs
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/xaf:trLine
XPath: /xaf:vat
Table Columns
The columns of the table TransactionLineVats 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 |
☐ |
|
DESCRIPTION |
string |
Transaction Line 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 |
☑ |
|
PRODUCT_ID |
string(240) |
Product ID |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
TRLINE_ACCID |
string(240) |
Transaction Line Account ID |
|
|
TRLINE_AMNT |
decimal |
Transaction Line Amount |
|
|
TRLINE_AMNTTP |
string(240) |
Transaction Line Amount Type |
|
|
TRLINE_ARTGRPID |
string(240) |
Transaction Line Article Group ID |
|
|
TRLINE_BANKACCNR |
string(240) |
Transaction Line Bank Account Number |
|
|
TRLINE_BANKIDCD |
string(240) |
Transaction Line Bank ID Code |
|
|
TRLINE_COSTID |
string(240) |
Transaction Line Cost ID |
|
|
TRLINE_CURRENCY_CURAMNT |
decimal |
|
|
|
TRLINE_CURRENCY_CURCODE |
string(240) |
|
|
|
TRLINE_CUSTSUPID |
string(240) |
Transaction Line ID |
|
|
TRLINE_DOCREF |
string(999) |
Transaction Line Document Reference |
|
|
TRLINE_EFFDATE |
datetime |
Transaction Line Effective Date |
|
|
TRLINE_INVREF |
string(999) |
Transaction Line Invoice Reference |
|
|
TRLINE_MATCHKEYID |
string(240) |
Transaction Line Match Key ID |
|
|
TRLINE_NR |
string(240) |
Transaction Line Number |
|
|
TRLINE_ORDERREF |
string(999) |
Transaction Line Order Reference |
|
|
TRLINE_PRODID |
string(240) |
Transaction Line Product ID |
|
|
TRLINE_PROJID |
string(240) |
Transaction Line Project ID |
|
|
TRLINE_QNTITY |
int64 |
Transaction Line Quantity |
|
|
TRLINE_QNTITYID |
string(240) |
Transaction Line Quantity ID |
|
|
TRLINE_RECEIVINGDOCREF |
string(999) |
Transaction Line Receiving Document Reference |
|
|
TRLINE_RECREF |
string(999) |
Transaction Line Record Reference |
|
|
TRLINE_SHIPDOCREF |
string(999) |
Transaction Line Shipping Document Reference |
|
|
TRLINE_WORKCOSTARRREF |
string(999) |
Transaction Line Work Cost Arrangement Reference |
|
|
VATAMNT |
decimal |
VAT Amount |
|
|
VATAMNTTP |
string(240) |
VAT Amount Type |
|
|
VATID |
string(240) |
ID |
|
|
VATPERC |
decimal |
VAT Percentage |
|
|
12-12-2020 18:41 Version 20.1.301-BETA+3023
