Table Data dictionary report - ar_batch_items

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

Table for saved Accounts Receivable payment batch items

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('ar_batch_items_id_seq'::regclass) Unique identifier
batch_id integer No No Batch identifier - links to ar_batches.id
transaction_id integer No No Accounts Receivable transaction identifier - links to ar_transactions.id
pay boolean No No Pay flag; FALSE = No TRUE = Yes
give_discount boolean No No Discount flag; FALSE = No TRUE = Yes
discount numeric(15,2) No No Discount amount
total numeric(15,2) No No Total payment
_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 modified this record
reference_no character varying(25) No No Reference number

Constraints

Name Type Definition Comment
ar_batch_items_pkey Primary key (id)
ar_batch_items_batch_id_fkey Foreign key (batch_id) REFERENCES public.ar_batches (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION

Report generated by pgAdmin3 LTS by BigSQL