Please enable JavaScript to view this site.

Navigation: Schema:  > Tables

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