Purchasing Document Line Details

The Purchasing Document Line Details view object contains information about purchase order and blanket agreement lines. It manages purchasing details such as the item to purchase, unit of measure, and price.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentLineExtractPVO

Primary Keys : PoLineId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AgingPeriodDays	Maximum number of days the material may be on consignment.
AllowDescriptionUpdateFlag	Indicates if you can change the description on release shipments. Possible values are Y and N. This attribute doesn't have a default value.
AllowPriceOverrideFlag	Indicates if you can change the price on release shipments. Possible values are Y and N. This attribute doesn't have a default value.
Amount	Amount of the service on the purchase order line.
AmountReleased	Total value of goods and services ordered related to a purchase agreement.
AuctionDisplayNumber	Number that indicates the negotiation number.
AuctionHeaderId	Value that uniquely identifies the negotiation.
AuctionLineNumber	Number that indicates the negotiation line number.
BaseModelId	Value that uniquely identifies the buying organization for the model item from which an assemble-to-order configuration was created.
BaseModelPrice	Unit price of the base model from which the configuration was built.
BaseQty	Base quantity of the unit for the item ordered.
BaseUnitPrice	Base price of the unit for the item ordered.
BaseUom	Base unit of measure for the item ordered.
BidLineNumber	Number that indicates the bid line.
BidNumber	Number that indicates the bid number.
CancelDate	Date when the purchase order line was canceled.
CancelFlag	Contains one of the following values: true or false. If true, then the purchase order line is canceled. If false, then the purchase order line isn't canceled. This attribute doesn't have a default value.
CancelReason	Description of the reason for cancellation.
CancelledBy	User who canceled the purchase order line.
CapitalExpenseFlag	Indicates if the line is for a capital expense. Possible values are Y and N. This attribute doesn't have a default value.
CategoryId	Value that uniquely identifies the purchasing category.
ClosedBy	User who closed the line.
ClosedDate	Date when the line was closed.
ClosedReason	Description of the reason why line was closed.
CommittedAmount	Amount agreed for an agreement line.
ConfiguredItemFlag	Contains one of the following values: true or false. If true, then the purchased item is a configuration, which is a single shippable unit made of a base model and optional additions. If false, then the purchased item is a standard item. This attribute doesn't have a default value.
ConsignmentLineFlag	Contains one of the following values: true or false. If true, then the item on the purchase order is under consignment. If false, then the item isn't under consignment. This attribute doesn't have a default value.
ContractId	Value that uniquely identifies the agreement reference of a line.
ContractorFirstName	First name of the contingent worker.
ContractorLastName	Last name of the contingent worker.
CreatedBy	User who created the purchase order line.
CreationDate	Date and time when the buyer or application created the purchase order line.
Discount	Discount percent or amount of the purchase order line.
DiscountReason	Description of the reason for the discount.
DiscountType	Value that indicates if the discount is based on percent or amount.
ExpirationDate	Date after which the item on this line can no longer be ordered.
FromHeaderId	Value that uniquely identifies the quotation or global agreement referenced by this line.
FromLineId	Value that uniquely identifies the quotation line or global agreement line referenced by this line.
FromLineLocationId	Value that uniquely identifies the price break referenced by this line.
FundsStatus	Status of the funds check or funds reservation validation result for the line.
HazardClassId	Value that uniquely identifies the hazard class.
ItemDescription	Description for the line item.
ItemId	Value that uniquely identifies the item on the purchase order.
ItemRevision	Revision number of the item.
JobDefinitionName	Name of the job that created or last updated the row.
JobDefinitionPackage	Package name of the job that created or last updated the row.
JobId	Value that uniquely identifies the job that created or last updated the row.
LastUpdateDate	Date and time when the buyer or application last updated the purchase order line.
LastUpdateLogin	Session login associated with the user who last updated the row.
LastUpdatedBy	User who last updated the purchase order line.
LastUpdatedProgram	Name of the program that last updated the row.
LineNum	Number that uniquely identifies the purchase order line.
LineReferenceNum	Number used for EDI transaction audit trail reference.
LineStatus	Value that indicates the status of the line.
LineTypeId	Value that uniquely identifies whether the purchase order line references an item or a service.
ListPrice	List price for the item on the line.
ListPricePerUnit	Price per unit of the item or service offered.
ManualPriceChangeFlag	Contains one of the following values: true or false. If true, then the price was manually changed by the user. If false, then the default price was applied by the application. This attribute doesn't have a default value.
Manufacturer	Value that identifies a person or company that makes goods.
ManufacturerPartNum	Contains a unique number that's issued by manufacturers to identify individual products. Normally, the MPN of a product is a series of numbers and letters.
MarketPrice	Market price for the item on the line. This price defaults from EGP_SYSTEM_ITEMS_B.market_price.
MatchingBasis	Matching basis of the line type.
MaxRetainageAmount	Maximum amount that can be withheld as retainage against a contract line.
MinReleaseAmount	Minimum amount that can be released against a planned or blanket agreement line.
NegotiatedByPreparerFlag	Contains one of the following values: true or false. If true, then the buyer and the supplier negotiated and agreed on the price before the purchase. If false, then the buyer and the supplier didn't negotiate the price before the purchase. This attribute doesn't have a default value.
NextConsumptionAdvGenDate	Date when consumption advice was generated for this line.
NotToExceedPrice	Price limit that you can't exceed on a release shipment.
NoteToVendor	Note that the supplier can read to get details about how to process the order line on the purchase order.
ObjectVersionNumber	Number that indicates the version of the row.
OkeContractHeaderId	Value that uniquely identifies the associated contract.
OkeContractVersionId	Value that uniquely identifies the version of the associated contract.
OptionsPrice	Sum of the extended price of all options chosen for each unit of the purchased configuration.
OrderTypeLookupCode	Value basis of the line.
OverToleranceErrorFlag	Indicates whether receipts exceeding the tolerance are rejected. Possible values are Y and N. This attribute doesn't have a default value.
ParentItemId	Value that uniquely identifies the parent option class or model for the item.
PjcBuBigDecimal	Value that uniquely identifies the project business unit.
PoHeaderId	Value that uniquely identifies the purchase order or agreement.
PoLineId	Value that uniquely identifies the purchase order or agreement line.
PrcBuId	Value that uniquely identifies the procurement business unit.
PreferredGrade	Quality grade preferred for the item ordered.
PriceBreakLookupCode	Pricing scheme for the price breaks of this line.
PriceTypeLookupCode	Price type of the line.
ProgressPaymentRate	Percentage applied to completed work to determine the amount eligible for payment.
PurchaseBasis	Purchase basis of the line type.
QtyRcvTolerance	Value that indicates the quantity received tolerance percentage.
Quantity	Quantity of the item on the order line.
QuantityCommitted	Quantity agreed for an agreement line.
ReqBuId	Value that uniquely identifies the requisitioning business unit for the line.
RequestId	Value that uniquely identifies the request ID of the job that created or last updated the row.
RetroactiveDate	Date when the retroactive price change was done.
SecondaryQuantity	Line quantity in the secondary unit of measure. This attribute is applicable when more than one unit of measure controls the item.
SecondaryUomCode	Secondary unit of measure to use for the quantity when more than one unit of measure controls the item.
ShippingUomCode	Code that identifies the supplier-requested shipment unit of measure.
ShippingUomQuantity	Quantity in the shipping unit of measure.
SourceDocRevNum	Revision number of the source document for the line.
StartDate	Assignment start date for the contingent worker.
SupplierParentItem	Supplier's identification number for the option class or model associated with item.
SupplierPartAuxid	Value that uniquely identifies the item.
SupplierRefNumber	Value that identifies a specific configuration of an item.
SupplierTopModel	Value that identifies the top model associated with the option or option class or submodel.
TaxAttributeUpdateCode	Code that indicates the create or update actions on this line.
TaxCodeId	Value that uniquely identifies the tax code.
TaxExclusivePrice	Purchase order line price that's exclusive of all taxes.
TaxName	Name of the tax code that applies to the line.
TaxableFlag	Contains one of the following values: true or false. If true, then the document line is taxable. If false, then the document line isn't taxable. This attribute doesn't have a default value.
TopModelId	Value that uniquely identifies the top model associated with the option or option class or submodel.
UnNumberId	Value that uniquely identifies the number that the United Nations uses to identify hazardous material.
UnitPrice	Unit price for the line.
UnorderedFlag	Indicates whether the line was created from unordered receipts. Possible values are Y and N. This attribute doesn't have a default value.
UomCode	Code that identifies the unit of measure.
VendorProductNum	Value of the supplier item number.
WorkOrderProduct	Name of the finished item that the work order in contract manufacturing creates.