Delivery Type

Kinetic ERP
1

I just noticed (or it is new) that there is a Delivery Type setup table under Shipping/Receiving-Setup. It only contains 2 fields but I cannot find where it is used. I checked the headers of all Shipping/Receiving records. I’m completely stumped.

Two questions:

  1. Can anyone find where this is being used?
  2. Is this a new table or one I have completely missed for years?
1 Like
2

Looks like Delivery Type is on the Customer table… but can’t find it on the form anywhere.

Also on ShipHead.

1 Like
3

Thanks for tracking that down. How’d you do it? If I were on prem, I would do a SQL query. I’m interested in how you figured out a way.
Answer Me Canadian GIF by CBC

4

ummm… blind luck?

Saw Delivery Type menu was under shipping and receiving…

I had my BAQ designer open, so I just started click on tables that had to deal with “deliveries” and looking to see where it would show up:

image
image869×104 3.69 KB

But again, I checked Customer and Customer Shipment Entry… even used 2024.1’s new fancy field search box, and “Delivery Type” doesn’t show up. So, I have to assume this is either OLD stuff that isn’t used anymore… or NEW stuff that hasn’t been fully implemented? The table columns are there, just not on the published forms.

5

Excited Season 4 GIF by The Office

1 Like
6

I was hoping for something like you can do in a SQL Query by searching for column names, but I will take your way and steal it.

Now, if only someone knew more about the table… @timshuwy ?

7

Not That Smart GIFs - Find & Share on GIPHY

8

The table Ice.ColumnAttribute contains fields like SchemaName, TableName, and ColumnName. A BAQ over it filtering over SchemaName and ColumnName returns this:

image
image790×422 7.33 KB

4 Likes
9

Awesome tip! Thanks @GThom

10

Beautiful!!

The question I have to ask myself is…

Would You Remember This Tomorrow GIFs - Find & Share on GIPHY

1 Like