Tableau Connector for Oracle Fusion Cloud Financials

Build 24.0.9060

SupplierNegotiationslines

The Lines resource manages details about products and services that the application sources in a supplier negotiation. For example, catering services or laptop computers.

Columns

Name Type Description
SupplierNegotiationsAuctionHeaderId [KEY] Long SupplierNegotiationsAuctionHeaderId of SupplierNegotiationslines
AuctionHeaderId [KEY] Long AuctionHeaderId of SupplierNegotiationslines
LineId [KEY] Decimal LineId of SupplierNegotiationslines
Line String Number that identifies the negotiation line.
ParentLine String Number that identifies an existing group or lot as a parent line in a negotiation. It is the value stored in the Line attribute. Group Line can be added as a child of Group, and Lot Line can be added as a child of Lot.
Requisition String Requisition of SupplierNegotiationslines
RequisitionLine String RequisitionLine of SupplierNegotiationslines
SourceAgreement String SourceAgreement of SupplierNegotiationslines
SourceAgreementLine String SourceAgreementLine of SupplierNegotiationslines
LineCloseDate Datetime Date and time when the negotiation line closes in a staggered closing or in a negotiation that can extend.
SequenceNumber Int Number that specifies the order in which lines are added to a negotiation using web service.
ParentSequenceNumber Int Sequence number of the parent line to which a child line is added. Group Line can be added as a child of Group, and Lot Line can be added as child of Lot.
GroupType String Type of negotiation line, such as line, group, group line, lot, or lot line. A list of accepted values is defined in the lookup type Negotiation Line Type.
GroupTypeCode String Abbreviation that identifies the type of negotiation line, such as line, group, group line, lot, or lot line. A list of accepted values is defined in the lookup type Negotiation Line Type.
PriceAndQuantityEnabledFlag Bool Contains one of the following values: true or false. If true, then allow each RFI (request for information) line to include price and quantity. If false, then do not allow. If the line resides in a group, then the default value is empty, else the default value is true.
UnitTargetPrice Decimal Price that the procurement organization prefers to pay for the negotiation line, not including cost factors.
DisplayUnitTargetPriceFlag Bool Contains one of the following values: true or false. If true, then allow the supplier to view the unit target price. If false, then do not allow. If the line resides in a group, then the default value is empty, else the default value is false.
LineDescription String Description of the negotiation line.
RequisitioningBU String Name of the requisition business unit that is a client of the procurement business unit.
RequisitioningBUId Long Value that uniquely identifies the requisition business unit that is a client of the procurement business unit.
LineType String Name of the line type that indicates whether the line is for items or services. A list of accepted values is defined in the lookup type ORDER TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Purchasing Line Types task.
LineTypeId Long Value that identifies the line type that indicates whether the line is for items or services.
Item String Name of the inventory item.
ItemId Long Value that identifies the inventory item.
ItemRevision String Revision of the inventory item on the negotiation line.
CategoryName String Name of the purchasing category for the negotiation line.
CategoryId Long Value that identifies the purchasing category for the negotiation line.
Quantity Decimal Quantity of the item in the negotiation.
EstimatedQuantity Decimal Estimated quantity of the item in the negotiation.
UOM String Name of the unit of measure for the item in the negotiation.
UOMCode String Abbreviation that identifies the unit of measure for the item in the negotiation.
ShipToLocation String Name of the location where the application ships the negotiated item, or where the provider performs the negotiated service.
ShipToLocationId Long Value that uniquely identifies the location where the supplier ships the item.
RequestedDeliveryDate Date Date when the application requests to deliver the item that the negotiation line references.
RequestedShipDate Date Date when the application requests to ship the item that the negotiation line references.
CurrentPrice Decimal Price that the procurement organization pays for the item or service.
TargetPrice Decimal Price that the procurement organization prefers pay for the negotiation line.
DisplayTargetPriceFlag Bool Contains one of the following values: true or false. If true, then allow the supplier to view the target price. If false, then do not allow. If the negotiation is a RFI (request for information), or if the application does not enable Allow Price and enable Quantity, then the default value for DisplayTargetPriceFlag is empty. If the line resides in a group, then the default value is empty, else the default value is false.
ResponseRevisionLineDecrementValue Decimal Minimum amount or percentage of reduction of the line price in each revised response.
StartPrice Decimal Highest price that the application allows the supplier to enter in response to a negotiation line.
RetainageRate Decimal Percentage of the amount requested that will be withheld before releasing payments to the contractor.
MaximumRetainageAmount Decimal Maximum amount of retainage that can be withheld on a line.
NoteToSuppliers String Note for the negotiation line for the supplier.
AllowAlternateLinesFlag Bool Contains one of the following values: true or false. If true, then allow the supplier to create an alternate response line for each negotiation line. If false, then do not allow. If Allow Alternate Lines is not enabled, then the default value for AllowAlternateLinesFlag is empty. Otherwise, the default value is true. The value for AllowAlternateLinesFlag is empty for a group or lot line.
EstimatedTotalAmount Decimal Estimated total amount of the service in the negotiation.
MinimumReleaseAmount Decimal Minimum amount in any purchase order line that the application can release for the purchase agreement line.
PriceBreakType String Type of price break. It specifies whether the application calculates the price break according to a single purchase order or across all purchase orders for the agreement. A list of accepted values is defined in the lookup type PON_PRICE_BREAK_TYPE.
PriceBreakTypeCode String Abbreviation that identifies the type of price break. It specifies whether the application calculates the price break according to a single purchase order or across all purchase orders for the agreement. Valid values are CUMULATIVE and NON-CUMULATIVE. A list of accepted values is defined in the lookup type PON_PRICE_BREAK_TYPE.
SuppliersCanModifyPriceBreaksFlag Bool Contains one of the following values: true or false. If true, then allow the supplier to modify price breaks that the procurement organization set up. If false, then do not allow. If the application does not enable price breaks, then the default value is empty. If the line resides in a group, then the value empty, else the default value is true.
CreationDate Datetime CreationDate of SupplierNegotiationslines
CreatedBy String CreatedBy of SupplierNegotiationslines
LastUpdateDate Datetime LastUpdateDate of SupplierNegotiationslines
LastUpdatedBy String LastUpdatedBy of SupplierNegotiationslines
Finder String Finder of SupplierNegotiationslines

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060