Field Mappings

Use these mappings to relate upstream fields to the AMLOK data model. Field population depends on the source product, account permissions, and available evidence.

Plaid - Canada (CA) / Plaid - United States (US)

M001 · bank_account.source_account_id

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].account_id
AMLOK target	bank_account.source_account_id
Transformation proposal	Keep case and connection context.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M002 · bank_account.name

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].name
AMLOK target	bank_account.name
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M003 · bank_account.official_name

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].official_name
AMLOK target	bank_account.official_name
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M004 · bank_account.mask

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].mask
AMLOK target	bank_account.mask
Transformation proposal	Preserve as string, not identity key.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M005 · bank_account.account_type

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].type
AMLOK target	bank_account.account_type
Transformation proposal	Map explicit enum.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M006 · bank_account.account_subtype

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].subtype
AMLOK target	bank_account.account_subtype
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M007 · account_balance.current.amount

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].balances.current
AMLOK target	account_balance.current.amount
Transformation proposal	Serialize exact decimal; retain asset/liability basis.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M008 · account_balance.available.amount

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].balances.available
AMLOK target	account_balance.available.amount
Transformation proposal	Null stays unavailable.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M009 · account_balance.credit_limit.amount

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].balances.limit
AMLOK target	account_balance.credit_limit.amount
Transformation proposal	Preserve null and product context.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M010 · account_balance.current.currency

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].balances.iso_currency_code
AMLOK target	account_balance.current.currency
Transformation proposal	Retain unofficial currency separately if applicable.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M011 · account_balance.as_of

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	accounts[].balances.last_updated_datetime
AMLOK target	account_balance.as_of
Transformation proposal	Do not invent missing timestamp.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M012 · connection.institution_id

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/accounts/get
Upstream field / value	item.institution_id
AMLOK target	connection.institution_id
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Cached account balances; selected institution/product controls optional fields. No entitlement inferred.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/accounts

M013 · bank_transaction.source_transaction_id

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].transaction_id
AMLOK target	bank_transaction.source_transaction_id
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M014 · bank_transaction.account_id

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].account_id
AMLOK target	bank_transaction.account_id
Transformation proposal	Resolve via connection account mapping.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M015 · bank_transaction.amount.amount

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].amount
AMLOK target	bank_transaction.amount.amount
Transformation proposal	Absolute decimal magnitude.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M016 · bank_transaction.direction

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].amount
AMLOK target	bank_transaction.direction
Transformation proposal	Positive outflow; negative inflow; zero neutral.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M017 · bank_transaction.amount.currency

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].iso_currency_code
AMLOK target	bank_transaction.amount.currency
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M018 · bank_transaction.posted_on

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].date
AMLOK target	bank_transaction.posted_on
Transformation proposal	Map only posted records; pending is not posted.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M019 · bank_transaction.authorized_on

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].authorized_date
AMLOK target	bank_transaction.authorized_on
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M020 · bank_transaction.description

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].name
AMLOK target	bank_transaction.description
Transformation proposal	Preserve legacy description; not merchant identity.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M021 · bank_transaction.merchant_name

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].merchant_name
AMLOK target	bank_transaction.merchant_name
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M022 · bank_transaction.status

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].pending
AMLOK target	bank_transaction.status
Transformation proposal	true=pending; false=posted.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M023 · bank_transaction.pending_transaction_id

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].pending_transaction_id
AMLOK target	bank_transaction.pending_transaction_id
Transformation proposal	Resolve prior pending ID; supersede correctly.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M024 · bank_transaction.payment_channel

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].payment_channel
AMLOK target	bank_transaction.payment_channel
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M025 · bank_transaction.source_category

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	added[].personal_finance_category.detailed
AMLOK target	bank_transaction.source_category
Transformation proposal	AMLOK category requires separate classification.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

M026 · common.deleted_at

Property	Definition
Provider IDs	BANK-02; BANK-13
Upstream object / API	/transactions/sync
Upstream field / value	removed[].transaction_id
AMLOK target	common.deleted_at
Transformation proposal	Create tombstone with observed removal time.
Source evidence	Documented
Availability conditions	Product-specific sign convention; sync added/modified/removed sets must all be applied.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

