Purchasing Document Distributions
The Purchasing Document Distribution view object contains accounting distribution information for a purchase order schedule.
Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentDistributionExtractPVO
Primary Keys : PoDistributionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
AccrualAccountId | Value that uniquely identifies the account to charge for receipt accrual. It applies when the legal entity of the requisitioning business unit and the sold-to legal entity are the same. |
AccrueOnReceiptFlag | Contains one of the following values: Y or N. If Y, then the purchase order distribution is accrued on receipt. If N, then the purchase order distribution is accrued at period end. This attribute doesn't have a default value. |
AccruedFlag | Contains one of the following values: Y or N. If Y, then the distribution was accrued. If N, then the distribution wasn't accrued. This attribute doesn't have a default value. |
AmountBilled | Amount equivalent of the matched invoice distributions based on the purchase price. |
AmountCancelled | Amount that was canceled for distributions associated with service lines. |
AmountDelivered | Amount that was delivered for distributions associated with service lines. |
AmountOrdered | Unit price multiplied by the distribution quantity. It applies when the purchase order line contains a quantity. If the purchase order line references a fixed price service, then this attribute contains the fixed price of the service. |
BudgetDate | Date to use to determine the time frame when the organization consumed the budget. |
CodeCombinationId | Value that uniquely identifies the account to charge for the purchase. It applies when the legal entity of the requisitioning business unit and the sold-to legal entity are the same. |
ConsignmentQuantity | Distribution quantity In consigned inventory after the deliver transaction. |
CreatedBy | User who created the distribution. |
CreationDate | Date and time when the distribution was created. |
DeliverToCustContactId | Value that uniquely identifies the third-party contact that receives the item. |
DeliverToCustId | Value that uniquely identifies the third-party that receives the item. |
DeliverToCustLocationId | Value that uniquely identifies the third-party location that receives the item. |
DeliverToLocationId | Value that uniquely identifies the final location that receives the item. |
DeliverToPersonId | Value that uniquely identifies the final person that receives the item. |
DestChargeAccountId | Value that uniquely identifies the account to charge for the cost of the item in the requisitioning business unit. It applies when the legal entity of the requisitioning business unit and the sold-to legal entity are different. |
DestVarianceAccountId | Value that uniquely identifies the account to charge for the price difference between the invoice and the purchase order in the requisitioning business unit. It applies when the legal entity of the requisitioning business unit and the sold-to legal entity are different. |
DestinationOrganizationId | Value that uniquely identifies the final destination organization. |
DestinationSubinventory | Subinventory that identifies where to deliver the requested item. |
DestinationTypeCode | Code that identifies the final destination type of the purchased item. |
DistIntendedUse | Purpose for which the acquired product is likely to be used in the business by the purchaser. |
DistributionNum | Number that uniquely identifies the purchase order distribution for the purchase order schedule. |
FundsStatus | Indicates whether the distribution amount is reserved or not. Possible values are: FAILED, LIQUIDATED, PARTIALLY_LIQUIDATED, WARNING, PASSED, RESERVED, or NOT_APPLICABLE. |
LastUpdateDate | Date and time when the distribution was last updated. |
LastUpdatedBy | User who last updated the purchase order distribution. |
LineLocationId | Value that uniquely identifies the document schedule. |
NonrecoverableInclusiveTax | Nonrecoverable tax that the purchase order distribution amount contains. The purchaser can't recover this tax. |
NonrecoverableTax | Nonrecoverable exclusive tax amount for the distribution. The purchaser can't recover this tax. |
ObjectVersionNumber | Indicates the version of the purchase order distribution. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
OriginalDistributionId | Value that uniquely identifies the distribution from which this distribution was copied or split. |
PJC_CONTEXT_CATEGORY | Segment for the Project descriptive flexfield. |
PJC_EXPENDITURE_TYPE_ID | Value that identifies the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
PJC_ORGANIZATION_ID | Value that identifies the expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
PJC_PROJECT_ID | Value that identifies the project used to build the transaction descriptive flexfield for project-related transaction distributions. |
PJC_TASK_ID | Value that identifies the task used to build the transaction descriptive flexfield for project-related transaction distributions. |
PoDistributionId | Value that uniquely identifies the purchase order distribution. |
PoHeaderId | Value that uniquely identifies the purchase order. |
PoLineId | Value that uniquely identifies the purchase order line. |
QuantityBilled | Quantity invoiced against the purchase order distribution. |
QuantityCancelled | Quantity canceled against the purchase order distribution |
QuantityDelivered | Quantity delivered against the purchase order distribution |
QuantityOrdered | Total quantity ordered for the purchase order distribution. |
Rate | Conversion rate to use when converting the currency. |
RateDate | Date to use for the conversion rate when converting an amount into another currency. The conversion rate varies depending on date. |
RecoverableInclusiveTax | Recoverable tax that the purchase order distribution amount contains. The purchaser can recover this tax. |
RecoverableTax | Tax amount that's recoverable exclusive for the distribution. The purchaser can recover this tax. |
RecoveryRate | Percentage of tax that can be recovered by the purchaser. |
ReqBuId | Value that uniquely identifies the business unit that requested the goods or services being purchased. |
ReqDistributionId | Value that uniquely identifies the requisition distribution associated with the purchase order distribution. |
ReqHeaderReferenceNum | Number that uniquely identifies the requisition number of the corresponding paper requisition, if you don't autocreate the purchase order from online requisitions. |
ReqLineReferenceNum | Number that uniquely identifies the requisition line number of the corresponding paper requisition, if you don't autocreate the purchase order from online requisitions. |
RetainageReleasedAmount | Amount of retainage released against the purchase order schedule. |
RetainageWithheldAmount | Total amount withheld as retainage against the purchase order schedule. |
SetOfBooksId | Value that uniquely identifies the primary ledger for the distribution. |
ShippingUomQtyCanceled | Value that identifies the most current canceled quantity in the shipping unit of measure. |
ShippingUomQtyDelivered | Value that identifies quantity in the shipping unit of measure that's delivered against the distribution. |
ShippingUomQuantity | Value that identifies the quantity in the shipping unit of measure. |
TaxAttributeUpdateCode | Code that identifies the create and update actions on the distribution. |
TaxExclusiveAmount | Tax amount exclusive for the distribution. Includes both recoverable and nonrecoverable portions. |
TaxRecoveryOverrideFlag | Contains one of the following values: Y or N. If Y, then tax recovery should be used. If N, then tax recovery should not be used. This attribute doesn't have a default value. |
UnencumberedAmount | Amount on the schedule encumbered to date. |
VarianceAccountId | Value that uniquely identifies the account to charge for the price difference between the invoice and the purchase order. Applies when the legal entity of the requisitioning business unit and the sold-to legal entity are the same. |