Table Data dictionary report - sales_order_payments

Generated: 9/23/2016 3:06:03 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('sales_order_payments_id_seq'::regclass)
order_no character varying(10) No No Order number
sequence smallint No No Sequence starting from 1 to number of payments
payment_method smallint No No Payment method from 1 - 8
currency character varying(3) Yes No ''::character varying Currency of payment
division character varying(3) Yes No ''::character varying Division of payment
gl_account character varying(24) Yes No ''::character varying GL account for payment
amount numeric(15,2) Yes No Amount of payment
auth_code character varying(20) No No Credit card authorization
ccard_postal_code character varying(16) No No Credit card postal code
cust_no character varying(20) No No Customer number
payment_date date No No Payment date
layaway_flag boolean No No Is this a deposit on sale order TRUE = Yes FALSE = No
trans_no character varying(10) No No GL transaction number for payment
_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_order_pmt_pkey Primary key (id)
sales_order_payments_order_no_sequence_key Unique (order_no, sequence) DEFERRABLE INITIALLY IMMEDIATE

Report generated by pgAdmin III