Table: dbo.AR_Invoice_Sort_By
Table to identify which field to sort by in invoices for Accounts Receivable
Columns
NameTypeConstraintsDescription
ar_invoice_sort_by_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (32)NOT NULLDescription of what to sort by
Primary key
NameColumnsDescription
PK_AR_Invoice_Sort_Byar_invoice_sort_by_KEY
Unique constraints
NameColumnsDescription
UK_AR_Invoice_Sort_By$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_AR_Setup__AR_Invoice_Sort_By__ar_invoice_sort_by_KEYar_invoice_sort_by_KEYClient_AR_Setup

Schema diagram