Table: dbo.Receivable_Transaction
Columns
NameTypeConstraintsDescription
receivable_transaction_KEYint (4)NOT NULLPrimary key
customer__client_KEYint (4)NOT NULLCurrently, this is the foreign key of the client being billed by the accountant. In the future, this key will be generalized to point to any customer that may have to be billed (a foreign key into a customer table). At that point, the firm client (accountant) will contain a customer record for all their clients and a regular client will contain customer records for those they do business with.
customer_namenvarchar (100)NOT NULLThe name of the customer at the time the receivable was created.
receivable_transaction_type_KEYint (4)NOT NULLDetermines the kind of receivable record ie. an invoice, a credit memo, etc. The system only supports client billing invoices at the moment.
transaction_status_KEYint (4)NOT NULLThe current state of the transaction ie. is it pending, has it been finalized, is it deleted, etc.
transaction_datesmalldatetime (4)NOT NULLNormally, this is the date the invoice was created; however, it can be overridden by the user.
reference_numbernvarchar (86)NOT NULLFor an invoice, the alphanumeric reference number can be automatically created by incrementing the last reference number used. The user can override this and even leave it blank. For other types of receivables, the contents of this field may be always set by the process or may completely be in the users control.
descriptionnvarchar (480)NOT NULLA description of the receivable. It can be left blank.
gross_amountdecimal (9, 2)NOT NULLThe total gross amount of the receivable which means it does not include any discount adjustments. This total always equals the sum of the receivable details.
gross_amount_overridedecimal (9, 2)An override of the total gross amount. This override amount does not have to equal the sum of the details. If the user hasn't overridden the gross amount, then this value is NULL.
discount_amountdecimal (9, 2)NOT NULLThe total amount of calculated discount available for this invoice.
discount_amount_overridedecimal (9, 2)A user override of the calculated discount amount. If the user didn't override the discount amount, then this value is NULL.
practice_cs_latest_export_datesmalldatetime (4)The date that the receivable transaction was last exported to Practice CS. If the date is null, then the transaction has never exported to Practice CS.
Primary key
NameColumnsDescription
PK_Receivable_Transactionreceivable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction__Client__customer__client_KEYcustomer__client_KEYClient (client_KEY)
FK_Receivable_Transaction__Receivable_Transaction_Type__receivable_transaction_type_KEYreceivable_transaction_type_KEYReceivable_Transaction_Type (receivable_transaction_type_KEY)
FK_Receivable_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYTransaction_Status (transaction_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Receivable_Transaction_Print_Option__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction_Print_Option
FK_Receivable_Transaction_Print_Override__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction_Print_Override
FK_Receivable_Transaction_Detail__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction_Detail
FK_Payable_Transaction_N_Receivable_Transaction__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYPayable_Transaction_N_Receivable_Transaction

Schema diagram