Receivable Invoice Detail
Analyze by Dates:
- Payment Due Date
- Transaction Date
| Measure | Source and/or calculation |
|---|---|
| Adjustment Amount Currency Amount | AdjustmentAmountCurrencyAmount |
| Application Amount Currency Amount | ApplicationAmountCurrencyAmount |
| Base Adjust Amount | BaseAdjustAmount |
| Base Amount | BaseAmount |
| Base Open Amount | Invoice Amount Currency Amount - (Application Amount Currency Amount + Adjustment Amount Currency Amount)) |
| Discount Amount 1 | DiscountAmountOrigDiscAmt1 |
| Discount Amount 2 | DiscountAmountOrigDiscAmt2 |
| Discount Amount 3 | DiscountAmountOrigDiscAmt3 |
| Gain Loss Amount | GainLossAmount |
| Invoice Amount Currency Amount | InvoiceAmountCurrencyAmount |
| ReceivableInvoiceDetailKey | ReceivableInvoiceDetailKey |
| Signed Applied Amount |
IF (Receivable Invoice Detail Type Code = 'C') THEN Signed Applied Amount = Application Amount Currency Amount * (-1) ELSE Signed Applied Amount = Application Amount Currency Amount |
| Signed Base Amount |
IF Receivable Invoice Detail Type Code = 'C' THEN Signed Base Amount = Invoice Amount Currency Amount * (-1) ELSE Signed Base Amount = Invoice Amount Currency Amount |
| Signed Base Open Amount |
IF Receivable Invoice Detail Type Code = 'C' THEN Signed Base Open Amount = (Invoice Amount Currency Amount - (Application Amount Currency Amount + Adjustment Amount Currency Amount)) * (-1) ELSE Signed Base Open Amount = Invoice Amount Currency Amount - (Application Amount Currency Amount + Adjustment Amount Currency Amount) |