Friday, October 05, 2012

IBY_USED_PAYMENT_DOCS Column Description


This table stores check numbers that have been used in Accounts Payable Module. Four main columns of this table are











Column NameDescription
PAYMENT_DOCUMENT_IDForeign key to CE_PAYMENT_DOCUMENTS
USED_DOCUMENT_NUMBERRefers to PAPER_DOCUMENT_NUMBER column of IBY_PAYMENTS_ALL
DOCUMENT_USELookup code of Type 'IBY_PAYMENT_DOCUMENT_USES', but at my site, this column is always equal to 'ISSUED' although we have many voided, overflown check payments
DATE_USEDDocument Date

No comments:

Post a Comment