---
title: "TimeAndExpensesBillingPerWeek (Twinfield)"
description: "Time and Expenses Billing per Week"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/twinfield/Twinfield.Twinfield.TimeAndExpensesBillingPerWeek
original: https://documentation.invantive.eu/en/datamodels/twinfield/Twinfield.Twinfield.TimeAndExpensesBillingPerWeek
updated: 2026-11-01T17:45:47Z
license: https://documentation.invantive.eu/en/
---

# TimeAndExpensesBillingPerWeek: Twinfield Time and Expenses Billing per Week

`read only` `per partition` `XML`

- Catalog: `Twinfield`
- Schema: `Twinfield`
- Label: Time and Expenses Billing per Week

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:
* TEQ_TRS_HEAD_AUTHORISER (between)
* TEQ_TRS_HEAD_CODE (between)
* TEQ_TRS_HEAD_CUSTOMER (between)
* TEQ_TRS_HEAD_DATE (between)
* TEQ_TRS_HEAD_PROJECT1 (between)
* TEQ_TRS_HEAD_PROJECT1COSTCENTRE (between)
* TEQ_TRS_HEAD_PROJECT2 (between)
* TEQ_TRS_HEAD_USER (between)
* TEQ_TRS_HEAD_USERCOSTCENTRE (between)
* TEQ_TRS_HEAD_YEARWEEK (between)

## API Source

- XML service: `webservices/processxml.asmx`
- XML topic: `661_1`

## 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 | 378 |

The result can be cached on the client.

## Table Columns

