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 |