Table Data dictionary report - purchase_order_items

Generated: 11/29/2017 8:26:00 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: inspire_health_2_7
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('purchase_order_items_id_seq'::regclass)
po_number character varying(10) No No Purchase order number
sequence smallint No No Sequence number starting at 0
whse character varying(6) No No Warehouse of the item
part_no character varying(34) No No Paret number of the item
description character varying(80) No No Description of the item
product_code character varying(10) No No Product code of the item
uom_purchase character varying(10) No No Purchase unit of measure
uom_inventory character varying(10) No No Inventory or stocking unit of measure
uom_sales character varying(10) No No Sales unit of measure
order_qty numeric(15,5) No No 0 Quantity ordered
received_qty numeric(15,5) No No 0 Quantity received to date
inventory_order_qty numeric(15,5) No No 0 Order quantity after unit of measure conversion
inventory_received_qty numeric(15,5) No No 0 Inventory received after unit of measure conversion
last_received_qty numeric(15,5) No No 0 Last quantity received
serialized_qty numeric(11) No No 0 Serialized quantity received
retail_price numeric(15,5) No No 0 Regular cost of item
unit_price numeric(15,5) No No 0 Cost of item after line discount
status smallint No No
whse_location character varying(20) No No Item's location in warehouse
vendor_part_no character varying(34) No No Vendor part number
guid character varying(32) No No GUID linking to sales and production orders
item_type smallint No No 1 - Physical Inventory 2 - Misc item, not in inventory 3 - Comment line 4 - Serialized or Lot Numbered 5 - Non Physical Inventory
last_received_date date No No Last date line received
required_date date No No Line required date
comment text No No Comment
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
reference character varying(20) No No Line reference number
date date No No
receive_qty numeric(11,3) No No 0 Receive quantity before posting
inventory_receive_qty numeric(11,3) No No 0 Quantity received after unit of measure conversion and before posting
duty_by_pct boolean No No false Calculate duty by percentage TRUE = Yes FALSE = No
duty_rate numeric(5,2) No No 0 Duty percentage
duty_amount numeric(15,5) No No 0 Duty amount
freight_by_pct boolean No No false Calculate freight by percentage TRUE = Yes FALSE = No
freight_rate numeric(5,2) No No 0 Freight percentage
freight_amount numeric(15,5) No No 0 Freight amount
gl_account character varying(24) No No GL account to post receipt to. Default it comes from sales dept but is editable by user with correct rights
sell_price numeric(15,5) No No 0 Sell price 1
user_sell_price boolean No No false Did user edit sell price TRUE = Yes FALSE = No
pack_size numeric(9,3) No No 0 Normal pack size
requisition_no character varying(10) No No Requisition number
employee character varying(6) No No Employee code added by user
ship_to character varying(20) No No Ship to as entered by user
job_no character varying(10) No No Job number
job_acct character varying(10) No No Job Account
weight numeric(15,2) No No 0 Line weight
tax_applicable boolean[] Yes No '{f,f,f,f}'::boolean[] Array field containing tax applicable flags t = Yes f = No
vendor_price_id integer No No
udf_data hstore No No ''::hstore hstore field containing user defined data
discountable boolean No No
line_disc numeric(5,2) Yes No Line discount percentage
line_disc_amt numeric(15,2) Yes No Line discount amount

Constraints

Name Type Definition Comment
purchase_order_dtail_pkey Primary key (id)
purchase_order_items_vendor_price_id_fkey Foreign key (vendor_price_id) REFERENCES vendor_pricing (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
purchase_order_items_po_number_sequence_key Unique (po_number, sequence) DEFERRABLE INITIALLY IMMEDIATE

Report generated by pgAdmin III