invantive documentation
Invantive Support ForumsLog In / Sign Up

OfficeSettingsByCode: Twinfield Company Settings by Code

read only per partition XML

  • Catalog: Twinfield
  • Schema: Settings
  • Primary Keys: code
  • Label: Company Settings by Code

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

Can only retrieve data.

Summary

Settings of one company, named by code. Every company is answered by the view OfficeSettings.

API Source

  • XML service: webservices/processxml.asmx
  • XML topic: office
  • XML path: /office

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 341

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
code `` Code of the company to read the settings of.
COMPANY_CODE `` Code of company.

Table Columns

The columns of the table OfficeSettingsByCode 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
ACCOUNTSPAYABLE varchar2 Accounts Payable Account /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/systemdimensions/accountspayable General ledger account the suppliers are booked on.
ACCOUNTSRECEIVABLE varchar2 Accounts Receivable Account /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/systemdimensions/accountsreceivable General ledger account the customers are booked on.
ADDRESS_CITY varchar2 City /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/city
ADDRESS_COUNTRY varchar2 Country /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/country
ADDRESS_COUNTRY_NAME varchar2 Country Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/country/name
ADDRESS_FIELD1 varchar2 Address Field 1 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/field1
ADDRESS_FIELD2 varchar2 Address Field 2 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/field2
ADDRESS_FIELD3 varchar2 Address Field 3 /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/field3
ADDRESS_POSTCODE varchar2 Postcode /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/postcode
ADDRESS_TELEPHONE varchar2 Telephone /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/address/telephone
ALLOWMULTIPLECONTROLACCOUNTS char Allow Multiple Control Accounts /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/allowmultiplecontrolaccounts
BASECURRENCY varchar2 Base Currency /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/basecurrency
CLOSEPNL varchar2 Close Profit and Loss Account /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/systemdimensions/closepnl
COCNUMBER varchar2 CoC Number /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/cocnumber
CODE varchar2 Code /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/code
COMPANY_CODE varchar2 Company ID
COMPANY_NAME varchar2 Company Name
CREATED datetime Created /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/created
CREDITORIDENTIFIER varchar2 Creditor Identifier /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/creditoridentifier Identifier used on a SEPA direct debit.
CURRENTPERIOD int32 Current Period /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/currentperiod
CURRENTYEAR int32 Current Year /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/currentyear
DAYSAFTERDUEDATE int32 Days After Due Date /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/creditmanagement/daysafterduedate Credit management: days after the due date before an invoice is listed.
DAYSAFTERDUEDATEVALUE decimal Days After Due Date Value /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/creditmanagement/daysafterduedatevalue
DAYSAFTERPARTPAYMENT int32 Days After Part Payment /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/creditmanagement/daysafterpartpayment
DEFAULTBANK varchar2 Default Bank /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/defaultbank
DEFAULTMATCHING varchar2 Default Matching /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/defaultmatching
DEMO char Demo /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/demo Whether the company serves training purposes only.
EDITDIMENSIONNAME char Edit Dimension Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/editdimensionname
HIERARCHY varchar2 Reporting Structure /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/hierarchy
LASTCLOSEDYEAR int32 Last Closed Year /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/lastclosedyear Financial year up to and including which the books are closed.
MODIFIED datetime Modified /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/modified
NAME varchar2 Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/name
NUMBEROFPERIODS int32 Number of Periods /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/numberofperiods
OPENINGBALANCE varchar2 Opening Balance Account /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/systemdimensions/openingbalance
PAYMENTDISCOUNT varchar2 Payment Discount /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/paymentdiscount
REGION varchar2 Region /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/region
REPORTINGCURRENCY varchar2 Reporting Currency /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/reportingcurrency
SCHEME varchar2 Scheme /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/scheme Either invoice or cash, being when VAT falls due.
SHORTNAME varchar2 Short Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/shortname
SOLETRADERVATNUMBER varchar2 Sole Trader VAT Number /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/soletradervatnumber
STATUS varchar2 Status /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/status
SUSPENCEACCOUNT varchar2 Suspense Account /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/systemdimensions/suspenceaccount
TOUCHED int32 Touched /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/touched
TYPE varchar2 Type /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/type
USER varchar2 User /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/user User who created or last changed the company.
USER_NAME varchar2 User Name /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/user/name
VATNUMBER varchar2 VAT Number /soap:Envelope/soap:Body/tns:ProcessXmlDocumentResponse/tns:ProcessXmlDocumentResult/office/general/vatnumber

Release Notes

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

Changes of This Table, 26.0 to 27.0

Table function Twinfield.Settings.OfficeSettingsByCode is added

The table function has 47 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0