biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / Credit Cards / Administration Extension
API Admin Info / Extended Admin Info
ADM1 - Administration Extension Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CurrPeriodFreenVarChar
10
StreetStreetnVarChar
100
StreetFStreet ForeignnVarChar
100
BlockBlocknVarChar
100
BlockFBlock ForeignnVarChar
100
CityCitynVarChar
100
CityFCity ForeignnVarChar
100
ZipCodeZip CodenVarChar
20
ZipCodeFZip Code ForeignnVarChar
20
CountyCountynVarChar
100
CountyFCounty ForeignnVarChar
100
StateStatusnVarChar
3OCST
States
CountryCountrynVarChar
3OCRY
Countries
IntrntAdrsInternet AddressnVarChar
50
Code KEY UNIQUECodeInt
11
1PRIMARYYes
AssTypeAssessee TypenVarChar
100
CompnyTypeCompany TypenVarChar
100
NatureBizNature of BusinessnVarChar
100
TaxIdNum4Federal Tax ID 4nVarChar
100
TaxIdNum5Federal Tax ID 5nVarChar
100
TaxIdNum6Federal Tax ID 6nVarChar
100
LogInstancLog InstanceInt
11
0
AddrTypeAddress TypenVarChar
100
AddrTypeFAddress Type ForeignnVarChar
100
StreetNoStreet No.nVarChar
100
StreetNoFStreet No. ForeignnVarChar
100
BuildingBuilding/Floor/RoomnVarChar
100
BuildingFBuilding/Floor/Room ForeignnVarChar
100
EccNoE.C.C. No.nVarChar
40
CERegNoC.E. Registration No.nVarChar
40
CERangeC.E. RangenVarChar
60
CEDivisionC.E. DivisionnVarChar
60
CeComRateC.E. CommisioneratenVarChar
60
MenuCodeManufacturer CodenVarChar
60
JurisdJurisdictionnVarChar
60
SnapShotIdSnapshot IDInt
11
0
STDCodeSTD CodeInt
11
STDCodeFSTD Code ForeignInt
11
CompNatureNature of CompanyInt
11
-1
EconActTEconomic Activity TypeInt
11
-1
CredCOrigCredit Contribution OriginVarChar
1
IPIPeriodIPI PeriodVarChar
1
CoopAssocTCooperative Association TypeInt
11
-1
DspIBPDocDisplay Inactive Items in Doc.VarChar
Y) Yes
N) No
1
Y
DspIITMDocDisplay Inactive BPs in Doc.VarChar
Y) Yes
N) No
1
Y
ProfTaxProfit TaxationInt
11
-1
CompQualifCompany QualificationInt
11
1
DeclTypeDeclarer TypeInt
11
1
IPITaxConIPI Tax ContributorVarChar
N) No
Y) Yes
1
N
ISVATRegNoIS VAT Reg. No. of TradernVarChar
100
ISVATRegExIS VAT Reg. No. ExtensionnVarChar
10
ISObligLvlIS Degree of ObligationVarChar
1
ISTaxStateIS Federal State of Tax OfficenVarChar
3OCST
States
ISComDecIDIS Company Declaration IDnVarChar
32
OKDPNumOKDP NumbernVarChar
7
ISValidKeyIS Validation Key Ident.nVarChar
35
ISDnsceIS Declaration OfficenVarChar
10
ISDfltPathIS Default File PathText
16
ISSimpProcIS Simplified ProcedureVarChar
Y) Yes
N) No
1
Y
ISForceCmpIS Require All DataVarChar
Y) Yes
N) No
1
Y
ISCstRecStIS Customs SectionnVarChar
6
ISDfltInctIS Default IncotermsInt
11
ISDfCPExIS Default Customs Proc. Exp.Int
11
ISDfCPImIS Default Customs Proc. Imp.Int
11
ISDfNTExIS Dflt Nat. of Trans. for ExpInt
11
ISDfNTImIS Dflt Nature of Tran. Imp.Int
11
ISDfPortExIS Default Port for ExportInt
11
ISDfPortImIS Default Port for ImportInt
11
ISDfSPExIS Default Stat. Proc. ExportInt
11
ISDfSPImIS Default Stat. Proc. ImportInt
11
ISDfCSTExIS Default State for ExportInt
11ODCI
Intrastat Configuration
ISDfCSTImIS Default State for ImportInt
11ODCI
Intrastat Configuration
ISDfTMExIS Default Transport Mode Exp.Int
11
ISDfTMImIS Default Transport Mode Imp.Int
11
ISDeclDeptDeclaring DepartmentInt
6
ISExlDocQtExcl. Docs w/ Qty Less ThanVarChar
Y) Yes
N) No
1
N
ISDocQtLmDocument Quantity LimitNum
20
ISExlDocAmExcl. Docs w/ Amt Less ThanVarChar
Y) Yes
N) No
1
N
ISDocAmLmDocument Amount LimitNum
20
ISDspNMassAlways Display Net Mass ValueVarChar
Y) Yes
N) No
1
Y
Free1IS Default Country ImportnVarChar
3
Free2IS Default Country ImportnVarChar
3
CommerRegCommercial RegisternVarChar
60
DateOfIncDate of IncorporationDate
8
SPEDProfSPED ProfilenVarChar
2
EnvTypeNFeEnvironment Type NFeInt
11
-1
Opt4ICMSOpting for ICMS 115_03VarChar
1
N
ISInstIntrIS Install IntrastatVarChar
Y) Yes
N) No
1
N
GlblLocNumGlobal Location NumbernVarChar
50
PTLedgeGenPeriod Type for Ledger Gen.VarChar
Y) Year
Q) Quarter
M) Month
P) Period
1
M
BZStRegIDBZSt Register IDnVarChar
6
BZStSendIDBZSt Sender IDnVarChar
11
PostInVatPost Input VAT in A/P InvoiceVarChar
Y) Yes
N) No
1
N
EnbEATrnsEnable EA for Transfer Doc.VarChar
Y) Yes
N) No
1
N
EnbEAInvEnable EA for Inv. Doc.VarChar
Y) Yes
N) No
1
N
AuthUserAuthorized UsernVarChar
100
AuthPwdAuthorization PasswordnVarChar
100
UrlGoodsURL for Goods TransportnVarChar
127
UrlInvTypeURL for Invoice TypenVarChar
127
ElGoodsFmtEl. Doc. Format for Goods TrnsInt
11OLLF
Legal List Format
ElInvFmtEl. Doc. Format for InvoiceInt
11OLLF
Legal List Format
ElDigiCertEl. Digit. Cert. PathText
16
TaxRptFrmTax Wizard Reporting FromDate
8
SuframaSUFRAMAnVarChar
100
EnbInItIQIEnable Inactive Items in IQIVarChar
Y) Yes
N) No
1
N
EnbInItINCEnable Inactive Items in INCVarChar
Y) Yes
N) No
1
Y
ExtRevActExtend Revenue AccountsVarChar
Y) Yes
N) No
1
N
IsStartupIdentify Startup CompanyVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ADM1.CurrPeriod AS 'Free', ADM1.Street AS 'Street', ADM1.StreetF AS 'Street Foreign', ADM1.Block AS 'Block', ADM1.BlockF AS 'Block Foreign', ADM1.City AS 'City', ADM1.CityF AS 'City Foreign', ADM1.ZipCode AS 'Zip Code', ADM1.ZipCodeF AS 'Zip Code Foreign', ADM1.County AS 'County', ADM1.CountyF AS 'County Foreign', ADM1.State AS 'Status', ADM1.Country AS 'Country', ADM1.IntrntAdrs AS 'Internet Address', ADM1.Code AS 'Code', ADM1.AssType AS 'Assessee Type', ADM1.CompnyType AS 'Company Type', ADM1.NatureBiz AS 'Nature of Business', ADM1.TaxIdNum4 AS 'Federal Tax ID 4', ADM1.TaxIdNum5 AS 'Federal Tax ID 5', ADM1.TaxIdNum6 AS 'Federal Tax ID 6', ADM1.LogInstanc AS 'Log Instance', ADM1.AddrType AS 'Address Type', ADM1.AddrTypeF AS 'Address Type Foreign', ADM1.StreetNo AS 'Street No.', ADM1.StreetNoF AS 'Street No. Foreign', ADM1.Building AS 'Building/Floor/Room', ADM1.BuildingF AS 'Building/Floor/Room Foreign', ADM1.EccNo AS 'E.C.C. No.', ADM1.CERegNo AS 'C.E. Registration No.', ADM1.CERange AS 'C.E. Range', ADM1.CEDivision AS 'C.E. Division', ADM1.CeComRate AS 'C.E. Commisionerate', ADM1.MenuCode AS 'Manufacturer Code', ADM1.Jurisd AS 'Jurisdiction', ADM1.SnapShotId AS 'Snapshot ID', ADM1.STDCode AS 'STD Code', ADM1.STDCodeF AS 'STD Code Foreign', ADM1.CompNature AS 'Nature of Company', ADM1.EconActT AS 'Economic Activity Type', ADM1.CredCOrig AS 'Credit Contribution Origin', ADM1.IPIPeriod AS 'IPI Period', ADM1.CoopAssocT AS 'Cooperative Association Type', ADM1.DspIBPDoc AS 'Display Inactive Items in Doc.', ADM1.DspIITMDoc AS 'Display Inactive BPs in Doc.', ADM1.ProfTax AS 'Profit Taxation', ADM1.CompQualif AS 'Company Qualification', ADM1.DeclType AS 'Declarer Type', ADM1.IPITaxCon AS 'IPI Tax Contributor', ADM1.ISVATRegNo AS 'IS VAT Reg. No. of Trader', ADM1.ISVATRegEx AS 'IS VAT Reg. No. Extension', ADM1.ISObligLvl AS 'IS Degree of Obligation', ADM1.ISTaxState AS 'IS Federal State of Tax Office', ADM1.ISComDecID AS 'IS Company Declaration ID', ADM1.OKDPNum AS 'OKDP Number', ADM1.ISValidKey AS 'IS Validation Key Ident.', ADM1.ISDnsce AS 'IS Declaration Office', ADM1.ISDfltPath AS 'IS Default File Path', ADM1.ISSimpProc AS 'IS Simplified Procedure', ADM1.ISForceCmp AS 'IS Require All Data', ADM1.ISCstRecSt AS 'IS Customs Section', ADM1.ISDfltInct AS 'IS Default Incoterms', ADM1.ISDfCPEx AS 'IS Default Customs Proc. Exp.', ADM1.ISDfCPIm AS 'IS Default Customs Proc. Imp.', ADM1.ISDfNTEx AS 'IS Dflt Nat. of Trans. for Exp', ADM1.ISDfNTIm AS 'IS Dflt Nature of Tran. Imp.', ADM1.ISDfPortEx AS 'IS Default Port for Export', ADM1.ISDfPortIm AS 'IS Default Port for Import', ADM1.ISDfSPEx AS 'IS Default Stat. Proc. Export', ADM1.ISDfSPIm AS 'IS Default Stat. Proc. Import', ADM1.ISDfCSTEx AS 'IS Default State for Export', ADM1.ISDfCSTIm AS 'IS Default State for Import', ADM1.ISDfTMEx AS 'IS Default Transport Mode Exp.', ADM1.ISDfTMIm AS 'IS Default Transport Mode Imp.', ADM1.ISDeclDept AS 'Declaring Department', ADM1.ISExlDocQt AS 'Excl. Docs w/ Qty Less Than', ADM1.ISDocQtLm AS 'Document Quantity Limit', ADM1.ISExlDocAm AS 'Excl. Docs w/ Amt Less Than', ADM1.ISDocAmLm AS 'Document Amount Limit', ADM1.ISDspNMass AS 'Always Display Net Mass Value', ADM1.Free1 AS 'IS Default Country Import', ADM1.Free2 AS 'IS Default Country Import', ADM1.CommerReg AS 'Commercial Register', ADM1.DateOfInc AS 'Date of Incorporation', ADM1.SPEDProf AS 'SPED Profile', ADM1.EnvTypeNFe AS 'Environment Type NFe', ADM1.Opt4ICMS AS 'Opting for ICMS 115_03', ADM1.ISInstIntr AS 'IS Install Intrastat', ADM1.GlblLocNum AS 'Global Location Number', ADM1.PTLedgeGen AS 'Period Type for Ledger Gen.', ADM1.BZStRegID AS 'BZSt Register ID', ADM1.BZStSendID AS 'BZSt Sender ID', ADM1.PostInVat AS 'Post Input VAT in A/P Invoice', ADM1.EnbEATrns AS 'Enable EA for Transfer Doc.', ADM1.EnbEAInv AS 'Enable EA for Inv. Doc.', ADM1.AuthUser AS 'Authorized User', ADM1.AuthPwd AS 'Authorization Password', ADM1.UrlGoods AS 'URL for Goods Transport', ADM1.UrlInvType AS 'URL for Invoice Type', ADM1.ElGoodsFmt AS 'El. Doc. Format for Goods Trns', ADM1.ElInvFmt AS 'El. Doc. Format for Invoice', ADM1.ElDigiCert AS 'El. Digit. Cert. Path', ADM1.TaxRptFrm AS 'Tax Wizard Reporting From', ADM1.Suframa AS 'SUFRAMA', ADM1.EnbInItIQI AS 'Enable Inactive Items in IQI', ADM1.EnbInItINC AS 'Enable Inactive Items in INC', ADM1.ExtRevAct AS 'Extend Revenue Accounts', ADM1.IsStartup AS 'Identify Startup Company' FROM ADM1 AS ADM1

Related information


Extended Admin Info ExtendedAdminInfo Object· Table: ADM1
Enables you to set and get additional administration properties, in addition to the properties accessed via the AdminInfo object. Source table: ADM1
   Parent: Admin Info AdminInfo Object· Table: OADM
Countries OCRY SQL Table

Legal List Format OLLF SQL Table

Intrastat Configuration ODCI 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