Journal Charges

Uploaded Charge

Field	XLSX Column	Type	Description
externalIds.vendor	Entry ID	string	Represents a unique vendor entry ID. Example: 2876850566
externalIds.reference	External Reference	string	Optional vendor-specific data, which might be used, for example, to detect the Marketplace order ID. Example: ORD-3270-2860-5617
externalIds.invoice	Vendor Invoice Reference	string	Represents the vendor-specific invoice ID. Example: 1234567890
search.subscription.criteria	Subscription Search Criteria	string	The search criteria for the specified subscription. Example: subscription.externalIds.vendor
search.subscription.value	Subscription Search Value	string	The value of the subscription. Example: d77f96aec94563b671697ed752f81cNA
search.order.criteria	Order Search Criteria	string	The search criteria for the order. Example: order.id
search.order.value	Order Search Value	string	The value of the order. Example: ORD-3270-2860-5617
search.item.criteria	Item Search Criteria	string	The search criteria for the item. Example: item.externalIds.vendor
search.item.value	Item Search Value	string	The value of the item. Example: 30005387CA
period.start	Usage Start Time	ISO 8601	Represents the start time of the entry. Example: 2025-01-01T00:00:00Z
period.end	Usage End Time	ISO 8601	Represents the end time for the entry. Example: 2025-01-01T00:00:00Z
quantity	Quantity	decimal	The quantity of the entry. Example: 10
price.unitPP	Purchase Price	decimal	The purchase price of the entry. Example: 253.83
price.PPx1	Total Purchase Price	decimal	The total purchase price of the entry. Example: 2538.3
segment	Market Segment	string	Examples: COM, GOV, EDU
description.value1	Description1	string	Vendor-specific line 1 of the data.
description.value2	Description2	string	Vendor-specific line 2 of the data.

Journal Charge

Field	Type	Description
id	string	The ID of the charge. Example: CHG-1234-1234-1234-1234-1234
status	enum	Possible values: Ready or Error
type	enum	Possible values: Automated or Manual
parent	charge	Optional reference to the parent charge for split billing cases, includes one parent split for the number of children charges. Example: { "id": "CHG-1234-1234-1234-1234-1234" }
buyer	buyer	A reference to the Buyer object. Example: { "id": "BUY-0355-0939", "href": "/accounts/buyers/BUY-0355-0939", "name": "TEST_BUYER30_rec" }
seller	seller	A reference to the Seller object. Example: { "id": "SEL-9512-0354", "href": "/accounts/sellers/SEL-9512-0354", "name": "TEST_SELLER30_rec" }
ledger	ledger	A reference to the Ledger object. Example: { "id": "BLE-6084-5502-9512-0354" }
statement	statement	A reference to the Statement object. Example: { "id": "SOM-6084-5502-5163-5035-5953", "type": "Debit" }
licensee	licensee	A reference to the Agreement object. Example: { "id": "LCE-4563-7526-8099", "href": "/accounts/licensees/LCE-4563-7526-8099", "name": "TEST_LICENSEE30_rec" }
agreement	agreement	A reference to the Agreement object. Example: { "id": "AGR-5163-5035-5953", "href": "/commerce/agreements/AGR-5163-5035-5953", "status": "Active", "name": "TEST_AGREEMENT30_rec_1" }
subscription	subscription	A reference to the Subscription object. Example: { "id": "SUB-7342-6318-2370", "href": "/commerce/subscriptions/SUB-7342-6318-2370", "name": "TEST_SUBSCRIPTION30_rec_1" }
item	item	A reference to the Item object. Example: { "id": "ITM-5333-3116-0002", "href": "/items/ITM-5333-3116-0002", "name": "TEST_SUBSCRIPTIONITEM30_rec" }
authorization	authorization	A reference to the Authorization object. Example: { "id": "AUT-2173-6546", "href": "/catalog/authorizations/AUT-2173-6546", "name": "MY_TEST_AUTHORIZATION30_rec" }
vendor	account	A reference to the vendor Account object. Example: { "id": "ACC-3647-5309", "href": "/accounts/accounts/ACC-3647-5309", "name": "TEST_VENDOR30_rec" }
price	price	Example: { "unitPP": 92.09375679688615, "unitSP": 101.30313247657476, "PPx1": 184.1875135937723, "SPx1": 202.60626495314952 "markup": 10, "margin": 9.0909090909 }
erpData	object	ERP system related data. Example: { "scu": "1", "cco": "ATC-CCO-112612", "erpItemId": "AO03.22961.MP" }
attributes	object	Various attributes taken from the input file. Example: { "documentNumber": "AGR-0605-6606-7993", "orderType": "Direct", "externalDocumentNo": "4500776612", "externalDocumentNo2": "AGR-0605-6606-7993", "yourReference": "Adobe VIP Marketplace Prinzhorn Holding GmbH" }

Examples

UPLOADED CHARGE

{
    "externalIds": {
      "vendor": "TEST_CHARGE_001"
      "reference": null,
      "invoice": "2000005957",
    },
    "search": {
      "subscription": {
        "criteria": "subscription.externalIds.vendor",
        "value": "86c4f6b8-ead5-4752-9075-1d2caec6a7cc"
      },
      "item": {
        "criteria": "item.externalIds.vendor",
        "value": "73927560-e5f2-4be4-bdb3-7f6069f0bf94"
      }
    },
    "period": {
      "start": "2025-01-01T00:00:00Z",
      "end": "2025-01-31T23:59:59Z"
    },
    "quantity": 2,
    "price": {
      "unitPP": 93.10961859011398,
      "PPx1": 186.21923718022796
    },
    "segment": "COM"
}

JOURNAL CHARGE