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 One9.3ITMR1025ITMRGeneral
SQL:  selectupdate insert create

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

SELECT DocCode, ItemId, Container, Type, VISIBLE, SupZeros, ItemLeft, ItemTop, Width, Height, LMargin, RMargin, TMargin, BMargin, LeftLine, RightLine, TopLine, BottomLine, Shadow, BGRed, BGGreen, BGBlue, FGRed, FGGreen, FGBlue, MrkrRed, MrkrGreen, MrkrBlue, BrdrRed, BrdrGreen, BrdrBlue, FromPane, ToPane, ItemGroup, FontName, FontSize, TextStyle, Justific, WRAP, PictSize, DataSource, ItemStr, VarNum, FileName, FieldNum, ShowDescr, CalcType, ChangFlags, ApplID, CalcCol, YJustific, SortLevel, RevOrder, SortType, IsUnique, IsGroup, NewPage, BarCode, Condition, LinkTo, Operator1, Operator2, Operation, BCStandard, SumInWords, ExcFonting, StrIndex, ContIndex, ItemIndex, StrLength, StrFiller, RelatedTo, NextSeg, HightAdjst, DupRpttAre, LnsRpttAre, RptDupDist, ItemDesc, ExportXml, DocType, Local, Numerator, Language, Created, Updated, UsrSgnStr, UsrSgnAttr, IsRef, FieldId, FGEnabled, BGEnabled, MKEnabled, BDEnabled, HidEmpRptt, RpttFtrAll, GbiDataTyp, GbiDataLen, PageBreak, IsLogo, VarDefName, ResCode, RevCode FROM ITMR


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1DocCodeReportnvarchar80 Allow NULL? 
2ItemIdItem IDint60 Allow NULL? 
3ContainerParent Typeint60 Allow NULL? 
4TypeTypeint6010=Text field, 11=Picture field, 12=User field, 1=Page header, 2=Start of report, 3=Repetitive area header, 4=Repetitive area, 5=Repetitive area footer, 6=End of report, 7=Page footer Allow NULL? 
5VISIBLEVisiblechar1010=No, 1=Yes Allow NULL? 
6SupZerosSuppress Zeroschar1000=No, 1=Yes Allow NULL? 
7ItemLeftLeft Itemint60 Allow NULL? 
8ItemTopTopint60 Allow NULL? 
9WidthWidthint60 Allow NULL? 
10HeightHeightint60 Allow NULL? 
11LMarginLeft Marginint600 Allow NULL? 
12RMarginRight Marginint600 Allow NULL? 
13TMarginTop Marginint600 Allow NULL? 
14BMarginBottom Marginint600 Allow NULL? 
15LeftLineLeft Border Line Thicknessint600 Allow NULL? 
16RightLineRight Border Line Thicknessint600 Allow NULL? 
17TopLineTop Border Line Thicknessint600 Allow NULL? 
18BottomLineBottom Border Line Thicknessint600 Allow NULL? 
19ShadowShadow Thicknessint600 Allow NULL? 
20BGRedBackground - Redint11065535 Allow NULL? 
21BGGreenBackground - Greenint11065535 Allow NULL? 
22BGBlueBackground - Blueint11065535 Allow NULL? 
23FGRedText - Redint1100 Allow NULL? 
24FGGreenText - Greenint1100 Allow NULL? 
25FGBlueText - Blueint1100 Allow NULL? 
26MrkrRedBold - Redint11065535 Allow NULL? 
27MrkrGreenBold - Greenint11065535 Allow NULL? 
28MrkrBlueBold - Blueint11065535 Allow NULL? 
29BrdrRedBorder - Redint1100 Allow NULL? 
30BrdrGreenBorder - Greenint1100 Allow NULL? 
31BrdrBlueBorder - Blueint1100 Allow NULL? 
32FromPaneFrom Areaint600 Allow NULL? 
33ToPaneTo Areaint600 Allow NULL? 
34ItemGroupGroup No.int600 Allow NULL? 
35FontNameFont Namenvarchar500Arial Allow NULL? 
36FontSizeFont Sizeint6012 Allow NULL? 
37TextStyleText Styleint110 Allow NULL? 
38JustificHorizontal Justificationchar1021=Right, 2=Left, 3=Center, 4=Language Dependent Allow NULL? 
39WRAPSegmentchar1010=Allow overflow, 1=Fit to cell, 2=Devide to lines Allow NULL? 
40PictSizePicture Sizechar1010=Original size, 1=Size of box, 2=Adjust to box, 3=Adjust to box height, 4=Adjust to box width Allow NULL? 
41DataSourceData Sourcechar1011=Static, 2=Var, 3=Data, 4=Calculation Allow NULL? 
43VarNumVariable No.int60 Allow NULL? 
44FileNameFile Namenvarchar200 Allow NULL? 
45FieldNumField No.nvarchar100 Allow NULL? 
46ShowDescrDisplay Descriptionchar1000=No, 1=Yes Allow NULL? 
47CalcTypeCalculation Typenvarchar201-1=[new formula String], 0=Formula, 10=Continue, 11=Continued on next page, 12=Generation message, 13=Column summary for page, 14=Column average for page, 15=Column summary for report, 16=Column average for report, 17=Total Pages, 1=Page number, 2=Date, 3=Time, 4=Column total, 5=Column average, 6=General row no., 7=Group row no., 8=Sort fi Allow NULL? 
48ChangFlagsChangeableint110 Allow NULL? 
49ApplIDItem No.int60 Allow NULL? 
50CalcColCalculation Columnint60 Allow NULL? 
51YJustificVertical Alignmentchar1031=Top, 2=Bottom, 3=Center Allow NULL? 
52SortLevelSort Levelint600 Allow NULL? 
53RevOrderReverse Sortchar1000=Ascending, 1=Descending Allow NULL? 
54SortTypeSort Typechar1000=Alpha, 1=Numeric, 2=Money, 3=Date Allow NULL? 
55IsUniqueUniquechar1000=No, 1=Yes Allow NULL? 
56IsGroupSet as Groupchar1000=No, 1=Yes Allow NULL? 
57NewPageNew Pagechar1000=No, 1=Yes Allow NULL? 
58BarCodePrint as Barcodechar1000=No, 1=Yes Allow NULL? 
60LinkToLink to Itemint600 Allow NULL? 
61Operator1Operator 1int60 Allow NULL? 
62Operator2Operator 2int60 Allow NULL? 
63OperationOperationint6000, 10=Less, 11=LessEq, 12=Equally, 13=Not eq, 14=GrEq, 15=Greater, 16=$Len, 17=Left, 18=Right, 19=Round, 1=+, 20=$Currency, 21=$Number, 2=-, 3=x, 4=/, 5=%, 6=$Concat, 7=$Right, 8=$Left, 9=$Sentence Allow NULL? 
64BCStandardBarcode Standardint6000=EAN-13, 1=Code 39, 2=Code 128 Allow NULL? 
65SumInWordsDisplay Total as a Wordchar1000=No, 1=Yes Allow NULL? 
66ExcFontingBlock Font Changechar1000=No, 1=Yes Allow NULL? 
67StrIndexString Indexint1100 Allow NULL? 
68ContIndexContainer Indexint600 Allow NULL? 
69ItemIndexItem Indexint600 Allow NULL? 
70StrLengthString Lengthint60 Allow NULL? 
71StrFillerString Fillerchar10 Allow NULL? 
72RelatedToRelated to Itemint600 Allow NULL? 
73NextSegNext Segment Item Numint600 Allow NULL? 
74HightAdjstHeight Adjustmentschar10NN=No, Y=Yes Allow NULL? 
75DupRpttAreDuplicate Repeatative Areachar10NN=No, Y=Yes Allow NULL? 
76LnsRpttAreNum Lines In Repeatative Areaint1100 Allow NULL? 
77RptDupDistDistanse To Rptt Dup (pixels)int1100 Allow NULL? 
78ItemDescItem Descriptionnvarchar500 Allow NULL? 
79ExportXmlExport to xmlchar10YN=No, Y=Yes Allow NULL? 
80DocTypeDocument Typenvarchar40 Allow NULL? 
81LocalLocalizationnvarchar20 Allow NULL? 
82NumeratorNumeratorint60 Allow NULL? 
83LanguageLanguageint60 Allow NULL? 
84CreatedCreation Datedate80
85UpdatedUpdated Datedate80
86UsrSgnStrUser Sign For Strings Changeint110-1 Allow NULL? 
87UsrSgnAttrUser Sign For Attribs Changeint110-1 Allow NULL? 
88IsRefIs the item refered by anotherchar10NN=No, Y=Yes Allow NULL? 
89FieldIdField Identifiernvarchar200 Allow NULL? 
90FGEnabledGrid Enabledchar10YN=No, Y=Yes Allow NULL? 
91BGEnabledBackground Enabledchar10YN=No, Y=Yes Allow NULL? 
92MKEnabledHighlight Enabledchar10YN=No, Y=Yes Allow NULL? 
93BDEnabledFrame Enabledchar10YN=No, Y=Yes Allow NULL? 
94HidEmpRpttHide Empty Areachar10NN=No, Y=Yes Allow NULL? 
95RpttFtrAllDisplay Rep. Footer on Allchar10NN=No, Y=Yes Allow NULL? 
96GbiDataTypData Typeint6000, 1=C n, 2=C.. n, 3=I.. n, 4=D w.d Allow NULL? 
97GbiDataLenData Lengthnvarchar60 Allow NULL? 
98PageBreakPage Breakint6000=None, 1=Before Area, 2=After Area Allow NULL? 
99IsLogoIs Logochar10NN=No, Y=Yes Allow NULL? 
100VarDefNameVariable Definition Namenvarchar500 Allow NULL? 
101ResCodeResource Code from RSBDint110-1 Allow NULL? 
102RevCodeRevision Codeint110-1 Allow NULL? 


PRIMARYNoYesDocType, Local, Numerator, Language, ApplID, ResCode, RevCode
TP_LC_NM_LNoNoDocType, Local, Numerator, Language
TYP_LOC_NMNoNoDocType, Local, Numerator
TYPE_LOCNoNoDocType, Local