Links between the Venice files
 
This topic explains how the different files (belonging to the SDK interfaces) in Venice are related to each other.
 
Reference file Related with SeekBy method Parameters
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
AnAcc.Code = AnCnt.AnaAccount
    SeekByCode AnAcc.AnaAccType = eAnaAccType.aatKind
AnAcc.Code = AnCnt.AnaKind
  Book SeekByCode Book.BookType = AnCnt.BookType
Book.Book = AnCnt.Book
  General accounts SeekByAccNum Accnt.Number = AnCnt.Account
  Entry SeekBySysNum Entry.SysNum = AnCnt.EntSysNum
  Financial documents SeekByBook AnCnt.BookType = eBookType.btFinan
Finan.Book = AnCnt.Book
Finan.DocNum = AnCnt.DocNum
  Purchase documents SeekByDocNum AnCnt.BookType = eBookType.btPurch
Purch.Book = AnCnt.Book
Purch.DocNum = AnCnt.DocNum
  Sales documents SeekByDocNum AnCnt.BookType = eBookType.btSales
Sales.Book = AnCnt.Book
Sales.DocNum = AnCnt.DocNum
  Sundry documents SeekByDocNum AnCnt.BookType = eBookType.btSndry
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
AnAcc.Code = AnUnt.AnaAccount
    SeekByCode AnAcc.AnaAccType = eAnaAccType.aatKind
AnAcc.Code = AnUnt.AnaKind
  Book SeekByCode Book.BookType = AnUnt.BookType
Book.Book = AnUnt.Book
  General accounts SeekByAccNum Accnt.Number = AnUnt.Account
  Entry SeekBySysNum Entry.SysNum = AnUnt.EntSysNum
  Financial documents SeekByBook AnUnt.BookType = eBookType.btFinan
Finan.Book = AnUnt.Book
Finan.DocNum = AnUnt.DocNum
  Purchase documents SeekByDocNum AnUnt.BookType = eBookType.btPurch
Purch.Book = AnUnt.Book
Purch.DocNum = AnUnt.DocNum
  Sales documents SeekByDocNum AnUnt.BookType = eBookType.btSales
Sales.Book = AnUnt.Book
Sales.DocNum = AnUnt.DocNum
  Sundry documents SeekByDocNum AnUnt.BookType = eBookType.btSndry
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
  Country SeekByCode Country.CountryCode = Artcl.CountryCode
  General accounts SeekByAccNum Accnt.Number = Artcl.Account<type>
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtAlias
Lookup.Text = Artcl.Alias
      Lookup.TypeNum = eLookupType.ltArtCat<index>
Lookup.Text = Artcl.FreeCategory<index>
      Lookup.TypeNum = eLookupType.ltArtTotal
Lookup.Text = Artcl.TotalCode
      Lookup.TypeNum = eLookupType.ltArtSlsUnDscLng<index>
Lookup.Text = Artcl.SalesUnitDscLng<index>
      Lookup.TypeNum = eLookupType.ltArtPrcUnDscLng<index>
Lookup.Text = Artcl.PurchUnitDscLng<index>
      Lookup.TypeNum = eLookupType.ltArtStcUnDscLng<index>
Lookup.Text = Artcl.StockUnitDscLng<index>
      Lookup.TypeNum = eLookupType.ltArtText<index>
Lookup.Text = Artcl.Text<index>
  Supplements SeekByCode Spplm.Code = Artcl.SupplCode<index>
  Supplier SeekBySupNum Suppl.Number = Artcl.SupNumber
Article groups Lookup SeekByType Lookup.TypeNum = eLookupType.ltGrpText<index>
Lookup.Text = ArtGrp.Text<index>
Article locations Articles SeekByNumber Artcl.Number = ArtLoc.ArtNum
  Locations SeekByWarehouse Locat.Warehouse = ArtLoc.Warehouse
Locat.Code = ArtLoc.Location
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltALoText<index>
Lookup.Text = ArtLoc.Text<index>
Article suppliers Articles SeekByNumber Artcl.Number = ArtSup.ArtNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltAsuText<index>
Lookup.Text = ArtSup.Text<index>
  Supplier SeekBySupNum Suppl.Number = ArtSup.SupNum
