Fivetran documentation

Search the docs

/

Cabcharge

Explore the interactive ERD

Table & Field Reference

statement_enriched_item

Column	Type	Keys
`index`	Unknown	PK
`statement_account_id`	Unknown	PKFK
`statement_period`	Unknown	PKFK
`assignee`	Unknown
`product_tag`	Json
`transaction_aust_amount`	Unknown
`transaction_aust_charge`	Unknown
`transaction_aust_extra`	Unknown
`transaction_booking_ref`	Unknown
`transaction_card_name`	Unknown
`transaction_card_number`	Unknown
`transaction_date`	Unknown
`transaction_docket`	Unknown
`transaction_driver_abn`	Unknown
`transaction_driver_id`	Unknown
`transaction_fare`	Unknown
`transaction_from_address`	Unknown
`transaction_gst`	Unknown
`transaction_levy_amount`	Unknown
`transaction_levy_authority`	Unknown
`transaction_local_amount`	Unknown
`transaction_local_fare`	Unknown
`transaction_merchant`	Unknown
`transaction_product`	Unknown
`transaction_rate_type`	Unknown
`transaction_rrn`	Unknown
`transaction_service_fee`	Unknown
`transaction_service_fee_rate`	Unknown
`transaction_taxi`	Unknown
`transaction_time`	Unknown
`transaction_to_address`	Unknown
`transaction_total_amount`	Unknown
`transaction_trans_number`	Unknown
`transaction_trip_uid`	Unknown
`trip_comment`	Unknown
`trip_tag`	Json

statement

Column	Type	Keys
`period`	Unknown	PK
`account_id`	Unknown	PKFK
`account_fee`	Unknown
`balance_brought_forward`	Unknown
`credit_adjustment`	Unknown
`debit_adjustment`	Unknown
`due_date`	Unknown
`enriched_order`	Json
`from_date`	Unknown
`gov_levy`	Unknown
`gst_amount`	Unknown
`invoice_number`	Unknown
`issue_date`	Unknown
`overdue`	Unknown
`payment_received`	Unknown
`period_total`	Unknown
`previous_balance`	Unknown
`service_fee`	Unknown
`statement_period`	Unknown
`taxi_fare`	Unknown
`to_date`	Unknown
`trip_number`	Unknown

traveller_role

Column	Type	Keys
`role`	Unknown	PK
`traveller_id`	Unknown	PKFK

traveller_tag_profile

Column	Type	Keys
`id`	Unknown	PK
`traveller_id`	Unknown	PKFK
`category_id`	Unknown	FK

traveller

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`pay_on_account_permission`	Unknown
`phone_number`	Unknown
`user_id`	Unknown

digital_fast_card_order

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`assignee`	Unknown
`cancelled_trip`	Unknown
`delivery_address`	Unknown
`delivery_method`	Unknown
`expiry`	Unknown
`order_date`	Unknown
`order_user_id`	Unknown
`original_trip`	Unknown
`pan`	Unknown
`seq`	Unknown
`spending_limit`	Unknown
`spending_limit_frequency`	Unknown
`status`	Unknown
`tags`	Unknown
`used_trip`	Unknown
`valid_from`	Unknown

transaction

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`billing_period`	Unknown
`drop_off_address`	Unknown
`drop_off_date_time`	Unknown
`fare`	Unknown
`gst`	Unknown
`kilometre`	Unknown
`order_id`	Unknown
`pickup_address`	Unknown
`pickup_date_time`	Unknown
`product_type`	Unknown
`receipt_number`	Unknown
`route`	Json
`service_fee`	Unknown
`taxi`	Unknown
`ticket_number`	Unknown
`transaction_date`	Unknown
`trip_tag`	Json
`extra_`

account

Column	Type	Keys
`id`	Unknown	PK
`account_status`	Unknown
`billing_period`	Json
`dfc_max_fare_limit`	Unknown
`name`	Unknown
`tag_visible`	Unknown
`trip_tag_config_allow_new_tag_addition`	Unknown
`trip_tag_config_categories_required`	Unknown
`trip_tag_config_comments_required`	Unknown
`trip_tag_config_traveller_trip_tagging_enabled`	Unknown

digital_pass_order

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`assignee`	Unknown
`cancelled_by`	Unknown
`cancelled_date`	Unknown
`cancelled_trip`	Unknown
`created_by`	Unknown
`delivery_address`	Unknown
`delivery_method`	Unknown
`expiry`	Unknown
`fare_limit`	Unknown
`original_trip`	Unknown
`status`	Unknown
`tags`	Json
`ticket_number`	Unknown
`used_trip`	Unknown
`valid_from`	Unknown

inventory_fastcard

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`assignee_email`	Unknown
`assignee_name`	Unknown
`expiry_date`	Unknown
`name_on_card`	Unknown
`receipt_email`	Unknown
`valid_from`	Unknown

category_tag

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`category_id`	Unknown	PKFK
`description`	Unknown

category

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`name`	Unknown

inventory_flexi_fastcard

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`assignee_email`	Unknown
`assignee_name`	Unknown
`expiry_date`	Unknown
`name_on_card`	Unknown
`receipt_email`	Unknown
`valid_from`	Unknown

inventory_eticket

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`assignee_email`	Unknown
`assignee_name`	Unknown
`expiry_date`	Unknown
`name_on_card`	Unknown
`receipt_email`	Unknown
`valid_from`	Unknown