Requisition Distributions
The Requisition Distributions view object stores information about the accounting and project data for each distribution associated with each requisition line.
Data Store Key : FscmTopModelAM.PrcExtractAM.PorBiccExtractAM.RequisitionDistributionExtractPVO
Primary Keys : DistributionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountUserOverrideFlag | Contains one of the following values: true or false. If true, then the user can override the application determined charge account. If false, then the user can't override the application determined charge account. This attribute doesn't have any default value. |
| Attribute1 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute10 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute11 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute12 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute13 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute14 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute15 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute16 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute17 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute18 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute19 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute2 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute20 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute3 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute4 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute5 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute6 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute7 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute8 | Segment for the Requisition Distribution descriptive flexfield. |
| Attribute9 | Segment for the Requisition Distribution descriptive flexfield. |
| AttributeCategory | Context name for the Requisition Distribution descriptive flexfield. |
| AttributeDate1 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate10 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate2 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate3 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate4 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate5 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate6 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate7 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate8 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeDate9 | Date segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber1 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber10 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber2 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber3 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber4 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber5 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber6 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber7 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber8 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeNumber9 | Number segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp10 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp6 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp7 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp8 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| AttributeTimestamp9 | Date and time segment for the Requisition Distribution descriptive flexfield. |
| BudgetDate | Date to be used for reserving the distribution. |
| CodeCombinationId | Unique identifier for the General Ledger charge account. |
| CreatedBy | User who created the requisition distribution. |
| CreationDate | Date and time when the user created the requisition distribution. |
| DistributionAmount | Amount on the requisition distribution. |
| DistributionCurrencyAmount | Foreign currency amount on the requisition distribution. |
| DistributionId | Value that uniquely identifies the requisition distribution. |
| DistributionNumber | Number that uniquely identifies the distribution associated with a purchase requisition line. |
| DistributionQuantity | Quantity on the distribution. |
| FundsStatus | Status of the funds reservation request. |
| JobDefinitionName | Name of the scheduled process that created or last updated the row. |
| JobDefinitionPackage | Package name of the scheduled process that created or last updated the row. |
| LastUpdateDate | Date and time when the user most recently updated the requisition distribution. |
| LastUpdateLogin | Session login associated with the user who last updated the requisition distribution. |
| LastUpdatedBy | User who last updated the requisition distribution. |
| NonrecoverableCurrencyTax | Foreign currency nonrecoverable tax on the requisition distribution. |
| NonrecoverableTax | Nonrecoverable tax on the requisition distribution. |
| ObjectVersionNumber | Indicates the version number of the requisition distribution row. |
| PJC_BILLABLE_FLAG | Indicates if a project-related item is available to be billed to customers. |
| PJC_CAPITALIZABLE_FLAG | Indicates if a project-related item is eligible for capitalization. |
| PJC_CONTEXT_CATEGORY | Context name for the Requisition Distributions descriptive flexfield for project-related standardized cost collection. |
| PJC_CONTRACT_ID | Value that uniquely identifies contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| PJC_CONTRACT_LINE_ID | Value that uniquely identifies the contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| PJC_EXPENDITURE_ITEM_DATE | Date on which project-related transaction is incurred. |
| PJC_EXPENDITURE_TYPE_ID | Value that uniquely identifies the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions |
| PJC_FUNDING_ALLOCATION_ID | Value that uniquely identifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
| PJC_ORGANIZATION_ID | Value that uniquely identifies the expenditure organization used to build the Requisition Distributions descriptive flexfield for project-related transaction distributions. |
| PJC_PROJECT_ID | Value that uniquely identifies the project used to build the Requisition Distributions descriptive flexfield for project-related transaction distributions. |
| PJC_TASK_ID | Value that uniquely identifies the task used to build the transaction descriptive flexfield for project-related transaction distributions. |
| PJC_WORK_TYPE_ID | Value that uniquely identifies the project-related classification of the work performed. |
| Percent | Allocation split value percent. |
| PrimaryLedgerId | Value that uniquely identifies the Primary Ledger for the charge account. |
| RecoverableCurrencyTax | Foreign currency recoverable tax on the requisition distribution. |
| RecoverableTax | Recoverable tax on the requisition distribution. |
| ReqBuId | Value that uniquely identifies the business unit that raised the requisition for goods and services. |
| RequestId | Value that uniquely identifies the request that created or last updated the row. |
| RequisitionLineId | Value that uniquely identifies the requisition line. |
| VarianceAccountId | Value that uniquely identifies the General Ledger variance account. |