AADM - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL

Administration /

Administration - Log

DTW Administration / Setup / Banking / House Bank Accounts

API AADM

AADM - Administration - Log Table

SBO SQL database table details

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

OLLF SQL Table

OHEM SQL Table

OCRY SQL Table

OBCA SQL Table

DSC1 SQL Table

ODSC SQL Table

OJET SQL Table

OSTC SQL Table

OPYM SQL Table

ODUT SQL Table

OHLD SQL Table

OACT SQL Table

OMPS SQL Table

OPAC SQL Table

OWHT SQL Table

OCST SQL Table

UICU SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

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