tbl_finance_project

14970 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoice_code varchar 20 null
ManAccs_Comments.invoice_code ManAccs_Comments_invoice_code_fkeyR
tbl_charge_group_project.invoice_code tbl_charge_group_project_invoice_fkeyC
tbl_finance_project_summary.invoice_code tbl_finance_project_summary_invoice_code_fkeyR
tbl_percentage_markup.invoice_code tbl_percentage_markup_invoice_code_fkeyR
tbl_project_defer_income.invoice_code tbl_project_defer_income_invoice_code_fkeyC
tbl_project_monitor_reports.invoice_code tbl_project_monitor_reports_invoice_code_fkeyC
tbl_project_monitor_subscriptions.invoice_code tbl_finance_project_summary_invoice_code_fkeyC
tbl_weighted_markup.invoice_code tbl_weighted_markup_invoice_code_fkeyR
fund varchar 10 √ null
tbl_lookup_fund.fund Implied ConstraintR
area varchar 10 √ null
tbl_lookup_area.area Implied ConstraintR
complete varchar 10 √ false
date_complete date 13 √ null
invoice_type varchar 20 √ null
tbl_lookup_invoice_type.invoice_type tbl_finance_project_invoice_type_fkeyR
purchase_order_details varchar 100 √ null
contract bool 1 √ false
costing_details bool 1 √ false
folder_name text 2147483647 √ null
episode_refid int4 10 √ null
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_finance_project_cost_centre_fkeyR
date_start date 13 √ null
comment text 2147483647 √ null
site_code varchar 20 √ null
manager int4 10 √ null
tbl_staff_lookup.refid tbl_finance_project_manager_fkeyR
exchange_reference int4 10 √ null
tbl_exchange_reference.exchange_reference tbl_finance_project_exchange_reference_fkeyR
framework_name varchar 200 √ null
project_name varchar 200 √ null
type varchar 100 √ null
department varchar 100 √ null
tbl_lookup_department.department tbl_finance_project_department_fkeyR
budget numeric 20,4 √ 0
tender_number int4 10 √ null
currency int4 10 √ 1
tbl_currency.currency tbl_finance_project_currency_fkeyR
description text 2147483647 √ null
project_status text 2147483647 √ null
old_manager varchar 50 √ null
eligible bool 1 √ null
job_number int8 19 √ null
temp_cambridge_project_type varchar 20 √ null
transfer_project bool 1 √ false
final_invoice bool 1 √ null
monitor bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_finance_project_pkey Primary key Asc invoice_code

Relationships

Close relationships within degrees of separation