|
|
DTW Administration / Setup / Banking / Credit Cards / Administration Extension
API Admin Info / Extended Admin Info
ADM1 - Administration Extension Table
Extended Admin Info ExtendedAdminInfo Object· 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CurrPeriod | Free | nVarChar | 10 |
|---|---|---|---|---|---|---|---|---|
| Street | Street | nVarChar | 100 | |||||
| StreetF | Street Foreign | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| BlockF | Block Foreign | nVarChar | 100 | |||||
| City | City | nVarChar | 100 | |||||
| CityF | City Foreign | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| ZipCodeF | Zip Code Foreign | nVarChar | 20 | |||||
| County | County | nVarChar | 100 | |||||
| CountyF | County Foreign | nVarChar | 100 | |||||
| State | Status | nVarChar | 3 | OCST States | ||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| IntrntAdrs | Internet Address | nVarChar | 50 | |||||
| Code KEY UNIQUE | Code | Int | 11 | 1 | PRIMARY | Yes | ||
| AssType | Assessee Type | nVarChar | 100 | |||||
| CompnyType | Company Type | nVarChar | 100 | |||||
| NatureBiz | Nature of Business | nVarChar | 100 | |||||
| TaxIdNum4 | Federal Tax ID 4 | nVarChar | 100 | |||||
| TaxIdNum5 | Federal Tax ID 5 | nVarChar | 100 | |||||
| TaxIdNum6 | Federal Tax ID 6 | nVarChar | 100 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| AddrType | Address Type | nVarChar | 100 | |||||
| AddrTypeF | Address Type Foreign | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| StreetNoF | Street No. Foreign | nVarChar | 100 | |||||
| Building | Building/Floor/Room | nVarChar | 100 | |||||
| BuildingF | Building/Floor/Room Foreign | nVarChar | 100 | |||||
| EccNo | E.C.C. No. | nVarChar | 40 | |||||
| CERegNo | C.E. Registration No. | nVarChar | 40 | |||||
| CERange | C.E. Range | nVarChar | 60 | |||||
| CEDivision | C.E. Division | nVarChar | 60 | |||||
| CeComRate | C.E. Commisionerate | nVarChar | 60 | |||||
| MenuCode | Manufacturer Code | nVarChar | 60 | |||||
| Jurisd | Jurisdiction | nVarChar | 60 | |||||
| SnapShotId | Snapshot ID | Int | 11 | 0 | ||||
| STDCode | STD Code | Int | 11 | |||||
| STDCodeF | STD Code Foreign | Int | 11 | |||||
| CompNature | Nature of Company | Int | 11 | -1 | ||||
| EconActT | Economic Activity Type | Int | 11 | -1 | ||||
| CredCOrig | Credit Contribution Origin | VarChar | 1 | |||||
| IPIPeriod | IPI Period | VarChar | 1 | |||||
| CoopAssocT | Cooperative Association Type | Int | 11 | -1 | ||||
| DspIBPDoc | Display Inactive Items in Doc. | VarChar | Y) Yes N) No | 1 | Y | |||
| DspIITMDoc | Display Inactive BPs in Doc. | VarChar | Y) Yes N) No | 1 | Y | |||
| ProfTax | Profit Taxation | Int | 11 | -1 | ||||
| CompQualif | Company Qualification | Int | 11 | 1 | ||||
| DeclType | Declarer Type | Int | 11 | 1 | ||||
| IPITaxCon | IPI Tax Contributor | VarChar | N) No Y) Yes | 1 | N | |||
| ISVATRegNo | IS VAT Reg. No. of Trader | nVarChar | 100 | |||||
| ISVATRegEx | IS VAT Reg. No. Extension | nVarChar | 10 | |||||
| ISObligLvl | IS Degree of Obligation | VarChar | 1 | |||||
| ISTaxState | IS Federal State of Tax Office | nVarChar | 3 | OCST States | ||||
| ISComDecID | IS Company Declaration ID | nVarChar | 32 | |||||
| OKDPNum | OKDP Number | nVarChar | 7 | |||||
| ISValidKey | IS Validation Key Ident. | nVarChar | 35 | |||||
| ISDnsce | IS Declaration Office | nVarChar | 10 | |||||
| ISDfltPath | IS Default File Path | Text | 16 | |||||
| ISSimpProc | IS Simplified Procedure | VarChar | Y) Yes N) No | 1 | Y | |||
| ISForceCmp | IS Require All Data | VarChar | Y) Yes N) No | 1 | Y | |||
| ISCstRecSt | IS Customs Section | nVarChar | 6 | |||||
| ISDfltInct | IS Default Incoterms | Int | 11 | |||||
| ISDfCPEx | IS Default Customs Proc. Exp. | Int | 11 | |||||
| ISDfCPIm | IS Default Customs Proc. Imp. | Int | 11 | |||||
| ISDfNTEx | IS Dflt Nat. of Trans. for Exp | Int | 11 | |||||
| ISDfNTIm | IS Dflt Nature of Tran. Imp. | Int | 11 | |||||
| ISDfPortEx | IS Default Port for Export | Int | 11 | |||||
| ISDfPortIm | IS Default Port for Import | Int | 11 | |||||
| ISDfSPEx | IS Default Stat. Proc. Export | Int | 11 | |||||
| ISDfSPIm | IS Default Stat. Proc. Import | Int | 11 | |||||
| ISDfCSTEx | IS Default State for Export | Int | 11 | ODCI Intrastat Configuration | ||||
| ISDfCSTIm | IS Default State for Import | Int | 11 | ODCI Intrastat Configuration | ||||
| ISDfTMEx | IS Default Transport Mode Exp. | Int | 11 | |||||
| ISDfTMIm | IS Default Transport Mode Imp. | Int | 11 | |||||
| ISDeclDept | Declaring Department | Int | 6 | |||||
| ISExlDocQt | Excl. Docs w/ Qty Less Than | VarChar | Y) Yes N) No | 1 | N | |||
| ISDocQtLm | Document Quantity Limit | Num | 20 | |||||
| ISExlDocAm | Excl. Docs w/ Amt Less Than | VarChar | Y) Yes N) No | 1 | N | |||
| ISDocAmLm | Document Amount Limit | Num | 20 | |||||
| ISDspNMass | Always Display Net Mass Value | VarChar | Y) Yes N) No | 1 | Y | |||
| Free1 | IS Default Country Import | nVarChar | 3 | |||||
| Free2 | IS Default Country Import | nVarChar | 3 | |||||
| CommerReg | Commercial Register | nVarChar | 60 | |||||
| DateOfInc | Date of Incorporation | Date | 8 | |||||
| SPEDProf | SPED Profile | nVarChar | 2 | |||||
| EnvTypeNFe | Environment Type NFe | Int | 11 | -1 | ||||
| Opt4ICMS | Opting for ICMS 115_03 | VarChar | 1 | N | ||||
| ISInstIntr | IS Install Intrastat | VarChar | Y) Yes N) No | 1 | N | |||
| GlblLocNum | Global Location Number | nVarChar | 50 | |||||
| PTLedgeGen | Period Type for Ledger Gen. | VarChar | Y) Year Q) Quarter M) Month P) Period | 1 | M | |||
| BZStRegID | BZSt Register ID | nVarChar | 6 | |||||
| BZStSendID | BZSt Sender ID | nVarChar | 11 | |||||
| PostInVat | Post Input VAT in A/P Invoice | VarChar | Y) Yes N) No | 1 | N | |||
| EnbEATrns | Enable EA for Transfer Doc. | VarChar | Y) Yes N) No | 1 | N | |||
| EnbEAInv | Enable EA for Inv. Doc. | VarChar | Y) Yes N) No | 1 | N | |||
| AuthUser | Authorized User | nVarChar | 100 | |||||
| AuthPwd | Authorization Password | nVarChar | 100 | |||||
| UrlGoods | URL for Goods Transport | nVarChar | 127 | |||||
| UrlInvType | URL for Invoice Type | nVarChar | 127 | |||||
| ElGoodsFmt | El. Doc. Format for Goods Trns | Int | 11 | OLLF Legal List Format | ||||
| ElInvFmt | El. Doc. Format for Invoice | Int | 11 | OLLF Legal List Format | ||||
| ElDigiCert | El. Digit. Cert. Path | Text | 16 | |||||
| TaxRptFrm | Tax Wizard Reporting From | Date | 8 | |||||
| Suframa | SUFRAMA | nVarChar | 100 | |||||
| EnbInItIQI | Enable Inactive Items in IQI | VarChar | Y) Yes N) No | 1 | N | |||
| EnbInItINC | Enable Inactive Items in INC | VarChar | Y) Yes N) No | 1 | Y | |||
| ExtRevAct | Extend Revenue Accounts | VarChar | Y) Yes N) No | 1 | N | |||
| IsStartup | Identify Startup Company | VarChar | 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
AdminInfo
Object
ExtendedAdminInfo
Property
AddressType
DB
StreetNo
DB
Service
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
