Table DCLSII
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| DCLSII | DSII | SII monitor | Common Data | KSP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DSII0 | CPY+TYPENV+GTE+VCRNUM+VCRLIN | No | |
| DSII1 | DKEY | No | |
| DSII2 | CPY+FCY+TYPENV+GTE+VCRNUM+VCRLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTATI | Invoice total | DCB | 13.2 | |||||
| AMTATIORI | Final payment | DCB | 13.2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | BP code | A | 40 | |||||
| BPRNAM | Company name | A | 120 | |||||
| BPRVCR | Source document | A | 60 | |||||
| CLADECCON | Consignment key | A | 1 | |||||
| CLAVDEC | Key | A | 1 | |||||
| CLAVEOPE | Operation key | A | 1 | |||||
| CODOPE | Operation code | A | 3 | |||||
| CPY | Company | CPY | [CPY]CPY0=[DSII]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[DSII]CREUSR | Other | ||||
| CRY | Country | CRY | [TCY]TCY0=[DSII]CRY | Block | ||||
| DATDVS | Date time | ADATIM | ||||||
| DATENV | Issue date | ADATIM | ||||||
| DATOPE | Operation date | D | ||||||
| DATOPEDEC | Declared operation date | D | ||||||
| DATVCRORI | Source date | ADATIM | ||||||
| DESBIENES | Asset description | A | 40 | |||||
| DESCRY | Destination country | CRY | [TCY]TCY0=[DSII]DESCRY | Block | ||||
| DIRECOPE | EU operator address | A | 120 | |||||
| DKEY | Declared key | A | 100 | |||||
| EJEREXPINI | Fiscal year | A | 4 | |||||
| ESTMIEMBRO | EU member state | A | 2 | |||||
| EXPDAT | Export date | D | ||||||
| FACDOC | Other documents | A | 150 | |||||
| FCY | Site | FCY | [FCY]FCY0=[DSII]FCY | Other | ||||
| FECHAINI | Use start date | D | ||||||
| FLGNIFREC | TIN not registered | M | 4 | 1 | ||||
| FLGSEL | Send | M | 4 | 1 | ||||
| GTE | Entry type | GTE | [GTE]GTE0=GTE(indice);[V]GSUPCLE | Block | ||||
| IDENTBIEN | Asset ID | A | 40 | |||||
| IDENTENT | Delivery number | A | 40 | |||||
| IDEXPINI | Identifier | A | 60 | |||||
| LOTNUM | Batch | A | 16 | |||||
| NIFREPC | Representative TIN | A | 40 | |||||
| NIP | Identification | A | 40 | |||||
| OPEREF | Operation reference | A | 250 | |||||
| ORICRY | Country of origin | CRY | [TCY]TCY0=[DSII]ORICRY | Other | ||||
| PEREXPINI | Period | A | 2 | |||||
| PLAZOOPE | Operation lead time | C | 3 | |||||
| PRORRATA | Prorate | DCB | 2.2 | |||||
| QTY | Quantity | QTY | ||||||
| RECDAT | Receipt date | D | ||||||
| REGDEDUCEFE | Deduction adjustment | DCB | 12.2 | |||||
| REGUANUAL | Annual adjustment | DCB | 12.2 | |||||
| STADOC | Document status | M | 50 | 2119 | ||||
| TIMESTAMP | Last transmitted | A | 19 | |||||
| TYPANUAL | Operation type | A | 1 | |||||
| TYPCOM | Communication type | M | 50 | 2116 | ||||
| TYPENV | Transmission method | M | 50 | 2115 | ||||
| TYPOPE | Operation type | A | 1 | |||||
| TYPOPECON | Consignment type | M | 50 | 2125 | ||||
| TYPREC | Record type | A | 1 | |||||
| UNIPRI | Unit price | DCB | 12.2 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[DSII]UPDUSR | Other | ||||
| VALBASIMP | Tax base value | DCB | 12.2 | |||||
| VALBIEN | Stock value | DCB | 12.2 | |||||
| VCRERRDES | Error description | A | 250 | |||||
| VCRERRNUM | Error code | A | 10 | |||||
| VCRLIN | Line | L | 8 | |||||
| VCRNUM | Document | A | 60 | |||||
| VCRSTA | Tax authority status | M | 50 | 2118 | ||||
| VCRTYP | Document type | M | 50 | 2109 |