The tables behind Subscription Boxes CRM

Subscriber and supplier parties. A counterparty on both sides is one record with Type Both.

People at an account with role, email and phone contact detail.

Team Members records; retain actual linked evidence and role scope.

Scheduled and completed sales and service activities linked to records.

Unqualified or in qualification demand with source, score and conversion state.

Qualified revenue pursuits with stage, amount, probability and expected close.

Scheduled and completed sales and service activities linked to records.

Priced offers with revision, approval state and acceptance.

Quoted products with quantity, unit price and discount.

Subscriber and supplier parties. A counterparty on both sides is one record with Type Both.

People at an account with role, email and phone contact detail.

Customer agreements with active dates, billing mode and remaining scope.

Products, quantities and prices committed within a contract.

Subscriber and supplier parties. A counterparty on both sides is one record with Type Both.

People at an account with role, email and phone contact detail.

Sellable and manufacturable products with units, costing and stock policy.

Recurring subscriber curation cycles with period, theme, quantities and billing progress.

Recurring subscriber curation cycles with period, theme, quantities and billing progress.

Products, quantities and prices committed within a contract.

Customer agreements with active dates, billing mode and remaining scope.

Meal order lines with portions, price, source location, tax and the allocated, served and billed quantities.

Invoice line items carrying quantity, price, discount and tax detail.

Confirmed subscriber orders that drive curation, allocation, fulfilment and payment, in the subscriber's currency.

Meal order lines with portions, price, source location, tax and the allocated, served and billed quantities.

Subscriber and supplier parties. A counterparty on both sides is one record with Type Both.

Customer agreements with active dates, billing mode and remaining scope.

Recurring subscriber curation cycles with period, theme, quantities and billing progress.

Review decisions on a submitted revision: review number, document scope, decision, reviewer and evidence.

Current credit position, limit and hold state per customer.

Outbound fulfillment events against a meal order, with carrier, tracking and proof of delivery.

Confirmed subscriber orders that drive curation, allocation, fulfilment and payment, in the subscriber's currency.

Meal order lines with portions, price, source location, tax and the allocated, served and billed quantities.

Stocking locations including owned, custody and in transit ownership locations.

Customer returns with original scope, received condition and credit effect.

Shipped lines with lot or serial identity and dispatched quantity.

Customer invoices posted to AR and Revenue with tax, delivery and settlement status.

Invoice line items carrying quantity, price, discount and tax detail.

Recurring subscriber curation cycles with period, theme, quantities and billing progress.

Confirmed subscriber orders that drive curation, allocation, fulfilment and payment, in the subscriber's currency.

Outbound fulfillment events against a meal order, with carrier, tracking and proof of delivery.

Customer returns with original scope, received condition and credit effect.

Payment evidence received from subscribers with method, amount, allocation progress and provider confirmation.

Fiscal periods per entity with the open and close state the close checklist drives.

Per-target allocation amounts produced by an allocation run.

Driver based cost allocation runs posting balanced allocation entries.

Valuation books defining depreciation method and basis for assets.

Fixed asset classes carrying default depreciation method and useful life.

Acquisition, transfer, impairment and disposal events retained for an asset.

Time bounded delegation of approval authority between roles.

Company bank accounts owned by an entity, used for receipts, payments and statement lines.

Statement lines imported from a bank account pending reconciliation.

Supplier bill lines with matched quantity and price difference.

Matched goods receipt and PO quantities consumed by a bill line.

Supplier bills matched to PO prices and accepted goods or services.

Per-account budget amounts within a budget version.

Locked or draft financial budgets per entity, period and account scope.

Account master shared across entities with a self-parenting tree, control flags and intercompany flag.

Ordering and blocking dependencies between close tasks.

Required close checklist tasks for an entity period.

Reusable close checklist templates defining required tasks and dependencies.

Effective dated compensation changes retained as history.

Elimination and adjustment entries applied during consolidation.

Entity scope and ownership applied within a consolidation run.

Per-entity consolidated balances produced by a consolidation run.

Translation, ownership and elimination runs producing consolidated results.

Responsibility centers used for budgeting, allocation and expense reporting.

Customer credit requests with requested limit, decision and expiry.

ISO currency codes used as functional, reporting and transaction currencies.

