Table CNSSII
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| CNSSII | CSII | SII inquiry | Common Data | KSP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CSII0 | CPY+TYPENV+EJERCICIO+PERIODO+NUM+VCRNUM+VCRNUMLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CCAJA | Cash VAT | M | 4 | 1 | ||||
| CLAVEOPE | Key | A | 1 | |||||
| CPY | Company | CPY | [CPY]CPY0=[CSII]CPY | Block | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[CSII]CREUSR | Other | ||||
| CSV | CSV | A | 16 | |||||
| EJERCICIO | Fiscal year | C | 4 | |||||
| ESTADO | Status | A | 20 | |||||
| ESTADOCON | Verification status | M | 50 | 2120 | ||||
| FACMOD | Updated invoice | M | 4 | 1 | ||||
| FCY | Site | FCY | [FCY]FCY0=[CSII]FCY | Delete | ||||
| FECHAEXP | Shipping date | A | 10 | |||||
| FECHAPRE | Submission date | A | 19 | |||||
| FECHMOD | Last update date | A | 19 | |||||
| IDENBIEN | Asset ID | A | 40 | |||||
| IDENDESEMI | Recipient/issuer ID | A | 40 | |||||
| IDENTIFCADOR | Identification | A | 40 | |||||
| IMPORTE | Amount | DCB | 12.2 | |||||
| NIFDESEMI | Recipient/issuer TIN | A | 40 | |||||
| NIFDESTIN | Recipient TIN | A | 40 | |||||
| NIFEMISOR | Issuer TIN | A | 40 | |||||
| NUM | Number | L | 8 | |||||
| PAIS | Country code | A | 2 | |||||
| PAISDESEMI | Recipient/issuer country | A | 2 | |||||
| PERIODO | Period | A | 2 | |||||
| RAZONSOC | Company name | A | 60 | |||||
| TYPDOC | Identification type | M | 15 | 2004 | ||||
| TYPENV | Transmission method | M | 50 | 2115 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[CSII]UPDUSR | Other | ||||
| VCRNUM | Document | A | 60 | |||||
| VCRNUMLIN | Line | C | 2 |