# 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://infinisuite.gitbook.io/sdk/data-model-and-schema/tables/companysetup.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.