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 |