SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2/ISDFPS/CHVW_E34External Batch Where-Used List
3FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6AUDLORIPR7KPro: Logical Information Object Attribute Values
7/OPT/Z1344Reporting table: Text table for exception definitions
8FCO_DOC_HEAD61Failure Cost Document Header
9FMIA65Actual Line Item Table for Funds Management
10PEG_TMTNS2Pegging: Movement Types Explicitly Not Supported

B1 9.2: Top 10 requests

2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPOR386Purchase Order
9OACT114G/L Accounts
10OPCH386A/P Invoice

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4OIVL77Whse Journal
5ORCT154Incoming Payment
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool
1Business One8.82AUSR901Archive Users - HistoryAdministration
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT USERID, PASSWORD, PASSWORD1, PASSWORD2, INTERNAL_K, USER_CODE, U_NAME, GROUPS, PASSWORD4, ALLOWENCES, SUPERUSER, DISCOUNT, PASSWORD3, Info1File, Info1Field, Info2File, Info2Field, Info3File, Info3Field, Info4File, Info4Field, dType, E_Mail, PortNum, OutOfOffic, SendEMail, SendSMS, DfltsGroup, CashLimit, MaxCashSum, Fax, SendFax, Locked, Department, Branch, UserPrefs, Language, Charset, OpenCdt, CdtPrvDays, DsplyRates, AuImpRates, OpenDps, RcrFlag, CheckFiles, OpenCredit, CreditDay1, CreditDay2, WallPaper, WllPprDsp, AdvImagePr, ContactLog, LastWarned, AlertPolFr, ScreenLock, ShowNewMsg, Picture, Position, Address, Country, Tel1, Tel2, GENDER, Birthday, EnbMenuFlt, objType, logInstanc, userSign, createDate, userSign2, updateDate, OneLogPwd, lastLogin, LastPwds, LastPwds2, LastPwdSet, FailedLog, PwdNeverEx, SalesDisc, PurchDisc, LstLogoutD, LstLoginT, LstLogoutT, LstPwdChT, LstPwdChB, RclFlag, MobileUser, MobileIMEI, PrsWkCntEb, SnapShotId FROM AUSR
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1USERIDUser Signatureint60 Allow NULL? 
2PASSWORDUser Passwordnvarchar25400 Allow NULL? 
3PASSWORD1User Passwordnvarchar80 Allow NULL? 
4PASSWORD2User Passwordnvarchar80 Allow NULL? 
5INTERNAL_KInternal Numberint60 Allow NULL? 
6USER_CODEUser Codenvarchar80 Allow NULL? 
7U_NAMEUser Namenvarchar1550 Allow NULL? 
8GROUPSUser Groupint600 Allow NULL? 
9PASSWORD4Passwordnvarchar2540 Allow NULL? 
10ALLOWENCESUser Confirmationtext160
11SUPERUSERSuperuserchar10NN, Y Allow NULL? 
12DISCOUNTMax. Discountnum196 Allow NULL? 
13PASSWORD3User Passwordnvarchar80 Allow NULL? 
14Info1FileInfo1Filenvarchar40 Allow NULL? 
15Info1FieldInfo1Fieldint60 Allow NULL? 
16Info2FileInfo2Filenvarchar40 Allow NULL? 
17Info2FieldInfo2Fieldint60 Allow NULL? 
18Info3FileInfo3Filenvarchar40 Allow NULL? 
19Info3FieldInfo3Fieldint60 Allow NULL? 
20Info4FileInfo4Filenvarchar40 Allow NULL? 
21Info4FieldInfo4Fieldint60 Allow NULL? 
22dTypedTypechar10HH, N, X, Y Allow NULL? 
23E_MailE-Mailnvarchar1000 Allow NULL? 
24PortNumMobile Phone Numbernvarchar500 Allow NULL? 
25OutOfOfficOut of the Officechar10NN, Y Allow NULL? 
26SendEMailSend E-Mailchar10NN, Y Allow NULL? 
27SendSMSSend SMSchar10NN, Y Allow NULL? 
28DfltsGroupDefaultnvarchar80OUDG Allow NULL? 
29CashLimitCash Amount Limitchar10NN, Y Allow NULL? 
30MaxCashSumMax. Cash Totalnum196 Allow NULL? 
31FaxFax Numbernvarchar200 Allow NULL? 
32SendFaxSend Faxchar10NN, Y Allow NULL? 
33LockedUser Confirmationchar10NN, Y Allow NULL? 
34DepartmentDepartmentint60OUDP-2 Allow NULL? 
35BranchBranchint60OUBR-2 Allow NULL? 
36UserPrefsUser Preferencestext160
37LanguageLanguageint60 Allow NULL? 
38CharsetFont Languageint60 Allow NULL? 
39OpenCdtOpen Window for Credit Vouchers Ref. Updatechar10NN, Y Allow NULL? 
40CdtPrvDaysVouchers from Last Daysint1101 Allow NULL? 
41DsplyRatesDisplay Rates Table on Startupchar10NN, Y Allow NULL? 
42AuImpRatesImport Currency Exchange Rates Automaticallychar10NN, Y Allow NULL? 
43OpenDpsOpen Postdated Checks Windowchar10NN, Y Allow NULL? 
44RcrFlagDisplay Scheduled Recurring Postingschar10NN, Y Allow NULL? 
45CheckFilesPerform Data Checkchar10NN, Y Allow NULL? 
46OpenCreditOpen Window for Postdated Credit Voucherschar10ND, N, Y Allow NULL? 
47CreditDay1Handle Postdated Credit Day 1int601 Allow NULL? 
48CreditDay2Handle Postdated Credit Day 2int6015 Allow NULL? 
50WllPprDspWallpaper Displayint6011, 2, 3 Allow NULL? 
51AdvImagePrExtended Image Processingchar10NN, O, Y Allow NULL? 
52ContactLogToday's Activity Alertchar10NN, Y Allow NULL? 
53LastWarnedLast Warned Datedate80
54AlertPolFrMessage Check Frequency (Min.)int605 Allow NULL? 
55ScreenLockScreen Lock Delayint6030 Allow NULL? 
56ShowNewMsgDisplay Message/Alert on Arrivalchar10YN, Y Allow NULL? 
57PicturePicturenvarchar2000 Allow NULL? 
58PositionPositionnvarchar900 Allow NULL? 
59AddressAddressnvarchar1000 Allow NULL? 
60CountryCountrynvarchar30OCRY Allow NULL? 
61Tel1Telephone 1nvarchar200 Allow NULL? 
62Tel2Telephone 2nvarchar200 Allow NULL? 
63GENDERGenderchar10FF, M Allow NULL? 
64BirthdayDate of Birthdate80
65EnbMenuFltEnable Forbidden Menu Itemschar10NN, Y Allow NULL? 
66objTypeObject Typenvarchar20012 Allow NULL? 
67logInstancLog Instanceint60 Allow NULL? 
68userSignCreating Userint60OUSR Allow NULL? 
69createDateCreation Datedate80
70userSign2Updating Userint60OUSR Allow NULL? 
71updateDateUpdate Datedate80
72OneLogPwdAt first logon change passwordchar10NN, Y Allow NULL? 
73lastLoginLast Logon Datedate80
74LastPwdsLast Passwords 1nvarchar25400 Allow NULL? 
75LastPwds2Last Passwords 2nvarchar25400 Allow NULL? 
76LastPwdSetLast Password Changedate80
77FailedLogFailed Login Countint1100 Allow NULL? 
78PwdNeverExPassword Never Expireschar10NN, Y Allow NULL? 
79SalesDiscMax. Sales Discountnum196 Allow NULL? 
80PurchDiscMax. Purchase Discountnum196 Allow NULL? 
81LstLogoutDLast Logoff Datedate80
82LstLoginTLast Logon Timeint110 Allow NULL? 
83LstLogoutTLast Logoff Timeint110 Allow NULL? 
84LstPwdChTLast Password Change Timeint110 Allow NULL? 
85LstPwdChBLast Password Changed Bynvarchar80 Allow NULL? 
86RclFlagDisplay Recurring Transactionschar10N, Y Allow NULL? 
87MobileUserMobile Userchar10NN, Y Allow NULL? 
88MobileIMEIMobile IMEInvarchar640 Allow NULL? 
89PrsWkCntEbPersonal Work Center Enablechar10NN, Y Allow NULL? 
90SnapShotIdSnapshot IDint1100 Allow NULL?