TransactionList: Twinfield Transactions List
read only per partition XML
- Catalog:
Twinfield - Schema:
Twinfield - Label: Transactions List
The data in this table is partitioned per value of the COMPANY_CODE column.
Can only retrieve data.
Summary
The following filters specified using SQL where-clauses are forwarded to Twinfield:
- FIN_TRS_HEAD_BROWSEREGIME (equal)
- FIN_TRS_HEAD_CODE (equal)
- FIN_TRS_HEAD_CURCODE (equal)
- FIN_TRS_HEAD_DATE (between)
- FIN_TRS_HEAD_INPDATE (between)
- FIN_TRS_HEAD_MODIFIED (between)
- FIN_TRS_HEAD_NUMBER (between)
- FIN_TRS_HEAD_STATUS (equal)
- FIN_TRS_HEAD_USER (equal)
- FIN_TRS_HEAD_YEAR (between)
- FIN_TRS_HEAD_YEARPERIOD (between)
- FIN_TRS_LINE_BASEVALUESIGNED (between)
- FIN_TRS_LINE_DIM1 (between)
- FIN_TRS_LINE_DIM2 (between)
- FIN_TRS_LINE_DIM3 (between)
- FIN_TRS_LINE_INVNUMBER (equal)
- FIN_TRS_LINE_REPVALUESIGNED (between)
- FIN_TRS_LINE_VALUESIGNED (between)
API Source
- XML service:
webservices/processxml.asmx - XML topic:
020
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 | 13,600 |
The result can be cached on the client.
Table Columns
The columns of the table TransactionList 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 |
|---|---|---|---|---|---|
CODE |
varchar2 |
Daybook Code | code |
The code of the journal to which this transaction belongs, such as MEMO or INK. | |
COMPANY_ |
varchar2 |
Company ID | |||
COMPANY_ |
varchar2 |
Company Name | |||
FIN_ |
varchar2 |
Banklink Status | fin. |
none, pending or active. | |
FIN_ |
varchar2 |
Dimension 1 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Name | fin. |
||
FIN_ |
varchar2 |
IBAN | fin. |
The international identifying code of the bank. | |
FIN_ |
varchar2 |
Transaction Type | fin. |
||
FIN_ |
int64 |
Reminders | fin. |
||
FIN_ |
varchar2 |
Head Code | fin. |
Day book code. | |
FIN_ |
int64 |
Head ID | fin. |
||
FIN_ |
varchar2 |
Total Dimension | fin. |
||
FIN_ |
varchar2 |
Total Dimension Type | fin. |
||
FIN_ |
varchar2 |
Cost Centre | fin. |
||
FIN_ |
varchar2 |
Cost Centre Name | fin. |
||
FIN_ |
varchar2 |
Balance Regime Prompt | fin. |
Values: Generic, Commercial, Economic or Fiscal. | |
FIN_ |
varchar2 |
Bank Code | fin. |
Values: BNK, KAS or SPAARR. | |
FIN_ |
varchar2 |
Bank Type | fin. |
Values: bank or cashbook. | |
FIN_ |
varchar2 |
Browse Regime | fin. |
Values: Generic, Commercial, Economic or Fiscal. | |
FIN_ |
decimal |
Close Value | fin. |
Closing balance. | |
FIN_ |
varchar2 |
Code | fin. |
||
FIN_ |
int64 |
Count | fin. |
||
FIN_ |
varchar2 |
Currency Code | fin. |
||
FIN_ |
decimal |
Customer Credit Limit | fin. |
||
FIN_ |
varchar2 |
Customer Responsible User | fin. |
||
FIN_ |
varchar2 |
Customer Responsible User Name | fin. |
||
FIN_ |
datetime |
Date | fin. |
Transaction date. | |
FIN_ |
datetime |
Input Date | fin. |
||
FIN_ |
datetime |
Modified | fin. |
Date/time the transaction was last modified. | |
FIN_ |
varchar2 |
Name | fin. |
||
FIN_ |
decimal |
Number | fin. |
Transaction number within day book. | |
FIN_ |
varchar2 |
Administration | fin. |
Office code. | |
FIN_ |
varchar2 |
Administration Name | fin. |
Office name. | |
FIN_ |
varchar2 |
Origin | fin. |
The journal transaction origin. | |
FIN_ |
int64 |
Period | fin. |
Financial year and period in YYYY/PP format. | |
FIN_ |
varchar2 |
Regime | fin. |
Type of regime. Values: Generic, Commercial, Economic or Fiscal. | |
FIN_ |
varchar2 |
Relation | fin. |
||
FIN_ |
varchar2 |
Relation Name | fin. |
||
FIN_ |
varchar2 |
Short Name | fin. |
||
FIN_ |
decimal |
Start Value | fin. |
Opening balance. | |
FIN_ |
varchar2 |
Status | fin. |
Values: draft, temporary, final, inuse or normal. | |
FIN_ |
int64 |
Statement Number | fin. |
Statement number. | |
FIN_ |
varchar2 |
User | fin. |
The user who created the transaction. | |
FIN_ |
varchar2 |
User Name | fin. |
Name of the user. | |
FIN_ |
int64 |
Year | fin. |
||
FIN_ |
varchar2 |
Year Period | fin. |
||
FIN_ |
varchar2 |
Action Code | fin. |
||
FIN_ |
datetime |
Action Created Date | fin. |
||
FIN_ |
datetime |
Action Date | fin. |
||
FIN_ |
varchar2 |
Action Description | fin. |
||
FIN_ |
varchar2 |
Action Name | fin. |
||
FIN_ |
varchar2 |
Action Remind? | fin. |
||
FIN_ |
varchar2 |
Action User | fin. |
||
FIN_ |
varchar2 |
Action User Name | fin. |
||
FIN_ |
decimal |
Action Value | fin. |
||
FIN_ |
int64 |
Asset Begin Period | fin. |
||
FIN_ |
int64 |
Asset Begin Year | fin. |
||
FIN_ |
int64 |
Asset Depreciation Term | fin. |
||
FIN_ |
varchar2 |
Available for Payrun | fin. |
||
FIN_ |
decimal |
Base Value | fin. |
Amount in the base currency. | |
FIN_ |
decimal |
Base Value (absolute) | fin. |
||
FIN_ |
decimal |
Base Value (signed) | fin. |
||
FIN_ |
varchar2 |
Cheque Number | fin. |
||
FIN_ |
int64 |
itgen_twinfield_fin_trs_line_count | fin. |
||
FIN_ |
datetime |
Currency Date | fin. |
Only if line type is detail. The line date. Only allowed if the line date in the journal book is set to Allowed or Mandatory. | |
FIN_ |
datetime |
Due Date | fin. |
||
FIN_ |
varchar2 |
Debit/Credit | fin. |
Whether the line is debit or credit. Values: credit or debit. | |
FIN_ |
varchar2 |
Description | fin. |
Textual description of the line. | |
FIN_ |
varchar2 |
Destination Dimension 1 | fin. |
If line type = detail the journal balance account or profit and loss account. If line type = vat the VAT balance account. When an empty dim1 is entered, by default the general ledger account will be taken as entered at the VAT code in Twinfield. | |
FIN_ |
varchar2 |
Destination Dimension 1 Name | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 2 | fin. |
If line type = detail the customer or supplier or the cost center or empty. Null else. | |
FIN_ |
varchar2 |
Destination Dimension 2 Name | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 3 | fin. |
If line type = detail the project or asset or empty. If line type = vat empty. | |
FIN_ |
varchar2 |
Destination Dimension 3 Name | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 4 | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 4 Name | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 5 | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 5 Name | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 6 | fin. |
||
FIN_ |
varchar2 |
Destination Dimension 6 Name | fin. |
||
FIN_ |
varchar2 |
Destination Administration | fin. |
||
FIN_ |
varchar2 |
Destination Administration Name | fin. |
||
FIN_ |
varchar2 |
Dimension 1 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 1 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 1 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 2 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 2 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 3 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Group 3 Name | fin. |
||
FIN_ |
varchar2 |
Group 4 | fin. |
||
FIN_ |
varchar2 |
Group Name 4 | fin. |
||
FIN_ |
varchar2 |
Group 5 | fin. |
||
FIN_ |
varchar2 |
Group Name 5 | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 1 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 1 Type | fin. |
||
FIN_ |
varchar2 |
Dimension 2 | fin. |
||
FIN_ |
varchar2 |
Dimension 2 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 2 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 2 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 2 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 2 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 2 Type | fin. |
||
FIN_ |
varchar2 |
Dimension 3 | fin. |
||
FIN_ |
varchar2 |
Dimension 3 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 3 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 3 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 3 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 3 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 3 Type | fin. |
||
FIN_ |
varchar2 |
Dimension 4 | fin. |
||
FIN_ |
varchar2 |
Dimension 4 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 4 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 4 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 4 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 4 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 4 Type | fin. |
||
FIN_ |
varchar2 |
Dimension 5 | fin. |
||
FIN_ |
varchar2 |
Dimension 5 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 5 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 5 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 5 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 5 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 5 Type | fin. |
||
FIN_ |
varchar2 |
Dimension 6 | fin. |
||
FIN_ |
varchar2 |
Dimension 6 Group | fin. |
||
FIN_ |
varchar2 |
Dimension 6 Name | fin. |
||
FIN_ |
varchar2 |
Dimension 6 Pay Available | fin. |
||
FIN_ |
varchar2 |
Dimension 6 Pay Code | fin. |
||
FIN_ |
varchar2 |
Dimension 6 Reminders | fin. |
Values: false, true, email. | |
FIN_ |
varchar2 |
Dimension 6 Type | fin. |
||
FIN_ |
varchar2 |
Free Text 1 | fin. |
Free text field 1 as entered on the transaction type. | |
FIN_ |
varchar2 |
Free Text 2 | fin. |
Free text field 2 as entered on the transaction type. | |
FIN_ |
varchar2 |
Free Text 3 | fin. |
Free text field 3 as entered on the transaction type. | |
FIN_ |
int64 |
ID | fin. |
Line ID. | |
FIN_ |
varchar2 |
Invoice Number | fin. |
Invoice number (for purchase and sales invoice transactions). | |
FIN_ |
int64 |
Invoice Batch ID | fin. |
||
FIN_ |
datetime |
Match Date | fin. |
||
FIN_ |
varchar2 |
Match Number | fin. |
||
FIN_ |
varchar2 |
Match Status | fin. |
Payment status of the transaction; notmatchable, available, matched or proposed. | |
FIN_ |
datetime |
Modified | fin. |
||
FIN_ |
decimal |
Open Value (base) | fin. |
||
FIN_ |
decimal |
Open Value (base, absolute) | fin. |
||
FIN_ |
decimal |
Open Amount | fin. |
||
FIN_ |
decimal |
Open Value (reporting) | fin. |
||
FIN_ |
decimal |
Open Value (reporting, absolute) | fin. |
||
FIN_ |
decimal |
Open Value (reporting, signed) | fin. |
||
FIN_ |
decimal |
Open Value | fin. |
||
FIN_ |
decimal |
Open Value (absolute) | fin. |
||
FIN_ |
decimal |
Open Value (signed) | fin. |
||
FIN_ |
varchar2 |
Payrun | fin. |
||
FIN_ |
decimal |
Quantity | fin. |
||
FIN_ |
int64 |
Relation | fin. |
||
FIN_ |
decimal |
Value (reporting) | fin. |
Amount in the reporting currency. | |
FIN_ |
decimal |
Value (reporting, absolute) | fin. |
||
FIN_ |
decimal |
Value (reporting, signed) | fin. |
||
FIN_ |
decimal |
Value | fin. |
If line type = detail amount without VAT. If line type = vat VAT amount. | |
FIN_ |
decimal |
Value (absolute) | fin. |
||
FIN_ |
decimal |
Value (signed) | fin. |
||
FIN_ |
decimal |
VAT Value (base, signed) | fin. |
||
FIN_ |
varchar2 |
VAT Code | fin. |
VAT code of the transaction line. | |
FIN_ |
varchar2 |
Transaction Type group | fin. |
||
FIN_ |
varchar2 |
Declaration Type | fin. |
Values: ict, vat, taxgroup, yearlysuppletion or taxgroupyearlysuppletion. | |
FIN_ |
int64 |
Declaration Year | fin. |
||
FIN_ |
varchar2 |
Gateway | fin. |
||
FIN_ |
datetime |
Sent | fin. |
||
FIN_ |
int64 |
Status | fin. |
||
FIN_ |
varchar2 |
Status Name | fin. |
Values: created, authorised, modified, sent, approved, sendtimeout or rejected. | |
FIN_ |
varchar2 |
Timeframe | fin. |
year, halfyear1, halfyear7, fourmonth1, fourmonth5, fourmonth9, quarter1..quarter12, bimonth1, bimonth3, bimonth5, bimonth7, bimonth9, bimonth11 or month1..month12. | |
HIE_ |
varchar2 |
Hierarchy | hie. |
||
HIE_ |
varchar2 |
Hierarchy Hidden | hie. |
||
HIE_ |
varchar2 |
Hierarchy Name | hie. |
||
HIE_ |
varchar2 |
Role | hie. |
||
HIE_ |
varchar2 |
Role Name | hie. |
||
HIE_ |
varchar2 |
Type | hie. |
Values: none, use, link or edit. | |
HIE_ |
varchar2 |
User | hie. |
The user code used to post the transaction. | |
HIE_ |
varchar2 |
User Name | hie. |
||
INV_ |
int64 |
Number | inv. |
||
IVB_ |
varchar2 |
Description | ivb. |
||
IVB_ |
int64 |
Schedule Number | ivb. |
||
IVB_ |
decimal |
Quantity | ivb. |
||
IVB_ |
varchar2 |
Source | ivb. |
Values: margin, financial, time, expenses, quantities or postponed. | |
IVB_ |
decimal |
Value | ivb. |
||
LINE |
varchar2 |
Line Number | line |
Number of the transaction line within the transaction. | |
NUMBER |
varchar2 |
Transaction Number | number |
The unique number of the transaction within the daybook. | |
OFFICE |
varchar2 |
Office Number | office |
The Twinfield offiec number. By definition equal to COMPANY_CODE. | |
TEQ_ |
varchar2 |
Authorizer | teq. |
||
TEQ_ |
varchar2 |
Authorizer Name | teq. |
||
TEQ_ |
varchar2 |
Code | teq. |
Transaction type code. | |
TEQ_ |
varchar2 |
Currency Code | teq. |
Currency used for the transaction. | |
TEQ_ |
varchar2 |
Customer | teq. |
||
TEQ_ |
varchar2 |
Customer Name | teq. |
||
TEQ_ |
datetime |
Date | teq. |
Transaction date. | |
TEQ_ |
varchar2 |
Dimension | teq. |
||
TEQ_ |
int64 |
Period | teq. |
||
TEQ_ |
varchar2 |
Project 1 | teq. |
||
TEQ_ |
varchar2 |
Project 1 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 1 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 1 Name | teq. |
||
TEQ_ |
varchar2 |
Project 2 | teq. |
||
TEQ_ |
varchar2 |
Project 2 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 2 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 2 Name | teq. |
||
TEQ_ |
varchar2 |
Project 3 | teq. |
||
TEQ_ |
varchar2 |
Project 3 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 3 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 3 Name | teq. |
||
TEQ_ |
varchar2 |
Project 4 | teq. |
||
TEQ_ |
varchar2 |
Project 4 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 4 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 4 Name | teq. |
||
TEQ_ |
varchar2 |
Project 5 | teq. |
||
TEQ_ |
varchar2 |
Project 5 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 5 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 5 Name | teq. |
||
TEQ_ |
varchar2 |
Project 6 | teq. |
||
TEQ_ |
varchar2 |
Project 6 Cost Centre | teq. |
||
TEQ_ |
varchar2 |
Project 6 Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
Project 6 Name | teq. |
||
TEQ_ |
varchar2 |
Status | teq. |
Values: entered, proposed, authorised, rejected, inuse, journalised. | |
TEQ_ |
varchar2 |
Token | teq. |
||
TEQ_ |
varchar2 |
User | teq. |
The user code used to post the transaction. | |
TEQ_ |
varchar2 |
User Cost Centre | teq. |
||
TEQ_ |
varchar2 |
User Cost Centre Name | teq. |
||
TEQ_ |
varchar2 |
User Name | teq. |
||
TEQ_ |
int64 |
Week | teq. |
||
TEQ_ |
int64 |
Year | teq. |
||
TEQ_ |
varchar2 |
Year Month | teq. |
||
TEQ_ |
varchar2 |
Year Period | teq. |
||
TEQ_ |
varchar2 |
Year Week | teq. |
||
TEQ_ |
varchar2 |
Billable | teq. |
||
TEQ_ |
varchar2 |
Description | teq. |
||
TEQ_ |
varchar2 |
Expense Billable | teq. |
||
TEQ_ |
decimal |
Expense | teq. |
||
TEQ_ |
decimal |
Expenses Not Billable | teq. |
||
TEQ_ |
int64 |
Invoice Batch ID | teq. |
||
TEQ_ |
varchar2 |
Quantity Billable | teq. |
||
TEQ_ |
decimal |
Quantity Value External | teq. |
||
TEQ_ |
decimal |
Quantities External Not Billable | teq. |
||
TEQ_ |
decimal |
Quantity Value Internal | teq. |
||
TEQ_ |
decimal |
Quantities Internal Not Billable | teq. |
||
TEQ_ |
decimal |
Quantity | teq. |
||
TEQ_ |
decimal |
Quantities Not Billable | teq. |
||
TEQ_ |
varchar2 |
Exchange Rate Code | teq. |
||
TEQ_ |
varchar2 |
Exchange Rate Name | teq. |
||
TEQ_ |
decimal |
Time | teq. |
||
TEQ_ |
varchar2 |
Time Billable | teq. |
||
TEQ_ |
decimal |
Time Value External | teq. |
||
TEQ_ |
decimal |
Time External Not Billable | teq. |
||
TEQ_ |
decimal |
Time Value Internal | teq. |
||
TEQ_ |
decimal |
Time Internal Not Billable | teq. |
||
TEQ_ |
decimal |
Time Not Billable | teq. |
||
TEQ_ |
varchar2 |
Token | teq. |
||
TEQ_ |
varchar2 |
Type | teq. |
Values: time, expense or quantity. | |
TEQ_ |
int64 |
Units | teq. |
||
TEQ_ |
decimal |
Value External | teq. |
||
TEQ_ |
decimal |
Value Internal | teq. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Transaction |
COMPANY_ |
Offices.code |
Key | |
Transaction |
COMPANY_ |
Currencies. |
Key | |
Transaction |
fin_ |
Currencies.code |
Key | |
Transaction |
COMPANY_ |
Balancesheets. |
Textual | Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table. |
Transaction |
fin_ |
Balancesheets.code |
Textual | Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table. |
Transaction |
COMPANY_ |
ProfitAndLoss. |
Textual | Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table. |
Transaction |
fin_ |
ProfitAndLoss.code |
Textual | Dimension 1 of a transaction line is a general ledger account: a balance sheet account in Dimensions.Balancesheets or a profit and loss account in Dimensions.ProfitAndLoss, of the same office; the dimension type of the line is not filled by every browse code and so cannot select the table. |
Transaction |
COMPANY_ |
VATCodes. |
Key | |
Transaction |
fin_ |
VATCodes.code |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: