---
title: "SYS_EXPN (AccountView)"
description: "General expressions"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/vismaaccountview/AccountView..SYS_EXPN
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..SYS_EXPN
updated: 2026-11-16T21:15:05Z
license: https://documentation.invantive.eu/it/
---

# SYS_EXPN: AccountView General expressions

`read only` `per partition`

- Catalogo: `AccountView`
- Label: General expressions

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `SYS_EXPN`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NAME` | `varchar2(40)` | Administration company name | [ ] |  |  |
| `ADDRESS` | `varchar2(80)` | Administration business postal address | [ ] |  |  |
| `ADDRESS2` | `varchar2(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` | `varchar2(40)` | Full name of logged-in user | [ ] |  |  |
| `LONG_DATE` | `varchar2(40)` | System date in full | [ ] |  |  |
| `PAGENUMBER` | `decimal` | Page number | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PAY_AMT` | `int64` | Deposit amount | [ ] |  |  |
| `PAY_CUR1` | `varchar2(10)` | Currency payment method 1 | [ ] |  |  |
| `PAY_CUR2` | `varchar2(10)` | Currency payment method 2 | [ ] |  |  |
| `PAY_CUR3` | `varchar2(10)` | Currency payment method 3 | [ ] |  |  |
| `PAY_CUR4` | `varchar2(10)` | Currency payment method 4 | [ ] |  |  |
| `PAY_METH1` | `varchar2(30)` | Payment method 1 | [ ] |  |  |
| `PAY_METH2` | `varchar2(30)` | Payment method 2 | [ ] |  |  |
| `PAY_METH3` | `varchar2(30)` | Payment method 3 | [ ] |  |  |
| `PAY_METH4` | `varchar2(30)` | Payment method 4 | [ ] |  |  |
| `SI_ARTPX` | `varchar2(20)` | Sales price per piece sales invoice lines | [ ] |  |  |
| `SI_TINVQTY` | `varchar2(20)` | Quantity to invoice sales invoice lines | [ ] |  |  |
| `SOL_ARTPX` | `varchar2(20)` | Sales price per piece sales order lines (layout) | [ ] |  |  |
| `SOL_ARTQTY` | `varchar2(20)` | Quantity to deliver sales order lines (layout) | [ ] |  |  |
| `SOL_ORDQTY` | `varchar2(20)` | Quantity ordered sales order lines (layout) | [ ] |  |  |
| `TIME` | `varchar2(8)` | Time | [ ] |  |  |
| `TOT_PAY` | `int64` | Paid | [ ] |  |  |
| `TRIAL` | `varchar2(20)` | Draft document | [ ] |  |  |
| `TXT_VISADD` | `varchar2(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` | `varchar2(14)` | Company fiscal VAT number | [ ] |  |  |
