OfficeSettings: Twinfield Company Settings
read only
- Catalog:
Twinfield - Schema:
Views - Label: Company Settings
Can only retrieve data.
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 OfficeSettings 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 | General ledger account the suppliers are booked on. | ||
ACCOUNTSRECEIVABLE |
varchar2 |
Accounts Receivable Account | General ledger account the customers are booked on. | ||
ADDRESS_ |
varchar2 |
City | |||
ADDRESS_ |
varchar2 |
Country | |||
ADDRESS_ |
varchar2 |
Country Name | |||
ADDRESS_ |
varchar2 |
Address Field 1 | |||
ADDRESS_ |
varchar2 |
Address Field 2 | |||
ADDRESS_ |
varchar2 |
Address Field 3 | |||
ADDRESS_ |
varchar2 |
Postcode | |||
ADDRESS_ |
varchar2 |
Telephone | |||
ALLOWMULTIPLECONTROLACCOUNTS |
char |
Allow Multiple Control Accounts | |||
BASECURRENCY |
varchar2 |
Base Currency | |||
CLOSEPNL |
varchar2 |
Close Profit and Loss Account | |||
COCNUMBER |
varchar2 |
CoC Number | |||
CODE |
varchar2 |
Code | |||
COMPANY_ |
varchar2 |
Company ID | |||
COMPANY_ |
varchar2 |
Company Name | |||
CREATED |
datetime |
Created | |||
CREDITORIDENTIFIER |
varchar2 |
Creditor Identifier | Identifier used on a SEPA direct debit. | ||
CURRENTPERIOD |
int32 |
Current Period | |||
CURRENTYEAR |
int32 |
Current Year | |||
DAYSAFTERDUEDATE |
int32 |
Days After Due Date | Credit management: days after the due date before an invoice is listed. | ||
DAYSAFTERDUEDATEVALUE |
decimal |
Days After Due Date Value | |||
DAYSAFTERPARTPAYMENT |
int32 |
Days After Part Payment | |||
DEFAULTBANK |
varchar2 |
Default Bank | |||
DEFAULTMATCHING |
varchar2 |
Default Matching | |||
DEMO |
char |
Demo | Whether the company serves training purposes only. | ||
EDITDIMENSIONNAME |
char |
Edit Dimension Name | |||
HIERARCHY |
varchar2 |
Reporting Structure | |||
LASTCLOSEDYEAR |
int32 |
Last Closed Year | Financial year up to and including which the books are closed. | ||
MODIFIED |
datetime |
Modified | |||
NAME |
varchar2 |
Name | |||
NUMBEROFPERIODS |
int32 |
Number of Periods | |||
OPENINGBALANCE |
varchar2 |
Opening Balance Account | |||
PAYMENTDISCOUNT |
varchar2 |
Payment Discount | |||
REGION |
varchar2 |
Region | |||
REPORTINGCURRENCY |
varchar2 |
Reporting Currency | |||
SCHEME |
varchar2 |
Scheme | Either invoice or cash, being when VAT falls due. | ||
SHORTNAME |
varchar2 |
Short Name | |||
SOLETRADERVATNUMBER |
varchar2 |
Sole Trader VAT Number | |||
STATUS |
varchar2 |
Status | |||
SUSPENCEACCOUNT |
varchar2 |
Suspense Account | |||
TOUCHED |
int32 |
Touched | |||
TYPE |
varchar2 |
Type | |||
USER |
varchar2 |
User | User who created or last changed the company. | ||
USER_ |
varchar2 |
User Name | |||
VATNUMBER |
varchar2 |
VAT Number |
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
View Twinfield.Views.OfficeSettings is added
The view has 47 columns and can select.
- importance 3