View: dbo.AR_Transaction_View | |||
View definition | |||
-- This view surfaces all rows and columns from the AR table table. In addition, it provides two amount -- fields summed from each transaction�s distributions. This view is the read source for the AR transaction entity. CREATE VIEW dbo.AR_Transaction_View AS SELECT art.gl_transaction_KEY , art.customer_KEY , art.ar_transaction_type_KEY , art.transaction_status_KEY , art.transaction_date , art.reference_number , art.reference_number_sortable , art.message , art.payment_discount_amount_original , art.payment_discount_amount , art.payment_discount_amount_override , art.payment_term_KEY , art.due_date , art.purchase_order_number , art.purchase_order_number_sortable , art.gl_account_KEY , art.payment_discount_expiration_date , art.payment_discount__gl_account_KEY , art.shipping__contact_address_type_KEY , art.shipping_date , art.shipping_salutation , art.shipping_name -- Force the calculated amount to be a decimal(17,2) column. , CAST(arti.tax_adjusted_amount AS DECIMAL(17,2)) AS amount , CAST(arti.cost_amount AS DECIMAL(17,2)) AS cost_amount , art.printed , art.generated_by__transaction_template_KEY --the ar_receivable_transaction_KEY is ONLY used for filtering purposes. The gl_transaction_KEY is still the --the key/column used for identifiying records in this view. , art.gl_transaction_KEY as ar_receivable_transaction_KEY , art.created_date FROM dbo.AR_Transaction AS art INNER JOIN dbo.AR_Transaction_Item_Rollup_View AS arti --WITH (NOEXPAND) ON art.gl_transaction_KEY = arti.gl_transaction_KEY | |||