Table Data dictionary report - purchase_history_items

Generated: 2018-10-18 7:33:43 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for items on closed Purchase Orders

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('purchase_history_items_id_seq'::regclass) Unique identifier
po_number character varying(10) No No Purchase Order number
sequence smallint No No Sequential number for order line
whse character varying(6) No No Inventory warehouse for this record - links to inventory.whse
part_no character varying(34) No No Inventory part number for this record - links to inventory.part_no
description character varying(80) No No Description of item
product_code character varying(10) No No Product Code assigned to the item - links to inventory_product_codes.product_code
uom_purchase character varying(10) No No Purchase unit of measure - links to inventory_uoms
uom_inventory character varying(10) No No Inventory unit of measure - links to inventory_uoms
uom_sales character varying(10) No No Sales unit of measure - links to inventory_uoms
order_qty numeric(15,5) No No Quantity ordered
received_qty numeric(15,5) No No Quantity received
inventory_order_qty numeric(15,5) No No Quantity ordered converted to Inventory unit of measure
inventory_received_qty numeric(15,5) No No Quantity received converted to Inventory unit of measure
last_received_qty numeric(15,5) No No Last received quantity
serialized_qty numeric(11) No No Serialized quantity received
retail_price numeric(15,5) No No Price before line discount
unit_price numeric(15,5) No No Price after line discount
status smallint No No Pricing status; 0 = price taken from Inventory current cost 5 = Vendor Price used 9 = user typed price
whse_location character varying(20) No No Physical location in warehouse for item
vendor_part_no character varying(34) No No Vendor part number from Vendor Price table
guid character varying(32) No No Unique identifier for linking to other tables; inventory_serial_transactions.link_guid inventory_receipts.link_guid inventory_requisitions_targ_guid purchase_receipts.guid
item_type smallint No No Item record type for this line; 1 = Inventory item 2 = Non Inventory item 3 = Comment 4 = Serial/Lot numbered item 5 = Non Physical item
last_received_date date No No Date Purchase Order line was last received
required_date date No No Required date for this item
comment text No No Comment on line
_dbversion integer No No Program version that last modified this record
_created timestamp without time zone No No UTC Date and time record was created
_created_by character varying(3) No No User initials that created this record
_modified timestamp without time zone No No UTC Date and time this record was last modified
_modified_by character varying(3) No No User initials that last modified this record
reference character varying(20) No No Reference number on the line
src_type character varying(4) No No Source type from Requisition; INV = Inventory SORD = Sales Order BORD = Production Order
src_no character varying(40) No No Source Sales Order number or Production Order number from Requisition
src_cust_no character varying(20) No No Source Customer number from Requisition
employee character varying(6) No No Employee code added by user - links to employees.employee_no
weight numeric(15,2) No No 0 Weight per each of order quantity of the item
job_no character varying(10) No No Job cost number - links to jobs.job_no
job_acct character varying(10) No No Job cost account number - links to jobs.account
template_no character varying(10) No No Not used
template_guid character varying(32) No No Not used
revision character varying(8) No No Not used
tax_applicable boolean[] Yes No '{f,f,f,f}'::boolean[] Tax 1 - 4 applicable flags; False = No True = Yes
udf_data hstore No No ''::hstore User defined data for this record
discountable boolean No No Discountable flag; FALSE = No TRUE = Yes
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_history_dtl_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL