Adjustment
The adjustment view object contains information about adjustments, including adjustment number, adjustment date, receivables activity, accounting date, installment number, installment balance, and adjustment status. The adjustment information is used to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. If an adjustment is created with a receipt, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the cash receipt ID of the entered receipt when the adjustment is created against the invoice, debit memo, or chargeback.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.AdjustmentExtractPVO
Primary Keys : ArAdjustmentAdjustmentId
Initial Extract Date : ArAdjustmentCreationDate
Incremental Extract Date : ArAdjustmentLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ArAdjustmentAcctdAmount | The accounted amount of the adjustment in the ledger currency. |
| ArAdjustmentAdjTaxAcctRule | The numeric code that identifies the tax accounting rule used to create the accounting for the adjustment. |
| ArAdjustmentAdjustmentId | The identifier of the adjustment. |
| ArAdjustmentAdjustmentNumber | The number of the adjustment automatically generated from AR_ADJUSTMENT_NUMBER_S. |
| ArAdjustmentAdjustmentType | The lookup codes for the AR_LOOKUPS adjustment creation type. Valid values are: CHARGES, FREIGHT, INVOICE, LINE and TAX. |
| ArAdjustmentAmount | The adjustment amount. |
| ArAdjustmentApplyDate | The date the adjustment was applied to the installment. |
| ArAdjustmentApprovedBy | The identifier of the user who approved the adjustment. |
| ArAdjustmentAssociatedApplicationId | The identifier of the receipt application associated with the adjustment. |
| ArAdjustmentAssociatedCashReceiptId | The identifier of the cash receipt associated with the adjustment. |
| ArAdjustmentAttribute1 | A segment of the Receivables Adjustment descriptive flexfield 1. |
| ArAdjustmentAttribute10 | A segment of the Receivables Adjustment descriptive flexfield 10. |
| ArAdjustmentAttribute11 | A segment of the Receivables Adjustment descriptive flexfield 11. |
| ArAdjustmentAttribute12 | A segment of the Receivables Adjustment descriptive flexfield 12. |
| ArAdjustmentAttribute13 | A segment of the Receivables Adjustment descriptive flexfield 13. |
| ArAdjustmentAttribute14 | A segment of the Receivables Adjustment descriptive flexfield 14. |
| ArAdjustmentAttribute15 | A segment of the Receivables Adjustment descriptive flexfield 15. |
| ArAdjustmentAttribute2 | A segment of the Receivables Adjustment descriptive flexfield 2. |
| ArAdjustmentAttribute3 | A segment of the Receivables Adjustment descriptive flexfield 3. |
| ArAdjustmentAttribute4 | A segment of the Receivables Adjustment descriptive flexfield 4. |
| ArAdjustmentAttribute5 | A segment of the Receivables Adjustment descriptive flexfield 5. |
| ArAdjustmentAttribute6 | A segment of the Receivables Adjustment descriptive flexfield 6. |
| ArAdjustmentAttribute7 | A segment of the Receivables Adjustment descriptive flexfield 7. |
| ArAdjustmentAttribute8 | A segment of the Receivables Adjustment descriptive flexfield 8. |
| ArAdjustmentAttribute9 | A segment of the Receivables Adjustment descriptive flexfield 9. |
| ArAdjustmentAttributeCategory | The descriptive flexfield context name of the Receivables Adjustment descriptive flexfield. |
| ArAdjustmentAutomaticallyGenerated | |
| ArAdjustmentAxAccountedFlag | The option that indicates whether the distributions have been upgraded. |
| ArAdjustmentBatchId | The identifier of the batch associated with the adjustment. |
| ArAdjustmentChargebackCustomerTrxId | The identifier of the chargeback transaction associated with the adjustment. |
| ArAdjustmentCodeCombinationId | The General Ledger account code combination of the adjustment. |
| ArAdjustmentComments | The user-entered comments about the adjustment. |
| ArAdjustmentConsInvId | The consolidated bill number of the balance forward bill that the adjustment belongs to. |
| ArAdjustmentCreatedBy | The user who created the adjustment. |
| ArAdjustmentCreatedFrom | The name of the process that created the adjustment. |
| ArAdjustmentCreationDate | The date and time the adjustment was created. |
| ArAdjustmentCustomerTrxId | The identifier of the customer transaction associated with the adjustment. |
| ArAdjustmentCustomerTrxLineId | The identifier of the customer transaction line associated with the adjustment. |
| ArAdjustmentDistributionSetId | The identifier of the distribution set associated with the adjustment. |
| ArAdjustmentDocSequenceId | The identifier of the document sequence assigned to the adjustment document category. |
| ArAdjustmentDocSequenceValue | The document sequence number assigned to the adjustment. |
| ArAdjustmentEventId | The identifier of the adjustment subledger accounting event. |
| ArAdjustmentFreightAdjusted | The freight amount adjusted as part of the adjustment. |
| ArAdjustmentGlDate | The adjustment accounting date. |
| ArAdjustmentGlPostedDate | The date the adjustment was posted to General Ledger. |
| ArAdjustmentGlobalAttribute1 | A segment of the Receivables Adjustment global descriptive flexfield 1. |
| ArAdjustmentGlobalAttribute10 | A segment of the Receivables Adjustment global descriptive flexfield 10. |
| ArAdjustmentGlobalAttribute11 | A segment of the Receivables Adjustment global descriptive flexfield 11. |
| ArAdjustmentGlobalAttribute12 | A segment of the Receivables Adjustment global descriptive flexfield 12. |
| ArAdjustmentGlobalAttribute13 | A segment of the Receivables Adjustment global descriptive flexfield 13. |
| ArAdjustmentGlobalAttribute14 | A segment of the Receivables Adjustment global descriptive flexfield 14. |
| ArAdjustmentGlobalAttribute15 | A segment of the Receivables Adjustment global descriptive flexfield 15. |
| ArAdjustmentGlobalAttribute16 | A segment of the Receivables Adjustment global descriptive flexfield 16. |
| ArAdjustmentGlobalAttribute17 | A segment of the Receivables Adjustment global descriptive flexfield 17. |
| ArAdjustmentGlobalAttribute18 | A segment of the Receivables Adjustment global descriptive flexfield 18. |
| ArAdjustmentGlobalAttribute19 | A segment of the Receivables Adjustment global descriptive flexfield 19. |
| ArAdjustmentGlobalAttribute2 | A segment of the Receivables Adjustment global descriptive flexfield 2. |
| ArAdjustmentGlobalAttribute20 | A segment of the Receivables Adjustment global descriptive flexfield 20. |
| ArAdjustmentGlobalAttribute3 | A segment of the Receivables Adjustment global descriptive flexfield 3. |
| ArAdjustmentGlobalAttribute4 | A segment of the Receivables Adjustment global descriptive flexfield 4. |
| ArAdjustmentGlobalAttribute5 | A segment of the Receivables Adjustment global descriptive flexfield 5. |
| ArAdjustmentGlobalAttribute6 | A segment of the Receivables Adjustment global descriptive flexfield 6. |
| ArAdjustmentGlobalAttribute7 | A segment of the Receivables Adjustment global descriptive flexfield 7. |
| ArAdjustmentGlobalAttribute8 | A segment of the Receivables Adjustment global descriptive flexfield 8. |
| ArAdjustmentGlobalAttribute9 | A segment of the Receivables Adjustment global descriptive flexfield 9. |
| ArAdjustmentGlobalAttributeCategory | The global descriptive flexfield context name of the Receivables Adjustment global descriptive flexfield. |
| ArAdjustmentInterestHeaderId | The unique identifier of the late charge adjustment header. This is a foreign key of the adjustment header view object. |
| ArAdjustmentInterestLineId | The unique identifier of the late charge adjustment line. This is a foreign key of the adjustment line view object. |
| ArAdjustmentLastUpdateDate | The date and time the adjustment was last updated. |
| ArAdjustmentLastUpdateLogin | The session login of the user who last updated the adjustment. |
| ArAdjustmentLastUpdatedBy | The user who last updated the adjustment. |
| ArAdjustmentLineNonrecoverable | The nonrecoverable adjustment amount on the transaction line. |
| ArAdjustmentLinkToTrxHistId | The identifier of the transaction history record associated with approved endorsements for the matured pending risk elimination endorsement. |
| ArAdjustmentObjectVersionNumber | The number used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of an adjustment to detect whether another session has updated the row since it was queried. |
| ArAdjustmentOrgId | The identifier of the business unit associated with the adjustment. |
| ArAdjustmentPaymentScheduleId | The identifier of the payment schedule associated with the adjustment. |
| ArAdjustmentPostable | The option that indicates whether the adjustment is postable. Valid values are: Y - postable, Null - not postable. |
| ArAdjustmentPostingControlId | The identifier of the Receivables posting batch. Valid values are: -1, -2, and -4 for posted in previous releases, and -3 for not posted. |
| ArAdjustmentProgramApplicationId | The identifier of the application that last updated the adjustment. |
| ArAdjustmentProgramId | The identifier of the process that last updated the adjustment. |
| ArAdjustmentProgramUpdateDate | The date a process last updated the adjustment. |
| ArAdjustmentReasonCode | The code that indicates the reason for the adjustment. |
| ArAdjustmentReceivablesChargesAdjusted | The adjustment charges associated with the adjustment. |
| ArAdjustmentReceivablesTrxId | The identifier of the transaction associated with the adjustment. |
| ArAdjustmentRequestId | The request identifier of the process that created or last updated the adjustment. |
| ArAdjustmentSetOfBooksId | The primary ledger associated with the adjustment. |
| ArAdjustmentStatus | The approval status of the adjustment. Valid values are: A - Approved, U - Unaccrued adjustments, R - Rejected, and any other codes for unapproved. |
| ArAdjustmentSubsequentTrxId | The identifier of the customer transaction against the adjustment. |
| ArAdjustmentTaxAdjusted | The adjusted tax amount of the adjustment. |
| ArAdjustmentTaxNonrecoverable | The nonrecoverable tax amount of the adjustment. |
| ArAdjustmentType | The name of the adjustment lookup type under AR_LOOKUPS. |
| ArAdjustmentUpgradeMethod | The option that indicates the origin of the adjustment upgrade method. |
| ArAdjustmentUssglTransactionCode | The value of the USSGL Transaction Code flexfield. |
| ArAdjustmentUssglTransactionCodeContext | The context value of the USSGL Transaction Code flexfield. |
| LineAdjusted | The line amount adjusted as part of the adjustment. |