# DJ_PAGE: Journal pages - Name: `DJ_PAGE` - Catalog: `AccountView` - Label: Journal pages - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `DJ_PAGE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(10)` | Account number | ☐ | | | `ACCT_POST` | `boolean` | Post directly to general ledger account | ☐ | | | `ACCT_UPD` | `boolean` | Accountant change | ☐ | | | `APPR_SEQ` | `decimal` | Approval sequence number | ☐ | | | `APPR_STATE` | `int32` | Workflow status | ☐ | | | `AUTH_DATE` | `datetime` | Last check date | ☐ | | | `AUTH_NR` | `string(10)` | Authorisation no. | ☐ | | | `AUTH_USR` | `string(10)` | Last checking user | ☐ | | | `BLK_AMT` | `int64` | G-account amount | ☐ | | | `BLK_CUR` | `int64` | G-account amount FC | ☐ | | | `BV_AMT` | `int64` | UWV amount | ☐ | | | `BV_CUR` | `int64` | UWV amount FC | ☐ | | | `CARD_NAME` | `string(40)` | Credit card name | ☐ | | | `CARD_NR` | `string(20)` | Credit card no. | ☐ | | | `CHECK_AMT` | `int64` | Cheque amount | ☐ | | | `CHECK_PRN` | `boolean` | Cheque printed | ☐ | | | `CHECK_WD` | `string(60)` | Cheque amount in words | ☐ | | | `CLT_UPD` | `boolean` | Client change | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMMENT1` | `string(4)` | Note | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CRED_DAYS` | `decimal` | Payment term in days | ☐ | | | `CUR_AMT` | `int64` | Total currency | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_VAT` | `int64` | VAT currency total | ☐ | | | `DD_ACT` | `boolean` | Direct debit | ☐ | | | `DISC_CODE` | `string(2)` | Payment term | ☐ | | | `DISC_DAYS` | `decimal` | Discount term in days | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `DJL_RATE` | `decimal` | Exchange rate foreign currency journal | ☐ | | | `DOC_ID` | `string(32)` | Document code | ☐ | | | `DOC_TYPE` | `int32` | Document type | ☐ | | | `EA_VOUCHER` | `string(36)` | ID of the entry in eAccounting | ☐ | | | `EBANK_ID` | `string(10)` | Bank link identification | ☐ | | | `EBANK_STAT` | `int32` | Bank link status | ☐ | | | `EXCH_RATE` | `decimal` | Exchange rate | ☐ | | | `EXP_CLI` | `boolean` | Export to client | ☐ | | | `EXP_DATE` | `datetime` | Valid until | ☐ | | | `EXP_DJP` | `boolean` | Exported journal pages | ☐ | | | `EXP_SYS` | `boolean` | Old value of sys_gen | ☐ | | | `EXT_DESC` | `string(40)` | Payment reference | ☐ | | | `GROSS_FLG` | `boolean` | Show base amount incl. VAT | ☐ | | | `HDR_DESC` | `string(40)` | Page description | ☐ | | | `IMP_CODE` | `string(10)` | Journal message | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INV_NR` | `string(12)` | Document/invoice number | ☐ | | | `LB_AMT` | `int64` | Payroll tax amount | ☐ | | | `LB_CUR` | `int64` | Payroll tax amount FC | ☐ | | | `MAND_B2B` | `boolean` | Direct debit type: business | ☐ | | | `MAND_DATE` | `datetime` | Signature date | ☐ | | | `MAND_ID` | `string(35)` | Direct debit mandate reference | ☐ | | | `MAND_SEQ` | `int32` | Direct debit mandate | ☐ | | | `NETT_AMT` | `int64` | Net page balance | ☐ | | | `NO_POST` | `boolean` | Do not post page | ☐ | | | `OWN_CNG_DT` | `datetime` | Owner change date | ☐ | | | `PAGE_AMT` | `int64` | Page balance | ☐ | | | `PAGE_AMTT` | `int64` | Closing balance | ☐ | | | `PAGE_EAMT` | `int64` | Closing balance | ☐ | | | `PAGE_NR` | `string(10)` | Page number (sign) | ☐ | | | `PAGE_NRD` | `string(13)` | Page number (description) | ☐ | | | `PAGE_NRV` | `decimal` | Page number | ☐ | | | `PAGE_VAT` | `int64` | VAT amount page | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_ID` | `string(25)` | Payment code | ☐ | | | `PAY_TYPE` | `string(25)` | Payment method | ☐ | | | `PAYIN_ID` | `string(25)` | Pay-in ID | ☐ | | | `PD_AMT` | `int64` | Payment discount amount | ☐ | | | `PD_PCT` | `decimal` | Payment discount percentage | ☐ | | | `PERIOD` | `decimal` | Period | ☐ | | | `PREV_AMT` | `int64` | Opening balance page | ☐ | | | `PRN_CHECK` | `boolean` | Print cheque | ☐ | | | `PRN_RA` | `boolean` | Print cheque remittance | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `STMT_DATE` | `datetime` | Statement date | ☐ | | | `STMT_LINE` | `boolean` | Bank statement line | ☐ | | | `STMT_NR` | `int32` | Bank statement | ☐ | | | `SUB_NR` | `string(10)` | Customer/Supplier | ☐ | | | `SYS_GEN` | `boolean` | Page generated by system | ☐ | | | `SYS_VAL` | `boolean` | System validations | ☐ | | | `TGT_BAL` | `int64` | Control balance | ☐ | | | `TRN_DATE` | `datetime` | Change date | ☐ | | | `USR_NAME` | `string(20)` | Last changed by | ☐ | | | `VEXCH_RATE` | `decimal` | Exchange rate (import) | ☐ | |