biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Banking / House Bank Accounts
API AADM
AADM - Administration - Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CompnyNameCompany NamenVarChar
100
CompnyAddrAddressnVarChar
127
CountryCountrynVarChar
3OCRY
Countries
PrintHeadrPrinting HeadernVarChar
100
Phone1Telephone Number 1nVarChar
20
Phone2Telephone Number 2nVarChar
20
FaxFax NumbernVarChar
20
E_MailE-MailnVarChar
100
ManagerManaging DirectornVarChar
100
CompTypeChart of Accounts TemplateVarChar
1
U
MainCurncyLocal CurrencynVarChar
3
SysCurrncySystem CurrencynVarChar
3
DispPosDebCredit Balance with Minus SignVarChar
Y) Yes
N) No
1
N
DefLengthUStandard Unit of LengthInt
6
2
DefWeightUDefault Weight UoMInt
6
2
DfltVendPMDefault Payt Method for VendornVarChar
15OPYM
Payment Methods for Payment Wizard
DirectRateDirect/Indirect RateVarChar
Y) Yes
N) No
1
Y
MinAmnt347Minimum Amount for 347 ReportNum
20
AutoITWSet Items - WarehousesVarChar
Y) Yes
N) No
1
N
BankCountrBank CountrynVarChar
3
TaxIdNumFederal Tax IDnVarChar
32
RevOfficeTax OfficenVarChar
100
FreeZoneNoAdditional ID NumbernVarChar
32
DdctFileNoDeduction File No.nVarChar
50
VatChargeTax CollectionVarChar
Y) Yes
N) No
1
Y
PayOutVatTax DefinitionVarChar
Y) Yes
N) No
1
N
VatPrcntTax RateNum
20
DpsitPrcntAdvances on Corp. Income Tax %Num
20
IncomeTaxWithholding Tax %Num
20
VendorDdctWithholding TaxVarChar
Y) Yes
N) No
1
N
CustmrDdctCustomer's Deduction at SourceVarChar
Y) Yes
N) No
1
N
DdctPercntWithholding Tax Deduction %Num
20
DdctExpireWithholding Tax Ded. in % - ExDate
8
DdctOfficeWithholding Tax Deduction - OfnVarChar
100
EURepSqntlSequential Number of EU SalesInt
11
0
BoxRptSeqBox Report Sequential NumberInt
11
0
WTLiableWTax LiableVarChar
1
Y
DfltCustPMDefault Payt Method for Cust.nVarChar
15OPYM
Payment Methods for Payment Wizard
AllowFuPosAllow Future Posting DateVarChar
Y) Yes
N) No
1
N
UseProdWipUse Product WIP AccountVarChar
Y) Yes
N) No
1
Y
CurrPeriodCurrent PeriodnVarChar
10
XmlPathXML File PathText
16
DflBnkKeyDefault Bank KeyInt
11ODSC
Bank Codes
BSInstledBank Statement InstalledVarChar
Y) Yes
N) No
1
N
UseShpdGdUse Shipped Goods AccountVarChar
Y) Yes
N) No
1
N
UseExtRptUse Extended Reporting (OTRS)VarChar
Y) Yes
N) No
1
N
ERpPerTypePeriod Type for GenerationVarChar
Y) Year
Q) Quarter
M) Month
P) Period
1
M
DfSVatExmpSales Tax Group for ExemptnVarChar
8
DfPVatExmpPurchases Tax Group for ExemptnVarChar
8
Manager1General ManagernVarChar
100
Manager1FGeneral Manager (For. Lang.)nVarChar
100
CCMaskMask Credit Card NumberVarChar
Y) Yes
N) No
1
Y
ObligLimitCommitment RestrictionVarChar
Y) Yes
N) No
1
N
CreditLimtCredit RestrictionVarChar
Y) Yes
N) No
1
N
SalesLimitRestrict SalesVarChar
Y) Yes
N) No
1
N
DlnLimitRestrict Del. Notes (PO)VarChar
Y) Yes
N) No
1
N
OrderLimitRestrict OrdersVarChar
Y) Yes
N) No
1
N
AddDlnBlncConsider Deliv - Sales RevenueVarChar
Y) Yes
N) No
1
N
CreditDpstCredit Deposit TypeVarChar
Y) Manually
N) Automatically
1
N
MultiLangMulti-Language Support EnabledVarChar
Y) Yes
N) No
1
N
DbVersDatabase VersionInt
11
ApplVersApplication VersionInt
11
DflWebSiteDefault for Web SiteText
16
DflFTPSiteDefault for FTP SiteText
16
UseTaxUse TaxVarChar
Y) Yes
N) No
1
N
RevisionPoSplit Purchase OrderVarChar
Y) Yes
N) No
1
N
ReindexRebuild IndexesVarChar
Y) Yes
N) No
1
N
DllPathPath to Validation DLLText
16
TaxIdValidTax ID Mandatory ValidationVarChar
Y) Yes
N) No
1
N
PchNameSplit Purchase OrdernVarChar
20
RpcNameRebuild IndexesnVarChar
20
PdnNameFree24nVarChar
20
RpdNameAlt Name for Goods ReturnnVarChar
20
PorNameAlternative Name for PurchasenVarChar
20
LevelWarnAlert Type for Whse StockVarChar
W) Warning Only
B) Block
D) No Message
1
W
CrdCommUseSet Commission by CustomerVarChar
Y) Yes
N) No
1
N
ItmCommUseSet Commission by ItemVarChar
Y) Yes
N) No
1
N
SlpCommUseAlternative Name for PurchaseVarChar
Y) Yes
N) No
1
N
DfCustTermDefault Pmt Terms for Cust.Int
6
-1
DfVendTermDefault Vendor Payment TermsInt
6
-1
SaleProfitCalc. Gross Profit per Trans.VarChar
Y) Yes
N) No
1
Y
CostPrcLstSet Commission by Sales Emp.Int
6
-1
GrossBySalGross Profit After SaleVarChar
Y) Yes
N) No
1
N
TreePricOnDisplay Price for Parent OnlyVarChar
Y) Yes
N) No
1
N
AddVatCalc. Gross Profit per Trans.VarChar
Y) Yes
N) No
1
Y
BaseFldBase FieldVarChar
Y) Yes
N) No
1
Y
ClosedQuotAllow Closed Sales QuotationsVarChar
Y) Yes
N) No
1
N
UseCodeUser Conversion CodeVarChar
Y) Yes
N) No
1
N
Code1CODE1nVarChar
8
Code2CODE2nVarChar
8
Code3CODE3nVarChar
8
Code4CODE4nVarChar
8
ColorCompany ColorInt
0
1) Classic
2) Gray
3) Violet
4) Blue
5) Green
6) Yellow
7) Orange
8) Red
9) Brown
6
1
SumDecTotals AccuracyInt
6
2
QtyDecAccuracy of QuantitiesInt
6
3
PriceDecPrice AccuracyInt
6
2
RateDecRate AccuracyInt
6
4
PercentDecPercentage Rate AccuracyInt
6
4
MeasureDecMeasuring Accuracy for UnitsInt
6
3
DdAutoRunPrice AccuracyVarChar
Y) Yes
N) No
1
N
DdNextDueRate AccuracyDate
8
DdHourPercentage Rate AccuracyInt
6
CmpnyAddrFAddress in Foreign LanguagenVarChar
127
DflTaxCodeDefault Tax CodenVarChar
8OSTC
Sales Tax Codes
PrintHdrFLetter Header in Foreign Lang.nVarChar
100
Phone1FTel. No. 1 (Foreign Language)nVarChar
20
Phone2FTel. No. 2 (Foreign Language)nVarChar
20
FaxFFax Number (Foreign Lang.)nVarChar
20
ManagerFLetter Header in Foreign Lang.nVarChar
100
TimeFormatTime TemplateVarChar
0
1) 12H
1
0
CigCupCig and Cup WarningVarChar
Y) Yes
N) No
1
N
DateFormatDate TemplateVarChar
0
1) DD/MM/CCYY
2) MM/DD/YY
3) MM/DD/CCYY
4) CCYY/MM/DD
5) DD/Month/YYYY
6) YY/MM/DD
1
0
DateSepDate SeparatorVarChar
1
/
FcNoBlncForeign Currency Checking AccountVarChar
B) Block
D) No Message
1
B
ChangeRdrChanged Existing OrdersVarChar
Y) Yes
N) No
1
Y
MultiCurrMulti-Currency CheckVarChar
B) Block
D) No Message
1
B
PickParDlvPartial Deliv. Pick and PackVarChar
Y) Yes
N) No
1
N
MaxTaxIncrMaximum Increase of Tax AmountNum
20
ISRTypeISR TypeInt
1) ISR
2) BISR
3) ISR+
4) BISR+
6
2
MaxTaxDecrMaximum Decrease of Tax AmountNum
20
RoundRmrkDisplay Rounding RemarkVarChar
Y) Yes
N) No
1
Y
ISRBillerIISR Biller IDnVarChar
9
UpdStampUpdate StampInt
11
SysCNoEditBlock System Currency EditingVarChar
Y) Yes
N) No
1
Y
RefDNoEditBlock Updating of Posting DateVarChar
Y) Yes
N) No
1
Y
DfltWhsDefault WarehousenVarChar
8
TaxDNoEditFreeVarChar
Y) Yes
N) No
1
Y
DfSVatItemTax DefinitionnVarChar
8
DfSVatServTax DefinitionnVarChar
8
DfPVatItemTax Group for Purchase ItemnVarChar
8
DfPVatServTax Group for Service PurchasenVarChar
8
DoBudgetCalculate BudgetVarChar
Y) Yes
N) No
1
N
CustIdNumCustomer IDnVarChar
6
0
BgtBlockBlock BudgetVarChar
B) Only Annual Alert
N) Monthly Alert Only
W) Block
1
N
BgtWarningBudget AlertVarChar
A) Annual Alert
M) Monthly Alert
1
A
BdgtPORDocBlock Purchase OrdersVarChar
Y) Yes
N) No
1
Y
BdgtAcctngBlock BookkeepingVarChar
Y) Yes
N) No
1
N
BdgtDfltDefault Budget Cost Assmt MthdInt
11
1
ContInvntPerpetual Inventory ManagementVarChar
Y) Yes
N) No
1
N
InvntSystmPerpetual Inventory SystemVarChar
A) Moving Average
S) Standard
F) FIFO
1
A
ApplicIFRSApplication of IFRSVarChar
N) No
Y) Yes
1
N
StartYearStarting in Fiscal YearInt
6
AccordingReport According ToInt
1)
2)
3)
6
1
MltpBrnchsEnable Multiple BranchesVarChar
Y) Yes
N) No
1
N
EnblSrvTaxEnable Service TaxVarChar
Y) Yes
N) No
1
N
DftRCNDefault for Retail ChainsInt
11
-6
RoundVatRound Tax AmountsVarChar
Y) Yes
N) No
1
N
BdgtPDNDocBlock Deliv. Notes for Purch.VarChar
Y) Yes
N) No
1
Y
IRSFileNoFile Number in Income TaxnVarChar
9
DeferrTaxDeferred TaxVarChar
Y) Yes
N) No
1
N
DflIntrstMin. Default Interest AmountNum
20
DfltSlpSales EmployeeInt
6
-1
DflCrCardDefault Credit CardInt
6
DflBnkCodeDefault Bank No.nVarChar
30
DflBnkAcctDefault Bank AccountnVarChar
50
DflBranchDefault BranchnVarChar
50
UsePaSysSales EmployeeVarChar
Y) Yes
N) No
1
N
Serv_UsrService CodenVarChar
20
Serv_PassService PasswordnVarChar
20
ParamPathParameter Folder PathText
16
ExcelPathExcel Folder PathText
16
TaxIdNum2Federal Tax ID 2nVarChar
32
TaxIdNum3Federal Tax ID 3nVarChar
32
DecSepDecimal SeparatorVarChar
1
.
ThousSepThousands SeparatorVarChar
1
,
CurOnRightDisplay Currency on the RightVarChar
Y) Yes
N) No
1
N
WarnByWhsAlert by WarehouseVarChar
N) No
Y) Yes
1
N
DflBnkAcKyDefault Bank Account No.Int
11DSC1
House Bank Accounts
PriceSysPrice SystemVarChar
Y) Whse
N) Item
1
Y
DftPVLPreferred Vendor CreditInt
11
-1
useDdctTrcWTax Deduction - HierarchyVarChar
Y) Yes
N) No
1
N
useDocWrfDoc. ConfirmationVarChar
Y) Yes
N) No
1
N
BtchStatusDefault for Batch StatusVarChar
0
1) Not Accessible
2) Locked
1
0
OrderBatchManage Orders in BatchesVarChar
Y) Yes
N) No
1
Y
GLMethodSet G/L Account ByVarChar
W) Warehouse
C) Item Group
L) Item Level
1
W
SetSriUniqSet Unique Serial No.VarChar
Y) Yes
N) No
1
N
SriUniqFldUnique Serial No.VarChar
0
2) Mfr Serial No.
3) Serial Number
4) Lot Number
1
3
MaxHistoryMax. HistoryInt
11
99
TaxRateDetTax Rate DeterminationVarChar
P) Posting Date
D) Document Date
1
P
RefreshQtyRefresh in Whse Qty in DIVarChar
Y) Yes
N) No
1
N
StockNoBasStock No. BaseVarChar
1
MaxCntRowsAllowed Max Rows in CountingInt
11
10000
CentPmtIncEnable Incom. Centralized PaytVarChar
N) No
Y) Yes
1
N
CentPmtOutEnable Outg. Centralized PaytVarChar
N) No
Y) Yes
1
N
ChCtrAPActChange Def. Recon. A/P AcctsVarChar
Y) Yes
N) No
1
N
ChCtrARActChange Def. Recon. A/R AccountsVarChar
Y) Yes
N) No
1
N
PACUsrNamePAC User NamenVarChar
100
PACPasswrdPAC PasswordnVarChar
100
CaredTypeBP Type CodenVarChar
01) 01
04) 04
15) 15
71) 71
73) 73
75) 75
2
PBSNumberPBS NumbernVarChar
8
PBSGroupNoPBS Group NumbernVarChar
5
OrgNumberOrganization NumbernVarChar
100
ActSepAccount Segments SeparatorVarChar
1
DspBokpWinDisplay Bookkeeping WindowVarChar
Y) Yes
N) No
1
N
SHandleWTWithholding TaxVarChar
Y) Yes
N) No
1
N
SDfltWTDefault Withholding Tax CodenVarChar
4OWHT
Withholding Tax
IncresGlAcG/L Increase AccountnVarChar
Y) Yes
N) No
15OACT
G/L Accounts
PHandleWTWithholding TaxVarChar
1
PDfltWTDefault Withholding Tax CodenVarChar
4OWHT
Withholding Tax
ExWTLiablWTax Liable ExpenseVarChar
Y) Yes
N) No
1
N
EDocSeqNumElectronic Document Sequence NumberInt
11
1
AllowPostZAllow Inb. Pstng W/o a PriceVarChar
Y) Yes
N) No
1
N
PostDiffRDisplay in Red Greater Than %Num
5) Variance Percentage Default Value
20
5
EnableROEnable Release Only Snb in PstVarChar
Y) Yes
N) No
1
N
UalLastDelLast Delete Date on Table OUALDate
8
UalKeepDayDays for keeping data on OUALInt
11
30
NegAmountUse Negative AmountsVarChar
Y) Yes
N) No
1
Y
EnbDocOptEnable Document OptimizationVarChar
Y) Yes
N) No
1
Y
HldCodeFree57nVarChar
20OHLD
Holiday Table
AlphaDocFree58VarChar
N) No
Y) Yes
1
N
free62Free62VarChar
1
free63Free63VarChar
1
free64Free64VarChar
1
free65Free65VarChar
1
OrderBlockOrder BlockVarChar
1
RoundMthdRounding MethodVarChar
Y) Yes
N) No
1
N
AdrsFromWHFree63VarChar
Y) Yes
N) No
1
Y
OrderPartyOrdering PartynVarChar
30
CrtfcateNOCertificate No.nVarChar
20
ExpireDateExpiration DateDate
8
NINumNational Insurance No.nVarChar
20
free66Free66VarChar
1
free67Free67VarChar
1
CfwAsnMustCFW Assignment Mandatory [Y/N]VarChar
N) No
Y) Yes
1
Y
CfwInDfltIncoming Payment Draft CF ItemInt
11
CfwOutDfltOutgoing Payment Dflt CFW ItemInt
11
free68Free68VarChar
1
free69Free69VarChar
1
TaxRegimeTax RegimenVarChar
100
AliasNameAlias NameText
16
DftJPELineDefault Line For Local AreaVarChar
1
RdrConfrmdConfirmed Sales OrderVarChar
Y) Yes
N) No
1
Y
PorConfrmdConfirmed Purchase OrderVarChar
Y) Yes
N) No
1
Y
free71Free71VarChar
1
free72Free72VarChar
1
ChfAccChief AccountantInt
11OHEM
Employees
TaxMethodTaxation MethodVarChar
0
1) On Payment
1
CEOCEOInt
11OHEM
Employees
free73Free73VarChar
1
free74Free74VarChar
1
RndToTDecRound VAT to TenthsVarChar
Y) Yes
N) No
1
N
SDfltITWTDefault Income Tax WTax CodenVarChar
4OWHT
Withholding Tax
PDfltITWTDefault Income Tax WTax CodenVarChar
4OWHT
Withholding Tax
free75Free75VarChar
1
free76Free76VarChar
1
DfActCurrDefault Account CurrencyVarChar
Y) All Currencies
N) Local Currency
1
Y
defTaxVendDeferred Tax for VendorsVarChar
Y) Yes
N) No
1
N
free77Free77VarChar
1
free78Free78VarChar
1
free79Free79VarChar
1
free80Free80VarChar
1
free89Free89VarChar
1
AutoVatFree77VarChar
Y) Yes
N) No
1
N
ConsumeFCTConsumer ForecastVarChar
Y) Yes
N) No
1
Y
ConsumeMtdConsumption MethodVarChar
B) Backward-Forward
F) Forward-Backward
1
B
DaysBackDays BackwardInt
11
7
DaysFwrdDays ForwardInt
11
7
IsPAPrnPanama Printer ConnectedVarChar
Y) Yes
N) No
1
N
free82Free82VarChar
1
TaxCodeCstDef. Tax Code (New Customers)nVarChar
8OSTC
Sales Tax Codes
TaxCodeVndDef. Tax Code (New Vendors)nVarChar
8OSTC
Sales Tax Codes
StateStatusnVarChar
3OCST
States
CharMonthNumber of Characters in MonthInt
11
free83Free83VarChar
1
free84Free84VarChar
1
free85Free85VarChar
1
free86Free86VarChar
1
AltBOEPostActive Alternative BOE PostVarChar
Y) Yes
N) No
1
N
LDiscTotalFree83VarChar
Y) Yes
N) No
1
Y
Code KEY UNIQUECodeInt
11
1PRIMARYYes
DfltDunTrmDefault Dunning TermsnVarChar
25ODUT
Dunning Terms
ProfessionProfessionnVarChar
50
free88Free88VarChar
1
DfltCDPDefault Closing Date ProcedureInt
6
-1
LogInstancLog InstanceInt
11
0
UpdateDateUpdate DateDate
8
UserSignUser SignatureInt
6OUSR
Users
DflBCACodeFree88nVarChar
3OBCA
Bank Charges Allocation Codes
IgrAllCashIgnore All Cash Flow RelevantVarChar
Y) Yes
N) No
1
Y
TaxPayerRfLog InstancenVarChar
32
EmployerRfEmployer's ReferencenVarChar
32
PStatAutChPeriod Status Automatic ChangeVarChar
Y) Yes
N) No
1
Y
PStatDelayPeriod Status Change DelayInt
6
1
RepBusTypeReporting Business TypenVarChar
Y) Yes
N) No
1) Industrial
2) Commercial
3) Service Provider
9) Other
4) Contractor
2
2
RepBusOthrUnique Taxpayer Ref. (UTR)nVarChar
32
BrachNumBranch NumbernVarChar
4
BuisnesDscBusiness DescriptionnVarChar
Y) Yes
N) No
50
ReptMethodReporting MethodnVarChar
1) Cash
2) Cumulative
3) US Dollar Regulation
2
2
AcctMethodAccounting MethodnVarChar
1) Unilateral
2) Double
2
2
BookpitypeBookkeeping TypenVarChar
1) Manual
2) Computerized
3) Mixed
2
2
ActSoftNamAccounting Software NamenVarChar
100
OpnClsRmrkCopy Opening/Closing RemarksVarChar
Y) Yes
N) No
1
Y
TaxRndRuleDefault Tax Rounding RuleVarChar
R) Round Off
C) Round Up
F) Round Down
1
NegTaxAllow Neg. Tax Amt in ReturnsVarChar
Y) Yes
N) No
1
N
ZeroLineAllow Zero Amt Row in JEVarChar
Y) Yes
N) No
1
Y
GBOpenFileOpen GBI File After ExportVarChar
Y) Yes
N) No
1
N
GBIntfaceGBI enabledVarChar
Y) Yes
N) No
1
N
DfltCDPVDefault A/P Closing Date Proc.Int
6
-1
OnHldPertCapital Goods On Hold Percent.Num
20
WTRndRuleDefault WTax Rounding RuleVarChar
R) Round Off
C) Round Up
F) Round Down
1
GPPrcntSrvDefault GP % in Service Doc.Num
20
DspFrznBPDisplay Inactive BPs in RptVarChar
Y) Yes
N) No
1
Y
DspFrznITMDisplay Inactive Items in RptVarChar
Y) Yes
N) No
1
Y
WTAccumAmtAccum. Amount for WTax on APNum
20
NewDPRCusHide Dpm InvoiceVarChar
Y) Yes
N) No
1
Y
ServNatureService NatureVarChar
1
PickLimitRestrict Pick ListVarChar
Y) Yes
N) No
1
N
WTAccAmtARAccum. Amount for WTax on ARNum
20
UseProdPLUse Production P&L AccountsVarChar
N) Use Balance Sheet Only
Y) Use Balance Sheet and Profit and Loss Account
1
N
QueryDecCalculated Query AccuracyInt
6
ExRtDefTaxExchange Rate on Deferred TaxVarChar
Y) Yes
N) No
1
N
BoletoPathBoleto PathText
16
UserSign2Updating UserInt
6OUSR
Users
MMLastImpDLast Import File DateDate
8
CpyExhRateCopy Exchange Rate in Copy ToVarChar
Y) Yes
N) No
1
N
MapServiceMap ServiceInt
11OMPS
Map Services
-1
ODWFreqOpen Doc. Refresh FrequencyInt
11
30
GTSOutPathGTS Outbound PathText
16
UseMltDimsUse MultidimensionsVarChar
Y) Yes
N) No
1
Y
MDStyleMultidimensions Display StyleVarChar
U) Unified
S) Separate
1
U
GTSInPathGTS Inbound PathText
16
GTSSepGTS SeparatornVarChar
10
GTSDftChkGTS Default CheckerInt
11OHEM
Employees
GTSDftPyeGTS Default PayeeInt
11OHEM
Employees
GTSMaxAmtGTS Max. AmountNum
20
RspOverAmtResponse to Exceeding AmountVarChar
B) Block
S) Split
1
B
DRBlock1Distribution Rule: Block 1VarChar
N) Without Warning
B) Block Posting
1
N
DRBlock2Distribution Rule: Block 2VarChar
N) Without Warning
B) Block Posting
1
N
DRBlock3Distribution Rule: Block 3VarChar
N) Without Warning
B) Block Posting
1
N
DRBlock4Distribution Rule: Block 4VarChar
N) Without Warning
B) Block Posting
1
N
DRBlock5Distribution Rule: Block 5VarChar
N) Without Warning
B) Block Posting
1
N
PrjBlockProject BlockVarChar
N) Without Warning
B) Block Posting
1
N
SimReportSimulation ReportVarChar
Y) Yes
N) No
1
N
SnapShotIdSnapshot IDInt
11
0
BackOrderPick and Pack Back OrderVarChar
Y) Yes
N) No
1
N
HQLocationHeadquarters LocationVarChar
B)
C) Continent
M) Madeira
A) Azores
1
B
DigCrtPathDigital Certificate PathText
16
DflWTSDefault E-Tax Web SiteInt
6
-1
EnbApprDIEnable DI Approval ProcedureVarChar
Y) Yes
N) No
1
N
ChBPSerieVerify Non-manual BP SeriesVarChar
Y) Yes
N) No
1
N
ChItmSerieVerify Non-manual ITM SeriesVarChar
Y) Yes
N) No
1
N
ETRTaxOffiETR Tax OfficeInt
11
0
ETRTaxPersETR Tax Person TypeVarChar
T) VAT Payer
R) Another Person Registered for Tax
S) Person required to submit a tax declaration/return according to section 78, paragraphs 3, 4, and 9
D) Taxable person according to section 3, subsection 5, when applying a tax deduction
I) Tax agent when importing goods according to section 69
1
EDocExpFrmElectronic Doc. Export FormatInt
11
PCN874RTypPCN874 Report TypeVarChar
1) Registered Business
6) Finan. Institution/Non-Profit Org.
1
1
BTWDecProvBTW Declaration ProvidernVarChar
BPL) BPL
INT) INT
3
BPL
BTWDcPrvIDBTW Declaration Provider IDnVarChar
100
BTWNameBTW NamenVarChar
100
BTWStreetBTW StreetnVarChar
100
BTWCityBTW CitynVarChar
100
BTWZipBTW ZIP CodenVarChar
30
BTWPhoneBTW Phone NumbernVarChar
100
BTWOBBTW OB IDInt
11
1
BTWICPBTW ICL IDInt
11
1
BTWOBFmtETR Telephone NumberInt
11
BTWICPFmtBTW ICP Mapping FormatInt
11
ETRPhoneNoETR Telephone NumbernVarChar
20
EDTestModeElectronic Document Test ModeVarChar
Y) Yes
N) No
1
N
EDocGenTypEl. Doc. Default Gen. TypeVarChar
G) Generate
L) Generate - Later
N) Not Relevant
1
N
EDocRptFmtEl. Document Report FormatInt
11
InputMsgEl. Doc. Input Message FormatInt
11
EDProcessElectronic Document ProcessVarChar
C) CFD
I) CFDI
1
I
PACPACnVarChar
20OPAC
PAC Companies
XML
NotifAlertNotification by AlertVarChar
Y) Yes
N) No
1
Y
NotifEmailNotification by E-MailVarChar
Y) Yes
N) No
1
N
EDocUDQCatFree58Int
11
EOutputPthFree58Text
16
EDelDocFrmElectronic Delivery Doc. Export FormatInt
11
free22Free22VarChar
1
free21Free21VarChar
1
ETRFaxNoETR Fax NumbernVarChar
20
ETRMgrPhnETR Manager's Phone NumbernVarChar
20
EDFormatElectronic Document FormatInt
11OLLF
Legal List Format
AIDFormatAnnual Invoice Decl. FormatInt
11OLLF
Legal List Format
CrtLineRFQCreate Online QuotationVarChar
Y) Yes
N) No
1
N
DflJETDefault JE TypenVarChar
60OJET
JE Document Type
OnlyPaidInDisplay Only Paid Reserve Inv.VarChar
N) No
Y) Yes
1
N
PDDEnabledPayments Due Date EnabledVarChar
1
N
MaxDays4DDMax. Allowed Range for Due DteInt
11
0
AutoAddUoMAuto. Add UoMs to ItemsVarChar
Y) Enabled
N) Disabled
1
Y
AutoAddPkgAuto. Add Pkgs to ItemsVarChar
Y) Enabled
N) Disabled
1
Y
BinActivatHas Whse Bin Activated [Y/N]VarChar
Y) Yes
N) No
1
N
IssuePriByIssue Primarily By SnB or BinInt
0
1) Issue Primarily By Bin Location
6
0
InstFixAstEnable Fixed AssetsVarChar
Y) Yes
N) No
1
N
DeprecCalcDepreciation CalculationVarChar
M) Month
D) Day
1
M
FixAstModFixed Asset ModeVarChar
P) Production
T) Transfer
1
P
SopPathSolution Packager Exe. PathText
16
NewAcctDeNew G/L Account DeterminationVarChar
Y) Yes
N) No
1
N
ClnZeroPlnClean Zero Price Row in ITM1VarChar
N) No
Y) Yes
1
N
CmdDisBothDisplay Both Related Docs.VarChar
Y) Yes
N) No
1
Y
CnclMaxDayMax. No. of Days For CancelInt
11
AttachPathAttachment PathText
16
ConfigPathConfiguration PathText
16
WrkshtPathWorksheet PathText
16
ICDifExPe1Single Count Variance (%)Num
5) Single Counting Type - Default Variance Percentage
20
5
ICDifExPe2Multiple Count Max. Variance (%)Num
5) Multiple Counting Type - Default Max Variance Percentage
20
5
ClsZoDiffRClose Rows Cont. Zero Diff.VarChar
Y) Yes
N) No
1
Y
ClsNoConfiClose Without ConfirmationVarChar
Y) Enabled
N) Disabled
1
N
DTWPathDTW Exe. PathText
16
DfltByEmlDefault by E-MailVarChar
E) E-Mail
O) Outlook E-Mail
1
E
free46Free46VarChar
1
INVOBPriceInventory OB Price ZeroVarChar
N) No
Y) Yes
1
N
SplitFBShSplit Fix Balance Sheet [Y/N]VarChar
1
N
NotifyRqrNotify RequesterVarChar
1
N
DeactivFADeactivate Asset When End LifeVarChar
N) No
Y) Yes
1
N
CshDctFACM for Payment Cash DiscountVarChar
N) No
Y) Yes
1
N
SendAlertSend Internal MessageVarChar
1
N
BdgtPRQDOCBlock Purchase RequestVarChar
Y) Yes
N) No
1
N
IsReuseNumEnable Document Number ReuseVarChar
N) No
Y) Yes
1
N
IsReuseNFNEnable Nota Fiscal No. ReuseVarChar
N) No
Y) Yes
1
N
SIPLReportShow Inactive PL in ReportsVarChar
Y) Yes
N) No
1
N
SIPLDocShow Inactive PL in DocsVarChar
Y) Yes
N) No
1
N
SIPLSetingShow Inactive PL in SettingsVarChar
Y) Yes
N) No
1
N
PriceProcMOn Change UoM Conversion RulesVarChar
R) Remove UoM Prices
U) Update UoM Prices Accordingly
L) Keep Corresponding UoM Prices Unchanged
K) Keep All UoM Prices Unchanged
1
U
ChkQtyINVEnable Check Quantity in INVVarChar
Y) Yes
N) No
1
N
EnbAdvATPEnable Advanced ATPVarChar
Y) Yes
N) No
1
N
EnblCaseEnable Case SensitivityVarChar
N) No
Y) Yes
1
N
EnbSupplCEnable Supplementary CodeVarChar
Y) Yes
N) No
1
Y
MBAOnPerAllow Multiple BAs for PeriodVarChar
N) No
Y) Yes
1
N
MBAOnAPBlock Multiple BAs for AP Doc.VarChar
N) No
Y) Yes
1
N
MBAOnARBlock Multiple BAs for AR Doc.VarChar
N) No
Y) Yes
1
N
ApyBsActSPApply Active Special PricesVarChar
Y) Yes
N) No
1
N
ApyBsActPVApply Active Period and VolumeVarChar
Y) Yes
N) No
1
N
ApyBsActPLApply Active Price ListsVarChar
Y) Yes
N) No
1
N
IsUpdNstdBUpdate Non-Std Based PricesVarChar
Y) Yes
N) No
1
N
SnBDfltSBSnB Default Eval. System SBVarChar
Y) Yes
N) No
1
N
OneBOneRecOne Batch One ReceiptVarChar
Y) Yes
N) No
1
N
ReptCurrcyR6111 Report CurrencynVarChar
1) Amounts in NIS
2) Amounts in USD
2
1
ICDifExPe3Multiple Count Vldt. Variance (%)Num
5) Multiple Counting Type - Default Individual Counter Variance Percentage
20
5
INCSingToVCopy Single Counter to Validt.VarChar
Y) Yes
N) No
1
Y
POrCByINCPosting or Create Date by INCVarChar
Y) Based on Posting Date
N) Based on Creation Date
1
N
EnbNegPymEnable Negative PaymentVarChar
Y) Yes
N) No
1
N
SirenNoSiren NumbernVarChar
9
SEPACredIDSEPA Creditor IDnVarChar
35
InstitCodeInstitution CodenVarChar
10) Secretaria da Receita Federal do Brasil
20) Banco Central do Brasil (COSIF)
2
ECDFormatECD File FormatInt
11OLLF
Legal List Format
ApyDRinPECApply DR in Period End ClosingVarChar
Y) Yes
N) No
1
N
ApyPRinPECApply PJ in Period End ClosingVarChar
Y) Yes
N) No
1
N
TaxPyerStaTAX_PAYER_STATUSnVarChar
2
MaxINVRptRAllowed Rows in INC Trans RptInt
11
85000
DftResWhsDefault Resource WarehousenVarChar
8
AutoResWhsAuto Add All Warehouses to New ResourcesVarChar
Y) Yes
N) No
1
Y
InActRptInactive ReportsVarChar
Y) Yes
N) No
1
Y
InActMktInactive Marketing DocumentsVarChar
Y) Yes
N) No
1
Y
InActPlnInactive Price ListsVarChar
Y) Yes
N) No
1
Y
StartFromStart FromVarChar
1) Today
2) Month Start
3) Month End
1
1
MonthsMonthsInt
6
1
DaysDaysInt
6
0
JEInFATranAlways Create JE in TransferVarChar
Y) Yes
N) No
1
N
TPLIdUI Template IDInt
6UICU
Customized Template
TxtSrchText SearchVarChar
Y) Yes
N) No
1
N
ApyIBtoACTApply IBAN Vldt. to Bank AcctVarChar
Y) Yes
N) No
1
N
JeUnGroupJournal Entry Lines UngroupingVarChar
1
N
IgnoreAddeImpresión de documento sin AddendaVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT AADM.CompnyName AS 'Company Name', AADM.CompnyAddr AS 'Address', AADM.Country AS 'Country', AADM.PrintHeadr AS 'Printing Header', AADM.Phone1 AS 'Telephone Number 1', AADM.Phone2 AS 'Telephone Number 2', AADM.Fax AS 'Fax Number', AADM.E_Mail AS 'E-Mail', AADM.Manager AS 'Managing Director', AADM.CompType AS 'Chart of Accounts Template', AADM.MainCurncy AS 'Local Currency', AADM.SysCurrncy AS 'System Currency', AADM.DispPosDeb AS 'Credit Balance with Minus Sign', AADM.DefLengthU AS 'Standard Unit of Length', AADM.DefWeightU AS 'Default Weight UoM', AADM.DfltVendPM AS 'Default Payt Method for Vendor', AADM.DirectRate AS 'Direct/Indirect Rate', AADM.MinAmnt347 AS 'Minimum Amount for 347 Report', AADM.AutoITW AS 'Set Items - Warehouses', AADM.BankCountr AS 'Bank Country', AADM.TaxIdNum AS 'Federal Tax ID', AADM.RevOffice AS 'Tax Office', AADM.FreeZoneNo AS 'Additional ID Number', AADM.DdctFileNo AS 'Deduction File No.', AADM.VatCharge AS 'Tax Collection', AADM.PayOutVat AS 'Tax Definition', AADM.VatPrcnt AS 'Tax Rate', AADM.DpsitPrcnt AS 'Advances on Corp. Income Tax %', AADM.IncomeTax AS 'Withholding Tax %', AADM.VendorDdct AS 'Withholding Tax', AADM.CustmrDdct AS 'Customer's Deduction at Source', AADM.DdctPercnt AS 'Withholding Tax Deduction %', AADM.DdctExpire AS 'Withholding Tax Ded. in % - Ex', AADM.DdctOffice AS 'Withholding Tax Deduction - Of', AADM.EURepSqntl AS 'Sequential Number of EU Sales', AADM.BoxRptSeq AS 'Box Report Sequential Number', AADM.WTLiable AS 'WTax Liable', AADM.DfltCustPM AS 'Default Payt Method for Cust.', AADM.AllowFuPos AS 'Allow Future Posting Date', AADM.UseProdWip AS 'Use Product WIP Account', AADM.CurrPeriod AS 'Current Period', AADM.XmlPath AS 'XML File Path', AADM.DflBnkKey AS 'Default Bank Key', AADM.BSInstled AS 'Bank Statement Installed', AADM.UseShpdGd AS 'Use Shipped Goods Account', AADM.UseExtRpt AS 'Use Extended Reporting (OTRS)', AADM.ERpPerType AS 'Period Type for Generation', AADM.DfSVatExmp AS 'Sales Tax Group for Exempt', AADM.DfPVatExmp AS 'Purchases Tax Group for Exempt', AADM.Manager1 AS 'General Manager', AADM.Manager1F AS 'General Manager (For. Lang.)', AADM.CCMask AS 'Mask Credit Card Number', AADM.ObligLimit AS 'Commitment Restriction', AADM.CreditLimt AS 'Credit Restriction', AADM.SalesLimit AS 'Restrict Sales', AADM.DlnLimit AS 'Restrict Del. Notes (PO)', AADM.OrderLimit AS 'Restrict Orders', AADM.AddDlnBlnc AS 'Consider Deliv - Sales Revenue', AADM.CreditDpst AS 'Credit Deposit Type', AADM.MultiLang AS 'Multi-Language Support Enabled', AADM.DbVers AS 'Database Version', AADM.ApplVers AS 'Application Version', AADM.DflWebSite AS 'Default for Web Site', AADM.DflFTPSite AS 'Default for FTP Site', AADM.UseTax AS 'Use Tax', AADM.RevisionPo AS 'Split Purchase Order', AADM.Reindex AS 'Rebuild Indexes', AADM.DllPath AS 'Path to Validation DLL', AADM.TaxIdValid AS 'Tax ID Mandatory Validation', AADM.PchName AS 'Split Purchase Order', AADM.RpcName AS 'Rebuild Indexes', AADM.PdnName AS 'Free24', AADM.RpdName AS 'Alt Name for Goods Return', AADM.PorName AS 'Alternative Name for Purchase', AADM.LevelWarn AS 'Alert Type for Whse Stock', AADM.CrdCommUse AS 'Set Commission by Customer', AADM.ItmCommUse AS 'Set Commission by Item', AADM.SlpCommUse AS 'Alternative Name for Purchase', AADM.DfCustTerm AS 'Default Pmt Terms for Cust.', AADM.DfVendTerm AS 'Default Vendor Payment Terms', AADM.SaleProfit AS 'Calc. Gross Profit per Trans.', AADM.CostPrcLst AS 'Set Commission by Sales Emp.', AADM.GrossBySal AS 'Gross Profit After Sale', AADM.TreePricOn AS 'Display Price for Parent Only', AADM.AddVat AS 'Calc. Gross Profit per Trans.', AADM.BaseFld AS 'Base Field', AADM.ClosedQuot AS 'Allow Closed Sales Quotations', AADM.UseCode AS 'User Conversion Code', AADM.Code1 AS 'CODE1', AADM.Code2 AS 'CODE2', AADM.Code3 AS 'CODE3', AADM.Code4 AS 'CODE4', AADM.Color AS 'Company Color', AADM.SumDec AS 'Totals Accuracy', AADM.QtyDec AS 'Accuracy of Quantities', AADM.PriceDec AS 'Price Accuracy', AADM.RateDec AS 'Rate Accuracy', AADM.PercentDec AS 'Percentage Rate Accuracy', AADM.MeasureDec AS 'Measuring Accuracy for Units', AADM.DdAutoRun AS 'Price Accuracy', AADM.DdNextDue AS 'Rate Accuracy', AADM.DdHour AS 'Percentage Rate Accuracy', AADM.CmpnyAddrF AS 'Address in Foreign Language', AADM.DflTaxCode AS 'Default Tax Code', AADM.PrintHdrF AS 'Letter Header in Foreign Lang.', AADM.Phone1F AS 'Tel. No. 1 (Foreign Language)', AADM.Phone2F AS 'Tel. No. 2 (Foreign Language)', AADM.FaxF AS 'Fax Number (Foreign Lang.)', AADM.ManagerF AS 'Letter Header in Foreign Lang.', AADM.TimeFormat AS 'Time Template', AADM.CigCup AS 'Cig and Cup Warning', AADM.DateFormat AS 'Date Template', AADM.DateSep AS 'Date Separator', AADM.FcNoBlnc AS 'Foreign Currency Checking Account', AADM.ChangeRdr AS 'Changed Existing Orders', AADM.MultiCurr AS 'Multi-Currency Check', AADM.PickParDlv AS 'Partial Deliv. Pick and Pack', AADM.MaxTaxIncr AS 'Maximum Increase of Tax Amount', AADM.ISRType AS 'ISR Type', AADM.MaxTaxDecr AS 'Maximum Decrease of Tax Amount', AADM.RoundRmrk AS 'Display Rounding Remark', AADM.ISRBillerI AS 'ISR Biller ID', AADM.UpdStamp AS 'Update Stamp', AADM.SysCNoEdit AS 'Block System Currency Editing', AADM.RefDNoEdit AS 'Block Updating of Posting Date', AADM.DfltWhs AS 'Default Warehouse', AADM.TaxDNoEdit AS 'Free', AADM.DfSVatItem AS 'Tax Definition', AADM.DfSVatServ AS 'Tax Definition', AADM.DfPVatItem AS 'Tax Group for Purchase Item', AADM.DfPVatServ AS 'Tax Group for Service Purchase', AADM.DoBudget AS 'Calculate Budget', AADM.CustIdNum AS 'Customer ID', AADM.BgtBlock AS 'Block Budget', AADM.BgtWarning AS 'Budget Alert', AADM.BdgtPORDoc AS 'Block Purchase Orders', AADM.BdgtAcctng AS 'Block Bookkeeping', AADM.BdgtDflt AS 'Default Budget Cost Assmt Mthd', AADM.ContInvnt AS 'Perpetual Inventory Management', AADM.InvntSystm AS 'Perpetual Inventory System', AADM.ApplicIFRS AS 'Application of IFRS', AADM.StartYear AS 'Starting in Fiscal Year', AADM.According AS 'Report According To', AADM.MltpBrnchs AS 'Enable Multiple Branches', AADM.EnblSrvTax AS 'Enable Service Tax', AADM.DftRCN AS 'Default for Retail Chains', AADM.RoundVat AS 'Round Tax Amounts', AADM.BdgtPDNDoc AS 'Block Deliv. Notes for Purch.', AADM.IRSFileNo AS 'File Number in Income Tax', AADM.DeferrTax AS 'Deferred Tax', AADM.DflIntrst AS 'Min. Default Interest Amount', AADM.DfltSlp AS 'Sales Employee', AADM.DflCrCard AS 'Default Credit Card', AADM.DflBnkCode AS 'Default Bank No.', AADM.DflBnkAcct AS 'Default Bank Account', AADM.DflBranch AS 'Default Branch', AADM.UsePaSys AS 'Sales Employee', AADM.Serv_Usr AS 'Service Code', AADM.Serv_Pass AS 'Service Password', AADM.ParamPath AS 'Parameter Folder Path', AADM.ExcelPath AS 'Excel Folder Path', AADM.TaxIdNum2 AS 'Federal Tax ID 2', AADM.TaxIdNum3 AS 'Federal Tax ID 3', AADM.DecSep AS 'Decimal Separator', AADM.ThousSep AS 'Thousands Separator', AADM.CurOnRight AS 'Display Currency on the Right', AADM.WarnByWhs AS 'Alert by Warehouse', AADM.DflBnkAcKy AS 'Default Bank Account No.', AADM.PriceSys AS 'Price System', AADM.DftPVL AS 'Preferred Vendor Credit', AADM.useDdctTrc AS 'WTax Deduction - Hierarchy', AADM.useDocWrf AS 'Doc. Confirmation', AADM.BtchStatus AS 'Default for Batch Status', AADM.OrderBatch AS 'Manage Orders in Batches', AADM.GLMethod AS 'Set G/L Account By', AADM.SetSriUniq AS 'Set Unique Serial No.', AADM.SriUniqFld AS 'Unique Serial No.', AADM.MaxHistory AS 'Max. History', AADM.TaxRateDet AS 'Tax Rate Determination', AADM.RefreshQty AS 'Refresh in Whse Qty in DI', AADM.StockNoBas AS 'Stock No. Base', AADM.MaxCntRows AS 'Allowed Max Rows in Counting', AADM.CentPmtInc AS 'Enable Incom. Centralized Payt', AADM.CentPmtOut AS 'Enable Outg. Centralized Payt', AADM.ChCtrAPAct AS 'Change Def. Recon. A/P Accts', AADM.ChCtrARAct AS 'Change Def. Recon. A/R Accounts', AADM.PACUsrName AS 'PAC User Name', AADM.PACPasswrd AS 'PAC Password', AADM.CaredType AS 'BP Type Code', AADM.PBSNumber AS 'PBS Number', AADM.PBSGroupNo AS 'PBS Group Number', AADM.OrgNumber AS 'Organization Number', AADM.ActSep AS 'Account Segments Separator', AADM.DspBokpWin AS 'Display Bookkeeping Window', AADM.SHandleWT AS 'Withholding Tax', AADM.SDfltWT AS 'Default Withholding Tax Code', AADM.IncresGlAc AS 'G/L Increase Account', AADM.PHandleWT AS 'Withholding Tax', AADM.PDfltWT AS 'Default Withholding Tax Code', AADM.ExWTLiabl AS 'WTax Liable Expense', AADM.EDocSeqNum AS 'Electronic Document Sequence Number', AADM.AllowPostZ AS 'Allow Inb. Pstng W/o a Price', AADM.PostDiffR AS 'Display in Red Greater Than %', AADM.EnableRO AS 'Enable Release Only Snb in Pst', AADM.UalLastDel AS 'Last Delete Date on Table OUAL', AADM.UalKeepDay AS 'Days for keeping data on OUAL', AADM.NegAmount AS 'Use Negative Amounts', AADM.EnbDocOpt AS 'Enable Document Optimization', AADM.HldCode AS 'Free57', AADM.AlphaDoc AS 'Free58', AADM.free62 AS 'Free62', AADM.free63 AS 'Free63', AADM.free64 AS 'Free64', AADM.free65 AS 'Free65', AADM.OrderBlock AS 'Order Block', AADM.RoundMthd AS 'Rounding Method', AADM.AdrsFromWH AS 'Free63', AADM.OrderParty AS 'Ordering Party', AADM.CrtfcateNO AS 'Certificate No.', AADM.ExpireDate AS 'Expiration Date', AADM.NINum AS 'National Insurance No.', AADM.free66 AS 'Free66', AADM.free67 AS 'Free67', AADM.CfwAsnMust AS 'CFW Assignment Mandatory [Y/N]', AADM.CfwInDflt AS 'Incoming Payment Draft CF Item', AADM.CfwOutDflt AS 'Outgoing Payment Dflt CFW Item', AADM.free68 AS 'Free68', AADM.free69 AS 'Free69', AADM.TaxRegime AS 'Tax Regime', AADM.AliasName AS 'Alias Name', AADM.DftJPELine AS 'Default Line For Local Area', AADM.RdrConfrmd AS 'Confirmed Sales Order', AADM.PorConfrmd AS 'Confirmed Purchase Order', AADM.free71 AS 'Free71', AADM.free72 AS 'Free72', AADM.ChfAcc AS 'Chief Accountant', AADM.TaxMethod AS 'Taxation Method', AADM.CEO AS 'CEO', AADM.free73 AS 'Free73', AADM.free74 AS 'Free74', AADM.RndToTDec AS 'Round VAT to Tenths', AADM.SDfltITWT AS 'Default Income Tax WTax Code', AADM.PDfltITWT AS 'Default Income Tax WTax Code', AADM.free75 AS 'Free75', AADM.free76 AS 'Free76', AADM.DfActCurr AS 'Default Account Currency', AADM.defTaxVend AS 'Deferred Tax for Vendors', AADM.free77 AS 'Free77', AADM.free78 AS 'Free78', AADM.free79 AS 'Free79', AADM.free80 AS 'Free80', AADM.free89 AS 'Free89', AADM.AutoVat AS 'Free77', AADM.ConsumeFCT AS 'Consumer Forecast', AADM.ConsumeMtd AS 'Consumption Method', AADM.DaysBack AS 'Days Backward', AADM.DaysFwrd AS 'Days Forward', AADM.IsPAPrn AS 'Panama Printer Connected', AADM.free82 AS 'Free82', AADM.TaxCodeCst AS 'Def. Tax Code (New Customers)', AADM.TaxCodeVnd AS 'Def. Tax Code (New Vendors)', AADM.State AS 'Status', AADM.CharMonth AS 'Number of Characters in Month', AADM.free83 AS 'Free83', AADM.free84 AS 'Free84', AADM.free85 AS 'Free85', AADM.free86 AS 'Free86', AADM.AltBOEPost AS 'Active Alternative BOE Post', AADM.LDiscTotal AS 'Free83', AADM.Code AS 'Code', AADM.DfltDunTrm AS 'Default Dunning Terms', AADM.Profession AS 'Profession', AADM.free88 AS 'Free88', AADM.DfltCDP AS 'Default Closing Date Procedure', AADM.LogInstanc AS 'Log Instance', AADM.UpdateDate AS 'Update Date', AADM.UserSign AS 'User Signature', AADM.DflBCACode AS 'Free88', AADM.IgrAllCash AS 'Ignore All Cash Flow Relevant', AADM.TaxPayerRf AS 'Log Instance', AADM.EmployerRf AS 'Employer's Reference', AADM.PStatAutCh AS 'Period Status Automatic Change', AADM.PStatDelay AS 'Period Status Change Delay', AADM.RepBusType AS 'Reporting Business Type', AADM.RepBusOthr AS 'Unique Taxpayer Ref. (UTR)', AADM.BrachNum AS 'Branch Number', AADM.BuisnesDsc AS 'Business Description', AADM.ReptMethod AS 'Reporting Method', AADM.AcctMethod AS 'Accounting Method', AADM.Bookpitype AS 'Bookkeeping Type', AADM.ActSoftNam AS 'Accounting Software Name', AADM.OpnClsRmrk AS 'Copy Opening/Closing Remarks', AADM.TaxRndRule AS 'Default Tax Rounding Rule', AADM.NegTax AS 'Allow Neg. Tax Amt in Returns', AADM.ZeroLine AS 'Allow Zero Amt Row in JE', AADM.GBOpenFile AS 'Open GBI File After Export', AADM.GBIntface AS 'GBI enabled', AADM.DfltCDPV AS 'Default A/P Closing Date Proc.', AADM.OnHldPert AS 'Capital Goods On Hold Percent.', AADM.WTRndRule AS 'Default WTax Rounding Rule', AADM.GPPrcntSrv AS 'Default GP % in Service Doc.', AADM.DspFrznBP AS 'Display Inactive BPs in Rpt', AADM.DspFrznITM AS 'Display Inactive Items in Rpt', AADM.WTAccumAmt AS 'Accum. Amount for WTax on AP', AADM.NewDPRCus AS 'Hide Dpm Invoice', AADM.ServNature AS 'Service Nature', AADM.PickLimit AS 'Restrict Pick List', AADM.WTAccAmtAR AS 'Accum. Amount for WTax on AR', AADM.UseProdPL AS 'Use Production P&L Accounts', AADM.QueryDec AS 'Calculated Query Accuracy', AADM.ExRtDefTax AS 'Exchange Rate on Deferred Tax', AADM.BoletoPath AS 'Boleto Path', AADM.UserSign2 AS 'Updating User', AADM.MMLastImpD AS 'Last Import File Date', AADM.CpyExhRate AS 'Copy Exchange Rate in Copy To', AADM.MapService AS 'Map Service', AADM.ODWFreq AS 'Open Doc. Refresh Frequency', AADM.GTSOutPath AS 'GTS Outbound Path', AADM.UseMltDims AS 'Use Multidimensions', AADM.MDStyle AS 'Multidimensions Display Style', AADM.GTSInPath AS 'GTS Inbound Path', AADM.GTSSep AS 'GTS Separator', AADM.GTSDftChk AS 'GTS Default Checker', AADM.GTSDftPye AS 'GTS Default Payee', AADM.GTSMaxAmt AS 'GTS Max. Amount', AADM.RspOverAmt AS 'Response to Exceeding Amount', AADM.DRBlock1 AS 'Distribution Rule: Block 1', AADM.DRBlock2 AS 'Distribution Rule: Block 2', AADM.DRBlock3 AS 'Distribution Rule: Block 3', AADM.DRBlock4 AS 'Distribution Rule: Block 4', AADM.DRBlock5 AS 'Distribution Rule: Block 5', AADM.PrjBlock AS 'Project Block', AADM.SimReport AS 'Simulation Report', AADM.SnapShotId AS 'Snapshot ID', AADM.BackOrder AS 'Pick and Pack Back Order', AADM.HQLocation AS 'Headquarters Location', AADM.DigCrtPath AS 'Digital Certificate Path', AADM.DflWTS AS 'Default E-Tax Web Site', AADM.EnbApprDI AS 'Enable DI Approval Procedure', AADM.ChBPSerie AS 'Verify Non-manual BP Series', AADM.ChItmSerie AS 'Verify Non-manual ITM Series', AADM.ETRTaxOffi AS 'ETR Tax Office', AADM.ETRTaxPers AS 'ETR Tax Person Type', AADM.EDocExpFrm AS 'Electronic Doc. Export Format', AADM.PCN874RTyp AS 'PCN874 Report Type', AADM.BTWDecProv AS 'BTW Declaration Provider', AADM.BTWDcPrvID AS 'BTW Declaration Provider ID', AADM.BTWName AS 'BTW Name', AADM.BTWStreet AS 'BTW Street', AADM.BTWCity AS 'BTW City', AADM.BTWZip AS 'BTW ZIP Code', AADM.BTWPhone AS 'BTW Phone Number', AADM.BTWOB AS 'BTW OB ID', AADM.BTWICP AS 'BTW ICL ID', AADM.BTWOBFmt AS 'ETR Telephone Number', AADM.BTWICPFmt AS 'BTW ICP Mapping Format', AADM.ETRPhoneNo AS 'ETR Telephone Number', AADM.EDTestMode AS 'Electronic Document Test Mode', AADM.EDocGenTyp AS 'El. Doc. Default Gen. Type', AADM.EDocRptFmt AS 'El. Document Report Format', AADM.InputMsg AS 'El. Doc. Input Message Format', AADM.EDProcess AS 'Electronic Document Process', AADM.PAC AS 'PAC', AADM.NotifAlert AS 'Notification by Alert', AADM.NotifEmail AS 'Notification by E-Mail', AADM.EDocUDQCat AS 'Free58', AADM.EOutputPth AS 'Free58', AADM.EDelDocFrm AS 'Electronic Delivery Doc. Export Format', AADM.free22 AS 'Free22', AADM.free21 AS 'Free21', AADM.ETRFaxNo AS 'ETR Fax Number', AADM.ETRMgrPhn AS 'ETR Manager's Phone Number', AADM.EDFormat AS 'Electronic Document Format', AADM.AIDFormat AS 'Annual Invoice Decl. Format', AADM.CrtLineRFQ AS 'Create Online Quotation', AADM.DflJET AS 'Default JE Type', AADM.OnlyPaidIn AS 'Display Only Paid Reserve Inv.', AADM.PDDEnabled AS 'Payments Due Date Enabled', AADM.MaxDays4DD AS 'Max. Allowed Range for Due Dte', AADM.AutoAddUoM AS 'Auto. Add UoMs to Items', AADM.AutoAddPkg AS 'Auto. Add Pkgs to Items', AADM.BinActivat AS 'Has Whse Bin Activated [Y/N]', AADM.IssuePriBy AS 'Issue Primarily By SnB or Bin', AADM.InstFixAst AS 'Enable Fixed Assets', AADM.DeprecCalc AS 'Depreciation Calculation', AADM.FixAstMod AS 'Fixed Asset Mode', AADM.SopPath AS 'Solution Packager Exe. Path', AADM.NewAcctDe AS 'New G/L Account Determination', AADM.ClnZeroPln AS 'Clean Zero Price Row in ITM1', AADM.CmdDisBoth AS 'Display Both Related Docs.', AADM.CnclMaxDay AS 'Max. No. of Days For Cancel', AADM.AttachPath AS 'Attachment Path', AADM.ConfigPath AS 'Configuration Path', AADM.WrkshtPath AS 'Worksheet Path', AADM.ICDifExPe1 AS 'Single Count Variance (%)', AADM.ICDifExPe2 AS 'Multiple Count Max. Variance (%)', AADM.ClsZoDiffR AS 'Close Rows Cont. Zero Diff.', AADM.ClsNoConfi AS 'Close Without Confirmation', AADM.DTWPath AS 'DTW Exe. Path', AADM.DfltByEml AS 'Default by E-Mail', AADM.free46 AS 'Free46', AADM.INVOBPrice AS 'Inventory OB Price Zero', AADM.SplitFBSh AS 'Split Fix Balance Sheet [Y/N]', AADM.NotifyRqr AS 'Notify Requester', AADM.DeactivFA AS 'Deactivate Asset When End Life', AADM.CshDctFA AS 'CM for Payment Cash Discount', AADM.SendAlert AS 'Send Internal Message', AADM.BdgtPRQDOC AS 'Block Purchase Request', AADM.IsReuseNum AS 'Enable Document Number Reuse', AADM.IsReuseNFN AS 'Enable Nota Fiscal No. Reuse', AADM.SIPLReport AS 'Show Inactive PL in Reports', AADM.SIPLDoc AS 'Show Inactive PL in Docs', AADM.SIPLSeting AS 'Show Inactive PL in Settings', AADM.PriceProcM AS 'On Change UoM Conversion Rules', AADM.ChkQtyINV AS 'Enable Check Quantity in INV', AADM.EnbAdvATP AS 'Enable Advanced ATP', AADM.EnblCase AS 'Enable Case Sensitivity', AADM.EnbSupplC AS 'Enable Supplementary Code', AADM.MBAOnPer AS 'Allow Multiple BAs for Period', AADM.MBAOnAP AS 'Block Multiple BAs for AP Doc.', AADM.MBAOnAR AS 'Block Multiple BAs for AR Doc.', AADM.ApyBsActSP AS 'Apply Active Special Prices', AADM.ApyBsActPV AS 'Apply Active Period and Volume', AADM.ApyBsActPL AS 'Apply Active Price Lists', AADM.IsUpdNstdB AS 'Update Non-Std Based Prices', AADM.SnBDfltSB AS 'SnB Default Eval. System SB', AADM.OneBOneRec AS 'One Batch One Receipt', AADM.ReptCurrcy AS 'R6111 Report Currency', AADM.ICDifExPe3 AS 'Multiple Count Vldt. Variance (%)', AADM.INCSingToV AS 'Copy Single Counter to Validt.', AADM.POrCByINC AS 'Posting or Create Date by INC', AADM.EnbNegPym AS 'Enable Negative Payment', AADM.SirenNo AS 'Siren Number', AADM.SEPACredID AS 'SEPA Creditor ID', AADM.InstitCode AS 'Institution Code', AADM.ECDFormat AS 'ECD File Format', AADM.ApyDRinPEC AS 'Apply DR in Period End Closing', AADM.ApyPRinPEC AS 'Apply PJ in Period End Closing', AADM.TaxPyerSta AS 'TAX_PAYER_STATUS', AADM.MaxINVRptR AS 'Allowed Rows in INC Trans Rpt', AADM.DftResWhs AS 'Default Resource Warehouse', AADM.AutoResWhs AS 'Auto Add All Warehouses to New Resources', AADM.InActRpt AS 'Inactive Reports', AADM.InActMkt AS 'Inactive Marketing Documents', AADM.InActPln AS 'Inactive Price Lists', AADM.StartFrom AS 'Start From', AADM.Months AS 'Months', AADM.Days AS 'Days', AADM.JEInFATran AS 'Always Create JE in Transfer', AADM.TPLId AS 'UI Template ID', AADM.TxtSrch AS 'Text Search', AADM.ApyIBtoACT AS 'Apply IBAN Vldt. to Bank Acct', AADM.JeUnGroup AS 'Journal Entry Lines Ungrouping', AADM.IgnoreAdde AS 'Impresión de documento sin Addenda' FROM AADM AS AADM

Related information


Legal List Format OLLF SQL Table

Employees OHEM SQL Table

Countries OCRY SQL Table

Bank Charges Allocation Codes OBCA SQL Table

House Bank Accounts DSC1 SQL Table

Bank Codes ODSC SQL Table

JE Document Type OJET SQL Table

Sales Tax Codes OSTC SQL Table

Payment Methods for Payment Wizard OPYM SQL Table

Dunning Terms ODUT SQL Table

Holiday Table OHLD SQL Table

G/L Accounts OACT SQL Table

Map Services OMPS SQL Table

PAC Companies OPAC SQL Table

Withholding Tax OWHT SQL Table

States OCST SQL Table

Customized Template UICU SQL Table

Users OUSR SQL Table



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