Table Data dictionary report - ap_transaction_links

Generated: 9/23/2016 2:26:14 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('ap_transaction_links_id_seq'::regclass)
debit_id integer No No The ID number in ap_transactions table that this links with
credit_id integer No No The ID number in ap_transactions table that this links with
applied_date date No No Date this transaction was applied
applied_amt numeric(15,2) No No Amount that was applied
_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
folio character varying(32) No No

Constraints

Name Type Definition Comment
ap_transaction_links_pkey Primary key (id)

Report generated by pgAdmin III