Table Naming Standard

[Zirak]

Hi,
I'm designing a data model for a Purchasign/Receiving system. When an item is received, I want to capture the info. My problem is that I don't know what to call the Receiving table, since we can't have a verb for a table name.
The only thing I can think of is tblItemReceived.

I was wondering what is the industry standard for such a table.

Thanks

 

[johnherman]

Receipts, Warehouse, Inventory, etc.
There is no "standard". What do your users call the stuff they purchase from vendors? Purchases? Supplies? Materials?

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[Zirak]

Thanks

 

[MDXer]

Just becareful in What standards you do settle on as what may seem to make sense at the time can be a real issue to others. Example I am currently building a warehouse for a POS system. Some Of the tables that are supposed to represent Cumulative amounts have been abbreviated so they have tables such as Emp_Check_Cum_BD, which has caused some embarassment when making presentation to females or females making the presentation.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Craig0201]

Zirak,

Received items are surely items which have a purchase order line associated with them? A column in the PO line for quantity received would solve this.

I have large experience with Oracle Financials and this is the approach that they take. They additionally have a column for quantity cancelled.

Craig

 

[johnherman]

Craig -
What about multiple shipments/receipts for one PO, items or partial quantities on backorder? Nope, I think it's a separate table, at least from a pure design point of view. Looks like a design flaw in Oracle Financials.
- John

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[Craig0201]

Not at all.

You have a table to hold the receipts. I was simplifying the situation to make it easily understandable in 2 sentences.

A PO has 1 header. For each header there can be many lines. For each line, there can be many requested deliveries. For each delivery there can be many distributions (internal deliveries).

For a receipt, there is a header and lines. Each receipt line can map to 1 or more of lines or 1 or more deliveries.

Craig

 

[johnherman]

Whew !
I was really hoping someone with the credentials of an Oracle had gotten something as basic as that concept correct.



Sometimes the grass is greener on the other side because there is more manure there - original.