The Memorized Transaction Definition table contains data about how a memorized transaction definition is set up and run to create memorized transactions.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
action | VARCHAR2 | 24 | Action | ||||
automatic_entry | VARCHAR2 | 3 | Automatic entry | ||||
date_next_posting | TIMESTAMP | Date of next posting | |||||
date_subsequent_posting | TIMESTAMP | Date of subsequent posting | |||||
days_in_advance | NUMBER | 39 | 0 | Days in advance | |||
employee_id | NUMBER | 39 | 0 | Employee ID | |||
frequency | VARCHAR2 | 128 | Frequency | ||||
ingroup | VARCHAR2 | 3 | In group | ||||
is_inactive | VARCHAR2 | 3 | Is inactive | ||||
is_indefinite | VARCHAR2 | 3 | Is indefinite | ||||
isdeferred | VARCHAR2 | 3 | Is deferred | ||||
isgroup | VARCHAR2 | 3 | Is group | ||||
memorized_id | NUMBER | 39 | 0 | Memorized ID | |||
next_occurance | TIMESTAMP | Next occurrence | |||||
number_remaining | NUMBER | 39 | 0 | Number remaining | |||
repeat_every | NUMBER | 39 | 0 | Repeat every | |||
subsequent_occurance | TIMESTAMP | Subsequent occurrence | |||||
time_period | VARCHAR2 | 24 | Time period | ||||
transaction_id | NUMBER | 39 | 0 | Transaction ID | |||
update_addresses | VARCHAR2 | 3 | Update addresses | ||||
update_prices | VARCHAR2 | 3 | Update prices |