|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Administration Electronic Report
Table Name: ADM2
Table Description: Administration Electronic Report
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Code | Int | 11 | - | Â | Â | Â |
| TaxAuCod | Tax Authority Code | nVarChar | 5 | - | Â | Â | Â |
| KeyEcoAct | Key Economic Activity | nVarChar | 10 | - | Â | Â | Â |
| TaxPayType | Tax Payer Type | VarChar | 1 | - | P | P | �94 |
|  |  |  |  |  |  | I | �96 |
|  |  |  |  |  |  | S | �95a |
| TaxLegForm | Tax Payer Legal Form | VarChar | 1 | - | P | F | Sole Proprietorship |
| Â | Â | Â | Â | Â | Â | P | Company |
| RegName | Registered Name | nVarChar | 254 | - | Â | Â | Â |
| RegNameExt | Registered Name Extension | nVarChar | 11 | - | Â | Â | Â |
| SoleFName | Sole Proprietor First Name | nVarChar | 20 | - | Â | Â | Â |
| SoleSName | Sole Proprietor Surname | nVarChar | 36 | - | Â | Â | Â |
| SoleTitle | Sole Proprietor Title | nVarChar | 10 | - | Â | Â | Â |
| CityTown | City/Town/Village | nVarChar | 48 | - | Â | Â | Â |
| ZipCode | Zip Code | nVarChar | 10 | - | Â | Â | Â |
| Telephone | Telephone | nVarChar | 50 | - | Â | Â | Â |
| Street | Street | nVarChar | 38 | - | Â | Â | Â |
| StreetNum | Street Number | nVarChar | 4 | - | Â | Â | Â |
| BuildinNum | Building Number | Int | 11 | - | Â | Â | Â |
| nVarChar | 254 | - | Â | Â | Â | ||
| State | State | nVarChar | 20 | - | Â | Â | Â |
| RepType | Representative Type | VarChar | 1 | - | P | Â | Â |
| Â | Â | Â | Â | Â | Â | F | Sole Proprietorship |
| Â | Â | Â | Â | Â | Â | P | Company |
| RepCode | Representative Code | nVarChar | 2 | - | Â | 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 |
| RepFName | Representative First Name | nVarChar | 20 | - | Â | Â | Â |
| RepSName | Representative Surname | nVarChar | 36 | - | Â | Â | Â |
| CompName | Company Name | nVarChar | 36 | - | Â | Â | Â |
| BirthDate | Birth Date | Date | 8 | - | Â | Â | Â |
| TaxACNum | Tax Advisor Certificate Number | nVarChar | 36 | - | Â | Â | Â |
| LegEntitID | Legal Entity ID | nVarChar | 10 | - | Â | Â | Â |
| AuthFName | Authorized Person First Name | nVarChar | 20 | - | Â | Â | Â |
| AuthLName | Authorized Person Last Name | nVarChar | 36 | - | Â | Â | Â |
| AuthRelat | Authorized Person Relation | nVarChar | 40 | - | Â | Â | Â |
| AuthType | Type of Authorized Person | VarChar | 1 | - | Â | Â | Â |
| TaxPayAttr | Taxpayer Attribute | nVarChar | 2 | - | Â | Â | Â |
| Classifier | Territorial/Adm. Classifier | nVarChar | 11 | - | Â | Â | Â |
| DeprMethod | Depreciation Method | VarChar | 1 | - | Â | Â | Â |
| SubmitPlac | Place of Submission | nVarChar | 3 | - | Â | Â | Â |
| BgtClass | Budget Classification Code | nVarChar | 20 | - | Â | Â | Â |
| SubjOfRuF | Subject of Russian Federation | nVarChar | 20 | - | Â | Â | Â |
| AuthFathrN | Father Name | nVarChar | 254 | - | Â | Â | Â |
| BgtCleVAT | Budget Classification Code (E-VAT) | nVarChar | 20 | - | Â | Â | Â |
| RepTitle | Representative Title | nVarChar | 10 | - | Â | Â | Â |
| TaxRegime | Tax Regime | nVarChar | 5 | - | 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 633/72) |
| Â | Â | Â | Â | Â | Â | RF06 | Match sales (Art. 74, section 1, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF07 | Publishing (Art. 74, section 1, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF08 | Management of public telephone services (Art. 74, section 1, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF09 | Resale of public transport and parking documents (Art. 74, section 1, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF10 | Entertainment, gaming and other activities referred to by the tariff attached to Italian Presidential Decree 640/72 (Art. 74, section 6, Italian Presidential Decree 633/1972) |
| Â | Â | Â | Â | Â | Â | RF11 | Travel and tourism agencies (Art. 74-ter, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF12 | Farmhouse accommodation/restaurants (Art. 5, section 2, Italian Law 413/91) |
| Â | Â | Â | Â | Â | Â | RF13 | Door-to-door sales (Art. 25-bis, section 6, Italian Presidential Decree 600/73) |
| Â | Â | Â | Â | Â | Â | RF14 | Resale of used goods, artworks, antiques or collector's items (Art. 36, Italian Decree Law 41/95) |
| Â | Â | Â | Â | Â | Â | RF15 | Artwork, antiques or collector's items auction agencies (Art. 40-bis, Italian Decree Law 41/95) |
| Â | Â | Â | Â | Â | Â | RF16 | VAT paid in cash by P.A. (Art. 6, section 5, Italian Presidential Decree 633/72) |
| Â | Â | Â | Â | Â | Â | RF17 | VAT paid in cash by subjects with business turnover below Euro 200,000 (Art. 7, Italian Decree Law 185/2008) |
| Â | Â | Â | Â | Â | Â | RF18 | Other |
| Â | Â | Â | Â | Â | Â | RF19 | Regime forfettario (art.1, c.54-89, L. 190/2014) |
| Â | Â | Â | Â | Â | Â | RF20 | Regime transfrontaliero di Franchigia IVA (Direttiva UE 2020/285) |
| SoleBDate | Sole Proprietor Date of Birth | Date | 8 | - | Â | Â | Â |
| SoleGender | Sole Proprietor Gender | VarChar | 1 | - | M | F | Female |
| Â | Â | Â | Â | Â | Â | M | Male |
| Â | Â | Â | Â | Â | Â | E | Not Specified |
| SoleCity | Sole Proprietor City of Birth | nVarChar | 40 | - | Â | Â | Â |
| SoleDistri | Sole Proprietor State of Birth | nVarChar | 3 | - | Â | Â | Â |
| RepFisCode | Representative Fiscal Code | nVarChar | 16 | - | Â | Â | Â |
| RepPosCode | Representative Position Code | nVarChar | 2 | - | Â | Â | Â |
| RepGender | Representative Gender | VarChar | 1 | - | M | F | Female |
| Â | Â | Â | Â | Â | Â | M | Male |
| Â | Â | Â | Â | Â | Â | E | Not Specified |
| RepCity | Representative City of Birth | nVarChar | 40 | - | Â | Â | Â |
| RepDistri | Representative State of Birth | nVarChar | 3 | - | Â | Â | Â |
| RepDate1 | Representative Start Date of Procedure | Date | 8 | - | Â | Â | Â |
| RepDate2 | Representative End Date of Procedure | Date | 8 | - | Â | Â | Â |
| RepPhone | Representative Telephone | nVarChar | 14 | - | Â | Â | Â |
| RepEmail | Representative E-Mail | nVarChar | 254 | - | Â | Â | Â |
| Country | Country/Region | nVarChar | 3 | OCRY | Â | Â | Â |
| District | District | nVarChar | 3 | OCST | Â | Â | Â |
| RegDistri | Register District | nVarChar | 3 | - | Â | Â | Â |
| RegSCAmnt | Share Capital Amount | Num | 19.6 | - | Â | Â | Â |
| RegSHolder | Shareholder | nVarChar | 2 | - | SU | SU | Sole Shareholder |
| Â | Â | Â | Â | Â | Â | SM | Several Shareholders |
| RegLiquida | Liquidation | nVarChar | 2 | - | LN | LS | In Liquidation |
| Â | Â | Â | Â | Â | Â | LN | Not in Liquidation |
| RepAddID | Representative Additional ID | nVarChar | 28 | - | Â | Â | Â |
| ActCode | Activity Code | nVarChar | 15 | - | Â | Â | Â |
| PosCode347 | Position Code for Report 347 | nVarChar | 2 | - | Â | Â | Â |
| Â | Â | Â | Â | Â | Â | 1 | 1 |
| Â | Â | Â | Â | Â | Â | 2 | 2 |
| Â | Â | Â | Â | Â | Â | 3 | 3 |
| Â | Â | Â | Â | Â | Â | 4 | 4 |
| Â | Â | Â | Â | Â | Â | 5 | 5 |
| Â | Â | Â | Â | Â | Â | 6 | 6 |
| Â | Â | Â | Â | Â | Â | 7 | 7 |
| Â | Â | Â | Â | Â | Â | 8 | 8 |
| Â | Â | Â | Â | Â | Â | 9 | 9 |
| Â | Â | Â | Â | Â | Â | 10 | 10 |
| Â | Â | Â | Â | Â | Â | 11 | 11 |
| Â | Â | Â | Â | Â | Â | 12 | 12 |
| Â | Â | Â | Â | Â | Â | 13 | 13 |
| Â | Â | Â | Â | Â | Â | 14 | 14 |
| Â | Â | Â | Â | Â | Â | 15 | 15 |
| FiscalCode | Fiscal Code | nVarChar | 16 | - | Â | Â | Â |
| DataBoxID | Data Box ID | nVarChar | 10 | - | Â | Â | Â |
| SmValLimit | Small Value Documents Limit | Num | 19.6 | - | Â | Â | Â |
| RepCEOName | Representative CEO Name | nVarChar | 254 | - | Â | Â | Â |
| RepCEOFisC | Representative CEO Fiscal Code | nVarChar | 16 | - | Â | Â | Â |
| CmpnTypeFR | Type d'entreprise | nVarChar | 30 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |