Links between the Venice files
 
This topic explains how the different files (belonging to the SDK interfaces) in Venice are related to each other.
 
The table has the following columns:
 
Reference file
The name of the file that has one or more properties which refer to one specific record in another file. The Reference File is typically the "many" side in a many-to-one relation (rarely, this can also be a one-to-one relation).
 
Related with
The name of the file that has a relation with the Reference file and on which you want to call a SeekBy method to find the unique record the Reference file refers to. The Related with file is the "to-one" side in a many-to-one (or one-to-one) relation.
 
SeekBy method
The SeekBy method to use on the Related with file to find the unique record that the Reference file refers to.
 
Parameters
The list of properties of both objects that need to match.
 
Reverse SeekBy method(s)
The list of SeekBy methods that can be used on the Reference file to find the records that refer to the Related with file.
 
Remark
There is not always a SeekBy method available that will allow you to do this type of reverse action with a limit. You can always use any of the existing SeekBy methods, and using a filter instead of a limit.
There may also be multiple SeekBy methods that could be used. In that case you can pick whichever method suits your needs best. A SeekBy may be using a Null-Key which can be useful and/or the available SeekBy methods will return the records in different sorting orders.
 
Reference file Related with SeekBy method Parameters Reverse SeekBy
Accounting proposals Lookup SeekByType Lookup.TypeNum = eLookupType.ltAphText<index> -
Lookup.Text = AccProp.Text<index>
Analytical accounts Lookup SeekByType Lookup.TypeNum = eLookupType.ltAacText<index> -
Lookup.Text = AnAcc.Text<index>
Analytical centre entries Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent AnCntSeekByCentreKindAcc, AnCntSeekByCentreKindDate
AnAcc.Code = AnCnt.AnaAccount
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatKind AnCntSeekByKindCentreAcc, AnCntSeekByKindCentreDate
AnAcc.Code = AnCnt.AnaKind
Book SeekByCode Book.BookType = AnCnt.BookType SeekByDocEntry, SeekFirstAnaEntry
Book.Book = AnCnt.Book
General accounts SeekByAccNum Accnt.Number = AnCnt.Account SeekByAccCentreKind, SeekByAccKindCentre
Entry SeekBySysNum Entry.SysNum = AnCnt.EntSysNum SeekByDocEntry, SeekFirstAnaEntry
Financial documents SeekByBook AnCnt.BookType = eBookType.btFinan SeekByDocEntry, SeekFirstAnaEntry
Finan.Book = AnCnt.Book
Finan.DocNum = AnCnt.DocNum
Purchase documents SeekByDocNum AnCnt.BookType = eBookType.btPurch SeekByDocEntry, SeekFirstAnaEntry
Purch.Book = AnCnt.Book
Purch.DocNum = AnCnt.DocNum
Sales documents SeekByDocNum AnCnt.BookType = eBookType.btSales SeekByDocEntry, SeekFirstAnaEntry
Sales.Book = AnCnt.Book
Sales.DocNum = AnCnt.DocNum
Sundry documents SeekByDocNum AnCnt.BookType = eBookType.btSndry SeekByDocEntry, SeekFirstAnaEntry
Sndry.Book = AnCnt.Book
Sndry.DocNum = AnCnt.DocNum
Analytical accounting proposal Lookup SeekByType Lookup.TypeNum = eLookupType.ltAnhText<index> -
Lookup.Text = AnaProp.Text<index>
Analytical unit entries Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit AnUntSeekByUnitKindAcc, AnUntSeekByUnitKindDate
AnAcc.Code = AnUnt.AnaAccount
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatKind AnUntSeekByKindUnitAcc, AnUntSeekByKindUnitDate
AnAcc.Code = AnUnt.AnaKind
Book SeekByCode Book.BookType = AnUnt.BookType SeekByDocEntry, SeekFirstAnaEntry
Book.Book = AnUnt.Book
General accounts SeekByAccNum Accnt.Number = AnUnt.Account SeekByAccUnitKind, SeekByAccKindUnit
Entry SeekBySysNum Entry.SysNum = AnUnt.EntSysNum SeekByDocEntry, SeekFirstAnaEntry
Financial documents SeekByBook AnUnt.BookType = eBookType.btFinan SeekByDocEntry, SeekFirstAnaEntry
Finan.Book = AnUnt.Book
Finan.DocNum = AnUnt.DocNum
Purchase documents SeekByDocNum AnUnt.BookType = eBookType.btPurch SeekByDocEntry, SeekFirstAnaEntry
Purch.Book = AnUnt.Book
Purch.DocNum = AnUnt.DocNum
Sales documents SeekByDocNum AnUnt.BookType = eBookType.btSales SeekByDocEntry, SeekFirstAnaEntry
Sales.Book = AnUnt.Book
Sales.DocNum = AnUnt.DocNum
Sundry documents SeekByDocNum AnUnt.BookType = eBookType.btSndry SeekByDocEntry, SeekFirstAnaEntry
Sndry.Book = AnUnt.Book
Sndry.DocNum = AnUnt.DocNum
Article Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatKind -
AnAcc.Code = Artcl.AnaKind
Article group SeekByCode ArtGrp.Code = Artcl.GroupCode SeekByGroupCode
Country SeekByCode Country.CountryCode = Artcl.CountryCode -
General accounts SeekByAccNum Accnt.Number = Artcl.Account<type> -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtAlias SeekByAlias
Lookup.Text = Artcl.Alias
SeekByType Lookup.TypeNum = eLookupType.ltArtCat<index> SeekByFreeCat
Lookup.Text = Artcl.FreeCategory<index>
SeekByType Lookup.TypeNum = eLookupType.ltArtTotal -
Lookup.Text = Artcl.TotalCode
SeekByType Lookup.TypeNum = eLookupType.ltArtSlsUnDscLng<index> -
Lookup.Text = Artcl.SalesUnitDscLng<index>
SeekByType Lookup.TypeNum = eLookupType.ltArtPrcUnDscLng<index> -
Lookup.Text = Artcl.PurchUnitDscLng<index>
SeekByType Lookup.TypeNum = eLookupType.ltArtStcUnDscLng<index> -
Lookup.Text = Artcl.StockUnitDscLng<index>
SeekByType Lookup.TypeNum = eLookupType.ltArtText<index> -
Lookup.Text = Artcl.Text<index>
SeekByType Lookup.TypeNum = eLookupType.ltArtTextExtra<index> -
Lookup.Text = Artcl.TextEx<index>
Supplements SeekByCode Spplm.Code = Artcl.SupplCode<index> -
Supplier SeekBySupNum Suppl.Number = Artcl.SupNumber SeekBySupNum, SeekBySupRef
Article groups Lookup SeekByType Lookup.TypeNum = eLookupType.ltGrpText<index> -
Lookup.Text = ArtGrp.Text<index>
Article locations Articles SeekByNumber Artcl.Number = ArtLoc.ArtNum SeekByArticle
Locations SeekByWarehouse Locat.Warehouse = ArtLoc.Warehouse SeekByWarehouse, SeekByPriority, SeekByPrcLoc
Locat.Code = ArtLoc.Location
Lookup SeekByType Lookup.TypeNum = eLookupType.ltALoText<index> -
Lookup.Text = ArtLoc.Text<index>
Article suppliers Articles SeekByNumber Artcl.Number = ArtSup.ArtNum SeekByArtNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltAsuText<index> -
Lookup.Text = ArtSup.Text<index>
Supplier SeekBySupNum Suppl.Number = ArtSup.SupNum SeekBySupNum,SeekBySupRef
Article warehouses Articles SeekByNumber Artcl.Number = ArtWrh.ArtNum SeekByArtNum
Warehouses SeekByCode Warehouse.Code = ArtWrh.Code SeekByWareh
Balance General accounts SeekByAccNum Accnt.Number = Balan.Account SeekByAccNum
Book - -       -
Commercial purchase agreements Articles SeekByNumber Artcl.Number = ComAp.ArtNum SeekByArtcl
Supplier SeekBySupNum Suppl.Number = ComAp.SupNum SeekBySuppl
Commercial sales agreements Articles SeekByNumber Artcl.Number = ComAs.ArtNum SeekByArtcl
Customer SeekByCstNum Custm.Number = ComAs.CstNum SeekByCustm
Commodity codes - -       -
Contact Country SeekByCode Country.CountryCode = Custm.CountryCode -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCtcText<index> -
Lookup.Text = Contact.Text<index>
Country - -       -
Current stock Articles SeekByNumber Artcl.Number = CurStock.StockNumber -
Location SeekByWarehouse Locat.Warehouse = CurStock.Warehouse -
Locat.Code = CurStock.Location
Serial number SeekByCode ArtSrl.ArtNum = CurStock.StockNumber -
ArtSrl.Code = CurStock.Serial
Stock changes Articles SeekByNumber Artcl.Number = StockInfo.ArtNumStock -
Customer SeekByCstNum StockInfo.DocType = eInvDocType.idtIsr / eInvDocType.idtIsd / eInvDocType.idtIsi -
Custm.Number = StockInfo.Number
Custm.SubNumber = StockInfo.SubNumber
Location SeekByWarehouse Locat.Warehouse = StockInfo.Warehouse -
Locat.Code = StockInfo.Location
Production documents SeekByBook StockInfo.DocType = eInvDocType.idtCmp -
Accounting year of Product-object = StockInfo.AccYear
Product.Book = StockInfo.Book
Product.DocNum = StockInfo.DocNum
Production document details SeekByDocument StockInfo.DocType = eInvDocType.idtCmp -
Accounting year of ProductDet-object = StockInfo.AccYear
ProductDet.Book = StockInfo.Book
ProductDet.DocNum = StockInfo.DocNum
ProductDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Purchase deliveries SeekByBook StockInfo.DocType = eInvDocType.idtIpd -
Accounting year of PDeliv-object = StockInfo.AccYear
PDeliv.Book = StockInfo.Book
PDeliv.DocNum = StockInfo.DocNum
Purchase delivery details SeekByDocument StockInfo.DocType = eInvDocType.idtIpd -
Accounting year of PDelivDet-object = StockInfo.AccYear
PDelivDet.Book = StockInfo.Book
PDelivDet.DocNum = StockInfo.DocNum
PDelivDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Purchase invoices SeekByBook StockInfo.DocType = eInvDocType.idtIpi -
Accounting year of PInvce-object = StockInfo.AccYear
PInvce.Book = StockInfo.Book
PInvce.DocNum = StockInfo.DocNum
Purchase invoice details SeekByDocument StockInfo.DocType = eInvDocType.idtIpi -
Accounting year of PInvceDet-object = StockInfo.AccYear
PInvceDet.Book = StockInfo.Book
PInvceDet.DocNum = StockInfo.DocNum
PInvceDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Purchase orders SeekByBook StockInfo.DocType = eInvDocType.idtIpr -
Accounting year of POrder-object = StockInfo.AccYear
POrder.Book = StockInfo.Book
POrder.DocNum = StockInfo.DocNum
Purchase order details SeekByDocument StockInfo.DocType = eInvDocType.idtIpr -
Accounting year of POrderDet-object = StockInfo.AccYear
POrderDet.Book = StockInfo.Book
POrderDet.DocNum = StockInfo.DocNum
POrderDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Sales deliveries SeekByBook StockInfo.DocType = eInvDocType.idtIsd -
Accounting year of SDeliv-object = StockInfo.AccYear
SDeliv.Book = StockInfo.Book
SDeliv.DocNum = StockInfo.DocNum
Sales delivery details SeekByDocument StockInfo.DocType = eInvDocType.idtIsd -
Accounting year of SDelivDet-object = StockInfo.AccYear
SDelivDet.Book = StockInfo.Book
SDelivDet.DocNum = StockInfo.DocNum
SDelivDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Sales invoices SeekByBook StockInfo.DocType = eInvDocType.idtIsi -
Accounting year of SInvce-object = StockInfo.AccYear
SInvce.Book = StockInfo.Book
SInvce.DocNum = StockInfo.DocNum
Sales invoice details SeekByDocument StockInfo.DocType = eInvDocType.idtIsi -
Accounting year of SInvceDet-object = StockInfo.AccYear
SInvceDet.Book = StockInfo.Book
SInvceDet.DocNum = StockInfo.DocNum
SInvceDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Sales orders SeekByBook StockInfo.DocType = eInvDocType.idtIsr -
Accounting year of SOrder-object = StockInfo.AccYear
SOrder.Book = StockInfo.Book
SOrder.DocNum = StockInfo.DocNum
Sales order details SeekByDocument StockInfo.DocType = eInvDocType.idtIsr -
Accounting year of SOrderDet-object = StockInfo.AccYear
SOrderDet.Book = StockInfo.Book
SOrderDet.DocNum = StockInfo.DocNum
SOrderDet.LineNum = StockInfo.Line - 1 (see SeekByDocument)
Serial number SeekByCode ArtSrl.Code = StockInfo.Serial -
ArtSrl.ArtNum = StockInfo.ArtNumStock
StockDoc SeekByBook StockInfo.DocType = eInvDocType.idtStc -
Accounting year of StockDoc-object = StockInfo.AccYear
StockDoc.Book = StockInfo.Book
StockDoc.DocNum = StockInfo.DocNum
Supplier SeekBySupNum StockInfo.DocType = eInvDocType.idtIpr / eInvDocType.idtIpd / eInvDocType.idtIpi -
Suppl.Number = StockInfo.Number
Suppl.SubNumber = StockInfo.SubNumber
Customer Accounting proposals SeekByCode AccProp.DocType = eAccPropDocType.apdtAsl<type> -
AccProp.Code = Custm.PropAsl<type>
Country SeekByCode Country.CountryCode = Custm.CountryCode -
General accounts SeekByAccNum Accnt.Number = Custm.AltAccount -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstAddressForm -
Lookup.Text = Custm.AddressForm
SeekByType Lookup.TypeNum = eLookupType.ltCstAlias SeekByAlias
Lookup.Text = Custm.Alias
SeekByType Lookup.TypeNum = eLookupType.ltCstClass -
Lookup.Text = Custm.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstGroup SeekByGroup
Lookup.Text = Custm.Groupcode
SeekByType Lookup.TypeNum = eLookupType.ltCstPolitePhrase -
Lookup.Text = Custm.PolitePhrase
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative -
Lookup.Text = Custm.Representative
SeekByType Lookup.TypeNum = eLookupType.ltCstStat -
Lookup.Text = Custm.Stat
SeekByType Lookup.TypeNum = eLookupType.ltCstText<index> -
Lookup.Text = Custm.Text<index>
SeekByType Lookup.TypeNum = eLookupType.ltCstTextExtra<index> -
Lookup.Text = Custm.TextEx<index>
EdoWork - -       -
Entry Financial documents SeekByBook Entry.BookType = eBookType.btFinan SeekByDocNum
Finan.Book = Entry.Book
Finan.DocNum = Entry.DocNum
SeekByBook Entry.BookTypeOrg = eBookType.btFinan SeekByDocNumOrg
Accounting year of Finan-object = Entry.AccYearOrg
Finan.Book = Entry.BookOrg
Finan.DocNum = Entry.DocNumOrg
Purchase documents SeekByDocNum Entry.BookType = eBookType.btPurch SeekByDocNum
Purch.Book = Entry.Book
Purch.DocNum = Entry.DocNum
SeekByDocNum Entry.BookTypeOrg = eBookType.btPurch SeekByDocNumOrg
Accounting year of Purch-object = Entry.AccYearOrg
Purch.Book = Entry.BookOrg
Purch.DocNum = Entry.DocNumOrg
Sales documents SeekByDocNum Entry.BookType = eBookType.btSales SeekByDocNum
Sales.Book = Entry.Book
Sales.DocNum = Entry.DocNum
SeekByDocNum Entry.BookTypeOrg = eBookType.btSales SeekByDocNumOrg
Accounting year of Sales-object = Entry.AccYearOrg
Sales.Book = Entry.BookOrg
Sales.DocNum = Entry.DocNumOrg
Sundry documents SeekByDocNum Entry.BookType = eBookType.btSndry SeekByDocNum
Sndry.Book = Entry.Book
Sndry.DocNum = Entry.DocNum
SeekByDocNum Entry.BookTypeOrg = eBookType.btSndry SeekByDocNumOrg
Accounting year of Sndry-object = Entry.AccYearOrg
Sndry.Book = Entry.BookOrg
Sndry.DocNum = Entry.DocNumOrg
Book SeekByCode Book.BookType = Entry.BookType SeekByJournal, SeekByDocNum
Book.Book = Entry.Book
SeekByType Book.BookType = Entry.BookTypeOrg SeekByDocNumOrg
Book.Book = Entry.BookOrg
General accounts SeekByAccNum Accnt.Number = Entry.Account SeekByHistory, SeekByToTick
General accounts SeekByAccNum Accnt.Number = Entry.CutOffAccount -
Financial books Accounting proposals SeekByCode AccProp.DocType = eAccPropDocType.apdtFinDoc -
AccProp.Code = FBook.PropFinDoc
Country SeekByCode Country.CountryCode = FBook.CountryCode -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltFbkAddressForm -
Lookup.Text = FBook.AddressForm
SeekByType Lookup.TypeNum = eLookupType.ltFbkPolitePhrase -
Lookup.Text = FBook.PolitePhrase
SeekByType Lookup.TypeNum = eLookupType.ltFbkText<index> -
Lookup.Text = FBook.Text<index>
Financial documents Financial books SeekByCode FBook.Book = Finan.Book SeekByBook
Lookup SeekByType Lookup.TypeNum = eLookupType.ltFinText<index> -
Lookup.Text = Finan.Text<index>
Firm data Country SeekByCode Country.CountryCode = Firm.CountryCode -
General accounts Analytical entry proposal SeekByCode AnaProp.AnaAccType = eAnaAccType.aatCent -
AnaProp.Code = Accnt.AnaPropCent
SeekByCode AnaProp.AnaAccType = eAnaAccType.aatUnit -
AnaProp.Code = Accnt.AnaPropCent
Lookup SeekByType Lookup.TypeNum = eLookupType.ltAccAlias SeekByAlias
Lookup.Text = Accnt.Alias
SeekByType Lookup.TypeNum = eLookupType.ltAccText<index> -
Lookup.Text = Accnt.Text<index>
Locations Lookup SeekByType Lookup.TypeNum = eLookupType.ltCircuitCode -
Lookup.Text = Locat.CircuitCode
SeekByType Lookup.TypeNum = eLookupType.ltLocText<index> -
Lookup.Text = Locat.Text<index>
Warehouse SeekByCode Warehouse.Code = Locat.Warehouse SeekByWarehouse, SeekByCircuit
Lookup - -       -
Material assets cards Analytical accounting proposals SeekByCode AnaProp.AnaPropAccType = eAnaPropAccType.apatCent -
AnaProp.Code = MaCrd.AnaPropCent
SeekByCode AnaProp.AnaPropAccType = eAnaPropAccType.apatUnit -
AnaProp.Code = MaCrd.AnaPropUnit
Purchase documents SeekByDocNum Accounting year of Purch-object = MaCrd.AprAccYear SeekByPrcDoc
Purch.Book = MaCrd.AprBook
Purch.DocNum = MaCrd.AprDocNum
SeekByDocNum Accounting year of Purch-object = MaCrd.CredAccYear SeekByCrdDoc
Purch.Book = MaCrd.CredBook
Purch.DocNum = MaCrd.CredDocNum
Sales documents SeekByDocNum Accounting year of Sales-object = MaCrd.AslAccYear SeekBySlsDoc
Sales.Book = MaCrd.AslBook
Sales.DocNum = MaCrd.AslDocNum
General accounts SeekByAccNum Accnt.Number = MaCrd.MasAcc -
SeekByAccNum Accnt.Number = MaCrd.DownAcc -
SeekByAccNum Accnt.Number = MaCrd.PlusAcc -
SeekByAccNum Accnt.Number = MaCrd.DeprAcc -
SeekByAccNum Accnt.Number = MaCrd.AslAcc -
SeekByAccNum Accnt.Number = MaCrd.NewMasAcc -
SeekByAccNum Accnt.Number = MaCrd.NewDownAcc -
SeekByAccNum Accnt.Number = MaCrd.NewPlusAcc -
SeekByAccNum Accnt.Number = MaCrd.NewAccRem -
Supplier SeekBySupNum Suppl.Number = MaCrd.SupNum -
Suppl.SubNumber = 0
Lookup SeekByType Lookup.TypeNum = eLookupType.ltMcrText<index> -
Lookup.Text = MaCrd.Text<index>
Payment work file Country SeekByCode Country.CountryCode = PayWork.BankCountryCode -
SeekByCode Country.CountryCode = PayWork.BenCountryCode
Entry SeekBySysNum Entry.SysNum = PayWork.TickSysNum SeekByTicking
Financial books SeekByCode FBook.Book = PayWork.BankCode SeekByBankCode, SeekByAssigned, SeekByValid
General accounts SeekByAccNum Accnt.Number = PayWork.Account SeekByAccNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPpxGroupCode SeekByGroupCode
Lookup.Text = PayWork.GroupCode
Periodical payments SeekByCode PerPay.PerCode = PayWork.PerCode -
Periodical payments Country SeekByCode Country.CountryCode = PerPay.BankCountryCode -
SeekByCode Country.CountryCode = PerPay.BenCountryCode
Financial books SeekByCode FBook.Book = PerPay.BankCode -
General accounts SeekByAccNum Accnt.Number = PerPay.Account -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPpxGroupCode SeekByGroup
Lookup.Text = PerPay.GroupCode
Production documents Articles SeekByNumber Artcl.Number = Product.ArtNum SeekByArtNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCphBook SeekByBook, SeekByProdStatus
Lookup.Text = Product.Book
SeekByType Lookup.TypeNum = eLookupType.ltCphText<index> -
Lookup.Text = Product.Text<index>
Production documents SeekBySysNum Accounting year of Product-object = Product.MainDocYear SeekByMainDoc
Product.SysNum = Product.MainDocSysNum
Sales order details SeekBySysNum Accounting year of SOrderDet-object = Product.TickYear SeekByTick
Product.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = Product.TickSysNum
Production document details Articles SeekByNumber Artcl.Number = ProductDet.ArtNum SeekByUnprodArt
SeekByNumber Artcl.Number = ProductDet.ArtNumStock SeekByStcArtNum, SeekByEvalDate
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCphBook SeekByDocument
Lookup.Text = ProductDet.Book
SeekByType Lookup.TypeNum = eLookupType.ltCpdText1 -
Lookup.Text = ProductDet.Text1
Production documents SeekByBook Product.Book = ProductDet.Book SeekByDocument
Product.DocNum = ProductDet.DocNum
Projects Customer SeekByCstNum Project.eFirmType = eFirmType.ftCustomer SeekByFirm, SeekByOpenFrm
Custm.Number = Project.FrmNum
Custm.SubNumber = Project.FrmSubNum
Contact SeekByContact Contact.Number = Project.CtcNum SeekByLink, SeekByOpenLnk
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPjhCategory SeekByCategory
Lookup.Text = Project.Category
SeekByType Lookup.TypeNum = eLookupType.ltPjhStatus SeekByOpenStat
Lookup.Text = Project.Status
SeekByType Lookup.TypeNum = eLookupType.ltPjhGroup SeekByGroup
Lookup.Text = Project.GroupCode
SeekByType Lookup.TypeNum = eLookupType.ltPjhVia -
Lookup.Text = Project.Via
SeekByType Lookup.TypeNum = eLookupType.ltPjhSource -
Lookup.Text = Project.Source
SeekByType Lookup.TypeNum = eLookupType.ltPjhResponsible -
Lookup.Text = Project.Responsible
SeekByType Lookup.TypeNum = eLookupType.ltPjhClosedReason -
Lookup.Text = Project.ClosedReason
SeekByType Lookup.TypeNum = eLookupType.ltPjhText<index> -
Lookup.Text = Project.Text<index>
Supplier SeekBySupNum Project.eFirmType = eFirmType.ftSupplier SeekByFirm, SeekByOpenFrm
Suppl.Number = Project.FrmNum
Suppl.SubNumber = Project.FrmSubNum
Project details Customer SeekByCstNum ProjectDet.eFirmType = eFirmType.ftCustomer SeekByFirm
Custm.Number = ProjectDet.FrmNum
Custm.SubNumber = ProjectDet.FrmSubNum
Contact SeekByContact Contact.Number = ProjectDet.CtcNum SeekByCtLink, SeekByCntct
Project SeekByProject Project.Number = ProjectDet.Project SeekByProject
Supplier SeekBySupNum ProjectDet.eFirmType = eFirmType.ftSupplier SeekByFirm
Suppl.Number = ProjectDet.FrmNum
Suppl.SubNumber = ProjectDet.FrmSubNum
Purchase deliveries Book SeekByCode Book.BookType = eBookType.btPurch SeekByBook
Book.Book = PDeliv.Book
Customer SeekBySysNum Custm.SysNum = PDeliv.SysNumDelivery -
Purchase invoices SeekBySysNum Accounting year of PInvce-object = PDeliv.TrnYear -
PDeliv.TrnDocType = eInvDocType.idtIpi
PInvce.SysNum = PDeliv.TrnSysNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltInvShipmentMethod -
Lookup.Text = PDeliv.ShipmentMethod
SeekByType Lookup.TypeNum = eLookupType.ltSupClass -
Lookup.Text = PDeliv.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat -
Lookup.Text = PDeliv.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltPdhText<index> -
Lookup.Text = PDeliv.Text<index>
Supplier SeekBySupNum Suppl.Number = PDeliv.SupNum SeekBySupNum, SeekByOpenStatSup, SeekBySupRefer
Suppl.SubNumber = PDeliv.SupSubNum
SeekBySysNum Suppl.SysNum = PDeliv.SysNumExtra -
Purchase delivery details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = PDelivDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = PDelivDet.AnaUnit
Articles SeekByNumber Artcl.Number = PDelivDet.ArtNum SeekByArticle, SeekByUnpaidArt
SeekByNumber Artcl.Number = PDelivDet.ArtNumStock SeekByStcArtNum
Book SeekByCode Book.BookType = eBookType.btPurch SeekByDocument
Book.Book = PDelivDet.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPddText -
Lookup.Text = PDelivDet.Text1
Purchase order details SeekBySysNum Accounting year of POrderDet-object = PDelivDet.TickYear SeekByTick
PDelivDet.TickDocType = eTickDocType.tdtPOrder
POrderDet.SysNum = PDelivDet.TickSysNum
Purchase delivery SeekByBook PDeliv.Book = PDelivDet.Book SeekByDocument
PDeliv.DocNum = PDelivDet.DocNum
Supplements SeekByCode Spplm.Code = PDelivDet.SupplCode<index> -
Supplier SeekBySupNum Suppl.Number = PDelivDet.SupNum SeekBySupNum
Suppl.SubNumber = PDelivDet.SupSubNum
Purchase documents Book SeekByCode Book.BookType = eBookType.btPurch SeekByDocNum
Book.Book = Purch.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass SeekByClassCode
Lookup.Text = Purch.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat SeekByStatCode
Lookup.Text = Purch.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltAprText<index> -
Lookup.Text = Purch.Text<index>
Purchase invoice SeekBySysNum PInvce.SysNum = Purch.SysNumIpr -
Supplier SeekBySupNum Suppl.Number = Purch.SupNum SeekBySupNum, SeekByUnpaid, SeekBySupRef
Suppl.SubNumber = Purch.SupSubNum
Purchase invoices Book SeekByCode Book.BookType = eBookType.btPurch SeekByBook, SeekByPrnStatus, SeekByTrnBook
Book.Book = PInvce.Book
Customer SeekBySysNum Custm.SysNum = PInvce.SysNumDelivery -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass -
Lookup.Text = PInvce.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat -
Lookup.Text = PInvce.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltPihText<index> -
Lookup.Text = PInvce.Text<index>
Supplier SeekBySupNum Suppl.Number = PInvce.SupNum SeekBySupNum, SeekBySupRefer
Suppl.SubNumber = PInvce.SupSubNum
SeekBySysNum Suppl.SysNum = PInvce.SysNumExtra -
Purchase invoice details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = PInvceDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = PInvceDet.AnaUnit
Articles SeekByNumber Artcl.Number = PInvceDet.ArtNum SeekByArticle
SeekByNumber Artcl.Number = PInvceDet.ArtNumStock SeekByStcArtNum
Article group SeekByCode ArtGrp.Code = PInvceDet.GroupCode SeekByGrpCod
Book SeekByCode Book.BookType = eBookType.btPurch SeekByDocument
Book.Book = PInvceDet.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtCat<index> SeekByFreeCat
Lookup.Text = PInvceDet.FreeCategory<index>
SeekByType Lookup.TypeNum = eLookupType.ltPidText -
Lookup.Text = PInvceDet.Text1
SeekByType Lookup.TypeNum = eLookupType.ltSupClass SeekByClass
Lookup.Text = PInvceDet.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat SeekByStatCod
Lookup.Text = PInvceDet.Stat
SeekByType Lookup.TypeNum = eLookupType.ltSupClass SeekByClass
Lookup.Text = PInvceDet.Class
Purchase order details SeekBySysNum Accounting year of POrderDet-object = PInvceDet.TickYear SeekByTick
PInvceDet.TickDocType = eTickDocType.tdtPOrder
POrderDet.SysNum = PInvceDet.TickSysNum
Purchase delivery details SeekBySysNum Accounting year of PDelivDet-object = PInvceDet.TickYear SeekByTick
PInvceDet.TickDocType = eTickDocType.tdtPDeliv
POrderDet.SysNum = PInvceDet.TickSysNum
Purchase invoice SeekByBook PInvce.Book = PInvceDet.Book SeekByDocument
PInvce.DocNum = PInvceDet.DocNum
Supplements SeekByCode Spplm.Code = PInvceDet.SupplCode<index> -
Supplier SeekBySupNum Suppl.Number = PInvceDet.SupNum SeekBySupNum, SeekBySupArt
Suppl.SubNumber = PInvceDet.SupSubNum
Purchase offers Book SeekByCode Book.BookType = eBookType.btPurch SeekByBook
Book.Book = POffer.Book
Customer SeekBySysNum Custm.SysNum = POffer.SysNumDelivery -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass -
Lookup.Text = POffer.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat -
Lookup.Text = POffer.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltPohText<index> -
Lookup.Text = POffer.Text<index>
Supplier SeekBySupNum Suppl.Number = POffer.SupNum SeekBySupNum
Suppl.SubNumber = POffer.SupSubNum
SeekBySysNum Suppl.SysNum = POffer.SysNumExtra -
SeekBySysNum Suppl.SysNum = POffer.SysNumSup SeekBySupSys
Purchase offer details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = POfferDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = POfferDet.AnaUnit
Articles SeekByNumber Artcl.Number = POfferDet.ArtNum -
Book SeekByCode Book.BookType = eBookType.btPurch SeekByDocument
Book.Book = POfferDet.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPodText -
Lookup.Text = POfferDet.Text1
Purchase offer SeekByBook POffer.Book = POfferDet.Book SeekByDocument
POffer.DocNum = POfferDet.DocNum
Supplements SeekByCode Spplm.Code = POfferDet.SupplCode<index> -
Purchase orders Book SeekByCode Book.BookType = eBookType.btPurch SeekByBook, SeekByOpenStatus
Book.Book = POrder.Book
Customer SeekBySysNum Custm.SysNum = POrder.SysNumDelivery -
Purchase deliveries SeekBySysNum Accounting year of PDeliv-object = POrder.TrnYear -
POrder.TrnDocType = eInvDocType.idtIpd
PDeliv.SysNum = POrder.TrnSysNum
Purchase invoices SeekBySysNum Accounting year of PInvce-object = POrder.TrnYear -
POrder.TrnDocType = eInvDocType.idtIpi
PInvce.SysNum = POrder.TrnSysNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltInvShipmentMethod -
Lookup.Text = POrder.ShipmentMethod
SeekByType Lookup.TypeNum = eLookupType.ltSupClass -
Lookup.Text = POrder.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupStat -
Lookup.Text = POrder.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltPrhText<index> -
Lookup.Text = POrder.Text<index>
Supplier SeekBySupNum Suppl.Number = POrder.SupNum SeekBySupNum, SeekByOpenStatSup
Suppl.SubNumber = POrder.SupSubNum
SeekBySysNum Suppl.SysNum = POrder.SysNumExtra -
Purchase order details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = POrderDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = POrderDet.AnaUnit
Articles SeekByNumber Artcl.Number = POrderDet.ArtNum SeekByArticle, SeekByOpenArt
SeekByNumber Artcl.Number = POrderDet.ArtNumStock SeekByStcArtNum
Book SeekByCode Book.BookType = eBookType.btPurch SeekByDocument
Book.Book = POrderDet.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltPrdText -
Lookup.Text = POrderDet.Text1
Purchase order SeekByBook POrder.Book = POrderDet.Book SeekByDocument
POrder.DocNum = POrderDet.DocNum
Supplements SeekByCode Spplm.Code = POrderDet.SupplCode<index> -
Supplier SeekBySupNum Suppl.Number = POrderDet.SupNum SeekBySupNum, SeekByOpenSup
Suppl.SubNumber = POrderDet.SupSubNum
Exchange rates - -       -
Sales deliveries Book SeekByCode Book.BookType = eBookType.btSales SeekByBook, SeekByOpenStatus, SeekByPrnStatus, SeekByExpStatus
Book.Book = SDeliv.Book
Customer SeekByCstNum Custm.Number = SDeliv.CstNum SeekByCstNum, SeekByOpenStatCst, SeekByCstRefer
Custm.SubNumber = SDeliv.CstSubNum
SeekBySysNum Custm.SysNum = SDeliv.SysNumDelivery -
SeekBySysNum Custm.SysNum = SDeliv.SysNumExtra -
Sales invoices SeekBySysNum Accounting year of SInvce-object = SDeliv.TrnYear -
SDeliv.TrnDocType = eInvDocType.idtIsi
SInvce.SysNum = SDeliv.TrnSysNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass -
Lookup.Text = SDeliv.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative -
Lookup.Text = SDeliv.Representative
SeekByType Lookup.TypeNum = eLookupType.ltInvShipmentMethod -
Lookup.Text = SDeliv.ShipmentMethod
SeekByType Lookup.TypeNum = eLookupType.ltCstStat -
Lookup.Text = SDeliv.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltSdhText<index> -
Lookup.Text = SDeliv.Text<index>
Sales delivery details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = SDelivDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = SDelivDet.AnaUnit
Articles SeekByNumber Artcl.Number = SDelivDet.ArtNum SeekByArticle, SeekByUnpaidArt, SeekByUnpaidArtCst
SeekByNumber Artcl.Number = SDelivDet.ArtNumStock SeekByStcArtNum
Book SeekByCode Book.BookType = eBookType.btSales SeekByDocument
Book.Book = SDelivDet.Book
Customer SeekByCstNum Custm.Number = SDelivDet.SupNum SeekByCstNum, SeekByUnpaidCst
Custm.SubNumber = SDelivDet.CstSubNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSddText -
Lookup.Text = SDelivDet.Text1
Sales delivery SeekByBook SDeliv.Book = SDelivDet.Book SeekByDocument
SDeliv.DocNum = SDelivDet.DocNum
Sales order details SeekBySysNum Accounting year of SOrderDet-object = SDelivDet.TickYear SeekByTick
SDelivDet.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = SDelivDet.TickSysNum
Supplements SeekByCode Spplm.Code = SDelivDet.SupplCode<index> -
Sales documents Book SeekByCode Book.BookType = eBookType.btSales SeekByDocNum
Book.Book = Sales.Book
Customer SeekByCstNum Custm.Number = Sales.CstNum SeekByCstNum, SeekByUnpaid, SeekByLawState
Custm.SupNumber = Sales.CstSubNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass SeekByClassCode
Lookup.Text = Sales.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative SeekByRepresent
Lookup.Text = Sales.Representative
SeekByType Lookup.TypeNum = eLookupType.ltCstStat SeekByStatCode
Lookup.Text = Sales.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltAslText<index> -
Lookup.Text = Sales.Text<index>
Sales invoice SeekBySysNum SInvce.SysNum = Sales.SysNumIsl -
Sales invoices Book SeekByCode Book.BookType = eBookType.btSales SeekByBook, SeekByPrnStatus, SeekByExpStatus, SeekByTrnBook
Book.Book = SInvce.Book
Customer SeekByCstNum Custm.Number = SInvce.CstNum SeekByCstNumSeekByCstRefer
Custm.SubNumber = SInvce.CstSubNum
SeekBySysNum Custm.SysNum = SInvce.SysNumDelivery -
SeekBySysNum Custm.SysNum = SInvce.SysNumExtra -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass -
Lookup.Text = SInvce.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative -
Lookup.Text = SInvce.Representative
SeekByType Lookup.TypeNum = eLookupType.ltCstStat -
Lookup.Text = SInvce.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltSihText<index> -
Lookup.Text = SInvce.Text<index>
Sales invoice SeekByBook Accounting year of SInvce-object = SInvce.RefYear SeekByBook
SInvce.Book = SInvce.RefBook
SInvce.DocNum = SInvce.RefDocNum
Sales invoice details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = SInvceDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = SInvceDet.AnaUnit
Articles SeekByNumber Artcl.Number = SInvceDet.ArtNum SeekByArticle
SeekByNumber Artcl.Number = SInvceDet.ArtNumStock SeekByStcArtNum
Article group SeekByCode ArtGrp.Code = SInvceDet.GroupCode SeekByGrpCod
Book SeekByCode Book.BookType = eBookType.btSales SeekByDocument
Book.Book = SInvceDet.Book
Customer SeekByCstNum Custm.Number = SInvceDet.CstNum SeekByCstNum, SeekByCstArt
Custm.SubNumber = SInvceDet.CstSubNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtCat<index> SeekByFreeCat
Lookup.Text = SInvceDet.FreeCategory<index>
SeekByType Lookup.TypeNum = eLookupType.ltCstClass SeekByClass
Lookup.Text = SInvceDet.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative SeekByRepres
Lookup.Text = SInvceDet.Representative
SeekByType Lookup.TypeNum = eLookupType.ltCstStat SeekByStatCod
Lookup.Text = SInvceDet.Stat
SeekByType Lookup.TypeNum = eLookupType.ltSidText -
Lookup.Text = SInvceDet.Text1
Sales delivery details SeekBySysNum Accounting year of SDelivDet-object = SInvceDet.TickYear SeekByTick
SInvceDet.TickDocType = eTickDocType.tdtSDeliv
SOrderDet.SysNum = SInvceDet.TickSysNum
Sales invoice SeekByBook SInvce.Book = SInvceDet.Book SeekByDocument
SInvce.DocNum = SInvceDet.DocNum
Sales order details SeekBySysNum Accounting year of SOrderDet-object = SInvceDet.TickYear SeekByTick
SInvceDet.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = SInvceDet.TickSysNum
Supplements SeekByCode Spplm.Code = SInvceDet.SupplCode<index> -
Sales offers Book SeekByCode Book.BookType = eBookType.btSales SeekByBook, SeekByPrnStatus, SeekByOpenStatus
Book.Book = SOffer.Book
Customer SeekByCstNum Custm.Number = SOffer.CstNum SeekByCstNum, SeekByOpenStatCst
Custm.SubNumber = SOffer.CstSubNum
SeekBySysNum Custm.SysNum = SOffer.SysNumCst SeekByCstSys
SeekBySysNum Custm.SysNum = SOffer.SysNumDelivery -
SeekBySysNum Custm.SysNum = SOffer.SysNumExtra -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass -
Lookup.Text = SOffer.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative -
Lookup.Text = SOffer.Representative
SeekByType Lookup.TypeNum = eLookupType.ltCstStat -
Lookup.Text = SOffer.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltSohText<index> -
Lookup.Text = SOffer.Text<index>
Sales offer details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = SOfferDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = SOfferDet.AnaUnit
Articles SeekByNumber Artcl.Number = SOfferDet.ArtNum -
Book SeekByCode Book.BookType = eBookType.btSales SeekByDocument
Book.Book = SOfferDet.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSodText -
Lookup.Text = SOfferDet.Text1
Sales offer SeekByBook SOffer.Book = SOfferDet.Book SeekByDocument
SOffer.DocNum = SOfferDet.DocNum
Supplements SeekByCode Spplm.Code = SInvceDet.SupplCode<index> -
Sales orders Book SeekByCode Book.BookType = eBookType.btSales SeekByBook, SeekByOpenStatus, SeekByPrnStatus
Book.Book = SOrder.Book
Customer SeekByCstNum Custm.Number = SOrder.CstNum SeekByCstNum, SeekByOpenStatCst, SeekByCstRefer
Custm.SubNumber = SOrder.CstSubNum
SeekBySysNum Custm.SysNum = SOrder.SysNumDelivery -
SeekBySysNum Custm.SysNum = SOrder.SysNumExtra -
Sales deliveries SeekBySysNum Accounting year of SDeliv-object = SOrder.TrnYear -
SOrder.TrnDocType = eInvDocType.idtIsd
SDeliv.SysNum = SOrder.TrnSysNum
Sales invoices SeekBySysNum Accounting year of SInvce-object = SOrder.TrnYear -
SOrder.TrnDocType = eInvDocType.idtIsi
SInvce.SysNum = SOrder.TrnSysNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass -
Lookup.Text = SOrder.Class
SeekByType Lookup.TypeNum = eLookupType.ltCstRepresentative -
Lookup.Text = SOrder.Representative
SeekByType Lookup.TypeNum = eLookupType.ltInvShipmentMethod -
Lookup.Text = SOrder.ShipmentMethod
SeekByType Lookup.TypeNum = eLookupType.ltCstStat -
Lookup.Text = SOrder.StatCode
SeekByType Lookup.TypeNum = eLookupType.ltSrhText<index> -
Lookup.Text = SOrder.Text<index>
Sales order details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent -
AnAcc.Code = SOrderDet.AnaCentre
SeekByCode AnAcc.AnaAccType = eAnaAccType.aatUnit -
AnAcc.Code = SOrderDet.AnaUnit
Articles SeekByNumber Artcl.Number = SOrderDet.ArtNum SeekByArticle, SeekByOpenArt
SeekByNumber Artcl.Number = SOrderDet.ArtNumStock SeekByStcArtNum
Book SeekByCode Book.BookType = eBookType.btSales SeekByDocument
Book.Book = SOrderDet.Book
Customer SeekByCstNum Custm.Number = SOrderDet.CstNum SeekByCstNum, SeekByOpenCst
Custm.SubNumber = SOrderDet.CstSubNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSrdText -
Lookup.Text = SOrderDet.Text1
Sales order SeekByBook SOrder.Book = SOrderDet.Book SeekByDocument
SOrder.DocNum = SOrderDet.DocNum
Supplements SeekByCode Spplm.Code = SOrderDet.SupplCode<index> -
Serial numbers Articles SeekByNumber Artcl.Number = ArtSrl.ArtNum SeekByArtNum
Country SeekByCode Country.CountryCode = ArtSrl.CountryCode -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltAsrText<index> -
Lookup.Text = ArtSrl.Text<index>
Stock documents Lookup SeekByType Lookup.TypeNum = eLookupType.ltStcBook SeekByBook
Lookup.Text = StockDoc.Book
SeekByType Lookup.TypeNum = eLookupType.ltSthText<index> -
Lookup.Text = StockDoc.Text<index>
Stock document details Articles SeekByNumber Artcl.Number = StockDocDet.ArtNum SeekByArtNum
SeekByNumber Artcl.Number = StockDocDet.ArtNumStock SeekByStcArtNum
Lookup SeekByType Lookup.TypeNum = eLookupType.ltStcBook SeekByDocument
Lookup.Text = StockDocDet.Book
SeekByType Lookup.TypeNum = eLookupType.ltStdText -
Lookup.Text = StockDocDet.Text1
Stock document SeekByBook StockDoc.Book = StockDocDet.Book SeekByDocument
StockDoc.DocNum = StockDocDet.DocNum
Sundry documents Book SeekByCode Book.BookType = eBookType.btSundry SeekByDocNum
Book.Book = Sndry.Book
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSndText<index> -
Lookup.Text = Sndry.Text<index>
Supplier Accounting proposals SeekByCode AccProp.DocType = eAccPropDocType.apdtApr<type> -
AccProp.Code = Suppl.PropApr<type>
Commodity codes SeekByCode ComCd.Code = Suppl.CommodityCode -
Country SeekByCode Country.CountryCode = Suppl.BankAcc1CountryCode -
SeekByCode Country.CountryCode = Suppl.CountryCode -
General accounts SeekByAccNum Accnt.Number = Suppl.AltAccount -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupAddressForm -
Lookup.Text = Suppl.AddressForm
SeekByType Lookup.TypeNum = eLookupType.ltSupAlias SeekByAlias
Lookup.Text = Suppl.Alias
SeekByType Lookup.TypeNum = eLookupType.ltSupClass -
Lookup.Text = Suppl.Class
SeekByType Lookup.TypeNum = eLookupType.ltSupGroup SeekByGroup
Lookup.Text = Suppl.Groupcode
SeekByType Lookup.TypeNum = eLookupType.ltSupPolitePhrase -
Lookup.Text = Suppl.PolitePhrase
SeekByType Lookup.TypeNum = eLookupType.ltSupStat -
Lookup.Text = Suppl.Stat
SeekByType Lookup.TypeNum = eLookupType.ltSupText<index> -
Lookup.Text = Suppl.Text<index>
Supplements General accounts SeekByAccNum Accnt.Number = Spplm.Account<type> -
Lookup SeekByType Lookup.TypeNum = eLookupType.ltSplText<index> -
Lookup.Text = Spplm.Text<index>
Warehouse Lookup SeekByType Lookup.TypeNum = eLookupType.ltWrhText<index> -
Lookup.Text = Warehouse.Text<index>