Table Data dictionary report - gl_recurring_pending

Generated: 2018-10-17 1:09:44 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Recurring transactions

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('gl_recurring_pending_id_seq'::regclass) Unique identifier
temp character varying(6) No No Recurring transaction template number - links to gl_recuring_transactions.template_temp
rjep_date date No No Planned post date for Open transaction
status character varying(1) No No Record status; C = Closed or Posted O = Open or unposted
post_date date No No Posted date for closed transactions
folio character varying(10) No No Transaction number of posted transaction
mc_revise character varying(1) No No Not used

Constraints

Name Type Definition Comment
recurring_pending_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL