Current table structure

- Order ID
- Transaction ID
- Customer ID
- Order Status
- Order Amount
- Order Date
- Product (ID or name)
- Campaign (Id or name)
- BIN
- sessionId
- Response (Decline reason)
- Card Type
- Sale Type
- Affiliate (ID or name)
- AFID 
- SID
- Chargeback (Yes or No)
- Chargeback Amount
- Chargeback Date
- Refund (Yes or No)
- Refund Date
- Refund Amount
- txnType (Yes or No)

Transcation Call info

'transactionId,parentTxnId,merchant,merchantDescriptor,midNumber,merchantId,dateCreated,dateUpdated,txnType,responseType,responseText,3DTxnResult,merchantTxnId,clientTxnId,authCode,avsResponse,cvvResponse,totalAmount,surcharge,orderId,orderAgentName,clientOrderId,billingCycleNumber,recycleNumber,campaignId,campaignName,campaignCategoryName,firstName,lastName,orderType,customerId,emailAddress,phoneNumber,address1,address2,city,state,country,postalCode,ipAddress,paySource,cardBin,cardLast4,cardType,cardIsPrepaid,cardIsDebit,achBankName,achRoutingNumber,achAccountNumber,sourceTitle,affId,sourceValue1,sourceValue2,sourceValue3,sourceValue4,sourceValue5,custom1,custom2,custom3,custom4,custom5,isChargedback,chargebackAmount,chargebackDate,chargebackReasonCode,chargebackNote,refundReason,currencySymbol,paySourceId,productId'


Order Call for the transcation call we need

'orderId,actualOrderId,clientOrderId,shipCarrier,shipMethod,dateCreated,dateUpdated,orderType,orderStatus,reviewStatus,totalAmount,refundRemaining,avsResponse,cvvResponse,campaignName,customerId,name,emailAddress,phoneNumber,firstName,lastName,companyName,address1,address2,city,state,country,postalCode,shipFirstName,shipLastName,shipCompanyName,shipAddress1,shipAddress2,shipCity,shipState,shipCountry,shipPostalCode,paySource,cardType,cardLast4,cardExpiryDate,cardIsPrepaid,cardIsDebit,achRoutingNumber,achAccountNumber,couponCode,agentUserId,agentName,price,baseShipping,voiceLogNumber,discountPrice,salesTax,surcharge,shipUpcharge,shipProfileId,isDeclineSave,ipAddress,sourceId,sourceTitle,affId,sourceValue1,sourceValue2,sourceValue3,sourceValue4,sourceValue5,currencySymbol,currencyCode,campaignId,totalDiscount,custom1,custom2,custom3,custom4,custom5,UTMSource,UTMMedium,UTMCampaign,UTMTerm,UTMContent,hasUpsell,productId'



Please let me if current table structure is proper or not. 

I have given you list of fields avaiable in Transcationcall and order call for that  transcation if you can go through and prepare the final list if you need more fields that will be really helpful to me. 



Apart from this call i will get sessionId from Import landing page