Article warehouses Articles SeekByNumber Artcl.Number = ArtWrh.ArtNum
Balance General accounts SeekByAccNum Accnt.Number = Balan.Account
Book - -      
Commercial sales agreements Articles SeekByNumber Artcl.Number = ComAs.ArtNum
  Customer SeekByCstNum Custm.Number = ComAs.CstNum
Commodity codes - -      
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
      Lookup.TypeNum = eLookupType.ltCstAlias
Lookup.Text = Custm.Alias
      Lookup.TypeNum = eLookupType.ltCstClass
Lookup.Text = Custm.Class
      Lookup.TypeNum = eLookupType.ltCstGroup
Lookup.Text = Custm.Groupcode
      Lookup.TypeNum = eLookupType.ltCstPolitePhrase
Lookup.Text = Custm.PolitePhrase
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = Custm.Representative
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = Custm.Stat
      Lookup.TypeNum = eLookupType.ltCstText<index>
Lookup.Text = Custm.Text<index>
EdoWork - -      
Entry Financial documents SeekByBook Entry.BookType = eBookType.btFinan
Finan.Book = Entry.Book
Finan.DocNum = Entry.DocNum
      Entry.BookTypeOrg = eBookType.btFinan
Accounting year of Finan-object = Entry.AccYearOrg
Finan.Book = Entry.BookOrg
Finan.DocNum = Entry.DocNumOrg
  Purchase documents SeekByDocNum Entry.BookType = eBookType.btPurch
Purch.Book = Entry.Book
Purch.DocNum = Entry.DocNum
      Entry.BookTypeOrg = eBookType.btPurch
Accounting year of Purch-object = Entry.AccYearOrg
Purch.Book = Entry.BookOrg
Purch.DocNum = Entry.DocNumOrg
  Sales documents SeekByDocNum Entry.BookType = eBookType.btSales
Sales.Book = Entry.Book
Sales.DocNum = Entry.DocNum
      Entry.BookTypeOrg = eBookType.btSales
Accounting year of Sales-object = Entry.AccYearOrg
Sales.Book = Entry.BookOrg
Sales.DocNum = Entry.DocNumOrg
  Sundry documents SeekByDocNum Entry.BookType = eBookType.btSndry
Sndry.Book = Entry.Book
Sndry.DocNum = Entry.DocNum
      Entry.BookTypeOrg = eBookType.btSndry
Accounting year of Sndry-object = Entry.AccYearOrg
Sndry.Book = Entry.BookOrg
Sndry.DocNum = Entry.DocNumOrg
  Book SeekByCode Book.BookType = Entry.BookType
Book.Book = Entry.Book
      Book.BookType = Entry.BookTypeOrg
Book.Book = Entry.BookOrg
  General accounts SeekByAccNum Accnt.Number = Entry.Account
  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
      Lookup.TypeNum = eLookupType.ltFbkPolitePhrase
Lookup.Text = FBook.PolitePhrase
      Lookup.TypeNum = eLookupType.ltFbkText<index>
Lookup.Text = FBook.Text<index>
Financial documents Financial books SeekByCode FBook.Book = Finan.Book
  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
      AnaProp.AnaAccType = eAnaAccType.aatUnit
AnaProp.Code = Accnt.AnaPropCent
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltAccAlias
Lookup.Text = Accnt.Alias
      Lookup.TypeNum = eLookupType.ltAccText<index>
Lookup.Text = Accnt.Text<index>
Locations Lookup SeekByType Lookup.TypeNum = eLookupType.ltCircuitCode
Lookup.Text = Locat.CircuitCode
      Lookup.TypeNum = eLookupType.ltLocText<index>
Lookup.Text = Locat.Text<index>
Lookup - -      
Material assets cards Analytical accounting proposals SeekByCode AnaProp.AnaPropAccType = eAnaPropAccType.apatCent
AnaProp.Code = MaCrd.AnaPropCent
      AnaProp.AnaPropAccType = eAnaPropAccType.apatUnit
AnaProp.Code = MaCrd.AnaPropUnit
  Purchase documents SeekByDocNum Accounting year of Purch-object = MaCrd.AprAccYear
