_81.erx_webservice_transactions

Field Type Null Default Key Extra Comment
ewt_id int(11) NO PRI auto_increment
ewt_cus_id int(11) NO 0 Customer ID#
ewt_cli_id int(11) NO 0 MUL Client ID#
ewt_pat_id int(11) NO 0 MUL Patient ID#
ewt_req_filepath varchar(256) NO String Request filpath, currently XML
ewt_res_filepath varchar(256) NO String Response filpath, currently XML
ewt_time int(11) NO 0 Time to complete request in milliseconds
ewt_success tinyint(1) NO 1 Indicates request was successful
ewt_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
ewt_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References