Fiscal Document Details

The Fiscal Document Details view object contains the details of validated fiscal documents for creating accounting in cost and receipt accounting.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrFiscalDocumentDetailsExtractPVO

Primary Keys : CmrFiscalDocumentDetailsPEOFiscalDocumentDetailId

Initial Extract Date : CmrFiscalDocumentDetailsPEOCreationDate

Incremental Extract Date : CmrFiscalDocumentDetailsPEOLastUpdateDate

Attributes

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

Name	Description
CmrFiscalDocumentDetailsPEOBillToBusinessUnitId	Value that uniquely identifies the bill-to business unit.
CmrFiscalDocumentDetailsPEOChargeAmount	Value that identifies the fiscal document item line charge amount.
CmrFiscalDocumentDetailsPEOCreatedBy	User who created the row.
CmrFiscalDocumentDetailsPEOCreationDate	Date and time the row was created.
CmrFiscalDocumentDetailsPEOFdAccessKeyNumber	Value that identifies the access key number generated by the issuer for each electronic fiscal document or electronic freight fiscal document.
CmrFiscalDocumentDetailsPEOFdAcknowledgedDate	Value that identifies the acknowledged date of the fiscal document.
CmrFiscalDocumentDetailsPEOFdCurrencyCode	Value that identifies the fiscal document currency code.
CmrFiscalDocumentDetailsPEOFdCurrencyConversionDate	Value that identifies the fiscal document acknowledged date. Values for complementary fiscal document are taken from standard fiscal document.
CmrFiscalDocumentDetailsPEOFdCurrencyConversionRate	Value that identifies the conversion rate captured in fiscal document.
CmrFiscalDocumentDetailsPEOFdCurrencyConversionType	Value that identifies the conversion type captured in fiscal document.
CmrFiscalDocumentDetailsPEOFdDocumentType	Value that identifies the type of fiscal document. Valid values are from lookup ORA_CMF_DOC_TYPE.
CmrFiscalDocumentDetailsPEOFdHeaderId	Value that identifies the fiscal document header.
CmrFiscalDocumentDetailsPEOFdLineId	Value that identifies the fiscal document item line.
CmrFiscalDocumentDetailsPEOFdLineNumber	Value that identifies the line number of the fiscal document item line.
CmrFiscalDocumentDetailsPEOFdLineQuantity	Value that identifies the quantity of the fiscal document item line.
CmrFiscalDocumentDetailsPEOFdLineType	Value that identifies the line type of fiscal document item line. Valid values are from lookup ORA_CMF_LINE_TYPE.
CmrFiscalDocumentDetailsPEOFdLineUnitPrice	Value that identifies the fiscal document item line unit price.
CmrFiscalDocumentDetailsPEOFdScheduleId	Value that identifies the fiscal document schedule.
CmrFiscalDocumentDetailsPEOFdUomCode	Value that identifies the UOM for the fiscal document line as captured in the fiscal document.
CmrFiscalDocumentDetailsPEOFiscalDocumentDetailId	Value that uniquely identifies the fiscal document details ID.
CmrFiscalDocumentDetailsPEOInventoryItemId	Value that identifies the reference for item details as captured on the fiscal document.
CmrFiscalDocumentDetailsPEOLastUpdateDate	Date and time the row was last updated.
CmrFiscalDocumentDetailsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrFiscalDocumentDetailsPEOLastUpdatedBy	User who last updated the row.
CmrFiscalDocumentDetailsPEOProcessedByRaFlag	Value that identifies whether the distribution was picked up by the receipt accounting processor.
CmrFiscalDocumentDetailsPEOProcurementBuId	Value that identifies the purchasing business unit for the given combination of source document number, line, and schedule.
CmrFiscalDocumentDetailsPEORcvTransactionId	Value that identifies the source of the receipt transaction as captured in the fiscal document.
CmrFiscalDocumentDetailsPEOReceiptLineNum	Value that identifies the receipt line number as captured in the fiscal document.
CmrFiscalDocumentDetailsPEOReceiptNum	Value that identifies the physical receipt number as captured in the fiscal document.
CmrFiscalDocumentDetailsPEOReferenceFdHeaderId	Value that identifies the reference fiscal document.
CmrFiscalDocumentDetailsPEOReferenceFdLineId	Value that identifies the reference fiscal document item line.
CmrFiscalDocumentDetailsPEOReqBuFuncCurrencyCode	Value that identifies the requisition business unit functional currency code.
CmrFiscalDocumentDetailsPEOReqBuFuncCurrencyRate	Value that identifies the currency conversion rate to convert from the fiscal document currency to the requisition business unit functional currency based on the fiscal document's currency conversion type and date values.
CmrFiscalDocumentDetailsPEORequisitionBuId	Value that identifies the requisition business unit for the given combination of source document number, line, and schedule.
CmrFiscalDocumentDetailsPEOServicePoLineFlag	Value that indicates if the line has an associated service purchase order. This is set to Y for freight fiscal documents that are based on a purchase order.
CmrFiscalDocumentDetailsPEOShipToOrganizationId	Value that identifies the receiving organization where receiving the transaction is created.
CmrFiscalDocumentDetailsPEOSoldToLegalEntityId	Value that identifies the sold-to legal entity.
CmrFiscalDocumentDetailsPEOSourceDocumentCurrencyCode	Value that identifies the source document currency code.
CmrFiscalDocumentDetailsPEOSourceDocumentLineId	Value that identifies the source document line ID.
CmrFiscalDocumentDetailsPEOSourceDocumentScheduleId	Value that identifies the source document schedule ID.
CmrFiscalDocumentDetailsPEOSourceDocumentType	Value that identifies the source document type captured in the fiscal document. Valid values are in lookup type ORA_CMF_SOURCE_DOC_TYPE.
CmrFiscalDocumentDetailsPEOSourceDocumentUomCode	Value that identifies the UOM of the source document line for the fiscal document line.
CmrFiscalDocumentDetailsPEOTaxAmount	Value that identifies the tax amount of the fiscal document item line.
CmrFiscalDocumentDetailsPEOTaxAmountIncludedFlag	Value that identifies the inclusive tax line indicator. Valid values are Y and N or Null. Y indicates inclusive tax and NULL or N indicates exclusive tax.
CmrFiscalDocumentDetailsPEOTransactionDate	Value that identifies the date that the physical receipt transaction is created.
CmrFiscalDocumentDetailsPEOTransactionQty	Value that identifies the physical receipt quantity.
CmrFiscalDocumentDetailsPEOTransactionUomCode	Value that identifies the unit of measure for the physical receipt quantity.