biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / Payment Methods
API ADM2
ADM2 - Administration Electronic Report Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
11
PRIMARYYes
TaxAuCodTax Authority CodenVarChar
5
KeyEcoActKey Economic ActivitynVarChar
10
TaxPayTypeTax Payer TypeVarChar
P) §94
I) §96
S) §95a
1
P
TaxLegFormTax Payer Legal FormVarChar
F) Sole Proprietorship
P) Company
1
P
RegNameRegistered NamenVarChar
127
RegNameExtRegistered Name ExtensionnVarChar
11
SoleFNameSole Proprietor First NamenVarChar
20
SoleSNameSole Proprietor SurnamenVarChar
36
SoleTitleSole Proprietor TitlenVarChar
10
CityTownCity/Town/VillagenVarChar
48
ZipCodeZip CodenVarChar
10
TelephoneTelephonenVarChar
14
StreetStreetnVarChar
38
StreetNumStreet NumbernVarChar
4
BuildinNumBuilding NumberInt
11
EmailE-MailnVarChar
127
StateStatenVarChar
20
RepTypeRepresentative TypeVarChar
1
P
RepCodeRepresentative CodenVarChar
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
2
RepFNameRepresentative First NamenVarChar
20
RepSNameRepresentative SurnamenVarChar
36
CompNameCompany NamenVarChar
36
BirthDateBirth DateDate
8
TaxACNumTax Advisor Certificate NumbernVarChar
36
LegEntitIDLegal Entity IDnVarChar
10
AuthFNameAuthorized Person First NamenVarChar
20
AuthLNameAuthorized Person Last NamenVarChar
36
AuthRelatAuthorized Person RelationnVarChar
40
AuthTypeType of Authorized PersonVarChar
1
TaxPayAttrTaxpayer AttributeVarChar
1
ClassifierTerritorial/Adm. ClassifiernVarChar
11
DeprMethodDepreciation MethodVarChar
1
SubmitPlacPlace of SubmissionnVarChar
3
BgtClassBudget Classification CodenVarChar
20
SubjOfRuFSubject of Russian FederationnVarChar
20
AuthFathrNFather NamenVarChar
127
BgtCleVATBudget Classification Code (E-VAT)nVarChar
20
RepTitleRepresentative TitlenVarChar
10
TaxRegimeTax RegimenVarChar
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
5
RF01
SoleBDateSole Proprietor Date of BirthDate
8
SoleGenderSole Proprietor GenderVarChar
F) Female
M) Male
1
M
SoleCitySole Proprietor City of BirthnVarChar
40
SoleDistriSole Proprietor State of BirthnVarChar
3
RepFisCodeRepresentative Fiscal CodenVarChar
16
RepPosCodeRepresentative Position CodenVarChar
2
RepGenderRepresentative GenderVarChar
F) Female
M) Male
1
M
RepCityRepresentative City of BirthnVarChar
40
RepDistriRepresentative State of BirthnVarChar
3
RepDate1Representative Start Date of ProcedureDate
8
RepDate2Representative End Date of ProcedureDate
8
RepPhoneRepresentative TelephonenVarChar
14
RepEmailRepresentative E-MailnVarChar
127
CountryCountrynVarChar
3OCRY
Countries
DistrictDistrictnVarChar
3OCST
States
RegDistriRegister DistrictnVarChar
3
RegSCAmntShare Capital AmountNum
20
RegSHolderShareholdernVarChar
SU) Sole Shareholder
SM) Several Shareholders
2
SU
RegLiquidaLiquidationnVarChar
LS) In Liquidation
LN) Not in Liquidation
2
LN
RepAddIDRepresentative Additional IDnVarChar
28
ActCodeActivity CodenVarChar
6
PosCode347Position Code for Report 347nVarChar
2

Table relationship map

SELECT statement

SELECT ADM2.Code AS 'Code', ADM2.TaxAuCod AS 'Tax Authority Code', ADM2.KeyEcoAct AS 'Key Economic Activity', ADM2.TaxPayType AS 'Tax Payer Type', ADM2.TaxLegForm AS 'Tax Payer Legal Form', ADM2.RegName AS 'Registered Name', ADM2.RegNameExt AS 'Registered Name Extension', ADM2.SoleFName AS 'Sole Proprietor First Name', ADM2.SoleSName AS 'Sole Proprietor Surname', ADM2.SoleTitle AS 'Sole Proprietor Title', ADM2.CityTown AS 'City/Town/Village', ADM2.ZipCode AS 'Zip Code', ADM2.Telephone AS 'Telephone', ADM2.Street AS 'Street', ADM2.StreetNum AS 'Street Number', ADM2.BuildinNum AS 'Building Number', ADM2.Email AS 'E-Mail', ADM2.State AS 'State', ADM2.RepType AS 'Representative Type', ADM2.RepCode AS 'Representative Code', ADM2.RepFName AS 'Representative First Name', ADM2.RepSName AS 'Representative Surname', ADM2.CompName AS 'Company Name', ADM2.BirthDate AS 'Birth Date', ADM2.TaxACNum AS 'Tax Advisor Certificate Number', ADM2.LegEntitID AS 'Legal Entity ID', ADM2.AuthFName AS 'Authorized Person First Name', ADM2.AuthLName AS 'Authorized Person Last Name', ADM2.AuthRelat AS 'Authorized Person Relation', ADM2.AuthType AS 'Type of Authorized Person', ADM2.TaxPayAttr AS 'Taxpayer Attribute', ADM2.Classifier AS 'Territorial/Adm. Classifier', ADM2.DeprMethod AS 'Depreciation Method', ADM2.SubmitPlac AS 'Place of Submission', ADM2.BgtClass AS 'Budget Classification Code', ADM2.SubjOfRuF AS 'Subject of Russian Federation', ADM2.AuthFathrN AS 'Father Name', ADM2.BgtCleVAT AS 'Budget Classification Code (E-VAT)', ADM2.RepTitle AS 'Representative Title', ADM2.TaxRegime AS 'Tax Regime', ADM2.SoleBDate AS 'Sole Proprietor Date of Birth', ADM2.SoleGender AS 'Sole Proprietor Gender', ADM2.SoleCity AS 'Sole Proprietor City of Birth', ADM2.SoleDistri AS 'Sole Proprietor State of Birth', ADM2.RepFisCode AS 'Representative Fiscal Code', ADM2.RepPosCode AS 'Representative Position Code', ADM2.RepGender AS 'Representative Gender', ADM2.RepCity AS 'Representative City of Birth', ADM2.RepDistri AS 'Representative State of Birth', ADM2.RepDate1 AS 'Representative Start Date of Procedure', ADM2.RepDate2 AS 'Representative End Date of Procedure', ADM2.RepPhone AS 'Representative Telephone', ADM2.RepEmail AS 'Representative E-Mail', ADM2.Country AS 'Country', ADM2.District AS 'District', ADM2.RegDistri AS 'Register District', ADM2.RegSCAmnt AS 'Share Capital Amount', ADM2.RegSHolder AS 'Shareholder', ADM2.RegLiquida AS 'Liquidation', ADM2.RepAddID AS 'Representative Additional ID', ADM2.ActCode AS 'Activity Code', ADM2.PosCode347 AS 'Position Code for Report 347' FROM ADM2 AS ADM2

Related information


Countries OCRY SQL Table

States OCST SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates