TransactionLineVats |
Catalog: XAF
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/xaf:trLine/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) |
|
☐ |
|
COMPANY_ADDRESS |
string(240) |
|
☐ |
|
COMPANY_CITY |
string(240) |
|
☐ |
|
COMPANY_ID |
string(240) |
|
☐ |
|
COMPANY_NAME |
string(1000) |
|
☐ |
|
COMPANY_POSTAL_CODE |
string(240) |
|
☐ |
|
COMPANY_TAX_REG_IDENT |
string(240) |
|
☐ |
|
FILE_CURRENCY_CODE |
string(240) |
|
☐ |
|
FILE_DATE_CREATED |
string(240) |
|
☐ |
|
FISCAL_YEAR_END_DATE |
datetime |
|
☐ |
|
FISCAL_YEAR_NUMBER |
string(240) |
|
☑ |
|
FISCAL_YEAR_START_DATE |
datetime |
|
☐ |
|
INTERFACE_URL |
string(4000) |
|
☑ |
|
PRODUCT_ID |
string(240) |
|
☐ |
|
PRODUCT_VERSION |
string(240) |
|
☐ |
|
TRLINE_ACCID |
string(240) |
Transaction Line Konto ID |
|
|
TRLINE_AMNT |
decimal |
Transaction Line Betrag |
|
|
TRLINE_AMNTTP |
string(240) |
Transaction Line Summe Typ |
|
|
TRLINE_ARTGRPID |
string(240) |
Transaction Line Article Group ID |
|
|
TRLINE_BANKACCNR |
string(240) |
Transaction Line Bankkontonummer |
|
|
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 Identifikation |
|
|
TRLINE_DESCRIPTION |
string |
Transaction Line Beschreibung |
|
|
TRLINE_DOCREF |
string(999) |
Transaction Line Document Reference |
|
|
TRLINE_EFFDATE |
datetime |
Transaction Line Gültigkeitsdatum |
|
|
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 Auftragsreferenz |
|
|
TRLINE_PRODID |
string(240) |
Transaction Line Produkt ID |
|
|
TRLINE_PROJID |
string(240) |
Transaction Line Projekt ID |
|
|
TRLINE_QNTITY |
int64 |
Transaction Line Menge |
|
|
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_TRANSACTION_AMNT |
decimal |
Verhandlung Betrag |
|
|
TRLINE_TRANSACTION_AMNTTP |
string(240) |
Verhandlung Summe Typ |
|
|
TRLINE_TRANSACTION_DESC |
string |
Verhandlung Beschreibung |
|
|
TRLINE_TRANSACTION_JOURNAL_BANKACCNR |
string(240) |
Journal Bankkontonummer |
|
|
TRLINE_TRANSACTION_JOURNAL_DESCRIPTION |
string |
Journal Beschreibung |
|
|
TRLINE_TRANSACTION_JOURNAL_JRNID |
string(240) |
Journal Journal ID |
|
|
TRLINE_TRANSACTION_JOURNAL_JRNTP |
string(240) |
Journal Journal Typ |
|
|
TRLINE_TRANSACTION_JOURNAL_OFFSETACCID |
string(240) |
Journal Offset Account ID |
|
|
TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_LINESCOUNT |
int64 |
Verhandlung Lines Count |
|
|
TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_TOTALCREDIT |
decimal |
Verhandlung Gesamtguthaben |
|
|
TRLINE_TRANSACTION_JOURNAL_TRANSACTIONS_TOTALDEBIT |
decimal |
Verhandlung Total Debit |
|
|
TRLINE_TRANSACTION_NR |
string(240) |
Verhandlung Number |
|
|
TRLINE_TRANSACTION_PERIODNUMBER |
int64 |
Verhandlung Period Number |
|
|
TRLINE_TRANSACTION_SOURCEID |
string(240) |
Verhandlung Quellen-Kennzahl |
|
|
TRLINE_TRANSACTION_TRDT |
datetime |
Verhandlung Datum |
|
|
TRLINE_TRANSACTION_USERID |
string(240) |
Verhandlung Benutzer-Kennung |
|
|
TRLINE_WORKCOSTARRREF |
string(999) |
Transaction Line Work Cost Arrangement Reference |
|
|
VATAMNT |
decimal |
|
|
|
VATAMNTTP |
string(240) |
|
|
|
VATID |
string(240) |
|
|
|
VATPERC |
decimal |
|
|
|
29-05-2022 00:55 Version 22.0.196-PROD+3400