migration.yml 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. organization:
  2. id: history.organization_id
  3. code: organization_code
  4. name: organization_name
  5. description: description
  6. email: organization_email
  7. emailOnOverBudget: sendemail_overbudget
  8. parent_id: history.parent_organization_id
  9. structure: history.organization_id_structure
  10. appliedDate: history.app_datetime
  11. expiredDate: history.exp_datetime
  12. costCenter:
  13. id: history.costcenter_id
  14. code: costcenter_code
  15. name: costcenter_name
  16. description: description
  17. email: costcenter_email
  18. parent_id: history.parent_costcenter_id
  19. structure: history.costcenter_id_structure
  20. appliedDate: history.app_datetime
  21. expiredDate: history.exp_datetime
  22. pbx:
  23. code: pbx_code
  24. name: description
  25. ipPbx: ip_pbx
  26. pbxSupporter: pbx_supporter
  27. sharePath: share_path
  28. # appliedDate: ext_start
  29. # expiredDate: ext_end
  30. trunk:
  31. id: history.trunk_id
  32. code: trunk_code
  33. name: description
  34. pbx_id: location_code
  35. direction: cap_direction
  36. appliedDate: history.app_datetime
  37. expiredDate: history.exp_datetime
  38. callTransaction:
  39. direction: direction
  40. startOfCall: start_of_call
  41. duration: duration
  42. extension: ext_used
  43. pin: pin
  44. phoneUser_id: phoneuser_code
  45. extTransferFrom: ext_transfer_from
  46. extTransferTo: ext_transfer_to
  47. number: dialed_number
  48. callerNumber: caller_number
  49. accessNumber: access_number
  50. organization_id: organization_code
  51. costCenter_id: costcenter_code
  52. cost: cost_1
  53. service: cost_service
  54. tax: cost_tax1
  55. discount: cost_adjustment
  56. currency: currency
  57. pbx_id: pbx_code
  58. terminationCode: call_termination
  59. redirectReason: redirect_reason
  60. account_id: account_code
  61. webUser:
  62. username: login_id
  63. password: login_password
  64. name: description
  65. phoneUser_id: phoneuser_code
  66. loginPin: used_pin
  67. phoneUser:
  68. id: history.phoneuser_id
  69. code: phoneuser_code
  70. name: phoneuser_name
  71. email: phoneuser_email
  72. whatsapp: phoneuser_mobile
  73. position: position
  74. emailOnOverBudget: sendemail_overbudget
  75. pin: history.phoneuser_pin
  76. extension: history.default_extension
  77. organization_id: history.organization_code
  78. costCenter_id: history.costcenter_code
  79. pbx_id: history.pbx_code
  80. pbx.list: group.pbx_list
  81. appliedDate: history.app_datetime
  82. expiredDate: history.exp_datetime
  83. budget.maxCost: history.max_cost
  84. budget.warnCost: history.warn_cost
  85. corcos:
  86. command: command
  87. name: short_desc
  88. description: description
  89. provider:
  90. code: provider_prefix
  91. name: description
  92. description: description
  93. account:
  94. id: history.account_id
  95. code: account_code
  96. name: history.account_number
  97. description: description
  98. appliedDate: history.app_datetime
  99. expiredDate: history.exp_datetime