| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | Code | Code | int | 11 | 0 | | | | Allow NULL? |
| 2 | TaxAuCod | Tax Authority Code | nvarchar | 5 | 0 | | | | Allow NULL? |
| 3 | KeyEcoAct | Key Economic Activity | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | TaxPayType | Tax Payer Type | char | 1 | 0 | | P | I=§96, P=§94, S=§95a | Allow NULL? |
| 5 | TaxLegForm | Tax Payer Legal Form | char | 1 | 0 | | P | F=Sole Proprietorship, P=Company | Allow NULL? |
| 6 | RegName | Registered Name | nvarchar | 254 | 0 | | | | Allow NULL? |
| 7 | RegNameExt | Registered Name Extension | nvarchar | 11 | 0 | | | | Allow NULL? |
| 8 | SoleFName | Sole Proprietor First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | SoleSName | Sole Proprietor Surname | nvarchar | 36 | 0 | | | | Allow NULL? |
| 10 | SoleTitle | Sole Proprietor Title | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | CityTown | City/Town/Village | nvarchar | 48 | 0 | | | | Allow NULL? |
| 12 | ZipCode | Zip Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | Telephone | Telephone | nvarchar | 14 | 0 | | | | Allow NULL? |
| 14 | Street | Street | nvarchar | 38 | 0 | | | | Allow NULL? |
| 15 | StreetNum | Street Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | BuildinNum | Building Number | int | 11 | 0 | | | | Allow NULL? |
| 17 | Email | E-Mail | nvarchar | 254 | 0 | | | | Allow NULL? |
| 18 | State | State | nvarchar | 20 | 0 | | | | Allow NULL? |
| 19 | RepType | Representative Type | char | 1 | 0 | | P | F=Sole Proprietorship, P=Company | Allow NULL? |
| 20 | RepCode | Representative Code | nvarchar | 2 | 0 | | | 1=Legal Representative, 2=Authorized Representative, 3=Common Representative, Contractual Representative, 4a=General Appointee - Sole Proprietorship or Company, 4b=Tax Advisor or Attorney, 4c=Tax Advisor | Allow NULL? |
| 21 | RepFName | Representative First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | RepSName | Representative Surname | nvarchar | 36 | 0 | | | | Allow NULL? |
| 23 | CompName | Company Name | nvarchar | 36 | 0 | | | | Allow NULL? |
| 24 | BirthDate | Birth Date | date | 8 | 0 | | | | |
| 25 | TaxACNum | Tax Advisor Certificate Number | nvarchar | 36 | 0 | | | | Allow NULL? |
| 26 | LegEntitID | Legal Entity ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | AuthFName | Authorized Person First Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 28 | AuthLName | Authorized Person Last Name | nvarchar | 36 | 0 | | | | Allow NULL? |
| 29 | AuthRelat | Authorized Person Relation | nvarchar | 40 | 0 | | | | Allow NULL? |
| 30 | AuthType | Type of Authorized Person | char | 1 | 0 | | | | Allow NULL? |
| 31 | TaxPayAttr | Taxpayer Attribute | char | 1 | 0 | | | | Allow NULL? |
| 32 | Classifier | Territorial/Adm. Classifier | nvarchar | 11 | 0 | | | | Allow NULL? |
| 33 | DeprMethod | Depreciation Method | char | 1 | 0 | | | | Allow NULL? |
| 34 | SubmitPlac | Place of Submission | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | BgtClass | Budget Classification Code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 36 | SubjOfRuF | Subject of Russian Federation | nvarchar | 20 | 0 | | | | Allow NULL? |
| 37 | AuthFathrN | Father Name | nvarchar | 254 | 0 | | | | Allow NULL? |
| 38 | BgtCleVAT | Budget Classification Code (E-VAT) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 39 | RepTitle | Representative Title | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | TaxRegime | Tax Regime | nvarchar | 5 | 0 | | RF01 | RF01=Ordinary, RF02=Minimum taxpayers (Art. 1, section 96-117, Italian Law 244/07), RF03=New production initiatives (Art. 13, Italian Law 388/00), RF04=Agriculture and connected activities, and fishing (Arts. 34 and 34-bis, Italian Presidential Decree 633/72), RF05=Sale of salts and tobaccos (Art. 74, section 1, Italian Presidential Decree | Allow NULL? |
| 41 | SoleBDate | Sole Proprietor Date of Birth | date | 8 | 0 | | | | |
| 42 | SoleGender | Sole Proprietor Gender | char | 1 | 0 | | M | E=Not Specified, F=Female, M=Male | Allow NULL? |
| 43 | SoleCity | Sole Proprietor City of Birth | nvarchar | 40 | 0 | | | | Allow NULL? |
| 44 | SoleDistri | Sole Proprietor State of Birth | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | RepFisCode | Representative Fiscal Code | nvarchar | 16 | 0 | | | | Allow NULL? |
| 46 | RepPosCode | Representative Position Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | RepGender | Representative Gender | char | 1 | 0 | | M | E=Not Specified, F=Female, M=Male | Allow NULL? |
| 48 | RepCity | Representative City of Birth | nvarchar | 40 | 0 | | | | Allow NULL? |
| 49 | RepDistri | Representative State of Birth | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | RepDate1 | Representative Start Date of Procedure | date | 8 | 0 | | | | |
| 51 | RepDate2 | Representative End Date of Procedure | date | 8 | 0 | | | | |
| 52 | RepPhone | Representative Telephone | nvarchar | 14 | 0 | | | | Allow NULL? |
| 53 | RepEmail | Representative E-Mail | nvarchar | 254 | 0 | | | | Allow NULL? |
| 54 | Country | Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 55 | District | District | nvarchar | 3 | 0 | OCST | | | Allow NULL? |
| 56 | RegDistri | Register District | nvarchar | 3 | 0 | | | | Allow NULL? |
| 57 | RegSCAmnt | Share Capital Amount | num | 19 | 6 | | | | Allow NULL? |
| 58 | RegSHolder | Shareholder | nvarchar | 2 | 0 | | SU | SM=Several Shareholders, SU=Sole Shareholder | Allow NULL? |
| 59 | RegLiquida | Liquidation | nvarchar | 2 | 0 | | LN | LN=Not in Liquidation, LS=In Liquidation | Allow NULL? |
| 60 | RepAddID | Representative Additional ID | nvarchar | 28 | 0 | | | | Allow NULL? |
| 61 | ActCode | Activity Code | nvarchar | 6 | 0 | | | | Allow NULL? |
| 62 | PosCode347 | Position Code for Report 347 | nvarchar | 2 | 0 | | | 10=10, 11=11, 12=12, 13=13, 14=14, 15=15, 1=1, 2=2, 3=3, 4=4, 5=5, 6=6, 7=7, 8=8, 9=9 | Allow NULL? |
| 63 | FiscalCode | Fiscal Code | nvarchar | 16 | 0 | | | | Allow NULL? |
| 64 | DataBoxID | Data Box ID | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | SmValLimit | Small Value Documents Limit | num | 19 | 6 | | | | Allow NULL? |
| 66 | RepCEOName | Representative CEO Name | nvarchar | 254 | 0 | | | | Allow NULL? |
| 67 | RepCEOFisC | Representative CEO Fiscal Code | nvarchar | 16 | 0 | | | | Allow NULL? |
