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
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
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.82OPEX971Payment Results TableBanking
SQL:  selectupdate insert create

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

SELECT AbsEntry, PayRunDate, VendorNum, CustNum, PaymMethod, PaymDocNum, FiscalYear, Country, CompTaxNum, PayeeName, PayeeZip, PayeeCity, PayeeStree, PayCountry, PayeeState, PayBnkName, PayBankZip, PayBnkCity, PayBnkStr, PayBnkCntr, PayBankAct, PayBnkCode, PayBnkCtrl, PayBnkSwif, PayBnkIBAN, PymPostDat, PymBnkAcct, PymBnkCntr, PymBnkCode, PymBnkIBAN, PymGLAcct, Currency, PymDocAmnt, PymDocCurr, PymDcAmtFC, PymCshDsct, PyCshDscFC, PymNumOfPa, PymDocRate, Status, PaymWizCod, InstrucKey, CllctAutho, PayBnkPost, PayBnkChNo, PayBnkHsBk, PayBnkBlck, PayBnkCnty, PayBnkStat, PayBnkBISR, PayBnkUsr1, PayBnkUsr2, PayBnkUsr3, PayBnkUsr4, PaymFormat, CompName, CompAddres, CompISRBil, VendISRBil, AddIdNum, CompOrgNum, PayBnkBrnc, PymBnkBrnc, UserName, UserEmail, UserPortNo, UserFax, Department, DebitMemo, EuInTrnsfr, FilePath, OrderParty, PymCtrlKey, PayeeTaxNo, PymKeyCode, PayRefDtls, FormatName, CheckPmnt, PymBnkUsr1, PymBnkUsr2, PymBnkUsr3, PymBnkUsr4, CompStreet, CompBlock, CompCity, CompZip, CompCounty, CompState, PymBCACode, PaymDocTyp, PayOrderNo, FreeText1, FreeText2, FreeText3, PymBnkSwif, PayBnkUIC, LineType FROM OPEX
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1AbsEntryInternal Numberint110 Allow NULL? 
2PayRunDateDate of Payment Rundate80
3VendorNumVendor Codenvarchar150 Allow NULL? 
4CustNumCustomer Codenvarchar150 Allow NULL? 
5PaymMethodPayment Meansnvarchar150 Allow NULL? 
6PaymDocNumPayment Document No.int110 Allow NULL? 
7FiscalYearFiscal Yeardate80
8CountryCompany Countrynvarchar30 Allow NULL? 
9CompTaxNumCompany Tax Numbernvarchar320 Allow NULL? 
10PayeeNamePayee Namenvarchar1000 Allow NULL? 
11PayeeZipPayee Zip Codenvarchar200 Allow NULL? 
12PayeeCityPayee Citynvarchar1000 Allow NULL? 
13PayeeStreePayee Streetnvarchar1000 Allow NULL? 
14PayCountryPayee Countrynvarchar30 Allow NULL? 
15PayeeStatePayee Statenvarchar30 Allow NULL? 
16PayBnkNamePayee Bank Namenvarchar2500 Allow NULL? 
17PayBankZipPayee Bank Zip Codenvarchar200 Allow NULL? 
18PayBnkCityPayee Bank Citynvarchar1000 Allow NULL? 
19PayBnkStrPayee Bank Streetnvarchar1000 Allow NULL? 
20PayBnkCntrPayee Bank Countrynvarchar30 Allow NULL? 
21PayBankActPayee Bank Accountnvarchar500 Allow NULL? 
22PayBnkCodePayee Bank Codenvarchar300 Allow NULL? 
23PayBnkCtrlPayee Bank Control Numbernvarchar20 Allow NULL? 
24PayBnkSwifPayee Bank BIC/SWIFT Codenvarchar500 Allow NULL? 
25PayBnkIBANPayee Bank IBANnvarchar500 Allow NULL? 
26PymPostDatPayment Posting Datedate80
27PymBnkAcctPayment Bank Accountnvarchar500 Allow NULL? 
28PymBnkCntrPayment Bank Countrynvarchar30 Allow NULL? 
29PymBnkCodePayment Bank Codenvarchar300 Allow NULL? 
30PymBnkIBANPayment Bank IBANnvarchar500 Allow NULL? 
31PymGLAcctPayment G/L Accountnvarchar150 Allow NULL? 
32CurrencyMain Currencynvarchar30 Allow NULL? 
33PymDocAmntPayment Document Amount (LC)num196 Allow NULL? 
34PymDocCurrPayment Document Currencynvarchar30 Allow NULL? 
35PymDcAmtFCPayment Document Amount (FC)num196 Allow NULL? 
36PymCshDsctCash Discount in Payment Docnum196 Allow NULL? 
37PyCshDscFCCash Discount in Payment Docnum196 Allow NULL? 
38PymNumOfPaNumber of Items Paidint110 Allow NULL? 
39PymDocRatePayment Document Exchange Ratenum196 Allow NULL? 
40StatusStatuschar10OC, O Allow NULL? 
41PaymWizCodPayment Wizard Codeint110OPWZ Allow NULL? 
42InstrucKeyInstruction Keynvarchar300 Allow NULL? 
43CllctAuthoCollection Authorizationchar10 Allow NULL? 
44PayBnkPostPayee Bank Post Officechar10 Allow NULL? 
45PayBnkChNoPayee Bank Next Check No.int110 Allow NULL? 
46PayBnkHsBkPayee Bank House Bankchar10NN, Y Allow NULL? 
47PayBnkBlckPayee Bank Blocknvarchar1000 Allow NULL? 
48PayBnkCntyPayee Bank Countynvarchar1000 Allow NULL? 
49PayBnkStatPayee Bank Statenvarchar30 Allow NULL? 
50PayBnkBISRPayee Bank BISRchar10NN, Y Allow NULL? 
51PayBnkUsr1Payee Bank User No. 1nvarchar250 Allow NULL? 
52PayBnkUsr2Payee Bank User No. 2nvarchar250 Allow NULL? 
53PayBnkUsr3Payee Bank User No. 3nvarchar250 Allow NULL? 
54PayBnkUsr4Payee Bank User No. 4nvarchar250 Allow NULL? 
55PaymFormatPayment Formatnvarchar200 Allow NULL? 
56CompNameCompany Namenvarchar1000 Allow NULL? 
57CompAddresCompany Addressnvarchar2540 Allow NULL? 
58CompISRBilCompany ISR Biller IDnvarchar90 Allow NULL? 
59VendISRBilVendor ISR Biller IDnvarchar90 Allow NULL? 
60AddIdNumAdditional ID No.nvarchar320 Allow NULL? 
61CompOrgNumCompany Organization No.nvarchar500 Allow NULL? 
62PayBnkBrncPayee Bank Branchnvarchar500 Allow NULL? 
63PymBnkBrncPayment Bank Branchnvarchar500 Allow NULL? 
64UserNameUser Namenvarchar1550 Allow NULL? 
65UserEmailUser E-Mailnvarchar1000 Allow NULL? 
66UserPortNoUser Mobile Phone No.nvarchar500 Allow NULL? 
67UserFaxUser Fax No.nvarchar200 Allow NULL? 
68DepartmentUser Departmentint60 Allow NULL? 
69DebitMemoDebit Memochar10NN, Y Allow NULL? 
70EuInTrnsfrEU Internal Transferchar10NN, Y Allow NULL? 
71FilePathFile Pathtext160
72OrderPartyOrdering Partynvarchar300 Allow NULL? 
73PymCtrlKeyPayment Bank Control Numbernvarchar20 Allow NULL? 
74PayeeTaxNoPayee Tax Numbernvarchar320 Allow NULL? 
75PymKeyCodePayment Key Codenvarchar60 Allow NULL? 
76PayRefDtlsPayee Reference Detailsnvarchar200 Allow NULL? 
77FormatNameFormat Namenvarchar1000 Allow NULL? 
78CheckPmntPayment Done with Checkchar10NN, Y Allow NULL? 
79PymBnkUsr1Payment Bank User No. 1nvarchar250 Allow NULL? 
80PymBnkUsr2Payment Bank User No. 2nvarchar250 Allow NULL? 
81PymBnkUsr3Payment Bank User No. 3nvarchar250 Allow NULL? 
82PymBnkUsr4Payment Bank User No. 4nvarchar250 Allow NULL? 
83CompStreetCompany Streetnvarchar1000 Allow NULL? 
84CompBlockCompany Blocknvarchar1000 Allow NULL? 
85CompCityCompany Citynvarchar1000 Allow NULL? 
86CompZipCompany Zip Codenvarchar200 Allow NULL? 
87CompCountyCompany Countynvarchar1000 Allow NULL? 
88CompStateCompany Statenvarchar30OCST Allow NULL? 
89PymBCACodePayment Bank Chargesnvarchar30OBCA Allow NULL? 
90PaymDocTypPayment Document Object Typenvarchar200 Allow NULL? 
91PayOrderNoPayment Order Numberint110OIPO Allow NULL? 
92FreeText1Free Text 1nvarchar1000 Allow NULL? 
93FreeText2Free Text 2nvarchar1000 Allow NULL? 
94FreeText3Free Text 3nvarchar1000 Allow NULL? 
95PymBnkSwifPayment Bank Swift Codenvarchar500 Allow NULL? 
96PayBnkUICPayee Bank UIC Codenvarchar30 Allow NULL? 
97LineTypeLine Typechar10GG, O, T Allow NULL?