JDBC Driver for Exact Online

Build 22.0.8462

Accounts

Usage information for the operation Accounts.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table Accounts.

Accountant String False

The Accountant column for the table Accounts.

AccountManager String False

The AccountManager column for the table Accounts.

AccountManagerFullName String False

The AccountManagerFullName column for the table Accounts.

AccountManagerHID Int False

The AccountManagerHID column for the table Accounts.

ActivitySector String False

The ActivitySector column for the table Accounts.

ActivitySubSector String False

The ActivitySubSector column for the table Accounts.

AddressLine1 String False

The AddressLine1 column for the table Accounts.

AddressLine2 String False

The AddressLine2 column for the table Accounts.

AddressLine3 String False

The AddressLine3 column for the table Accounts.

Blocked Bool False

The Blocked column for the table Accounts.

BRIN String False

The BRIN column for the table Accounts.

BusinessType String False

The BusinessType column for the table Accounts.

CanDropShip Bool False

The CanDropShip column for the table Accounts.

ChamberOfCommerce String False

The ChamberOfCommerce column for the table Accounts.

City String False

The City column for the table Accounts.

Classification String False

The Classification column for the table Accounts.

Classification1 String False

The Classification1 column for the table Accounts.

Classification2 String False

The Classification2 column for the table Accounts.

Classification3 String False

The Classification3 column for the table Accounts.

Classification4 String False

The Classification4 column for the table Accounts.

Classification5 String False

The Classification5 column for the table Accounts.

Classification6 String False

The Classification6 column for the table Accounts.

Classification7 String False

The Classification7 column for the table Accounts.

Classification8 String False

The Classification8 column for the table Accounts.

ClassificationDescription String False

The ClassificationDescription column for the table Accounts.

Code String False

The Code column for the table Accounts.

CodeAtSupplier String False

The CodeAtSupplier column for the table Accounts.

CompanySize String False

The CompanySize column for the table Accounts.

ConsolidationScenario Int False

The ConsolidationScenario column for the table Accounts.

ControlledDate Datetime False

The ControlledDate column for the table Accounts.

Costcenter String False

The Costcenter column for the table Accounts.

CostcenterDescription String False

The CostcenterDescription column for the table Accounts.

CostPaid Int False

The CostPaid column for the table Accounts.

Country String False

The Country column for the table Accounts.

CountryName String False

The CountryName column for the table Accounts.

Created Datetime False

The Created column for the table Accounts.

Creator String False

The Creator column for the table Accounts.

CreatorFullName String False

The CreatorFullName column for the table Accounts.

CreditLinePurchase Double False

The CreditLinePurchase column for the table Accounts.

CreditLineSales Double False

The CreditLineSales column for the table Accounts.

Currency String False

The Currency column for the table Accounts.

CustomerSince Datetime False

The CustomerSince column for the table Accounts.

DatevCreditorCode String False

The DatevCreditorCode column for the table Accounts.

DatevDebtorCode String False

The DatevDebtorCode column for the table Accounts.

DiscountPurchase Double False

The DiscountPurchase column for the table Accounts.

DiscountSales Double False

The DiscountSales column for the table Accounts.

Division Int False

The Division column for the table Accounts.

Document String False

The Document column for the table Accounts.

DunsNumber String False

The DunsNumber column for the table Accounts.

Email String False

The Email column for the table Accounts.

EndDate Datetime False

The EndDate column for the table Accounts.

EstablishedDate Datetime False

The EstablishedDate column for the table Accounts.

Fax String False

The Fax column for the table Accounts.

GLAccountPurchase String False

The GLAccountPurchase column for the table Accounts.

GLAccountSales String False

The GLAccountSales column for the table Accounts.

GLAP String False

The GLAP column for the table Accounts.

GLAR String False

The GLAR column for the table Accounts.

HasWithholdingTaxSales Bool False

The HasWithholdingTaxSales column for the table Accounts.

IgnoreDatevWarningMessage Bool False

The IgnoreDatevWarningMessage column for the table Accounts.

IntraStatArea String False

The IntraStatArea column for the table Accounts.

IntraStatDeliveryTerm String False

The IntraStatDeliveryTerm column for the table Accounts.

IntraStatSystem String False

The IntraStatSystem column for the table Accounts.

IntraStatTransactionA String False

The IntraStatTransactionA column for the table Accounts.

IntraStatTransactionB String False

The IntraStatTransactionB column for the table Accounts.

IntraStatTransportMethod String False

The IntraStatTransportMethod column for the table Accounts.

InvoiceAccount String False

The InvoiceAccount column for the table Accounts.

InvoiceAccountCode String False

The InvoiceAccountCode column for the table Accounts.

InvoiceAccountName String False

The InvoiceAccountName column for the table Accounts.

InvoiceAttachmentType Int False

The InvoiceAttachmentType column for the table Accounts.

InvoicingMethod Int False

The InvoicingMethod column for the table Accounts.

IsAccountant Int False

The IsAccountant column for the table Accounts.

IsAgency Int False

The IsAgency column for the table Accounts.

