invantive documentation
Invantive Support ForumsLog In / Sign Up

FixedAssets: Twinfield Fixed Assets

read only per partition XML

  • Catalog: Twinfield
  • Schema: Twinfield
  • Label: Fixed Assets

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_CODE (equal)
  • FIN_TRS_HEAD_STATUS (equal)
  • FIN_TRS_HEAD_YEAR (between)
  • FIN_TRS_HEAD_YEARPERIOD (between)
  • FIN_TRS_LINE_DIM3 (between)

API Source

  • XML service: webservices/processxml.asmx
  • XML topic: 302_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 FixedAssets 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
COMPANY_NAME varchar2 Company Name
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
FixedAssets_COMPANY_CODE_fk COMPANY_CODE Offices.code Key

Release Notes

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