Table Data dictionary report - inventory_adjustments

Generated: 9/23/2016 2:43:17 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_adjustments_id_seq'::regclass)
adjustment_no character varying(10) No No Adjustment number. Links to inventory_adjustment_items.adjustment_no
adjustment_mode smallint No No Adjustment mode 1 = Adjustment 3 = Transfer
src_whse character varying(6) No No Source warehouse. For adjustment this will be the same as inventory_adjustments.dst_whse. For transfers they must be different
src_location character varying(24) No No Source locaton for the adjustment. This is the source from when the company is set as multi location accounting. Not to be confused with warehouse location.
dst_whse character varying(6) No No Destination warehouse for a transfer
dst_location character varying(24) No No Destination locaton for the adjustment. This is the destinaton from when the company is set as multi location accounting. Not to be confused with warehouse location.
division character varying(3) No No Division that this trnasfer is to be posted to. If divisions are not turned on this wil always be 000
currency character varying(3) No No
date date No No Date the adjustment transaction is to be posted to.
po_number character varying(10) No No
vendor_no character varying(20) No No
markup_pct numeric(9,2) No No Markup percentage to be added to the transfer. If added to the header this will get added to each line of the transfer by default
required_date date No No
received_date date No No
_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

Constraints

Name Type Definition Comment
bve_inv_adj_pkey Primary key (id)

Report generated by pgAdmin III