Accounts Payable Invoice Details

The Accounts Payable Invoice Details view object contains accounts payable amount details.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrApInvoiceDtlsExtractPVO

Primary Keys : CmrApInvoiceDtlsPEOCmrApInvoiceDistId, CmrApInvoiceDtlsPEOExternalSystemRefId, CmrApInvoiceDtlsPEOExternalSystemReference

Initial Extract Date : CmrApInvoiceDtlsPEOCreationDate

Incremental Extract Date : CmrApInvoiceDtlsPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CmrApInvoiceDtlsPEOAccountingDate	Date when the invoice was accounted.
CmrApInvoiceDtlsPEOChargeApplicableToDistId	Value that identifies the invoice distribution that applies.
CmrApInvoiceDtlsPEOCmrApInvoiceDistId	Value that identifies the internal accounts payable invoice distribution.
CmrApInvoiceDtlsPEOCmrApInvoiceLineId	Value that identifies the internal accounts payable invoice line.
CmrApInvoiceDtlsPEOCmrPoDistributionId	Value that identifies the purchase order distribution that's matched to the Invoice distribution. This value will exist for match to PO as well as match to receipt cases.
CmrApInvoiceDtlsPEOCmrRcvTransactionId	Value that identifies the receiving transaction.
CmrApInvoiceDtlsPEOConsumptionAdviceHeaderId	Value that identifies the header of the consumption advice line that's matched to the invoice.
CmrApInvoiceDtlsPEOConsumptionAdviceLineId	Value that identifies the consumption advice line that's matched to the invoice.
CmrApInvoiceDtlsPEOCorrectedInvoiceDistId	Value that identifies the invoice distribution that's being corrected.
CmrApInvoiceDtlsPEOCreatedBy	User who created the row.
CmrApInvoiceDtlsPEOCreationDate	Date and time the row was created.
CmrApInvoiceDtlsPEOCurrencyCode	Value that identifies the currency of the invoice amount.
CmrApInvoiceDtlsPEOCurrencyConversionDate	Date to be used to determine the exchange rates for currency conversion.
CmrApInvoiceDtlsPEOCurrencyConversionRate	Value that identifies the optional user specified currency conversion rate.
CmrApInvoiceDtlsPEOCurrencyConversionType	Value that identifies the conversion type that should be used for currency conversion.
CmrApInvoiceDtlsPEODistCodeCombinationId	Value that identifies the account associated with invoice distribution.
CmrApInvoiceDtlsPEODistributionMatchType	Value that indicates whether the invoice is matched to a purchase order or a receipt transaction.
CmrApInvoiceDtlsPEOExpenditureItemDate	Value that identifies the expenditure item date that will be passed on projects.
CmrApInvoiceDtlsPEOExternalSystemRefId	Value that identifies the accounts payable invoice distribution line in the source system.
CmrApInvoiceDtlsPEOExternalSystemReference	Value that identifies the source system that owns the accounts payable invoice entity.
CmrApInvoiceDtlsPEOFinalMatchFlag	Value that indicates whether this is a final match invoice. No further invoices are expected for the PO or the receipt after the final match.
CmrApInvoiceDtlsPEOFiscalChargeType	Value that identifies the tax driver. Subclassification is for invoices with a line type of freight or miscellaneous. Valid values are from lookup ZX_CHARGE_TYPE.
CmrApInvoiceDtlsPEOFiscalDocHeaderId	Value that identifies the fiscal document header.
CmrApInvoiceDtlsPEOFiscalDocLineId	Value that identifies the fiscal document line.
CmrApInvoiceDtlsPEOInclusiveFlag	Value that indicates whether the invoice amounts on each invoice distribution is a tax exclusive or a tax inclusive amount.
CmrApInvoiceDtlsPEOInvoiceAmt	Value that identifies the amount on the invoice distribution.
CmrApInvoiceDtlsPEOInvoiceBaseAmount	Value that identifies the amount on the invoice distribution in functional currency.
CmrApInvoiceDtlsPEOInvoiceCreationDate	Date when the invoice was created.
CmrApInvoiceDtlsPEOInvoiceDistributionType	Value that identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous, and so on.
CmrApInvoiceDtlsPEOInvoiceId	Value that identifies the payables invoice identifier.
CmrApInvoiceDtlsPEOInvoiceLineNumber	Value that identifies the user specified invoice line number.
CmrApInvoiceDtlsPEOInvoiceLineType	Value that identifies the type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, and TAX.
CmrApInvoiceDtlsPEOInvoiceNumber	Value that identifies the user specified invoice number used during invoice creation.
CmrApInvoiceDtlsPEOInvoiceQty	Value that identifies the quantity being invoiced in unit of measure code.
CmrApInvoiceDtlsPEOInvoiceQtyInPoUom	Value that identifies the invoice quantity converted to the UOM on the purchase order.
CmrApInvoiceDtlsPEOInvoiceQtyInPrimaryUom	Value that identifies the invoice quantity in the primary unit of measure of the item.
CmrApInvoiceDtlsPEOInvoiceSource	Value that identifies the source of the invoice. Valid values include Intercompany and Credit Card.
CmrApInvoiceDtlsPEOInvoiceType	Value that identifies the type of invoice. Valid values include Standard Invoice, Credit memo, and Debit memo.
CmrApInvoiceDtlsPEOInvoicingBuFuncCurrCode	Value that identifies the functional currency of the invoicing business unit.
CmrApInvoiceDtlsPEOInvoicingBusinessUnitId	Value that identifies the business unit that owns the invoice.
CmrApInvoiceDtlsPEOLastUpdateDate	Date and time the row was most recently updated.
CmrApInvoiceDtlsPEOLastUpdateLogin	Session login associated to the user who most recently updated the row.
CmrApInvoiceDtlsPEOLastUpdatedBy	User who last updated the row.
CmrApInvoiceDtlsPEOLcmAssociationProcessedFlag	Value that indicates whether the invoice distribution has been picked up by the LCM charge invoice association process.
CmrApInvoiceDtlsPEOLcmAssociationRequestId	Value that identifies the request ID of the enterprise scheduler service job that processed this record for association.
CmrApInvoiceDtlsPEOLcmEnabledFlag	Value that indicates if this invoice line is for a landed cost charge.
CmrApInvoiceDtlsPEOLeTimezoneCode	Value that identifies the time zone code of the legal entity.
CmrApInvoiceDtlsPEOLineCancelledFlag	Value that indicates whether the invoice line has been canceled.
CmrApInvoiceDtlsPEOOnlineAssocProcessId	Value that uniquely identifies the online process, if the invoice line was processed from the UI.
CmrApInvoiceDtlsPEOParentReversalId	Value that identifies the invoice distribution that's being reversed.
CmrApInvoiceDtlsPEOPoDistributionId	Value that identifies the source of the purchase order distribution that's matched to the invoice distribution. This value will exist for match to PO as well as match to receipt cases.
CmrApInvoiceDtlsPEOProcessedByCaFlag	Value that identifies whether the distribution was processed by the cost accounting processor. Valid values are N, Y and F. If N, then it hasn't been processed by cost accounting. If Y, then it has been processed by cost accounting. If F, then it's a future dated invoice and isn't ready for cost accounting.
CmrApInvoiceDtlsPEOProcessedByRaFlag	Value that indicates that the distribution was picked up by the receipt accounting processor.
CmrApInvoiceDtlsPEOProcurementBusinessUnitId	Value that identifies the business unit that has procured the goods or services. Specifically required to nonmatched invoices.
CmrApInvoiceDtlsPEORcvTransactionId	Value that identifies the source of the receipt transaction. This value is populated only for match to receipt cases.
CmrApInvoiceDtlsPEORelatedDistributionId	Value that identifies the related distributions.
CmrApInvoiceDtlsPEOReversalFlag	Value that indicates if this invoice distribution is reversing another invoice distribution.
CmrApInvoiceDtlsPEOSelfAssessedFlag	Value that indicates if the NONREC TAX invoice distribution line is self assessed.
CmrApInvoiceDtlsPEOTaxCodeId	Value that identifies the tax code that was used on this distribution for the invoice date.
CmrApInvoiceDtlsPEOTaxPointBasis	Value that identifies the tax point basis applicable to the tax line on each invoice distribution.
CmrApInvoiceDtlsPEOUnitOfMeasure	Value that identifies the unit of measure for the invoice quantity.
CmrApInvoiceDtlsPEOVendorId	Value that identifies the supplier and references PO_VENDORS.vendor_id.
CmrApInvoiceDtlsPEOVendorSiteId	Value that identifies the supplier site and references PO_VENDOR_SITES_ALL.vendor_site_id.