# L19.4 - Gestione eCOMMERCE

---

### 4.1 - Configurazione dei parametri e Attività Propedeutiche

<table id="bkmrk-1.1---manutenzione-x" style="height: 75px; width: 100%;"><tbody><tr><td style="width: 69.5834%;">#### 4.1.1 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Tabella Procedurale ECO: Parametri eCOMMERCE </span>

</td><td style="width: 30.5358%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">EE0</td><td>1.1</td><td>7</td></tr></tbody></table>

</td></tr></tbody></table>

<span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Percorso: BE0 \\ 1.1 Parametri base \\ 7 Tabelle procedurali</span>

[![image.png](https://gsdoc.genesyssoftware.eu/uploads/images/gallery/2026-06/scaled-1680-/el5image.png)](https://gsdoc.genesyssoftware.eu/uploads/images/gallery/2026-06/el5image.png)

La tabella procedurale ECO deve essere preventivamente censita e valorizzata per ogni Ditta per definire le direttive fondamentali di interscambio e le specifiche di connessione verso le piattaforme esterne. All'interno di questa tabella sono configurabili i seguenti campi:

- Codice Portale: Identifica il codice del Portale dedicato all'eCOMMERCE. Il Portale deve essere preventivamente codificato all'interno della Tabella procedurale `PRT - Portale`.
- Upload flussi: Check-box da attivare per abilitare il caricamento automatico dei flussi generati direttamente sul server web dedicato all'eCOMMERCE.
- Nome flussi: Questo indicatore determina la codifica e la nomenclatura dei file generati per l'Export flussi. Può assumere i seguenti valori:
- `0` = Nome file strutturato come `&lt;data&gt;+&lt;nometavola&gt;` (Formato: `AAMMDDHHMMSS&lt;nometavola&gt;.csv`).
- `1` = Nome file strutturato come solo `&lt;nometavola&gt;.csv`.
- Nota di controllo bloccante: Se l'indicatore è impostato sul valore `1`, si attiva un controllo automatico di sicurezza per il quale la procedura di Export viene eseguita \*\*solo se\*\* le cartelle di interscambio del server locale e le cartelle di interscambio del portale web risultano completamente vuote.
- Genera zip: Indicatore booleano per stabilire se i flussi generati debbano essere compressi in un unico archivio in formato `.zip` prima della trasmissione.
- Download flussi: Check-box per indicare al sistema se effettuare il download dei flussi dal portale web per le successive attività di importazione dati (es. Ordini).
- Formato Export: Questo campo determina la tecnologia di output dei flussi di sincronizzazione ed è strettamente legato all'architettura del database di destinazione. Può assumere i seguenti valori numerici:

`0` – File (Formato standard CSV/XML salvato in locale o su server FTP).

`1` – Database MySQL.

`2` – Database SQL Server.

`3` – Database Oracle.

- Gruppo DB: Campo alfanumerico in cui inserire il gruppo identificativo del database esterno a cui connettersi. L'inserimento è modificabile ed è \*\*obbligatorio se e solo se\*\* il campo \*Formato Export\* è stato impostato su un valore diverso da `0` (quindi `1`, `2` o `3`).
- Gestione Storico e Nr. Gg.: Flag attivabile dall'utente che abilita un campo numerico aggiuntivo. Consente di definire il numero esatto di giorni di dati storici da conservare e mantenere all'interno del database durante le operazioni di export flussi.
- Export per Fascia oraria: Flag che permette di decidere se limitare e pianificare l'esecuzione dell'export dei dati esclusivamente all'interno di determinati intervalli orari giornalieri.
- Fascia 1 e Fascia 2: Campi in cui l'utente digita gli orari limite (Inizio/Fine) per l'esecuzione dei processi.

**Nota di attenzione**: Le fasce orarie sono sempre digitabili a terminale, ma verranno elaborate e considerate dall'applicativo "se e solo se" l'utente ha preventivamente selezionato e attivato il flag \*Export per Fascia oraria\*.

<table id="bkmrk-1.2---tabella-proced" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3945%;">#### 4.1.2 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Manutenzione XRTB</span>

</td><td style="width: 28.6055%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">EE0</td><td>1.20</td><td>3</td></tr></tbody></table>

</td></tr></tbody></table>

La tabella tecnica di manutenzione \*\*XRTB\*\* sovrintende ai criteri di sincronizzazione delle singole tavole dati del gestionale. Per abilitare il corretto funzionamento dell'eCOMMERCE è necessario impostare i seguenti campi di controllo:

- Ditta sincronizzazione: Indica il codice della Ditta per la quale eseguire i processi di allineamento. È un parametro obbligatorio: in sua assenza il sistema blocca qualsiasi tentativo di sincronizzazione.
- Sincronizzazione WEB: Indicatore numerico fondamentale per l'attivazione della sincronizzazione verso il portale eCOMMERCE. Determina il comportamento del motore di sincronizzazione:
- Valore `1` = Configura la sincronizzazione incrementale standard. Vengono intercettate ed esportate unicamente le singole righe della tavola che hanno subito inserimenti, modifiche o cancellazioni dall'ultimo invio.
- Valore `9` (\*Refresh ever\*) = Forza il sistema ad eseguire sempre un refresh completo e totale della tavola ad ogni ciclo, anche durante le sessioni di sincronizzazione ordinaria.
- Sincronizzazione TEST: Indicatore per attivare le routine di sincronizzazione e disallineamento in ambiente di Test.

##### 4.1.2.1 - Classificazione delle tavole in base agli indicatori XRTB

A seconda delle esigenze operative, le tavole di eSIGEA si dividono nei due macro-gruppi gestiti dalla manutenzione:

1. **Tavole interessate dalla Sincronizzazione WEB (eCOMMERCE core):**

<table border="1" id="bkmrk-aat2-condizioni-di-p" style="border-collapse: collapse; width: 72.5%; height: 348.333px;"><colgroup><col style="width: 14.1473%;"></col><col style="width: 85.8392%;"></col></colgroup><tbody><tr><td><span style="font-family: 'courier new', courier, monospace;">AAT2</span></td><td>Condizioni di pagamento</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AAT7</span>

</td><td>Porti</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AATC</span></td><td>Categoria Clienti</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AATM</span>

</td><td>Voci Complementari (Tariffario Spese di Trasporto)</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AAT5</span></td><td>Gruppi/Sottogruppi Articoli</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AETF</span></td><td>Classificazione Articoli (ECR)</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETA</span>

</td><td style="height: 29.3333px;">ECR - Reparti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETB</span></td><td style="height: 29.3333px;">ECR - Settori</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETC</span></td><td style="height: 29.3333px;">ECR - Famiglie</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETD</span></td><td style="height: 29.3333px;">ECR - Sub-famiglie</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETE</span></td><td style="height: 29.3333px;">ECR - Gruppi</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ASCP</span>

</td><td style="height: 29.3333px;">Tabella Sconti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AACC</span></td><td style="height: 29.3333px;">Anagrafica Clienti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AAMG</span></td><td style="height: 29.3333px;">Anagrafica Articoli di Magazzino</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ACMG</span></td><td style="height: 29.3333px;">Contabile Articoli di Magazzino (Generale o del Deposito specifico indicato nel file `.fio`)</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AABR</span></td><td>Anagrafica Codici EAN Articoli</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AALV</span>

</td><td>Listino Prezzi Articoli</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">MCPB</span></td><td>Relazioni Campagne promozionali/Clienti (Promozioni/Volantini: Beneficiari)</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">MCPP</span></td><td>Relazioni Campagne promozionali/Articoli (Promozioni/Volantini: Articoli)</td></tr></tbody></table>

**2. Tavole abilitate per la Sincronizzazione TEST:**

<table border="1" id="bkmrk-abtf-filiali-aatd-de" style="border-collapse: collapse; width: 71.4286%; height: 527.999px;"><colgroup><col style="width: 13.8766%;"></col><col style="width: 86.1082%;"></col></colgroup><tbody><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ABTF</span>

</td><td style="height: 29.3333px;">Filiali</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AATD</span></td><td style="height: 29.3333px;">Depositi</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ATBL</span>

</td><td style="height: 29.3333px;">Tabelle procedurali</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AACC</span></td><td style="height: 29.3333px;">Anagrafica Conti Clienti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AACF</span></td><td style="height: 29.3333px;">Anagrafica Conti Fornitori</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AACG</span>

</td><td style="height: 29.3333px;">Anagrafica Conti Generali</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ARCC</span></td><td style="height: 29.3333px;">Relazione Rapporti Contabili</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AATG</span></td><td style="height: 29.3333px;">Conti Standard</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ATO</span></td><td style="height: 29.3333px;">Agenti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AATQ</span>

</td><td style="height: 29.3333px;">Zone</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AAT4</span></td><td style="height: 29.3333px;">Centri di Costo/Ricavo</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AAMG</span></td><td style="height: 29.3333px;">Anagrafica Articoli di Magazzino</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AAME</span></td><td style="height: 29.3333px;">Dati aggiuntivi Articoli</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AAT5</span></td><td style="height: 29.3333px;">Gruppi/Sottogruppi</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">ABTL</span>

</td><td style="height: 29.3333px;">Brand e Sub-brand</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETF</span></td><td style="height: 29.3333px;">Classificazione Articoli (ECR)</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETA</span></td><td style="height: 29.3333px;">ECR - Reparti</td></tr><tr style="height: 29.3333px;"><td style="height: 29.3333px;"><span style="font-family: 'courier new', courier, monospace;">AETB</span></td><td style="height: 29.3333px;">ECR - Settori</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AETC</span></td><td>ECR - Famiglie</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AETD</span></td><td>ECR - Sub-famiglie</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">AETE</span></td><td>ECR - Gruppi</td></tr></tbody></table>

### <span style="font-size: 32px;">4.2 - Architettura di interscambio dati e modalità di integrazione</span>

eSIGEA supporta due differenti architetture tecniche di integrazione con il portale eCOMMERCE, configurabili a livello di Ditta tramite la tabella procedurale ECO.

La modalità operativa è determinata dal parametro Formato Export, che definisce il meccanismo fisico di trasporto, sincronizzazione e acquisizione dei dati tra il gestionale e la piattaforma esterna.

<table border="0" cellpadding="0" cellspacing="3" class="MsoNormalTable" id="bkmrk-valore-modalit%C3%A0-tecn" style="width: 82.7381%;"><thead><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="padding: 0.75pt; width: 8.78847%;">Valore

</td><td style="padding: 0.75pt; width: 27.2527%;">Modalità

</td><td style="padding: 0.75pt; width: 63.9458%;">Tecnologia

</td></tr></thead><tbody><tr style="mso-yfti-irow: 1;"><td style="padding: 0.75pt; width: 8.78847%;">0

</td><td style="padding: 0.75pt; width: 27.2527%;">Interscambio tramite File

</td><td style="padding: 0.75pt; width: 63.9458%;">File CSV/XML su cartelle di spool o portale web

</td></tr><tr style="mso-yfti-irow: 2;"><td style="padding: 0.75pt; width: 8.78847%;">1

</td><td style="padding: 0.75pt; width: 27.2527%;">Database MySQL

</td><td style="padding: 0.75pt; width: 63.9458%;">Connessione diretta DB

</td></tr><tr style="mso-yfti-irow: 3;"><td style="padding: 0.75pt; width: 8.78847%;">2

</td><td style="padding: 0.75pt; width: 27.2527%;">Database SQL Server

</td><td style="padding: 0.75pt; width: 63.9458%;">Connessione diretta DB

</td></tr><tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="padding: 0.75pt; width: 8.78847%;">3

</td><td style="padding: 0.75pt; width: 27.2527%;">Database Oracle

</td><td style="padding: 0.75pt; width: 63.9458%;">Connessione diretta DB

</td></tr></tbody></table>

Le due architetture condividono le medesime logiche funzionali di sincronizzazione delle tavole gestionali, ma differiscono completamente nella modalità tecnica di scambio dati.

<div align="center" class="MsoNormal" id="bkmrk--4" style="text-align: center;">---

</div>#### 4.2.1 - Interscambio tramite File (CSV/XML)

La modalità File rappresenta il modello standard di integrazione basato sulla generazione e acquisizione di flussi fisici memorizzati nelle cartelle di interscambio del server eSIGEA o trasferiti da/verso il portale web.

Questa architettura viene attivata impostando:

Formato Export = 0 (File)

Principio di funzionamento

L'integrazione avviene attraverso due processi distinti:

Export dati verso il portale

eSIGEA genera file in formato CSV, contenenti le tavole anagrafiche e commerciali abilitate alla sincronizzazione WEB tramite configurazione XRTB.

I file vengono inizialmente prodotti nella cartella temporanea:

<span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/EXP/TMP</span>

e successivamente trasferiti nella cartella di elaborazione:

<span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/EXP/ELA</span>

Qualora nella tabella ECO sia attivo il parametro Upload flussi, i file vengono automaticamente pubblicati sul server del portale web e rimossi dalle directory locali dopo il completamento del trasferimento.

La nomenclatura dei file è governata dal parametro Nome flussi:

- <span style="font-family: 'courier new', courier, monospace;">0 → AAAAMMGGHHMMSS&lt;nometavola&gt;.csv</span>
- <span style="font-family: 'courier new', courier, monospace;">1 → &lt;nometavola&gt;.csv</span>

Import dati dal portale

L'acquisizione dei dati provenienti dall'eCOMMERCE avviene mediante lettura di file strutturati, normalmente in formato XML.

La principale implementazione standard riguarda l'importazione degli Ordini Clienti Web, tramite file XML depositati nella directory:

<span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/IMP/ORDC/ELA</span>

In alternativa, qualora configurato il parametro Download flussi nella tabella ECO, il sistema può eseguire automaticamente il recupero dei file dal portale remoto.

Regole di mapping e trasformazione

Nella modalità file, la struttura dei tracciati non è determinata dal database, ma da specifici file di configurazione tecnica.

Per il corretto funzionamento dell’interscambio devono essere presenti nella directory:

<span style="font-family: 'courier new', courier, monospace;">$PROCLIB/fio</span>

i seguenti file:

Export CSV

<span style="font-family: 'courier new', courier, monospace;">WEB0\_EXPO\_&lt;nometavola&gt;.fio</span>

Tali file definiscono:

- mapping dei campi esportati;
- regole di estrazione;
- attributi di filtro;
- parametri specifici di tavola.

Esempi:

ACMG  
richiede l'attributo:

code-depo

per determinare il deposito utilizzato nel calcolo delle giacenze esportate.

AABR  
può utilizzare:

tipc--ean

per filtrare la tipologia di codici EAN da esportare.

Import XML Ordini

<span style="font-family: 'courier new', courier, monospace;">WEB0\_IMPO\_ORDC.fio</span>

<span style="font-family: 'courier new', courier, monospace;">WEB0\_IMPO\_ORDC.xsl</span>

Il file .fio governa la mappatura tecnica dei campi, mentre il foglio di stile .xsl esegue:

- trasformazione del tracciato XML;
- normalizzazione dei dati;
- validazione formale del file;
- conversione verso il formato interno eSIGEA.

Nel file .fio è inoltre possibile valorizzare il parametro:

CODE\_DEPO

per forzare il deposito di intestazione dell’ordine cliente generato.

<div align="center" class="MsoNormal" id="bkmrk--5" style="text-align: center;">---

</div>#### 4.2.2 - Interscambio tramite Database di Frontiera

La modalità Database di Frontiera realizza una sincronizzazione diretta tra eSIGEA e il database del portale eCOMMERCE, eliminando la necessità di generare file intermedi di interscambio.

L’integrazione viene attivata impostando il parametro:

Formato Export = 1, 2 oppure 3

in funzione del motore database utilizzato dal cliente:

1. MySQL
2. SQL Server
3. Oracle

In tale scenario il campo Gruppo DB della tabella ECO diventa obbligatorio e identifica la connessione tecnica verso il database remoto.

Principio di funzionamento

In questa architettura:

- non vengono generati file CSV di interscambio;
- non vengono utilizzate cartelle spool per la sincronizzazione dati;
- il trasferimento delle informazioni avviene tramite connessione diretta al database remoto.

Il motore di sincronizzazione aggiorna esclusivamente le tavole abilitate nella manutenzione XRTB, filtrando i record con:

Sincronizzazione WEB &gt; 0

La logica di export rimane invariata:

- sincronizzazione incrementale standard (1);
- refresh completo (9 - Refresh ever).

Inizializzazione del database di frontiera

Prima dell’attivazione della sincronizzazione è necessario creare la struttura fisica del database remoto.

A tale scopo deve essere utilizzata la funzione:

<span style="font-family: 'courier new', courier, monospace;">B31 (3109) → 2.23 eCommerce → 10 Manutenzione e assestamento → 1 Agg.to DB frontiera</span>

La procedura esegue i seguenti passaggi:

1\. Verifica parametri ECO

Il sistema controlla la presenza della tabella procedurale ECO.

Se assente:

"Parametri eCOMMERCE non presenti"

la procedura viene bloccata.

Se il parametro Formato Export risulta uguale a 0 (File), l’elaborazione viene ugualmente interrotta poiché la funzione è disponibile esclusivamente in modalità database.

2\. Apertura connessione DB

La procedura utilizza le credenziali definite nel Gruppo DB per collegarsi al database remoto.

3\. Analisi tavole sincronizzabili

Il sistema legge la manutenzione XRTB ed individua le sole tavole aventi:

Sincronizzazione WEB &gt; 0

4\. Generazione struttura fisica

Alla conferma dell’utente vengono eseguiti automaticamente gli script SQL di creazione tabelle, memorizzati nella directory:

../H02/comn

L’esito viene rappresentato graficamente:

- Verde → tabella creata correttamente;
- Rosso/Giallo → errore o tabella già presente.

Eccezioni tecniche automatiche

Generazione automatica MPMG

La creazione della tabella:

MMMG

produce automaticamente anche la generazione della tabella logistica:

MPMG

Creazione tabella SEMAFORO

Contestualmente all’inizializzazione del database di frontiera, il sistema genera automaticamente la tabella tecnica:

SEMAFORO

utilizzata per il controllo anticoncorrenziale dei processi di sincronizzazione.

### 4.3 - Gestione dei flussi ed esecuzione delle fasi operative

La trasmissione e la ricezione dei dati tra eSIGEA e il portale eCOMMERCE possono avvenire secondo due differenti modalità tecniche:

- tramite file (CSV/XML), utilizzando cartelle di interscambio;
- tramite database di frontiera, utilizzando connessione diretta al DB remoto.

Le procedure operative descritte nei paragrafi successivi si applicano in funzione della modalità di integrazione configurata nella tabella ECO.

#### 4.3.1 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Scambio Dati e Logica dei Semafori Anticoncorrenziali</span>

Per impedire fenomeni distruttivi di sovrascrittura dei dati, conflitti di accesso alla rete o letture parziali delle righe durante le fasi di aggiornamento, l'architettura tecnica prevede un blocco a semaforo gestito tramite l'omonima tabella `"SEMAFORO"` creata sul database di frontiera.

**Algoritmo di Controllo del Semaforo nell'Export**

\[Avvio Procedura Export\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[Verifica Stato Tabella SEMAFORO\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span lang="EN-US" style="font-family: 'MS Gothic'; mso-bidi-font-family: 'MS Gothic';">├</span><span style="mso-ascii-font-family: Aptos; mso-hansi-font-family: Aptos; mso-bidi-font-family: Aptos;">──</span><span style="font-family: 'Arial',sans-serif;">►</span> Se Stato = "ACCESO" (In corso) <span style="mso-ascii-font-family: Aptos; mso-hansi-font-family: Aptos; mso-bidi-font-family: Aptos;">──</span><span style="font-family: 'Arial',sans-serif;">►</span> \[Blocco Procedura\] <span style="mso-ascii-font-family: Aptos; mso-hansi-font-family: Aptos; mso-bidi-font-family: Aptos;">──</span><span style="font-family: 'Arial',sans-serif;">►</span> Notifica Errore a Terminale

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>└──<span style="font-family: 'Arial',sans-serif;">►</span> Se Stato = "SPENTO" (Libero)

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

<span style="mso-spacerun: yes;"> </span>\[Accensione Semaforo\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

<span style="mso-spacerun: yes;"> </span>\[Esecuzione Export Tabelle\]

<span style="mso-spacerun: yes;"> </span>(Sincronizzazione Web &gt; 0)

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

<span style="mso-spacerun: yes;"> </span>\[Scrittura Dati\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

<span style="mso-spacerun: yes;"> </span>\[Spegnimento Semaforo\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

<span style="mso-spacerun: yes;"> </span>\[Fine Processo\]

##### 4.3.1.1 Funzioni di Forzatura per l'Assistenza Tecnica

In caso di arresti anomali del server, cadute di connessione o necessità di sblocco manuale da parte dell'assistenza tecnica, sono state predisposte due voci di menù dedicate al ripristino forzato degli stati interni del semaforo sul database:

\* Percorso: `B31 (3109)\\2.23 eCommerce\\10 Manutenzione e assestamento\\2 Ripristina stato "ESPORTARE"`

\* Percorso: `B31 (3109)\\2.23 eCommerce\\10 Manutenzione e assestamento\\3 Ripristina stato "AGGIORNARE"`

<table id="bkmrk-3.2---procedura-di-e" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3548%;">#### 4.3.2 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Procedura di Export Files</span>

</td><td style="width: 28.5896%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">E29</td><td>2.23</td><td>1</td></tr></tbody></table>

</td></tr></tbody></table>

Percorso di menù: E29 \\ 2.23 \\ 1

La funzione genera i flussi estratti dalle tavole gestionali per allineare il Portale Web. Prevede due modalità esecutive distinte richiamabili da menù:

1\. \*\*Export Ordinario:\*\* Esporta selettivamente solo le righe inserite, modificate o rimosse, a meno che sulla Manutenzione XRTB non sia impostato il valore `9` (\*refresh ever\*) su una specifica tavola, inducendo l'esportazione totale della stessa.

2\. \*\*Prima installazione / Refresh:\*\* Forza l'estrazione e l'esportazione integrale e massiva di tutte le tabelle censite con indicatore maggiore di zero.

<span style="mso-no-proof: yes;">![](https://gsdoc.genesyssoftware.eu/uploads/images/gallery/2026-06/embedded-image-4binonos.png)</span>

##### 4.3.2.1 Regole di Mappatura tramite file di configurazione (.fio)

Per la corretta formattazione e mappatura delle colonne, la procedura richiede il caricamento nella cartella di sistema `$PROCLIB/fio` di file di configurazione dedicati per ciascuna tavola, rinominati tassativamente secondo la regola: `WEB0\_EXPO\_&lt;nometavola&gt;.fio`.

All'interno di questi file `.fio` devono essere valorizzati alcuni attributi strutturali specifici per le seguenti tavole:

- Tavola `ACMG` (Contabile Articoli): Deve obbligatoriamente contenere l'attributo `code-depo` per specificare al motore di estrazione il codice del Deposito da cui attingere per calcolare la giacenza corretta da esportare.
- Tavola `AABR` (EAN Articoli): Deve contenere l'attributo `tipc--ean` per filtrare la tipologia di codice a barre:
- Valore `0` = Esporta esclusivamente i codici EAN legati al singolo Prodotto.
- Valore `1` = Esporta esclusivamente i codici EAN legati alla Confezione.
- Attributo assente/vuoto = Vengono esportati tutti i codici EAN presenti in anagrafica, senza alcuna distinzione.
- Tavola `MCPB` (Beneficiari Campagne): Deve contenere l'attributo `rige-ccom` per indicare al sistema se rigenerare completamente le relazioni delle campagne promozionali prima di avviare il processo di export dei record.

##### 4.3.2.2 Denominazione, Percorsi di Spool e Tracciamento Log

- Nomenclatura: I file assumono la forma `YYYYMMDDHHMMSS&lt;nometavola&gt;.csv` (oppure solo `&lt;nometavola&gt;.csv` in base al parametro \*Nome flussi\* della tabella ECO). L'identificativo `&lt;nometavola&gt;` deve essere rigorosamente composto da 4 caratteri.
- Ciclo dei percorsi sul server: I file vengono inizialmente generati nella directory temporanea `SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/EXP/TMP`. Terminata la scrittura del singolo file, questo viene trasferito nella cartella di elaborazione `SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/EXP/ELA`. Se nella tabella ECO è attivo l'Upload flussi, il file viene pubblicato sul portale esterno e successivamente rimosso dalle cartelle locali del server.
- Tracciabilità: Tutte le sessioni di sincronizzazione vengono registrate nei file log di sistema e sono consultabili liberamente dagli utenti attraverso la funzione aziendale \*\*Inquiry log documentale\*\*, impostando il filtro \*Tipo documento\* sul valore `WEB0`.

<table id="bkmrk-3.3---procedura-di-i" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3548%;">#### 4.3.3 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Procedura di Import Ordini Vendita</span>

</td><td style="width: 28.5896%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">E29</td><td>2.23</td><td>4</td><td>1</td></tr></tbody></table>

</td></tr></tbody></table>

Percorso di menù: E29 \\ 2.23 \\ 4 \\ 1

Questa funzione automatizza la ricezione e la conversione dei flussi acquisti generati dal portale web in Ordini Clienti standard all'interno di eSIGEA.

##### 4.3.3.1 Requisiti strutturali del file e mappatura d'ingresso

- Formato e Nome: I file provenienti dal portale web devono essere tassativamente in formato \*\*XML\*\*. La denominazione del file è libera.
- Directory di Input: I file XML devono essere depositati nella cartella server <span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/IMP/ORDC/ELA</span> (oppure scaricati direttamente dal portale via connessione se previsto nei parametri ECO).
- File di Mappatura e Trasformazione: Per elaborare il flusso, l'assistenza deve allocare nella cartella `$PROCLIB/fio` il file di configurazione <span style="font-family: 'courier new', courier, monospace;">WEB0\_IMPO\_ORDC.fio</span> e il foglio di stile <span style="font-family: 'courier new', courier, monospace;">WEB0\_IMPO\_ORDC.xsl</span>, deputato alla trasformazione e alla validazione formale dei dati del file XML. Nel file `.fio` è possibile impostare l'attributo `code\_depo` per forzare l'intestazione dell'ordine a un determinato Deposito aziendale.

##### 4.3.3.2 Tracciato Record Obbligatorio del flusso XML di Import

Il file XML deve presentare una struttura gerarchica divisa in due blocchi informativi, contenenti i seguenti campi:

**1. \*\*Dati di Testata dell'Ordine:\*\***

\* Codice Cliente (Codifica interna del gestionale eSIGEA)

\* Data dell'Ordine

\* Numero identificativo dell'Ordine

\* Data di Consegna richiesta (\*Opzionale\*)

\* Codice della condizione di pagamento (\*Opzionale\*)

**2. \*\*Dati di Corpo dell'Ordine (Righe ripetitive):\*\***

\* Tipo Riga: Campo numerico fisso. Vale `0` per riga Articolo standard; vale `1` per riga addebiti spese di trasporto.

\* Codice Articolo (Codifica interna eSIGEA)

\* Quantità ordinata

\* Prezzo unitario applicato dal portale

\* Percentuali di Sconto: Campi opzionali che mappano dallo Sconto 1 allo Sconto 5.

##### 4.3.3.3 Regole di archiviazione esiti e logica di svincolo

Terminata l'elaborazione del file XML, il sistema sposta il file in base all'esito del parsing e della validazione:

- Esito Positivo (Successo): Il file viene spostato nella cartella storica <span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/IMP/ORDC/SAV</span>.
- Esito Negativo (Errore/Scarto): Il file viene isolato nella cartella di revisione <span style="font-family: 'courier new', courier, monospace;">SPOOL/EXCH/&lt;codiceditta&gt;/WEB0/IMP/ORDC/REV</span>.
- Stato di Evadibilità dell'Ordine: Una volta inseriti a sistema, gli ordini possono essere marcati direttamente come "Evadibili" o bloccati in uno stato sospeso da sottoporre a \*Check Ordini\*. Il comportamento è regolato dal parametro \*\*Check Evadibilità\*\* configurato a livello di ditta in eSIGEA.

<table id="bkmrk-3.4---export-ordinar" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3548%;">#### 4.3.4 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Export Ordinario - Aggiornamento frequente</span>

</td><td style="width: 28.5896%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">EE0</td><td>1.20</td><td>20</td><td>21</td></tr></tbody></table>

</td></tr></tbody></table>

Schedulazione: <span style="font-family: 'courier new', courier, monospace;">EE0 \\ 1.20 \\ 20 \\ 21</span>

Questa variante della procedura di export è attivabile \*\*esclusivamente\*\* tramite lo schedulatore dei processi batch in background. Consente di estrarre un sottoinsieme di tavole critiche con una frequenza temporale molto più ravvicinata (es. allineamento giacenze ogni ora) rispetto al ciclo di export ordinario globale.

**Configurazione**: All'interno dei parametri della stringa di comando dello schedulatore, il tecnico deve valorizzare il campo \*\*Stringa 1\*\* inserendo i codici delle sole tavole da sottoporre ad aggiornamento frequente, separandoli rigidamente con il carattere punto e virgola `;` (Esempio: `ACMG;AABR`).

<table id="bkmrk-3.5---funzione-pubbl" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3548%;">#### 4.3.5 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Funzione Pubblica files</span>

</td><td style="width: 28.5896%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">E29</td><td>2.23</td><td>10</td><td>1</td></tr></tbody></table>

</td></tr></tbody></table>

Percorso: <span style="font-family: 'courier new', courier, monospace;">E29 \\ 2.23 \\ 10 \\ 1</span>

Consente all'operatore di forzare manualmente la trasmissione verso il portale web dei file CSV di export precedentemente generati e rimasti parcheggiati sul server. Questa opzione è adoperata come soluzione di ripiego in caso di guasti temporanei della rete durante l'export automatico.

**Condizione vincolante**: La funzione esegue l'invio \*\*solo se\*\* verifica che la cartella remota di interscambio del portale WEB risulta completamente vuota.

<table id="bkmrk-3.6---funzione-inqui" style="height: 125px; width: 100%;"><tbody><tr><td style="width: 71.3548%;">#### 4.3.6 - <span style="font-size: 12.0pt; line-height: 115%; font-family: 'Aptos',sans-serif; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Aptos; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: IT; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">Funzione Inquiry Ordini Importati</span>

</td><td style="width: 28.5896%;"><table align="right" border="2" cellspacing="2"><tbody><tr><td colspan="5">E29</td><td>2.23</td><td>6</td><td>1</td></tr></tbody></table>

</td></tr></tbody></table>

Percorso: <span style="font-family: 'courier new', courier, monospace;">E29 \\ 2.23 \\ 6 \\ 1</span>

Interfaccia grafica di consultazione a video di tutti gli ordini elettronici transitati dal portale eCOMMERCE verso i registri interni di eSIGEA. La maschera mette a disposizione dell'utente una serie di filtri di ricerca:

- Conto Cliente (Digitando l'intero codice, inserendo solo il Mastro di riferimento per un'estrazione cumulativa, o lasciando a zero per includere tutti i conti).
- Deposito di destinazione.
- Stato dell'Ordine.
- Giro logistico.
- Categoria Clienti / Zona Clienti / Agente commerciale / Spedizioniere.
- Data Ordine (Filtro da data... a data) / Numero Ordine (Da numero... a numero) / Data Consegna (Da data... a data).
- Filtro Condizioni Commerciali: Flag specifico che, se attivato, isola e mostra a video esclusivamente gli ordini importati che presentano discrepanze o anomalie tra i prezzi/sconti applicati dal portale web e le condizioni economiche ufficiali censite nel gestionale alla data dell'ordine.
- Ordinamento: Indicatore per scegliere il criterio di ordinamento e visualizzazione delle righe nella griglia a video.

### 4.4 - Specifiche tecniche e sintassi dei flussi export

#### 4.4.1 - Standard Formattazione File CSV

I file estratti da eSIGEA e inviati verso il database o le cartelle di frontiera rispettano le seguenti specifiche sintattiche di formattazione:

- Delimitatore di colonna: Carattere `Tab` (Tabulazione hardware).
- Separatore dei decimali: Tassativamente il carattere \*\*virgola ( , )\*\*.
- Separatore delle migliaia: Non utilizzato (i numeri vengono esportati come stringa continua).
- Campi fissi di testa per riga: Ogni riga di qualsiasi file CSV esportato deve aprirsi obbligatoriamente con due colonne fisse:

1. `AZIO\_TABE`: Indica l'azione di tipo DML da eseguire sul database del portale web.
2. `TABL\_ID`: Contiene il codice numerico univoco progressivo (ID) della riga della tabella.

Tabella di decodifica del campo AZIO\_TABE

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0valore%C2%A0-%C2%A0azione%C2%A0-%C2%A05" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 66.1761px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Valore </span>

</td><td style="width: 617.304px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="629"><span style="color: black; mso-color-alt: windowtext;"> Azione </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 66.1761px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="55"><span style="color: black; mso-color-alt: windowtext;"> 5 </span>

</td><td style="width: 617.304px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="629"><span style="color: black; mso-color-alt: windowtext;"> Inserimento/Modifica riga nella tavola </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 66.1761px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="55"><span style="color: black; mso-color-alt: windowtext;"> 8 </span>

</td><td style="width: 617.304px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="629"><span style="color: black; mso-color-alt: windowtext;"> Cancellazione riga della tavola </span>

</td></tr><tr style="mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><td style="width: 66.1761px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="55"><span style="color: black; mso-color-alt: windowtext;"> 80 </span>

</td><td style="width: 617.304px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="629"><span style="color: black; mso-color-alt: windowtext;"> Svuotamento completo della tavola (in caso di refresh tavole) </span>

</td></tr></tbody></table>

####  

#### 4.4.2 - Struttura Dettagliata dei Tracciati Record delle Tabelle Esportate

I formati dei campi seguono la legenda: `N` = Numerico intero, `ND` = Numerico decimale (es. `N8D6` indica 8 cifre intere e 6 decimali), `X` = Alfanumerico/Stringa.

##### 4.4.2.1 - TAVOLA `AAT2`: Tabella Condizioni di pagamento

Raccoglie i codici di pagamento. Si relaziona alla tabella clienti `AACC` tramite la colonna comune `CODE\_PAGA`.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio" style="width: 513.3pt; background: white; border-collapse: collapse; height: 224.347px;" width="684"><tbody><tr style="height: 47.1875px;"><td style="width: 134.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt; height: 47.1875px;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 424px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt; height: 47.1875px;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 125.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt; height: 47.1875px;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="height: 46.1222px;"><td style="width: 134.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt; height: 46.1222px;" valign="top" width="86"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 424px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 46.1222px;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Azione tabella </span>

</td><td style="width: 125.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 46.1222px;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="height: 44.1193px;"><td style="width: 134.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt; height: 44.1193px;" valign="top" width="86"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 424px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 44.1193px;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> ID tabella </span>

</td><td style="width: 125.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 44.1193px;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="height: 43.054px;"><td style="width: 134.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt; height: 43.054px;" valign="top" width="86"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_PAGA </span>

</td><td style="width: 424px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 43.054px;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Codice Pagamento </span>

</td><td style="width: 125.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 43.054px;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="height: 43.8636px;"><td style="width: 134.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt; height: 43.8636px;" valign="top" width="86"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_PAGA </span>

</td><td style="width: 424px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 43.8636px;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Pagamento </span>

</td><td style="width: 125.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt; height: 43.8636px;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.2 - TAVOLA `AAT7`: Tabella Porti

Contiene la codifica dei porti di resa merci. Si relaziona alla tabella clienti <span style="font-family: 'courier new', courier, monospace;">AACC</span> tramite la colonna comune <span style="font-family: 'courier new', courier, monospace;">CODE\_PORT</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-1" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 129.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 448px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="596"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 106.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 129.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="88"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 448px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="596"><span style="color: black; mso-color-alt: windowtext;"> Azione tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 129.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="88"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 448px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="596"><span style="color: black; mso-color-alt: windowtext;"> ID tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 129.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="88"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_PORT </span>

</td><td style="width: 448px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="596"><span style="color: black; mso-color-alt: windowtext;"> Codice Porto </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="width: 129.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="88"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_PORT </span>

</td><td style="width: 448px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="596"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Porto </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.3 - TAVOLA `AATC`: Tabella Categoria Clienti

Fornisce la segmentazione commerciale dei clienti. Si relaziona alla tabella `AACC` tramite la colonna <span style="font-family: 'courier new', courier, monospace;">CODE\_CATG</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-2" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 102.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 451px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 130.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 102.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE</span>

</td><td style="width: 451px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Azione tabella </span>

</td><td style="width: 130.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 102.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 451px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> ID tabella </span>

</td><td style="width: 130.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 102.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_CATG </span>

</td><td style="width: 451px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Categoria </span>

</td><td style="width: 130.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="width: 102.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_CATG </span>

</td><td style="width: 451px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Categoria </span>

</td><td style="width: 130.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.4 - TAVOLA `AAT5`: Tabella Gruppi/Sottogruppi Articoli

Definisce l'albero della classificazione merceologica standard degli articoli.

Logica gerarchica di riga: Se il campo <span style="font-family: 'courier new', courier, monospace;">CODE\_SGRU</span> è \*\*uguale a 0\*\*, la riga descrive un Gruppo principale. Se il campo <span style="font-family: 'courier new', courier, monospace;">CODE\_SGRU</span> è \*\*maggiore di 0\*\*, la riga rappresenta un Sottogruppo analitico.

Si relaziona all'Anagrafica Articoli <span style="font-family: 'courier new', courier, monospace;">AAMG</span> tramite l'accoppiata dei campi <span style="font-family: 'courier new', courier, monospace;">CODE\_SETT</span> e <span style="font-family: 'courier new', courier, monospace;">CODE\_SGRU</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-3" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 117.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 417px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 149.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="93"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 417px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; font-family: 'courier new', courier, monospace;"> Azione tabella </span>

</td><td style="width: 149.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="93"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 417px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; font-family: 'courier new', courier, monospace;"> ID tabella </span>

</td><td style="width: 149.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="93"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_SETT</span>

</td><td style="width: 417px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; font-family: 'courier new', courier, monospace;"> Codice Gruppo Articoli </span>

</td><td style="width: 149.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N4 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="93"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_SGRU</span>

</td><td style="width: 417px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; font-family: 'courier new', courier, monospace;"> Codice Sottogruppo Articoli </span>

</td><td style="width: 149.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N4 </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="93"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_CATG</span>

</td><td style="width: 417px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="591"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Gruppo/Sottogruppo Articoli </span>

</td><td style="width: 149.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.5 - TAVOLA `AETA`: ECR - Reparti

Contiene la codifica dei Reparti secondo lo standard di classificazione ECR. Si relaziona alle tabelle gerarchiche <span style="font-family: 'courier new', courier, monospace;">AETF</span> e <span style="font-family: 'courier new', courier, monospace;">AETB</span> tramite il campo <span style="font-family: 'courier new', courier, monospace;">TABL\_ID</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-4" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 145.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 422.992px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="575"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 115.175px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 145.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 422.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="575"><span style="color: black; font-family: 'courier new', courier, monospace;"> Azione tabella </span>

</td><td style="width: 115.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 145.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 422.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="575"><span style="color: black; font-family: 'courier new', courier, monospace;"> ID tabella </span>

</td><td style="width: 115.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 145.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_REPR</span>

</td><td style="width: 422.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="575"><span style="color: black; font-family: 'courier new', courier, monospace;"> Codice Reparto </span>

</td><td style="width: 115.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; font-family: 'courier new', courier, monospace;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="width: 145.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_REPR</span>

</td><td style="width: 422.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="575"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Reparto </span>

</td><td style="width: 115.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.6 - TAVOLA `AETB`: ECR - Settori

Rappresenta i Settori ECR. Si collega a monte ad `AETA` tramite il campo `AETA\_ID` (corrispondente al `TABL\_ID` della tabella `AETA`) e a valle alle Famiglie `AETC` tramite il proprio `TABL\_ID`.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-5" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 125.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 452px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 106.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 125.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="98"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 452px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 125.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="98"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 452px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 125.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="98"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_SETT</span>

</td><td style="width: 452px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> Codice Settore </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 125.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="98"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_SETT</span>

</td><td style="width: 452px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Settore </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 125.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="98"><span style="color: black; font-family: 'courier new', courier, monospace;">AETA\_ID</span>

</td><td style="width: 452px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="586"><span style="color: black; mso-color-alt: windowtext;"> ID Reparti ECR (AETA). *Relazionata a TABL\_ID di AETA.* </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.7 - TAVOLA `AETC`: ECR - Famiglie

Identifica le Famiglie ECR. Si collega a monte ad `AETB` tramite il campo `AETB\_ID` e a valle alle Sub-famiglie `AETD` tramite il proprio `TABL\_ID`.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-6" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 117.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 445px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 121.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="95"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 445px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 121.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="95"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 445px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 121.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="95"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_FAMI</span>

</td><td style="width: 445px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> Codice Famiglia </span>

</td><td style="width: 121.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="95"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_FAMI</span>

</td><td style="width: 445px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Famiglia </span>

</td><td style="width: 121.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="95"><span style="color: black; font-family: 'courier new', courier, monospace;">AETB\_ID</span>

</td><td style="width: 445px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="589"><span style="color: black; mso-color-alt: windowtext;"> ID Settori ECR (AETB). *Relazionata a TABL\_ID di AETB.* </span>

</td><td style="width: 121.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.8 - TAVOLA `AETD`: ECR - Sub-famiglie

Identifica le Sub-famiglie ECR. Si collega a monte ad <span style="font-family: 'courier new', courier, monospace;">AETC</span> tramite il campo `<span style="font-family: 'courier new', courier, monospace;">AETC\_ID</span>` e a valle ai Gruppi ECR <span style="font-family: 'courier new', courier, monospace;">AETE</span> tramite il proprio <span style="font-family: 'courier new', courier, monospace;">TABL\_ID</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-7" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 108.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 475px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 100.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 108.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 475px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;">Azione Tabella </span>

</td><td style="width: 100.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 108.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 475px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;">ID Tabella </span>

</td><td style="width: 100.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 108.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_SUBF</span>

</td><td style="width: 475px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;">Codice Sub-famiglia </span>

</td><td style="width: 100.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 108.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_SUBF</span>

</td><td style="width: 475px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;">Descrizione Sub-famiglia </span>

</td><td style="width: 100.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 108.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">AETC\_ID</span>

</td><td style="width: 475px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="599"><span style="color: black; mso-color-alt: windowtext;">ID Famiglie ECR (AETC). *Relazionata a TABL\_ID di AETC.* </span>

</td><td style="width: 100.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.9 - TAVOLA `AETE`: ECR - Gruppi

Rappresenta l'ultimo livello di scomposizione della classificazione. Si relaziona a monte alla Sub-famiglia tramite l'attributo `AETD\_ID`.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-8" style="width: 684px; background: white; border-collapse: collapse;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 126.483px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 556.85px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 126.483px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 556.85px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 126.483px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID </span>

</td><td style="width: 556.85px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 126.483px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_GRUP</span>

</td><td style="width: 556.85px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Codice Gruppo </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 126.483px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_GRUP</span>

</td><td style="width: 556.85px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Gruppo </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 126.483px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="85"><span style="color: black; font-family: 'courier new', courier, monospace;">AETD\_ID</span>

</td><td style="width: 556.85px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="598"><span style="color: black; mso-color-alt: windowtext;"> ID Sub-famiglie ECR (AETC). *Relazionata a TABL\_ID di AETD.* </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.10 - TAVOLA `AETF`: Classificazione Articoli (ECR)

Tavola di sintesi che mappa la stringa ECR completa da associare ai prodotti. Si collega all'Anagrafica Articoli `AAMG` tramite la colonna chiave `CODE\_\_ECR`. Contiene i puntatori diretti a tutta la gerarchia ECR precedentemente descritta.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-9" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 107.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;">Colonna</span>

</td><td style="width: 491px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 85.1667px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AZIO\_TABE</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">Azione Tabella </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">TABL\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Tabella </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">CODE\_\_ECR</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">Codice ECR </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N10 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">DESC\_GRUP</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">Descrizione ECR </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AETA\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Reparti ECR (AETA). *Relazionata a TABL\_ID di AETA.* </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AETB\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Reparti ECR (AETB). *Relazionata a TABL\_ID di AETB.* </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AETC\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Reparti ECR (AETC). *Relazionata a TABL\_ID di AETC.* </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AETD\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Reparti ECR (AETD). *Relazionata a TABL\_ID di AETD.* </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 9; mso-yfti-lastrow: yes;"><td style="width: 107.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="91"><span style="color: black; font-family: 'courier new', courier, monospace;">AETE\_ID</span>

</td><td style="width: 491px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="593"><span style="color: black; mso-color-alt: windowtext;">ID Reparti ECR (AETE). *Relazionata a TABL\_ID di AETE.* </span>

</td><td style="width: 85.1667px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.11 - TAVOLA `AATM`: Voci Complementari (Tariffario Spese di Trasporto)

Contiene le matrici numeriche e i parametri adoperati dall'algoritmo di calcolo per determinare le spese di spedizione degli ordini web. Si collega all'Anagrafica Clienti <span style="font-family: 'courier new', courier, monospace;">AACC</span> tramite il campo <span style="font-family: 'courier new', courier, monospace;">CODE\_VOCC</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-10" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 110.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 465px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 108.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_VOCC </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> Codice Tabella Tariffario Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_VOCC </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Tariffario Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X50 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> SPES\_FISS </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> Importo Costo Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N6D4 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> SPES\_PERC </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> % da applicare sul Valore Ordine per calcolo Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC01 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 1° massimale Valore Ordine per calcolo Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC01 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 1° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 9;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC02 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 2° massimale Valore Ordine per calcolo Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 10;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC02 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 2° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 11;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC03 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 3° massimale Valore Ordine per calcolo Trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 12;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC03 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 3° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 13;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC04 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 4° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 14;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC04 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 4° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 15;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC05 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 5° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 16;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC05 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 5° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 17;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC06 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 6° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 18;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC06 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 6° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 19;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC07 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 7° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 20;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC07 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 7° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 21;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC08 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 8° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 22;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC08 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 8° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr><tr style="mso-yfti-irow: 23;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> MAXI\_SC09 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 9° massimale Valore Ordine per calcolo trasporto </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9D2 </span>

</td></tr><tr style="mso-yfti-irow: 24; mso-yfti-lastrow: yes;"><td style="width: 110.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="103"><span style="color: black; font-family: 'courier new', courier, monospace;"> VALO\_SC09 </span>

</td><td style="width: 465px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="580"><span style="color: black; mso-color-alt: windowtext;"> 9° importo Costo Trasporto in base al massimale </span>

</td><td style="width: 108.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N7D5 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.12 - TAVOLA `AACC`: Anagrafica Clienti

Raccoglie i record anagrafici, fiscali e le regole di configurazione commerciale per ogni singolo cliente abilitato.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-11" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 124.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 423px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 136.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_CONT </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Conto Cliente </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_CONT </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Denominazione Cliente </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> STAT\_RECO </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Stato del Cliente. Può assumere i seguenti valori:   
  
</span>

- <span style="color: black; mso-color-alt: windowtext;">A = Attivo</span>
- <span style="color: black; mso-color-alt: windowtext;">C = Cessato (in via di estinzione)</span>
- <span style="color: black; mso-color-alt: windowtext;">D = Disattivo</span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X1 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> INDR\_DOFI </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Indirizzo domicilio fiscale </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CITT\_DOFI </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Città domicilio fiscale </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CAP\_\_DOFI </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> C.a.p. domicilio fiscale </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 9;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> PROV\_DOFI </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Sigla Provincia domicilio fiscale </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X2 </span>

</td></tr><tr style="mso-yfti-irow: 10;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_FISC </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice fiscale </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X16 </span>

</td></tr><tr style="mso-yfti-irow: 11;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> PART\_IVAC </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Partita IVA </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X14 </span>

</td></tr><tr style="mso-yfti-irow: 12;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> LISP\_FATT </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Numero Listino fatturazione (assume valori da 1 a 8) </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 13;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> LISP\_PUBL </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Numero Listino al pubblico (assume valori da 1 a 8) </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 14;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_CATG </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Categoria Clienti. *Relazionata a CODE\_CATG di AATC.* </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 15;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_PAGA </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Condizione pagamento. *Relazionata a CODE\_PAGA di AAT2.* </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 16;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_PORT </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Porto. *Relazionata a CODE\_PAGA di AAT7.* </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 17;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> VOCC\_TRAS </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice tariffario trasporti. *Relazionata a CODE\_VOCC di AATM.* </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 18;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_SCON </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice tabella sconti. *Relazionata a CODE\_SCON di ASCP.* </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 19;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCON </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> % Sconto da applicare su ciascuna riga dell'Ordine </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 20;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> NOTE\_CLIE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Annotazione Cliente </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X30 </span>

</td></tr><tr style="mso-yfti-irow: 21;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> NOTE\_AGGV </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Ulteriore annotazione Cliente </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X250 </span>

</td></tr><tr style="mso-yfti-irow: 22;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> RSOC\_DIVE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Ragione sociale diversa destinazione merce </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 23;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> INDR\_DIVE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Indirizzo diverso destinazione merce </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 24;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CITT\_DIVE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Città diversa destinazione merce </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr><tr style="mso-yfti-irow: 25;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CAP\_\_DIVE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> C.a.p. diverso destinazione merce </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 26;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> PROV\_DIVE </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Sigla Provincia diversa destinazione merce </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X2 </span>

</td></tr><tr style="mso-yfti-irow: 27;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_RCON </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Rapporto Contabile </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9 </span>

</td></tr><tr style="mso-yfti-irow: 28; mso-yfti-lastrow: yes;"><td style="width: 124.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="100"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_RCON </span>

</td><td style="width: 423px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Ragione sociale Rapporto Contabile </span>

</td><td style="width: 136.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X90 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.13 - AAMG: Anagrafica Articoli

In questa tavola è presente l'Anagrafica degli Articoli.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-12" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 118.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 459px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 106.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_ARTK </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Codice Articolo </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_ARTK </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Descrizione Articolo </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X40 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> STAT\_RECO </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Stato dell'Articolo. Può assumere i seguenti valori:   
  
</span>

- <span style="color: black; mso-color-alt: windowtext;">A = Attivo</span>
- <span style="color: black; mso-color-alt: windowtext;">B = Attivo per rete commerciale</span>
- <span style="color: black; mso-color-alt: windowtext;">D = Disattivo</span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X1 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_SETT </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Codice Settore. *Relazionata a CODE\_SETT di AAT5.* </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_SGRU </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Codice Sottogruppo. *Relazionata a CODE\_SGRU di AAT5.* </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_\_ECR </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Codice ECR. *Relazionata a CODE\_\_ECR di AETF.* </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N10 </span>

</td></tr><tr style="mso-yfti-irow: 9;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> COAR\_SOST </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> 1° Codice Articolo sostitutivo/alternativo </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 10;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> COAR\_SOS2 </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> 2° Codice Articolo sostitutivo/alternativo </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 11;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> COAR\_SOS3 </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> 3° Codice Articolo sostitutivo/alternativo </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 12;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> DESC\_UMIS </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Unità di misura </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X2 </span>

</td></tr><tr style="mso-yfti-irow: 13;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> GIOR\_VALI </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Giorni shelf-life </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N4 </span>

</td></tr><tr style="mso-yfti-irow: 14;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> GIOR\_VAL2 </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Giorni di logistica </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N4 </span>

</td></tr><tr style="mso-yfti-irow: 15;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> PEZZ\_CONF </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Pezzi per confezione </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N4 </span>

</td></tr><tr style="mso-yfti-irow: 16;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> PESN\_UNPZ </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Peso netto per pezzo, espresso in kg </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N4D6 </span>

</td></tr><tr style="mso-yfti-irow: 17;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> PESL\_UNPZ </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Peso lordo per pezzo, espresso in kg </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N4D6 </span>

</td></tr><tr style="mso-yfti-irow: 18;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> VOLM\_UNPZ </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Volume per pezzo, espresso in cm³ </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5D3 </span>

</td></tr><tr style="mso-yfti-irow: 19;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> VOLM\_UNCO </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Volume per confezione, espresso in cm³ </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5D3 </span>

</td></tr><tr style="mso-yfti-irow: 20;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> NCON\_STRA </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Numero colli per strato </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 21;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> NUMR\_STRA </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Numero strati per pallet </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 22;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> IDEN\_TRAF </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Identificativo trafila </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X4 </span>

</td></tr><tr style="mso-yfti-irow: 23;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> GRUP\_SCON </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Gruppo Sconti. Utile per determinare le % di sconto. </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 24;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> QESI\_ACTL </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Giacenza dell'Articolo espressa nell'unità di misura. </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D3 </span>

</td></tr><tr style="mso-yfti-irow: 25; mso-yfti-lastrow: yes;"><td style="width: 118.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="108"><span style="color: black; font-family: 'courier new', courier, monospace;"> UMIN\_VEND </span>

</td><td style="width: 459px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="576"><span style="color: black; mso-color-alt: windowtext;"> Unità minima di vendita (se 10 o 15 può accettare anche input qtà) </span>

</td><td style="width: 106.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.14 - TAVOLA `AABR`: Anagrafica Codici EAN Articoli

Associa i codici a barre ai prodotti. Il campo `DATE\_VALI` determina l'inizio della validità temporale del codice.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-13" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 144.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 404px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 135.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 144.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="102"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 404px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 135.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 144.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="102"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 404px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 135.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 144.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="102"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_ARTK </span>

</td><td style="width: 404px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> Codice Articolo. *Relazionata a CODE\_ARTK di AAMG.* </span>

</td><td style="width: 135.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 144.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="102"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_\_EAN </span>

</td><td style="width: 404px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> Codice EAN </span>

</td><td style="width: 135.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N14 </span>

</td></tr><tr style="mso-yfti-irow: 5; mso-yfti-lastrow: yes;"><td style="width: 144.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="102"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_VALI </span>

</td><td style="width: 404px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="582"><span style="color: black; mso-color-alt: windowtext;"> Data Inizio Validità Codice EAN (nel formato AAAAMMGG) </span>

</td><td style="width: 135.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.15 - TAVOLA `AALV`: Listino Prezzi Articoli

Contiene i prezzi monetari lordi. I campi `DATE\_INIZ` e `DATE\_FINE` circoscrivono il range temporale di validità del listino.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-14" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 127.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 429px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 127.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_ARTK </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Codice Articolo. *Relazionata a CODE\_ARTK di AAMG* </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_INIZ </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Data inizio validità listino (espressa nel formato AAAAMMGG) </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_FINE </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> Data fine validità listino (espressa nel formato AAAAMMGG) </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS1 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 1° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS2 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 2° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS3 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 3° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 9;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS4 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 4° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 10;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS5 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 5° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 11;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS6 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 6° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 12;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS7 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 7° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 13; mso-yfti-lastrow: yes;"><td style="width: 127.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="99"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_LIS8 </span>

</td><td style="width: 429px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="584"><span style="color: black; mso-color-alt: windowtext;"> 8° Prezzo del Listino </span>

</td><td style="width: 127.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.16 - TAVOLA `ASCP`: Tabella Sconti

Rappresenta la matrice bidimensionale per il calcolo delle catene di sconti. L'accesso avviene incrociando il codice sconto del cliente con il gruppo sconto del prodotto.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-15" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 117.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 443.992px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 122.175px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_SCON </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> Codice Tabella Sconti </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N5 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> GRUP\_SCON </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> Gruppo Sconti </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCO1 </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> 1° percentuale sconto </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCO2 </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> 2° percentuale sconto </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCO3 </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> 3° percentuale sconto </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCO4 </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> 4° percentuale sconto </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr><tr style="mso-yfti-irow: 9; mso-yfti-lastrow: yes;"><td style="width: 117.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="96"><span style="color: black; font-family: 'courier new', courier, monospace;"> PERC\_SCO5 </span>

</td><td style="width: 443.992px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="588"><span style="color: black; mso-color-alt: windowtext;"> 5° percentuale sconto </span>

</td><td style="width: 122.175px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr></tbody></table>

#####  

##### 4.4.2.17 - TAVOLA `MCPB`: Promozioni/Volantini - Beneficiari

Contiene l'anagrafica dei clienti inclusi in contratti promozionali.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-16" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 123.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 455px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 105.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> CCOM\_ID </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Identificativo campagna promozionale </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> TIPO\_CCOM </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Tipologia campagna promozionale. Può assumere i seguenti valori:   
  
</span>

- <span style="color: black; mso-color-alt: windowtext;"> 5 = promozione</span>
- <span style="color: black; mso-color-alt: windowtext;"> 7 = canvass</span>
- <span style="color: black; mso-color-alt: windowtext;">10 = volantino</span>
- <span style="color: black; mso-color-alt: windowtext;">50 = listino dedicato per cliente</span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_CONT </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Codice Cliente Beneficiario. *Relazionata a CODE\_CONT di AACC.* </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N9 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_SLII </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Data d'inizio sell-in (nel formato AAAAMMGG) </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_SLIF </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Data di fine sell-in (nel formato AAAAMMGG) </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr><tr style="mso-yfti-irow: 8;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_SLOI </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Data d'inizio sell-out (nel formato AAAAMMGG) </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr><tr style="mso-yfti-irow: 9; mso-yfti-lastrow: yes;"><td style="width: 123.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="106"><span style="color: black; font-family: 'courier new', courier, monospace;"> DATE\_SLOF </span>

</td><td style="width: 455px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="578"><span style="color: black; mso-color-alt: windowtext;"> Data di fine sell-out (nel formato AAAAMMGG) </span>

</td><td style="width: 105.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8 </span>

</td></tr></tbody></table>

**Logica di visualizzazione Banner Volantini sul Portale Web**: Per stabilire se attivare e mostrare a schermo il banner grafico dei prodotti in offerta a un determinato utente, l'applicazione web deve interrogare in tempo reale la tavola `MCPB` inserendo come chiavi di ricerca la data corrente dell'ordine (o della consegna) ed il codice del cliente loggato.

Se il cliente viene intercettato in una riga in cui l'attributo `TIPO\_CCOM` è uguale al valore `10` (Volantino), la piattaforma estrae i prodotti in offerta associati dalla tabella correlata `MCPP` e visualizza il banner.

Se per quel determinato codice cliente non viene trovata alcuna corrispondenza attiva per la data indicata, la visualizzazione del banner sul portale eCOMMERCE deve rimanere tassativamente \*\*disattivata\*\*.

##### 4.4.2.18 - TAVOLA `MCPP`: Promozioni/Volantini - Articoli

Contiene l'elenco degli articoli in offerta agganciati alle campagne contrattualizzate nella tabella <span style="font-family: 'courier new', courier, monospace;">MCPB</span>.

<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" id="bkmrk-%C2%A0colonna%C2%A0-%C2%A0descrizio-17" style="width: 513.3pt; background: white; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="684"><tbody><tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><td style="width: 114.167px; border: 1pt solid rgb(221, 221, 221); background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Colonna </span>

</td><td style="width: 458px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Descrizione </span>

</td><td style="width: 111.167px; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: rgb(221, 221, 221) rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; border-image: initial; background: rgb(202, 228, 255); padding: 4.5pt 6pt;" valign="top" width="5%"><span style="color: black; mso-color-alt: windowtext;"> Formato </span>

</td></tr><tr style="mso-yfti-irow: 1;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> AZIO\_TABE </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Azione Tabella </span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 2;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> TABL\_ID </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> ID Tabella </span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 3;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> CCOM\_ID </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Identificativo campagna promozionale </span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N12 </span>

</td></tr><tr style="mso-yfti-irow: 4;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> CODE\_ARTK </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Codice Articolo. *Relazionata a CODE\_ARTK di AAMG.* </span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> X18 </span>

</td></tr><tr style="mso-yfti-irow: 5;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> APPL\_PRIO </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Livello priorità </span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 6;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> TIPO\_BENF </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Tipo beneficio. Può assumere i seguenti valori:  
  
</span>

- <span style="color: black; mso-color-alt: windowtext;">1 = Prezzo lordo</span>
- <span style="color: black; mso-color-alt: windowtext;">2 = Sconto integrativo</span>
- <span style="color: black; mso-color-alt: windowtext;">3 = Sconto sostitutivo</span>
- <span style="color: black; mso-color-alt: windowtext;">4 = Prezzo netto</span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N2 </span>

</td></tr><tr style="mso-yfti-irow: 7;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> PREZ\_CCOM </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> Prezzo. Valido solo in caso di TIPO\_BENF uguale a 1 o 4.</span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N8D6 </span>

</td></tr><tr style="mso-yfti-irow: 8; mso-yfti-lastrow: yes;"><td style="width: 114.167px; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221); border-image: initial; padding: 4.5pt 6pt;" valign="top" width="118"><span style="color: black; font-family: 'courier new', courier, monospace;"> SCON\_CCOM </span>

</td><td style="width: 458px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="566"><span style="color: black; mso-color-alt: windowtext;"> % Sconto. Valido solo in caso di TIPO\_BENF uguale a 2 o 3.</span>

</td><td style="width: 111.167px; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: currentcolor rgb(221, 221, 221) rgb(221, 221, 221) currentcolor; padding: 4.5pt 6pt;" valign="top" width="0"><span style="color: black; mso-color-alt: windowtext;"> N3D2 </span>

</td></tr></tbody></table>

###  

### 4.5 - Logiche di calcolo delle condizioni commerciali

L'applicazione corretta delle condizioni economiche sul portale eCOMMERCE deve combinare in modo deterministico i dati estratti dalle anagrafiche, dai listini standard e dalle tabelle promozionali attive alla data dell'ordine.

#### 4.5.1 - Algoritmo Sequenziale a Cascata per la Determinazione del Prezzo di Vendita

Il motore di calcolo esegue un controllo rigorosamente sequenziale (a cascata), basato sulla data dell'operazione, incrociando il Codice Cliente ed il Codice Articolo all'interno delle tabelle <span style="font-family: 'courier new', courier, monospace;">MCPB</span> e <span style="font-family: 'courier new', courier, monospace;">MCPP</span> per verificare la presenza di benefici di tipo "Prezzo Lordo" (valore `1`) o "Prezzo Netto" (valore `4`). La gerarchia dei controlli segue questo ordine fisso:

\[Inizio Calcolo Prezzo\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[1. Cerca Volantino in <span style="font-family: 'courier new', courier, monospace;">MCPB/MCPP (TIPO\_CCOM = 10</span>)\] ── Trovato ──<span style="font-family: 'Arial',sans-serif;">►</span> \[Preleva Prezzo da <span style="font-family: 'courier new', courier, monospace;">MCPP</span>\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>Assente

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[2. Cerca Promozione in <span style="font-family: 'courier new', courier, monospace;">MCPB/MCPP (TIPO\_CCOM = 5</span>)\] ── Trovato ──<span style="font-family: 'Arial',sans-serif;">►</span> \[Preleva Prezzo da <span style="font-family: 'courier new', courier, monospace;">MCPP</span>\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>Assente

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[3. Cerca Canvass in <span style="font-family: 'courier new', courier, monospace;">MCPB/MCPP (TIPO\_CCOM = 7</span>)\] ─── Trovato ──<span style="font-family: 'Arial',sans-serif;">►</span> \[Preleva Prezzo da <span style="font-family: 'courier new', courier, monospace;">MCPP</span>\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>Assente

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[4. Cerca Listino Dedicato in MCPB/MCPP (TIPO\_CCOM = 50)\] ─ Trovato ─<span style="font-family: 'Arial',sans-serif;">►</span> \[Preleva Prezzo da MCPP\]

<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>Assente

<span style="mso-spacerun: yes;"> </span><span style="font-family: 'Arial',sans-serif;">▼</span>

\[5. Applica Listino Standard da <span style="font-family: 'courier new', courier, monospace;">AALV</span>\]

<span style="mso-spacerun: yes;"> </span>┌───────<span lang="EN-US" style="font-family: 'MS Gothic'; mso-bidi-font-family: 'MS Gothic';">┴</span><span style="mso-ascii-font-family: Aptos; mso-hansi-font-family: Aptos; mso-bidi-font-family: Aptos;">─────────────────────────────────────────────────────────────────┐</span>

<span style="mso-spacerun: yes;"> </span>│ 1. Legge il campo <span style="font-family: 'courier new', courier, monospace;">LISP\_FATT </span>nell'Anagrafica Cliente (<span style="font-family: 'courier new', courier, monospace;">AACC</span>).<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>│ 2. Estrae il prezzo dalla colonna di AALV corrispondente all'indice.<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>│<span style="mso-spacerun: yes;"> </span>(Es: Se <span style="font-family: 'courier new', courier, monospace;">LISP\_FATT = 3</span> ──<span style="font-family: 'Arial',sans-serif;">►</span> Legge A<span style="font-family: 'courier new', courier, monospace;">ALV.PREZ\_LIS3</span>)<span style="mso-spacerun: yes;"> </span><span style="mso-ascii-font-family: Aptos; mso-hansi-font-family: Aptos; mso-bidi-font-family: Aptos;">│</span>

<span style="mso-spacerun: yes;"> </span>│ 3. Valida la corrispondenza temporale con <span style="font-family: 'courier new', courier, monospace;">DATE\_INIZ e DATE\_FINE</span>.<span style="mso-spacerun: yes;"> </span>│

<span style="mso-spacerun: yes;"> </span>└─────────────────────────────────────────────────────────────────────────┘

#### 4.5.2 - Iter di Determinazione delle Percentuali di Sconto di Riga

Il sistema eSIGEA prevede l'applicazione in cascata aritmetica di un numero \*\*massimo di 5 percentuali di sconto\*\* sulla medesima riga d'ordine.

**Regola di esclusione totale**: Qualora l'algoritmo al punto precedente (Fase 5.1) abbia intercettato una condizione promozionale con beneficio impostato su \*\*"Prezzo Netto"\*\* (<span style="font-family: 'courier new', courier, monospace;">TIPO\_BENF</span> = 4), tutte le percentuali di sconto di riga vengono azzerate e non viene applicato nessuno sconto.

In caso contrario, la catena dei 5 sconti viene valorizzata seguendo la seguente sequenza logica:

1\. \*\*Estrazione Sconti Standard Matrice:\*\* Il sistema interroga la tabella sconti <span style="font-family: 'courier new', courier, monospace;">ASCP</span> estraendo la riga che presenta la combinazione tra il codice sconto del cliente (<span style="font-family: 'courier new', courier, monospace;">AACC.CODE\_SCON</span>) ed il gruppo sconti dell'articolo (<span style="font-family: 'courier new', courier, monospace;">AAMG.GRUP\_SCON</span>). Le percentuali valorizzate si posizionano in sequenza sulle prime colonne di sconto (dallo Sconto 1 a salire).

2\. \*\*Iniezione Sconti Promozionali:\*\* Si verifica la presenza in `MCPB` di una Promozione attiva (<span style="font-family: 'courier new', courier, monospace;">TIPO\_CCOM = 5</span>) che contenga un beneficio di tipo Sconto.

\* Se il beneficio è un \*\*"Sconto sostitutivo"\*\* (<span style="font-family: 'courier new', courier, monospace;">TIPO\_BENF = 3</span>): La percentuale promozionale <span style="font-family: 'courier new', courier, monospace;">MCPP.SCON\_CCOM</span> cancella e sostituisce interamente tutti gli sconti precedentemente estratti dalla matrice standard.

\* Se il beneficio è un \*\*"Sconto integrativo"\*\* (<span style="font-family: 'courier new', courier, monospace;">TIPO\_BENF = 2</span>): La percentuale promozionale si inietta e si posiziona sulla prima colonna di sconto rimasta vuota ed inutilizzata nella catena dei 5 sconti standard.

\* \*Esempio di integrazione A:\* Se la matrice standard occupava solo le prime 2 colonne di sconto, lo sconto promozionale si posiziona come 3° sconto della riga.

\* \*Esempio di integrazione B (Saturazione):\* Nel caso in cui la matrice standard della tabella <span style="font-family: 'courier new', courier, monospace;">ASCP</span> avesse già occupato tutte e 5 le colonne di sconto disponibili, lo sconto promozionale si somma matematicamente al valore numerico già presente nella quinta colonna di sconto.

3\. \*\*Applicazione Sconto Anagrafica Cliente:\*\* Qualora non vi siano promozioni attive sulla riga, l'algoritmo verifica il campo <span style="font-family: 'courier new', courier, monospace;">AACC.PERC\_SCON</span> nell'Anagrafica del Cliente. Se superiore a zero, questa percentuale viene applicata come valore integrativo inserendosi sulla prima colonna di sconto libera della catena o sommandosi al quinto sconto in caso di totale saturazione.

#### 4.5.3 - Calcolo Matematico del Netto Riga

Ottenuti il Prezzo Lordo e la catena delle percentuali di sconto, il calcolo del valore netto di riga si articola in due passi:

1\. \*\*Determinazione del Prezzo Netto Unitario:\*\* Si applicano in successione aritmetica le percentuali di sconto determinate sul valore del Prezzo Lordo. Il formato del prezzo netto prevede un massimo di \*\*6 decimali\*\*. Durante i passaggi di calcolo intermedi delle percentuali, il valore risultante \*\*non deve subire alcun arrotondamento\*\* al sesto decimale, bensì viene applicato un \*\*troncamento\*\* netto alla sesta cifra decimale.

2\. \*\*Calcolo del Netto di Riga Complessivo:\*\* Si moltiplica il Prezzo Netto Unitario troncato per la Quantità di prodotto inserita nell'ordine. Il valore monetario del Netto Riga finale viene espresso con \*\*2 decimali\*\*, applicando l'\*\*arrotondamento\*\* standard in conformità alle direttive legislative europee.

#### 4.5.4 - Algoritmo per il Calcolo delle Spese di Trasporto

Le spese di spedizione da imputare in riga (Tipo riga = 1) all'interno dell'ordine vengono calcolate estraendo i parametri dal tariffario `AATM` secondo i seguenti passaggi:

1\. Il sistema legge il valore contenuto nel campo <span style="font-family: 'courier new', courier, monospace;">AACC.VOCC\_TRAS</span> dall'Anagrafica Cliente per individuare la riga corrispondente nella tabella del tariffario trasporti <span style="font-family: 'courier new', courier, monospace;">AATM</span>.

2\. Se il codice <span style="font-family: 'courier new', courier, monospace;">AACC.VOCC\_TRAS</span> è \*\*maggiore di zero\*\*, l'algoritmo preleva la quota fissa espressa nel campo <span style="font-family: 'courier new', courier, monospace;">AATM.SPES\_FISS</span> e la imposta come base di partenza del costo.

3\. Alle spese fisse viene sommata la componente variabile, calcolata applicando l'aliquota percentuale contenuta nel campo <span style="font-family: 'courier new', courier, monospace;">AATM.SPES\_PERC</span> sul valore imponibile complessivo dell'ordine web.

4\. Infine, il sistema analizza il valore totale dell'ordine e lo confronta sequenzialmente con gli scaglioni di massimale censiti nei campi da <span style="font-family: 'courier new', courier, monospace;">AATM.MAXI\_SC01</span> a <span style="font-family: 'courier new', courier, monospace;">AATM.MAXI\_SC09</span>. Al superamento di uno scaglione, viene estratto il corrispondente valore di costo inserito nei campi da <span style="font-family: 'courier new', courier, monospace;">AATM.VALO\_SC01</span> a `AATM.VALO\_SC09` e sommato al totale delle spese di trasporto dell'ordine.

### 4.6 - Note tecniche per l'assistenza: Tracciato nuovi campi

A corredo dell'integrazione nativa delle logiche commerciali per i canali B2B e B2C aziendali, all'interno delle tabelle del database di eSIGEA sono stati inseriti i seguenti campi integrativi che devono essere mappati nei flussi.

#### 4.6.1 - Campi Aggiuntivi su Tabella `AACC` (Anagrafica Clienti)

<table border="1" id="bkmrk-indr__pec-stringa-al" style="border-collapse: collapse; width: 96.6667%; height: 482.259px;"><colgroup><col style="width: 16.9078%;"></col><col style="width: 83.2056%;"></col></colgroup><tbody><tr style="height: 46.5057px;"><td style="height: 46.5057px;"><span style="font-family: 'courier new', courier, monospace;">INDR\_\_PEC</span>

</td><td style="height: 46.5057px;">Stringa alfanumerica contenente l'indirizzo PEC (Posta Elettronica Certificata) aziendale principale del cliente</td></tr><tr style="height: 31.5199px;"><td style="height: 31.5199px;"><span style="font-family: 'courier new', courier, monospace;">UAMM\_\_PEC</span></td><td style="height: 31.5199px;">Indirizzo PEC specifico adibito alle comunicazioni dell'ufficio amministrativo</td></tr><tr style="height: 31.5199px;"><td style="height: 31.5199px;"><span style="font-family: 'courier new', courier, monospace;">UFIN\_\_PEC</span></td><td style="height: 31.5199px;">Indirizzo PEC specifico per le comunicazioni dell'ufficio finanza e tesoreria</td></tr><tr style="height: 31.5199px;"><td style="height: 31.5199px;"><span style="font-family: 'courier new', courier, monospace;">UCOM\_\_PEC</span></td><td style="height: 31.5199px;">Indirizzo PEC specifico per le comunicazioni dell'ufficio commerciale</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;"><span style="font-family: 'courier new', courier, monospace;">CODE\_\_SDI</span>

</td><td style="height: 46.5057px;">Codice alfanumerico di 7 caratteri che identifica l'indirizzo telematico univoco (SDI) per l'invio della fatturazione elettronica</td></tr><tr style="height: 62.9261px;"><td style="height: 62.9261px;"><span style="font-family: 'courier new', courier, monospace;">TIPG\_CONT</span></td><td style="height: 62.9261px;">Campo di classificazione per determinare la tipologia di conto aziendale utilizzato, distinguendo gli account abilitati alla \*Fatturazione\* dagli account logistici abilitati alla sola \*Consegna\*</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;"><span style="font-family: 'courier new', courier, monospace;">VALR\_COLL</span></td><td style="height: 46.5057px;">Campo numerico decimale che definisce il valore minimo in Euro richiesto per ogni singolo collo d'ordine in fase di checkout sul portale</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;"><span style="font-family: 'courier new', courier, monospace;">VALM\_ORDN</span>

</td><td style="height: 46.5057px;">Valore monetario imponibile minimo complessivo richiesto come soglia per permettere al cliente la convalida e l'invio dell'ordine dal web</td></tr><tr style="height: 46.1222px;"><td style="height: 46.1222px;"><span style="font-family: 'courier new', courier, monospace;">COLM\_ORDN</span></td><td style="height: 46.1222px;">Quantità numerica minima di colli totali obbligatori da inserire all'interno del carrello per validare l'ordine</td></tr><tr style="height: 46.1222px;"><td style="height: 46.1222px;"><span style="font-family: 'courier new', courier, monospace;">CLPN\_CTRA</span></td><td style="height: 46.1222px;">Valore numerico indicante il costo specifico fisso associato alla gestione del trasporto merci per il cliente</td></tr><tr style="height: 46.5057px;"><td style="height: 46.5057px;"><span style="font-family: 'courier new', courier, monospace;">TIPG\_CTRA</span></td><td style="height: 46.5057px;">Codice identificativo della regola e della tipologia di applicazione economica del costo di trasporto (es. tariffazione calcolata a singolo collo o a pedana intera)</td></tr></tbody></table>

####  

#### 4.6.2 - Campi Aggiuntivi su Tabella `AAMG` (Anagrafica Articoli)

<table border="1" id="bkmrk-code_bran-codice-ide" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 16.1256%;"></col><col style="width: 83.9827%;"></col></colgroup><tbody><tr><td><span style="font-family: 'courier new', courier, monospace;">CODE\_BRAN</span>

</td><td>Codice identificativo univoco del Brand/Marchio associato al prodotto</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DESC\_BRAN</span></td><td>Descrizione testuale estesa del Brand/Marchio dell'articolo da esporre sul portale web</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DATE\_ASSI</span></td><td>Campo data indicante il giorno di inizio dell'inserimento dell'articolo nell'assortimento commerciale ordinabile</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DATE\_SOSI</span></td><td>Data di inizio del periodo di sospensione temporanea della visibilità e dell'ordinabilità del prodotto sul portale web</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DATE\_SOSF</span>

</td><td>Data di fine del periodo di sospensione temporanea del prodotto sul web</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">IDEN\_TRAF</span></td><td>Codice identificativo interno della trafila tecnica associata all'articolo</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DESC\_TRAF</span></td><td>Descrizione estesa e specifiche tecniche della trafila del prodotto</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">CODE\_SSUP</span></td><td>Codice identificativo del tipo di supporto logistico o di imballaggio protettivo utilizzato per l'articolo</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DATE\_LIMI</span>

</td><td>Data di inizio del periodo entro cui si applicano specifiche restrizioni o limitazioni di vendita sul portale</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">DATE\_LIMF</span></td><td>Data di fine del periodo delle limitazioni di vendita</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">NCOL\_\_MAX</span></td><td>Numero massimo di colli ordinabili sul portale per singolo ordine o singolo utente</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">QUAN\_\_MAX</span></td><td>Quantità massima complessiva di unità di prodotto ordinabili dal portale web per singolo utente</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">FLAG\_EXPO</span>

</td><td>Flag utilizzato per definire se lo specifico articolo è abilitato o meno all'esportazione e alla pubblicazione sulla piattaforma web eCOMMERCE</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">QSAL\_ORDF</span></td><td>Quantità residua totale dei saldi d'ordine in corso ancora da ricevere lato Fornitori per l'articolo</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">QSAL\_ORDC</span></td><td>Quantità residua totale dei saldi d'ordine in corso ordinati e ancora da evadere lato Clienti</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">ALTZ\_CONF</span>

</td><td>Misura dell'Altezza fisica della confezione del prodotto espressa in unità di misura logistica</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">LARG\_CONF</span></td><td>Misura della Larghezza fisica della confezione del prodotto</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">PROF\_CONF</span></td><td>Misura della Profondità fisica della confezione del prodotto</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">PESO\_COLL</span></td><td>Peso lordo complessivo del collo d'imballaggio espresso in unità di misura</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">NCON\_USTR</span></td><td>Numero di colli totali posizionabili e stivabili per l'ultimo strato superiore del pallet logistico</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">NCOL\_PALL</span></td><td>Numero di colli totali necessari per completare un pallet logistico standard del prodotto</td></tr><tr><td><span style="font-family: 'courier new', courier, monospace;">VOLM\_STRA</span></td><td>Volume complessivo espresso in unità logistica occupato da un singolo strato completo di merci sul pallet</td></tr></tbody></table>

---