| Table: dbo.Payable_Payment_Application | |||
| This table holds records that are Applications of Payments to Payables. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| payable_transaction_KEY | int (4) | NOT NULL | Foreign key of related payable. |
| payment__gl_transaction_KEY | int (4) | NOT NULL | Foreign key of gl transaction belonging to related payment. |
| application_date | smalldatetime (4) | NOT NULL | The date (date only) the payment was applied. |
| gl_transaction_KEY | int (4) | NOT NULL | Primary Key. |
| discount_taken_amount | decimal (9, 2) | NOT NULL | The amount of discount taken for the Payable Payment Application. |
| payment__reference_number | nvarchar (32) | NOT NULL | The reference number of the payment. |
| description | nvarchar (240) | NOT NULL | The description of the bank or payable transaction. |
| origin__accounting_application_KEY | int (4) | The application that was running when the bank or payable transaction was created. | |
| data_origin_KEY | int (4) | The origin of each bank transaction. For example, Data Entry or CSA Conversion. | |
| Primary key | |||
| Name | Columns | Description | |
| PK_Payable_Payment_Application$gl_transaction_KEY | gl_transaction_KEY | ||