plaid.com/docs/api/products/transactions

Stripe

M027 · processor_transaction.source_transaction_id

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	id
AMLOK target	processor_transaction.source_transaction_id
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M028 · processor_transaction.gross.amount

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	amount
AMLOK target	processor_transaction.gross.amount
Transformation proposal	Minor units to exact major units; retain sign.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M029 · processor_transaction.fee.amount

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	fee
AMLOK target	processor_transaction.fee.amount
Transformation proposal	Minor units to exact major units.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M030 · processor_transaction.net.amount

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	net
AMLOK target	processor_transaction.net.amount
Transformation proposal	Minor units to exact major units; retain sign.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M031 · processor_transaction.net.currency

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	currency
AMLOK target	processor_transaction.net.currency
Transformation proposal	Uppercase currency; apply to all event money.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M032 · processor_transaction.event_type

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	type
AMLOK target	processor_transaction.event_type
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M033 · processor_transaction.reporting_category

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	reporting_category
AMLOK target	processor_transaction.reporting_category
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M034 · processor_transaction.availability_status

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	status
AMLOK target	processor_transaction.availability_status
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M035 · processor_transaction.available_on

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	available_on
AMLOK target	processor_transaction.available_on
Transformation proposal	Unix timestamp to documented calendar date.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M036 · processor_transaction.occurred_at

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	created
AMLOK target	processor_transaction.occurred_at
Transformation proposal	Unix seconds to UTC timestamp.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

M037 · processor_transaction.source_object_id

Property	Definition
Provider IDs	PAY-02
Upstream object / API	BalanceTransaction
Upstream field / value	source
AMLOK target	processor_transaction.source_object_id
Transformation proposal	Retain expanded-object ID if expanded.
Source evidence	Documented
Availability conditions	Merchant authorization required; this ledger is separate from a bank-account transaction feed.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

docs.stripe.com/api/balance_transactions/object

Shopify / Shopify POS

M038 · order.source_order_id

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	id
AMLOK target	order.source_order_id
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M039 · order.order_number

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	name
AMLOK target	order.order_number
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M040 · order.placed_at

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	createdAt
AMLOK target	order.placed_at
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M041 · order.cancelled_at

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	cancelledAt
AMLOK target	order.cancelled_at
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M042 · order.payment_status

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	displayFinancialStatus
AMLOK target	order.payment_status
Transformation proposal	Preserve provider financial-state meaning.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M043 · order.fulfillment_status

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	displayFulfillmentStatus
AMLOK target	order.fulfillment_status
Transformation proposal	Map versioned enum.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M044 · order.total.amount

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	totalPriceSet.shopMoney
AMLOK target	order.total.amount
Transformation proposal	Use amount member and currencyCode companion.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M045 · order.current_total.amount

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	currentTotalPriceSet.shopMoney
AMLOK target	order.current_total.amount
Transformation proposal	Keep current total distinct from original.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M046 · order.refunded_total.amount

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	totalRefundedSet.shopMoney
AMLOK target	order.refunded_total.amount
Transformation proposal	Use amount and currencyCode.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M047 · order.tax_total.amount

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	totalTaxSet.shopMoney
AMLOK target	order.tax_total.amount
Transformation proposal	Use amount and currencyCode.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M048 · order.taxes_included

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	taxesIncluded
AMLOK target	order.taxes_included
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

M049 · order.is_test

Property	Definition
Provider IDs	ECOM-01; PAY-05
Upstream object / API	Order; Admin GraphQL 2026-10
Upstream field / value	test
AMLOK target	order.is_test
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	read_orders and relevant protected-data permissions; older than 60 days requires appropriate all-orders access.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

shopify.dev/docs/api/admin-graphql/latest/objects/Order

Xero