IsBank Bool False

The IsBank column for the table Accounts.

IsCompetitor Int False

The IsCompetitor column for the table Accounts.

IsExtraDuty Bool False

The IsExtraDuty column for the table Accounts.

IsMailing Int False

The IsMailing column for the table Accounts.

IsMember Bool False

The IsMember column for the table Accounts.

IsPilot Bool False

The IsPilot column for the table Accounts.

IsPurchase Bool False

The IsPurchase column for the table Accounts.

IsReseller Bool False

The IsReseller column for the table Accounts.

IsSales Bool False

The IsSales column for the table Accounts.

IsSupplier Bool False

The IsSupplier column for the table Accounts.

Language String False

The Language column for the table Accounts.

LanguageDescription String False

The LanguageDescription column for the table Accounts.

Latitude Double False

The Latitude column for the table Accounts.

LeadPurpose String False

The LeadPurpose column for the table Accounts.

LeadSource String False

The LeadSource column for the table Accounts.

Logo Binary False

The Logo column for the table Accounts.

LogoFileName String False

The LogoFileName column for the table Accounts.

LogoThumbnailUrl String False

The LogoThumbnailUrl column for the table Accounts.

LogoUrl String False

The LogoUrl column for the table Accounts.

Longitude Double False

The Longitude column for the table Accounts.

MainContact String False

The MainContact column for the table Accounts.

Modified Datetime False

The Modified column for the table Accounts.

Modifier String False

The Modifier column for the table Accounts.

ModifierFullName String False

The ModifierFullName column for the table Accounts.

Name String False

The Name column for the table Accounts.

OINNumber String False

The OINNumber column for the table Accounts.

Parent String False

The Parent column for the table Accounts.

PayAsYouEarn String False

The PayAsYouEarn column for the table Accounts.

PaymentConditionPurchase String False

The PaymentConditionPurchase column for the table Accounts.

PaymentConditionPurchaseDescription String False

The PaymentConditionPurchaseDescription column for the table Accounts.

PaymentConditionSales String False

The PaymentConditionSales column for the table Accounts.

PaymentConditionSalesDescription String False

The PaymentConditionSalesDescription column for the table Accounts.

Phone String False

The Phone column for the table Accounts.

PhoneExtension String False

The PhoneExtension column for the table Accounts.

Postcode String False

The Postcode column for the table Accounts.

PriceList String False

The PriceList column for the table Accounts.

PurchaseCurrency String False

The PurchaseCurrency column for the table Accounts.

PurchaseCurrencyDescription String False

The PurchaseCurrencyDescription column for the table Accounts.

PurchaseLeadDays Int False

The PurchaseLeadDays column for the table Accounts.

PurchaseVATCode String False

The PurchaseVATCode column for the table Accounts.

PurchaseVATCodeDescription String False

The PurchaseVATCodeDescription column for the table Accounts.

RecepientOfCommissions Bool False

The RecepientOfCommissions column for the table Accounts.

Remarks String False

The Remarks column for the table Accounts.

Reseller String False

The Reseller column for the table Accounts.

ResellerCode String False

The ResellerCode column for the table Accounts.

ResellerName String False

The ResellerName column for the table Accounts.

RSIN String False

The RSIN column for the table Accounts.

SalesCurrency String False

The SalesCurrency column for the table Accounts.

SalesCurrencyDescription String False

The SalesCurrencyDescription column for the table Accounts.

SalesTaxSchedule String False

The SalesTaxSchedule column for the table Accounts.

SalesTaxScheduleCode String False

The SalesTaxScheduleCode column for the table Accounts.

SalesTaxScheduleDescription String False

The SalesTaxScheduleDescription column for the table Accounts.

SalesVATCode String False

The SalesVATCode column for the table Accounts.

SalesVATCodeDescription String False

The SalesVATCodeDescription column for the table Accounts.

SearchCode String False

The SearchCode column for the table Accounts.

SecurityLevel Int False

The SecurityLevel column for the table Accounts.

SeparateInvPerProject Int False

The SeparateInvPerProject column for the table Accounts.

SeparateInvPerSubscription Int False

The SeparateInvPerSubscription column for the table Accounts.

ShippingLeadDays Int False

The ShippingLeadDays column for the table Accounts.

ShippingMethod String False

The ShippingMethod column for the table Accounts.

StartDate Datetime False

The StartDate column for the table Accounts.

State String False

The State column for the table Accounts.

StateName String False

The StateName column for the table Accounts.

Status String False

The Status column for the table Accounts.

StatusSince Datetime False

The StatusSince column for the table Accounts.

TradeName String False

The TradeName column for the table Accounts.

Type String False

The Type column for the table Accounts.

UniqueTaxpayerReference String False

The UniqueTaxpayerReference column for the table Accounts.

VATLiability String False

The VATLiability column for the table Accounts.

VATNumber String False

The VATNumber column for the table Accounts.

Website String False

The Website column for the table Accounts.

LinkedBankAccounts String False

The LinkedBankAccounts column for the table Accounts.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462