Draft Purchasing Document Line Locations
The Draft 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.DraftPurchasingDocumentLineLocationExtractPVO
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 | Value that identifies the amount agreed on an agreement line between the buying and selling organization. |
AssessableValue | Value that identifies the 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. |
BidPaymentId | Value that identifies the bid pay item if it was negotiated in sourcing. |
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. |
CancelBackingReqFlag | Contains one of the following values: Y or N. If Y, then the backing requisition will be canceled. This attribute doesn't have a default value. |
CancelBudgetDate | Value that identifies the 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 | Value that identifies the shipment cancellation reason provided by an employee. |
CancelledBy | User who canceled the schedule |
CarrierId | Value that uniquely identifies the carrier on the schedule. |
ChangeAcceptedFlag | Contains one of the following values: true or false. If true, then purchase order or change order is accepted by supplier. If false, then supplier response isn't required or pending for supplier acceptance. This attribute doesn't have a default value. |
ChangePromisedDateReason | Reason for changing the promised-by date on the schedule. |
CoAmountCancelled | Description of the amount canceled in change order. |
CoQuantityCancelled | Description of the quantity canceled in change order. |
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 | Value that identifies the maximum acceptable number of days shipment items can be received early. |
DaysLateReceiptAllowed | Value that identifies the 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 | Value that identifies 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. |
EntityChangeTypeCode | Value that identifies if the row is new or changed. |
ExternalChangeFlag | Value that identifies if the change is external. |
FinalDischargeLocationId | Value that uniquely identifies the final discharge location on the schedule. |
FirmDate | Date when the shipment was firmed. |
FirmStatusLookupCode | Code that identifies whether you want to prevent this shipment from being automatically rescheduled by your manufacturing application. |
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 | Value that identifies 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 | Code that identifies the tax classification on the schedule. |
InvoiceCloseTolerance | Percentage tolerance within which a shipment is automatically closed for invoicing when billed. |
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. |
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. |
LeadTime | Lead time for the price break and applies to RFQs and quotations only. |
LeadTimeUnit | Unit of measure for the lead time. |
LineIntendedUse | Value that identifies the purpose for which a product is likely to be used in the business by the purchaser. |
LineIntendedUseId | Value that uniquely identifies the product that's likely to be used in the business by the purchaser. |
LineLocationId | Value that uniquely identifies the document shipment schedule. |
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 | Value that identifies whether the invoice for the shipment should be matched to the purchase order or the receipt. |
MatchingBasis | Value that identifies the matching basis of the schedule. |
ModeOfTransport | Value that identifies the 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 | Value that identifies the 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. |
OriginalShipmentId | Value that identifies the shipment ID from which this shipment was copied or split over. |
OutsourcedAssembly | Value that identifies whether the line is Outsourced Assembly or not. |
PaymentType | Value that identifies the type of payment such as manual, quick, refund, and payment process request. |
PjcContextCategory | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. |
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. |
PreferredGrade | Value that identifies the preferred quality grade for the ordered item. |
PriceDiscount | Value that identifies the discount percentage for price break, applies to RFQs and quotations only. |
PriceOverride | Value that identifies the order shipment price or break price for blanket purchase orders, RFQs, and quotations. |
ProductCategory | Value that identifies the product category that's used to classify products for tax purposes. |
ProductFiscClassId | Value that uniquely identifies the product fiscal classification on the schedule. |
ProductFiscClassification | Value that identifies the product fiscal classification of the products by tax authority for tax purposes. It's based on the inventory item category. |
ProductType | Value that identifies the product type that specifies whether the transaction line is for a good, or a service, or it's a memo line. |
ProgramAppName | Value that identifies the application name of the concurrent program. |
ProgramName | Value that identifies the concurrent program.Concurrent programs are system batch jobs that retrieve and push data between Oracle applications and the database. |
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 | Value that identifies the maximum overreceipt tolerance percentage on the schedule. |
Quantity | Value that identifies the total quantity ordered for this purchase order schedule. |
ReasonForChange | Value that identifies the reason for changing the line. |
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 | Value that identifies the percentage tolerance within which a shipment is automatically closed for receiving. |
ReceivingRoutingId | Value that uniquely identifies the receipt routing on the schedule. |
RejectedBy | User who rejected the purchase order line. |
RejectedByRole | Role of the user rejecting the entity record. |
RejectedReason | Value that identifies the purchase order schedule rejected reason. |
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 | Value that identifies the maximum percentage that can be withheld from an invoice as retainage. |
RetroactiveDate | Date of a retroactive price change on the schedule. |
SalesOrderLineNumber | Value that identifies the sales order line number on the schedule that has to be fulfilled by the material being procured. |
SalesOrderNumber | Value that identifies the sales order number on the schedule that has to be fulfilled by the material being procured. |
SalesOrderScheduleNumber | Value that identifies the sales order schedule number on the schedule that has to be fulfilled by the material being procured. |
SalesOrderUpdateDate | Date and time when any of the referenced data elements on the backing sales order line were updated. |
SecondaryQuantity | Value that identifies the secondary quantity ordered on the schedule. |
SecondaryUomCode | Code that identifies the secondary unit of measure for the quantity ordered. |
ServiceLevel | Value that identifies the priority of transportation that affects how quickly goods are transported. |
SfoAgreementLineNumber | Value that identifies the orchestration agreement line number on the schedule. |
SfoAgreementNumber | Value that identifies 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. |
ShipmentNum | Value that identifies the line number of the shipment. |
ShipmentType | Value that identifies 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. |
SourceShipmentId | Value that uniquely identifies the planned purchase order shipment you chose to release from. |
StartDate | Date when the shipment price break is 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. |
TaxName | Name of the tax code that applies to the line. |
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 | Value that identifies the transaction business category for tax purposes as required by a tax authority. |
UnencumberedQuantity | Value that identifies the quantity on the schedule encumbered to date. |
UnitOfMeasureClass | Value that identifies the 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 that identifies the value basis of the line location. |
VmiFlag | Value that identifies the VMI shipment line with value Y |
WorkOrderId | Value that uniquely identifies the contract manufacturing work order. |
WorkOrderNumber | Number that indicates the contract manufacturing work order number. |
WorkOrderOperationSeq | Value that identifies the execution sequence of the work order operation. |