Organization departments used for workforce reporting and approvals.

Per-asset depreciation amounts produced by a depreciation run.

Periodic depreciation processing runs over an asset book.

Immutable revisions of governed documents retained with effective dates.

Effective dated pay component assignment per employee.

Approved effective operating, posting and approval policies.

Dated currency multipliers by source and type; required rates are reviewed and frozen on a transaction.

Read-only effective exchange rates for this app.

Capitalized assets with cost, accumulated depreciation and disposal state.

Arrived lines with lot or serial, quantity and acceptance state.

Supplier arrivals held as custody until inspected and accepted.

Observed holiday calendars for an entity or region.

Ingredient and stock movements recording each quantity change with its source evidence.

Delivery attempts and responses for outbound integration events.

On hand and reserved quantity per product, warehouse and lot or serial.

Counted quantity per product, location and lot within a count.

Physical inventory count documents with variance review.

Reservations of traced stock against demand documents.

Balanced accounting entries posted to the ledger for a period and entity.

Debit and credit lines of a journal entry with account, cost center and amount.

Entitled, taken and available leave per employee and leave type.

Recorded taken leave consuming approved balances.

Employee leave requests with reserved, approved or rejected state.

Leave categories with accrual rules and approval requirements.

Material requirements planning runs with demand, supply and shortage output.

Proposed changes to governed master data pending review and activation.

Menu recipe header: the recipe for a made product, versioned by revision.

Opening balance import batches with cutoff, approval and activation state.

Individual imported opening balance or master items within a batch.

Operation receipts recording each governed action, its source event and its persisted effect state.

Organizations served by the subscription box operation; each owns its settings, members, service locations and orders.

Earnings, deduction and employer cost components used in payroll.

Earning, deduction and employer cost lines of a pay statement.

Per-employee pay statements produced by an approved payroll run.

Allocation of made payments to bills and AP remainders.

Allocations of received cash to specific invoice remainders.

Bank payment instructions with submitted, accepted and settled state.

Prepared supplier payment runs requiring independent release.

Due-date rules applied to invoices, bills and payment runs.

Outgoing payments with settlement confirmation state.

Allocation of payroll cost to cost centers and production orders.

Imported payroll year to date opening balances per employee.

Payroll processing runs with frozen inputs, approval and settlement state.

Application people mapped to users with role title and active state.

MRP purchase and production proposals pending firming.

Approved positions with department, grade and headcount authority.

Effective dated price per product within a price book.

Named pricing books applied to customers, markets and currencies.

Inventory, WIP and COGS posting accounts per product and entity.

Accepted terminal output transferred into finished stock.

Production execution events with time, good output and scrap.

Ordered supplier lines with received, matched and billed quantities.

Supplier commitments with receipt, match and payment state.

Inspection results gating acceptance and quality release.

Accepted and rejected quantities against a received arrival.

Each ingredient consumed to produce one unit of the parent menu recipe.

Refunds of customer credit requiring independent approval and one funding source.

Requested products, quantities and needed dates within a requisition.

Internal purchase requests routed for independent approval.

Per-balance revaluation differences produced by a revaluation run.

Foreign currency revaluation runs over eligible remaining monetary balances.

Operations, work centers and setup or run time within a routing.

Effective dated operation sequences used to produce an item.

Attributed sales activity evidence submitted against an opportunity and owner.

Allocation of order or invoice value to owners, cost centers or entities.

Acceptance of services using completion evidence without warehouse stock.

Requests for customer or authorizer signature on a governed document.

Custody, ownership and transfer events retained for traceability.

Cost layers consumed on issue and retained for valuation and returns.

Tax rates applied to document lines, mapped to a jurisdiction and a GL account.

Tax returns prepared and filed for a jurisdiction and period.

Authorities that levy tax and receive filings: country, state, province, city.

Per-day or per-assignment time lines within a timesheet.

Employee timesheets submitted for approval by period.

Users

Returns to suppliers with original cost and billed state.

Per-date working state and shift hours of a work calendar.

Working calendars defining working and nonworking patterns.

Capacity bearing production resources with cost rates.

Component requirements issued into WIP for a work order.

Material, labour and overhead cost entries charged to a work order.

Released operations with schedule, assignment and reported time.

Released production orders with frozen BOM, routing and cost rates.