id |
integer |
Yes |
Yes |
nextval('gl_recurring_transactions_id_seq'::regclass) |
|
template_temp |
character varying(6) |
No |
No |
|
Links to gl_recurring_pending.temp for the dates to recur |
template_desc |
character varying(60) |
No |
No |
|
The description of the entry. Is populated when creating recurring entry but is editable by user |
template_freq |
character varying(1) |
No |
No |
|
Frequency transaction is to post. M = Monthly S = Specific date 2 = Bi-Monthly F = Fiscal A = Annual W = Weekly B = Bi-Weekly D = Daily Q = Quarterly |
template_stat |
character varying(1) |
No |
No |
|
Status of recurring template A = Active S = Suspended U = Unpostable |
template_folio |
character varying(10) |
No |
No |
|
The GL transaction that will be recurred |
template_tran_date |
date |
No |
No |
|
Last date this recurring transaction posted |
template_arap_no |
character varying(20) |
No |
No |
|
Customer or vendor code from the transaction being recurred |
ar_ref |
character varying(9) |
No |
No |
|
Editable reference that will post with transaction |
template_module |
character varying(1) |
No |
No |
|
Module that this transaction comes from G = General Ledger P = Accounts Payable R = Accounts Receivable |
template_rec_info |
character varying(10) |
No |
No |
|
Info for the repeat cycle 2 digit numeric - will post each month on that day 4 digit numeric - the 2 days it will post when bi-monthly F = First day of month L = Last day of month |
template_start |
date |
No |
No |
|
Date to start recurring transaction |
template_end |
date |
No |
No |
|
Date to end recurring transaction |
template_mc_revise |
character varying(1) |
No |
No |
|
|
template_userid |
character varying(3) |
No |
No |
|
User that created transaction |
template_posted |
character varying(1) |
No |
No |
|
|