Channel Supplier Accruals
The Channel Supplier Accruals view object contains information about accruals owed by a supplier site based on the supplier programs. Additionally, it contains information documenting the lifecycle of the accrual, from the source transaction, how it was interfaced in, the program and product rule used to calculate the accrual, how it was interfaced out to Financials cloud, and confirmed settlement details from Financials cloud.
Data Store Key : FscmTopModelAM.ScmExtractAM.CjmBiccExtractAM.ProgramUtilExtractPVO
Primary Keys : UtilizationId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccrualQty | Number that identifies the quantity of the accrual in the accrual UOM, which is converted if the inventory UOM does match the program UOM. |
| AccrualQtyInInvUom | Number that identifies the original quantity in the inventory UOM. For the receipt match option, this is the receipt quantity in the receipt UOM. For the PO match option, this is the PO quantity in the PO UOM. |
| AccrualQtyInProgLineUom | Number that identifies the quantity in the product rule UOM, which is converted if the source transaction UOM and product rule UOM are different. |
| AccrualTrxType | Value that identifies the type of source transaction accrued. Contains one of the following values: RECEIPT, INVOICE, ORDER. |
| AccrualType | Code that identifies whether the accrual is for a supplier or customer. A list of accepted values is defined in the lookup ORA_CJM_ACCRUAL_TYPES. |
| AccrualUom | Code that uniquely identifies the UOM of the accrual. This is the foreign key to the Unit of Measures view object. |
| AcctdAmount | Amount that identifies the earned amount of the accrual in the ledger currency. |
| AcctdAmountRemaining | Amount that identifies the amount remaining of the accrual in the ledger currency. |
| AdjustmentDate | Date when the adjustment was created. |
| AdjustmentReasonId | Value that uniquely identifies the adjustment reason. This is the foreign key to the Channel Adjustments Reasons view object. |
| AdjustmentType | Value that identifies the adjustment type. |
| AdjustmentTypeId | Value that uniquely identifies the adjustment type used for adjusting accruals. This is a foreign key to the Channel Adjustments Types view object. |
| BillOfLadingNumber | Value that identifies the bill of lading number from the source transaction. |
| BillToCustomerId | Value that uniquely identifies the bill-to customer account of the sales order of the source transaction. |
| BillToLocationId | Value that uniquely identifies the purchase order bill-to location of the adjustment. This is a foreign key to HR_LOCATIONS_ALL.LOCATION_ID. |
| BuId | Value that uniquely identifies the business unit of the accrual. |
| CategoryId | Value that uniquely identifies the product category of the product rule. This is the foreign key to the Categories view object. |
| ChargeDefinitionCode | Code that uniquely identifies the charge definition used to price the accrual. This is a foreign key to the Order Charge Components view object. |
| CreatedBy | User who created the supplier accrual. |
| CreationDate | Date and time when the supplier accrual was created. |
| CustomerTrxLineId | Value that uniquely identifies the invoice line from the sales order line of the source transaction. This is a foreign key to Sales Order Headers view object. |
| DiscountAmount | Amount that indicates the discount percentage or per unit amount from the product rule that's used to calculate the accrual. |
| DiscountType | Value that indicates the discount type such as percent or per unit amount from the product rule that's used to calculate the accrual. |
| DistributorId | Value that identifies the actual supplier from whom you purchased items from when they're an alternate supplier of the program accrued, and the accrual is paid by the program supplier site. This attribute is blank when purchased directly from the supplier of the program accrued. |
| DistributorSiteId | Value that identifies the actual supplier site from whom you purchased items from when they're an alternate supplier site of the program accrued, and the accrual is paid by the program supplier site. This attribute is blank when purchased directly from the supplier site of the program accrued. |
| DocumentProgramId | Value that unique identifies the program during accrual calculation. This is the foreign key to the CJM_DOCUMENT_PROGRAMS table. |
| EarnedAccrualsEvent | Value that identifies the GL post event for the earned accrual. |
| ExchangeRate | Value that identifies the exchange rate type used to convert source transaction amounts when the source transaction currency doesn't match the ledger currency. |
| ExchangeRateDate | Date used when converting the amount from the source transaction currency to the ledger currency. |
| ExchangeRateType | Rate type used to convert the amount from the source transaction currency to the ledger currency. |
| GlDate | Date when the earned accrual was posted. |
| GlPostedFlag | Status of the GL posting. Contains one of the following values: Y, F or N. If Y, then the earned accrual posted successfully. If F, then the earned accrual posting failed due to errors and will be reprocessed in the next run. If N, then the earned accrual isn't yet posted. |
| InvoiceDate | Date of the sales invoice for a supplier ship and debit accrual. |
| InvoiceId | Value that uniquely identifies the sales invoice used for the supplier ship and debit accrual. |
| InvoiceLineNumber | Value that identifies the sales invoice line number used for the supplier ship and debit accrual. |
| InvoiceNumber | Value that identifies the sales invoice number used for the supplier ship and debit accrual. |
| InvoiceSourceApplication | Value that identifies the source application for either supplier invoices or sales invoices. This attribute is applicable to supplier rebate accruals and supplier ship and debit accruals respectively. Contains one of the following values: AP or AR. If AR, then it indicates a supplier ship and debit accrual. If AP, then it indicates a supplier rebate accrual. |
| InvoiceSourceCode | Code that identifies the application name of the sales invoice. Applicable to supplier ship and debit adjustments only. Contains the value, Distributed Order Orchestration. |
| ItemId | Value that uniquely identifies the item accrued. This is a foreign key to the Items view object. |
| ItemLevelCode | Code that identifies the item level in the product rule used to construct exclusion and category based product rules. A list of accepted values is defined in the lookup type ORA_CJM_ITEM_LEVEL including: ITEM, CATEGORY, ALL_ITEMS. |
| JobDefinitionName | Name of the scheduled process that created or last updated the supplier accrual row. This is populated through Enterprise Service Scheduler. |
| JobDefinitionPackage | Value that identifies the package name of the scheduled process that created or last updated the row. |
| LastUpdateDate | Date and time when the supplier accrual row was last updated. |
| LastUpdateLogin | User who last updated the supplier accrual row. |
| LastUpdatedBy | Session login associated with the user who last updated the supplier accrual. |
| ManualAdjustmentId | Value that uniquely identifies the manual adjustment if the accrual is based on an adjustment. This is the foreign key to the Channel Adjustments view object. A single manual adjustment can create multiple records in this view object if the decrease earned adjustment uses first-in first-out logic. |
| MatchOption | Value that identifies whether the shipment invoice should match the purchase order or the receipt. This is denormalized from the CJM_DOCUMENT_LINES_ALL table during accrual calculation for supplier rebates through direct integration. |
| ObjectId | Value that uniquely identifies the source transaction header of the accrual when the object type is provided. If the object type is DOCUMENT, then the value is the foreign key to the CJM_DOCUMENT_HEADERS_ALL table used for supplier rebate accruals. If the object type is ORDER, then the value is the foreign key to the Sales Order Headers view object used for supplier ship and debit accruals. This attribute is blank and not applicable for supplier annual programs. |
| ObjectLineId | Value that uniquely identifies the source transaction line of the accrual when the object type is provided. If the object type is DOCUMENT, then the value is the foreign key to the CJM_DOCUMENT_LINES_ALL table used for supplier rebate accruals. If the object type is ORDER, then the value is the foreign key to the Sales Order Lines view object used for supplier ship and debit accruals. Alternate key that identifies the Order Charges and Order Charge Components view objects. |
| ObjectType | Code that identifies the view object or table where the source transaction is stored for an accrual. The ObjectTypeCode, ObjectId, ObjectLineId combine to uniquely identify a source transaction. Contains one of the following values: ORDER or DOCUMENT. If ORDER, then indicates the source transaction is stored in the Sales Order Headers view object for supplier ship and debit accruals. If DOCUMENT, then indicates the source transaction is stored in the CJM_DOCUMENT_HEADERS_ALL table for supplier rebates accruals. This attribute is blank for supplier annual program accruals. |
| ObjectVersionNumber | Number of times the object line row of the source transaction has been updated. |
| OrigUtilizationId | Value that uniquely identifies the original accrual from a split scenario or RMA in the Channel Supplier Accruals view object. |
| PeriodName | Value that uniquely identifies the period name of the accrual. |
| PoHeaderId | Value that uniquely identifies the purchase order used in the utilization transaction. |
| PoLineLocationId | Value that uniquely identifies the purchase order line location for the source transaction. This is a foreign key to Purchasing Document Header Line Locations view object. |
| PoNumber | Value that identifies the purchase order number used in the utilization transaction. |
| PriceElementCode | Code that uniquely identifies the element of the price. This attribute is a part of the composite primary key of the Order Charge Components view object. |
| PricePeriodicityCode | Code that identifies the periodicity of the pricing rule used to calculate the accrual. This attribute is a part of the composite primary key of the Order Charge Components view object. |
| PricingSourceId | Value that uniquely identifies the pricing term or lowest level pricing source used to calculate the accrual. This is a foreign key to the Pricing Term view object. |
| PricingSourceTypeCode | Code that identifies the type of the product rule pricing source used to calculate the accrual. |
| ProgramAmount | Amount that identifies the earned amount of the accrual in the program currency. |
| ProgramAmountRemaining | Amount that identifies the remaining accrual amount in program currency. |
| ProgramCurrencyCode | Code that identifies the currency of the program associated with the accrual. |
| ProgramHeaderId | Value that uniquely identifies the program. This is the foreign key to the Channel Programs view object. |
| ProgramLineId | Value that uniquely identifies the program product rule. This is the foreign key to the Channel Program Product Rules view object. |
| ProgramLineUomCode | Code that identifies the unit of measure of the item in the product rule used to calculate the accrual. |
| ReceiptId | Value that uniquely identifies the receiving receipt of the utilization transaction. This is the foreign key to the Receiving Receipt Transactions view object. |
| ReceiptNumber | Value that identifies the receiving receipt number of the utilization transaction. |
| ReferenceId | Value that uniquely identifies the batch when the reference type is BATCH. This is a foreign key to the CJM_DOCUMENT_BATCHES_ALL table. |
| ReferenceType | Value that identifies the how the source transaction was interfaced into channel. Contains one of the following values: BATCH or SSD. |
| RequestId | Value that uniquely identifies the scheduled process that created or last updated the row. |
| RequestedGlDate | Date when accrual accounting is requested. During a sweep fix, if the period is closed, then the records get posted in the next open GL period and this attribute is updated with the actual GL posted date. For manual adjustments, a user-entered date can be a past date or the system date. |
| SeededProgramTypeCode | Code that uniquely identifies the predefined program template of the supplier program used to calculate accruals. A list of accepted values is defined in the lookup type ORA_CJM_PROGRAM_TYPES, but only buy-side templates are applicable. |
| ShipToLocationId | Value that uniquely identifies the purchase order ship to location. This is a foreign key to HR_LOCATIONS_ALL.LOCATION_ID. |
| ShipmentDate | Date when source transaction was actually shipped. |
| ShipmentNumber | Value that identifies the shipment number of the source transaction. |
| SourceTrxAcctdAmount | Amount that identifies the line amount of the source transaction in ledger currency. |
| SourceTrxAmountInPrgCurr | Amount that identifies the line amount of the source transaction in program currency. |
| SourceTrxAmountInTrxCurr | Amount that identifies the line amount of the source transaction in source transaction currency. |
| TpItemId | Value that uniquely identifies the supplier item if provided during adjustment creation or in the product rule. This is a foreign key to the Trading Partner Items view object. |
| TransactionCurrAmount | Monetary amount that identifies the earned amount of the accrual in the source transaction currency. |
| TransactionCurrAmountRem | Monetary amount that identifies the remaining amount of the accrual in the source transaction currency yet to be claimed. |
| TransactionCurrencyCode | Code that identifies the currency of the source transaction and the currency of the accrual. |
| TransactionId | Value that uniquely identifies the utilization transaction associated with the accrual. If a supplier rebate accrual is utilized upon the receiving transaction event, then this is the foreign key to the Receiving Receipt Transactions view object. |
| TransactionUnitPrice | Unit price of the source transaction in the transaction currency used to calculate the accrual. |
| UtilizationId | Value that uniquely identifies the supplier accrual. This is the primary key to the Channel Supplier Accruals view object. |
| UtilizationType | Code that identifies the utilization type of the accrual such as Accrual, Adjustment. Values are from lookup ORA_CJM_TRANSACTION_TYPE. |
| VendorId | Value that uniquely identifies the supplier. This is the foreign key to the Supplier Details view object. |
| VendorSiteId | Value that uniquely identifies the supplier site. This is the foreign key to the Supplier Site Details view object. |
| WaybillNumber | Value that identifies the waybill number of the source transaction accrued. |
| YearId | Value that uniquely identifies the calendar year of the accrual. |