📚 SAP Business One SDK Help

Table Name: ADM1

Table Description: Administration Extension

Field Description Type Size Related Default Value Constraints
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 State nVarChar 3 OCST      
Country Country/Region nVarChar 3 OCRY      
IntrntAdrs Internet Address nVarChar 50 -      
Code Code Int 11 - 1    
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 1 - Y Y Yes
            N No
DspIITMDoc Display Inactive BPs in Doc. VarChar 1 - Y Y Yes
            N No
ProfTax Profit Taxation Int 11 - -1    
CompQualif Company Qualification Int 11 - 1    
DeclType Declarer Type Int 11 - 1    
IPITaxCon IPI Tax Contributor VarChar 1 - N N No
            Y Yes
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      
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 1 - Y Y Yes
            N No
ISForceCmp IS Require All Data VarChar 1 - Y Y Yes
            N No
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      
ISDfCSTIm IS Default State for Import Int 11 ODCI      
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 1 - N Y Yes
            N No
ISDocQtLm Document Quantity Limit Num 19.6 -      
ISExlDocAm Excl. Docs w/ Amt Less Than VarChar 1 - N Y Yes
            N No
ISDocAmLm Document Amount Limit Num 19.6 -      
ISDspNMass Always Display Net Mass Value VarChar 1 - Y Y Yes
            N No
ImInfSup Immediate Information Supply VarChar 1 -      
Free2 Free2 VarChar 1 -      
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 1 - N Y Yes
            N No
GlblLocNum Global Location Number nVarChar 50 -      
PTLedgeGen Period Type for Ledger Gen. VarChar 1 - M Y Year
            Q Quarter
            M Month
            P Period
BZStRegID BZSt Register ID nVarChar 6 -      
BZStSendID BZSt Sender ID nVarChar 11 -      
PostInVat Post Input VAT in A/P Invoice VarChar 1 - N Y Yes
            N No
EnbEATrns Enable EA for Transfer Doc. VarChar 1 - N Y Yes
            N No
EnbEAInv Enable EA for Inv. Doc. VarChar 1 - N Y Yes
            N No
AuthUser Authorized User nVarChar 100 -      
AuthPwd Authorization Password nVarChar 100 -      
UrlGoods URL for Goods Transport nVarChar 250 -      
UrlInvType URL for Invoice Type nVarChar 250 -      
ElGoodsFmt El. Doc. Format for Goods Trns Int 11 OLLF      
ElInvFmt El. Doc. Format for Invoice Int 11 OLLF      
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 1 - N Y Yes
            N No
EnbInItINC Enable Inactive Items in INC VarChar 1 - Y Y Yes
            N No
ExtRevAct Extend Revenue Accounts VarChar 1 - N Y Yes
            N No
IsStartup Identify Startup Company VarChar 1 - N Y Yes
            N No
IsCUITMndt Block adding/updating BP without valid CUIT/CUIL VarChar 1 - N Y Yes
            N No
LnMlBrnch Allow Linking of Multiple Branches VarChar 1 - Y Y Yes
            N No
DfBrnchPh Allow Different Branch in Phases VarChar 1 - Y Y Yes
            N No
AplShipPch Apply Ship-to on Purchasing VarChar 1 - N Y Yes
            N No
AsnBrnchBP Auto Assign Branches to BP VarChar 1 - Y Y Yes
            N No
ApyPRinAT Apply PRJ in Automatic TRN VarChar 1 - N Y Yes
            N No
ApyDRinAT Apply DR in Automatic TRN VarChar 1 - N Y Yes
            N No
EnMlBrkInv Enable Multiple Broker Invoices for Landed Costs VarChar 1 - N N No
            Y Yes
PEFilePath Payment Bank File Path1 Text 16 -      
EnableGDPR Enable Personal Data Protection Management VarChar 1 - N Y Yes
            N No
MTDLbltAct Outstanding Liabilities Tax Account nVarChar 15 OACT      
MTDClmAct Outstanding Refunds Tax Account nVarChar 15 OACT      
RmrksIncld Document Remarks Include VarChar 1 - Y Y Base Document Number
            N BP Reference Number
            E Manual Remarks Only
VerfVatNo Verify VAT Numbers VarChar 1 - N N No
            Y Yes
VerfVatMxD Max. Days for VAT No. Verify Int 11 - 1    
VerfVatAct Verify VAT Num For Doc Action nVarChar 100 - NNNNNNNNNNNNNNNNNNNNNNNNNNNNN    
CNPJOfIT CNPJ of IT Company nVarChar 14 -      
CnPerson Contact Person nVarChar 60 -      
Email E-Mail nVarChar 60 -      
Telephone Phone Number nVarChar 50 -      
ISUseDscSV Include Document Discount for Statistical Value VarChar 1 - Y Y Yes
            N No
UrlRegSrv URL for Series Registration Service nVarChar 250 -      
ElSersReg El. Doc. Format Series Registration Int 11 -      
ELSersCncl El. Doc. Format Series Cancelation Int 11 -      
ELSersFin El. Doc. Format Series Finalization Int 11 -      
EnbEASer Enable Electronic Approval for Series VarChar 1 - N Y Yes
            N No
IntrFLines Intrastat Result File Num of Lines Int 11 - -1    
CargoTrack Cargo Tracking & Tracing in EU VarChar 1 - N Y Yes
            N No
NoWrnLkUdf No Warning for Link-Type UDF VarChar 1 - N Y Yes
            N No
TaxComPosN Calculate Tax for Combined Positive and Negative Rows VarChar 1 - N Y Yes
            N No
ObjList Document nVarChar 11 - 13 1470000049 Capitalization
            1470000071 Depreciation Run
            1470000090 Fixed Asset Transfer
            23 Sales Quotation
            17 Sales Order
            15 Delivery
            234000031 Return Request
            16 Returns
            203 A/R Down Payment
            13 A/R Invoice
            165 A/R Correction Invoice
            166 A/R Correction Invoice Reversal
            14 A/R Credit Memo
            1470000113 Purchase Request
            540000006 Purchase Quotation
            22 Purchase Order
            20 Goods Receipt PO
            234000032 Goods Return Request
            21 Goods Return
            204 A/P Down Payment
            18 A/P Invoice
            163 A/P Correction Invoice
            164 A/P Correction Invoice Reversal
            19 A/P Credit Memo
            69 Landed Costs
            24 Incoming Payment
            25 Deposit
            46 Outgoing Payment
            76 Postdated Deposit
            57 Check for Payment
            30 Journal Entry
            28 Journal Voucher
            140000010 Incoming Excise Invoice
            140000009 Outgoing Excise Invoice
            59 Goods Receipt
            60 Goods Issue
            1250000001 Inventory Transfer Request
            67 Inventory Transfer
            68 Work Instructions
            202 Production Order
            162 Inventory Revaluation
            156 Pick List
            1470000065 Inventory Counting
            10000071 Inventory Posting
            310000001 Inventory Opening Balances
            191 Service Call
            190 Service Contract
            176 Equipment Card
            88 Entrada
            89 Salida
            90 Traspaso
            132 Correction Invoice
            234000021 Project Management Document
RoundSums Automatic Rounding for Document VarChar 1 - N Y Yes
            N No
SplitTran1 Split Transaction 1 VarChar 1 - N Y Yes
            N No
SplitTran2 Split Transaction 2 VarChar 1 - Y Y Yes
            N No
SplitTran3 Split Transaction 3 VarChar 1 - Y Y Yes
            N No
EngKBCard Change to English Keyboard When Entering BP Code VarChar 1 - N Y Yes
            N No
EngKBItem Change to English Keyboard When Entering Item No. VarChar 1 - N Y Yes
            N No
SpltTrBOE1 In Bill of Exchange Deposit VarChar 1 - N Y Yes
            N No
MaxUOPay Under/Overpayment Amt Allowed Num 19.6 -      
AllowFuPos Allow Future Posting Date VarChar 1 - N Y Yes
            N No
ErdOutMode Post Positive Exchange Rate Differences as Negatives VarChar 1 - N Y Yes
            N No
ErdIncMode Post Negative Exchange Rate Differences as Negatives VarChar 1 - N Y Yes
            N No
YearTrans Display Transaction in Payment VarChar 1 - N N No
            Y Yes
ReconJeSer Reconciliation JE Series Int 6 - 0    
ChkDupRef When Duplicated Customer Reference No. Occurs VarChar 1 - N N Without Warning
            W Warning Only
            B Block Release
CpyCVRef Allow Copying Customer Reference No. to Target Doc. VarChar 1 - N N No
            Y Yes
