This table stores Invoices, Credit Memos, and Finance Charges for the Accounts Receivable service. Invoices and Finance Charges are transactions customers have to pay while Credit Memos are can be used to reduce open balance. |
gl_transaction_KEY | int (4) | NOT NULL | Primary key for this table. AR Transactions are required to have a GL Transaction row. |
customer_KEY | int (4) | NOT NULL | The customer the transaction is for. |
ar_transaction_type_KEY | int (4) | NOT NULL | AR Transaction Type including Invoice, Credit Memo and Finance Charge. |
transaction_status_KEY | int (4) | NOT NULL | Transaction status. Valid statuses for AR Transactions include Live, Voided, and Pending |
transaction_date | smalldatetime (4) | NOT NULL | The date the transaction took place on. |
reference_number | nvarchar (32) | NOT NULL | The reference number for the transaction. |
payment_discount_amount_original | decimal (9, 2) | NOT NULL | A discount amount for making early payments. This field is for an original amount. |
payment_discount_amount_override | decimal (9, 2) | | An override field for payment discount amount. |
payment_term_KEY | int (4) | | An optional payment term for the transaction. |
due_date | smalldatetime (4) | | The due date for the transaction if applicable. |
purchase_order_number | nvarchar (32) | NOT NULL | The purchase order number for the transaction. |
gl_account_KEY | int (4) | NOT NULL | The AR Transaction GL Account. |
payment_discount_expiration_date | smalldatetime (4) | | The discount expiration date for the payment discount. |
payment_discount__gl_account_KEY | int (4) | | The gl account for the payment discount amount. |
shipping__contact_address_type_KEY | int (4) | | The type of contact address to use for shipping. |
shipping_date | smalldatetime (4) | | The date the items for the invoice shipped. |
shipping_salutation | nvarchar (80) | NOT NULL | The salutation to use for the shipping name. |
shipping_name | nvarchar (100) | NOT NULL | The name to use in the shipping address. |
printed | bit (1) | NOT NULL | True if this AR_Transaction has ever been printed. |
generated_by__transaction_template_KEY | int (4) | | Specifies that this AR transaction was generated by a specific template. This link is important for template scheduling; we need to keep track of what has already been generated by a template. A null value indicates that it was not generated by a template. |
reference_number_sortable | varchar (80) | NOT NULL | A system generated sortable reference number. |
purchase_order_number_sortable | varchar (80) | NOT NULL | A system generated sortable purchase order number. |
message | nvarchar (2000) | NOT NULL | A transaction message. |
payment_discount_amount | decimal (9, 2) | NOT NULL | This payment discount amount field shows the override value if not null otherwise it shows the original amount. |
created_date | datetime (8, 3) | NOT NULL | The date on which the AR transaction was created. To maintain consistency with the Payable_Transaction and Bank_Transaction_Event versions of created date, we want to use DATETIME instead of DATE and the local time value needs to be assigned rather than using UTC time. |