| Previous: po_summary_attachment_ref | Unanet Data Model | Next: posting_group |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | post_history_key | decimal(15) | |||
| 2. | post_timestamp | datetime | ||||
| 3. | document_number | varchar(15) | ||||
| 4. | actuals_through_date | datetime | ||||
| 5. | journal_trans_date | datetime | ||||
| 6. | cp_recalc_begin_date | datetime | ||||
| 7. | cp_recalc_end_date | datetime | ||||
| 8. | posted_by_key | decimal(15) | person | fk_post_history1 | ||
| 9. | time_date_type | char(1) | ||||
| 10. | expense_date_type | char(1) | ||||
| 11. | bill_pool_rate_type | char(1) | ||||
| 12. | recog_pool_rate_type | char(1) | ||||
| 13. | use_financial_orgs | char(1) | ||||
| 14. | feature | tinyint | ||||
| 15. | post_to_gl | char(1) | ||||
| 16. | gl_post_level | tinyint | ||||
| 17. | gl_post_level_offset | tinyint | ||||
| 18. | gl_post_level_offset_alt | tinyint | ||||
| 19. | post_labor_cross_charge | char(1) | ('N') | |||
| 20. | post_fp_billable | char(1) | ||||
| 21. | post_fp_revenue | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| posted_by_key | person | person_key | fk_post_history1 |
| Table | Column | Foreign Key Name |
| cost_plus_post_detail | post_history_key | fk_cost_plus_post_detail10 |
| expense_data_allocation | cost_post_history_key | fk_expense_data_allocation10 |
| expense_data_allocation | post_history_key | fk_expense_data_allocation7 |
| fee_cap_adjustment | post_history_key | fk_fee_cap_adjustment3 |
| fin_document_detail_expense | post_history_key | fk_fin_doc_detail_expense3 |
| fin_document_detail_item | post_history_key | fk_fin_doc_detail_item4 |
| fin_document_detail_labor | post_history_key | fk_fin_doc_detail_labor3 |
| fixed_price | billable_post_history_key | fk_fixed_price5 |
| fixed_price | post_history_key | fk_fixed_price4 |
| fp_revenue_schedule | post_history_key | fk_fp_revenue_schedule2 |
| funding_cap_adjustment | post_history_key | fk_funding_cap_adjustment3 |
| journal_cost_plus_detail | post_history_key | fk_journal_cost_plus_detail4 |
| journal_document_expense | post_history_key | fk_journal_document_expense4 |
| journal_document_item | post_history_key | fk_journal_document_item4 |
| journal_document_labor | post_history_key | fk_journal_document_labor4 |
| journal_expense | post_history_key | fk_journal_expense4 |
| journal_fee_cap_adjustment | post_history_key | fk_journal_fee_cap_adjust4 |
| journal_fixed_price | post_history_key | fk_journal_fixed_price4 |
| journal_funding_cap_adjustment | post_history_key | fk_journal_funding_cap_adj4 |
| journal_prebilled_labor | post_history_key | fk_journal_prebilled_labor4 |
| journal_time | post_history_key | fk_journal_time4 |
| person_time_data | cost_post_history_key | fk_person_time_data13 |
| person_time_data | post_history_key | fk_person_time_data11 |
| prebilled_labor | post_history_key | fk_prebilled_labor2 |
| project_post_history | post_history_key | fk_project_post_history2 |
| Name | Definition |
| cc_ph_actuals_through_date | ([actuals_through_date]>='1900-01-01' AND [actuals_through_date]<='2099-12-31') |
| cc_ph_bill_pool_rate_type | ([bill_pool_rate_type]='A' OR [bill_pool_rate_type]='P' OR [bill_pool_rate_type]='T') |
| cc_ph_cp_recalc_begin_date | ([cp_recalc_begin_date]>='1900-01-01' AND [cp_recalc_begin_date]<='2099-12-31') |
| cc_ph_cp_recalc_end_date | ([cp_recalc_end_date]>='1900-01-01' AND [cp_recalc_end_date]<='2099-12-31') |
| cc_ph_cp_recalc_range | ([cp_recalc_begin_date] IS NULL AND [cp_recalc_end_date] IS NULL OR [cp_recalc_begin_date] IS NOT NULL AND [cp_recalc_end_date] IS NOT NULL AND [cp_recalc_begin_date]<=[cp_recalc_end_date]) |
| cc_ph_exp_date_type | ([expense_date_type]='P' OR [expense_date_type]='C' OR [expense_date_type]='I') |
| cc_ph_feature | ([feature]>=(0) AND [feature]<=(99)) |
| cc_ph_gl_post_level | ([gl_post_level]>=(1) AND [gl_post_level]<=(99)) |
| cc_ph_gl_post_lvl_offset | ([gl_post_level_offset]>=(1) AND [gl_post_level_offset]<=(99)) |
| cc_ph_gl_post_lvl_offset_alt | ([gl_post_level_offset_alt]>=(1) AND [gl_post_level_offset_alt]<=(99)) |
| cc_ph_journal_trans_date | ([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31') |
| cc_ph_post_fp_billable | ([post_fp_billable]='N' OR [post_fp_billable]='Y') |
| cc_ph_post_fp_revenue | ([post_fp_revenue]='N' OR [post_fp_revenue]='Y') |
| cc_ph_post_labor_cross_charge | ([post_labor_cross_charge]='N' OR [post_labor_cross_charge]='Y') |
| cc_ph_post_to_gl | ([post_to_gl]='N' OR [post_to_gl]='Y') |
| cc_ph_recog_pool_rate_type | ([recog_pool_rate_type]='A' OR [recog_pool_rate_type]='P' OR [recog_pool_rate_type]='T') |
| cc_ph_time_date_type | ([time_date_type]='P' OR [time_date_type]='W') |
| cc_ph_use_financial_orgs | ([use_financial_orgs]='N' OR [use_financial_orgs]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_post_history | true | post_history_key | Asc |
| idx_post_history1 | true | document_number | Asc |