Purchasing Document Line Locations

The Purchasing Document Line Locations view object contains information about purchase order shipment schedules and blanket agreement price breaks. It manages purchasing details such as ship-to location and delivery date.

Data Store Key : FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentLineLocationExtractPVO

Primary Keys : LineLocationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AccrueOnReceiptFlag	Contains one of the following values: Y or N. If Y, then the purchase order schedule will be accrued on receipt. If N, then the purchase order schedule won't be accrued on receipt. This attribute doesn't have a default value.
AllowSubstituteReceiptsFlag	Contains one of the following values: Y or N. If Y, then the purchase order schedule can receive substitute item in place of ordered item. If N, then the purchase order schedule can't receive substitute item in place of ordered item. This attribute doesn't have a default value.
Amount	Amount agreed on an agreement line between the buying and selling organization.
AmountAccepted	Amount accepted for service lines.
AmountBilled	Amount equivalent of the matched invoice lines based on the purchase price.
AmountCancelled	Amount that was canceled for service lines.
AmountReceived	Amount received for service lines.
AmountShipped	Amount shipped for service lines.
AnticipatedArrivalDate	Date of delivery of the ordered goods based on the current projected date of shipping.
AssessableValue	Assessable value of the product for schedule.
BackToBackFlag	Contains one of the following values: Y or N. If Y, then the material to be received is being specifically purchased to fulfill a sales order from a customer. If N, then the material to be received isn't being purchased to fulfill a sales order from a customer. This attribute doesn't have a default value.
CalculateTaxFlag	Contains one of the following values: Y or N. If Y, then the tax needs to be calculated. If N, then the tax should not be calculated. This attribute doesn't have a default value.
CancelBudgetDate	Budget date on the shipment used for commitment control for cancel action.
CancelDate	Date when the schedule was canceled.
CancelFlag	Contains one of the following values: Y or N. If Y, then the purchase order is canceled. If N, then the purchase order isn't canceled. This attribute doesn't have a default value.
CancelReason	Shipment cancellation reason provided by an employee.
CancelledBy	User who canceled the schedule.
CarrierId	Value that uniquely identifies the carrier on the schedule.
ChangePromisedDateReason	Reason for changing the promised-by date on the schedule.
ClosedBy	User who closed the shipment.
ClosedDate	Date when the shipment was closed.
ClosedDateTime	Date and time when the shipment was closed.
ClosedForInvoiceDate	Date when the shipment was closed for invoicing.
ClosedForReceivingDate	Date when the shipment was closed for receiving.
ClosedReason	Text description of the previous closure of a document schedule.
ConsignedFlag	Contains one of the following values: Y or N. If Y, then the shipment is consigned. If N, then the shipment isn't consigned. This attribute doesn't have a default value.
CountryOfOriginCode	Code that identifies the country from which shipment goods were exported.
CreatedBy	User who created the schedule.
CreationDate	Date and time when the schedule was created.
CustomerItem	Identifier used by the customer for the product being procured that fulfills the customer's sales order in a drop ship arrangement.
CustomerItemDesc	Description used by the customer for the product being procured that fulfills the customer's sales order in a drop ship arrangement.
CustomerPoLineNumber	Purchase order line number that identifies the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement.
CustomerPoNumber	Purchase order number that identifies the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement.
CustomerPoScheduleNumber	Purchase order schedule number that identifies the customer that originated the sales order which is being fulfilled by the material being procured in a drop ship arrangement.
DaysEarlyReceiptAllowed	Maximum acceptable number of days shipment items can be received early.
DaysLateReceiptAllowed	Maximum acceptable number of days shipment items can be received late.
Description	Description of the pay Item on the schedule.
DestinationTypeCode	Code that identifies the final destination of the purchased shipment items.
DropShipFlag	Indicates whether the Shipment has a backing Sales Order Line.
EncumberedDate	Date when shipment was encumbered.
EncumberedFlag	Contains one of the following values: Y or N. If Y, then the shipment is encumbered. If N, then the shipment isn't encumbered. This attribute doesn't have a default value.
EndDate	Date when the price break expires on the schedule.
EnforceShipToLocationCode	Code that identifies what action is taken when the receiving location differs from the ship-to location.
FinalDischargeLocationId	Value that uniquely identifies the final discharge location on the schedule.
FinalMatchFlag	Contains one of the following values: Y or N. If Y, then the shipment is finally matched by AP invoice. If N, then the shipment isn't finally matched by AP invoice. This attribute doesn't have a default value.
FirmDate	Date when the shipment was firmed.
FirmFlag	Contains one of the following values: Y or N. If Y, then the shipment is firmed. If N, then the shipment isn't firmed. This attribute doesn't have a default value.
FirmReason	Reason why the shipment was firmed.
FirmStatusLookupCode	Code that identifies whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application.
FirmedBy	User who firmed the shipment.
FobLookupCode	Code that identifies the type of free-on-board terms for the shipment.
FreightTermsLookupCode	Code that identifies the type of freight terms for the RFQ or quotation shipment.
FromHeaderId	Value that uniquely identifies the agreement header. This is a foreign key of the purchasing document header view object.
FromLineId	Value that uniquely identifies the agreement line. This is a foreign key of the purchasing document line view object.
FromLineLocationId	Value that uniquely identifies the agreement schedule. This is a foreign key of the purchasing document schedule view object.
FundsStatus	Indicates whether the schedule amount is reserved or not. Possible values are: FAILED, LIQUIDATED, PARTIALLY_LIQUIDATED, WARNING, PASSED, RESERVED, or NOT_APPLICABLE.
InputTaxClassificationCode	Code that identifies the tax classification on the schedule.
InspectionRequiredFlag	Contains one of the following values: Y or N. If Y, then the shipment must be inspected before the invoice is paid. If N, then the shipment must not be inspected before the invoice is paid. This attribute doesn't have a default value.
InvoiceCloseTolerance	Percentage tolerance within which a shipment is automatically closed for invoicing when billed.
LastAcceptDate	Date when the ordered quantity or amount on the schedule can be last received.
LastUpdateDate	Date and time when the schedule was last updated.
LastUpdateLogin	Session login associated to the user who last updated the schedule.
LastUpdatedBy	User who last updated the schedule.
LineLocationId	Value that uniquely identifies the document schedule. This is a primary key of the Purchasing Document Schedule view object.
ManualPriceChangeFlag	Contains one of the following values: Y or N. If Y, then the user has manually entered a price overriding the Blanket Agreement price. If N, then the user hasn't manually entered a price overriding the Blanket Agreement price. This attribute doesn't have a default value.
MatchOption	Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt.
MatchingBasis	Matching basis of the schedule.
ModeOfTransport	Type of transportation used to ship the product such as truck, air, or boat.
NeedByDate	Date when the buying company requests the supplier to deliver the item.
NoteToReceiver	Shipment level note to receiver, which would hold the note to receiver info coming from requisition lines.
ObjectVersionNumber	Number of times the line location row has been updated.
OrchestrationCode	Code that identifies the integrating application's orchestrating changes between their application and Oracle Fusion Procurement.
OriginalShipmentId	Shipment ID from which this shipment was copied or split over.
PaymentType	Type of payment such as Manual, Quick, Refund, and Payment Process Request.
PoHeaderId	Value that uniquely identifies the document header. This is a foreign key of the document header view object.
PoLineId	Value that uniquely identifies the document line. This is a foreign key of the document line view object.
PoTradingOrganizationId	Value that uniquely identifies the purchasing trading organization.
PrcBuId	Value that uniquely identifies the business unit that manages and owns the purchasing document.
PriceDiscount	Discount percentage for price break. It applies to RFQs and quotations only.
PriceOverride	Order shipment price or break price for blanket purchase orders, RFQs, and quotations
ProductCategory	Product category that's used to classify products for tax purposes.
ProductFiscClassId	Value that uniquely identifies the product fiscal classification on the schedule.
ProductFiscClassification	Product Fiscal Classification of the products by tax authority for tax purposes. It's based on the inventory item category.
ProductType	Value of product type that specifies whether the transaction line is for a good, or a service, or it's a memo line.
PromisedDate	Date when the supplier has promised to deliver the ordered item or service.
PromisedShipDate	Date when the supplier has promised to ship the item ordered by the buying company.
QtyRcvExceptionCode	Code that identifies what action is taken when the quantity received tolerance is exceeded.
QtyRcvTolerance	Maximum overreceipt tolerance percentage on the schedule.
Quantity	Total quantity ordered for this purchase order schedule.
QuantityAccepted	Quantity on the schedule accepted after inspection.
QuantityBilled	Quantity invoiced against the purchase order schedule.
QuantityCancelled	Quantity canceled against the purchase order schedule.
QuantityReceived	Quantity received against the purchase order schedule.
QuantityRejected	Quantity on the schedule rejected after inspection till today.
QuantityShipped	Quantity shipped against the purchase order schedule.
ReceiptDaysExceptionCode	Code that identifies what action is taken when items are received earlier or later than the allowed number of days specified.
ReceiptRequiredFlag	Contains one of the following values: Y or N. If Y, then the shipment must be received before the invoice is paid. If N, then the shipment must not be received before the invoice is paid. This attribute doesn't have a default value.
ReceiveCloseTolerance	Percentage tolerance within which a shipment is automatically closed for receiving.
ReceivingRoutingId	Value that uniquely identifies the receipt routing on the schedule.
ReopenFinalCloseDate	Date when the finally closed schedule was reopened.
ReqBuId	Value that uniquely identifies the business unit that requested the goods or services being purchased.
RequestId	Value that uniquely identifies the request ID of the job that created or last updated the schedule.
RequestedShipDate	Date when the buyer requested that the supplier ship the shipment item.
RetainageRate	Maximum percentage that can be withheld from an invoice as retainage.
RetainageReleasedAmount	Amount of retainage released against the purchase order schedule.
RetainageWithheldAmount	Total amount withheld as retainage against the purchase order schedule.
RetroactiveDate	Date of a retroactive price change on the schedule.
SalesOrderLineNumber	Sales order line number on the schedule that has to be fulfilled by the material being procured.
SalesOrderNumber	Sales order number on the schedule that has to be fulfilled by the material being procured.
SalesOrderScheduleNumber	Sales order schedule number on the schedule that has to be fulfilled by the material being procured.
SalesOrderUpdateDate	Date and time when any of referenced data elements on the backing Sales Order Line was updated.
ScheduleStatus	Status of the purchase order schedule.
SecondaryQuantity	Secondary quantity ordered on the schedule.
SecondaryQuantityAccepted	Quantity on the schedule accepted in secondary unit of measure after inspection till today.
SecondaryQuantityCancelled	Quantity on the schedule canceled in secondary unit of measure after inspection till today.
SecondaryQuantityReceived	Quantity on the schedule in secondary unit of measure received till today.
SecondaryQuantityRejected	Quantity on the schedule rejected in secondary unit of measure after inspection till today.
SecondaryQuantityShipped	Quantity on the schedule in secondary unit of measure shipped till today.
SecondaryUomCode	Code that identifies the secondary unit of measure for the quantity ordered.
ServiceLevel	Priority of transportation that affects how quickly goods are transported.
SfoAgreementLineNumber	Orchestration agreement line number on the schedule.
SfoAgreementNumber	Number that indicates the orchestration agreement entered into between the legal entities, business units, and trade organizations establishing a trade relationship.
SfoPtrId	Value that uniquely identifies the primary trade relationship in an orchestration agreement.
ShipToCustContactId	Value that uniquely identifies the contact from the company where the good are shipped.
ShipToCustId	Value that uniquely identifies the customer to whom merchandise is being sent.
ShipToCustLocationId	Value that uniquely identifies the location where the supplier should ship the goods.
ShipToLocationId	Value that uniquely identifies the location where the supplier ships the shipment item.
ShipToOrganizationId	Value that uniquely identifies the ship-to organization.
ShipmentClosedDate	Date when the shipment was closed for both receiving and invoicing.
ShipmentNum	Line number of the shipment.
ShipmentType	Type that indicates whether the purchase order shipment record is a schedule or a price break.
ShippingUomCode	Code that identifies the supplier-requested shipment unit of measure.
ShippingUomQuantity	Value that identifies the quantity in the shipping unit of measure.
ShippingUomQuantityAccepted	Value that identifies the most current accepted quantity in the shipping unit of measure after inspection.
ShippingUomQuantityCanceled	Value that identifies the most current canceled quantity in shipping unit of measure.
ShippingUomQuantityReceived	Value that identifies the most current quantity in the shipping unit of measure received.
ShippingUomQuantityRejected	Value that identifies the most current quantity rejected in the shipping unit of measure after inspection.
ShippingUomQuantityShipped	Value that identifies the most current quantity in the shipping unit of measure shipped.
SourceShipmentId	Value that uniquely identifies the planned purchase order shipment that was referenced when creating this scheduled release shipment. This is a foreign key of the Line Location view object.
StartDate	Date when the shipment price break gets effective.
SupplierOrderLineNumber	Number that indicates the supplier change request on the schedule.
TaxAttributeUpdateCode	Code that identifies the create or update action on the schedule.
TaxCodeId	Value that uniquely identifies the tax code on the schedule.
TaxUserOverrideFlag	Contains one of the following values: Y or N. If Y, then the default tax has been overridden. If N, then the default tax hasn't been overridden. This attribute doesn't have a default value.
TaxableFlag	Contains one of the following values: Y or N. If Y, then the shipment is taxable. If N, then the shipment isn't taxable. This attribute doesn't have a default value.
TermsId	Value that uniquely identifies the payment terms on the schedule.
TransactionFlowHeaderId	Value that uniquely identifies the schedule transaction flow header.
TrxBusinessCategory	Transaction business category for tax purposes as required by a tax authority.
UnencumberedQuantity	Quantity on the schedule encumbered to date.
UnitOfMeasureClass	Unit of measure class of the schedule.
UomCode	Code that identifies the unit of measure for the quantity ordered on the schedule.
UserDefinedFiscClass	Additional classification of the schedule transaction for tax purposes.
ValueBasis	Value basis of the line location.
WorkApproverId	Value that uniquely identifies the FND user ID of the pay item's work confirmation owner.
WorkOrderId	Value that uniquely identifies the contract manufacturing work order.
WorkOrderNumber	Number that indicates the contract manufacturing work order number.
WorkOrderOperationId	Value that uniquely identifies the work order operation sequence.
WorkOrderOperationSeq	Execution sequence of the work order operation.
WorkOrderSubType	Subtype of the manufacturing work order.