M050 · common.source_refs[].source_record_id

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	InvoiceID
AMLOK target	common.source_refs[].source_record_id
Transformation proposal	Qualified by Xero organization.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M051 · invoice.number

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	InvoiceNumber
AMLOK target	invoice.number
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M052 · invoice.counterparty_id

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	Contact.ContactID
AMLOK target	invoice.counterparty_id
Transformation proposal	Resolve counterparty within organization.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M053 · invoice.issued_on

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	Date
AMLOK target	invoice.issued_on
Transformation proposal	Preserve date; parse source encoding.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M054 · invoice.due_on

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	DueDate
AMLOK target	invoice.due_on
Transformation proposal	Preserve calendar date.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M055 · invoice.status

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	Status
AMLOK target	invoice.status
Transformation proposal	Map enum; preserve original.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M056 · invoice.total.amount

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	Total
AMLOK target	invoice.total.amount
Transformation proposal	Exact decimal.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M057 · invoice.total.currency

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	CurrencyCode
AMLOK target	invoice.total.currency
Transformation proposal	Apply to document money fields.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M058 · invoice.amount_due.amount

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	AmountDue
AMLOK target	invoice.amount_due.amount
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M059 · invoice.amount_paid.amount

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	AmountPaid
AMLOK target	invoice.amount_paid.amount
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M060 · invoice.amount_credited.amount

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	AmountCredited
AMLOK target	invoice.amount_credited.amount
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

M061 · invoice / bill (resource routing)

Property	Definition
Provider IDs	ACC-03
Upstream object / API	Invoices
Upstream field / value	Type
AMLOK target	invoice / bill (resource routing)
Transformation proposal	Routing: ACCREC to invoice; ACCPAY to bill; Type is not status.
Source evidence	Documented
Availability conditions	The final Type row documents routing, not a direct status assignment. Line detail may require individual or paged reads.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.xero.com/documentation/api/accounting/invoices

QuickBooks Online

M062 · common.source_refs[].source_record_id

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	Id
AMLOK target	common.source_refs[].source_record_id
Transformation proposal	Qualified by QBO company/realm.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M063 · invoice.number

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	DocNumber
AMLOK target	invoice.number
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M064 · invoice.counterparty_id

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	CustomerRef.value
AMLOK target	invoice.counterparty_id
Transformation proposal	Resolve customer reference.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M065 · invoice.issued_on

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	TxnDate
AMLOK target	invoice.issued_on
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M066 · invoice.due_on

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	DueDate
AMLOK target	invoice.due_on
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M067 · invoice.total.amount

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	TotalAmt
AMLOK target	invoice.total.amount
Transformation proposal	Preserve value.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M068 · invoice.amount_due.amount

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	Balance
AMLOK target	invoice.amount_due.amount
Transformation proposal	Zero does not establish void status.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M069 · invoice.total.currency

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	CurrencyRef.value
AMLOK target	invoice.total.currency
Transformation proposal	Use documented home currency if no currency ref.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M070 · invoice.home_total.amount

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	HomeTotalAmt
AMLOK target	invoice.home_total.amount
Transformation proposal	Pair with company home currency.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

M071 · invoice.exchange_rate

Property	Definition
Provider IDs	ACC-01
Upstream object / API	Invoice
Upstream field / value	ExchangeRate
AMLOK target	invoice.exchange_rate
Transformation proposal	Home units per document unit.
Source evidence	Documented
Availability conditions	QBO company scope, multicurrency settings and authorized Accounting API access determine population.
Adapter test status	Not tested
Reviewed on	2026-10-22

Source documentation

developer.intuit.com/docs/api/accounting/invoice

Overview

Integrations

Data Model

Pricing

Support

Security & Compliance

Resources

Field Mappings

Plaid - Canada (CA) / Plaid - United States (US)

Stripe

Shopify / Shopify POS

Xero

QuickBooks Online

​Plaid - Canada (CA) / Plaid - United States (US)

​Stripe

​Shopify / Shopify POS

​Xero

​QuickBooks Online

Plaid - Canada (CA) / Plaid - United States (US)

Stripe

Shopify / Shopify POS

Xero

QuickBooks Online