Please enable JavaScript to view this site.

Twinfield Data Model

Navigation: Catalog: Twinfield > Schemas > Schema: Twinfield > Tables

AnnualReportTotals: Annual Report Totals

Contents Previous Home Next More

Name: AnnualReportTotals

Catalog: Twinfield

Schema: Twinfield

Label: Annual Report Totals

Partition-specific: true

Select: true

Insert: false

Update: false

Delete: false

Service URL (XML-specific): webservices/processxml.asmx

Topic (XML-specific): 040_1

Table Columns

Name

Data Type

Label

Required

Documentation

CODE

string

Code

 

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

itgen_twinfield_fin_trs_line_actiondate

 

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

itgen_twinfield_fin_trs_line_openbasevaluesigned

 

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

itgen_twinfield_fin_trs_mng_type

 

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

itgen_twinfield_ivb_trs_head_number

 

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

 

PARTITIONID

string

Company ID

 

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

decimal

Expense

 

TEQ_TRS_LINE_EXPENSE_NB

decimal

itgen_twinfield_teq_trs_line_expense_nb

 

TEQ_TRS_LINE_INVOICEBATCHID

int64

Invoice Batch ID

 

TEQ_TRS_LINE_QTYBILLABLE

string

Quantity Billable

 

TEQ_TRS_LINE_QTYVALUEEXT

decimal

Quantity Value External

 

TEQ_TRS_LINE_QTYVALUEEXT_NB

decimal

itgen_twinfield_teq_trs_line_qtyvalueext_nb

 

TEQ_TRS_LINE_QTYVALUEINT

decimal

Quantity Value Internal

 

TEQ_TRS_LINE_QTYVALUEINT_NB

decimal

itgen_twinfield_teq_trs_line_qtyvalueint_nb

 

TEQ_TRS_LINE_QUANTITY

decimal

Quantity

 

TEQ_TRS_LINE_QUANTITY_NB

decimal

itgen_twinfield_teq_trs_line_quantity_nb

 

TEQ_TRS_LINE_RATE_CODE

string

Exchange Rate Code

 

TEQ_TRS_LINE_RATE_NAME

string

Exchange Rate Name

 

TEQ_TRS_LINE_TIME

decimal

Time

 

TEQ_TRS_LINE_TIME_NB

decimal

itgen_twinfield_teq_trs_line_time_nb

 

TEQ_TRS_LINE_TIMEBILLABLE

string

Time Billable

 

TEQ_TRS_LINE_TIMEVALUEEXT

decimal

Time Value External

 

TEQ_TRS_LINE_TIMEVALUEEXT_NB

decimal

itgen_twinfield_teq_trs_line_timevalueext_nb

 

TEQ_TRS_LINE_TIMEVALUEINT

decimal

Time Value Internal

 

TEQ_TRS_LINE_TIMEVALUEINT_NB

decimal

itgen_twinfield_teq_trs_line_timevalueint_nb

 

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

 

 

25-11-2019 21:0317.33.205-BETA+2497