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