---
title: "SYS_EXPN (AccountView)"
description: "General expressions"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/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/fr/
---

# SYS_EXPN: AccountView General expressions

`read only` `per partition`

- Catalogue : `AccountView`
- Label: General expressions

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `SYS_EXPN` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NAME` | `varchar2(40)` | Nom de la société de gestion | [ ] |  |  |
| `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` | Numéro de page | [ ] |  |  |
| `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 | [ ] |  |  |
