fct_invoice

Primary key of this table. Unique identifier of the invoice position (position-level grain, not invoice-level).

Technical identifier of the invoice this position belongs to

Human-readable invoice reference number shown on the invoice document. Null for VOID invoices which have no external reference.

Timestamp when the invoice record was created in the system

Date on which the invoice was formally issued. Null for MySports receipts and some imported invoices.

Current lifecycle status of the invoice. For MySports receipts, status is set to ‘PAID’ since they represent completed online payments. VOID invoices retain their source status (typically ‘DRAFT’). May be null for some imported invoices.

Technical subtype of the invoice, distinguishing automated invoice runs, manual debt claims, voids, MySports receipts, and imported invoices

Document classification of the invoice. Set for debt-claim invoice runs (INVOICE, REFUND) and MySports receipts (PAYMENT_RECEIPT). Null for void and some imported invoices.

Total gross amount of the invoice across all positions including tax. Null for some void and imported invoices.

Currency in which the invoice amounts are denominated. Null for some void and imported invoices.

Number of days from the invoice date by which payment is due. Typically 0 for standard invoices (immediate payment), 30 for manual debt claims. Null for MySports receipts and some imported invoices.

External URL encoded as a QR code on the invoice for electronic invoicing flows. Null when electronic invoicing is not applicable.

Identifier of the customer who was invoiced. Null for company-only invoices where no individual customer is associated.

Identifier of the company associated with this invoice. Null for individual/non-corporate invoices.

Identifier of the studio or organization unit that issued the invoice

Identifier of the original invoice that this invoice voids or credits. Only set for VOID and COMPANY_VOID invoice types; null otherwise.

Display name of the line item as shown on the invoice

Technical subtype of the invoice position, distinguishing invoice run positions, MySports receipts, and imported positions

Lifecycle status of the invoice position. Only set for debt-claim position types; null for MySports and imported positions.

Secondary description or sub-label shown beneath the main position name on the invoice. Null when no sub-label was specified.

Gross amount of this invoice position including tax (net_amount + tax_amount)

Net amount of this invoice position excluding tax

Tax amount applied to this invoice position

Tax rate applied to this invoice position, expressed as a percentage

Display order of this position within the invoice

Identifier of the contract linked to this invoice position. Null when the position has no associated booking entry or the booking entry has no contract (e.g. MySports positions, payment-type booking entries).

Start date of the service period this invoice position covers. Null when the position has no associated booking entry.

End date of the service period this invoice position covers. Null when the position has no associated booking entry.

Surrogate key linking to the product dimension via sale_position. Only populated for invoice positions that have an associated sale with a product variant or dynamic item. Null for membership charges and positions without linked sales.

Identifier of the rate plan linked to the contract. Null when contract_id is null.

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).