# DAILY: Journals - Name: `DAILY` - Catalog: `AccountView` - Label: Journals - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `DAILY` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_PUW` | `string(10)` | Payments in transit account | ☐ | | | `ACCT_RUW` | `string(10)` | Receipts in transit account | ☐ | | | `BNK_ACCT` | `string(34)` | Journal bank account | ☐ | | | `BNK_ACCTV` | `string(42)` | Journal bank account | ☐ | | | `BNK_CODE` | `string(10)` | Bank code | ☐ | | | `CHECK_NR` | `string(25)` | Last used cheque number | ☐ | | | `CHK_BAL` | `boolean` | Check page balances | ☐ | | | `CHK_DIF` | `boolean` | Check differences | ☐ | | | `CLT_BLK` | `boolean` | Blocked for client | ☐ | | | `CNG_BLK` | `boolean` | Manual changes blocked | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `CNT_CODE` | `string(2)` | ISO country code | ☐ | | | `CRED_LIM` | `int64` | Bank account credit limit | ☐ | | | `DJ_ACCT` | `string(10)` | Linked account | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `DJ_COMB` | `boolean` | Summarised posting | ☐ | | | `DJ_EXT` | `boolean` | External journal | ☐ | | | `DJ_NAME` | `string(40)` | Journal name | ☐ | | | `DJ_OWNER` | `decimal` | Journal owner | ☐ | | | `DJ_RECON` | `boolean` | Bank reconciliation | ☐ | | | `DJ_TYPE` | `decimal` | Journal type (numeric) | ☐ | | | `DJ_TYPEV` | `string(20)` | Journal type | ☐ | | | `DJP_BLK` | `boolean` | Automatically block page | ☐ | | | `EXCH_STAT` | `decimal` | Exchange status | ☐ | | | `GREK_BANK` | `boolean` | Blocked bank account | ☐ | | | `GROSS_FLG` | `boolean` | Gross entry | ☐ | | | `HDR_DESC` | `int32` | Journal page description | ☐ | | | `IBAN_NR` | `string(34)` | IBAN | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LAY_CHECK` | `string(250)` | Cheque layout | ☐ | | | `LAY_REMIT` | `string(250)` | Cheque remittance layout | ☐ | | | `LINE_DESC` | `int32` | Journal lines description | ☐ | | | `LST_STMT` | `string(5)` | Last imported bank statement | ☐ | | | `NUM_AUTO` | `boolean` | Automatically assign document/invoice numbers | ☐ | | | `NUM_GRP` | `decimal` | Document/invoice number group | ☐ | | | `PA_CODE` | `string(10)` | Partner | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PD_DESC` | `int32` | Payment reference | ☐ | | | `SEND_APPR` | `boolean` | Require new pages to be sent into the workflow | ☐ | | | `SYS_VAL` | `boolean` | System validations | ☐ | |