Payment Status Log
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| payment_status_log/payment_status_log_YYYY_MM_dd.csv | :white_check_mark: | :white_check_mark: | Daily |
| Attribute | Required? | Value | Description |
|---|---|---|---|
| ID | NUMBER | Unique identifier for entity | |
| USER_ID | NUMBER | Foreign key for Users | |
| USER_ACCESS_ID | NUMBER | Foreign key for User Access | |
| STATUS_ID | NUMBER | 1 = REQUEST 2 = USER_SUBSCRIPTION_REQUESTED 3 = USER_SUBSCRIPTION_CREATED 4 = USER_SUBSCRIPTION_STOP_REQUESTED 5 = CHECK 6 = SALECC 7 = USER_SUBSCRIPTION_EXTENDED 9 = SALEEXTERNALLOGIN 10 = ADD_ORDER 15 = USER_SUBSCRIPTION_REACTIVATED 33 = REFUND 39 = CHARGE 40 = CHARGE_FAILED 50 = CREDIT 60 = UPDATE_PAYMENT_METHOD 101 = REQUEST_FAILED 102 = AUTHORIZE_FAILED 103 = RESULT_FAILED 104 = COMPLETE_FAILED 105 = CHECK_FAILED 106 = SALECC_FAILED 107 = STOP_FAILED 109 = SALEEXTERNALLOGIN_FAILED 110 = ADD_ORDER_FAILED 150 = CREDIT_FAILED 201 = ALREADY_CAPTURED 202 = CAPTURE_FAILED 203 = CAPTURE_FAILED_AUTORENEW 301 = UPDATE_PROFILE_FAILED 302 = RULES_INCONCISTENCY 303 = AUTORENEW_EXTENSION | |
| ORDER_REF | VARCHAR2 | External reference of the subscription, typically from payment provider | |
| MESSAGE | VARCHAR2 | ||
| REGISTERED | DATE |