Search Results ar_payment_schedules_all




Here's a detailed description of the AR_PAYMENT_SCHEDULES_ALL table in Oracle E-Business Suite:

Table Name: AR_PAYMENT_SCHEDULES_ALL

Purpose:
- Stores payment schedule details for receivables transactions
- Tracks installment and due dates for customer invoices and payments
- Part of the Accounts Receivable (AR) module

Key Columns:
1. PAYMENT_SCHEDULE_ID (Primary Key)
- Unique identifier for each payment schedule record

2. CUSTOMER_ID
- Links to HZ_CUST_ACCOUNTS table
- Identifies the customer associated with the payment schedule

3. AMOUNT_DUE_ORIGINAL
- Original amount due for the payment schedule
- Represents the total invoice or payment amount

4. AMOUNT_DUE_REMAINING
- Remaining balance to be paid
- Tracks unpaid portions of the invoice

5. CLASS
- Indicates the type of payment schedule
- Examples: Invoice, Chargeback, Guarantee, etc.

6. DUE_DATE
- Date when payment is expected
- Used for aging and collections processing

7. GL_DATE
- Accounting date for the payment schedule
- Used for financial reporting and reconciliation

8. STATUS
- Current status of the payment schedule
- Examples: Open, Closed, Partially Paid

9. TRXN_TYPE
- Transaction type associated with the payment schedule
- Helps categorize different types of receivables

Important Relationships:
- Connected to RA_CUSTOMER_TRX_ALL (Transactions)
- Links with HZ_CUST_ACCOUNTS (Customer Accounts)

Typical Use Cases:
- Payment tracking
- Collections management
- Aging analysis
- Invoice installment management