forked from zackchandler/acts_as_quickbooks_model
-
Notifications
You must be signed in to change notification settings - Fork 1
/
ReceivePayment.rb
133 lines (130 loc) · 9.41 KB
/
ReceivePayment.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
# auto-generated from json definitions
# new table definitions
t.string :txn_id, :limit => 36
t.datetime :time_created
t.datetime :time_modified
t.string :edit_sequence, :limit => 16
t.integer :txn_number
t.string :customer_ref_list_id, :limit => 36
t.string :customer_ref_full_name, :limit => 209
t.string :ar_account_ref_list_id, :limit => 36
t.string :ar_account_ref_full_name, :limit => 159
t.datetime :txn_date
t.string :ref_number, :limit => 20
t.decimal :total_amount, :precision => 9, :scale => 2
t.string :payment_method_ref_list_id, :limit => 36
t.string :payment_method_ref_full_name, :limit => 31
t.string :memo, :limit => 4095
t.string :deposit_to_account_ref_list_id, :limit => 36
t.string :deposit_to_account_ref_full_name, :limit => 159
t.string :credit_card_txn_info_credit_card_txn_input_info_credit_card_number, :limit => 25
t.integer :credit_card_txn_info_credit_card_txn_input_info_expiration_month
t.integer :credit_card_txn_info_credit_card_txn_input_info_expiration_year
t.string :credit_card_txn_info_credit_card_txn_input_info_name_on_card, :limit => 41
t.string :credit_card_txn_info_credit_card_txn_input_info_credit_card_address, :limit => 41
t.string :credit_card_txn_info_credit_card_txn_input_info_credit_card_postal_code, :limit => 18
t.string :credit_card_txn_info_credit_card_txn_input_info_commercial_card_code, :limit => 24
t.string :credit_card_txn_info_credit_card_txn_input_info_transaction_mode
t.string :credit_card_txn_info_credit_card_txn_input_info_credit_card_txn_type
t.integer :credit_card_txn_info_credit_card_txn_result_info_result_code
t.string :credit_card_txn_info_credit_card_txn_result_info_result_message, :limit => 60
t.string :credit_card_txn_info_credit_card_txn_result_info_credit_card_trans_id, :limit => 24
t.string :credit_card_txn_info_credit_card_txn_result_info_merchant_account_number, :limit => 32
t.string :credit_card_txn_info_credit_card_txn_result_info_authorization_code, :limit => 12
t.string :credit_card_txn_info_credit_card_txn_result_info_avs_street
t.string :credit_card_txn_info_credit_card_txn_result_info_avs_zip
t.string :credit_card_txn_info_credit_card_txn_result_info_card_security_code_match
t.string :credit_card_txn_info_credit_card_txn_result_info_recon_batch_id, :limit => 84
t.integer :credit_card_txn_info_credit_card_txn_result_info_payment_grouping_code
t.string :credit_card_txn_info_credit_card_txn_result_info_payment_status
t.datetime :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_time
t.integer :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_stamp
t.string :credit_card_txn_info_credit_card_txn_result_info_client_trans_id, :limit => 16
t.decimal :unused_payment, :precision => 9, :scale => 2
t.decimal :unused_credits, :precision => 9, :scale => 2
# add_column definitions
add_column :table_name, :txn_id, :string, :limit => 36
add_column :table_name, :time_created, :datetime
add_column :table_name, :time_modified, :datetime
add_column :table_name, :edit_sequence, :string, :limit => 16
add_column :table_name, :txn_number, :integer
add_column :table_name, :customer_ref_list_id, :string, :limit => 36
add_column :table_name, :customer_ref_full_name, :string, :limit => 209
add_column :table_name, :ar_account_ref_list_id, :string, :limit => 36
add_column :table_name, :ar_account_ref_full_name, :string, :limit => 159
add_column :table_name, :txn_date, :datetime
add_column :table_name, :ref_number, :string, :limit => 20
add_column :table_name, :total_amount, :decimal, :precision => 9, :scale => 2
add_column :table_name, :payment_method_ref_list_id, :string, :limit => 36
add_column :table_name, :payment_method_ref_full_name, :string, :limit => 31
add_column :table_name, :memo, :string, :limit => 4095
add_column :table_name, :deposit_to_account_ref_list_id, :string, :limit => 36
add_column :table_name, :deposit_to_account_ref_full_name, :string, :limit => 159
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_number, :string, :limit => 25
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_expiration_month, :integer
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_expiration_year, :integer
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_name_on_card, :string, :limit => 41
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_address, :string, :limit => 41
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_postal_code, :string, :limit => 18
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_commercial_card_code, :string, :limit => 24
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_transaction_mode, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_txn_type, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_result_code, :integer
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_result_message, :string, :limit => 60
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_credit_card_trans_id, :string, :limit => 24
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_merchant_account_number, :string, :limit => 32
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_authorization_code, :string, :limit => 12
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_avs_street, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_avs_zip, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_card_security_code_match, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_recon_batch_id, :string, :limit => 84
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_payment_grouping_code, :integer
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_payment_status, :string
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_time, :datetime
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_stamp, :integer
add_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_client_trans_id, :string, :limit => 16
add_column :table_name, :unused_payment, :decimal, :precision => 9, :scale => 2
add_column :table_name, :unused_credits, :decimal, :precision => 9, :scale => 2
# remove_column definitions
remove_column :table_name, :txn_id
remove_column :table_name, :time_created
remove_column :table_name, :time_modified
remove_column :table_name, :edit_sequence
remove_column :table_name, :txn_number
remove_column :table_name, :customer_ref_list_id
remove_column :table_name, :customer_ref_full_name
remove_column :table_name, :ar_account_ref_list_id
remove_column :table_name, :ar_account_ref_full_name
remove_column :table_name, :txn_date
remove_column :table_name, :ref_number
remove_column :table_name, :total_amount
remove_column :table_name, :payment_method_ref_list_id
remove_column :table_name, :payment_method_ref_full_name
remove_column :table_name, :memo
remove_column :table_name, :deposit_to_account_ref_list_id
remove_column :table_name, :deposit_to_account_ref_full_name
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_number
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_expiration_month
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_expiration_year
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_name_on_card
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_address
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_postal_code
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_commercial_card_code
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_transaction_mode
remove_column :table_name, :credit_card_txn_info_credit_card_txn_input_info_credit_card_txn_type
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_result_code
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_result_message
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_credit_card_trans_id
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_merchant_account_number
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_authorization_code
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_avs_street
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_avs_zip
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_card_security_code_match
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_recon_batch_id
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_payment_grouping_code
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_payment_status
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_time
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_txn_authorization_stamp
remove_column :table_name, :credit_card_txn_info_credit_card_txn_result_info_client_trans_id
remove_column :table_name, :unused_payment
remove_column :table_name, :unused_credits