Purchase Orders

Back to list of main tables

Field name	Description	Type	Indexed
additional_instructions	Text
agent_commission	Real
auth_checksum	Text
authorizing_officer_1	Text
authorizing_officer_2	Text
budget_period_ID	Long
category_ID	Long	*
colour	Long
comment	Text
communications_charge	Real
confirm_date	Date
cost_in_local_currency	Real
created_by	Long
creation_date	Date
curr_rate	Real
currency_ID	Alpha
Date_advance_payment	Date
Date_contract_signed	Date
Date_goods_received_at_port	Date
delivery_method	Text
document_charge	Real
donor_id	Long
editedRemotely	Boolean
freight	Real
freight_charge	Real
freight_conditions	Text
heading_message	Text
ID	Unique identifier of this record	Long	*
include_in_on_order_calcs	Boolean
insurance_charge	Real
inv_discount_amount	Real
inv_sub_total	Real
is_authorised	Boolean
last_edited_by	Long
lines	Long
locked	Boolean
name_ID	The unique ID of the supplier to whom this PO is sent	Long	*
Order_total_after_discount	Real
Order_total_before_discount	Real
po_sent_date	Date
quote_ID	Long
reference	Alpha
requested_delivery_date	Date
status	When created: SG When send to supplier: CN When finished receiving: FN	Alpha
store_ID	Long
supplier_agent	Text
supplier_discount_amount	Real
target_months	The number of days targeted when quantities were auto-generated	Real
total_foreign_currency_expected	Real
total_local_currency_expected	Real
user_field_1	Alpha
user_field_2	Alpha

History

v3.1: target_days (long) changed to target_months (real)