Table: GL_Entry_Export_Option
Columns
NameTypeConstraintsDescription
gl_entry_export_option_KEYintNOT NULL
firm_KEYintNOT NULL
gl_entry_export_accounting_method_KEYintNOT NULL
time_expense__gl_entry_export_bill_amount_basis_KEYintNOT NULL
progress_bill__gl_entry_export_bill_amount_basis_KEYintNOT NULL
gl_entry_export_tax_basis_KEYintNOT NULL
time_expense_gl_accountnvarchar (60)NOT NULL
progress_bill_gl_accountnvarchar (60)NOT NULL
tax_gl_accountnvarchar (60)NOT NULL
receipts_gl_accountnvarchar (60)NOT NULL
accounts_receivable_gl_accountnvarchar (60)NOT NULL
service_charges_gl_accountnvarchar (60)NOT NULL
credit_memos_gl_accountnvarchar (60)NOT NULL
debit_memos_gl_accountnvarchar (60)NOT NULL
write_off_gl_accountnvarchar (60)NOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
unapplied_receipts_gl_accountnvarchar (60)NOT NULL
Primary key
NameColumnsDescription
PK_GL_Entry_Export_Option$gl_entry_export_option_KEYgl_entry_export_option_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_GL_Entry_Export_Option$firm_KEYfirm_KEYThere can only be one GL_Entry_Export_Option record per firm.
Indexes
NameColumnsDescription
IX_GL_Entry_Export_Option$gl_entry_export_accounting_method_KEYgl_entry_export_accounting_method_KEYIndex supports foreign key FK_GL_Entry_Export_Option__GL_Entry_Export_Accounting_Method__gl_entry_export_accounting_method_KEY
IX_GL_Entry_Export_Option$gl_entry_export_tax_basis_KEYgl_entry_export_tax_basis_KEYIndex supports foreign key FK_GL_Entry_Export_Option__GL_Entry_Export_Tax_Basis__gl_entry_export_tax_basis_KEY
IX_GL_Entry_Export_Option$progress_bill__gl_entry_export_bill_amount_basis_KEYprogress_bill__gl_entry_export_bill_amount_basis_KEYIndex supports foreign key FK_GL_Entry_Export_Option__GL_Entry_Export_Bill_Amount_Basis__progress_bill__gl_entry_export_bill_amount_basis_KEY
IX_GL_Entry_Export_Option$time_expense__gl_entry_export_bill_amount_basis_KEYtime_expense__gl_entry_export_bill_amount_basis_KEYIndex supports foreign key FK_GL_Entry_Export_Option__GL_Entry_Export_Bill_Amount_Basis__time_expense__gl_entry_export_bill_amount_basis_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Entry_Export_Option__Firm__firm_KEYfirm_KEYFirm

Schema diagram