tbl_work_in_progress

3822 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoice_code varchar 20 √ null
dated date 13 √ null
cost numeric 20,4 √ 0
an_name varchar 100 √ null
tl_description varchar 100 √ null
ja_line_order varchar 100 √ null
culdx_company varchar 100 √ null
idx_ac_code varchar 100 √ null
idx_anal_code varchar 100 √ null
ja_posted int4 10 √ null
th_your_ref varchar 100 √ null
ja_year int4 10 √ null
ja_period numeric 2 √ null
jr_user_1 varchar 100 √ null
ja_posted_run int4 10 √ null
ja_reserved int4 10 √ null
ja_reverse int4 10 √ null
jr_status int4 10 √ null
tl_currency int4 10 √ 1
tbl_currency.currency tbl_work_in_progress_tl_currency_fkeyR
cost_centre varchar 100 √ null
tbl_cost_centre.cost_centre tbl_work_in_progress_cost_centre_fkeyR
exchange_reference int4 10 √ null
tbl_exchange_reference.exchange_reference tbl_work_in_progress_exchange_rate_fkeyR
folio int8 19 null
tbl_wip_currency_translation.folio tbl_wip_currency_translation_folio_fkeyC
line_position int8 19 null
tbl_wip_currency_translation.line_position tbl_wip_currency_translation_folio_fkeyC

Indexes

Constraint Name Type Sort Column(s)
tbl_work_in_progress_pkey Primary key Asc/Asc folio + line_position
idx_wip_invoice_code Performance Asc invoice_code

Relationships

Close relationships within degrees of separation