Public Pastes
Guest

Untitled

By: a guest on Dec 1st, 2010  |  syntax: None  |  size: 0.65 KB  |  hits: 21  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  1. CUSTOMER PROFILE:
  2. CUSTOMER_ID (key)
  3. F_NAME
  4. L_NAME
  5. EMAIL
  6. ADDRESS1_BILL
  7. ADDRESS2_BILL
  8. CITY_BILL
  9. ZIP_BILL
  10. COUNTRY_BILL
  11. PHONE_BILL
  12. REG_DATE
  13.  
  14. USER PROFILE (recipient):
  15. USER_ID (key)
  16. F_NAME
  17. L_NAME
  18. EMAIL
  19. ADDRESS1_SHIP
  20. ADDRESS2_SHIP
  21. CITY_SHIP
  22. ZIP_SHIP
  23. COUNTRY_SHIP
  24. PHONE_SHIP
  25. USER_STATUS
  26. USER_PASSWORD
  27. SUBSCRIPTIONS (Array with Subscription ID's)
  28.  
  29. TRANSACTION DATA:
  30. TRANS_ID (key)
  31. CUSTOMER_ID
  32. TRANS_CAMPAIGN
  33. TRANS_DATE
  34. TRANS_IP
  35. TRANS_CC_HASH
  36. TRANS_CC_TYPE
  37. TRANS_CC_LAST4
  38. TRANS_AMT
  39. TRANS_PAYPAL_TRANSID
  40. TRANS_APRV_DATE
  41. TRANS_APRV_ID
  42.  
  43. SUBSCRIPTION DATA:
  44. SUB_ID (key)
  45. SUB_STATUS
  46. SUB_AMT_DUE
  47. SUB_NEXT_DATE
  48. SUB_NEXT_AMT
  49. TRANS_ID
create a new version of this paste RAW Paste Data