In How many tables field linked?

upasanisandip · 2006-08-17

HI all,
I want to check the field of item table (27) "No." linked in how many tables.
Is there any easy method or I have to manually go to every table for this?

Any suggessitions , hints are welcome.

Thanks,
Sandip.

kine · 2006-08-17

1) Many :-)
2) You can use NDT (Navision Developer Toolkit) to find where the field is used. Search for NDT for more info...

johnson_alonso · 2006-08-17

I think it maybe delevper toolkit. because I have ever asked in this forum about discrete quantity field use in the item table,and ara3n told he used developer toolkit to check the field link to where...

Rgds,
Johnson

mgill · 2006-08-18

Epxort all the objects in NDT,right click the field in that the item table and click the "Where Used" option,it will tell wherever that field is used in all the objects or u can also filter to find the field usage in tables

ara3n · 2006-08-18

Here it is.

    + Table 30 Item Translation
    + Table 32 Item Ledger Entry
    + Table 37 Sales Line
    + Table 39 Purchase Line
    + Table 83 Item Journal Line
    + Table 89 BOM Journal Line
    + Table 90 BOM Component
    + Table 97 Comment Line
    + Table 99 Item Vendor
    + Table 111 Sales Shipment Line
    + Table 113 Sales Invoice Line
    + Table 115 Sales Cr.Memo Line
    + Table 121 Purch. Rcpt. Line
    + Table 123 Purch. Inv. Line
    + Table 125 Purch. Cr. Memo Line
    + Table 168 Job Budget Line
    + Table 169 Job Ledger Entry
    + Table 171 Standard Sales Line
    + Table 174 Standard Purchase Line
    + Table 210 Job Journal Line
    + Table 211 Job Budget Entry
    + Table 246 Requisition Line
    + Table 263 Intrastat Jnl. Line
    + Table 268 Item Amount
    + Table 279 Extended Text Header
    + Table 280 Extended Text Line
    + Table 281 Phys. Inventory Ledger Entry
    + Table 307 Inventory Buffer
    + Table 336 Tracking Specification
    + Table 337 Reservation Entry
    + Table 352 Default Dimension
    + Table 427 IC Outbox Sales Line
    + Table 429 IC Outbox Purchase Line
    + Table 431 Handled IC Outbox Sales Line
    + Table 433 Handled IC Outbox Purch. Line
    + Table 435 IC Inbox Sales Line
    + Table 437 IC Inbox Purchase Line
    + Table 439 Handled IC Inbox Sales Line
    + Table 441 Handled IC Inbox Purch. Line
    + Table 753 Standard Item Journal Line
    + Table 5108 Sales Line Archive
    + Table 5110 Purchase Line Archive
    + Table 5401 Item Variant
    + Table 5404 Item Unit of Measure
    + Table 5405 Production Order
    + Table 5406 Prod. Order Line
    + Table 5407 Prod. Order Component
    + Table 5430 Planning Error Log
    + Table 5700 Stockkeeping Unit
    + Table 5701 Stockkeeping Unit Comment Line
    + Table 5715 Item Substitution
    + Table 5716 Substitution Condition
    + Table 5717 Item Cross Reference
    + Table 5718 Nonstock Item
    + Table 5741 Transfer Line
    + Table 5745 Transfer Shipment Line
    + Table 5747 Transfer Receipt Line
    + Table 5765 Warehouse Request
    + Table 5766 Warehouse Activity Header
    + Table 5767 Warehouse Activity Line
    + Table 5768 Whse. Cross-Dock Opportunity
    + Table 5771 Warehouse Source Filter
    + Table 5773 Registered Whse. Activity Line
    + Table 5802 Value Entry
    + Table 5803 Item Journal Buffer
    + Table 5804 Avg. Cost Adjmt. Entry Point
    + Table 5805 Item Charge Assignment (Purch)
    + Table 5809 Item Charge Assignment (Sales)
    + Table 5821 Item Statistics Buffer
    + Table 5832 Capacity Ledger Entry
    + Table 5841 Standard Cost Worksheet
    + Table 5902 Service Invoice Line
    + Table 5907 Service Ledger Entry
    + Table 5908 Warranty Ledger Entry
    + Table 5913 Loaner
    + Table 5931 Posted Service Item Line
    + Table 5932 Posted Service Invoice Line
    + Table 5940 Service Item
    + Table 5941 Service Item Component
    + Table 5943 Troubleshooting Header
    + Table 5945 Troubleshooting Setup
    + Table 5964 Service Contract Line
    + Table 5965 Service Contract Header
    + Table 5971 Filed Contract Line
    + Table 6083 Serv. Price Adjustment Detail
    + Table 6084 Serv. Inv. Line Price Adjmt.
    + Table 6241 Reverse Auction Header
    + Table 6502 Item Tracking Code
    + Table 6504 Serial No. Information
    + Table 6505 Lot No. Information
    + Table 6506 Item Tracking Comment
    + Table 6550 Whse. Item Tracking Line
    + Table 6651 Return Shipment Line
    + Table 6661 Return Receipt Line
    + Table 7002 Sales Price
    + Table 7004 Sales Line Discount
    + Table 7012 Purchase Price
    + Table 7014 Purchase Line Discount
    + Table 7023 Sales Price Worksheet
    + Table 7114 Analysis Line
    + Table 7134 Item Budget Entry
    + Table 7136 Item Budget Buffer
    + Table 7152 Item Analysis View
    + Table 7154 Item Analysis View Entry
    + Table 7156 Item Analysis View Budg. Entry
    + Table 7190 Sales Shipment Buffer
    + Table 7302 Bin Content
    + Table 7311 Warehouse Journal Line
    + Table 7312 Warehouse Entry
    + Table 7317 Warehouse Receipt Line
    + Table 7319 Posted Whse. Receipt Line
    + Table 7321 Warehouse Shipment Line
    + Table 7323 Posted Whse. Shipment Line
    + Table 7326 Whse. Worksheet Line
    + Table 7330 Bin Content Buffer
    + Table 7332 Whse. Internal Put-away Line
    + Table 7334 Whse. Internal Pick Line
    + Table 7338 Bin Creation Worksheet Line
    + Table 7340 Posted Invt. Put-away Header
    + Table 7341 Posted Invt. Put-away Line
    + Table 7342 Posted Invt. Pick Header
    + Table 7343 Posted Invt. Pick Line
    + Table 7354 Bin
    + Table 7380 Phys. Invt. Item Selection
    + Table 7704 Item Identifier
    + Table 99000758 Machine Center
    + Table 99000763 Routing Header
    + Table 99000771 Production BOM Header
    + Table 99000772 Production BOM Line
    + Table 99000774 Family Line
    + Table 99000788 Production Matrix BOM Line
    + Table 99000789 Production Matrix  BOM Entry
    + Table 99000790 Where-Used Line
    + Table 99000799 Order Tracking Entry
    + Table 99000800 Sales Planning Line
    + Table 99000829 Planning Component
    + Table 99000846 Planning Buffer
    + Table 99000849 Action Message Entry
    + Table 99000850 Planning Assignment
    + Table 99000852 Production Forecast Entry
    + Table 99000853 Inventory Profile
    + Table 99000880 Order Promising Line
    + Table 99008533 BizTalk Reservation Entry

johnson_alonso · 2006-08-18

Hi Ara3n,
It's nice to see the answer from you.

I think the answer only developer toolkit but the result/answer is now available.

Rgds,
Johnson

Kowa · 2006-08-18

It is best to use the NDT on the database in question as there can always be additonal tables in a localized database as well as tables created due to customization.

jjanauskas · 2006-08-18

As far as I remember, Navision has a system table called 'Field', which contains ALL fields in database.

I cannot access Navision at the moment, but as far as I remember, in this table there are some fields related with table relationship.

So, the easest way would be just filter this table by your needs. But don't forget that in such case you will only know the other fields in DB which are related to the one you are interested. And if you want to know the places your field is used in source code, so use NDT

ara3n · 2006-08-18

the related field only filled in for simple relationship. For complicated relationship the field is empty.

Howdy, Stranger!

Quick Links

Categories

In How many tables field linked?

Comments