|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
cctr__qadc01
|
|
|
x(8)
|
|
|
|
cctr__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
cctr__qadi01
|
|
|
>>>>>>9
|
|
|
|
cctr__qadl01
|
|
|
yes/no
|
|
|
|
cctr__qadt01
|
|
|
99/99/99
|
|
|
|
cctr_action_code
|
Action Code
|
Action
|
x(3)
|
|
|
|
cctr_amt
|
Authorized Amount
|
Auth Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
cctr_auth_code
|
Authorization Code
|
Auth Code
|
x(8)
|
|
|
|
cctr_auth_expire_date
|
Expire Date
|
Expire
|
99/99/99
|
|
|
|
cctr_auth_nbr
|
Authorization Number
|
|
x(20)
|
|
|
|
cctr_aux_msg
|
Auxiliary Message
|
|
x(60)
|
|
|
|
cctr_avs_code
|
AVS Code
|
|
x(4)
|
|
|
|
cctr_cc_nbr
|
Credit Card Number
|
|
x(24)
|
|
|
|
cctr_cust_txn
|
Customer Trans ID
|
|
x(20)
|
|
|
|
cctr_domain
|
Domain
|
|
x(8)
|
|
|
|
cctr_err_msg
|
Error Message
|
|
x(40)
|
|
|
|
cctr_internal_tx
|
Internal Transaction
|
|
yes/no
|
|
|
|
cctr_inv_nbr
|
Invoice Number
|
Invoice
|
x(22)
|
|
|
|
cctr_merch_txn
|
Merchant Trans ID
|
|
x(20)
|
|
|
|
cctr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
cctr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
cctr_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
cctr_ref_code
|
Reference Code
|
Reference
|
x(12)
|
|
|
|
cctr_status
|
Status Code
|
|
x(20)
|
|
|
|
cctr_trnbr
|
Transaction Number
|
Trans
|
>>>>>>>>9
|
|
|
|
cctr_tx_date
|
Transaction Date
|
Tran Date
|
99/99/99
|
|
|
|
cctr_tx_time
|
Transaction Time
|
Time
|
x(8)
|
|
|
|
cctr_tx_type
|
Transaction Type
|
|
x(8)
|
|
|
|
cctr_user1
|
User Field 1
|
|
x(24)
|
|
|
|
cctr_user2
|
User Field 2
|
|
x(24)
|
|
|
|
oid_cctr_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
cctr_auth_nbr
|
no
|
cctr_domain
|
yes
|
no
|
|
|
|
|
cctr_auth_nbr
|
yes
|
no
|
|
|
|
|
cctr_tx_date
|
yes
|
no
|
|
|
cctr_date_time
|
no
|
cctr_domain
|
yes
|
no
|
|
|
|
|
cctr_tx_date
|
yes
|
no
|
|
|
|
|
cctr_tx_time
|
yes
|
no
|
|
|
cctr_inv_nbr
|
no
|
cctr_domain
|
yes
|
no
|
|
|
|
|
cctr_inv_nbr
|
yes
|
no
|
|
|
cctr_nbr
|
no
|
cctr_domain
|
yes
|
no
|
|
|
|
|
cctr_nbr
|
yes
|
no
|
|
|
|
|
cctr_tx_date
|
yes
|
no
|
|
∗
|
cctr_trnbr
|
yes
|
cctr_domain
|
yes
|
no
|
|
|
|
|
cctr_trnbr
|
yes
|
no
|
|
|
oid_cctr_hist
|
yes
|
oid_cctr_hist
|
yes
|
no
|