Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
lbr_averagecost_id | numeric | 10 | null |
|
|
||||||
ad_client_id | numeric | 10 | null |
|
|
||||||
ad_org_id | numeric | 10 | null |
|
|
||||||
isactive | bpchar | 1 | 'Y'::bpchar |
|
|
||||||
created | timestamp | 29,6 | null |
|
|
||||||
createdby | numeric | 10 | null |
|
|
||||||
updated | timestamp | 29,6 | null |
|
|
||||||
updatedby | numeric | 10 | null |
|
|
||||||
c_period_id | numeric | 10 | null |
|
|
||||||
m_costelement_id | numeric | 10 | null |
|
|
Constraint Name | Constraint |
---|---|
lbr_averagecost_lbr_avgstep1_check | ((lbr_avgstep1 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_lbr_avgstep2_check | ((lbr_avgstep2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_lbr_avgstep5_check | ((lbr_avgstep5 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_lbr_avgstep4_check | ((lbr_avgstep4 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_processed_check | ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
lbr_averagecost_lbr_avgstep3_check | ((lbr_avgstep3 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |