Payment Transactions

Available since: v1.0.0

[block:parameters] { “data”: { “h-0”: “File”, “h-1”: “Snapshot”, “h-2”: “Delta”, “h-3”: “Frequency”, “0-0”: “payment_transactions/payment_transactions_yyyy_MM_dd.csv”, “0-1”: “:white_check_mark: \n(:new: v2.4.0+)”, “0-2”: “:white_check_mark:”, “0-3”: “Daily” }, “cols”: 4, “rows”: 1, “align”: [ “left”, “left”, “left”, “left” ] } [/block]

[block:parameters] { “data”: { “h-0”: “Attribute”, “h-1”: “Required?”, “h-2”: “Value”, “h-3”: “Description”, “0-0”: “ID”, “0-1”: “Yes”, “0-2”: “NUMBER”, “0-3”: “Unique identifier for entity”, “1-0”: “USER_ACCESS_ID”, “1-1”: "", “1-2”: “NUMBER”, “1-3”: “Foreign key for User Access that the transaction belongs to”, “2-0”: “PAYMENT_PROVIDER_ID”, “2-1”: "", “2-2”: “NUMBER”, “2-3”: “Foreign key for Payment Providers”, “3-0”: “REGISTERED”, “3-1”: "", “3-2”: “DATE”, “3-3”: “Date the transaction was registered”, “4-0”: “TYPE”, “4-1”: "", “4-2”: “NUMBER”, “4-3”: “0 = Purchase \n1 = Autorenew \n2 = Refund_autorenew \n3 = Refund_purchase \n5 = Auth_only (card authorization)”, “5-0”: “PRICE”, “5-1”: "", “5-2”: “NUMBER”, “5-3”: “Transaction amount”, “6-0”: “CURRENCY”, “6-1”: "", “6-2”: “VARCHAR2(25 BYTE)”, “6-3”: “Currency of the transaction”, “7-0”: “VAT”, “7-1”: "", “7-2”: “NUMBER”, “7-3”: “Sales tax (amount of price)”, “8-0”: “STATUS”, “8-1”: "", “8-2”: “NUMBER”, “8-3”: “0 = UNKNOWN \n1 = SUCCESS \n2 = PENDINGEXPORT (e.g with invoice billing) \n3 = EXPORTED \n4 = UNCAPTURED (initialized purchases) \n5 = FAILED \n6 = PENDING (pending response from webhook) \n7 = SMS_SENT \n8 = TEMPORARILY_FAILED”, “9-0”: “TRANSACTION_CUT_ID”, “9-1”: "", “9-2”: “NUMBER”, “9-3”: “Columns used for various transaction cuts.”, “10-0”: “TRANSACTION_CUT”, “10-1”: "", “10-2”: “NUMBER”, “10-3”: ”””, “11-0”: “DISTRIBUTIO_CUT_ID”, “11-1”: "", “11-2”: “NUMBER”, “11-3”: ”””, “12-0”: “ROYALTY_CUT_ID”, “12-1”: "", “12-2”: “NUMBER”, “12-3”: ”””, “13-0”: “ROYALTY_CUT”, “13-1”: "", “13-2”: “NUMBER”, “13-3”: ”””, “14-0”: “REFERRER_CUT_ID”, “14-1”: "", “14-2”: “NUMBER”, “14-3”: ”””, “15-0”: “REFERRER_CUT”, “15-1”: "", “15-2”: “NUMBER”, “15-3”: ”””, “16-0”: “ROYALTY2_CUT_ID”, “16-1”: "", “16-2”: “NUMBER”, “16-3”: ”””, “17-0”: “ROYALTY2_CUT”, “17-1”: "", “17-2”: “NUMBER”, “17-3”: ”””, “18-0”: “TRANSACTION_REF”, “18-1”: "", “18-2”: “VARCHAR2(200 BYTE)”, “18-3”: “External payment provider’s transaction reference”, “19-0”: “TRANSACTION_NUM”, “19-1”: "", “19-2”: “VARCHAR2(200 BYTE)”, “19-3”: “External payment provider’s transaction number, if applicable”, “20-0”: “USER_PAYMENT_METHOD_ID”, “20-1”: "", “20-2”: “UUID”, “20-3”: “Foreign key for Users Payment Methods”, “21-0”: “STARTDATE”, “21-1”: "", “21-2”: “DATE”, “21-3”: ”(:new: v2.11.0+) \nStart date for corresponding subscription period”, “22-0”: “ENDDATE”, “22-1”: "", “22-2”: “DATE”, “22-3”: ”(:new: v2.11.0+) \nEnd date for corresponding subscription period”, “23-0”: “EXT_TRANSACTION_DATE”, “23-1”: "", “23-2”: “DATE”, “23-3”: ”(:new: v2.11.0+) \nDate for this transaction in external system” }, “cols”: 4, “rows”: 24, “align”: [ “left”, “left”, “left”, “left” ] } [/block]