ReopOrder Reopen Doc. by Creating Returns/Goods Returns/Credit Memos Based on Doc. VarChar 1 - N N No
            Y Yes
ForceReOrd Without User Confirmation VarChar 1 - N N No
            Y Yes
RecomPkg Recommend Packaging Based on Item Master Data VarChar 1 - N N No
            Y Yes
orderblock Block documents with earlier Posting Date VarChar 1 - N Y Yes
            N No
Enitemcost Allow Setting Item Cost When Document is Not Based VarChar 1 - N Y Yes
            N No
ClosePQ Close Document When Its Base Purchase Request is Closed VarChar 1 - Y Y Yes
            N No
CpyPRPrice Copy Prices from Purchase Requests to Purchase Orders VarChar 1 - N Y Yes
            N No
EnSetCost Enable Setting Cost on All Document Rows by Default VarChar 1 - N    
DftPLChk Price List of Return Cost VarChar 1 - N    
DfltPLSel Default Price List Selection Int 6 - -1    
BlockWHT08 Block Payment in Local Currency in Case BP is Subjected to WHT Group Code '08' VarChar 1 - N Y Yes
            N No
PoDropPrss Activate Automatically for Drop-Ship Warehouse Lines VarChar 1 - Y Y Yes
            N No
ShowCash Allow Cash Accounts Only for Cash Payment Means VarChar 1 - N Y Yes
            N No
PRUseBPTax Update Tax Code according to BP default Tax Code VarChar 1 - N Y Yes
            N No
EnblTtlEgD Apply Exchange Rate of Drawn Down Payments VarChar 1 - N Y Yes
            N No
EnblUpdUDF Allow Update of User-Defined Fields When Document Rows Are Not Editable VarChar 1 - N Y Yes
            N No
EnblDpmTax Enable Tax Calculation in Down Payment Invoices VarChar 1 - N Y Yes
            N No
ChkRefBP Check for Duplicate Under VarChar 1 - N Y Yes
            N No
ChkRefYear Check for Duplicate in Current Fiscal Year Only VarChar 1 - N Y Yes
            N No
BspDpmType Down Payment Type for BSP VarChar 1 - E E  
            R Down Payment Request
            I Down Payment Invoice
ReopenByC Display Base Document Items in Procurement Confirmation Wizard When Target Documents Are Canceled VarChar 1 - N N No
            Y Yes
ForceReByC Without User Confirmation VarChar 1 - N N No
            Y Yes
OpenSnB Open Serial/Batch Selection for Auto. Allocated Items Issued Primarily by Bin Location VarChar 1 - N N No
            Y Yes
BItmDscUpd Block Item Description Updated in the Copied Lines VarChar 1 - N N No
            Y Yes
DeferrTax Deferred Tax VarChar 1 - N Y Yes
            N No
EnblExpns Manage Freight in Documents VarChar 1 -   Y Yes
            N No
RateBase Exchange Rate Base Date (A/P Documents) VarChar 1 - P P Posting Date
            T Document Date
DispTrByDf Display All Transactions by Default VarChar 1 - Y Y Yes
            N No
stampTax Default Stamp Tax nVarChar 8 -      
DaysOrdCnc Default Days for Order Cancellation Int 11 - 30    
ChkQunty Activate Automatic Availability Check VarChar 1 - N Y Yes
            N No
MxDcsInPmt Maximum No. of Documents in Payment Int 11 - 0    
SameURLPmt Enable Same URL for Payment Service VarChar 1 - N Y Yes
            N No
ElPmtFmt Enable Payment Format Int 11 OLLF      
CpyRefDoc Copy Document References VarChar 1 - Y Y Yes
            N No
ISEFMAbs EFM Template ID Int 11 -      
CtlActSlct Allow Control Account Selection VarChar 1 - N Y Yes
            N No
SepDiscDpm Separate Discount % and DPM % Fields VarChar 1 - N Y Yes
            N No
ISExlWoQty Exclude Document Row Marked as Without Qty Posting VarChar 1 - Y Y Yes
            N No
DppNzbBP When Blocking or Cleaning Up a Business Partner with a Non-zero Balance VarChar 1 - W W Allow with Warning
            B Cancel Process
CpyListNum Copy Price List from Base Document VarChar 1 - N Y Yes
            N No
UsrAcctID User Account ID nVarChar 10 -      
DpmEUSales Incl. DPM in EU Sales Report VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes Code