Guest User

Untitled

a guest
Jul 17th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. create table SilentPosts
  2. {
  3. SilentPostId int not null identity primary key,
  4. ResponseCode int null, -- 1
  5. ResponseSubcode int null, -- 1
  6. ResponseReasonCode int null, -- 1
  7. ResponseReasonText nvarchar(100) null, -- This transaction has been approved.
  8. AuthCode , --
  9. AVSCode , -- P
  10. TransId , -- 1821199455
  11. InvoiceNum , -- --
  12. Description , --
  13. Amount , -- 9.95
  14. Method , -- CC
  15. Type , -- auth_capture
  16. CustId , -- 1
  17. FirstName , -- John
  18. LastName , -- Smith
  19. Company , --
  20. Address , --
  21. City , --
  22. State , --
  23. Zip , --
  24. Country , --
  25. Phone , --
  26. Fax , --
  27. Email , --
  28. ShipToFirstName , --
  29. ShipToLastName , --
  30. ShipToCompany , --
  31. ShipToAddress , --
  32. ShipToCity , --
  33. ShipToState , --
  34. ShipToZip , --
  35. ShipToCountry , --
  36. Tax , -- 0.0000
  37. Duty , -- 0.0000
  38. Freight , -- 0.0000
  39. Tax_exempt , -- FALSE
  40. PONum , --
  41. MD5Hash , -- A375D35004547A91EE3B7AFA40B1E727
  42. CAVVResponse , --
  43. TestRequest , -- false
  44. SubscriptionId , -- 365314
  45. SubscriptionPaynum -- 1
  46. }
Add Comment
Please, Sign In to add comment