Twinfield API Data Model

CODE

string

Code

☐

COMPANY_CODE

string

Company ID

☑

COMPANY_NAME

string

Company Name

☑

FIN_BNK_BANKLINKSTATUS

string

Banklink Status

☐

FIN_BNK_DIM1

string

Dimension 1

☐

FIN_BNK_DIM1NAME

string

Dimension 1 Name

☐

FIN_BNK_IBAN

string

IBAN

☐

FIN_BNK_TRANSACTIONTYPE

string

Transaction Type

☐

FIN_RMD_DETAIL_REMINDCOUNT

int64

Reminders

☐

FIN_RMD_HEAD_CODE

string

Head Code

☐

FIN_RMD_HEAD_ID

int64

Head ID

☐

FIN_RMD_TOTAL_DIMENSION

string

Total Dimension

☐

FIN_RMD_TOTAL_DIMTYPE

string

Total Dimension Type

☐

FIN_TRS_COSTCENTER

string

Cost Center

☐

FIN_TRS_COSTCENTERNAME

string

Cost Center Name

☐

FIN_TRS_HEAD_BALANCEREGIMEPROMPT

string

Balance Regime Prompt

☐

FIN_TRS_HEAD_BANKCODE

string

Bank Code

☐

FIN_TRS_HEAD_BANKTYPE

string

Bank Type

☐

FIN_TRS_HEAD_BROWSEREGIME

string

Browse Regime

☐

FIN_TRS_HEAD_CLOSEVALUE

decimal

Close Value

☐

FIN_TRS_HEAD_CODE

string

Code

☐

FIN_TRS_HEAD_COUNT

int64

Count

☐

FIN_TRS_HEAD_CURCODE

string

Currency Code

☐

FIN_TRS_HEAD_CUSTOMER_CREDITLIMIT

decimal

Customer Credit Limit

☐

FIN_TRS_HEAD_CUSTOMER_RESPUSER

string

Customer Responsible User

☐

FIN_TRS_HEAD_CUSTOMER_RESPUSERNAME

string

Customer Responsible User Name

☐

FIN_TRS_HEAD_DATE

datetime

Date

☐

FIN_TRS_HEAD_INPDATE

datetime

Input Date

☐

FIN_TRS_HEAD_MODIFIED

datetime

Modified

☐

FIN_TRS_HEAD_NAME

string

Name

☐

FIN_TRS_HEAD_NUMBER

decimal

Number

☐

FIN_TRS_HEAD_OFFICE

string

Administration

☐

FIN_TRS_HEAD_OFFICENAME

string

Administration Name

☐

FIN_TRS_HEAD_ORIGIN

string

Origin

☐

FIN_TRS_HEAD_PERIOD

int64

Period

☐

FIN_TRS_HEAD_REGIME

string

Regime

☐

FIN_TRS_HEAD_RELATION

string

Relation

☐

FIN_TRS_HEAD_RELATIONNAME

string

Relation Name

☐

FIN_TRS_HEAD_SHORTNAME

string

Short Name

☐

FIN_TRS_HEAD_STARTVALUE

decimal

Start Value

☐

FIN_TRS_HEAD_STATUS

string

Status

☐

FIN_TRS_HEAD_STMNUMBER

int64

Statement Number

☐

FIN_TRS_HEAD_USER

string

User

☐

FIN_TRS_HEAD_USERNAME

string

User Name

☐

FIN_TRS_HEAD_YEAR

int64

Year

☐

FIN_TRS_HEAD_YEARPERIOD

string

Year Period

☐

FIN_TRS_LINE_ACTIONCODE

string

Action Code

☐

FIN_TRS_LINE_ACTIONCREATED

datetime

Action Created Date

☐

FIN_TRS_LINE_ACTIONDATE

datetime

Action Date

☐

FIN_TRS_LINE_ACTIONDESCRIPTION

string

Action Description

☐

FIN_TRS_LINE_ACTIONNAME

string

Action Name

☐

