Friday, June 10, 2016

Dynamics SL - Tables

  • https://mbs.microsoft.com/partnersource/global/deployment/documentation/how-to-articles/MSDYN_ReportAssistantsSL2011

  • Accounts
    • Account
    • SubAcct
    • vs_acctsub (view)
    • AcctHist - Account transaction history
      • select distinct acct, sub, fiscyr from accthist
        where fiscyr >= 2012
  • Vendors
    • Vendor
    • Class - VendClass
  • Vendor Balances
    • vr_03680VendorDetail (view)
  • Purchasing
    • PurchOrd - PO Hdr
    • PurOrdDet - PO Lines
    • PORct - Receipts
    • POTran - Receipt Lines
  • Customers
    • Customer
    • Class - CustClass
  • Items
    • Inventory
    • Units of Measure - INUnit
    • Sites - Site
    • Item Class - ProductClass
    • Item Qty - Location
    • Bins - vp_DfltSiteBins
    • Item Prices - Inventory

No comments:

Post a Comment