invantive documentation
Invantive Support ForumsLog In / Sign Up

Projects: Twinfield Projects

read only per partition XML

  • Catalog: Twinfield
  • Schema: Dimensions
  • Label: Projects

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: webservices/processxml.asmx
  • XML topic: PRJ

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 Projects 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
BEGINPERIOD int16 Begin Period /dimension/beginperiod
BEGINYEAR int16 Begin Year /dimension/beginyear
BEHAVIOUR varchar2 Behaviour /dimension/behaviour
COCNUMBER varchar2 CoC Number /dimension/cocnumber
CODE varchar2 Code /dimension/code
COMPANY_CODE varchar2 Company ID
COMPANY_NAME varchar2 Company Name
EDITDIMENSIONNAME char Edit Dimension Name /dimension/editdimensionname
ENDPERIOD int16 End Period /dimension/endperiod
ENDYEAR int16 End Year /dimension/endyear
FINANCIALS_ACCOUNTTYPE varchar2 Account Type /dimension/financials/accounttype
FINANCIALS_COLLECTIONSCHEMA varchar2 Collection Schema /dimension/financials/collectionschema
FINANCIALS_COLLECTMANDATE_ID varchar2 Collect Mandate ID /dimension/financials/collectmandate/id
FINANCIALS_COLLECTMANDATE_SIGNATUREDATE datetime Collect Mandate Signature Date /dimension/financials/collectmandate/signaturedate
FINANCIALS_CREDITMANAGEMENT_BASECREDITLIMIT decimal Base Credit Limit /dimension/financials/creditmanagement/basecreditlimit
FINANCIALS_CREDITMANAGEMENT_BLOCKED char Blocked /dimension/financials/creditmanagement/blocked
FINANCIALS_CREDITMANAGEMENT_BLOCKED_LOCKED char Blocked/Locked /dimension/financials/creditmanagement/blocked/locked
FINANCIALS_CREDITMANAGEMENT_BLOCKED_MODIFIED varchar2 Blocked Modified /dimension/financials/creditmanagement/blocked/modified
FINANCIALS_CREDITMANAGEMENT_COMMENT varchar2 Comment /dimension/financials/creditmanagement/comment
FINANCIALS_CREDITMANAGEMENT_FREETEXT1 varchar2 Free Text 1 /dimension/financials/creditmanagement/freetext1
FINANCIALS_CREDITMANAGEMENT_FREETEXT2 varchar2 Free Text 2 /dimension/financials/creditmanagement/freetext2
FINANCIALS_CREDITMANAGEMENT_FREETEXT3 varchar2 Free Text 3 /dimension/financials/creditmanagement/freetext3
FINANCIALS_CREDITMANAGEMENT_REMINDEREMAIL varchar2 Reminder Email /dimension/financials/creditmanagement/reminderemail
FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER varchar2 Responsible User /dimension/financials/creditmanagement/responsibleuser
FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER_NAME varchar2 Responsible User Name /dimension/financials/creditmanagement/responsibleuser/name
FINANCIALS_CREDITMANAGEMENT_RESPONSIBLEUSER_SHORTNAME varchar2 Responsible User Short Name /dimension/financials/creditmanagement/responsibleuser/shortname
FINANCIALS_CREDITMANAGEMENT_SENDREMINDER char Send Reminder /dimension/financials/creditmanagement/sendreminder
FINANCIALS_DUEDAYS int32 Due Days /dimension/financials/duedays
FINANCIALS_EBILLING char Ebilling /dimension/financials/ebilling
FINANCIALS_EBILLMAIL varchar2 Ebill Mail /dimension/financials/ebillmail Email address to send the invoice to.
FINANCIALS_LEVEL int16 Level /dimension/financials/level
FINANCIALS_MATCHTYPE varchar2 Match Type /dimension/financials/matchtype
FINANCIALS_MEANSOFPAYMENT varchar2 Means of Payment /dimension/financials/meansofpayment
FINANCIALS_PAYAVAILABLE char Pay Available /dimension/financials/payavailable
FINANCIALS_PAYCODE varchar2 Pay Code /dimension/financials/paycode
FINANCIALS_PAYCODE_NAME varchar2 Pay Code Name /dimension/financials/paycode/name
FINANCIALS_PAYCODE_SHORTNAME varchar2 Pay Code Short Name /dimension/financials/paycode/shortname
FINANCIALS_RELATIONSREFERENCE varchar2 Relations Reference /dimension/financials/relationsreference Customer reference, your customer number by the supplier.
FINANCIALS_SUBANALYSE varchar2 Sub-analyse /dimension/financials/subanalyse
FINANCIALS_SUBSTITUTEWITH varchar2 Substitute with /dimension/financials/substitutewith
FINANCIALS_SUBSTITUTEWITH_DIMENSIONTYPE varchar2 Substitute with Dimension Type /dimension/financials/substitutewith/dimensiontype
FINANCIALS_SUBSTITUTEWITH_ID guid Substitute with ID /dimension/financials/substitutewith/id
FINANCIALS_SUBSTITUTEWITH_NAME varchar2 Substitute with Name /dimension/financials/substitutewith/name
FINANCIALS_SUBSTITUTEWITH_SHORTNAME varchar2 Substitute with Short Name /dimension/financials/substitutewith/shortname
FINANCIALS_SUBSTITUTIONLEVEL int16 Substitution Level /dimension/financials/substitutionlevel
FINANCIALS_VATCODE varchar2 VAT Code /dimension/financials/vatcode
FINANCIALS_VATCODE_FIXED varchar2 {res:itgen_twinfield_financials_vatcode/fixed} /dimension/financials/vatcode/fixed
FINANCIALS_VATCODE_NAME varchar2 {res:itgen_twinfield_financials_vatcode/name} /dimension/financials/vatcode/name
FINANCIALS_VATCODE_SHORTNAME varchar2 {res:itgen_twinfield_financials_vatcode/shortname} /dimension/financials/vatcode/shortname
FINANCIALS_VATCODE_TYPE varchar2 {res:itgen_twinfield_financials_vatcode/type} /dimension/financials/vatcode/type
FINANCIALS_VATOBLIGATORY char VAT Obligatory /dimension/financials/vatobligatory
FINANCIALS_VATTYPE varchar2 VAT Type /dimension/financials/vattype
FINANCIALS_VATTYPE_NAME varchar2 VAT Type Name /dimension/financials/vattype/name
FINANCIALS_VATTYPE_SHORTNAME varchar2 VAT Type Short Name /dimension/financials/vattype/shortname
INUSE char In Use /dimension/inuse Have financial transactions been posted to this dimension.
MODIFIED datetime Modified /dimension/modified
NAME varchar2 Name /dimension/name
PROJECTS_AUTHORISER varchar2 Authoriser /dimension/projects/authoriser
PROJECTS_AUTHORISER_INHERIT char Projects Authoriser Inherit /dimension/projects/authoriser/inherit
PROJECTS_AUTHORISER_LOCKED char Projects Authoriser Locked /dimension/projects/authoriser/locked
PROJECTS_BILLABLE char Billable /dimension/projects/billable
PROJECTS_BILLABLE_FORRATIO char Billable for Ratio /dimension/projects/billable/forratio
PROJECTS_BILLABLE_INHERIT char Projects Billable Inherit /dimension/projects/billable/inherit
PROJECTS_BILLABLE_LOCKED char Projects Billable Locked /dimension/projects/billable/locked
PROJECTS_CUSTOMER varchar2 Customer /dimension/projects/customer
PROJECTS_CUSTOMER_INHERIT char Projects Customer Inherit /dimension/projects/customer/inherit
PROJECTS_CUSTOMER_LOCKED char Projects Customer Locked /dimension/projects/customer/locked
PROJECTS_INVOICEDESCRIPTION varchar2 Invoice Description /dimension/projects/invoicedescription
PROJECTS_RATE varchar2 Rate /dimension/projects/rate The project (quantity) rate code.
PROJECTS_RATE_INHERIT char Projects Rate Inherit /dimension/projects/rate/inherit
PROJECTS_RATE_LOCKED char Projects Rate Locked /dimension/projects/rate/locked
PROJECTS_VALIDFROM datetime Valid from /dimension/projects/validfrom
PROJECTS_VALIDTILL varchar2 Valid till /dimension/projects/validtill
REMITTANCEADVICE_SENDMAIL varchar2 Send Mail /dimension/remittanceadvice/sendmail
REMITTANCEADVICE_SENDTYPE varchar2 Send Type /dimension/remittanceadvice/sendtype
SHORTNAME varchar2 Short Name /dimension/shortname
STATUS varchar2 Status /dimension/status
TOUCHED int16 Touched /dimension/touched
UID guid UID /dimension/uid
VATNUMBER varchar2 VAT Number /dimension/vatnumber
WEBSITE varchar2 Website /dimension/website

Keys

Key Column Refers to Kind Description
Projects_COMPANY_CODE_fk COMPANY_CODE Offices.code Key

Referenced By

Release Notes

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