Purch.Book = MaCrd.AprBook
Purch.DocNum = MaCrd.AprDocNum
    SeekByDocNum Accounting year of Purch-object = MaCrd.CredAccYear
Purch.Book = MaCrd.CredBook
Purch.DocNum = MaCrd.CredDocNum
  Sales documents SeekByDocNum Accounting year of Sales-object = MaCrd.AslAccYear
Sales.Book = MaCrd.AslBook
Sales.DocNum = MaCrd.AslDocNum
  General accounts SeekByAccNum Accnt.Number = MaCrd.MasAcc
      Accnt.Number = MaCrd.DownAcc
      Accnt.Number = MaCrd.PlusAcc
      Accnt.Number = MaCrd.DeprAcc
      Accnt.Number = MaCrd.AslAcc
      Accnt.Number = MaCrd.NewMasAcc
      Accnt.Number = MaCrd.NewDownAcc
      Accnt.Number = MaCrd.NewPlusAcc
      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
      Country.CountryCode = PayWork.BenCountryCode
  Entry SeekBySysNum Entry.SysNum = PayWork.TickSysNum
  Financial books SeekByCode FBook.Book = PayWork.BankCode
  General accounts SeekByAccNum Accnt.Number = PayWork.Account
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltPpxGroupCode
Lookup.Text = PayWork.GroupCode
  Periodical payments SeekByCode PerPay.PerCode = PayWork.PerCode
Periodical payments Country SeekByCode Country.CountryCode = PerPay.BankCountryCode
      Country.CountryCode = PerPay.BenCountryCode
  Financial books SeekByCode FBook.Book = PerPay.BankCode
  General accounts SeekByAccNum Accnt.Number = PerPay.Account
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltPpxGroupCode
Lookup.Text = PerPay.GroupCode
Production documents Articles SeekByNumber Artcl.Number = Product.ArtNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltCphBook
Lookup.Text = Product.Book
      Lookup.TypeNum = eLookupType.ltCphText<index>
Lookup.Text = Product.Text<index>
  Production documents SeekBySysNum Accounting year of Product-object = Product.MainDocYear
Product.SysNum = Product.MainDocSysNum
  Sales order details SeekBySysNum Accounting year of SOrderDet-object = Product.TickYear
Product.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = Product.TickSysNum
Production document details Articles SeekByNumber Artcl.Number = ProductDet.ArtNum
      Artcl.Number = ProductDet.ArtNumStock
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltCphBook
Lookup.Text = ProductDet.Book
      Lookup.TypeNum = eLookupType.ltCpdText1
Lookup.Text = ProductDet.Text1
  Production documents SeekByBook Product.Book = ProductDet.Book
Product.DocNum = ProductDet.DocNum
Purchase deliveries Book SeekByCode Book.BookType = eBookType.btPurch
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
      Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = PDeliv.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = PDeliv.StatCode
      Lookup.TypeNum = eLookupType.ltPdhText<index>
Lookup.Text = PDeliv.Text<index>
  Supplier SeekBySupNum Suppl.Number = PDeliv.SupNum
Suppl.SubNumber = PDeliv.SupSubNum
    SeekBySysNum Suppl.SysNum = PDeliv.SysNumExtra
Purchase delivery details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = PDelivDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = PDelivDet.AnaUnit
  Articles SeekByNumber Artcl.Number = PDelivDet.ArtNum
      Artcl.Number = PDelivDet.ArtNumStock
  Book SeekByCode Book.BookType = eBookType.btPurch
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
PDelivDet.TickDocType = eTickDocType.tdtPOrder
POrderDet.SysNum = PDelivDet.TickSysNum
  Purchase delivery SeekByBook PDeliv.Book = PDelivDet.Book
PDeliv.DocNum = PDelivDet.DocNum
  Supplements SeekByCode Spplm.Code = PDelivDet.SupplCode<index>
  Supplier SeekBySupNum Suppl.Number = PDelivDet.SupNum
Suppl.SubNumber = PDelivDet.SupSubNum
Purchase documents Book SeekByCode Book.BookType = eBookType.btPurch
Book.Book = Purch.Book
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = Purch.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = Purch.StatCode
      Lookup.TypeNum = eLookupType.ltAprText<index>
Lookup.Text = Purch.Text<index>
  Purchase invoice SeekBySysNum PInvce.SysNum = Purch.SysNumIpr
  Supplier SeekBySupNum Suppl.Number = Purch.SupNum
Suppl.SubNumber = Purch.SupSubNum
Purchase invoices Book SeekByCode Book.BookType = eBookType.btPurch
Book.Book = PInvce.Book
  Customer SeekBySysNum Custm.SysNum = PInvce.SysNumDelivery
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = PInvce.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = PInvce.StatCode
      Lookup.TypeNum = eLookupType.ltPihText<index>
Lookup.Text = PInvce.Text<index>
  Supplier SeekBySupNum Suppl.Number = PInvce.SupNum
Suppl.SubNumber = PInvce.SupSubNum
    SeekBySysNum Suppl.SysNum = PInvce.SysNumExtra
Purchase invoice details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = PInvceDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = PInvceDet.AnaUnit
  Articles SeekByNumber Artcl.Number = PInvceDet.ArtNum
      Artcl.Number = PInvceDet.ArtNumStock
  Article group SeekByCode ArtGrp.Code = PInvceDet.GroupCode
  Book SeekByCode Book.BookType = eBookType.btPurch
Book.Book = PInvceDet.Book
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtCat<index>
Lookup.Text = PInvceDet.FreeCategory<index>
      Lookup.TypeNum = eLookupType.ltPidText
Lookup.Text = PInvceDet.Text1
      Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = PInvceDet.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = PInvceDet.Stat
      Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = PInvceDet.Class
  Purchase order details SeekBySysNum Accounting year of POrderDet-object = PInvceDet.TickYear
PInvceDet.TickDocType = eTickDocType.tdtPOrder
POrderDet.SysNum = PInvceDet.TickSysNum
  Purchase delivery details SeekBySysNum Accounting year of PDelivDet-object = PInvceDet.TickYear
PInvceDet.TickDocType = eTickDocType.tdtPDeliv
POrderDet.SysNum = PInvceDet.TickSysNum
  Purchase invoice SeekByBook PInvce.Book = PInvceDet.Book
PInvce.DocNum = PInvceDet.DocNum
  Supplements SeekByCode Spplm.Code = PInvceDet.SupplCode<index>
  Supplier SeekBySupNum Suppl.Number = PInvceDet.SupNum
Suppl.SubNumber = PInvceDet.SupSubNum
Purchase offers Book SeekByCode Book.BookType = eBookType.btPurch
Book.Book = POffer.Book
  Customer SeekBySysNum Custm.SysNum = POffer.SysNumDelivery
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = POffer.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = POffer.StatCode
      Lookup.TypeNum = eLookupType.ltPohText<index>
Lookup.Text = POffer.Text<index>
  Supplier SeekBySupNum Suppl.Number = POffer.SupNum
Suppl.SubNumber = POffer.SupSubNum
    SeekBySysNum Suppl.SysNum = POffer.SysNumExtra
      Suppl.SysNum = POffer.SysNumSup
Purchase orders Book SeekByCode Book.BookType = eBookType.btPurch
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
      Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = POrder.Class
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = POrder.StatCode
      Lookup.TypeNum = eLookupType.ltPrhText<index>
Lookup.Text = POrder.Text<index>
  Supplier SeekBySupNum Suppl.Number = POrder.SupNum
Suppl.SubNumber = POrder.SupSubNum
    SeekBySysNum Suppl.SysNum = POrder.SysNumExtra
Purchase order details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = POrderDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = POrderDet.AnaUnit
  Articles SeekByNumber Artcl.Number = POrderDet.ArtNum
      Artcl.Number = POrderDet.ArtNumStock
  Book SeekByCode Book.BookType = eBookType.btPurch
Book.Book = POrderDet.Book
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltPrdText
Lookup.Text = POrderDet.Text1
  Purchase order SeekByBook POrder.Book = POrderDet.Book
POrder.DocNum = POrderDet.DocNum
  Supplements SeekByCode Spplm.Code = POrderDet.SupplCode<index>
  Supplier SeekBySupNum Suppl.Number = POrderDet.SupNum
