Financial Routes
The Financial Routes view object stores the information related to financial trade relationships defined for financial trade agreements.
Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosFinancialTradeRelationExtractPVO
Primary Keys : FinancialTradeRelationPEOAgreementFtrId, FinancialTradeRelationPEOEffectiveEndDate, FinancialTradeRelationPEOEffectiveStartDate
Initial Extract Date : FinancialTradeRelationPEOCreationDate
Incremental Extract Date : FinancialTradeRelationPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| FinancialTradeRelationPEOAgreementFtrId | Value that uniquely identifies the financial route. This is the primary key of the Financial Routes view object. |
| FinancialTradeRelationPEOAgreementId | Value that identifies the parent agreement to which this financial trade relationship belongs. |
| FinancialTradeRelationPEOAgreementPtrId | Value that identifies the parent primary trade relationship line to which this financial trade relationship belongs. |
| FinancialTradeRelationPEOAttributeCategory | Context structure definition of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar1 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar10 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar11 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar12 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar13 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar14 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar15 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar2 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar3 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar4 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar5 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar6 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar7 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar8 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeChar9 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeDate1 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeDate2 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeDate3 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeNumber1 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeNumber2 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeNumber3 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeNumber4 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeNumber5 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeTimestamp1 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeTimestamp2 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOAttributeTimestamp3 | Segment of the user descriptive flexfield. |
| FinancialTradeRelationPEOBsrId | Value that identifies the buy sell relationship that this financial trade relationship uses. |
| FinancialTradeRelationPEOBuyingCrmDocCategoryCode | Value that identifies the sequential numbering, voucher number, document category for the invoice Credit Memo lookup value. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE. |
| FinancialTradeRelationPEOBuyingDefaultTxtCountry | Value that indicates the buy-side default taxation country code. |
| FinancialTradeRelationPEOBuyingDocCategoryCode | Value that identifies the sequential numbering, voucher number, document category. Use the Manage Payables Document Sequences task to identify valid values. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE. |
| FinancialTradeRelationPEOBuyingDocumentSubType | Value that identifies the buy-side document fiscal classification code. |
| FinancialTradeRelationPEOBuyingFirstPtyRegId | Value that identifies the buy-side first-party tax registration identifier for the transaction. |
| FinancialTradeRelationPEOBuyingIntendedUse | Value that identifies the buy-side intended use code of the transaction line. This identifies the purpose for which the product is used. |
| FinancialTradeRelationPEOBuyingProductCategory | Value that identifies the buy-side product category code of the transaction line. |
| FinancialTradeRelationPEOBuyingProductFiscClsf | Value that identifies the buy-side product fiscal classification code of the inventory item. |
| FinancialTradeRelationPEOBuyingThirdPtyRegId | Value that identifies the buy-side third-party tax registration identifier of the transaction. |
| FinancialTradeRelationPEOBuyingTrxBusinessCategory | Value that identifies the buy-side transaction business category code. |
| FinancialTradeRelationPEOBuyingUserDefinedFiscCls | Value that identifies the buy-side user-defined fiscal classification code. |
| FinancialTradeRelationPEOChargeAccountCcid | Value that identifies the accounting flexfield identifier for the charge account for intercompany payable invoice. |
| FinancialTradeRelationPEOCreatedBy | User who created the financial route. |
| FinancialTradeRelationPEOCreationDate | Date when the financial route was created. |
| FinancialTradeRelationPEOEffectiveEndDate | Date at the end of the date range within which the row is effective. |
| FinancialTradeRelationPEOEffectiveStartDate | Date at the beginning of the date range within which the row is effective. |
| FinancialTradeRelationPEOEnterpriseId | Value that identifies the enterprise that's used for multiple tenancy partitioning. |
| FinancialTradeRelationPEOFromBuId | Value that identifies the selling business unit. |
| FinancialTradeRelationPEOFromTradeOrg | Value that identifies the organization from where the financial transaction starts for the financial trade relationship line. |
| FinancialTradeRelationPEOIncotermLocation | Contains the value of the location where the validity of the INCOTERM exists. |
| FinancialTradeRelationPEOIncoterms | Value that identifies a series of international sales terms most commonly used in international trade. Scope of this is limited to matters relating to rights and obligations of the parties to the contract of sale with respect to the delivery of goods sold. They're used to divide transaction costs and responsibilities between buyer and seller and reflect state-of-the-art transportation practices. Valid values are contained within the RCS_INCO_TERMS lookup type. |
| FinancialTradeRelationPEOLastUpdateDate | Date when the financial route was last updated. |
| FinancialTradeRelationPEOLastUpdateLogin | Session login associated with the user who last updated the financial route. |
| FinancialTradeRelationPEOLastUpdatedBy | User who last updated the financial route. |
| FinancialTradeRelationPEOLogicalReceiptHoldFlag | Value that indicates if a hold should be applied to the logical receipt, for shipment flows, if Brazil is the final buying business unit |
| FinancialTradeRelationPEOLogicalShipHoldFlag | Value that indicates if a hold should be applied to the trade sales issue for shipment flows, if Brazil is the final buying business unit and if the hold is applicable to a logical receipt. |
| FinancialTradeRelationPEOObjectVersionNumber | Value that identifies the number of times the financial route row has been updated. |
| FinancialTradeRelationPEOOcForwardTimeLag | Value that identifies the time in hours for which the system will wait for ownership change after the ownership change event has occurred in the forward flow. |
| FinancialTradeRelationPEOOcFwdEventDefId | Value that uniquely identifies the event that will trigger the ownership change for this financial trade relationship in the forward flow. |
| FinancialTradeRelationPEOOcRetEventDefId | Value that uniquely identifies the event that will trigger the ownership change for this financial trade relationship in the return flow. |
| FinancialTradeRelationPEOOcReturnTimeLag | Value that identifies the time in hours for which the application will wait for an ownership change after the ownership change event has occurred in the return flow. |
| FinancialTradeRelationPEOPaymentTermId | Value that identifies the payment terms used for intercompany sales by the profit center business unit. |
| FinancialTradeRelationPEOPricingId | Value that identifies the foreign key to the Transfer Pricing Rules view object. |
| FinancialTradeRelationPEOReceivablesCreditMemoType | Value that identifies the transaction type and is used for the creation of intercompany receivables credit memos. |
| FinancialTradeRelationPEOReceivablesInvoiceType | Value that identifies the transaction type and is used for the creation of intercompany receivables invoices. |
| FinancialTradeRelationPEOSellingDefaultTxtCountry | Value that identifies the sell-side default taxation country code. |
| FinancialTradeRelationPEOSellingDocumentSubType | Value that identifies the sell-side document fiscal classification code. |
| FinancialTradeRelationPEOSellingFirstPtyRegId | Value that identifies the sell-side first-party tax registration identifier for the transaction. |
| FinancialTradeRelationPEOSellingIntendedUse | Value that identifies the sell-side intended use code of the transaction line. This identifies the purpose for which the product is used. |
| FinancialTradeRelationPEOSellingProductCategory | Value that identifies the sell-side product category code of the transaction line. |
| FinancialTradeRelationPEOSellingProductFiscClsf | Value that identifies the sell-side product fiscal classification code of the inventory item. |
| FinancialTradeRelationPEOSellingThirdPtyRegId | Value that identifies the sell-side third-party tax registration identifier for the transaction. |
| FinancialTradeRelationPEOSellingTrxBusinessCategory | Value that identifies the sell-side transaction business category code. |
| FinancialTradeRelationPEOSellingUserDefinedFiscCls | Value that identifies the sell-side user-defined fiscal classification code. |
| FinancialTradeRelationPEOSequenceNumber | Value that identifies the sequence number of the current financial trade relationship line for a given primary trade relationship line. |
| FinancialTradeRelationPEOTaRuleSetId | Value that identifies the foreign key to the Documentation and Accounting Rules view object. |
| FinancialTradeRelationPEOToBuId | Value that identifies the buying business unit. |
| FinancialTradeRelationPEOToTradeOrg | Value that identifies the organization where the financial transaction ends for the financial trade relationship line. |