Request Distributions
The Supply Request Distribution Details Extract view object extracts distribution details from the supply request.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyRequestDistrbDtlsExtractPVO
Primary Keys : DosDistributionDetailsIntPEODistributionDetailsIntfId
Initial Extract Date : DosDistributionDetailsIntPEOCreationDate
Incremental Extract Date : DosDistributionDetailsIntPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosDistributionDetailsIntPEOCreatedBy | Name of the user who created the distribution details. |
| DosDistributionDetailsIntPEOCreationDate | Date and time when the user created the distribution details. |
| DosDistributionDetailsIntPEODetailType | Type of distribution detail. |
| DosDistributionDetailsIntPEODistrbAmount | Amount on the transfer order line. |
| DosDistributionDetailsIntPEODistrbAmountCurrencyCode | Abbreviation that identifies the currency of the distribution amount. |
| DosDistributionDetailsIntPEODistrbBudgetDate | Date to use for the budget when reserving the distribution. |
| DosDistributionDetailsIntPEODistrbChargeAccountId | Value that uniquely identifies the charge account to use in the general ledger for the distribution. |
| DosDistributionDetailsIntPEODistrbCurramtCurrencyCode | Abbreviation that identifies the currency that the distribution is currently using on the transfer order. |
| DosDistributionDetailsIntPEODistrbCurrencyAmount | Currency to use for the distribution on the transfer order. |
| DosDistributionDetailsIntPEODistrbDeliveredQuantity | Quantity that fulfillment delivered, received, then put away into inventory. |
| DosDistributionDetailsIntPEODistrbDelvrdQuantityUom | Unit of measure for the delivered quantity. |
| DosDistributionDetailsIntPEODistrbExpenditureDate | Date when the expenditure occurred for a project transaction. |
| DosDistributionDetailsIntPEODistrbExpenditureOrgId | Value that uniquely identifies the organization to expense for the transaction. Use this attribute when you use a descriptive flexfield to capture the distribution for a project transaction. |
| DosDistributionDetailsIntPEODistrbExpenditureTypeId | Value that uniquely identifies the type of expenditure. Use this attribute when you use a descriptive flexfield to capture the distribution for a project transaction. |
| DosDistributionDetailsIntPEODistrbFundsStatus | Status of the funds for the distribution. Use this attribute to calculate the budget. It specifies the type of internal material transfer. Values include Type 1 or Type 2. Type 1 means to transfer the inventory item between different inventory locations. You usually use type 1 to control the budget for a distribution that involves the Federal Government of the United States. Type 2 means to transfer the inventory item to an expense destination. You usually use type 2 to control an expense budget. For type 1 and type 2, Supply Orchestration expects that the request is a commitment, the in-process transfer transaction is an obligation, and the completed transfer transaction is an expenditure. So, you might need to use a specialized category to reserve funds when you manage the amount. |
| DosDistributionDetailsIntPEODistrbNonrcvrblCrncyTax | Currency of the tax that isn't recoverable. Tax is on the distribution. |
| DosDistributionDetailsIntPEODistrbNonrecoverableTax | Tax that isn't recoverable. Tax is on the distribution. |
| DosDistributionDetailsIntPEODistrbPercent | Percent to allocate when you split the value of the distribution. |
| DosDistributionDetailsIntPEODistrbPjcBillableFlag | This attribute contains 1 or 0. 1 means you can bill your customer for each project item in the distribution. 0 means you can't. No value means 0. 0 is the default value. |
| DosDistributionDetailsIntPEODistrbPjcCapitalizableFlag | This attribute contains 1 or 0. 1 means you can capitalize each project item in the distribution. 0 means you can't. No value means 0. 0 is the default value. |
| DosDistributionDetailsIntPEODistrbPjcContextCategory | Segment you can use to identify the application context of a descriptive flexfield. You use the flexfield to capture the standardized cost for the project. |
| DosDistributionDetailsIntPEODistrbPjcContractId | Value that uniquely identifies the contract. Use this attribute when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEODistrbPjcContractLineId | Value that uniquely identifies the contract line. Use this attribute when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEODistrbPjcFndingAllctnId | Value that uniquely identifies the funding allocation to use on the distribution details for the project. Use this attribute when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute1 | Attribute 1 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute10 | Attribute 10 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute2 | Attribute 2 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute3 | Attribute 3 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute4 | Attribute 4 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute5 | Attribute 5 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute6 | Attribute 6 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute7 | Attribute 7 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute8 | Attribute 8 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcRsrvdAttribute9 | Attribute 9 that captures project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute1 | Attribute 1 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute10 | Attribute 10 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute2 | Attribute 2 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute3 | Attribute 3 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute4 | Attribute 4 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute5 | Attribute 5 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute6 | Attribute 6 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute7 | Attribute 7 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute8 | Attribute 8 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcUsrDefAttribute9 | Attribute 9 you can define to capture project details for the distribution. Reserved for future use. |
| DosDistributionDetailsIntPEODistrbPjcWorkTypeId | Value that uniquely identifies the type of work to do for a project. |
| DosDistributionDetailsIntPEODistrbPrimaryLedgerId | Value that uniquely identifies the primary ledger to use for the charge account. |
| DosDistributionDetailsIntPEODistrbProjectId | Value that uniquely identifies the project to use when you create a descriptive flexfield that captures the distribution for a project. |
| DosDistributionDetailsIntPEODistrbPropamtCurrencyCode | Abbreviation that identifies the currency to use for the amount of the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedAmount | Amount to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedChrgAccntId | Value that uniquely identifies the charge account to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedPercent | Percent to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedProjectId | Value that uniquely identifies the project to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedQuantity | Quantity to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedQuantityUom | Unit of measure to use for the quantity of the proposed distribution. |
| DosDistributionDetailsIntPEODistrbProposedTaskId | Value that uniquely identifies the task to use for the proposed distribution. |
| DosDistributionDetailsIntPEODistrbQuantity | Quantity on the distribution line. |
| DosDistributionDetailsIntPEODistrbQuantityUom | Unit of measure for the quantity on the distribution line. |
| DosDistributionDetailsIntPEODistrbRecoverableCrncyTax | Currency to use for the amount of recoverable tax on the distribution. |
| DosDistributionDetailsIntPEODistrbRecoverableTax | Amount of recoverable tax on the distribution. |
| DosDistributionDetailsIntPEODistrbRequestingBuId | Value that uniquely identifies the business unit for the requesting organization. |
| DosDistributionDetailsIntPEODistrbRequisitionLineId | Value that uniquely identifies the requisition line. |
| DosDistributionDetailsIntPEODistrbTaskId | Value that uniquely identifies the task to use when you create a descriptive flexfield that captures the distribution for a project. |
| DosDistributionDetailsIntPEODistributionDetailsIntfId | Value that uniquely identifies the interface to use for details on the distribution. Supply Orchestration creates this value. Its required. |
| DosDistributionDetailsIntPEODistributionId | Value that uniquely identifies the distribution. |
| DosDistributionDetailsIntPEODistributionNumber | Number that identifies the transfer order or purchase order. |
| DosDistributionDetailsIntPEODistributionOperation | Type of operation to do for the distribution. Values include CREATE, UPDATE, or CANCEL. |
| DosDistributionDetailsIntPEOHeaderInterfaceId | Value that uniquely identifies the interface header to use for details on the distribution. Supply Orchestration creates this value. Its required. |
| DosDistributionDetailsIntPEOInterfaceBatchNumber | Number that identifies the batch to use for planning, Global Order Promising, or inventory. It must contain the same value that you use to reference the supply order, such as the sales order number. You can use an alphanumeric value. |
| DosDistributionDetailsIntPEOJobDefinitionName | Name of the job that Enterprise Service Scheduler used to create or most recently update the distribution details. |
| DosDistributionDetailsIntPEOJobDefinitionPackage | Name of the package that Enterprise Service Scheduler used to create or most recently update the distribution details. |
| DosDistributionDetailsIntPEOLastUpdateDate | Date and time when the user most recently updated the distribution details. |
| DosDistributionDetailsIntPEOLastUpdateLogin | Login that the user used when updating the distribution details. |
| DosDistributionDetailsIntPEOLastUpdatedBy | User who most recently updated the distribution details. |
| DosDistributionDetailsIntPEOLineInterfaceId | Value that uniquely identifies the interface for the request line. Supply Orchestration creates this value. Its required. |
| DosDistributionDetailsIntPEOLoadRequestId | Value that uniquely identifies the load request for the SQL Loader Request scheduled process. Use the DOS_DISTRIBUTION_DETAILS_INT_S sequence to create this value. If you use a web service to call the scheduled process, then you can leave this attribute empty. |
| DosDistributionDetailsIntPEOObjectVersionNumber | Version of the distribution details. This attribute makes sure no more than one user modifies the same object at the same time. The database increments the version every time it updates the row, then compares the version at the start and at the end of each transaction to determine whether another user updated the row during the current session. |
| DosDistributionDetailsIntPEOPjcBillableFlag | This attribute contains 1 or 0. 1 means you can bill your customer for each project item in the supply request. 0 means you can't. No value means 0. 0 is the default value. |
| DosDistributionDetailsIntPEOPjcCapitalizableFlag | This attribute contains 1 or 0. 1 means you can capitalize the distribution. 0 means you can't. No value means 0. 0 is the default value. |
| DosDistributionDetailsIntPEOPjcContextCategory | Context category to use for descriptive flexfields that you use to capture distribution details. |
| DosDistributionDetailsIntPEOPjcContractId | Value that uniquely identifies the contract. Use it when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEOPjcContractLineId | Value that uniquely identifies the contract line. Use it when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEOPjcExpenditureItemDate | Date when you incur the expenditure for an item that includes a project transaction. |
| DosDistributionDetailsIntPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type. Use this attribute when you use a descriptive flexfield to capture details for a project distribution. |
| DosDistributionDetailsIntPEOPjcFundingAllocationId | Value that uniquely identifies the funding allocation to use on the supply request for the project. Use this attribute when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsIntPEOPjcOrganizationId | Value that uniquely identifies the organization. Use this attribute when you use a descriptive flexfield to capture details for a project distribution. |
| DosDistributionDetailsIntPEOPjcProjectId | Value that uniquely identifies the project. Use this attribute when you use a descriptive flexfield to capture details for a project distribution. |
| DosDistributionDetailsIntPEOPjcProjectNumber | Number that identifies the project. |
| DosDistributionDetailsIntPEOPjcReservedAttribute1 | Descriptive flexfield 1 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute10 | Descriptive flexfield 10 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute2 | Descriptive flexfield 2 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute3 | Descriptive flexfield 3 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute4 | Descriptive flexfield 4 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute5 | Descriptive flexfield 5 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute6 | Descriptive flexfield 6 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute7 | Descriptive flexfield 7 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute8 | Descriptive flexfield 8 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcReservedAttribute9 | Descriptive flexfield 9 that captures project details. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcTaskId | Value that uniquely identifies the task. Use this attribute when you use a descriptive flexfield to capture details for a project distribution. |
| DosDistributionDetailsIntPEOPjcTaskNumber | Number that identifies the task to perform for project work. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute1 | Attribute 1 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute10 | Attribute 10 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute2 | Attribute 2 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute3 | Attribute 3 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute4 | Attribute 4 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute5 | Attribute 5 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute6 | Attribute 6 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute7 | Attribute 7 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute8 | Attribute 8 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcUserDefAttribute9 | Attribute 9 you can define to capture project details for the supply request. Reserved for future use. |
| DosDistributionDetailsIntPEOPjcWorkTypeId | Value that uniquely identifies the work type for a project task. |
| DosDistributionDetailsIntPEORequestId | Value that uniquely identifies the request that Enterprise Service Scheduler used to create or most recently update the supply request. |