Table Data dictionary report - inventory_counts

Generated: 2018-10-18 6:23:32 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Inventory Count batches

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('inventory_counts_id_seq'::regclass) Unique identifier
count_no character varying(10) Yes No Batch number for this Inventory Count
start_date date No No Start date for count
finish_date date No No Finish date for count
total_unit_variance numeric(15,5) No No Total variance quantity for this batch
total_gain_loss numeric(15,5) No No The total amount of loss (negative) or gain for this batch
location character varying(24) No No General Ledger Location segment of the warehouse for companies using Location accounting
posted boolean Yes No false Batch posted flag; FALSE = No TRUE = Yes
trans_no character varying(10) No No General Ledger transaction number for posting
notes text No No User added notes for this batch
_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

Constraints

Name Type Definition Comment
inventory_counts_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL