Table Information for the Post Intercompany Receivables Screen

The posting process updates several tables.

Updated tables include:

  • Intercompany Receivables Header (ICR_Hdr): This table stores information from the headers of Intercompany Receivables journal entries. During posting, Costpoint copies this information to the Intercompany Receivables Header History table. Because these records are no longer needed in the Intercompany Receivables Header table, Costpoint then deletes them so that the table only contains open records.
  • Intercompany Receivables Header History (ICR_Hdr_Hs): Costpoint updates this table with information from the Intercompany Receivables Header table during the posting process.
  • Intercompany Receivables Transaction (ICR_Trn): This table stores information from the lines of Intercompany Receivables journal entries. During posting, Costpoint copies this information to the Intercompany Receivables Transaction History table. Because these records are no longer needed in the Intercompany Receivables Transaction table, Costpoint deletes them so that the table only contains open records.
  • Intercompany Receivables Transaction History (ICR_Trn_Hs): Costpoint updates this table with information from the Intercompany Receivables Transaction table during the posting process.
  • Transaction Posting Detail (GL_Detl): To keep this table at a manageable size, the posting program updates it only with summary debit and credit information from the Intercompany Receivables Header and Transaction tables. This information includes the user ID, ICR number, and amount. Intercompany Receivables transactions are identified as "Post Intercompany Receivables" in this table. Detailed reports and inquiries take line data from the Intercompany Receivables Header and Transaction History tables.
  • Transaction Posting Summary (GL_Post_Sum): The posting program updates this table with summary debit and credit information from the Intercompany Receivables Header and Transaction tables. This information includes amounts posted by fiscal year and selected period, and account/organization data.
  • Financial Statement Summary of Account Balances (FS_Sum): The posting program updates this table with summary debit and credit information from the Intercompany Receivables Header and Transaction tables. This information includes amounts posted by fiscal year and selected period, and account/organization data.
  • Reference Summary (Ref_Sum): The posting program updates this table with summary debit and credit information from the Intercompany Receivables Header and Transaction tables. This information includes amounts posted by fiscal year and selected period, and account/reference number data.