companysetup

Type: table

Columns

Column	Type	Attributes	Description
accountclassvalidationtype	varchar
accumdepreciationaccountrowid	int
accumdepreciationclassrowid	int
acknowledgementprintscriptrowid	int
allowcommitmenttracking	smallint
allowcommitmenttrackingoverride	smallint
allowcreditcardprocessing	smallint
allowcreditholdoverride	smallint
allowcustomercurrencyidoverride	smallint
allowcustomercurrencyratetypeidoverride	smallint
allowcustomerpricelevelidoverride	smallint
allowencumbrancetracking	smallint
allowencumbrancetrackingoverride	smallint
allowjournalbillabletransactions	smallint
allowlotserialnbrtracking	smallint
allowmulticurrencyentry	smallint
allowmultiplecurrencyitemsalesprices	smallint
allownegativeinventory	smallint
allowpayablesitemaccountidoverride	smallint
allowpostedtransactionmodifications	smallint
allowpurchasinglastcostupdate	smallint
allowreceivablesitemaccountidoverride	smallint
allowsitelocationtracking	smallint
allowvendorcurrencyidoverride	smallint
allowvendorcurrencyratetypeidoverride	smallint
allowzerobilltransactionamount	smallint
apaccountrowid	int
apallowadditionaltransactions	smallint
apcurrencyrateselectiondatetype	varchar
apcurrencyratetyperowid	int
apoffsetvarianceaccountrowid	int
appaymentaccountrowid	int
appaymentmethodlistitemrowid	int
araccountrowid	int
arcurrencyrateselectiondatetype	varchar
arcurrencyratetyperowid	int
arpaymentaccountrowid	int
arpaymentmethodlistitemrowid	int
arpaymentsetasundepositedbydefault	smallint
assetaccountrowid	int
assetclassrowid	int
autoincrementbilltransactionid	smallint
autoincrementcustomeraffiliateid	smallint
autoincrementleadaffiliateid	smallint
autoincrementvendoraffiliateid	smallint
balancingaccountkeysegmentrowid	int
balancingclasskeysegmentrowid	int
balancingentitytyperowid	int
basecurrencyrowid	int
billofladingprintscriptrowid	int
budgetcurrencyratetyperowid	int
checkbudgetcontrolatentry	smallint
checkbudgetcontrolatsave	smallint
checkcreditlimitforestimate	smallint
checkcreditlimitforinvoice	smallint
checkcreditlimitforsalesorder	smallint
checkforduplicatepurchaseorder	smallint
checkprintscriptrowid	int
checksmarkedtoprintbydefault	smallint
city	varchar
closearlineitemswhentransactionisclosed	smallint
closepolineitemswhentransactionisclosed	smallint
commitmentreserveaccountrowid	int
companyid	varchar
companykeysegmentvalidationrowid	int
companyname	varchar
companyrowid	int
companyuid	varchar
comparecreditlimittoestimatetotal	smallint
comparecreditlimittoinvoicetotal	smallint
comparecreditlimittosalesordertotal	smallint
costofsalesaccountcategoryrowid	int
costofsalesaccountrowid	int
costofsalesclassrowid	int
costofsalesoffsetaccountrowid	int
costofsalesoffsetclassrowid	int
country	varchar
creditcardrefunditemrowid	int
customerdiscountaccountrowid	int
customerdiscountclassrowid	int
customertermrowid	int
defaultclassrowid	int
deferredrevenueaccountcategoryrowid	int
deferredrevenueaccountrowid	int
deferredrevenueclassrowid	int
depositaccountcategoryrowid	int
depositaccountrowid	int
depositclassrowid	int
depreciationexpenseaccountrowid	int
depreciationexpenseclassrowid	int
depreciationmethod	varchar
depreciationpostingcycle	varchar
descriptiondefault	varchar
displaybalanceinlistscreen	smallint
emailaddress	varchar
encumbrancereserveaccountrowid	int
enterjournalunits	smallint
enteropeningbalance	smallint
estimateprintscriptrowid	int
faxnbr	varchar
fein	varchar
filteraccountsbytype	smallint
fiscalmonth	smallint
fiscalperiodclosedate	datetime
fiscalyear	varchar
fiscalyearclosedate	datetime
glcurrencyratetyperowid	int
includedocamountinapduplicatechecking	smallint
includedocidinapduplicatechecking	smallint
includeqtyonestimateinqtyavailable	smallint
includeqtyonpurchaseorderinqtyavailable	smallint
includeqtyonsalesorderinqtyavailable	smallint
includereferencedateinapduplicatechecking	smallint
includerolepolicyinapduplicatechecking	smallint
intercompanyaccountrowid	int
invoiceprintscriptrowid	int
iso639	varchar
itemreceiptapoffsetaccountrowid	int
lastapbatchnbr	int
lastarbatchnbr	int
lastcashsaledocnbr	int
lastcccustomerpaymentdocnbr	int
lastcccustomerpaymenttransactionidprefix	varchar
lastccrefundinvoicedocnbr	int
lastccrefundinvoicetransactionidsuffix	varchar
lastcontractdocnbr	int
lastcontractdocnbrprefix	varchar
lastcustomeraffiliateidsuffix	varchar
lastcustomeraffiliatenbr	int
lastcustomerestimatedocnbr	int
lastcustomerreturndocnbr	int
lastfixedassetdocnbr	int
lastglbatchnbr	int
lastinbatchnbr	int
lastitemadjustmentdocnbr	int
lastitemreceiptdocnbr	int
lastitemsaledocnbr	int
lastjournalentrydocnbr	int
lastkitassemblydocnbr	int
lastleadaffiliateidprefix	varchar
lastleadaffiliatenbr	int
lastrecurringbilldocnbr	int
lastrecurringcreditmemodocnbr	int
lastrecurringinvoicedocnbr	int
lastrecurringjournalentrydocnbr	int
lastreportingonlyjournalentrydocnbr	int
lastrequisitiondocnbr	int
lastrmadocnbr	int
lastsalesorderdocnbr	int
lastvendoraffiliateidsuffix	varchar
lastvendoraffiliatenbr	int
lastvendordocnbr	int
leadcontactroletyperowid	int
legalcompanyname	varchar
partialyeardepreciationmethod	varchar
percentcompleteaccountcategoryrowid	int
phonenbr	varchar
purchaseordersmarkedasencumbrancesbydefault	smallint
qtyavailableprompt	varchar
reimbursableexpenseitemrowid	int
requireclasses	smallint
requirejobaccountcategory	smallint
requisitionsmarkedascommitmentsbydefault	smallint
retainedearningsaccountrowid	int
retentionaccountcategoryrowid	int
retentionaccountrowid	int
retentionclassrowid	int
retentionincludeother	smallint
retentionincludetax	smallint
revaluationcurrencyratetyperowid	int
revenueaccountcategoryrowid	int
revenueaccountrowid	int
revenueclassrowid	int
revenuerecognitionbasis	varchar
revenuerecognitionposting	varchar
rowid	int	auto_increment
salesordersourcerequired	smallint
salespricecurrencyratetyperowid	int
salestaxaccountcategoryrowid	int
saveapmemosatentitylevel	smallint
savearmemosatentitylevel	smallint
state	varchar
streetaddress	varchar
suppressqty	smallint
transactionstatussettoholdbydefault	smallint
unbilledaccountcategoryrowid	int
unbilledaccountrowid	int
unbilledclassrowid	int
unbilledfeeaccountcategoryrowid	int
unbilledfeeaccountrowid	int
unbilledfeeclassrowid	int
unbilledoverheadaccountcategoryrowid	int
unbilledoverheadaccountrowid	int
unbilledoverheadclassrowid	int
unbilledrevenueaccountcategoryrowid	int
unbilledrevenueaccountrowid	int
unbilledrevenueclassrowid	int
undepositedfundsaccountrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
useaccountids	smallint
useadvancedallocations	smallint
useadvancedsecurity	smallint
useauditnbrtracking	smallint
usebatches	smallint
usebudgetcontrol	smallint
usebudgets	smallint
usecashmanager	smallint
useclasses	smallint
usecreditlimitchecking	smallint
usecrm	smallint
usecustomernameasid	smallint
useemployeenameasid	smallint
useencumbrance	smallint
usefixedassets	smallint
usefundaccounting	smallint
useinventory	smallint
useitemshortdescriptionasid	smallint
usejobbudgets	smallint
usejobnameasid	smallint
usejobs	smallint
usejobtasks	smallint
usemulticurrency	smallint
usemultiplesites	smallint
useorderprocessing	smallint
useothernamenameasid	smallint
usepayables	smallint
usepurchasing	smallint
usereceivables	smallint
usereimbursableexpenseitemaccount	smallint
usereportwriter	smallint
userequisitions	smallint
usestateprovinceabbreviationcode	smallint
usetimeentry	smallint
usevendornameasid	smallint
useworkorder	smallint
validateaccountcategoryjob	smallint
validateclassesbyaccount	smallint
validatejobsbycustomer	smallint
vendordiscountaccountrowid	int
vendordiscountclassrowid	int
vendordiscountmethod	varchar
vendortermrowid	int
wipaccountcategoryrowid	int
wipaccountrowid	int
wipclassrowid	int
writeoffbalanceaccountrowid	int
writeoffbalanceclassrowid	int
writeoffmethod	varchar
zipcode	varchar

v.ismain -- Wed, Feb 28, 2018 2:58 PM