Suppl.SubNumber = POrderDet.SupSubNum
Exchange rates - -      
Sales deliveries Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SDeliv.Book
  Customer SeekByCstNum Custm.Number = SDeliv.CstNum
Custm.SubNumber = SDeliv.CstSubNum
    SeekBySysNum Custm.SysNum = SDeliv.SysNumDelivery
      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
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = SDeliv.Representative
      Lookup.TypeNum = eLookupType.ltInvShipmentMethod
Lookup.Text = SDeliv.ShipmentMethod
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = SDeliv.StatCode
      Lookup.TypeNum = eLookupType.ltSdhText<index>
Lookup.Text = SDeliv.Text<index>
Sales delivery details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = SDelivDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = SDelivDet.AnaUnit
  Articles SeekByNumber Artcl.Number = SDelivDet.ArtNum
      Artcl.Number = SDelivDet.ArtNumStock
  Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SDelivDet.Book
  Customer SeekByCstNum Custm.Number = SDelivDet.SupNum
Custm.SubNumber = SDelivDet.CstSubNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSddText
Lookup.Text = SDelivDet.Text1
  Sales delivery SeekByBook SDeliv.Book = SDelivDet.Book
SDeliv.DocNum = SDelivDet.DocNum
  Sales order details SeekBySysNum Accounting year of SOrderDet-object = SDelivDet.TickYear
SDelivDet.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = SDelivDet.TickSysNum
  Supplements SeekByCode Spplm.Code = SDelivDet.SupplCode<index>
Sales documents Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = Sales.Book
  Customer SeekByCstNum Custm.Number = Sales.CstNum
Custm.SupNumber = Sales.CstSubNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass
Lookup.Text = Sales.Class
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = Sales.StatCode
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = Sales.StatCode
      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
Book.Book = SInvce.Book
  Customer SeekByCstNum Custm.Number = SInvce.CstNum
Custm.SubNumber = SInvce.CstSubNum
    SeekBySysNum Custm.SysNum = SInvce.SysNumDelivery
      Custm.SysNum = SInvce.SysNumExtra
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass
Lookup.Text = SInvce.Class
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = SInvce.Representative
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = SInvce.StatCode
      Lookup.TypeNum = eLookupType.ltSihText<index>
Lookup.Text = SInvce.Text<index>
  Sales invoice SeekByBook Accounting year of SInvce-object = SInvce.RefYear
SInvce.Book = SInvce.RefBook
SInvce.DocNum = SInvce.RefDocNum
Sales invoice details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = SInvceDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = SInvceDet.AnaUnit
  Articles SeekByNumber Artcl.Number = SInvceDet.ArtNum
      Artcl.Number = SInvceDet.ArtNumStock
  Article group SeekByCode ArtGrp.Code = SInvceDet.GroupCode
  Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SInvceDet.Book
  Customer SeekByCstNum Custm.Number = SInvceDet.CstNum
Custm.SubNumber = SInvceDet.CstSubNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltArtCat<index>
Lookup.Text = SInvceDet.FreeCategory<index>
      Lookup.TypeNum = eLookupType.ltCstClass
Lookup.Text = SInvceDet.Class
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = SInvceDet.Representative
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = SInvceDet.Stat
      Lookup.TypeNum = eLookupType.ltSidText
Lookup.Text = SInvceDet.Text1
  Sales delivery details SeekBySysNum Accounting year of SDelivDet-object = SInvceDet.TickYear
SInvceDet.TickDocType = eTickDocType.tdtSDeliv
SOrderDet.SysNum = SInvceDet.TickSysNum
  Sales invoice SeekByBook SInvce.Book = SInvceDet.Book
SInvce.DocNum = SInvceDet.DocNum
  Sales order details SeekBySysNum Accounting year of SOrderDet-object = SInvceDet.TickYear
SInvceDet.TickDocType = eTickDocType.tdtSOrder
SOrderDet.SysNum = SInvceDet.TickSysNum
  Supplements SeekByCode Spplm.Code = SInvceDet.SupplCode<index>
Sales offers Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SOffer.Book
  Customer SeekByCstNum Custm.Number = SOffer.CstNum