The columns of the table `TimeAndExpensesBillingPerWeek` 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_CODE` | `varchar2` | Company ID | [x] |  |  |
| `COMPANY_NAME` | `varchar2` | Company Name | [x] |  |  |
| `FIN_BNK_BANKLINKSTATUS` | `varchar2` | Banklink Status | [ ] | `fin.bnk.banklinkstatus` | none, pending or active. |
| `FIN_BNK_DIM1` | `varchar2` | Dimension 1 | [ ] | `fin.bnk.dim1` |  |
| `FIN_BNK_DIM1NAME` | `varchar2` | Dimension 1 Name | [ ] | `fin.bnk.dim1name` |  |
| `FIN_BNK_IBAN` | `varchar2` | IBAN | [ ] | `fin.bnk.iban` | The international identifying code of the bank. |
| `FIN_BNK_TRANSACTIONTYPE` | `varchar2` | Transaction Type | [ ] | `fin.bnk.transactiontype` |  |
| `FIN_RMD_DETAIL_REMINDCOUNT` | `int64` | Reminders | [ ] | `fin.rmd.detail.remindcount` |  |
| `FIN_RMD_HEAD_CODE` | `varchar2` | Head Code | [ ] | `fin.rmd.head.code` | Day book code. |
| `FIN_RMD_HEAD_ID` | `int64` | Head ID | [ ] | `fin.rmd.head.id` |  |
| `FIN_RMD_TOTAL_DIMENSION` | `varchar2` | Total Dimension | [ ] | `fin.rmd.total.dimension` |  |
| `FIN_RMD_TOTAL_DIMTYPE` | `varchar2` | Total Dimension Type | [ ] | `fin.rmd.total.dimtype` |  |
| `FIN_TRS_COSTCENTER` | `varchar2` | Cost Centre | [ ] | `fin.trs.costcenter` |  |
| `FIN_TRS_COSTCENTERNAME` | `varchar2` | Cost Centre Name | [ ] | `fin.trs.costcentername` |  |
| `FIN_TRS_HEAD_BALANCEREGIMEPROMPT` | `varchar2` | Balance Regime Prompt | [ ] | `fin.trs.head.balanceregimeprompt` | Values: Generic, Commercial, Economic or Fiscal. |
| `FIN_TRS_HEAD_BANKCODE` | `varchar2` | Bank Code | [ ] | `fin.trs.head.bankcode` | Values: BNK, KAS or SPAARR. |
| `FIN_TRS_HEAD_BANKTYPE` | `varchar2` | Bank Type | [ ] | `fin.trs.head.banktype` | Values: bank or cashbook. |
| `FIN_TRS_HEAD_BROWSEREGIME` | `varchar2` | Browse Regime | [ ] | `fin.trs.head.browseregime` | Values: Generic, Commercial, Economic or Fiscal. |
| `FIN_TRS_HEAD_CLOSEVALUE` | `decimal` | Close Value | [ ] | `fin.trs.head.closevalue` | Closing balance. |
| `FIN_TRS_HEAD_CODE` | `varchar2` | Code | [ ] | `fin.trs.head.code` |  |
| `FIN_TRS_HEAD_COUNT` | `int64` | Count | [ ] | `fin.trs.head.count` |  |
| `FIN_TRS_HEAD_CURCODE` | `varchar2` | Currency Code | [ ] | `fin.trs.head.curcode` |  |
| `FIN_TRS_HEAD_CUSTOMER_CREDITLIMIT` | `decimal` | Customer Credit Limit | [ ] | `fin.trs.head.customer.creditlimit` |  |
| `FIN_TRS_HEAD_CUSTOMER_RESPUSER` | `varchar2` | Customer Responsible User | [ ] | `fin.trs.head.customer.respuser` |  |
| `FIN_TRS_HEAD_CUSTOMER_RESPUSERNAME` | `varchar2` | Customer Responsible User Name | [ ] | `fin.trs.head.customer.respusername` |  |
| `FIN_TRS_HEAD_DATE` | `datetime` | Date | [ ] | `fin.trs.head.date` | Transaction date. |
| `FIN_TRS_HEAD_INPDATE` | `datetime` | Input Date | [ ] | `fin.trs.head.inpdate` |  |
| `FIN_TRS_HEAD_MODIFIED` | `datetime` | Modified | [ ] | `fin.trs.head.modified` | Date/time the transaction was last modified. |
| `FIN_TRS_HEAD_NAME` | `varchar2` | Name | [ ] | `fin.trs.head.name` |  |
| `FIN_TRS_HEAD_NUMBER` | `decimal` | Number | [ ] | `fin.trs.head.number` | Transaction number within day book. |
| `FIN_TRS_HEAD_OFFICE` | `varchar2` | Administration | [ ] | `fin.trs.head.office` | Office code. |
| `FIN_TRS_HEAD_OFFICENAME` | `varchar2` | Administration Name | [ ] | `fin.trs.head.officename` | Office name. |
| `FIN_TRS_HEAD_ORIGIN` | `varchar2` | Origin | [ ] | `fin.trs.head.origin` | The journal transaction origin. |
| `FIN_TRS_HEAD_PERIOD` | `int64` | Period | [ ] | `fin.trs.head.period` | Financial year and period in YYYY/PP format. |
| `FIN_TRS_HEAD_REGIME` | `varchar2` | Regime | [ ] | `fin.trs.head.regime` | Type of regime. Values: Generic, Commercial, Economic or Fiscal. |
| `FIN_TRS_HEAD_RELATION` | `varchar2` | Relation | [ ] | `fin.trs.head.relation` |  |
| `FIN_TRS_HEAD_RELATIONNAME` | `varchar2` | Relation Name | [ ] | `fin.trs.head.relationname` |  |
| `FIN_TRS_HEAD_SHORTNAME` | `varchar2` | Short Name | [ ] | `fin.trs.head.shortname` |  |
| `FIN_TRS_HEAD_STARTVALUE` | `decimal` | Start Value | [ ] | `fin.trs.head.startvalue` | Opening balance. |
| `FIN_TRS_HEAD_STATUS` | `varchar2` | Status | [ ] | `fin.trs.head.status` | Values: draft, temporary, final, inuse or normal. |
| `FIN_TRS_HEAD_STMNUMBER` | `int64` | Statement Number | [ ] | `fin.trs.head.stmnumber` | Statement number. |
| `FIN_TRS_HEAD_USER` | `varchar2` | User | [ ] | `fin.trs.head.user` | The user who created the transaction. |
| `FIN_TRS_HEAD_USERNAME` | `varchar2` | User Name | [ ] | `fin.trs.head.username` | Name of the user. |
| `FIN_TRS_HEAD_YEAR` | `int64` | Year | [ ] | `fin.trs.head.year` |  |
| `FIN_TRS_HEAD_YEARPERIOD` | `varchar2` | Year Period | [ ] | `fin.trs.head.yearperiod` |  |
| `FIN_TRS_LINE_ACTIONCODE` | `varchar2` | Action Code | [ ] | `fin.trs.line.actioncode` |  |
| `FIN_TRS_LINE_ACTIONCREATED` | `datetime` | Action Created Date | [ ] | `fin.trs.line.actioncreated` |  |
| `FIN_TRS_LINE_ACTIONDATE` | `datetime` | Action Date | [ ] | `fin.trs.line.actiondate` |  |
| `FIN_TRS_LINE_ACTIONDESCRIPTION` | `varchar2` | Action Description | [ ] | `fin.trs.line.actiondescription` |  |
| `FIN_TRS_LINE_ACTIONNAME` | `varchar2` | Action Name | [ ] | `fin.trs.line.actionname` |  |
| `FIN_TRS_LINE_ACTIONREMIND` | `varchar2` | Action Remind? | [ ] | `fin.trs.line.actionremind` |  |
| `FIN_TRS_LINE_ACTIONUSER` | `varchar2` | Action User | [ ] | `fin.trs.line.actionuser` |  |
| `FIN_TRS_LINE_ACTIONUSERNAME` | `varchar2` | Action User Name | [ ] | `fin.trs.line.actionusername` |  |
| `FIN_TRS_LINE_ACTIONVALUE` | `decimal` | Action Value | [ ] | `fin.trs.line.actionvalue` |  |
| `FIN_TRS_LINE_ASSET_BEGINPERIOD` | `int64` | Asset Begin Period | [ ] | `fin.trs.line.asset.beginperiod` |  |
| `FIN_TRS_LINE_ASSET_BEGINYEAR` | `int64` | Asset Begin Year | [ ] | `fin.trs.line.asset.beginyear` |  |
| `FIN_TRS_LINE_ASSET_DEPRECIATIONTERM` | `int64` | Asset Depreciation Term | [ ] | `fin.trs.line.asset.depreciationterm` |  |
| `FIN_TRS_LINE_AVAILABLEFORPAYRUNS` | `varchar2` | Available for Payrun | [ ] | `fin.trs.line.availableforpayruns` |  |
| `FIN_TRS_LINE_BASEVALUE` | `decimal` | Base Value | [ ] | `fin.trs.line.basevalue` | Amount in the base currency. |
| `FIN_TRS_LINE_BASEVALUEABS` | `decimal` | Base Value (absolute) | [ ] | `fin.trs.line.basevalueabs` |  |
| `FIN_TRS_LINE_BASEVALUESIGNED` | `decimal` | Base Value (signed) | [ ] | `fin.trs.line.basevaluesigned` |  |
| `FIN_TRS_LINE_CHEQUENUMBER` | `varchar2` | Cheque Number | [ ] | `fin.trs.line.chequenumber` |  |
| `FIN_TRS_LINE_COUNT` | `int64` | itgen_twinfield_fin_trs_line_count | [ ] | `fin.trs.line.count` |  |
| `FIN_TRS_LINE_CURRENCYDATE` | `datetime` | Currency Date | [ ] | `fin.trs.line.currencydate` | 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_TRS_LINE_DATEDUE` | `datetime` | Due Date | [ ] | `fin.trs.line.datedue` |  |
| `FIN_TRS_LINE_DEBITCREDIT` | `varchar2` | Debit/Credit | [ ] | `fin.trs.line.debitcredit` | Whether the line is debit or credit. Values: credit or debit. |
| `FIN_TRS_LINE_DESCRIPTION` | `varchar2` | Description | [ ] | `fin.trs.line.description` | Textual description of the line. |
| `FIN_TRS_LINE_DESTINATION_DIM1` | `varchar2` | Destination Dimension 1 | [ ] | `fin.trs.line.destination.dim1` | 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_TRS_LINE_DESTINATION_DIM1NAME` | `varchar2` | Destination Dimension 1 Name | [ ] | `fin.trs.line.destination.dim1name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM2` | `varchar2` | Destination Dimension 2 | [ ] | `fin.trs.line.destination.dim2` | If line type = detail the customer or supplier or the cost center or empty. Null else. |
| `FIN_TRS_LINE_DESTINATION_DIM2NAME` | `varchar2` | Destination Dimension 2 Name | [ ] | `fin.trs.line.destination.dim2name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM3` | `varchar2` | Destination Dimension 3 | [ ] | `fin.trs.line.destination.dim3` | If line type = detail the project or asset or empty. If line type = vat empty. |
| `FIN_TRS_LINE_DESTINATION_DIM3NAME` | `varchar2` | Destination Dimension 3 Name | [ ] | `fin.trs.line.destination.dim3name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM4` | `varchar2` | Destination Dimension 4 | [ ] | `fin.trs.line.destination.dim4` |  |
| `FIN_TRS_LINE_DESTINATION_DIM4NAME` | `varchar2` | Destination Dimension 4 Name | [ ] | `fin.trs.line.destination.dim4name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM5` | `varchar2` | Destination Dimension 5 | [ ] | `fin.trs.line.destination.dim5` |  |
| `FIN_TRS_LINE_DESTINATION_DIM5NAME` | `varchar2` | Destination Dimension 5 Name | [ ] | `fin.trs.line.destination.dim5name` |  |
| `FIN_TRS_LINE_DESTINATION_DIM6` | `varchar2` | Destination Dimension 6 | [ ] | `fin.trs.line.destination.dim6` |  |
| `FIN_TRS_LINE_DESTINATION_DIM6NAME` | `varchar2` | Destination Dimension 6 Name | [ ] | `fin.trs.line.destination.dim6name` |  |
| `FIN_TRS_LINE_DESTINATION_OFFICE` | `varchar2` | Destination Administration | [ ] | `fin.trs.line.destination.office` |  |
| `FIN_TRS_LINE_DESTINATION_OFFICENAME` | `varchar2` | Destination Administration Name | [ ] | `fin.trs.line.destination.officename` |  |
| `FIN_TRS_LINE_DIM1` | `varchar2` | Dimension 1 | [ ] | `fin.trs.line.dim1` |  |
| `FIN_TRS_LINE_DIM1GROUP` | `varchar2` | Dimension 1 Group | [ ] | `fin.trs.line.dim1group` |  |
| `FIN_TRS_LINE_DIM1GROUP1` | `varchar2` | Dimension 1 Group 1 | [ ] | `fin.trs.line.dim1group1` |  |
| `FIN_TRS_LINE_DIM1GROUP1NAME` | `varchar2` | Dimension 1 Group 1 Name | [ ] | `fin.trs.line.dim1group1name` |  |
| `FIN_TRS_LINE_DIM1GROUP2` | `varchar2` | Dimension 1 Group 2 | [ ] | `fin.trs.line.dim1group2` |  |
| `FIN_TRS_LINE_DIM1GROUP2NAME` | `varchar2` | Dimension 1 Group 2 Name | [ ] | `fin.trs.line.dim1group2name` |  |
| `FIN_TRS_LINE_DIM1GROUP3` | `varchar2` | Dimension 1 Group 3 | [ ] | `fin.trs.line.dim1group3` |  |
| `FIN_TRS_LINE_DIM1GROUP3NAME` | `varchar2` | Dimension 1 Group 3 Name | [ ] | `fin.trs.line.dim1group3name` |  |
| `FIN_TRS_LINE_DIM1GROUP4` | `varchar2` | Group 4 | [ ] | `fin.trs.line.dim1group4` |  |
| `FIN_TRS_LINE_DIM1GROUP4NAME` | `varchar2` | Group Name 4 | [ ] | `fin.trs.line.dim1group4name` |  |
| `FIN_TRS_LINE_DIM1GROUP5` | `varchar2` | Group 5 | [ ] | `fin.trs.line.dim1group5` |  |
| `FIN_TRS_LINE_DIM1GROUP5NAME` | `varchar2` | Group Name 5 | [ ] | `fin.trs.line.dim1group5name` |  |
| `FIN_TRS_LINE_DIM1NAME` | `varchar2` | Dimension 1 Name | [ ] | `fin.trs.line.dim1name` |  |
| `FIN_TRS_LINE_DIM1PAYAVAILABLE` | `varchar2` | Dimension 1 Pay Available | [ ] | `fin.trs.line.dim1payavailable` |  |
| `FIN_TRS_LINE_DIM1PAYCODE` | `varchar2` | Dimension 1 Pay Code | [ ] | `fin.trs.line.dim1paycode` |  |
| `FIN_TRS_LINE_DIM1REMINDERS` | `varchar2` | Dimension 1 Reminders | [ ] | `fin.trs.line.dim1reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM1TYPE` | `varchar2` | Dimension 1 Type | [ ] | `fin.trs.line.dim1type` |  |
| `FIN_TRS_LINE_DIM2` | `varchar2` | Dimension 2 | [ ] | `fin.trs.line.dim2` |  |
| `FIN_TRS_LINE_DIM2GROUP` | `varchar2` | Dimension 2 Group | [ ] | `fin.trs.line.dim2group` |  |
| `FIN_TRS_LINE_DIM2NAME` | `varchar2` | Dimension 2 Name | [ ] | `fin.trs.line.dim2name` |  |
| `FIN_TRS_LINE_DIM2PAYAVAILABLE` | `varchar2` | Dimension 2 Pay Available | [ ] | `fin.trs.line.dim2payavailable` |  |
| `FIN_TRS_LINE_DIM2PAYCODE` | `varchar2` | Dimension 2 Pay Code | [ ] | `fin.trs.line.dim2paycode` |  |
| `FIN_TRS_LINE_DIM2REMINDERS` | `varchar2` | Dimension 2 Reminders | [ ] | `fin.trs.line.dim2reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM2TYPE` | `varchar2` | Dimension 2 Type | [ ] | `fin.trs.line.dim2type` |  |
| `FIN_TRS_LINE_DIM3` | `varchar2` | Dimension 3 | [ ] | `fin.trs.line.dim3` |  |
| `FIN_TRS_LINE_DIM3GROUP` | `varchar2` | Dimension 3 Group | [ ] | `fin.trs.line.dim3group` |  |
| `FIN_TRS_LINE_DIM3NAME` | `varchar2` | Dimension 3 Name | [ ] | `fin.trs.line.dim3name` |  |
| `FIN_TRS_LINE_DIM3PAYAVAILABLE` | `varchar2` | Dimension 3 Pay Available | [ ] | `fin.trs.line.dim3payavailable` |  |
| `FIN_TRS_LINE_DIM3PAYCODE` | `varchar2` | Dimension 3 Pay Code | [ ] | `fin.trs.line.dim3paycode` |  |
| `FIN_TRS_LINE_DIM3REMINDERS` | `varchar2` | Dimension 3 Reminders | [ ] | `fin.trs.line.dim3reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM3TYPE` | `varchar2` | Dimension 3 Type | [ ] | `fin.trs.line.dim3type` |  |
| `FIN_TRS_LINE_DIM4` | `varchar2` | Dimension 4 | [ ] | `fin.trs.line.dim4` |  |
| `FIN_TRS_LINE_DIM4GROUP` | `varchar2` | Dimension 4 Group | [ ] | `fin.trs.line.dim4group` |  |
| `FIN_TRS_LINE_DIM4NAME` | `varchar2` | Dimension 4 Name | [ ] | `fin.trs.line.dim4name` |  |
| `FIN_TRS_LINE_DIM4PAYAVAILABLE` | `varchar2` | Dimension 4 Pay Available | [ ] | `fin.trs.line.dim4payavailable` |  |
| `FIN_TRS_LINE_DIM4PAYCODE` | `varchar2` | Dimension 4 Pay Code | [ ] | `fin.trs.line.dim4paycode` |  |
| `FIN_TRS_LINE_DIM4REMINDERS` | `varchar2` | Dimension 4 Reminders | [ ] | `fin.trs.line.dim4reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM4TYPE` | `varchar2` | Dimension 4 Type | [ ] | `fin.trs.line.dim4type` |  |
| `FIN_TRS_LINE_DIM5` | `varchar2` | Dimension 5 | [ ] | `fin.trs.line.dim5` |  |
| `FIN_TRS_LINE_DIM5GROUP` | `varchar2` | Dimension 5 Group | [ ] | `fin.trs.line.dim5group` |  |
| `FIN_TRS_LINE_DIM5NAME` | `varchar2` | Dimension 5 Name | [ ] | `fin.trs.line.dim5name` |  |
| `FIN_TRS_LINE_DIM5PAYAVAILABLE` | `varchar2` | Dimension 5 Pay Available | [ ] | `fin.trs.line.dim5payavailable` |  |
| `FIN_TRS_LINE_DIM5PAYCODE` | `varchar2` | Dimension 5 Pay Code | [ ] | `fin.trs.line.dim5paycode` |  |
| `FIN_TRS_LINE_DIM5REMINDERS` | `varchar2` | Dimension 5 Reminders | [ ] | `fin.trs.line.dim5reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM5TYPE` | `varchar2` | Dimension 5 Type | [ ] | `fin.trs.line.dim5type` |  |
| `FIN_TRS_LINE_DIM6` | `varchar2` | Dimension 6 | [ ] | `fin.trs.line.dim6` |  |
| `FIN_TRS_LINE_DIM6GROUP` | `varchar2` | Dimension 6 Group | [ ] | `fin.trs.line.dim6group` |  |
| `FIN_TRS_LINE_DIM6NAME` | `varchar2` | Dimension 6 Name | [ ] | `fin.trs.line.dim6name` |  |
| `FIN_TRS_LINE_DIM6PAYAVAILABLE` | `varchar2` | Dimension 6 Pay Available | [ ] | `fin.trs.line.dim6payavailable` |  |
| `FIN_TRS_LINE_DIM6PAYCODE` | `varchar2` | Dimension 6 Pay Code | [ ] | `fin.trs.line.dim6paycode` |  |
| `FIN_TRS_LINE_DIM6REMINDERS` | `varchar2` | Dimension 6 Reminders | [ ] | `fin.trs.line.dim6reminders` | Values: false, true, email. |
| `FIN_TRS_LINE_DIM6TYPE` | `varchar2` | Dimension 6 Type | [ ] | `fin.trs.line.dim6type` |  |
| `FIN_TRS_LINE_FREETEXT1` | `varchar2` | Free Text 1 | [ ] | `fin.trs.line.freetext1` | Free text field 1 as entered on the transaction type. |
| `FIN_TRS_LINE_FREETEXT2` | `varchar2` | Free Text 2 | [ ] | `fin.trs.line.freetext2` | Free text field 2 as entered on the transaction type. |
| `FIN_TRS_LINE_FREETEXT3` | `varchar2` | Free Text 3 | [ ] | `fin.trs.line.freetext3` | Free text field 3 as entered on the transaction type. |
| `FIN_TRS_LINE_ID` | `int64` | ID | [ ] | `fin.trs.line.id` | Line ID. |
| `FIN_TRS_LINE_INVNUMBER` | `varchar2` | Invoice Number | [ ] | `fin.trs.line.invnumber` | Invoice number (for purchase and sales invoice transactions). |
| `FIN_TRS_LINE_INVOICEBATCHID` | `int64` | Invoice Batch ID | [ ] | `fin.trs.line.invoicebatchid` |  |
| `FIN_TRS_LINE_MATCHDATE` | `datetime` | Match Date | [ ] | `fin.trs.line.matchdate` |  |
| `FIN_TRS_LINE_MATCHNUMBER` | `varchar2` | Match Number | [ ] | `fin.trs.line.matchnumber` |  |
| `FIN_TRS_LINE_MATCHSTATUS` | `varchar2` | Match Status | [ ] | `fin.trs.line.matchstatus` | Payment status of the transaction; notmatchable, available, matched or proposed. |
| `FIN_TRS_LINE_MODIFIED` | `datetime` | Modified | [ ] | `fin.trs.line.modified` |  |
| `FIN_TRS_LINE_OPENBASEVALUE` | `decimal` | Open Value (base) | [ ] | `fin.trs.line.openbasevalue` |  |
| `FIN_TRS_LINE_OPENBASEVALUEABS` | `decimal` | Open Value (base, absolute) | [ ] | `fin.trs.line.openbasevalueabs` |  |
| `FIN_TRS_LINE_OPENBASEVALUESIGNED` | `decimal` | Open Amount | [ ] | `fin.trs.line.openbasevaluesigned` |  |
| `FIN_TRS_LINE_OPENREPVALUE` | `decimal` | Open Value (reporting) | [ ] | `fin.trs.line.openrepvalue` |  |
| `FIN_TRS_LINE_OPENREPVALUEABS` | `decimal` | Open Value (reporting, absolute) | [ ] | `fin.trs.line.openrepvalueabs` |  |
| `FIN_TRS_LINE_OPENREPVALUESIGNED` | `decimal` | Open Value (reporting, signed) | [ ] | `fin.trs.line.openrepvaluesigned` |  |
| `FIN_TRS_LINE_OPENVALUE` | `decimal` | Open Value | [ ] | `fin.trs.line.openvalue` |  |
| `FIN_TRS_LINE_OPENVALUEABS` | `decimal` | Open Value (absolute) | [ ] | `fin.trs.line.openvalueabs` |  |
| `FIN_TRS_LINE_OPENVALUESIGNED` | `decimal` | Open Value (signed) | [ ] | `fin.trs.line.openvaluesigned` |  |
| `FIN_TRS_LINE_PAYRUN` | `varchar2` | Payrun | [ ] | `fin.trs.line.payrun` |  |
| `FIN_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `fin.trs.line.quantity` |  |
| `FIN_TRS_LINE_RELATION` | `int64` | Relation | [ ] | `fin.trs.line.relation` |  |
| `FIN_TRS_LINE_REPVALUE` | `decimal` | Value (reporting) | [ ] | `fin.trs.line.repvalue` | Amount in the reporting currency. |
| `FIN_TRS_LINE_REPVALUEABS` | `decimal` | Value (reporting, absolute) | [ ] | `fin.trs.line.repvalueabs` |  |
| `FIN_TRS_LINE_REPVALUESIGNED` | `decimal` | Value (reporting, signed) | [ ] | `fin.trs.line.repvaluesigned` |  |
| `FIN_TRS_LINE_VALUE` | `decimal` | Value | [ ] | `fin.trs.line.value` | If line type = detail amount without VAT. If line type = vat VAT amount. |
| `FIN_TRS_LINE_VALUEABS` | `decimal` | Value (absolute) | [ ] | `fin.trs.line.valueabs` |  |
| `FIN_TRS_LINE_VALUESIGNED` | `decimal` | Value (signed) | [ ] | `fin.trs.line.valuesigned` |  |
| `FIN_TRS_LINE_VATBASEVALUESIGNED` | `decimal` | VAT Value (base, signed) | [ ] | `fin.trs.line.vatbasevaluesigned` |  |
| `FIN_TRS_LINE_VATCODE` | `varchar2` | VAT Code | [ ] | `fin.trs.line.vatcode` | VAT code of the transaction line. |
| `FIN_TRS_MNG_TYPE` | `varchar2` | Transaction Type group | [ ] | `fin.trs.mng.type` |  |
| `FIN_VAT_DECLTYPE` | `varchar2` | Declaration Type | [ ] | `fin.vat.decltype` | Values: ict, vat, taxgroup, yearlysuppletion or taxgroupyearlysuppletion. |
| `FIN_VAT_DECLYEAR` | `int64` | Declaration Year | [ ] | `fin.vat.declyear` |  |
| `FIN_VAT_GATEWAY` | `varchar2` | Gateway | [ ] | `fin.vat.gateway` |  |
| `FIN_VAT_SENT` | `datetime` | Sent | [ ] | `fin.vat.sent` |  |
| `FIN_VAT_STATUS` | `int64` | Status | [ ] | `fin.vat.status` |  |
| `FIN_VAT_STATUSNAME` | `varchar2` | Status Name | [ ] | `fin.vat.statusname` | Values: created, authorised, modified, sent, approved, sendtimeout or rejected. |
| `FIN_VAT_TIMEFRAME` | `varchar2` | Timeframe | [ ] | `fin.vat.timeframe` | year, halfyear1, halfyear7, fourmonth1, fourmonth5, fourmonth9, quarter1..quarter12, bimonth1, bimonth3, bimonth5, bimonth7, bimonth9, bimonth11 or month1..month12. |
| `HIE_XSS_HIERARCHY` | `varchar2` | Hierarchy | [ ] | `hie.xss.hierarchy` |  |
| `HIE_XSS_HIERARCHYHIDDEN` | `varchar2` | Hierarchy Hidden | [ ] | `hie.xss.hierarchyhidden` |  |
| `HIE_XSS_HIERARCHYNAME` | `varchar2` | Hierarchy Name | [ ] | `hie.xss.hierarchyname` |  |
| `HIE_XSS_ROLE` | `varchar2` | Role | [ ] | `hie.xss.role` |  |
| `HIE_XSS_ROLENAME` | `varchar2` | Role Name | [ ] | `hie.xss.rolename` |  |
| `HIE_XSS_TYPE` | `varchar2` | Type | [ ] | `hie.xss.type` | Values: none, use, link or edit. |
| `HIE_XSS_USER` | `varchar2` | User | [ ] | `hie.xss.user` | The user code used to post the transaction. |
| `HIE_XSS_USERNAME` | `varchar2` | User Name | [ ] | `hie.xss.username` |  |
| `INV_TRS_HEAD_NUMBER` | `int64` | Number | [ ] | `inv.trs.head.number` |  |
| `IVB_TRS_HEAD_DESCRIPTION` | `varchar2` | Description | [ ] | `ivb.trs.head.description` |  |
| `IVB_TRS_HEAD_NUMBER` | `int64` | Schedule Number | [ ] | `ivb.trs.head.number` |  |
| `IVB_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `ivb.trs.line.quantity` |  |
| `IVB_TRS_LINE_SOURCE` | `varchar2` | Source | [ ] | `ivb.trs.line.source` | Values: margin, financial, time, expenses, quantities or postponed. |
| `IVB_TRS_LINE_VALUE` | `decimal` | Value | [ ] | `ivb.trs.line.value` |  |
| `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_TRS_HEAD_AUTHORISER` | `varchar2` | Authorizer | [ ] | `teq.trs.head.authoriser` |  |
| `TEQ_TRS_HEAD_AUTHORISERNAME` | `varchar2` | Authorizer Name | [ ] | `teq.trs.head.authorisername` |  |
| `TEQ_TRS_HEAD_CODE` | `varchar2` | Code | [ ] | `teq.trs.head.code` | Transaction type code. |
| `TEQ_TRS_HEAD_CURCODE` | `varchar2` | Currency Code | [ ] | `teq.trs.head.curcode` | Currency used for the transaction. |
| `TEQ_TRS_HEAD_CUSTOMER` | `varchar2` | Customer | [ ] | `teq.trs.head.customer` |  |
| `TEQ_TRS_HEAD_CUSTOMERNAME` | `varchar2` | Customer Name | [ ] | `teq.trs.head.customername` |  |
| `TEQ_TRS_HEAD_DATE` | `datetime` | Date | [ ] | `teq.trs.head.date` | Transaction date. |
| `TEQ_TRS_HEAD_DIMENSION` | `varchar2` | Dimension | [ ] | `teq.trs.head.dimension` |  |
| `TEQ_TRS_HEAD_PERIOD` | `int64` | Period | [ ] | `teq.trs.head.period` |  |
| `TEQ_TRS_HEAD_PROJECT1` | `varchar2` | Project 1 | [ ] | `teq.trs.head.project1` |  |
| `TEQ_TRS_HEAD_PROJECT1COSTCENTRE` | `varchar2` | Project 1 Cost Centre | [ ] | `teq.trs.head.project1costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT1COSTCENTRENAME` | `varchar2` | Project 1 Cost Centre Name | [ ] | `teq.trs.head.project1costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT1NAME` | `varchar2` | Project 1 Name | [ ] | `teq.trs.head.project1name` |  |
| `TEQ_TRS_HEAD_PROJECT2` | `varchar2` | Project 2 | [ ] | `teq.trs.head.project2` |  |
| `TEQ_TRS_HEAD_PROJECT2COSTCENTRE` | `varchar2` | Project 2 Cost Centre | [ ] | `teq.trs.head.project2costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT2COSTCENTRENAME` | `varchar2` | Project 2 Cost Centre Name | [ ] | `teq.trs.head.project2costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT2NAME` | `varchar2` | Project 2 Name | [ ] | `teq.trs.head.project2name` |  |
| `TEQ_TRS_HEAD_PROJECT3` | `varchar2` | Project 3 | [ ] | `teq.trs.head.project3` |  |
| `TEQ_TRS_HEAD_PROJECT3COSTCENTRE` | `varchar2` | Project 3 Cost Centre | [ ] | `teq.trs.head.project3costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT3COSTCENTRENAME` | `varchar2` | Project 3 Cost Centre Name | [ ] | `teq.trs.head.project3costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT3NAME` | `varchar2` | Project 3 Name | [ ] | `teq.trs.head.project3name` |  |
| `TEQ_TRS_HEAD_PROJECT4` | `varchar2` | Project 4 | [ ] | `teq.trs.head.project4` |  |
| `TEQ_TRS_HEAD_PROJECT4COSTCENTRE` | `varchar2` | Project 4 Cost Centre | [ ] | `teq.trs.head.project4costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT4COSTCENTRENAME` | `varchar2` | Project 4 Cost Centre Name | [ ] | `teq.trs.head.project4costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT4NAME` | `varchar2` | Project 4 Name | [ ] | `teq.trs.head.project4name` |  |
| `TEQ_TRS_HEAD_PROJECT5` | `varchar2` | Project 5 | [ ] | `teq.trs.head.project5` |  |
| `TEQ_TRS_HEAD_PROJECT5COSTCENTRE` | `varchar2` | Project 5 Cost Centre | [ ] | `teq.trs.head.project5costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT5COSTCENTRENAME` | `varchar2` | Project 5 Cost Centre Name | [ ] | `teq.trs.head.project5costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT5NAME` | `varchar2` | Project 5 Name | [ ] | `teq.trs.head.project5name` |  |
| `TEQ_TRS_HEAD_PROJECT6` | `varchar2` | Project 6 | [ ] | `teq.trs.head.project6` |  |
| `TEQ_TRS_HEAD_PROJECT6COSTCENTRE` | `varchar2` | Project 6 Cost Centre | [ ] | `teq.trs.head.project6costcentre` |  |
| `TEQ_TRS_HEAD_PROJECT6COSTCENTRENAME` | `varchar2` | Project 6 Cost Centre Name | [ ] | `teq.trs.head.project6costcentrename` |  |
| `TEQ_TRS_HEAD_PROJECT6NAME` | `varchar2` | Project 6 Name | [ ] | `teq.trs.head.project6name` |  |
| `TEQ_TRS_HEAD_STATUS` | `varchar2` | Status | [ ] | `teq.trs.head.status` | Values: entered, proposed, authorised, rejected, inuse, journalised. |
| `TEQ_TRS_HEAD_TOKEN` | `varchar2` | Token | [ ] | `teq.trs.head.token` |  |
| `TEQ_TRS_HEAD_USER` | `varchar2` | User | [ ] | `teq.trs.head.user` | The user code used to post the transaction. |
| `TEQ_TRS_HEAD_USERCOSTCENTRE` | `varchar2` | User Cost Centre | [ ] | `teq.trs.head.usercostcentre` |  |
| `TEQ_TRS_HEAD_USERCOSTCENTRENAME` | `varchar2` | User Cost Centre Name | [ ] | `teq.trs.head.usercostcentrename` |  |
| `TEQ_TRS_HEAD_USERNAME` | `varchar2` | User Name | [ ] | `teq.trs.head.username` |  |
| `TEQ_TRS_HEAD_WEEK` | `int64` | Week | [ ] | `teq.trs.head.week` |  |
| `TEQ_TRS_HEAD_YEAR` | `int64` | Year | [ ] | `teq.trs.head.year` |  |
| `TEQ_TRS_HEAD_YEARMONTH` | `varchar2` | Year Month | [ ] | `teq.trs.head.yearmonth` |  |
| `TEQ_TRS_HEAD_YEARPERIOD` | `varchar2` | Year Period | [ ] | `teq.trs.head.yearperiod` |  |
| `TEQ_TRS_HEAD_YEARWEEK` | `varchar2` | Year Week | [ ] | `teq.trs.head.yearweek` |  |
| `TEQ_TRS_LINE_BILLABLE` | `varchar2` | Billable | [ ] | `teq.trs.line.billable` |  |
| `TEQ_TRS_LINE_DESCRIPTION` | `varchar2` | Description | [ ] | `teq.trs.line.description` |  |
| `TEQ_TRS_LINE_EXPBILLABLE` | `varchar2` | Expense Billable | [ ] | `teq.trs.line.expbillable` |  |
| `TEQ_TRS_LINE_EXPENSE` | `decimal` | Expense | [ ] | `teq.trs.line.expense` |  |
| `TEQ_TRS_LINE_EXPENSE_NB` | `decimal` | Expenses Not Billable | [ ] | `teq.trs.line.expense_nb` |  |
| `TEQ_TRS_LINE_INVOICEBATCHID` | `int64` | Invoice Batch ID | [ ] | `teq.trs.line.invoicebatchid` |  |
| `TEQ_TRS_LINE_QTYBILLABLE` | `varchar2` | Quantity Billable | [ ] | `teq.trs.line.qtybillable` |  |
| `TEQ_TRS_LINE_QTYVALUEEXT` | `decimal` | Quantity Value External | [ ] | `teq.trs.line.qtyvalueext` |  |
| `TEQ_TRS_LINE_QTYVALUEEXT_NB` | `decimal` | Quantities External Not Billable | [ ] | `teq.trs.line.qtyvalueext_nb` |  |
| `TEQ_TRS_LINE_QTYVALUEINT` | `decimal` | Quantity Value Internal | [ ] | `teq.trs.line.qtyvalueint` |  |
| `TEQ_TRS_LINE_QTYVALUEINT_NB` | `decimal` | Quantities Internal Not Billable | [ ] | `teq.trs.line.qtyvalueint_nb` |  |
| `TEQ_TRS_LINE_QUANTITY` | `decimal` | Quantity | [ ] | `teq.trs.line.quantity` |  |
| `TEQ_TRS_LINE_QUANTITY_NB` | `decimal` | Quantities Not Billable | [ ] | `teq.trs.line.quantity_nb` |  |
| `TEQ_TRS_LINE_RATE_CODE` | `varchar2` | Exchange Rate Code | [ ] | `teq.trs.line.rate.code` |  |
| `TEQ_TRS_LINE_RATE_NAME` | `varchar2` | Exchange Rate Name | [ ] | `teq.trs.line.rate.name` |  |
| `TEQ_TRS_LINE_TIME` | `decimal` | Time | [ ] | `teq.trs.line.time` |  |
| `TEQ_TRS_LINE_TIMEBILLABLE` | `varchar2` | Time Billable | [ ] | `teq.trs.line.timebillable` |  |
| `TEQ_TRS_LINE_TIMEVALUEEXT` | `decimal` | Time Value External | [ ] | `teq.trs.line.timevalueext` |  |
| `TEQ_TRS_LINE_TIMEVALUEEXT_NB` | `decimal` | Time External Not Billable | [ ] | `teq.trs.line.timevalueext_nb` |  |
| `TEQ_TRS_LINE_TIMEVALUEINT` | `decimal` | Time Value Internal | [ ] | `teq.trs.line.timevalueint` |  |
| `TEQ_TRS_LINE_TIMEVALUEINT_NB` | `decimal` | Time Internal Not Billable | [ ] | `teq.trs.line.timevalueint_nb` |  |
| `TEQ_TRS_LINE_TIME_NB` | `decimal` | Time Not Billable | [ ] | `teq.trs.line.time_nb` |  |
| `TEQ_TRS_LINE_TOKEN` | `varchar2` | Token | [ ] | `teq.trs.line.token` |  |
| `TEQ_TRS_LINE_TYPE` | `varchar2` | Type | [ ] | `teq.trs.line.type` | Values: time, expense or quantity. |
| `TEQ_TRS_LINE_UNITS` | `int64` | Units | [ ] | `teq.trs.line.units` |  |
| `TEQ_TRS_LINE_VALUEEXT` | `decimal` | Value External | [ ] | `teq.trs.line.valueext` |  |
| `TEQ_TRS_LINE_VALUEINT` | `decimal` | Value Internal | [ ] | `teq.trs.line.valueint` |  |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `TimeAndExpensesBillingPerWeek_COMPANY_CODE_fk` | `COMPANY_CODE` | [Offices](Twinfield.Twinfield.Offices)`.code` | Key |  |



## Release Notes

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

- [Twinfield](/en/release-notes/drivers?driver=twinfield)

