# SYS_EXPN: General expressions - Name: `SYS_EXPN` - Catalog: `AccountView` - Label: General expressions - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `SYS_EXPN` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NAME` | `string(40)` | Administration company name | ☐ | | | `ADDRESS` | `string(80)` | Administration business postal address | ☐ | | | `ADDRESS2` | `string(80)` | Administration business visiting address | ☐ | | | `COPIES` | `decimal` | Total number of copies | ☐ | | | `CUR_AMT1` | `int64` | Amount payment method 1 | ☐ | | | `CUR_AMT2` | `int64` | Amount payment method 2 | ☐ | | | `CUR_AMT3` | `int64` | Amount payment method 3 | ☐ | | | `CUR_AMT4` | `int64` | Amount payment method 4 | ☐ | | | `DATE` | `datetime` | Date | ☐ | | | `LOGIN_NAME` | `string(40)` | Full name of logged-in user | ☐ | | | `LONG_DATE` | `string(40)` | System date in full | ☐ | | | `PAGENUMBER` | `decimal` | Page number | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_AMT` | `int64` | Deposit amount | ☐ | | | `PAY_CUR1` | `string(10)` | Currency payment method 1 | ☐ | | | `PAY_CUR2` | `string(10)` | Currency payment method 2 | ☐ | | | `PAY_CUR3` | `string(10)` | Currency payment method 3 | ☐ | | | `PAY_CUR4` | `string(10)` | Currency payment method 4 | ☐ | | | `PAY_METH1` | `string(30)` | Payment method 1 | ☐ | | | `PAY_METH2` | `string(30)` | Payment method 2 | ☐ | | | `PAY_METH3` | `string(30)` | Payment method 3 | ☐ | | | `PAY_METH4` | `string(30)` | Payment method 4 | ☐ | | | `SI_ARTPX` | `string(20)` | Sales price per piece sales invoice lines | ☐ | | | `SI_TINVQTY` | `string(20)` | Quantity to invoice sales invoice lines | ☐ | | | `SOL_ARTPX` | `string(20)` | Sales price per piece sales order lines (layout) | ☐ | | | `SOL_ARTQTY` | `string(20)` | Quantity to deliver sales order lines (layout) | ☐ | | | `SOL_ORDQTY` | `string(20)` | Quantity ordered sales order lines (layout) | ☐ | | | `TIME` | `string(8)` | Time | ☐ | | | `TOT_PAY` | `int64` | Paid | ☐ | | | `TRIAL` | `string(20)` | Draft document | ☐ | | | `TXT_VISADD` | `string(20)` | Visiting address text | ☐ | | | `VAT_C_1` | `int64` | VAT amt code 1 sales order lines (layout) | ☐ | | | `VAT_C_2` | `int64` | VAT amt code 2 sales order lines (layout) | ☐ | | | `VAT_C_2_1` | `int64` | VAT amt code 1 sales invoice lines | ☐ | | | `VAT_C_2_2` | `int64` | VAT amt code 2 sales invoice lines | ☐ | | | `VAT_N_1` | `int64` | Net amt VAT code 1 sales order lines (layout) | ☐ | | | `VAT_N_2` | `int64` | Net amt VAT code 2 sales order lines (layout) | ☐ | | | `VAT_N_2_1` | `int64` | Net amt VAT code 1 sales invoice lines | ☐ | | | `VAT_N_2_2` | `int64` | Net amt VAT code 2 sales invoice lines | ☐ | | | `VAT_NR` | `string(14)` | Company fiscal VAT number | ☐ | |