Table Data dictionary report - payment_methods

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

Table for Payment Methods

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('payment_methods_id_seq'::regclass) Unique identifier
code character varying(10) Yes No User set payment code
description character varying(60) Yes No Payment description
payment_type character varying(1) Yes No Payment type; C = Cash D = Debit O = Other Q - Cheque R = Credit Card
account_no character varying(24) Yes No General Ledger Account number to post
display boolean Yes No Display payment method in payment dialog; FALSE = No TRUE = Yes
sequence smallint No No Sequence to display in payment dialog; 1 = at the top 99 = at the bottom
icon character varying(30) No No Icon selected to display in payment dialog
_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
shortcut character varying(12) No No Keyboard shortcut for payment method
integrated boolean Yes No false Integration flag for payment gateway; FALSE = No TRUE = Yes

Constraints

Name Type Definition Comment
payment_methods_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL