This table holds temporary data that only exists as long as the current user session exists. This table also has a DAL bypass to aid in the performance of high row count inserts. No DAL constraints should be added to this table. WARNING - if this table is modified, use-defined table type dbo.Manage_Customer_Payment_Rows and stored procedure dbo.pb_Insert_Manage_Customer_Payment_Rows also need to be updated to maintain identical structure |
gl_transaction_KEY | int (4) | NOT NULL | Each accounts receivable payment and ar transaction credit memo is based on a GL transaction. |
user_session_guid | uniqueidentifier (16) | NOT NULL | This is a foreign key to the User_Session table, it allows our table contents to be related to a specific user session. |
gl_transaction_type_KEY | int (4) | NOT NULL | The type of GL Transaction. Includes ar payment types and credit memos from the ar transaction type. |
transaction_status_KEY | int (4) | NOT NULL | Specifies the state the payment is currently in. |
customer_KEY | int (4) | NOT NULL | The customer that is associated with this payment. |
customer_name | nvarchar (100) | NOT NULL | The name of the customer associated with this payment. For AR Payments, this field serves as a historical snapshot containing the customer name from when the transaction was created. If the name of the customer is changed in the customer table after the transaction is created, it is important to retain the original name the transaction was created under |
reference_number | nvarchar (32) | NOT NULL | The reference number to be associated with this payment. |
transaction_date | datetime (8, 3) | NOT NULL | The date to be associated with this payment. |
amount | decimal (9, 2) | NOT NULL | The numerical value of this payment |
gl_account_KEY | int (4) | NOT NULL | GL account of the AR payment or the AR Transaction Credit memo. |
journal_KEY | int (4) | NOT NULL | A foreign key to the Journal table. |
gl_period_KEY | int (4) | NOT NULL | A foreign key to the gl period table, to give us the gl period to adjust. |
manage_customer_payment_KEY | int (4) | NOT NULL | Primary Key for this table. |