Table: CompanyInfo
Company Information and Settings
| Name | Type | Description | Remarks |
|---|---|---|---|
| DEFAULT_COMPANY_ID |
| Name | Type | Description | Remarks |
|---|---|---|---|
| AdditionalCoatingMessageOption | GenLookup Additional Coating Message Option |
||
| AdditionalColorMessageOption | Additional Color Message Option |
||
| AdminAccessLevel | Administrative Access Level |
||
| AllowCLDiagnosticAutoOrder |
bit |
Value for checkbox: "Allow CL Diagnostic Auto Order" |
|
| AllowMultiplePackage |
bit |
Value of checkbox: "Allow Multiple Package" |
|
| AllowNegativeOnHandQuantity |
bit |
Value for checkbox: "Allow Negative OnHand Quantity" |
|
| AllowPOForRetailOfficeByDC |
bit |
value for checkbox: "Allow PO For Retail Office By DC" |
|
| AllowVspLabProvidedFrame |
bit |
Setting for whether to allow Frame Source of "Provided By" for VSP Lab orders. |
|
| AppointmentAutoConfirmDays |
int |
Value for "Auto Confirm Appt. Days" |
|
| AuditLoglevel | Audit Log Level Indicator |
||
| AutoSendCLAutoOfficeOrders |
bit |
Value for checkbox: "Auto Send CL Auto Office Orders" |
|
| AutoSendCLPatientOfficeOrders |
bit |
Value for checkbox: "Auto Send CL Patient Office Orders" |
|
|
Providername |
varchar(50) |
Name to use as the Billing Provider |
|
|
ProviderAddressID |
int |
The Address ID of the Billing Provider. |
ProviderAddressID is the foreign key to the Address table. |
| CaptureLast4andExpDate |
bit |
Value for checkbox "Capture Last 4 and Exp Date" |
|
| CentralizedInventory |
bit |
Valcue for checkbox: "Central Inventory" |
|
| CLExpirationMonth | |||
| CMS1500LeftOffset |
int |
Left Margin Offset for CMS-1500 |
|
| CMS1500TopOffset |
int |
Top Margin Offset for CMS-1500 |
|
| CombineBifocalSplitPD |
bit |
Value for checkbox: "Combine Bifocal Split PD" |
|
| CombinePatientForms |
bit |
Value for checkbox "Combine Patient Forms" |
|
| CommissionMethod |
int |
Commission Calculation Method. |
1=SPIFF, 2=Sales per Hour |
| CompanyAddress |
int |
Company Address ID |
CompanyAddressId is a foreign key reference to the Address table for the address of the company. |
| CompanyDoctor |
int |
ID of the Company Doctor |
CompanyDoctor is a foreign key to the Employee table. |
| CompanyLabs | |||
| CompanyName |
varchar(100) |
Company Name |
|
| CompanyPriceList | |||
| CompanyType | Special Company Type |
See CompanyType |
|
| ContactInfo |
varchar(100) |
Contact Name |
|
| ContactPhone |
varchar(14) |
Contact Phone |
|
| CreateStockOrderOnTransfer |
bit |
Indicator for checkbox: "Replenish stock on Transfer" |
|
| DataSourceId | Data Source for the company Record |
See DataSourceType |
|
| DefaultDepositPercent |
int |
The percentage of sale required as a deposit to release an order. |
|
| DistributionCenter |
varchar(8) |
The Office Number of the primary Distribution Center. |
|
| EGExpirationMonth |
int |
Default EG Expiration (month) |
|
| EHRSystem | Value for EHR System type |
See EHRSystemEnum |
|
| EmployeeNumberRequired |
bit |
Value for checkbox "Employee Number Required" |
|
| EmployeePreference | |||
| EMRExamWriter |
bit |
EMR Checkbox setting for "Send Patient Demographics to ExamWRITER" |
|
| EMREyefinityEHR |
bit |
EMR Checkbox setting for "Send Patient Demographics to Eyefinity EHR" |
|
| EnableBatchEDIProcessing |
bit |
Value for checkbox "Enable Batch EDI Processing" |
|
| EnableServiceLocationFeature |
bit |
Enable Service Location Feature |
|
| EncryptionStatus | |||
| EnforceRxExpiration |
bit |
Value for checkbox: "Enforce Rx Expiration" |
|
| EtimeManagementByAll |
bit |
Value of checkbox: "Etime Management By All" |
|
| EyefinityEHRDomain |
varchar(100) |
Eyefinity EHR Domain |
|
| EyefinityEHRExamUrl |
varchar(500) |
Eyefinity EHR Exam URL |
|
| EyefinityEHRHran |
varchar(100) |
Eyefinity EHR Health Record Account Number |
|
| EyefinityEHRPassword | |||
| EyefinityEHRPasswordDB | |||
| EyefinityEHRUsername |
varchar(50) |
Eyefinity EHR User name |
|
| GeneralEncryption | |||
| GetCompanyAddressTrimmed | |||
| GetRemitAddress | |||
| GetRemitAddressTrimmed | |||
| GLCenter |
varchar(10) |
The value to use in General Ledger Export for the company-level Center Code |
|
| GLInterfacePackage |
int |
General Ledger Interface Package |
GLInterfacePackage is a foreign key reference to CatElementLU of type 73 |
| HideListPrice |
bit |
Value of checkbox: "Hide List Price" |
|
| HomePageUrl |
varchar(128) |
The URL for the AcuityLogic home page. |
|
| ICD10ActivationDate |
datetime |
ICD-10 Activation Date |
|
| IgnoreZeroRetailOnBP |
bit |
Value for checkbox "Ignore Zero Retail Items on Bulk Pricing" |
|
| InitialAuthentication |
bit |
Value for checkbox: "Initial Authentication" |
|
| InvCreateDateLimit |
int |
Number of days before Inventory Create Session Allowed |
|
| InventoryCountMethod |
int |
Method for performing Physical Inventory counting. |
|
| InventoryValuationMethod |
int |
Inventory Valuation Method |
|
| InvoiceCaption |
varchar(500) |
Invoice Caption text to be printed on the patient invoice. |
|
| IsDiscountLicenseFrame |
bit |
Value for checkbox: "Discount License Frame" |
|
| IsOnFrameSpex |
bit |
Indicator for whether "On Frame Spex" is checked. |
|
| IsValidateODOnRxExamSale |
bit |
Value for checkbox "Validate OD On Rx/Exam Sale" |
|
| IsVisionMedicalSeparateInv |
bit |
Value of checkbox: "Prohibit medical and vision ins on same invoice" |
|
| LabSystemVersion | |||
| MedicalConditionRequired |
bit |
Setting for whehter Medical Condition checkbox options are required when entering an exam. |
|
| NationalProviderId |
varchar(20) |
Default National Provider ID number for the company (NPI) |
|
| NoCouponValidation | Value of checkbox: "No Coupon Validation" |
||
| NoCreditCardValidation |
bit |
Value for Checkbox: "No Credit Card Validation" |
|
| NoDeliveryWithBalance |
bit |
Value for Checkbox: "No Delivery With Balance" |
|
| PackageDisplayType | Package Display Type setting |
NULL=Default; 1=Accumulate |
|
| PasswordPolicy | Value for Company Password Policy |
PasswordPolicy is a foreign key to the PasswordPolicy table. |
|
| PatientInsuranceReadOnly | |||
| PatientProfileReadOnly |
bit |
Indicator for whether Patient Profile Information is limited to Read-Only mode for the company. |
|
| PatientSearchType | Option for "Use Search Button for Patient Search" |
||
| PhysicalInventorySort |
int |
The sorting method to be used for count sheets in a Frame Physical Inventory |
1=Item Name, 2= Collection |
| PriceRoundingOption | Frame Markup Rounding Option |
Null=Default 1=Round to Nearest Nine 2=Round to Nearest Nine Ninety Five |
|
| PrintCPTCodesOnInvoice |
bit |
Value for checkbox "Print CPT Codes on Invoice" |
|
| PrintFrameTags |
int |
Setting for "Print Frame Tags" |
0 = Default; 1 = Print Frame Tags by Item Group. |
| PrintVendorName |
bit |
Value for checkbox: "Print Vendor Name on Frame Tag" |
|
| RecordODForNonRxOrder |
bit |
Value for checkbox: "Record OD For Non-Rx Order" |
|
|
RemitAddressID |
int |
Address ID for the company Remit To address. |
RemitAddressID is a foreign key reference to the Address table. |
| RemitName |
varchar(50) |
Remit To Name |
|
| RemoteDCLookup | Value for checkbox: "Remote DC Lookup" |
||
| RequireOCHeight |
bit |
Value for checkbox "Require OC Height" |
|
| ScheduleApptforotherOffices |
bit |
Value of checkbox: "Schedule Appointment for other Offices" |
|
| SessionTimeout |
int |
Number of minutes for session to auto-timeout. |
|
| ShowCommission |
bit |
Value for Checkbox: "Show Commission" |
|
| ShowCostOnPOSInvRpt | |||
| ShowDrReimbInVSPCalculation |
bit |
Value for checkbox: "Show Dr. Reimb in VSP Calc" |
|
| ShowInvoiceRxAlert |
bit |
Value for checkbox: "Show Invoice Rx Alert" |
|
| ShowProductivity |
bit |
Vlaue for Checkbox: "Show Productivity" |
|
| SMTPEmail |
varchar(200) |
SMTP Server Email |
|
| SMTPEmailAuth | Value for checkbox: "Use Authentication" in SMTP section. |
||
| SMTPPassword | |||
| SMTPPasswordDB | |||
| SMTPPort |
int |
SMTP Port |
|
| SMTPRetryBeforeSendEmails |
int |
SMTP Setting "Retry between send e-mails" |
|
| SMTPServer |
varchar(200) |
SMTP Server Address |
|
| SMTPUserName |
varchar(200) |
SMTP User Name |
|
| TaxID |
varchar(50) |
Tax ID Number for the company |
|
| TimeElapsedToCheck |
int |
SMTP Setting for "Check xlink failures (minutes)" |
|
| UseBookIncentives | KPI Comission setting: Use Book Incentive (invoice date vs delivery date) |
||
| UseBookSales | |||
| VSLabAccountLength |
int |
VisionStar setting for Account Length |
|
| VSPUseFrameLabName |