# AnnualReportTotalsMulticurrency: Twinfield Annual Report Totals (Multi-currency) ## Documentation The following filters specified using SQL where-clauses are forwarded to Twinfield: * FIN_TRS_HEAD_BALANCEREGIMEPROMPT (equal) * FIN_TRS_HEAD_REPORTINGSTRUCTURE (equal) * FIN_TRS_HEAD_STATUS (equal) * FIN_TRS_HEAD_YEAR (between) * FIN_TRS_HEAD_YEARPERIOD (between) * FIN_TRS_LINE_DIM1 (between) - Catalog: `Twinfield` - Schema: `Twinfield` - Label: Annual Report Totals (Multi-currency) The data in this table is partitioned per value of the `COMPANY_CODE` column. This is a read-only table. The Twinfield API may not support changing the data or the Invantive UniversalSQL driver for Twinfield does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Twinfield API. ## Table Columns The columns of the table `AnnualReportTotalsMulticurrency` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CODE` | `varchar2` | Daybook Code | ☐ | The code of the journal to which this transaction belongs, such as MEMO or INK. | | `COMPANY_CODE` | `varchar2` | Company ID | ☑ | | | `COMPANY_NAME` | `varchar2` | Company Name | ☑ | | | `FIN_BNK_BANKLINKSTATUS` | `varchar2` | Banklink Status | ☐ | none, pending or active. | | `FIN_BNK_DIM1` | `varchar2` | Dimension 1 | ☐ | | | `FIN_BNK_DIM1NAME` | `varchar2` | Dimension 1 Name | ☐ | | | `FIN_BNK_IBAN` | `varchar2` | IBAN | ☐ | The international identifying code of the bank. | | `FIN_BNK_TRANSACTIONTYPE` | `varchar2` | Transaction Type | ☐ | | | `FIN_RMD_DETAIL_REMINDCOUNT` | `int64` | Reminders | ☐ | | | `FIN_RMD_HEAD_CODE` | `varchar2` | Head Code | ☐ | Day book code. | | `FIN_RMD_HEAD_ID` | `int64` | Head ID | ☐ | | | `FIN_RMD_TOTAL_DIMENSION` | `varchar2` | Total Dimension | ☐ | | | `FIN_RMD_TOTAL_DIMTYPE` | `varchar2` | Total Dimension Type | ☐ | | | `FIN_TRS_COSTCENTER` | `varchar2` | Cost Centre | ☐ | | | `FIN_TRS_COSTCENTERNAME` | `varchar2` | Cost Centre Name | ☐ | | | `FIN_TRS_HEAD_BALANCEREGIMEPROMPT` | `varchar2` | Balance Regime Prompt | ☐ | Values: Generic, Commercial, Economic or Fiscal. | | `FIN_TRS_HEAD_BANKCODE` | `varchar2` | Bank Code | ☐ | Values: BNK, KAS or SPAARR. | | `FIN_TRS_HEAD_BANKTYPE` | `varchar2` | Bank Type | ☐ | Values: bank or cashbook. | | `FIN_TRS_HEAD_BROWSEREGIME` | `varchar2` | Browse Regime | ☐ | Values: Generic, Commercial, Economic or Fiscal. | | `FIN_TRS_HEAD_CLOSEVALUE` | `decimal` | Close Value | ☐ | Closing balance. | | `FIN_TRS_HEAD_CODE` | `varchar2` | Code | ☐ | | | `FIN_TRS_HEAD_COUNT` | `int64` | Count | ☐ | | | `FIN_TRS_HEAD_CURCODE` | `varchar2` | Currency Code | ☐ | | | `FIN_TRS_HEAD_CUSTOMER_CREDITLIMIT` | `decimal` | Customer Credit Limit | ☐ | | | `FIN_TRS_HEAD_CUSTOMER_RESPUSER` | `varchar2` | Customer Responsible User | ☐ | | | `FIN_TRS_HEAD_CUSTOMER_RESPUSERNAME` | `varchar2` | Customer Responsible User Name | ☐ | | | `FIN_TRS_HEAD_DATE` | `datetime` | Date | ☐ | Transaction date. | | `FIN_TRS_HEAD_INPDATE` | `datetime` | Input Date | ☐ | | | `FIN_TRS_HEAD_MODIFIED` | `datetime` | Modified | ☐ | Date/time the transaction was last modified. | | `FIN_TRS_HEAD_NAME` | `varchar2` | Name | ☐ | | | `FIN_TRS_HEAD_NUMBER` | `decimal` | Number | ☐ | Transaction number within day book. | | `FIN_TRS_HEAD_OFFICE` | `varchar2` | Administration | ☐ | Office code. | | `FIN_TRS_HEAD_OFFICENAME` | `varchar2` | Administration Name | ☐ | Office name. | | `FIN_TRS_HEAD_ORIGIN` | `varchar2` | Origin | ☐ | The journal transaction origin. | | `FIN_TRS_HEAD_PERIOD` | `int64` | Period | ☐ | Financial year and period in YYYY/PP format. | | `FIN_TRS_HEAD_REGIME` | `varchar2` | Regime | ☐ | Type of regime. Values: Generic, Commercial, Economic or Fiscal. | | `FIN_TRS_HEAD_RELATION` | `varchar2` | Relation | ☐ | | | `FIN_TRS_HEAD_RELATIONNAME` | `varchar2` | Relation Name | ☐ | | | `FIN_TRS_HEAD_REPORTINGSTRUCTURE` | `varchar2` | Reporting Structure | ☐ | Reporting structure code. | | `FIN_TRS_HEAD_SHORTNAME` | `varchar2` | Short Name | ☐ | | | `FIN_TRS_HEAD_STARTVALUE` | `decimal` | Start Value | ☐ | Opening balance. | | `FIN_TRS_HEAD_STATUS` | `varchar2` | Status | ☐ | Values: draft, temporary, final, inuse or normal. | | `FIN_TRS_HEAD_STMNUMBER` | `int64` | Statement Number | ☐ | Statement number. | | `FIN_TRS_HEAD_USER` | `varchar2` | User | ☐ | The user who created the transaction. | | `FIN_TRS_HEAD_USERNAME` | `varchar2` | User Name | ☐ | Name of the user. | | `FIN_TRS_HEAD_YEAR` | `int64` | Year | ☐ | | | `FIN_TRS_HEAD_YEARPERIOD` | `varchar2` | Year Period | ☐ | | | `FIN_TRS_LINE_ACTIONCODE` | `varchar2` | Action Code | ☐ | | | `FIN_TRS_LINE_ACTIONCREATED` | `datetime` | Action Created Date | ☐ | | | `FIN_TRS_LINE_ACTIONDATE` | `datetime` | Action Date | ☐ | | | `FIN_TRS_LINE_ACTIONDESCRIPTION` | `varchar2` | Action Description | ☐ | | | `FIN_TRS_LINE_ACTIONNAME` | `varchar2` | Action Name | ☐ | | | `FIN_TRS_LINE_ACTIONREMIND` | `varchar2` | Action Remind? | ☐ | | | `FIN_TRS_LINE_ACTIONUSER` | `varchar2` | Action User | ☐ | | | `FIN_TRS_LINE_ACTIONUSERNAME` | `varchar2` | Action User Name | ☐ | | | `FIN_TRS_LINE_ACTIONVALUE` | `decimal` | Action Value | ☐ | | | `FIN_TRS_LINE_ASSET_BEGINPERIOD` | `int64` | Asset Begin Period | ☐ | | | `FIN_TRS_LINE_ASSET_BEGINYEAR` | `int64` | Asset Begin Year | ☐ | | | `FIN_TRS_LINE_ASSET_DEPRECIATIONTERM` | `int64` | Asset Depreciation Term | ☐ | | | `FIN_TRS_LINE_AVAILABLEFORPAYRUNS` | `varchar2` | Available for Payrun | ☐ | | | `FIN_TRS_LINE_BASEVALUE` | `decimal` | Base Value | ☐ | Amount in the base currency. | | `FIN_TRS_LINE_BASEVALUEABS` | `decimal` | Base Value (absolute) | ☐ | | | `FIN_TRS_LINE_BASEVALUESIGNED` | `decimal` | Base Value (signed) | ☐ | | | `FIN_TRS_LINE_CHEQUENUMBER` | `varchar2` | Cheque Number | ☐ | | | `FIN_TRS_LINE_COUNT` | `int64` | | ☐ | | | `FIN_TRS_LINE_CURRENCYDATE` | `datetime` | Currency Date | ☐ | 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_DEBITCREDIT` | `varchar2` | Debit/Credit | ☐ | Whether the line is debit or credit. Values: credit or debit. | | `FIN_TRS_LINE_DESCRIPTION` | `varchar2` | Description | ☐ | Textual description of the line. | | `FIN_TRS_LINE_DESTINATION_DIM1` | `varchar2` | Destination Dimension 1 | ☐ | 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_DIM2` | `varchar2` | Destination Dimension 2 | ☐ | 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_DIM3` | `varchar2` | Destination Dimension 3 | ☐ | 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_DIM4` | `varchar2` | Destination Dimension 4 | ☐ | | | `FIN_TRS_LINE_DESTINATION_DIM4NAME` | `varchar2` | Destination Dimension 4 Name | ☐ | | | `FIN_TRS_LINE_DESTINATION_DIM5` | `varchar2` | Destination Dimension 5 | ☐ | | | `FIN_TRS_LINE_DESTINATION_DIM5NAME` | `varchar2` | Destination Dimension 5 Name | ☐ | | | `FIN_TRS_LINE_DESTINATION_DIM6` | `varchar2` | Destination Dimension 6 | ☐ | | | `FIN_TRS_LINE_DESTINATION_DIM6NAME` | `varchar2` | Destination Dimension 6 Name | ☐ | | | `FIN_TRS_LINE_DESTINATION_OFFICE` | `varchar2` | Destination Administration | ☐ | | | `FIN_TRS_LINE_DESTINATION_OFFICENAME` | `varchar2` | Destination Administration Name | ☐ | | | `FIN_TRS_LINE_DIM1` | `varchar2` | Dimension 1 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP` | `varchar2` | Dimension 1 Group | ☐ | | | `FIN_TRS_LINE_DIM1GROUP1` | `varchar2` | Dimension 1 Group 1 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP1NAME` | `varchar2` | Dimension 1 Group 1 Name | ☐ | | | `FIN_TRS_LINE_DIM1GROUP2` | `varchar2` | Dimension 1 Group 2 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP2NAME` | `varchar2` | Dimension 1 Group 2 Name | ☐ | | | `FIN_TRS_LINE_DIM1GROUP3` | `varchar2` | Dimension 1 Group 3 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP3NAME` | `varchar2` | Dimension 1 Group 3 Name | ☐ | | | `FIN_TRS_LINE_DIM1GROUP4` | `varchar2` | Group 4 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP4NAME` | `varchar2` | Group Name 4 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP5` | `varchar2` | Group 5 | ☐ | | | `FIN_TRS_LINE_DIM1GROUP5NAME` | `varchar2` | Group Name 5 | ☐ | | | `FIN_TRS_LINE_DIM1NAME` | `varchar2` | Dimension 1 Name | ☐ | | | `FIN_TRS_LINE_DIM1PAYAVAILABLE` | `varchar2` | Dimension 1 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM1PAYCODE` | `varchar2` | Dimension 1 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM1REMINDERS` | `varchar2` | Dimension 1 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM1TYPE` | `varchar2` | Dimension 1 Type | ☐ | | | `FIN_TRS_LINE_DIM2` | `varchar2` | Dimension 2 | ☐ | | | `FIN_TRS_LINE_DIM2GROUP` | `varchar2` | Dimension 2 Group | ☐ | | | `FIN_TRS_LINE_DIM2NAME` | `varchar2` | Dimension 2 Name | ☐ | | | `FIN_TRS_LINE_DIM2PAYAVAILABLE` | `varchar2` | Dimension 2 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM2PAYCODE` | `varchar2` | Dimension 2 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM2REMINDERS` | `varchar2` | Dimension 2 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM2TYPE` | `varchar2` | Dimension 2 Type | ☐ | | | `FIN_TRS_LINE_DIM3` | `varchar2` | Dimension 3 | ☐ | | | `FIN_TRS_LINE_DIM3GROUP` | `varchar2` | Dimension 3 Group | ☐ | | | `FIN_TRS_LINE_DIM3NAME` | `varchar2` | Dimension 3 Name | ☐ | | | `FIN_TRS_LINE_DIM3PAYAVAILABLE` | `varchar2` | Dimension 3 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM3PAYCODE` | `varchar2` | Dimension 3 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM3REMINDERS` | `varchar2` | Dimension 3 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM3TYPE` | `varchar2` | Dimension 3 Type | ☐ | | | `FIN_TRS_LINE_DIM4` | `varchar2` | Dimension 4 | ☐ | | | `FIN_TRS_LINE_DIM4GROUP` | `varchar2` | Dimension 4 Group | ☐ | | | `FIN_TRS_LINE_DIM4NAME` | `varchar2` | Dimension 4 Name | ☐ | | | `FIN_TRS_LINE_DIM4PAYAVAILABLE` | `varchar2` | Dimension 4 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM4PAYCODE` | `varchar2` | Dimension 4 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM4REMINDERS` | `varchar2` | Dimension 4 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM4TYPE` | `varchar2` | Dimension 4 Type | ☐ | | | `FIN_TRS_LINE_DIM5` | `varchar2` | Dimension 5 | ☐ | | | `FIN_TRS_LINE_DIM5GROUP` | `varchar2` | Dimension 5 Group | ☐ | | | `FIN_TRS_LINE_DIM5NAME` | `varchar2` | Dimension 5 Name | ☐ | | | `FIN_TRS_LINE_DIM5PAYAVAILABLE` | `varchar2` | Dimension 5 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM5PAYCODE` | `varchar2` | Dimension 5 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM5REMINDERS` | `varchar2` | Dimension 5 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM5TYPE` | `varchar2` | Dimension 5 Type | ☐ | | | `FIN_TRS_LINE_DIM6` | `varchar2` | Dimension 6 | ☐ | | | `FIN_TRS_LINE_DIM6GROUP` | `varchar2` | Dimension 6 Group | ☐ | | | `FIN_TRS_LINE_DIM6NAME` | `varchar2` | Dimension 6 Name | ☐ | | | `FIN_TRS_LINE_DIM6PAYAVAILABLE` | `varchar2` | Dimension 6 Pay Available | ☐ | | | `FIN_TRS_LINE_DIM6PAYCODE` | `varchar2` | Dimension 6 Pay Code | ☐ | | | `FIN_TRS_LINE_DIM6REMINDERS` | `varchar2` | Dimension 6 Reminders | ☐ | Values: false, true, email. | | `FIN_TRS_LINE_DIM6TYPE` | `varchar2` | Dimension 6 Type | ☐ | | | `FIN_TRS_LINE_FREETEXT1` | `varchar2` | Free Text 1 | ☐ | Free text field 1 as entered on the transaction type. | | `FIN_TRS_LINE_FREETEXT2` | `varchar2` | Free Text 2 | ☐ | Free text field 2 as entered on the transaction type. | | `FIN_TRS_LINE_FREETEXT3` | `varchar2` | Free Text 3 | ☐ | Free text field 3 as entered on the transaction type. | | `FIN_TRS_LINE_ID` | `int64` | ID | ☐ | Line ID. | | `FIN_TRS_LINE_INVNUMBER` | `varchar2` | Invoice Number | ☐ | Invoice number (for purchase and sales invoice transactions). | | `FIN_TRS_LINE_INVOICEBATCHID` | `int64` | Invoice Batch ID | ☐ | | | `FIN_TRS_LINE_MATCHDATE` | `datetime` | Match Date | ☐ | | | `FIN_TRS_LINE_MATCHNUMBER` | `varchar2` | Match Number | ☐ | | | `FIN_TRS_LINE_MATCHSTATUS` | `varchar2` | Match Status | ☐ | Payment status of the transaction; notmatchable, available, matched or proposed. | | `FIN_TRS_LINE_MODIFIED` | `datetime` | Modified | ☐ | | | `FIN_TRS_LINE_OPENBASEVALUE` | `decimal` | Open Value (base) | ☐ | | | `FIN_TRS_LINE_OPENBASEVALUEABS` | `decimal` | Open Value (base, absolute) | ☐ | | | `FIN_TRS_LINE_OPENBASEVALUESIGNED` | `decimal` | Open Amount | ☐ | | | `FIN_TRS_LINE_OPENREPVALUE` | `decimal` | Open Value (reporting) | ☐ | | | `FIN_TRS_LINE_OPENREPVALUEABS` | `decimal` | Open Value (reporting, absolute) | ☐ | | | `FIN_TRS_LINE_OPENREPVALUESIGNED` | `decimal` | Open Value (reporting, signed) | ☐ | | | `FIN_TRS_LINE_OPENVALUE` | `decimal` | Open Value | ☐ | | | `FIN_TRS_LINE_OPENVALUEABS` | `decimal` | Open Value (absolute) | ☐ | | | `FIN_TRS_LINE_OPENVALUESIGNED` | `decimal` | Open Value (signed) | ☐ | | | `FIN_TRS_LINE_PAYRUN` | `varchar2` | Payrun | ☐ | | | `FIN_TRS_LINE_QUANTITY` | `decimal` | Quantity | ☐ | | | `FIN_TRS_LINE_RELATION` | `int64` | Relation | ☐ | | | `FIN_TRS_LINE_REPVALUE` | `decimal` | Value (reporting) | ☐ | Amount in the reporting currency. | | `FIN_TRS_LINE_REPVALUEABS` | `decimal` | Value (reporting, absolute) | ☐ | | | `FIN_TRS_LINE_REPVALUESIGNED` | `decimal` | Value (reporting, signed) | ☐ | | | `FIN_TRS_LINE_VALUE` | `decimal` | Value | ☐ | If line type = detail amount without VAT. If line type = vat VAT amount. | | `FIN_TRS_LINE_VALUEABS` | `decimal` | Value (absolute) | ☐ | | | `FIN_TRS_LINE_VALUESIGNED` | `decimal` | Value (signed) | ☐ | | | `FIN_TRS_LINE_VATBASEVALUESIGNED` | `decimal` | VAT Value (base, signed) | ☐ | | | `FIN_TRS_LINE_VATCODE` | `varchar2` | VAT Code | ☐ | VAT code of the transaction line. | | `FIN_TRS_MNG_TYPE` | `varchar2` | Transaction Type group | ☐ | | | `FIN_VAT_DECLTYPE` | `varchar2` | Declaration Type | ☐ | Values: ict, vat, taxgroup, yearlysuppletion or taxgroupyearlysuppletion. | | `FIN_VAT_DECLYEAR` | `int64` | Declaration Year | ☐ | | | `FIN_VAT_GATEWAY` | `varchar2` | Gateway | ☐ | | | `FIN_VAT_SENT` | `datetime` | Sent | ☐ | | | `FIN_VAT_STATUS` | `int64` | Status | ☐ | | | `FIN_VAT_STATUSNAME` | `varchar2` | Status Name | ☐ | Values: created, authorised, modified, sent, approved, sendtimeout or rejected. | | `FIN_VAT_TIMEFRAME` | `varchar2` | 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_HIERARCHYHIDDEN` | `varchar2` | Hierarchy Hidden | ☐ | | | `HIE_XSS_HIERARCHYNAME` | `varchar2` | Hierarchy Name | ☐ | | | `HIE_XSS_ROLE` | `varchar2` | Role | ☐ | | | `HIE_XSS_ROLENAME` | `varchar2` | Role Name | ☐ | | | `HIE_XSS_TYPE` | `varchar2` | Type | ☐ | Values: none, use, link or edit. | | `HIE_XSS_USER` | `varchar2` | User | ☐ | The user code used to post the transaction. | | `HIE_XSS_USERNAME` | `varchar2` | User Name | ☐ | | | `INV_TRS_HEAD_NUMBER` | `int64` | Number | ☐ | | | `IVB_TRS_HEAD_DESCRIPTION` | `varchar2` | Description | ☐ | | | `IVB_TRS_HEAD_NUMBER` | `int64` | Schedule Number | ☐ | | | `IVB_TRS_LINE_QUANTITY` | `decimal` | Quantity | ☐ | | | `IVB_TRS_LINE_SOURCE` | `varchar2` | Source | ☐ | Values: margin, financial, time, expenses, quantities or postponed. | | `IVB_TRS_LINE_VALUE` | `decimal` | Value | ☐ | | | `LINE` | `varchar2` | Line Number | ☐ | Number of the transaction line within the transaction. | | `NUMBER` | `varchar2` | Transaction Number | ☐ | The unique number of the transaction within the daybook. | | `OFFICE` | `varchar2` | Office Number | ☐ | The Twinfield offiec number. By definition equal to COMPANY_CODE. | | `TEQ_TRS_HEAD_AUTHORISER` | `varchar2` | Authorizer | ☐ | | | `TEQ_TRS_HEAD_AUTHORISERNAME` | `varchar2` | Authorizer Name | ☐ | | | `TEQ_TRS_HEAD_CODE` | `varchar2` | Code | ☐ | Transaction type code. | | `TEQ_TRS_HEAD_CURCODE` | `varchar2` | Currency Code | ☐ | Currency used for the transaction. | | `TEQ_TRS_HEAD_CUSTOMER` | `varchar2` | Customer | ☐ | | | `TEQ_TRS_HEAD_CUSTOMERNAME` | `varchar2` | Customer Name | ☐ | | | `TEQ_TRS_HEAD_DATE` | `datetime` | Date | ☐ | Transaction date. | | `TEQ_TRS_HEAD_DIMENSION` | `varchar2` | Dimension | ☐ | | | `TEQ_TRS_HEAD_PERIOD` | `int64` | Period | ☐ | | | `TEQ_TRS_HEAD_PROJECT1` | `varchar2` | Project 1 | ☐ | | | `TEQ_TRS_HEAD_PROJECT1COSTCENTRE` | `varchar2` | Project 1 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT1COSTCENTRENAME` | `varchar2` | Project 1 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT1NAME` | `varchar2` | Project 1 Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT2` | `varchar2` | Project 2 | ☐ | | | `TEQ_TRS_HEAD_PROJECT2COSTCENTRE` | `varchar2` | Project 2 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT2COSTCENTRENAME` | `varchar2` | Project 2 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT2NAME` | `varchar2` | Project 2 Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT3` | `varchar2` | Project 3 | ☐ | | | `TEQ_TRS_HEAD_PROJECT3COSTCENTRE` | `varchar2` | Project 3 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT3COSTCENTRENAME` | `varchar2` | Project 3 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT3NAME` | `varchar2` | Project 3 Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT4` | `varchar2` | Project 4 | ☐ | | | `TEQ_TRS_HEAD_PROJECT4COSTCENTRE` | `varchar2` | Project 4 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT4COSTCENTRENAME` | `varchar2` | Project 4 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT4NAME` | `varchar2` | Project 4 Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT5` | `varchar2` | Project 5 | ☐ | | | `TEQ_TRS_HEAD_PROJECT5COSTCENTRE` | `varchar2` | Project 5 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT5COSTCENTRENAME` | `varchar2` | Project 5 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT5NAME` | `varchar2` | Project 5 Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT6` | `varchar2` | Project 6 | ☐ | | | `TEQ_TRS_HEAD_PROJECT6COSTCENTRE` | `varchar2` | Project 6 Cost Centre | ☐ | | | `TEQ_TRS_HEAD_PROJECT6COSTCENTRENAME` | `varchar2` | Project 6 Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_PROJECT6NAME` | `varchar2` | Project 6 Name | ☐ | | | `TEQ_TRS_HEAD_STATUS` | `varchar2` | Status | ☐ | Values: entered, proposed, authorised, rejected, inuse, journalised. | | `TEQ_TRS_HEAD_TOKEN` | `varchar2` | Token | ☐ | | | `TEQ_TRS_HEAD_USER` | `varchar2` | User | ☐ | The user code used to post the transaction. | | `TEQ_TRS_HEAD_USERCOSTCENTRE` | `varchar2` | User Cost Centre | ☐ | | | `TEQ_TRS_HEAD_USERCOSTCENTRENAME` | `varchar2` | User Cost Centre Name | ☐ | | | `TEQ_TRS_HEAD_USERNAME` | `varchar2` | User Name | ☐ | | | `TEQ_TRS_HEAD_WEEK` | `int64` | Week | ☐ | | | `TEQ_TRS_HEAD_YEAR` | `int64` | Year | ☐ | | | `TEQ_TRS_HEAD_YEARMONTH` | `varchar2` | Year Month | ☐ | | | `TEQ_TRS_HEAD_YEARPERIOD` | `varchar2` | Year Period | ☐ | | | `TEQ_TRS_HEAD_YEARWEEK` | `varchar2` | Year Week | ☐ | | | `TEQ_TRS_LINE_BILLABLE` | `varchar2` | Billable | ☐ | | | `TEQ_TRS_LINE_DESCRIPTION` | `varchar2` | Description | ☐ | | | `TEQ_TRS_LINE_EXPBILLABLE` | `varchar2` | Expense Billable | ☐ | | | `TEQ_TRS_LINE_EXPENSE_NB` | `decimal` | Expenses Not Billable | ☐ | | | `TEQ_TRS_LINE_EXPENSE` | `decimal` | Expense | ☐ | | | `TEQ_TRS_LINE_INVOICEBATCHID` | `int64` | Invoice Batch ID | ☐ | | | `TEQ_TRS_LINE_QTYBILLABLE` | `varchar2` | Quantity Billable | ☐ | | | `TEQ_TRS_LINE_QTYVALUEEXT_NB` | `decimal` | Quantities External Not Billable | ☐ | | | `TEQ_TRS_LINE_QTYVALUEEXT` | `decimal` | Quantity Value External | ☐ | | | `TEQ_TRS_LINE_QTYVALUEINT_NB` | `decimal` | Quantities Internal Not Billable | ☐ | | | `TEQ_TRS_LINE_QTYVALUEINT` | `decimal` | Quantity Value Internal | ☐ | | | `TEQ_TRS_LINE_QUANTITY_NB` | `decimal` | Quantities Not Billable | ☐ | | | `TEQ_TRS_LINE_QUANTITY` | `decimal` | Quantity | ☐ | | | `TEQ_TRS_LINE_RATE_CODE` | `varchar2` | Exchange Rate Code | ☐ | | | `TEQ_TRS_LINE_RATE_NAME` | `varchar2` | Exchange Rate Name | ☐ | | | `TEQ_TRS_LINE_TIME_NB` | `decimal` | Time Not Billable | ☐ | | | `TEQ_TRS_LINE_TIME` | `decimal` | Time | ☐ | | | `TEQ_TRS_LINE_TIMEBILLABLE` | `varchar2` | Time Billable | ☐ | | | `TEQ_TRS_LINE_TIMEVALUEEXT_NB` | `decimal` | Time External Not Billable | ☐ | | | `TEQ_TRS_LINE_TIMEVALUEEXT` | `decimal` | Time Value External | ☐ | | | `TEQ_TRS_LINE_TIMEVALUEINT_NB` | `decimal` | Time Internal Not Billable | ☐ | | | `TEQ_TRS_LINE_TIMEVALUEINT` | `decimal` | Time Value Internal | ☐ | | | `TEQ_TRS_LINE_TOKEN` | `varchar2` | Token | ☐ | | | `TEQ_TRS_LINE_TYPE` | `varchar2` | Type | ☐ | Values: time, expense or quantity. | | `TEQ_TRS_LINE_UNITS` | `int64` | Units | ☐ | | | `TEQ_TRS_LINE_VALUEEXT` | `decimal` | Value External | ☐ | | | `TEQ_TRS_LINE_VALUEINT` | `decimal` | Value Internal | ☐ | |