Use these data-model references to describe the records your connection needs. They are planning examples; connector availability and supported operations must be established before implementation.
Download the mapping worksheet · CSV, no email required
Reporting dataset
Invoice / Proposed customer invoice table in Amazon DynamoDB (choose its name)
Plan a customer invoice dataset while preserving its source meaning.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅
- Amazon DynamoDB
- Your database schema
- Record identity
- Retain the invoice ID, issuer/legal entity, and original order reference; invoice numbers alone may overlap.
- Field ownership
- The financial system owns posting and accounting treatment. A posted invoice may need a credit or adjustment process instead of an overwrite.
Fields to include
- Source invoice ID
- Customer or supplier reference
- Line totals
- Currency
- Posting/payment status
- Record dependencies
- Resolve the customer or supplier, account codes, tax, currency, and accounting period before posting.
- Validation
- Test a posted invoice, a partial payment, tax rounding, and a closed accounting period. Compare financial totals within the same entity and currency.
- Recovery
- Determine whether a transaction posted before retrying. Follow the approved adjustment process for posted records.
References: Campfire: Invoice documentation
Reporting dataset
Bill / Proposed supplier bill table in Amazon DynamoDB (choose its name)
Plan a supplier bill dataset while preserving its source meaning.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅ Every 24h
- Amazon DynamoDB
- Your database schema
- Record identity
- Retain the supplier-bill ID, supplier, legal entity, and document reference; distinguish it from a customer invoice.
- Field ownership
- Accounts payable owns approval and posting; a supplier bill is not an accounts-receivable invoice.
Fields to include
- Source bill ID
- Supplier reference
- Entity
- Line amounts and currency
- Approval/posting state
- Record dependencies
- Resolve supplier, expense/account codes, entity, currency, and accounting period before bill lines.
- Validation
- Test a duplicate supplier document number in another entity, a partially paid bill, and a closed period.
- Recovery
- Verify whether the bill was approved or posted before retrying; use the approved adjustment process for posted bills.
References: Campfire: Bill documentation
Reporting dataset
Vendor / Proposed supplier or vendor table in Amazon DynamoDB (choose its name)
Plan a supplier or vendor dataset while preserving its source meaning.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅
- Amazon DynamoDB
- Your database schema
- Record identity
- Use the supplier ID within its business entity; a supplier name may occur in several subsidiaries.
- Field ownership
- Assign responsibility for approved supplier details; restrict changes to payment instructions to the business approval process.
Fields to include
- Source supplier ID
- Legal name
- Entity reference
- Payment terms
- Active status
- Record dependencies
- Resolve business-unit and payment-term references before purchasing transactions.
- Validation
- Test a supplier shared across subsidiaries and an inactive supplier referenced by an open bill.
- Recovery
- Review rejected supplier changes before retrying dependent bills; do not reactivate a supplier merely to make a write pass.
References: Campfire: Vendor documentation
Reporting dataset
Journal Entry / Proposed journal or ledger entry table in Amazon DynamoDB (choose its name)
Plan a journal or ledger entry dataset while preserving its source meaning.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅
- Amazon DynamoDB
- Your database schema
- Record identity
- Retain journal ID and line IDs within the legal entity and accounting period.
- Field ownership
- The ledger owns posting approval and period controls; an integration should not treat a posted journal as an ordinary editable row.
Fields to include
- Source journal ID
- Account references
- Debit/credit amounts
- Entity
- Accounting period
- Record dependencies
- Resolve chart-of-account, currency, entity, and dimension references before lines.
- Validation
- Verify balanced debits and credits, dimension requirements, and rejection for a closed period.
- Recovery
- Reconcile posting status and use the finance-approved reversal or adjustment process instead of replaying a posted entry.
References: Campfire: Journal Entry documentation
Record matching
Product / Items
Compare whether Campfire Product and Amazon DynamoDB Items describe the same product or catalog item in your business.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅
- Amazon DynamoDB
- Object support to establish
- Record identity
- Distinguish the product ID, variant ID, SKU, and price-list entry; they are not interchangeable keys.
- Field ownership
- Assign ownership for catalog content, price, and stock separately.
Fields to include
- Source product ID
- SKU or variant reference
- Description
- Unit of measure
- Price-list reference
- Record dependencies
- Resolve units, variants, categories, and applicable price lists before order lines.
- Validation
- Test two variants of one product, a changed SKU, and a price that applies to only one market or currency.
- Recovery
- Repair the variant or price-list reference before retrying affected order lines; preserve existing transaction prices.
References: Campfire: Product documentation
Reporting dataset
Product / Proposed product or catalog item table in Amazon DynamoDB (choose its name)
Plan a product or catalog item dataset while preserving its source meaning.
Planning example. Stacksync support for the required connection and record operations needs a technical review.
- Campfire
- Documented record · Incremental: ✅; historical: ✅; delete detection: ✅
- Amazon DynamoDB
- Your database schema
- Record identity
- Distinguish the product ID, variant ID, SKU, and price-list entry; they are not interchangeable keys.
- Field ownership
- Assign ownership for catalog content, price, and stock separately.
Fields to include
- Source product ID
- SKU or variant reference
- Description
- Unit of measure
- Price-list reference
- Record dependencies
- Resolve units, variants, categories, and applicable price lists before order lines.
- Validation
- Test two variants of one product, a changed SKU, and a price that applies to only one market or currency.
- Recovery
- Repair the variant or price-list reference before retrying affected order lines; preserve existing transaction prices.
References: Campfire: Product documentation