Table Data dictionary report - ar_transaction_links

Generated: 2018-10-17 7:32:11 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table to link Accounts Receivable Credit transactions to Debit transactions

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('ar_transaction_links_id_seq'::regclass) Unique identifier
debit_id integer No No Debit record identifier - links to ar_transactions.id
credit_id integer No No Credit record identifier - links to ar_transactions.id
applied_date date No No Apply date used
applied_amt numeric(15,2) No No Apply amount
_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 record was last modified
_modified_by character varying(3) No No User initials that last modified this record
folio character varying(32) No No Folio value to group tranasactions that were selected by the user during a session

Constraints

Name Type Definition Comment
ar_transaction_links_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL