Table: dbo.Receivable_Transaction_Print_Override
The table used to store overrides for unprinted Receivable Transaction during the printing process.
Columns
NameTypeConstraintsDescription
receivable_transaction_KEYint (4)NOT NULLPrimary Key field for Receivable_Transaction_Print_Override table.
transaction_datesmalldatetime (4)Override for the Receivable_Transaction transaction_date. A null value signifies that the field is not overriden.
reference_numbernvarchar (86)NOT NULLOverride for the Receivable_Transaction reference_number. An empty string signifies no override.
descriptionnvarchar (480)NOT NULLOverride for the Receivable_Transaction description. An empty string signifies no override.
invoice_layout__report_definition_KEYint (4)Override for the Receivable_Transaction_Print_Option invoice_layout__report_definition_KEY. A null value signifies no override.
Primary key
NameColumnsDescription
PK_Receivable_Transaction_Print_Override$receivable_transaction_KEYreceivable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction_Print_Override__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction (receivable_transaction_KEY)
FK_Receivable_Transaction_Print_Override__Report_Definition__invoice_layout__report_definition_KEYinvoice_layout__report_definition_KEYReport_Definition (report_definition_KEY)

Schema diagram