# LEDGER: General ledger - Name: `LEDGER` - Catalog: `AccountView` - Label: General ledger - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `LEDGER` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_ALLOC` | `string(10)` | Clear balance to | ☐ | | | `ACCT_BAL` | `int64` | Account balance | ☐ | | | `ACCT_COST` | `string(10)` | Cost price account | ☐ | | | `ACCT_LINK` | `decimal` | Control account type | ☐ | | | `ACCT_NAME` | `string(40)` | Account description | ☐ | | | `ACCT_NR` | `string(10)` | Account number | ☐ | | | `ACCT_PROJ` | `boolean` | Project account | ☐ | | | `ACCT_TYPE` | `decimal` | Account type | ☐ | | | `ACT_PY` | `int64` | Balance prior year | ☐ | | | `BAL_BAL` | `int64` | Balance sheet | ☐ | | | `BAL_PL` | `int64` | P&L | ☐ | | | `CLT_BLK` | `boolean` | Blocked for client | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `CO_ACCT` | `boolean` | Clearing account | ☐ | | | `CON_ACCT` | `string(10)` | Statutory consolidation account | ☐ | | | `CON_ACCT2` | `string(10)` | Internal consolidation account | ☐ | | | `COR_BAL` | `int64` | Balance of prior-year items | ☐ | | | `COR_CAMT` | `int64` | Adjustments credit amount | ☐ | | | `COR_DAMT` | `int64` | Adjustments debit amount | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `COST_MAND` | `boolean` | Cost centre code required | ☐ | | | `CR_AMT` | `int64` | Credit amount | ☐ | | | `CR_AMTMIN` | `int64` | Negative credit amount | ☐ | | | `CUR_CAMT` | `int64` | Currency amount credit | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_DAMT` | `int64` | Currency amount debit | ☐ | | | `DIST_CODE` | `string(10)` | Allocation key | ☐ | | | `DOSS_DESC` | `string(4)` | Note | ☐ | | | `DOSS_REF` | `string(10)` | File reference | ☐ | | | `DR_AMT` | `int64` | Debit amount | ☐ | | | `EFS_CHK` | `string(25)` | Element of taxonomy to be checked | ☐ | | | `EFS_LEDG` | `string(25)` | Element of accounting taxonomy | ☐ | | | `FA_ACCT` | `boolean` | Asset account | ☐ | | | `FA_SELL` | `boolean` | Asset sales account | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `JRNL_QTY` | `boolean` | Number of journal lines to check | ☐ | | | `LDG_STAT` | `string(5)` | Account status | ☐ | | | `NORM_STAT` | `decimal` | Normal balance | ☐ | | | `NOT_DASH` | `boolean` | Exclude from dashboard charts | ☐ | | | `PART_MAND` | `decimal` | Partner required | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(5)` | Cost type code | ☐ | | | `PRE_COR` | `int64` | For prior-year items | ☐ | | | `PRE_CORC` | `int64` | For prior-year items credit | ☐ | | | `PRE_CORD` | `int64` | For prior-year items debit | ☐ | | | `PRO_ATTR` | `string(4)` | Linked project dimensions | ☐ | | | `PROJ_EXP` | `boolean` | Billable project costs/revenues | ☐ | | | `PROJ_OBLI` | `boolean` | Project commitments | ☐ | | | `QTY_MAND` | `decimal` | Quantity required | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_SYS` | `boolean` | System record | ☐ | | | `REV_ACCT` | `boolean` | Revalue currency | ☐ | | | `RUBRIEKEN` | `string(40)` | Categories | ☐ | | | `SL_CODE1` | `string(10)` | Subledger 1 | ☐ | | | `SL_CODE2` | `string(10)` | Subledger 2 | ☐ | | | `SL_CODE3` | `string(10)` | Subledger 3 | ☐ | | | `SPLIT_PA` | `boolean` | Split per partner | ☐ | | | `STAT_ORIG` | `string(5)` | Original account status | ☐ | | | `STAT_SELL` | `boolean` | Revenue account | ☐ | | | `SUM_RPT` | `boolean` | Summarise on general ledger card report | ☐ | | | `TRANS_NR` | `int32` | Number of transactions | ☐ | | | `VAT_CODE` | `string(2)` | VAT Code | ☐ | | | `VAT_MAND` | `boolean` | VAT code required | ☐ | | | `WF_ALLOW` | `boolean` | Account suitable for use in IFA | ☐ | | | `WGT_MAND` | `decimal` | Weight required | ☐ | | | `WKR_TRN` | `boolean` | Transaction charged to free allowance WKR | ☐ | | | `XBRL_SPEC` | `boolean` | XBRL specification | ☐ | |