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_utc | datetime | NOT NULL | |
create_date_utc | 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 |