Distributions
The Supply Distribution Details Extract view object extracts details for the supply distribution.
Data Store Key : FscmTopModelAM.ScmExtractAM.DosBiccExtractAM.SupplyDistributionDetailsExtractPVO
Primary Keys : DosDistributionDetailsPEODistributionDetailsId
Initial Extract Date : DosDistributionDetailsPEOCreationDate
Incremental Extract Date : DosDistributionDetailsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| DosDistributionDetailsPEOCreatedBy | Name of the user who created the supply distribution. |
| DosDistributionDetailsPEOCreationDate | Date and time when the user created the supply distribution. |
| DosDistributionDetailsPEODetailType | Type of detail in the supply distribution. |
| DosDistributionDetailsPEODistrbAmount | Amount to distribute for the supply distribution. |
| DosDistributionDetailsPEODistrbAmountCurrencyCode | Abbreviation that identifies the currency for the amount in the supply distribution. |
| DosDistributionDetailsPEODistrbBudgetDate | Date to use when reserving the supply distribution. |
| DosDistributionDetailsPEODistrbChargeAccountId | Value that uniquely identifies the charge account for the general ledger. |
| DosDistributionDetailsPEODistrbCurramtCurrencyCode | Abbreviation that identifies the foreign currency for the amount in the supply distribution. |
| DosDistributionDetailsPEODistrbCurrencyAmount | Foreign currency of the amount in the supply distribution. |
| DosDistributionDetailsPEODistrbDeliveredQuantity | Quantity that the warehouse received and put into inventory. |
| DosDistributionDetailsPEODistrbDelvrdQuantityUom | Unit of measure for the quantity that the warehouse received and put into inventory. |
| DosDistributionDetailsPEODistrbFundsStatus | Status of the funds that the supply distribution distributes. Use it to calculate a budget. This attribute contains a value of Type 1 or Type 2. Type 1 means to transfer the inventory item between different inventory locations. You usually use type 1 only with funds that involve the Federal Government of the United States. Type 2 means transfer the inventory item to an expense destination. You usually use type 2 for an internal material transfer that requires budgetary control because it affects the expense budget. For type 1 and type 2, the request is a commitment, the in-process transfer transaction is an obligation, and the completed transfer transaction is an expenditure. This might require you to use specialized Funds Reservation Categories to manage the amounts. |
| DosDistributionDetailsPEODistrbNonrcvrblCrncyTax | Currency of the tax that you can't recover. |
| DosDistributionDetailsPEODistrbNonrecoverableTax | Tax that you can't recover. |
| DosDistributionDetailsPEODistrbPercent | Percent to allocate when you split the supply distribution. |
| DosDistributionDetailsPEODistrbPrimaryLedgerId | Value that uniquely identifies the primary ledger for the charge account. |
| DosDistributionDetailsPEODistrbPropamtCurrencyCode | Abbreviation that identifies the currency to use for the proposed amount of the supply distribution. |
| DosDistributionDetailsPEODistrbProposedAmount | Proposed amount of the supply distribution. |
| DosDistributionDetailsPEODistrbProposedChrgAccntId | Proposed charge account to use for the supply distribution. |
| DosDistributionDetailsPEODistrbProposedPercent | Proposed percent to use for the supply distribution. |
| DosDistributionDetailsPEODistrbProposedProjectId | Value that uniquely identifies the proposed project to use for the supply distribution. |
| DosDistributionDetailsPEODistrbProposedQuantity | Proposed quantity to use for the supply distribution. |
| DosDistributionDetailsPEODistrbProposedQuantityUom | Unit of measure of the proposed quantity to use for the supply distribution. |
| DosDistributionDetailsPEODistrbProposedTaskId | Value that uniquely identifies the proposed task to use for the supply distribution. |
| DosDistributionDetailsPEODistrbQuantity | Quantity of the line in the supply distribution. |
| DosDistributionDetailsPEODistrbQuantityUom | Unit of measure for the distribution quantity. |
| DosDistributionDetailsPEODistrbRecoverableCrncyTax | Currency to use for the tax that's recoverable on the supply distribution. |
| DosDistributionDetailsPEODistrbRecoverableTax | Amount of tax that's recoverable on the supply distribution. |
| DosDistributionDetailsPEODistrbRequestingBuId | Value that uniquely identifies the business unit for the requesting organization. |
| DosDistributionDetailsPEODistrbRequisitionLineId | Value that uniquely identifies the requisition line. |
| DosDistributionDetailsPEODistributionDetailsId | Value that uniquely identifies details for the supply distribution. Use it for project cost attributes when you must reference distribution details from the supply order in Supply Orchestration. |
| DosDistributionDetailsPEODistributionId | Value that uniquely identifies the distribution that the supply distribution distributes. |
| DosDistributionDetailsPEODistributionNumber | Number that identifies the distribution details in Supply Orchestration. Supply Orchestration creates this value when it processes the supply request. |
| DosDistributionDetailsPEODistributionOperation | Type of operation to do for the distribution. Use CREATE, UPDATE, or CANCEL. |
| DosDistributionDetailsPEOJobDefinitionName | Name of the job that Enterprise Service Scheduler used to create or most recently update the supply distribution. |
| DosDistributionDetailsPEOJobDefinitionPackage | Name of the package that Enterprise Service Scheduler used to create or most recently update the supply distribution. |
| DosDistributionDetailsPEOLastUpdateDate | Date and time when the user most recently updated the supply distribution. |
| DosDistributionDetailsPEOLastUpdateLogin | Login that the user used when updating the supply distribution. |
| DosDistributionDetailsPEOLastUpdatedBy | User who most recently updated the supply distribution. |
| DosDistributionDetailsPEOLineId | Value that uniquely identifies the line in the supply distribution. You must include this value. |
| DosDistributionDetailsPEOLoadRequestId | Value that uniquely identifies the load request for the supply distribution. Use it when you use the SQL Loader Request scheduled process. Use the DOS_DISTRIBUTION_DETAILS_INT_S sequence to specify the sequence to use for the load request. If you load data directly from a web service, then you can leave this attribute empty. |
| DosDistributionDetailsPEOObjectVersionNumber | Version of the supply distribution. 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. |
| DosDistributionDetailsPEOPjcBillableFlag | This attribute contains 1 or 0. 1 means to bill your customer for the supply distribution. 0 means don't bill them. No value means 0. 0 is the default value. |
| DosDistributionDetailsPEOPjcCapitalizableFlag | This attribute contains 1 or 0. 1 means to capitalize the distribution. 0 means don't capitalize it. No value means 0. 0 is the default value. |
| DosDistributionDetailsPEOPjcContextCategory | Context category to use for descriptive flexfields that you use with the supply distribution. |
| DosDistributionDetailsPEOPjcContractId | Value that uniquely identifies the contract. Use it when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsPEOPjcContractLineId | Value that uniquely identifies contract line. Use it when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsPEOPjcExpenditureItemDate | Date when the project transaction occurs. |
| DosDistributionDetailsPEOPjcExpenditureTypeId | Value that uniquely identifies the expenditure type. Use this attribute when you use a descriptive flexfield to capture details about a project transaction. |
| DosDistributionDetailsPEOPjcFundingAllocationId | Value that uniquely identifies the funding allocation for a project. Use it when you use Oracle Contract Billing or Oracle Grants Accounting. |
| DosDistributionDetailsPEOPjcOrganizationId | Value that uniquely identifies the expenditure organization. Use this attribute when you use a descriptive flexfield to capture details about a project transaction. |
| DosDistributionDetailsPEOPjcProjectId | Value that uniquely identifies the project. Use this attribute when you use a descriptive flexfield to capture details about a project transaction. |
| DosDistributionDetailsPEOPjcProjectNumber | Number that identifies the project. |
| DosDistributionDetailsPEOPjcReservedAttribute1 | Descriptive flexfield 1 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute10 | Descriptive flexfield 10 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute2 | Descriptive flexfield 2 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute3 | Descriptive flexfield 3 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute4 | Descriptive flexfield 4 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute5 | Descriptive flexfield 5 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute6 | Descriptive flexfield 6 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute7 | Descriptive flexfield 7 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute8 | Descriptive flexfield 8 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcReservedAttribute9 | Descriptive flexfield 9 that captures project cost for the supply distribution. Reserved for future use. |
| DosDistributionDetailsPEOPjcTaskId | Value that uniquely identifies the task. Use this attribute when you use a descriptive flexfield to capture details about a project transaction. |
| DosDistributionDetailsPEOPjcTaskNumber | Number that identifies a project task in the supply distribution. |
| DosDistributionDetailsPEOPjcUserDefAttribute1 | Attribute 1 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute10 | Attribute 10 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute2 | Attribute 2 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute3 | Attribute 3 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute4 | Attribute 4 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute5 | Attribute 5 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute6 | Attribute 6 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute7 | Attribute 7 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute8 | Attribute 8 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcUserDefAttribute9 | Attribute 9 that you can use for your own purposes to store project details. |
| DosDistributionDetailsPEOPjcWorkTypeId | Value that uniquely identifies the type of work to do for a project task. |
| DosDistributionDetailsPEORequestId | Value that uniquely identifies the request. |
| DosDistributionDetailsPEOTrackingLineId | Value that uniquely identifies the tracking line. |