VBNXT.rocksmodel browser

This is a browser tool for the Visma Business Model. You can paste a SQL query from Visma Business and it will show you the tables and columns used in the query.Try the AI GraphQL Assistant

Tip: Use the copy button to copy the GraphQL query to your clipboard. Hold shift or ctrl to alias all columns to the SQL name.Fields with enum or flag values are marked with a flag icon. Click the icon to see the values. For flag values you can select the values to calculate the flag value.

Tables

Structure Copy column names to clipboard. Hold shift or ctrl to copy with sql name as alias.

Struct (119)

ProductNoStruct.ProdNo (2694)
LineNoStruct.LnNo (2695)
SubProductNoStruct.SubProd (2696)
OverriddenDescriptionStruct.Descr (2697)
IdStruct.ID (2698)
QuantityPerStructureStruct.NoPerStr (2699)
FontNameStruct.FFm (3675) System field. Not retrieveable.
FontSizeStruct.FSz (3676)
FontStyleStruct.FSt (3677) System field. Not retrieveable.
LineFlagsStruct.LnFl (3678) System field. Not retrieveable.
SortSequenceNoStruct.Srt (2701) System field. Not writeable.
ChangedDateStruct.ChDt (2702) System field. Not writeable.
ChangedTimeStruct.ChTm (2703) System field. Not writeable.
ChangedByUserStruct.ChUsr (2704) System field. Not writeable.
EditStatusStruct.LckSt (2705) System field. Not writeable.
LockedByProcessNoStruct.ChPrc (2706) System field. Not writeable.
ChecksumStruct.ChSm (2708) System field. Not retrieveable.
ProcessingMethod2Struct.PrM2 (4949)
ProductType1Struct.ProdTp1 (6109) TxtTp 19
ProductType2Struct.ProdTp2 (6110) TxtTp 58
ProductType3Struct.ProdTp3 (6111) TxtTp 112
ProductType4Struct.ProdTp4 (6112) TxtTp 113
TransactionInformation1Struct.TrInf1 (6115)
TransactionInformation2Struct.TrInf2 (6116)
StructureWeightStruct.StrWgt (6400)
ProcessingMethod1Struct.PrM1 (6549)
ProcessingMethod3Struct.PrM3 (6550)
ProcessingMethod4Struct.PrM4 (6560)
ProcessingMethod5Struct.PrM5 (6561)
RawMaterial (16450)
TransactionInformation3Struct.TrInf3 (7080)
TransactionInformation4Struct.TrInf4 (7081)
Free1Struct.Free1 (11265)
Free2Struct.Free2 (11266)
Free3Struct.Free3 (11267)
Free4Struct.Free4 (11268)
OrgUnit1Struct.R1 (11269)
OrgUnit2Struct.R2 (11270)
OrgUnit3Struct.R3 (11271)
OrgUnit4Struct.R4 (11272)
OrgUnit5Struct.R5 (11273)
OrgUnit6Struct.R6 (11274)
OrgUnit7Struct.R7 (11275)
OrgUnit8Struct.R8 (11276)
OrgUnit9Struct.R9 (11277)
OrgUnit10Struct.R10 (11278)
OrgUnit11Struct.R11 (11279)
OrgUnit12Struct.R12 (11280)
FromDateStruct.FrDt (12803)
FromWeek (12804)
ToDateStruct.ToDt (12805)
ToWeek (12806)
Information1Struct.Inf (12807)
Information2Struct.Inf2 (12808)
Information3Struct.Inf3 (12809)
Information4Struct.Inf4 (12810)
Information5Struct.Inf5 (12811)
Information6Struct.Inf6 (12812)
Information7Struct.Inf7 (12813)
Information8Struct.Inf8 (12814)
Group1Struct.Gr (12815) TxtTp 168
Group2Struct.Gr2 (12816) TxtTp 169
Group3Struct.Gr3 (12817) TxtTp 170
Group4Struct.Gr4 (12818) TxtTp 171
Group5Struct.Gr5 (12819) TxtTp 172
Group6Struct.Gr6 (12820) TxtTp 173
Group7Struct.Gr7 (12821) TxtTp 174
Group8Struct.Gr8 (12822) TxtTp 175
Group9Struct.Gr9 (12823) TxtTp 176
Group10Struct.Gr10 (12824) TxtTp 177
Group11Struct.Gr11 (12825) TxtTp 178
Group12Struct.Gr12 (12826) TxtTp 179
WarehouseNoStruct.StcNo (13773)
MemoFileNameStruct.NoteNm (13774)
TaxAndAccountingGroupStruct.ProdGr (15367) TxtTp 17
AccountSetStruct.AcSet (15368) TxtTp 18
ProductProcessingMethodNoStruct.ProdProcNo (16306)
CreatedDateStruct.CreDt (17143) System field. Not writeable.
CreatedTimeStruct.CreTm (17144) System field. Not writeable.
CreatedByUserStruct.CreUsr (17145) System field. Not writeable.
MemoNoStruct.MemoNo (19233) System field. Not retrieveable.

Relations

Reverse Relations