AP Check Form Fields
(Created 12/14/2022)
A/P Check Form Database Fields
CHECK_AMOUNT H.CHECK_MEMO H.NAME H.ADDRESS_1 H.ADDRESS_2 H.CITY H.STATE H.ZIP H.SESSION_NO CM_SESSION_NO H.TRANS_NO CM_TRANS_NO D.INVOICE_NO D.INVOICE_DATE D.DUE_DATE D.DISCOUNT_DATE D.RETAINAGE_DATE D.GROSS_AMOUNT D.PAID_AMOUNT D.RETAINAGE_AMOUNT D.PAID_THIS_CHECK D.DISC_THIS_CHECK D.DISC_TAKEN D.DESCRIPTION D.PO_NUMBER V.PARENT_VEND_ID V.CREDIT_LIMIT V.HIGH_CREDIT V.VEND_CLASS V.PAYMENT_TERMS V.TEN99_CLASS V.SECURITY_CLASS V.LAST_PURCHASE_DATE V.LAST_PAY_DATE V.LAST_CHECK_NO V.LAST_BANK_NO V.CREDIT_LIMIT V.PHONE_NO V.FAX_NO V.PAGER_NO V.MOBILE_NO V.EMAIL V.URL V.START_DATE V.LAST_CONTACT_DATE V.MTD_PURCHASES V.YTD_PURCHASES V.LAST_YEAR_PURCHASES V.MTD_PAYMENTS V.YTD_PAYMENTS V.LAST_YEAR_PAYMENTS V.MTD_DISC_TAKEN V.YTD_DISC_TAKEN V.FIN_CHARGE_CODE V.TAX_CODE V.COD_FLAG V.TEMP_FLAG V.TEN99_FLAG V.AUTO_DIST_FLAG V.USER_1 V.USER_2 V.TAX_AUTHORITY C.NAME CONTACT V.SEQUENCE_CODE V.NOTES_1 V.NOTES_2 V.NOTES_3 V.NOTES_4 V.AP_GL V.CASH_GL V.DISC_GL V.EXPENSE_GL V.TAX_ID V.CASH_BANK_NO V.NAME_2 V.VEND_ID
Notes:
- H: Check Header
- D: Check Detail (invoice)
- V: Vendor
- C: Contact
A/P Check Form Calculated Fields
CALC_WRITTENAMT CALC_GROSSTOTAL CALC_DISCTOTAL CALC_VENDADDR1 CALC_VENDADDR2 CALC_VENDADDR3 CALC_VENDADDR4 CHECK_NO COND_INVOICEDESC