_435.adjustment_rules

Field Type Null Default Key Extra Comment
ar_id int(11) NO PRI auto_increment
ar_cus_id int(11) NO customer id
ar_cli_id int(11) NO client id
ar_name text YES name for the rule
ar_description text YES short description of the rule
ar_rule text YES the text version of the rule logic
ar_adj_code int(11) YES the adjustment code to be used for posting when the rule is matched
ar_adj_rev_code int(11) YES
ar_denial tinyint(1) NO 0 the denial setting to be used for posting when the rule is matched
ar_complete tinyint(1) YES the complete setting to be used for posting when the rule is matched
ar_usr_id_created int(11) YES user id of user who created the rule
ar_usr_id_modified int(11) YES the last user to modify the rule
ar_disabled tinyint(1) NO 0
ar_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ar_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References