Table: GL_Entry_Export_Option
Columns
Name | Type | Constraints | Description
gl_entry_export_option_KEY | int | NOT NULL |
firm_KEY | int | NOT NULL |
gl_entry_export_accounting_method_KEY | int | NOT NULL |
time_expense__gl_entry_export_bill_amount_basis_KEY | int | NOT NULL |
progress_bill__gl_entry_export_bill_amount_basis_KEY | int | NOT NULL |
gl_entry_export_tax_basis_KEY | int | NOT NULL |
time_expense_gl_account | nvarchar (60) | NOT NULL |
progress_bill_gl_account | nvarchar (60) | NOT NULL |
tax_gl_account | nvarchar (60) | NOT NULL |
receipts_gl_account | nvarchar (60) | NOT NULL |
accounts_receivable_gl_account | nvarchar (60) | NOT NULL |
service_charges_gl_account | nvarchar (60) | NOT NULL |
credit_memos_gl_account | nvarchar (60) | NOT NULL |
debit_memos_gl_account | nvarchar (60) | NOT NULL |
write_off_gl_account | nvarchar (60) | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
unapplied_receipts_gl_account | nvarchar (60) | NOT NULL |

Primary key
Name | Columns | Description
PK_GL_Entry_Export_Option$gl_entry_export_option_KEY | gl_entry_export_option_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_GL_Entry_Export_Option__firm_KEY | firm_KEY | There can only be one GL_Entry_Export_Option record per firm.
Indexes
Name | Columns | Description
IX_GL_Entry_Export_Option$gl_entry_export_accounting_method_KEY | gl_entry_export_accounting_method_KEY | Index 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_KEY | gl_entry_export_tax_basis_KEY | Index 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_KEY | progress_bill__gl_entry_export_bill_amount_basis_KEY | Index 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_KEY | time_expense__gl_entry_export_bill_amount_basis_KEY | Index 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
Name | Columns | Referenced table | Description
FK_GL_Entry_Export_Option__Firm__firm_KEY | firm_KEY | Firm |
FK_GL_Entry_Export_Option__GL_Entry_Export_Accounting_Method__gl_entry_export_accounting_method_KEY | gl_entry_export_accounting_method_KEY | GL_Entry_Export_Accounting_Method |
FK_GL_Entry_Export_Option__GL_Entry_Export_Bill_Amount_Basis__progress_bill__gl_entry_export_bill_amount_basis_KEY | progress_bill__gl_entry_export_bill_amount_basis_KEY | GL_Entry_Export_Bill_Amount_Basis |
FK_GL_Entry_Export_Option__GL_Entry_Export_Bill_Amount_Basis__time_expense__gl_entry_export_bill_amount_basis_KEY | time_expense__gl_entry_export_bill_amount_basis_KEY | GL_Entry_Export_Bill_Amount_Basis |
FK_GL_Entry_Export_Option__GL_Entry_Export_Tax_Basis__gl_entry_export_tax_basis_KEY | gl_entry_export_tax_basis_KEY | GL_Entry_Export_Tax_Basis |