FIN_TRS_LINE_ACTIONREMIND

string

Action Remind?

☐

FIN_TRS_LINE_ACTIONUSER

string

Action User

☐

FIN_TRS_LINE_ACTIONUSERNAME

string

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

string

Available for Payrun

☐

FIN_TRS_LINE_BASEVALUE

decimal

Base Value

☐

FIN_TRS_LINE_BASEVALUEABS

decimal

Base Value (absolute)

☐

FIN_TRS_LINE_BASEVALUESIGNED

decimal

Base Value (signed)

☐

FIN_TRS_LINE_CHEQUENUMBER

string

Cheque Number

☐

FIN_TRS_LINE_CURRENCYDATE

datetime

Currency Date

☐

FIN_TRS_LINE_DATEDUE

datetime

Due Date

☐

FIN_TRS_LINE_DEBITCREDIT

string

Debit/Credit

☐

FIN_TRS_LINE_DESCRIPTION

string

Description

☐

FIN_TRS_LINE_DESTINATION_DIM1

string

Destination Dimension 1

☐

FIN_TRS_LINE_DESTINATION_DIM1NAME

string

Destination Dimension 1 Name

☐

FIN_TRS_LINE_DESTINATION_DIM2

string

Destination Dimension 2

☐

FIN_TRS_LINE_DESTINATION_DIM2NAME

string

Destination Dimension 2 Name

☐

FIN_TRS_LINE_DESTINATION_DIM3

string

Destination Dimension 3

☐

FIN_TRS_LINE_DESTINATION_DIM3NAME

string

Destination Dimension 3 Name

☐

FIN_TRS_LINE_DESTINATION_DIM4

string

Destination Dimension 4

☐

FIN_TRS_LINE_DESTINATION_DIM4NAME

string

Destination Dimension 4 Name

☐

FIN_TRS_LINE_DESTINATION_DIM5

string

Destination Dimension 5

☐

FIN_TRS_LINE_DESTINATION_DIM5NAME

string

Destination Dimension 5 Name

☐

FIN_TRS_LINE_DESTINATION_DIM6

string

Destination Dimension 6

☐

FIN_TRS_LINE_DESTINATION_DIM6NAME

string

Destination Dimension 6 Name

☐

FIN_TRS_LINE_DESTINATION_OFFICE

string

Destination Administration

☐

FIN_TRS_LINE_DESTINATION_OFFICENAME

string

Destination Administration Name

☐

FIN_TRS_LINE_DIM1

string

Dimension 1

☐

FIN_TRS_LINE_DIM1GROUP

string

Dimension 1 Group

☐

FIN_TRS_LINE_DIM1GROUP1

string

Dimension 1 Group 1

☐

FIN_TRS_LINE_DIM1GROUP1NAME

string

Dimension 1 Group 1 Name

☐

FIN_TRS_LINE_DIM1GROUP2

string

Dimension 1 Group 2

☐

FIN_TRS_LINE_DIM1GROUP2NAME

string

Dimension 1 Group 2 Name

☐

FIN_TRS_LINE_DIM1GROUP3

string

Dimension 1 Group 3

☐

FIN_TRS_LINE_DIM1GROUP3NAME

string

Dimension 1 Group 3 Name

☐

FIN_TRS_LINE_DIM1NAME

string

Dimension 1 Name

☐

FIN_TRS_LINE_DIM1PAYAVAILABLE

string

Dimension 1 Pay Available

☐

FIN_TRS_LINE_DIM1PAYCODE

string

Dimension 1 Pay Code

☐

FIN_TRS_LINE_DIM1REMINDERS

string

Dimension 1 Reminders

☐

FIN_TRS_LINE_DIM1TYPE

string

Dimension 1 Type

☐

FIN_TRS_LINE_DIM2

string

Dimension 2

☐

FIN_TRS_LINE_DIM2GROUP

string

Dimension 2 Group

☐

FIN_TRS_LINE_DIM2NAME

string

