Tags: read-only
Content:
1 | INV | Invoice | 1 | INV | 2 | SC | Service Charge | 1 | SC | 3 | DM | Debit Memo | 1 | DM | 4 | CHK | Check | -1 | CHK | 5 | CM | Credit Memo | -1 | CM | 6 | NSF | Non-Sufficient Funds | 1 | NSF | 7 | WO | Write Off | -1 | WO | 8 | CA | Cash | -1 | CA | 9 | CC | Credit Card | -1 | CC | 10 | CCR | Credit Card Return | 1 | CCR | 11 | ACH | Electronic Funds Transfer | -1 | ACH | 12 | PWO | Proforma Write Off | -1 | Proforma Write Off | 13 | CNA | Reversal (Application) | -1 | CNA |
|
ledger_entry_type_KEY | int | NOT NULL | Database assigned primary key for this table. |
ledger_entry_type_id | nvarchar (250) | NOT NULL | User defined identifier (unique). |
description | nvarchar (250) | NOT NULL | User defined description (unique). |
normal_sign | decimal (1) | NOT NULL | Debit (1) or Credit (-1). |
ledger_entry_type_id_sortable | varchar (250) | NOT NULL | A representation of the ledger_entry_type_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of ledger_entry_type_id. |