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. |