Dimension 2 Name

☐

FIN_TRS_LINE_DIM2PAYAVAILABLE

string

Dimension 2 Pay Available

☐

FIN_TRS_LINE_DIM2PAYCODE

string

Dimension 2 Pay Code

☐

FIN_TRS_LINE_DIM2REMINDERS

string

Dimension 2 Reminders

☐

FIN_TRS_LINE_DIM2TYPE

string

Dimension 2 Type

☐

FIN_TRS_LINE_DIM3

string

Dimension 3

☐

FIN_TRS_LINE_DIM3GROUP

string

Dimension 3 Group

☐

FIN_TRS_LINE_DIM3NAME

string

Dimension 3 Name

☐

FIN_TRS_LINE_DIM3PAYAVAILABLE

string

Dimension 3 Pay Available

☐

FIN_TRS_LINE_DIM3PAYCODE

string

Dimension 3 Pay Code

☐

FIN_TRS_LINE_DIM3REMINDERS

string

Dimension 3 Reminders

☐

FIN_TRS_LINE_DIM3TYPE

string

Dimension 3 Type

☐

FIN_TRS_LINE_DIM4

string

Dimension 4

☐

FIN_TRS_LINE_DIM4GROUP

string

Dimension 4 Group

☐

FIN_TRS_LINE_DIM4NAME

string

Dimension 4 Name

☐

FIN_TRS_LINE_DIM4PAYAVAILABLE

string

Dimension 4 Pay Available

☐

FIN_TRS_LINE_DIM4PAYCODE

string

Dimension 4 Pay Code

☐

FIN_TRS_LINE_DIM4REMINDERS

string

Dimension 4 Reminders

☐

FIN_TRS_LINE_DIM4TYPE

string

Dimension 4 Type

☐

FIN_TRS_LINE_DIM5

string

Dimension 5

☐

FIN_TRS_LINE_DIM5GROUP

string

Dimension 5 Group

☐

FIN_TRS_LINE_DIM5NAME

string

Dimension 5 Name

☐

FIN_TRS_LINE_DIM5PAYAVAILABLE

string

Dimension 5 Pay Available

☐

FIN_TRS_LINE_DIM5PAYCODE

string

Dimension 5 Pay Code

☐

FIN_TRS_LINE_DIM5REMINDERS

string

Dimension 5 Reminders

☐

FIN_TRS_LINE_DIM5TYPE

string

Dimension 5 Type

☐

FIN_TRS_LINE_DIM6

string

Dimension 6

☐

FIN_TRS_LINE_DIM6GROUP

string

Dimension 6 Group

☐

FIN_TRS_LINE_DIM6NAME

string

Dimension 6 Name

☐

FIN_TRS_LINE_DIM6PAYAVAILABLE

string

Dimension 6 Pay Available

☐

FIN_TRS_LINE_DIM6PAYCODE

string

Dimension 6 Pay Code

☐

FIN_TRS_LINE_DIM6REMINDERS

string

Dimension 6 Reminders

☐

FIN_TRS_LINE_DIM6TYPE

string

Dimension 6 Type

☐

FIN_TRS_LINE_FREETEXT1

string

Free Text 1

☐

FIN_TRS_LINE_FREETEXT2

string

Free Text 2

☐

FIN_TRS_LINE_FREETEXT3

string

Free Text 3

☐

FIN_TRS_LINE_ID

int64

ID

☐

FIN_TRS_LINE_INVNUMBER

string

Invoice Number

☐

FIN_TRS_LINE_INVOICEBATCHID

int64

Invoice Batch ID

☐

FIN_TRS_LINE_MATCHDATE

datetime

Match Date

☐

FIN_TRS_LINE_MATCHNUMBER

string

Match Number

☐

FIN_TRS_LINE_MATCHSTATUS

string

Match Status

☐

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

☐

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

string

Payrun

☐

FIN_TRS_LINE_QUANTITY

decimal

Quantity

☐

FIN_TRS_LINE_RELATION

