|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ihcc__qadc01
|
|
|
x(8)
|
|
|
|
ihcc__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
ihcc__qadi01
|
|
|
>>>>>>9
|
|
|
|
ihcc__qadl01
|
|
|
yes/no
|
|
|
|
ihcc__qadt01
|
|
|
99/99/99
|
|
|
|
ihcc_auth_amt
|
Authorization Amount
|
Auth Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
ihcc_auth_date
|
Authorization Date
|
Auth Date
|
99/99/99
|
|
|
|
ihcc_auth_expire_date
|
Authorization Expires
|
Auth Expires
|
99/99/99
|
|
|
|
ihcc_auth_nbr
|
Authorization Number
|
|
x(20)
|
|
|
|
ihcc_billing_addr1
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_addr2
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_addr3
|
Address
|
|
x(28)
|
|
|
|
ihcc_billing_city
|
City
|
|
x(20)
|
|
|
|
ihcc_billing_country
|
Country
|
|
x(28)
|
|
|
|
ihcc_billing_ctry
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
ihcc_billing_name
|
Name
|
|
x(28)
|
|
|
|
ihcc_billing_state
|
State
|
|
x(4)
|
|
|
|
ihcc_billing_zip
|
Post
|
|
x(10)
|
|
|
|
ihcc_card_type
|
Card Type
|
|
x(8)
|
|
|
|
ihcc_cc_expire_date
|
Expire Date
|
Expire
|
99/99/99
|
|
|
|
ihcc_cc_nbr
|
Credit Card Number
|
|
x(24)
|
|
|
|
ihcc_cc_nbr_tail
|
End Digits
|
Ending
|
x(4)
|
|
|
|
ihcc_domain
|
Domain
|
|
x(8)
|
|
|
|
ihcc_inv_nbr
|
Invoice Number
|
Invoice
|
x(22)
|
|
|
|
ihcc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ihcc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
ihcc_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
ihcc_user1
|
User Field 1
|
|
x(24)
|
|
|
|
ihcc_user2
|
User Field 2
|
|
x(24)
|
|
|
|
oid_ihcc_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ihcc_inv_nbr
|
yes
|
ihcc_domain
|
yes
|
no
|
|
|
|
|
ihcc_inv_nbr
|
yes
|
no
|
|
|
|
|
ihcc_cc_nbr
|
yes
|
no
|
|
|
ihcc_nbr
|
no
|
ihcc_domain
|
yes
|
no
|
|
|
|
|
ihcc_nbr
|
yes
|
no
|
|
|
|
|
ihcc_cc_nbr
|
yes
|
no
|
|
|
oid_ihcc_hist
|
yes
|
oid_ihcc_hist
|
yes
|
no
|