Table Data dictionary report - sales_order_batches

Generated: 9/23/2016 3:04:20 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public


Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('sales_order_batches_id_seq'::regclass)
batch_no bigint No No Batch number
type character varying(1) No No I = Invoice O = Order
record_no character varying(10) No No Invoice number
status character varying(1) No No C = Closed O= Open
division character varying(3) No No Division payment posted to
gl_trans_no character varying(10) No No GL transaction number
create_user character varying(3) No No User initials that created payment
post_user character varying(3) No No User that posted payment
location character varying(24) No No Location - (if using Spire's location accounting)
profit_centre character varying(24) No No Profit center if using Spire's profit centers.
create_date timestamp without time zone No No Date created
post_date timestamp without time zone No No Date posted


Name Type Definition Comment
bve_batch_pkey Primary key (id)

Report generated by pgAdmin III