int64

Relation

☐

FIN_TRS_LINE_REPVALUE

decimal

Value (reporting)

☐

FIN_TRS_LINE_REPVALUEABS

decimal

Value (reporting, absolute)

☐

FIN_TRS_LINE_REPVALUESIGNED

decimal

Value (reporting, signed)

☐

FIN_TRS_LINE_VALUE

decimal

Value

☐

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

string

VAT Code

☐

FIN_TRS_MNG_TYPE

string

☐

FIN_VAT_DECLTYPE

string

Declaration Type

☐

FIN_VAT_DECLYEAR

int64

Declaration Year

☐

FIN_VAT_GATEWAY

string

Gateway

☐

FIN_VAT_SENT

datetime

Sent

☐

FIN_VAT_STATUS

int64

Status

☐

FIN_VAT_STATUSNAME

string

Status Name

☐

FIN_VAT_TIMEFRAME

string

Timeframe

☐

HIE_XSS_HIERARCHY

string

Hierarchy

☐

HIE_XSS_HIERARCHYHIDDEN

string

Hierarchy Hidden

☐

HIE_XSS_HIERARCHYNAME

string

Hierarchy Name

☐

HIE_XSS_ROLE

string

Role

☐

HIE_XSS_ROLENAME

string

Role Name

☐

HIE_XSS_TYPE

string

Type

☐

HIE_XSS_USER

string

User

☐

HIE_XSS_USERNAME

string

User Name

☐

INV_TRS_HEAD_NUMBER

int64

Number

☐

IVB_TRS_HEAD_DESCRIPTION

string

Description

☐

IVB_TRS_HEAD_NUMBER

int64

☐

IVB_TRS_LINE_QUANTITY

decimal

Quantity

☐

IVB_TRS_LINE_SOURCE

string

Source

☐

IVB_TRS_LINE_VALUE

decimal

Value

☐

LINE

string

Line

☐

NUMBER

string

Number

☐

OFFICE

string

Administration

☐

TEQ_TRS_HEAD_AUTHORISER

string

Authorizer

☐

TEQ_TRS_HEAD_AUTHORISERNAME

string

Authorizer Name

☐

TEQ_TRS_HEAD_CODE

string

Code

☐

TEQ_TRS_HEAD_CURCODE

string

Currency Code

☐

TEQ_TRS_HEAD_CUSTOMER

string

Customer

☐

TEQ_TRS_HEAD_CUSTOMERNAME

string

Customer Name

☐

TEQ_TRS_HEAD_DATE

datetime

Date

☐

TEQ_TRS_HEAD_DIMENSION

string

Dimension

☐

TEQ_TRS_HEAD_PERIOD

int64

Period

☐

TEQ_TRS_HEAD_PROJECT1

string

Project 1

☐

TEQ_TRS_HEAD_PROJECT1COSTCENTRE

string

Project 1 Cost Center

☐

TEQ_TRS_HEAD_PROJECT1COSTCENTRENAME

string

Project 1 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT1NAME

string

Project 1 Name

☐

TEQ_TRS_HEAD_PROJECT2

string

Project 2

☐

TEQ_TRS_HEAD_PROJECT2COSTCENTRE

string

Project 2 Cost Center

☐

TEQ_TRS_HEAD_PROJECT2COSTCENTRENAME

string

Project 2 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT2NAME

string

Project 2 Name

☐

TEQ_TRS_HEAD_PROJECT3

string

Project 3

☐

TEQ_TRS_HEAD_PROJECT3COSTCENTRE

string

Project 3 Cost Center

☐

TEQ_TRS_HEAD_PROJECT3COSTCENTRENAME

string

Project 3 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT3NAME

string

Project 3 Name

☐

TEQ_TRS_HEAD_PROJECT4

string

Project 4

☐

TEQ_TRS_HEAD_PROJECT4COSTCENTRE

string

Project 4 Cost Center

☐

TEQ_TRS_HEAD_PROJECT4COSTCENTRENAME

