Excluded Accounts Payable Invoice Details

The Excluded Accounts Payable Invoice Details view object contains the invoice variance lines for inventory and work order destination purchase orders which are to be excluded from accounting in receipt and cost accounting.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrExcludedApInvoiceDtlsExtractPVO

Primary Keys : CmrExcludedApInvoiceDtlsPEOExternalSystemRefId, CmrExcludedApInvoiceDtlsPEOExternalSystemReference

Initial Extract Date : CmrExcludedApInvoiceDtlsPEOCreationDate

Incremental Extract Date : CmrExcludedApInvoiceDtlsPEOLastUpdateDate

Attributes

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

Name	Description
CmrExcludedApInvoiceDtlsPEOAccountingDate	Date when the invoice was accounted.
CmrExcludedApInvoiceDtlsPEOChargeApplicableToDistId	Value that identifies the invoice distribution that applies.
CmrExcludedApInvoiceDtlsPEOCmrApInvoiceDistId	Value that identifies the internal accounts payable invoice distribution.
CmrExcludedApInvoiceDtlsPEOCmrPoDistributionId	Value that identifies the purchase order distribution that's matched to the Invoice distribution. This value will exist for match to PO and match to receipt cases.
CmrExcludedApInvoiceDtlsPEOCmrRcvTransactionId	Value that identifies the receiving transaction.
CmrExcludedApInvoiceDtlsPEOConsumptionAdviceHeaderId	Value that identifies the header of the consumption advice line that's matched to the invoice.
CmrExcludedApInvoiceDtlsPEOConsumptionAdviceLineId	Value that identifies the consumption advice line that's matched to the invoice.
CmrExcludedApInvoiceDtlsPEOCorrectedInvoiceDistId	Value that identifies the invoice distribution being corrected.
CmrExcludedApInvoiceDtlsPEOCreatedBy	User who created the row.
CmrExcludedApInvoiceDtlsPEOCreationDate	Date and time the row was created.
CmrExcludedApInvoiceDtlsPEOCurrencyCode	Value that identifies the currency of the invoice amount.
CmrExcludedApInvoiceDtlsPEOCurrencyConversionDate	Date to be used to determine the exchange rates for currency conversion.
CmrExcludedApInvoiceDtlsPEOCurrencyConversionRate	Value that identifies the optional user-specified currency conversion rate.
CmrExcludedApInvoiceDtlsPEOCurrencyConversionType	Value that identifies the conversion type that should be used for currency conversion.
CmrExcludedApInvoiceDtlsPEODistCodeCombinationId	Value that identifies the account associated with the invoice distribution.
CmrExcludedApInvoiceDtlsPEODistributionMatchType	Value that indicates whether the invoice is matched to a purchase order or a receipt transaction.
CmrExcludedApInvoiceDtlsPEOExpenditureItemDate	Value that identifies the expenditure item date that will be passed on projects.
CmrExcludedApInvoiceDtlsPEOExternalSystemRefId	Value that identifies the accounts payable invoice distribution line in the source system.
CmrExcludedApInvoiceDtlsPEOExternalSystemReference	Value that identifies the source system that owns the accounts payable invoice entity.
CmrExcludedApInvoiceDtlsPEOFinalMatchFlag	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.
CmrExcludedApInvoiceDtlsPEOFiscalChargeType	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.
CmrExcludedApInvoiceDtlsPEOFiscalDocHeaderId	Value that identifies the fiscal document header.
CmrExcludedApInvoiceDtlsPEOFiscalDocLineId	Value that identifies the fiscal document line.
CmrExcludedApInvoiceDtlsPEOInclusiveFlag	Value that indicates whether the invoice amounts on each invoice distribution is a tax exclusive and tax inclusive amount.
CmrExcludedApInvoiceDtlsPEOInvoiceAmt	Value that identifies the amount on the invoice distribution.
CmrExcludedApInvoiceDtlsPEOInvoiceBaseAmount	Value that identifies the amount on the invoice distribution in functional currency.
CmrExcludedApInvoiceDtlsPEOInvoiceCreationDate	Date when the invoice was created.
CmrExcludedApInvoiceDtlsPEOInvoiceDistributionType	Value that identifies the distribution type such as Accrual, Exchange Rate Variance, Freight, Invoice Price Variance, Item, Nonrecoverable tax, Miscellaneous, and so on.
CmrExcludedApInvoiceDtlsPEOInvoiceId	Value that identifies the payables invoice identifier.
CmrExcludedApInvoiceDtlsPEOInvoiceLineNumber	Value that identifies the user specified invoice line number.
CmrExcludedApInvoiceDtlsPEOInvoiceLineType	Value that identifies the type of invoice line. Valid values are ITEM, FREIGHT, MISCELLANEOUS, and TAX.
CmrExcludedApInvoiceDtlsPEOInvoiceNumber	Value that identifies the user specified invoice number used during invoice creation.
CmrExcludedApInvoiceDtlsPEOInvoiceQty	Value that identifies the quantity being invoiced in the unit of measure code.
CmrExcludedApInvoiceDtlsPEOInvoiceQtyInPoUom	Value that identifies the invoice quantity converted to the UOM on the purchase order.
CmrExcludedApInvoiceDtlsPEOInvoiceQtyInPrimaryUom	Value that identifies the invoice quantity in the primary unit of measure of the item.
CmrExcludedApInvoiceDtlsPEOInvoiceSource	Value that identifies the source of the invoice. Valid values include Intercompany and Credit Card.
CmrExcludedApInvoiceDtlsPEOInvoiceType	Value that identifies the type of invoice. Valid values include Standard Invoice, Credit memo, and Debit memo.
CmrExcludedApInvoiceDtlsPEOInvoicingBuFuncCurrCode	Value that identifies the functional currency of the invoicing business unit.
CmrExcludedApInvoiceDtlsPEOInvoicingBusinessUnitId	Value that identifies the business unit that owns the invoice.
CmrExcludedApInvoiceDtlsPEOLastUpdateDate	Date and time the row was most recently updated.
CmrExcludedApInvoiceDtlsPEOLastUpdateLogin	Session login associated to the user who most recently updated the row.
CmrExcludedApInvoiceDtlsPEOLastUpdatedBy	User who last updated the row.
CmrExcludedApInvoiceDtlsPEOLcmAssociationProcessedFlag	Value that indicates whether the invoice distribution has been picked up by the LCM charge invoice association process.
CmrExcludedApInvoiceDtlsPEOLcmEnabledFlag	Value that indicates if this invoice line is for a landed cost charge.
CmrExcludedApInvoiceDtlsPEOLeTimezoneCode	Value that identifies the time zone code of the legal entity.
CmrExcludedApInvoiceDtlsPEOLineCancelledFlag	Value that indicates whether the invoice line has been canceled.
CmrExcludedApInvoiceDtlsPEOOnlineAssocProcessId	Value that uniquely identifies the online process, if the invoice line was processed from the UI.
CmrExcludedApInvoiceDtlsPEOParentReversalId	Value that identifies the invoice distribution being reversed.
CmrExcludedApInvoiceDtlsPEOPoDistributionId	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.
CmrExcludedApInvoiceDtlsPEOProcurementBusinessUnitId	Value that identifies the business unit that has procured the goods or services. Specifically required for nonmatched invoices.
CmrExcludedApInvoiceDtlsPEORcvTransactionId	Value that identifies the source of the receipt transaction. This value is populated only for match to receipt cases.
CmrExcludedApInvoiceDtlsPEORelatedDistributionId	Value that identifies the related distributions.
CmrExcludedApInvoiceDtlsPEOReversalFlag	Value that indicates if this invoice distribution is reversing another invoice distribution.
CmrExcludedApInvoiceDtlsPEOSelfAssessedFlag	Value that indicates if the NONREC TAX invoice distribution line is self-assessed.
CmrExcludedApInvoiceDtlsPEOTaxCodeId	Value that identifies the tax code that was used on this distribution for the invoice date.
CmrExcludedApInvoiceDtlsPEOTaxPointBasis	Value that identifies the tax point basis applicable to the tax line on each invoice distribution.
CmrExcludedApInvoiceDtlsPEOUnitOfMeasure	Value that identifies the unit of measure for the invoice quantity.
CmrExcludedApInvoiceDtlsPEOVendorId	Value that identifies the supplier and references PO_VENDORS.vendor_id.
CmrExcludedApInvoiceDtlsPEOVendorSiteId	Value that identifies the supplier site and references PO_VENDOR_SITES_ALL.vendor_site_id.