Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Table Information for the View Check History Inquiry Screen

The serval tables use or contain data for A/P checks.

These tables include:

  • Accounts (ACCT): Account descriptions on all subtasks come from this table.
  • Billable Labor Category (BILL_LAB_CAT): This table contains project labor categories (PLCs) and their descriptions, entered through the General Labor Categories screen in Labor. The Vendor Labor subtask takes the PLC Description from this table.
  • Organizations (ORG): Organization names and abbreviations in all subtasks come from this table.
  • Purchase Order Line (PO_LN): This table contains all the purchase order information entered on the Enter Purchase Orders screen in Purchasing. The Enter PO Vouchers application in Accounts Payable also accesses this table for purchase order information corresponding to the voucher being entered. The PO Detail subtask uses the Purchase Order Line table to populate the fields in its table window. These fields display quantity and cost amount information from the purchase order.
  • Projects (PROJ): Project names and abbreviations in all subtasks come from this table.
  • Reference Structure (REF_STRUC): Reference number names in all subtasks come from this table.
  • Voucher Header History (VCHR_HDR_HS): The Voucher Header History table stores header information (information that is not included in the table window) for all posted vouchers. This table provides information for all the fields relating to voucher information in the Vouchers subtask (except for the Discount Taken and Amt Paid fields), as well as the voucher header information for the Voucher Detail subtasks (both A/P and PO). It also provides all the voucher header information for the Vendor Labor subtask.
  • Voucher Labor Vendor History (VCHR_LAB_VEND_HS): After an A/P or PO voucher is posted, this table stores the data you entered on the Vendor Labor subtask of the Enter A/P or PO Vouchers screens. It also contains a Billable Labor Category Code, which is linked to a PLC description in the Billable Labor Category table. The Vendor Labor subtask uses this table to populate all the fields of its table window, except for the PLC Description.
  • Voucher Line Account History (VCHR_LN_ACCT_HS): This table stores account, organization, project, cost, and tax information for each voucher line after the voucher is posted. It provides the data for all the fields in the Voucher Detail (A/P) table window, expect for the Vchr Line, Description, and Notes fields. It also provides account, organization, project, reference number, and amount information for the Vendor Labor subtask.
  • Voucher Line History (VCHR_LN_HS): This table stores discrepancy, tax, and amount information for each PO voucher line after the voucher has been posted. It also stores line notes and line numbers for all vouchers after they have been posted. The Voucher Line History table provides information for all the fields in the Voucher Detail (PO) table window. It also populates the Voucher Detail (A/P) Line No, Description, and Notes fields.
  • Vendor (VEND): The Vendor table contains information you entered for vendors on the Enter/Manage Vendors screen. The pay vendor's name and location in all Inquiry screens come from this table.
  • Vendor Address (VEND_ADDR): This table stores the vendor address information you entered in the Enter/Manage Vendors screen. It provides the information for the Pay Vendor Address and Phone Info group boxes on the Vendor subtask.
  • Vendor Address Contacts (VEND_ADDR_CNTACT): This table stores the contact information you entered for the vendor in the Contacts subtask of the Enter/Manage Vendors screen. It provides all the information for the Contacts table window.
  • Vendor Check History (VEND_CHK): The Vendor Check History stores check number, date, posting, and cash account and organization information for checks that have already been posted. It provides all the information for the main screen's table window, as well as the check header information for all the subtasks on the Check History Inquiry screen.
  • Vendor Check History Voucher Detail (VEND_CHK_VCHR): The Vendor Check History Detail contains information that links checks to particular vouchers. This information includes the voucher vendor ID, the amount of the check that was applied to the voucher (because many vouchers may be paid by the same check), and the discount taken on posted vouchers. It supplies the data for the Discount Taken and Amount Paid fields on both the Vouchers and Form View subtasks.