Receivable Application
The receivable application view object contains accounting entries for cash and credit memo applications, including transaction applied, installment, application type, amount applied, discounts, days late, application rule, and application status. Valid statuses are: APP-applied, UNAPP-unapplied, ACC-on account, UNID-unidentified, ACTIVITY-receivable activity, and OTHER ACC-other application. Total amount applied for cash applications should equal the cash receipt amount. A negative amount applied value becomes debit when the application is posted to GL. Upon cash receipt creation, an unapplied record for cash receipt amount is created. For each subsequent application, one applied record for amount applied to invoice and one unapplied record for the negative of applied amount are created. If a cash application is reversed, one applied record for the negative of the original application amount and one unapplied record for the positive amount of the application are created.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.ReceivableApplicationExtractPVO
Primary Keys : ArReceivableApplicationReceivableApplicationId
Initial Extract Date : ArReceivableApplicationCreationDate
Incremental Extract Date : ArReceivableApplicationLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
ArReceivableApplicationAcctdAmountAppliedFrom | The portion of the receipt amount that is converted to the ledger currency. |
ArReceivableApplicationAcctdAmountAppliedTo | The portion of the transaction amount that is converted to the ledger currency. |
ArReceivableApplicationAcctdEarnedDiscountTaken | The earned discount equivalent in the ledger currency converted using the transaction conversion rate. |
ArReceivableApplicationAcctdUnearnedDiscountTaken | The unearned discount equivalent in the ledger currency converted using the transaction conversion rate. |
ArReceivableApplicationAmountApplied | For ledger currency transactions and receipts, the total applied amount in the ledger currency. For cross-currency transactions and receipts, the total applied amount in the transaction currency. |
ArReceivableApplicationAmountAppliedFrom | For cross-currency applications only, the total applied amount in the receipt currency. |
ArReceivableApplicationApplicationRefId | The identifier of the reference number used for special applications or receipt-to-receipt applications. |
ArReceivableApplicationApplicationRefNum | The displayed reference number used for special applications or receipt-to-receipt applications. |
ArReceivableApplicationApplicationRefReason | The application reason code whose context is determined by the application reference type value. |
ArReceivableApplicationApplicationRefType | The application reference type that determines the context for the application reference number. A list of accepted values is defined in the lookup type APPLICATION_REF_TYPE. |
ArReceivableApplicationApplicationRule | The code used to identify which SQL statements in the modules created this record. |
ArReceivableApplicationApplicationType | The lookup code used to identify the Receivable Application type. A list of accepted values is defined in the lookup type APPLICATION_TYPE lookup code. |
ArReceivableApplicationAppliedCustomerTrxId | The identifier of the debit item or credit item to which a payment or credit memo is applied. |
ArReceivableApplicationAppliedCustomerTrxLineId | The line number of the debit item or credit item to which a payment or credit memo is applied |
ArReceivableApplicationAppliedPaymentScheduleId | The identifier of the payment schedule of the debit item or credit item to which a payment or credit memo is applied. |
ArReceivableApplicationAppliedRecAppId | The identifier of the Receivable application record to which the payment is applied. |
ArReceivableApplicationApplyDate | The receipt application date. |
ArReceivableApplicationAttribute1 | A segment of the Receivable Application descriptive flexfield 1. |
ArReceivableApplicationAttribute10 | A segment of the Receivable Application descriptive flexfield 10. |
ArReceivableApplicationAttribute11 | A segment of the Receivable Application descriptive flexfield 11. |
ArReceivableApplicationAttribute12 | A segment of the Receivable Application descriptive flexfield 12. |
ArReceivableApplicationAttribute13 | A segment of the Receivable Application descriptive flexfield 13. |
ArReceivableApplicationAttribute14 | A segment of the Receivable Application descriptive flexfield 14. |
ArReceivableApplicationAttribute15 | A segment of the Receivable Application descriptive flexfield 15. |
ArReceivableApplicationAttribute2 | A segment of the Receivable Application descriptive flexfield 2. |
ArReceivableApplicationAttribute3 | A segment of the Receivable Application descriptive flexfield 3. |
ArReceivableApplicationAttribute4 | A segment of the Receivable Application descriptive flexfield 4. |
ArReceivableApplicationAttribute5 | A segment of the Receivable Application descriptive flexfield 5. |
ArReceivableApplicationAttribute6 | A segment of the Receivable Application descriptive flexfield 6. |
ArReceivableApplicationAttribute7 | A segment of the Receivable Application descriptive flexfield 7. |
ArReceivableApplicationAttribute8 | A segment of the Receivable Application descriptive flexfield 8. |
ArReceivableApplicationAttribute9 | A segment of the Receivable Application descriptive flexfield 9. |
ArReceivableApplicationAttributeCategory | The descriptive flexfield context name for the Receivable Application descriptive flexfield. |
ArReceivableApplicationCashReceiptHistoryId | The unique identifier of the cash receipt history table. This is a foreign key of the Receivable Application view object. |
ArReceivableApplicationCashReceiptId | The identifier of a cash receipt payment. |
ArReceivableApplicationChargesEdiscounted | The amount of the earned discount taken from the remaining open amount on the item. |
ArReceivableApplicationChargesUediscounted | The amount of the unearned discount taken from the remaining open amount on the item. |
ArReceivableApplicationCodeCombinationId | The unique identifier of the General Ledger account code combination. |
ArReceivableApplicationComments | The user comments for the receipt application. |
ArReceivableApplicationConfirmedFlag | The option that indicates whether the cash receipt is confirmed. The value No indicates that the cash receipt is not confirmed. Always use NVL--CONFIRMED_FLAG is Y--when checking this column. |
ArReceivableApplicationConsInvId | The identifier of a consolidated invoice against which an adjustment is applied. |
ArReceivableApplicationConsInvIdTo | The identifier of a consolidated invoice that contains the application to a different customer site, when either cash or a credit memo is applied to a customer site that is different from the site originally assigned to the cash or credit memo transaction. |
ArReceivableApplicationCreatedBy | The user who created the Receivable application. |
ArReceivableApplicationCreationDate | The date and time the Receivable application was created. |
ArReceivableApplicationCustomerReason | The customer reason for deductions and chargebacks associated with an application. |
ArReceivableApplicationCustomerReference | The reference provided by the customer for the Receivable application. |
ArReceivableApplicationCustomerTrxId | The identifier of the debit item or credit memo that is applied. |
ArReceivableApplicationDaysLate | The number of days between the Receivable application date and the transaction due date. |
ArReceivableApplicationDisplay | The option that indicates whether the application against the transaction is the latest. |
ArReceivableApplicationEarnedDiscountCcid | The unique identifier of the General Ledger earned discount code combination. |
ArReceivableApplicationEarnedDiscountTaken | The amount of earned discount taken toward the application. |
ArReceivableApplicationEdiscTaxAcctRule | The option that indicates the rule used to create accounting for tax on earned discounts. |
ArReceivableApplicationEventId | The identifier of the Subledger accounting event for the Receivable application. |
ArReceivableApplicationExceptionReasonCode | The reason a receipt was applied manually to the transaction. |
ArReceivableApplicationFreightApplied | The amount applied to the transaction freight. |
ArReceivableApplicationFreightEdiscounted | The amount of earned discount taken from the remaining freight amount for the item. |
ArReceivableApplicationFreightUediscounted | The amount of unearned discount taken from the remaining freight amount for the item. |
ArReceivableApplicationGlDate | The date when the application will post to the General Ledger. |
ArReceivableApplicationGlPostedDate | The date when the application was posted to the General Ledger. |
ArReceivableApplicationGlobalAttribute1 | A segment of the Receivable Application global descriptive flexfield 1. |
ArReceivableApplicationGlobalAttribute10 | A segment of the Receivable Application global descriptive flexfield 10. |
ArReceivableApplicationGlobalAttribute11 | A segment of the Receivable Application global descriptive flexfield 11. |
ArReceivableApplicationGlobalAttribute12 | A segment of the Receivable Application global descriptive flexfield 12. |
ArReceivableApplicationGlobalAttribute13 | A segment of the Receivable Application global descriptive flexfield 13. |
ArReceivableApplicationGlobalAttribute14 | A segment of the Receivable Application global descriptive flexfield 14. |
ArReceivableApplicationGlobalAttribute15 | A segment of the Receivable Application global descriptive flexfield 15. |
ArReceivableApplicationGlobalAttribute16 | A segment of the Receivable Application global descriptive flexfield 16. |
ArReceivableApplicationGlobalAttribute17 | A segment of the Receivable Application global descriptive flexfield 17. |
ArReceivableApplicationGlobalAttribute18 | A segment of the Receivable Application global descriptive flexfield 18. |
ArReceivableApplicationGlobalAttribute19 | A segment of the Receivable Application global descriptive flexfield 19. |
ArReceivableApplicationGlobalAttribute2 | A segment of the Receivable Application global descriptive flexfield 2. |
ArReceivableApplicationGlobalAttribute20 | A segment of the Receivable Application global descriptive flexfield 20. |
ArReceivableApplicationGlobalAttribute3 | A segment of the Receivable Application global descriptive flexfield 3. |
ArReceivableApplicationGlobalAttribute4 | A segment of the Receivable Application global descriptive flexfield 4. |
ArReceivableApplicationGlobalAttribute5 | A segment of the Receivable Application global descriptive flexfield 5. |
ArReceivableApplicationGlobalAttribute6 | A segment of the Receivable Application global descriptive flexfield 6. |
ArReceivableApplicationGlobalAttribute7 | A segment of the Receivable Application global descriptive flexfield 7. |
ArReceivableApplicationGlobalAttribute8 | A segment of the Receivable Application global descriptive flexfield 8. |
ArReceivableApplicationGlobalAttribute9 | A segment of the Receivable Application global descriptive flexfield 9. |
ArReceivableApplicationGlobalAttributeCategory | The descriptive flexfield context name for the Receivable Application global descriptive flexfield. |
ArReceivableApplicationGlobalAttributeDate1 | A segment of the Receivable Application Date global descriptive flexfield 1. |
ArReceivableApplicationGlobalAttributeDate2 | A segment of the Receivable Application Date global descriptive flexfield 2. |
ArReceivableApplicationGlobalAttributeDate3 | A segment of the Receivable Application Date global descriptive flexfield 3. |
ArReceivableApplicationGlobalAttributeDate4 | A segment of the Receivable Application Date global descriptive flexfield 4. |
ArReceivableApplicationGlobalAttributeDate5 | A segment of the Receivable Application Date global descriptive flexfield 5. |
ArReceivableApplicationGlobalAttributeNumber1 | A segment of the Receivable Application Number global descriptive flexfield 1. |
ArReceivableApplicationGlobalAttributeNumber2 | A segment of the Receivable Application Number global descriptive flexfield 2. |
ArReceivableApplicationGlobalAttributeNumber3 | A segment of the Receivable Application Number global descriptive flexfield 3. |
ArReceivableApplicationGlobalAttributeNumber4 | A segment of the Receivable Application Number global descriptive flexfield 4. |
ArReceivableApplicationGlobalAttributeNumber5 | A segment of the Receivable Application Number global descriptive flexfield 5. |
ArReceivableApplicationLastUpdateDate | The date and time of the last update to the receipt. |
ArReceivableApplicationLastUpdateLogin | The session login of the user who last updated the receipt. |
ArReceivableApplicationLastUpdatedBy | The user who last updated the receipt. |
ArReceivableApplicationLineApplied | The amount of the receipt applied to the transaction line amount. |
ArReceivableApplicationLineEdiscounted | The amount of the earned discount taken from the remaining open amount on the transaction line. |
ArReceivableApplicationLineUediscounted | The amount of the unearned discount taken from the remaining open amount on the transaction line. |
ArReceivableApplicationLinkToCustomerTrxId | This column is used to reference the transaction associated with a short term debt application. |
ArReceivableApplicationLinkToTrxHistId | This column is used to reference the transaction history record associated with the movement of deferred tax due either to a maturity date event or its subsequent reversal event. |
ArReceivableApplicationObjectVersionNumber | The number of times the receipt was updated. |
ArReceivableApplicationOrgId | The identifier of the business unit. |
ArReceivableApplicationPaymentScheduleId | The identifier of the payment schedule of the payment or credit memo applied to the transaction. |
ArReceivableApplicationPaymentSetId | The identifier of the payment set of the prepayment application. |
ArReceivableApplicationPostable | The option that indicates whether the item can be posted to General Ledger. |
ArReceivableApplicationPostingControlId | The identifier of the Receivables posting batch. Valid values are: -1, -2, and -4 if posted in previous releases, -3 if not posted. |
ArReceivableApplicationProgramApplicationId | The identifier of the application that last updated the receipt application. |
ArReceivableApplicationProgramId | The identifier of the process that last updated the receipt application. |
ArReceivableApplicationProgramUpdateDate | The date a process last updated the receipt application. |
ArReceivableApplicationReceivableApplicationId | The identifier of the receipt application to the transaction. |
ArReceivableApplicationReceivablesChargesApplied | The amount of the Receivables charges applied to the transaction. |
ArReceivableApplicationReceivablesTrxId | The identifier of the Receivables activity. |
ArReceivableApplicationRequestId | The request identifier of the process that created or last updated the receipt application. |
ArReceivableApplicationReversalGlDate | The accounting date for both reversed receipts and the accompanying reverse activity. |
ArReceivableApplicationRuleSetId | The identifier of the Receivable application rule set. |
ArReceivableApplicationSecondaryApplicationRefId | The secondary application reference identifier of another transaction or application, such as a claim, that is associated with this receipt application. |
ArReceivableApplicationSecondaryApplicationRefNum | The receipt application reference number displayed to the user. |
ArReceivableApplicationSecondaryApplicationRefType | The identifier of the receipt application reference type that determines the context for the SECONDARY_APPLICATION_REF_ID and SECONDARY_APPLICATION_REF_NUM columns. A list of accepted values is defined in the lookup type APPLICATION_REF_TYPE. |
ArReceivableApplicationSetOfBooksId | The identifier of the primary ledger associated with the receipt application. |
ArReceivableApplicationStatus | The lookup code used to display the status of the receipt application. |
ArReceivableApplicationTaxApplied | The amount of tax associated to the receipt. |
ArReceivableApplicationTaxCode | The tax rate code related to on-account transactions. |
ArReceivableApplicationTaxEdiscounted | The amount of earned discount taken from the remaining tax amount for the item. |
ArReceivableApplicationTaxUediscounted | The amount of unearned discount taken from the remaining tax amount for the item. |
ArReceivableApplicationTransToReceiptRate | For cross-currency applications only, the conversion rate used to convert the amount applied in the transaction currency to the amount applied in the receipt currency. |
ArReceivableApplicationUnearnedDiscountCcid | The General Ledger code combination used for the unearned discount. |
ArReceivableApplicationUnearnedDiscountTaken | The amount of unearned discount taken for the receipt application. |
ArReceivableApplicationUnediscTaxAcctRule | The option that indicates the rule used to create the accounting for tax on unearned discounts. |
ArReceivableApplicationUpgradeMethod | The option that indicates the source of the receipt application. |
ArReceivableApplicationUssglTransactionCode | The transaction code defined under Public Sector accounting. |
ArReceivableApplicationUssglTransactionCodeContext | The context value for the USSGL Transaction Code Flexfield. |