Payment Transactions
Available since: v1.0.0
| File | Snapshot | Delta | Frequency |
|---|---|---|---|
| payment_transactions/payment_transactions_yyyy_MM_dd.csv | :white_check_mark: (:new: v2.4.0+) | :white_check_mark: | Daily |
| Attribute | Required? | Value | Description |
|---|---|---|---|
| ID | Yes | NUMBER | Unique identifier for entity |
| USER_ACCESS_ID | NUMBER | Foreign key for User Access that the transaction belongs to | |
| PAYMENT_PROVIDER_ID | NUMBER | Foreign key for Payment Providers | |
| REGISTERED | DATE | Date the transaction was registered | |
| TYPE | NUMBER | 0 = Purchase 1 = Autorenew 2 = Refund_autorenew 3 = Refund_purchase 5 = Auth_only (card authorization) | |
| PRICE | NUMBER | Transaction amount | |
| CURRENCY | VARCHAR2(25 BYTE) | Currency of the transaction | |
| VAT | NUMBER | Sales tax (amount of price) | |
| STATUS | NUMBER | 0 = UNKNOWN 1 = SUCCESS 2 = PENDINGEXPORT (e.g with invoice billing) 3 = EXPORTED 4 = UNCAPTURED (initialized purchases) 5 = FAILED 6 = PENDING (pending response from webhook) 7 = SMS_SENT 8 = TEMPORARILY_FAILED | |
| TRANSACTION_CUT_ID | NUMBER | Columns used for various transaction cuts. | |
| TRANSACTION_CUT | NUMBER | ||
| DISTRIBUTIO_CUT_ID | NUMBER | ||
| ROYALTY_CUT_ID | NUMBER | ||
| ROYALTY_CUT | NUMBER | ||
| REFERRER_CUT_ID | NUMBER | ||
| REFERRER_CUT | NUMBER | ||
| ROYALTY2_CUT_ID | NUMBER | ||
| ROYALTY2_CUT | NUMBER | ||
| TRANSACTION_REF | VARCHAR2(200 BYTE) | External payment provider’s transaction reference | |
| TRANSACTION_NUM | VARCHAR2(200 BYTE) | External payment provider’s transaction number, if applicable | |
| USER_PAYMENT_METHOD_ID | UUID | Foreign key for Users Payment Methods | |
| STARTDATE | DATE | (:new: v2.11.0+) Start date for corresponding subscription period | |
| ENDDATE | DATE | (:new: v2.11.0+) End date for corresponding subscription period | |
| EXT_TRANSACTION_DATE | DATE | (:new: v2.11.0+) Date for this transaction in external system |