Skip to Content
Former Member
Jan 30, 2007 at 05:33 PM

I want the table names for these fields


Customer ID.

Material Number

Cross company Purchase Order.

Delivery date (requested by the company who is placing the purchase order).

Qty requested.

Value of the Qty requested (Value of the Qty requested = Qty requested * Material unit price )


Total pieces shipped (during the time frame set on the report)

Balance Left ( Balance Left = Qty Requested - Total pieces shipped)

Value of the balance left Value of the balance left = Balance left * Unit price only if the Balance left is greater than cero,

if the balance left is lower than or equals cero, the value of the balance left show be cero.

% Delivery (% Delivery = Total pieces shipped / Qty requested).