Purchase Order Lines

Back to list of main tables

Field name Description Type Indexed
batch Alpha
comment Text
cost_from_invoice Real
cost_local Real
delivery_date_expected Date
delivery_date_requested Date
expiry Date
ID The ID of purchase order line Long*
item_ID The item_ID of purchase order line Long*
item_name The item name of the related item name Alpha
line_number Long
location_ID Long
manufacturer_ID Long
non_stock_name_ID Long
note Text
note_has_been_actioned Boolean
note_show_on_goods_rec Boolean
pack_units Alpha
packsize_ordered Real
price_expected_after_discount Real
price_extension_before_discount Real
price_extension_expected Real
purchase_order_ID Long*
quan_adjusted_order Real
quan_original_order Real
quan_rec_to_date Real
quote_line_ID Long
spare_estmated_cost Real
store_ID Long*
supplier_code Alpha
volume_per_pack Real