# TLB_LINE: E-banking lines - Name: `TLB_LINE` - Catalog: `AccountView` - Label: E-banking lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `TLB_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(10)` | Account number | ☐ | | | `ADDRESS` | `string(30)` | Address | ☐ | | | `BANK_ACCT` | `string(34)` | Bank account number | ☐ | | | `BANK_ACCTV` | `string(42)` | Bank account number | ☐ | | | `BANK_AMT` | `int64` | Bank transaction amount | ☐ | | | `BANK_DATE` | `datetime` | Bank statement date | ☐ | | | `BANK_DESC` | `string(4)` | Bank transaction description | ☐ | | | `BANK_ID` | `string(10)` | E-banking line identification | ☐ | | | `BANK_REF` | `string(20)` | Bank reference | ☐ | | | `COMP_NAME` | `string(100)` | Company name | ☐ | | | `DJ_CODE` | `string(3)` | Journal code | ☐ | | | `INV_NR` | `string(12)` | Document/invoice number | ☐ | | | `LINE_ACC` | `boolean` | Transaction accepted | ☐ | | | `LINE_OK` | `boolean` | Line correct | ☐ | | | `LINE_STAT` | `string(4)` | Transaction status | ☐ | | | `LINE_WARN` | `string(4)` | Warning | ☐ | | | `PAGE_NR` | `string(10)` | Page number (sign) | ☐ | | | `PART_CODE` | `string(10)` | Partner | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PD_AMT` | `int64` | Payment discount amount | ☐ | | | `PD_PCT` | `decimal` | Payment discount percentage | ☐ | | | `POST_CODE` | `string(7)` | Postcode | ☐ | | | `PREF` | `string(35)` | Batch ID | ☐ | | | `RECOG_STAT` | `string(4)` | Auto-recognition status | ☐ | | | `REMI_INFO` | `string(140)` | Posting information | ☐ | | | `RTRN_CODE` | `string(4)` | Direct debit rejection reason | ☐ | | | `STMT_KEY` | `string(10)` | Unique statement key | ☐ | | | `TRAN_CODE` | `string(5)` | Transaction code | ☐ | | | `TRN_QTY` | `decimal` | Quantity (agr) | ☐ | | | `TRN_WGT` | `decimal` | Weight | ☐ | |