Customer Open Accounts Receivable Management Database Information

Data for Customer Open Accounts Receivable Management is stored in multiple tables.

Results Tab Fields

Field

Field Name/Table

Transactions

This grid includes the following columns:

  • Ref# - ref-num in ar-open

  • Ref Type - ref-type in ar-open

  • Status - is-open in ar-open

  • Ref Date - ref-date in ar-open

  • Due Date - due-date in ar-open

  • Customer PO# - cust-po-number in ar-open

  • Original Amount - orig-amt x ent-currency-conversion-rate in ar-open

  • Open Amount - open-amt x ent-currency-conversion-rate in ar-open

  • Reminder Date - reminder-date in ar-open

  • Open Amount (Entered Currency) - open-amt in ar-open

  • Billing Customer Code - billing-customer-key in ar-open

  • Paying Customer Code - payer-customer-key in ar-open

  • Customer Code - cust-key in ar-open

  • Customer Ref# - cust-ref-num in ar-open

  • Disputed - disputed-invoice in ar-open

  • Disputed Date - disputed-invoice-date in ar-open

  • Dispute Logged by - disputed-invoice-by in ar-open

  • Entered Currency - entered-currency in ar-open

  • Reminder - reminder in ar-open

  • Reminder Done - reminder-date in ar-open

  • Reminder User - reminder-user in ar-open

  • Manual Task - manual-task in ar-open

  • Chargeback Reminder Date - cb-reminder-date in ar-open

  • RA# - ra-num in ar-open

  • Payment Terms - terms-key in arinvhdr

  • First Order Number - For invoices and credit memos: order-num in the first related oe-join-order-invoice record; For prepayments: order-num in the first related ar-dep-prepay record

  • Chargeback User Defined 1-10  - For chargebacks: user-defined-01-10 in ar-chrgbcks