string

Project 4 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT4NAME

string

Project 4 Name

☐

TEQ_TRS_HEAD_PROJECT5

string

Project 5

☐

TEQ_TRS_HEAD_PROJECT5COSTCENTRE

string

Project 5 Cost Center

☐

TEQ_TRS_HEAD_PROJECT5COSTCENTRENAME

string

Project 5 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT5NAME

string

Project 5 Name

☐

TEQ_TRS_HEAD_PROJECT6

string

Project 6

☐

TEQ_TRS_HEAD_PROJECT6COSTCENTRE

string

Project 6 Cost Center

☐

TEQ_TRS_HEAD_PROJECT6COSTCENTRENAME

string

Project 6 Cost Center Name

☐

TEQ_TRS_HEAD_PROJECT6NAME

string

Project 6 Name

☐

TEQ_TRS_HEAD_STATUS

string

Status

☐

TEQ_TRS_HEAD_TOKEN

string

Token

☐

TEQ_TRS_HEAD_USER

string

User

☐

TEQ_TRS_HEAD_USERCOSTCENTRE

string

User Cost Center

☐

TEQ_TRS_HEAD_USERCOSTCENTRENAME

string

User Cost Center Name

☐

TEQ_TRS_HEAD_USERNAME

string

User Name

☐

TEQ_TRS_HEAD_WEEK

int64

Week

☐

TEQ_TRS_HEAD_YEAR

int64

Year

☐

TEQ_TRS_HEAD_YEARMONTH

string

Year Month

☐

TEQ_TRS_HEAD_YEARPERIOD

string

Year Period

☐

TEQ_TRS_HEAD_YEARWEEK

string

Year Week

☐

TEQ_TRS_LINE_BILLABLE

string

Billable

☐

TEQ_TRS_LINE_DESCRIPTION

string

Description

☐

TEQ_TRS_LINE_EXPBILLABLE

string

Expense Billable

☐

TEQ_TRS_LINE_EXPENSE_NB

decimal

☐

TEQ_TRS_LINE_EXPENSE

decimal

Expense

☐

TEQ_TRS_LINE_INVOICEBATCHID

int64

Invoice Batch ID

☐

TEQ_TRS_LINE_QTYBILLABLE

string

Quantity Billable

☐

TEQ_TRS_LINE_QTYVALUEEXT_NB

decimal

☐

TEQ_TRS_LINE_QTYVALUEEXT

decimal

Quantity Value External

☐

TEQ_TRS_LINE_QTYVALUEINT_NB

decimal

☐

TEQ_TRS_LINE_QTYVALUEINT

decimal

Quantity Value Internal

☐

TEQ_TRS_LINE_QUANTITY_NB

decimal

☐

TEQ_TRS_LINE_QUANTITY

decimal

Quantity

☐

TEQ_TRS_LINE_RATE_CODE

string

Exchange Rate Code

☐

TEQ_TRS_LINE_RATE_NAME

string

Exchange Rate Name

☐

TEQ_TRS_LINE_TIME_NB

decimal

☐

TEQ_TRS_LINE_TIME

decimal

Time

☐

TEQ_TRS_LINE_TIMEBILLABLE

string

Time Billable

☐

TEQ_TRS_LINE_TIMEVALUEEXT_NB

decimal

☐

TEQ_TRS_LINE_TIMEVALUEEXT

decimal

Time Value External

☐

TEQ_TRS_LINE_TIMEVALUEINT_NB

decimal

☐

TEQ_TRS_LINE_TIMEVALUEINT

decimal

Time Value Internal

☐

TEQ_TRS_LINE_TOKEN

string

Token

☐

TEQ_TRS_LINE_TYPE

string

Type

☐

TEQ_TRS_LINE_UNITS

int64

Units

☐

TEQ_TRS_LINE_VALUEEXT

decimal

Value External

☐

TEQ_TRS_LINE_VALUEINT

decimal

Value Internal

☐