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

1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10BSEG345Accounting Document Segment

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
1Business One9.3OPEX1391Payment 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, BoeKey, BoeCurrSta, BoeDate, BoeDueDate, Instruct1, Instruct2, BoeCancIns, BoeOccCode, BoePtfID, BoeOurNum, BoeIntrAm, BoeDiscD, BoeDisAmnt, BoeFineD, BoeFineAmt, BoeIntrstD, BoeIOFAmt, BoeMovCode, BarcodeRep, PONumber, POSeries, PaPriority, PaymType, RecipStatu, BudegetId, OKATO, PymReason, PostPeriod, BaseDocTyp, BaseDocDat, TaxPymType, OKTMO, SeqType, PymDate, PymBnkName, UIPCode, UserId, SpltPmtVAT, EnBnkAct, EnBnkIBan, EncryptIV, DPPStatus 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=Closed, O=Open 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=No, Y=Yes Allow NULL? 
47PayBnkBlckPayee Bank Blocknvarchar1000 Allow NULL? 
48PayBnkCntyPayee Bank Countynvarchar1000 Allow NULL? 
49PayBnkStatPayee Bank Statenvarchar30 Allow NULL? 
50PayBnkBISRPayee Bank BISRchar10NN=No, Y=Yes 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=No, Y=Yes Allow NULL? 
70EuInTrnsfrEU Internal Transferchar10NN=No, Y=Yes 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=No, Y=Yes 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=General, O=Pay on Account, T=Pay to Account Allow NULL? 
98BoeKeyBill of Exchange Keyint110OBOE Allow NULL? 
99BoeCurrStaBoE Current Statuschar10 Allow NULL? 
100BoeDateBill of Exchange Datedate80
101BoeDueDateBoE Due Datedate80
102Instruct1BoE Instruction 1nvarchar20 Allow NULL? 
103Instruct2BoE Instruction 2nvarchar20 Allow NULL? 
104BoeCancInsBoE Cancel Instructionnvarchar20 Allow NULL? 
105BoeOccCodeBoE Occurrence Codenvarchar20 Allow NULL? 
106BoePtfIDBoE Internal Portfolio IDnvarchar30 Allow NULL? 
107BoeOurNumOur Number in Next BoEint110 Allow NULL? 
108BoeIntrAmBoE Interest Amountnum196 Allow NULL? 
109BoeDiscDBoE Discount Datedate80
110BoeDisAmntBoE Discount Amountnum196 Allow NULL? 
111BoeFineDBoE Fine Datedate80
112BoeFineAmtBoE Fine Amountnum196 Allow NULL? 
113BoeIntrstDBoE Interest Datedate80
114BoeIOFAmtBoE IOF Amountnum196 Allow NULL? 
115BoeMovCodeBoE Movement Codenvarchar100 Allow NULL? 
116BarcodeRepBarcode Representationnvarchar1000 Allow NULL? 
117PONumberExternal Payment Order Numberint110 Allow NULL? 
118POSeriesExternal Payment Order Seriesint110 Allow NULL? 
119PaPriorityPayment Prioritychar1061, 2, 3, 4, 5, 6 Allow NULL? 
120PaymTypePayment Typechar10NE=Electronic, N, P=Mail, T=Telegraph, X=Express Allow NULL? 
121RecipStatuRecipient Statusnvarchar20 Allow NULL? 
122BudegetIdVAT Budget Classification Codenvarchar1000 Allow NULL? 
123OKATOOKATOnvarchar110 Allow NULL? 
124PymReasonPayment Reasonnvarchar20 Allow NULL? 
125PostPeriodPosting Period Codenvarchar100 Allow NULL? 
126BaseDocTypBase Document Typenvarchar20 Allow NULL? 
127BaseDocDatBase Document Datedate80
128TaxPymTypeTax Payment Typenvarchar20 Allow NULL? 
129OKTMOOKTMOnvarchar120 Allow NULL? 
130SeqTypeSequence Typenvarchar40FNAL=FNAL, FRST=FRST, OOFF=OOFF, RCUR=RCUR Allow NULL? 
131PymDatePayment Datedate80
132PymBnkNamePayment Bank Namenvarchar2500 Allow NULL? 
133UIPCodeUIP Codenvarchar250 Allow NULL? 
134UserIdUser IDint60OUSR Allow NULL? 
135SpltPmtVATSplit Paymentchar10NN=No, Y=Yes Allow NULL? 
136EnBnkActEncryption of Payee Bank Accttext160
137EnBnkIBanEncryption of Payee Bank IBANtext160
138EncryptIVEncrypt IVnvarchar1000 Allow NULL? 
139DPPStatusData Protection Statuschar10ND=Erased, N=None Allow NULL?