The tables behind Photography CRM

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

Customer, prospect and partner companies with owner, terms and credit position.

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

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

Scheduled and completed sales and service activities linked to records.

Customer, prospect and partner companies with owner, terms and credit position.

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

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

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

Priced offers with revision, approval state and acceptance.

Confirmed customer orders with fulfillment, credit and invoicing state.

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

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

Customer, prospect and partner companies with owner, terms and credit position.

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

Priced offers with revision, approval state and acceptance.

Scheduled and completed sales and service activities linked to records.

Scheduled and completed sales and service activities linked to records.

Customer, prospect and partner companies with owner, terms and credit position.

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

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

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

Priced offers with revision, approval state and acceptance.

Quoted products with quantity, unit price and discount.

Named pricing books applied to customers, markets and currencies.

Effective dated price per product within a price book.

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

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

Confirmed customer orders with fulfillment, credit and invoicing state.

Confirmed customer orders with fulfillment, credit and invoicing state.

Ordered products with ordered, shipped and invoiced quantities.

Priced offers with revision, approval state and acceptance.

Customer, prospect and partner companies with owner, terms and credit position.

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

Dispatch records with carrier evidence and shipped quantities.

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.

Approval requests with decision, approver, reason and linked source document.

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.

Components, quantities and scrap factors within a BOM revision.

Effective dated bills of material defining component structure.

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.

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

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.

Unique billing or delivery cycles generated for a contract period.

Products, quantities and prices committed within a contract.

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

Responsibility centers used for budgeting, allocation and expense reporting.

Customer credit requests with requested limit, decision and expiry.

Current credit position, limit and hold state per customer.

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.

Employee records with department, position, employment terms and payroll eligibility.

Approved effective operating, posting and approval policies.

Legal entities under a reporting parent, each owning its trial balance and fiscal calendar.

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.

Delivery attempts and responses for outbound integration events.

Inbound and outbound integration events with source identity and handling state.

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.

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

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.

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

Individual imported opening balance or master items within a batch.

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.

Incoming customer cash recorded to bank with unapplied receipt status.

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.

MRP purchase and production proposals pending firming.

Approved positions with department, grade and headcount authority.

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.

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.

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

Acceptance of services using completion evidence without warehouse stock.

Shipped lines with lot or serial identity and dispatched quantity.

Attributed sales activity evidence submitted against an opportunity and owner.

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.

Every owned stock movement with quantity, cost and linked document.

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.

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

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.

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

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.