Table Data dictionary report - gl_recurring_transactions

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

Table of Templates defining Recurring transactions

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('gl_recurring_transactions_id_seq'::regclass) Unique identifier
template_temp character varying(6) No No Template number - links to gl_recurring_pending.temp
template_desc character varying(60) No No Template description
template_freq character varying(1) No No Template frequency; 2 = Bi-Monthly A = Annual B = Bi-Weekly D = Daily F = Fiscal period M = Monthly Q = Quarterly S = Specific date W = Weekly
template_stat character varying(1) No No Template status; A = Active S = Suspended U = Unpostable
template_folio character varying(10) No No General Ledger transaction that will be mimiced. Updated at each posting occurence
template_tran_date date No No Previoous date this recurring transaction was posted
template_arap_no character varying(20) No No Customer or vendor code for the transaction being recurred for Accounts Receivable and Accounts Payable postings only
ar_ref character varying(9) No No Reference to post with transaction
template_module character varying(1) No No Module to post that this transaction came from; G = General Ledger P = Accounts Payable R = Accounts Receivable
template_rec_info character varying(10) No No Information to use with template_freq to create repeat cycle; template_freq - template_rec_info 2 - the two days of the month to post A - date to post B - the day of the week to post, 1 = Monday, 2 = Tuesday etc D - 1 = Monday through Friday, 2 = Monday through Saturday, 3 = Monday through Sunday F - F= post on first day of period, L= last day of period M - F = post on first day of month, L = last day of month Q - blank S - day of the month to post W - the day of the week to post, 1 = Monday, 2 = Tuesday etc
template_start date No No Date to start posting recurring transaction
template_end date No No Date to end posting recurring transaction
template_mc_revise character varying(1) No No Not used
template_userid character varying(3) No No User initials that created this record
template_posted character varying(1) No No Not used

Constraints

Name Type Definition Comment
recurring_template_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL