invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionLinesByNumber: Twinfield Transaction Lines by Number

read only per partition XML

  • Catalog: Twinfield
  • Schema: Settings
  • Label: Transaction Lines by Number

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

Summary

The lines of one financial transaction. A line is of one of three kinds - the total line, a detail line and a VAT line - and the columns that only one kind carries are empty on the others.

API Source

  • XML service: webservices/processxml.asmx
  • XML topic: transaction
  • XML path: /transaction/lines/line

Performance Characteristics

Characteristic Value
Average access latency (ms) 54
Full scan rows per minute 1,690
Point query rows per minute 1,111
Write rows per minute 1,500

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
code `` Code of the daybook, such as VRK for sales.
COMPANY_CODE `` Code of company.
number `` Number of the transaction within the daybook.

Table Columns

The columns of the table TransactionLinesByNumber are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
BASELINE int32 Base Line /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/baseline Only on a VAT line: the detail line the VAT was calculated over.
BASEVALUE decimal Base Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/basevalue Value in the base currency of the company.
BASEVALUEOPEN decimal Base Value Open /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/basevalueopen Only on the total line: what is still outstanding.
COMMENT varchar2 Comment /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/comment
COMPANY_CODE varchar2 Company ID
COMPANY_NAME varchar2 Company Name
DEBITCREDIT varchar2 Debit or Credit /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/debitcredit
DESCRIPTION varchar2 Description /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/description
DESTOFFICE varchar2 Destination Office /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/destoffice Only on a detail line of an intercompany transaction.
DIM1 varchar2 Dimension 1 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/dim1 General ledger account.
DIM1_NAME varchar2 Dimension 1 Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/dim1/name
DIM2 varchar2 Dimension 2 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/dim2 Customer, supplier or cost centre.
DIM2_NAME varchar2 Dimension 2 Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/dim2/name
DIM3 varchar2 Dimension 3 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/dim3 Project or asset.
FREECHAR varchar2 Free Character /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/freechar
ID int32 Line Identifier /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/id
MATCHLEVEL int32 Match Level /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/matchlevel
MATCHSTATUS varchar2 Match Status /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/matchstatus
RATE decimal Rate /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/rate
RELATION varchar2 Relation /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/relation
REPRATE decimal Reporting Rate /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/reprate
REPVALUE decimal Reporting Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/repvalue
TYPE varchar2 Type /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/type One of total, detail or vat.
VALUE decimal Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/value
VATBASETOTAL decimal VAT Base Total /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatbasetotal Only on the total line.
VATBASETURNOVER decimal VAT Base Turnover /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatbaseturnover Only on a VAT line.
VATBASEVALUE decimal VAT Base Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatbasevalue
VATCODE varchar2 VAT Code /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatcode
VATTOTAL decimal VAT Total /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vattotal Only on the total line.
VATTURNOVER decimal VAT Turnover /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatturnover Only on a VAT line.
VATVALUE decimal VAT Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/transaction/lines/line/vatvalue

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

Changes of This Table, 26.0 to 27.0

Table function Twinfield.Settings.TransactionLinesByNumber is added

The table function has 31 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0