Custm.SubNumber = SOffer.CstSubNum
    SeekBySysNum Custm.SysNum = SOffer.SysNumCst
      Custm.SysNum = SOffer.SysNumDelivery
      Custm.SysNum = SOffer.SysNumExtra
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltCstClass
Lookup.Text = SOffer.Class
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = SOffer.Representative
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = SOffer.StatCode
      Lookup.TypeNum = eLookupType.ltSohText<index>
Lookup.Text = SOffer.Text<index>
Sales offer details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = SOfferDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = SOfferDet.AnaUnit
  Articles SeekByNumber Artcl.Number = SOfferDet.ArtNum
  Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SOfferDet.Book
      Lookup.TypeNum = eLookupType.ltSodText
Lookup.Text = SOfferDet.Text1
  Sales offer SeekByBook SOffer.Book = SOfferDet.Book
SOffer.DocNum = SOfferDet.DocNum
  Supplements SeekByCode Spplm.Code = SInvceDet.SupplCode<index>
Sales orders Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SOrder.Book
  Customer SeekByCstNum Custm.Number = SOrder.CstNum
Custm.SubNumber = SOrder.CstSubNum
    SeekBySysNum Custm.SysNum = SOrder.SysNumDelivery
      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
      Lookup.TypeNum = eLookupType.ltCstRepresentative
Lookup.Text = SOrder.Representative
      Lookup.TypeNum = eLookupType.ltInvShipmentMethod
Lookup.Text = SOrder.ShipmentMethod
      Lookup.TypeNum = eLookupType.ltCstStat
Lookup.Text = SOrder.StatCode
      Lookup.TypeNum = eLookupType.ltSrhText<index>
Lookup.Text = SOrder.Text<index>
Sales order details Analytical accounts SeekByCode AnAcc.AnaAccType = eAnaAccType.aatCent
AnAcc.Code = SOrderDet.AnaCentre
      AnAcc.AnaAccType = eAnaAccType.aatUnit
AnAcc.Code = SOrderDet.AnaUnit
  Articles SeekByNumber Artcl.Number = SOrderDet.ArtNum
      Artcl.Number = SOrderDet.ArtNumStock
  Book SeekByCode Book.BookType = eBookType.btSales
Book.Book = SOrderDet.Book
  Customer SeekByCstNum Custm.Number = SOrderDet.CstNum
Custm.SubNumber = SOrderDet.CstSubNum
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSrdText
Lookup.Text = SOrderDet.Text1
  Sales order SeekByBook SOrder.Book = SOrderDet.Book
SOrder.DocNum = SOrderDet.DocNum
  Supplements SeekByCode Spplm.Code = SOrderDet.SupplCode<index>
Serial numbers Articles SeekByNumber Artcl.Number = ArtSrl.ArtNum
  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
Lookup.Text = StockDoc.Book
      Lookup.TypeNum = eLookupType.ltSthText<index>
Lookup.Text = StockDoc.Text<index>
Stock document details Articles SeekByNumber Artcl.Number = StockDocDet.ArtNum
Artcl.Number = StockDocDet.ArtNumStock
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltStcBook
Lookup.Text = StockDocDet.Book
      Lookup.TypeNum = eLookupType.ltStdText
Lookup.Text = StockDocDet.Text1
  Stock document SeekByBook StockDoc.Book = StockDocDet.Book
StockDoc.DocNum = StockDocDet.DocNum
Sundry documents Book SeekByCode Book.BookType = eBookType.btSundry
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
      Country.CountryCode = Suppl.CountryCode
  General accounts SeekByAccNum Accnt.Number = Suppl.AltAccount
  Lookup SeekByType Lookup.TypeNum = eLookupType.ltSupAddressForm
Lookup.Text = Suppl.AddressForm
      Lookup.TypeNum = eLookupType.ltSupAlias
Lookup.Text = Suppl.Alias
      Lookup.TypeNum = eLookupType.ltSupClass
Lookup.Text = Suppl.Class
      Lookup.TypeNum = eLookupType.ltSupGroup
Lookup.Text = Suppl.Groupcode
      Lookup.TypeNum = eLookupType.ltSupPolitePhrase
Lookup.Text = Suppl.PolitePhrase
      Lookup.TypeNum = eLookupType.ltSupStat
Lookup.Text = Suppl.Stat
      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>