Fulfillment Lines
The Fulfillment Lines view object that extracts fulfillment line details from the sales orders, such as line type, item, customer, shipping and billing attributes, and so on.
Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineExtractPVO
Primary Keys : FulfillLineId
Initial Extract Date : FulfillLineCreationDate
Incremental Extract Date : FulfillLineLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
FulfillLineAccountingRuleId | Value that identifies the accounting rule on the fulfillment line. |
FulfillLineAccountingRuleIdDerived | Value that identifies the corresponding accounting rule as defined in the application. An accounting rule is a collected entity. The value of this attribute denotes the value derived from the collected value stored by Planning. |
FulfillLineActionTypeCode | Code that identifies the type of action with respect to the coverage or the subscription product on fulfillment line. A list of accepted values is defined in the lookup type ORA_QP_ACTION_TYPES. |
FulfillLineActualCompletionDate | Date when the fulfillment line was processed completely. |
FulfillLineActualShipDate | Date when the item was shipped. |
FulfillLineAgreementHeaderId | Value that identifies the sales agreement on the fulfillment line. |
FulfillLineAgreementLineId | Value that identifies the sales agreement line on the fulfillment line. |
FulfillLineAgreementVersionNumber | Version number of the sales agreement on the fulfillment line. |
FulfillLineAppliedPriceListId | Value that identifies the price list that pricing applied. |
FulfillLineAssessableValue | Value that identifies the price that a tax authority uses to value, and then tax the item. |
FulfillLineAssetGroupNumber | Value that groups customer assets into different categories. |
FulfillLineAssetTrackedFlag | Value that identifies whether the fulfill line is eligible to be interfaced to asset management for tracking customer assets that are created from order processing. |
FulfillLineBatchId | Value that uniquely identifies the batch that was used for importing the order to which the fulfillment line belongs. |
FulfillLineBillToContactId | Value that identifies the contact of the bill-to account on the fulfillment line. |
FulfillLineBillToContactPointId | Value that identifies whether the user modified the lot-serial row. If true, then the user modified the lot-serial row. If false, then the user didn't modify the lot-serial row. |
FulfillLineBillToCustomerId | Value that identifies the account of the bill-to customer on the fulfillment line. |
FulfillLineBillToSiteUseId | Value that identifies the address of the bill-to account on the fulfillment line. |
FulfillLineBillingTrxTypeId | Value that identifies the receivables transaction type on the fulfillment line. |
FulfillLineBuyerId | Value that identifies the buyer details for a schedule. This attribute references the Buyer Public View that the application publishes for the item on the purchase order. |
FulfillLineCancelBackordersFlag | Indicates whether the fulfillment line can be canceled when it's backordered in shipping. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineCancelReasonCode | Value that identifies the reason to cancel the sales order. A list of accepted values is defined in the lookup type DOO_RETURN_REASON. |
FulfillLineCanceledFlag | Indicates whether the fulfillment line was canceled. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineCanceledQty | Canceled quantity. |
FulfillLineCarrierId | Value that identifies the carrier who delivers the item on the fulfillment line. |
FulfillLineCategoryCode | Code that identifies the transaction category. It's used to organize sales order lines that have similar characteristics into a group. A list of accepted values is defined in the lookup type DOO_LINE_CATEGORY. |
FulfillLineChangeEligibleFlag | Value that identifies whether the fulfillment line is eligible for modification by the user. Contains one of the following values: true or false. If true, then allow the user to modify the order line. If false, then don't allow. |
FulfillLineComments | Comments for the order line. |
FulfillLineCompSeqPath | Defines the hierarchical relation of a model. It's derived from BOM table. |
FulfillLineComponentIdPath | Value that identifies the path from the inventory item to the parent of this configured item on the order line. |
FulfillLineConfigCreationDate | Date when the user created the configured item. |
FulfillLineConfigHeaderId | Value that identifies the order header of the sales order that contains the configured item. |
FulfillLineConfigInventoryItemId | Value that identifies the inventory item for an assemble-to-order, configured item. |
FulfillLineConfigItemReference | Reference to the finished configured item. |
FulfillLineConfigItemVersion | Number that identifies the version of a one-time configured item. |
FulfillLineConfigRevisionNumber | Value that identifies the revision number of the configured item. The configurator sets the value of this attribute to the configured item. It doesn't set it to a configure option. |
FulfillLineConfigTradeComplResultCode | Value that identifies the result of trade compliance screening for the configured item. |
FulfillLineConfiguratorPath | Value that identifies the path of the inventory item for the configure option. The path format is a period separated by the inventory item identifier. The format uses brackets to specify configure options that occur in more than one instance. |
FulfillLineContractEndDate | End date of the contract. |
FulfillLineContractStartDate | Start date of the contract. |
FulfillLineCreatedBy | User who created the fulfillment line row. |
FulfillLineCreatedInRelease | Value that identifies the application release in which the fulfillment line was created. |
FulfillLineCreationDate | Date when the fulfillment line row was created. |
FulfillLineCreationMode | Value that identifies the interface from which the order fulfillment line was captured. |
FulfillLineCreditChkAuthExpDate | Date when the approved credit authorization expires. |
FulfillLineCreditChkAuthNum | Value that uniquely identifies the approved credit authorization that the credit management system created on the authorized amount for the customer account. This attribute applies to credit checks only for authorization or reauthorization. |
FulfillLineCustomerItemId | Value that uniquely identifies the customer item. |
FulfillLineCustomerPoLineNumber | Number of the purchase order line on the fulfillment line. |
FulfillLineCustomerPoNumber | Number of the purchase order on the fulfillment line. |
FulfillLineCustomerPoScheduleNumber | Value that identifies the schedule for the shipment that ships the purchase order. This is an optional attribute that the user can specify when submitting the sales order. |
FulfillLineDefaultTaxationCountry | Value that identifies the country that the tax authority uses to calculate tax. |
FulfillLineDeltaType | Value that identifies the type of change, such as update, cancel, and so on. Order Management uses this value when processing change orders. |
FulfillLineDemandClassCode | Code that identifies the demand class. A list of accepted values is defined in the lookup type ORA_DOO_DEMAND_CLASS. |
FulfillLineDemandSourceLineReference | Value that uniquely identifies the demand, such as the line in a shopping cart on a web store or in an e-commerce application. You create a sales order in a web store, the web store sends a request to Oracle Fusion Cloud Global Order Promising to schedule it, Global Order Promising schedules the demand and sends a reply to the web store, the web store sends the sales order to Oracle Fusion Cloud Order Management, then Order Management manages the order through fulfillment. |
FulfillLineDemandSourceScheduledFlag | Value that applies to transactions that start in a web store or e-commerce store. Valid values are Y or N. If Y then, Oracle Fusion Cloud Order Management created a sales order, sent the demand source line reference to Oracle Fusion Cloud Global Order Promising, Global Order Promising successfully scheduled the demand, and then Order Management received a response from Global Order Promising. If N then, Global Order Promising hasn't successfully scheduled this demand, or the line doesn't contain demand source line reference. |
FulfillLineDerivedItemId | Value that identifies the corresponding inventory item defined in the Oracle Fusion application. |
FulfillLineDerivedOrgId | Value that identifies the corresponding inventory organization defined in the Oracle Fusion application. |
FulfillLineDestinationLocationId | Value that identifies the destination location where the application ships the item. |
FulfillLineDestinationOrgId | Value that identifies the destination organization where the application ships the item. |
FulfillLineDocumentSubType | Value that identifies the tax classification for tax reporting, depending on the requirements for each country. |
FulfillLineDraftScheduledFlag | Contains one of the following values: Y or N. If Y, the user manually schedules the draft fulfillment line using the Schedule action on the Create Order, Search Order, and Check Availability pages in Oracle Fusion Cloud Order Management. If N or null, the draft fulfillment line isn't scheduled manually. The default value is N. |
FulfillLineEarliestAcceptableShipDate | Earliest date when the customer expects the item to be shipped. |
FulfillLineEndCreditMethodCode | Value that identifies the credit method used for ending or closing the subscription. A list of accepted values is defined in the lookup type ORA_OSS_CLOSE_CREDIT_METHOD. |
FulfillLineEndDate | Date when the subscription ends. |
FulfillLineEndReasonCode | Value that identifies the reason for ending or closing the subscription. A list of accepted values is defined in the lookup type ORA_OSS_CLOSE_REASONS. |
FulfillLineEnforceSingleShipmentFlag | Indicates whether, during ship confirm, the order lines that can't be shipped in one shipment are canceled. A list of accepted values is defined in the lookup type YES_NO. If Y, then backorders with multiple shipments are canceled. This attribute can be set to true only if the CancelBackordersFlag is also set to Y. The default value is N. |
FulfillLineEstimateFulfillmentCost | Estimated cost to deliver the fulfillment line to the customer. |
FulfillLineEstimateMargin | Estimated margin expected when shipping the fulfillment line. |
FulfillLineExemptionCertificateNumber | Certification number that the taxing authority provides for tax exemption for each customer who's eligible for tax exemption. |
FulfillLineExtendedAmount | Monetary amount of the fulfillment line. |
FulfillLineExternalPriceBookName | Name of the price book or price list in the external pricing application. |
FulfillLineFinalDischargeLocationId | Value that identifies the final destination location for the purchase. |
FulfillLineFirstPtyRegId | Value that identifies the registration number that the application provides to the supplier. The supplier uses this number to tax the transaction. |
FulfillLineFobPointCode | Code that identifies freight on board. This value identifies ownership of the item while it's in transit. |
FulfillLineFreightTermsCode | Code that identifies the terms for paying freight charges. |
FulfillLineFulfillInstanceId | Value that identifies the fulfillment instance that fulfills this fulfillment line. |
FulfillLineFulfillLineNumber | Number of the fulfillment line. |
FulfillLineFulfillOrgId | Value that identifies the organization that fulfills this fulfillment line. |
FulfillLineFulfillToleranceAbove | The limit for over shipments. |
FulfillLineFulfillToleranceBelow | The limit for under shipments. |
FulfillLineFulfilledQty | Quantity of the item that has been fulfilled. |
FulfillLineFulfillmentDate | Date when the fulfillment line was fulfilled. |
FulfillLineFulfillmentGroupId | Value that identifies the fulfillment group to which the fulfillment line belongs. All lines that belong to the same ship set or model are in the same fulfillment group. |
FulfillLineFulfillmentMode | Code that identifies the type of fulfillment that's required for the fulfillment line, such as shipment from internal warehouse, drop shipment, or back-to-back shipment. A list of accepted values is defined in the lookup type ORA_DOO_FULFILLMENT_MODE. |
FulfillLineFulfillmentSplitRefId | Value that identifies the original fulfillment line when the split was originated from a fulfillment system. |
FulfillLineGopReferenceId | Value that identifies the recommended split fulfillment line that was created by GOP. |
FulfillLineGopRequestRegion | Value that identifies the region details for the promising request that global order promising provides. |
FulfillLineHeaderId | Value that identifies the sales order header associated to the fulfillment line row. This is a foreign key to the Sales Order Headers view object. |
FulfillLineId | Value that uniquely identifies the fulfillment line. This is the primary key of the Fulfillment Lines view object. |
FulfillLineIntendedUseClassifId | Value that uniquely identifies intended use of the item. This is used for tax calculation. |
FulfillLineInternalComments | Comments that Oracle uses to monitor data for an item when processing a fulfillment line. This is strictly for internal use only. |
FulfillLineInventoryInterfacedFlag | Indicates whether Oracle Order Management Cloud has successfully interfaced a fulfillment line to Oracle Inventory Management Cloud. |
FulfillLineInventoryItemId | Value that identifies the inventory item on the fulfillment line. |
FulfillLineInventoryOrganizationId | Value that identifies the inventory organization associated to the inventory item. |
FulfillLineInventoryTransactionFlag | Indicates whether Oracle Order Management Cloud sends a request to Oracle Inventory Management Cloud to perform an inventory transaction when fulfilling the order line instead of using the pick wave, pick, pack, and ship flow. |
FulfillLineInvoiceEnabledFlag | Indicates whether the item qualifies for billing. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineInvoiceInterfacedFlag | Indicates whether the fulfillment line has been sent to the billing system. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineInvoiceableItemFlag | Indicates whether the item is enabled for billing. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineInvoicingRuleId | Value that identifies the invoicing rule on the fulfillment line. |
FulfillLineInvoicingRuleIdDerived | Value that identifies the corresponding invoicing rule as defined in the application. Invoicing rule is a collected entity. The value of this attribute denotes the value derived from the collected value stored by Planning. |
FulfillLineItemSubTypeCode | Code that identifies the subtype of inventory item. A list of accepted values is defined in the lookup type ORA_DOO_ITEM_SUB_TYPE_CODE. |
FulfillLineItemTypeCode | Code that identifies the type of inventory item. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. |
FulfillLineLastUpdateDate | Date when the fulfillment line row was last updated. |
FulfillLineLastUpdateLogin | Session login associated to the user who most recently updated the fulfillment line row. |
FulfillLineLastUpdatedBy | User who most recently updated the fulfillment line row. |
FulfillLineLatestAcceptableArrivalDate | Latest date when the customer is willing to receive shipment. |
FulfillLineLatestAcceptableShipDate | Latest date when the customer expects the item to be shipped. |
FulfillLineLatestExtFulfillLineNumber | Value that identifies an additional key used for communication to fulfillment systems. |
FulfillLineLineId | Value that identifies the sales order line associated to the fulfillment line row. This is a foreign key to the Sales Order Lines view object. |
FulfillLineLineTypeCode | Code that identifies the type of fulfillment line. A list of accepted values is defined in the lookup type ORA_DOO_LINE_TYPES for a buy line and ORA_DOO_RETURN_LINE_TYPES for a return line. |
FulfillLineMdoFlag | Value that identifies the orchestration mode of the fulfillment line. If true, then the orchestration mode is meta-data driven. If false, the orchestration mode is regular. |
FulfillLineModifiedFlag | Value that identifies whether the user modified the order line. If true, then the user modified the order line. If false, then the user didn't modify the order line. |
FulfillLineObjectVersionNumber | Number of times the fulfillment line row has been updated. |
FulfillLineOnHold | Indicates whether the fulfillment line is on hold. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineOneTimeConfigFlag | Indicates whether the assembled to order configured item should be fulfilled as a one-time configuration. A one-time configuration is an assembled-to-order, configured item that's unique on the order line. Order Management keeps that item's number even if you reconfigure the item and modify its structure. |
FulfillLineOpenFlag | Indicates whether the fulfillment line is open. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineOrderedQty | Quantity of the item that's ordered or returned. |
FulfillLineOrderedUom | Code that identifies the unit of measure for the ordered quantity. |
FulfillLineOrgId | Value that identifies the business unit that sells the fulfillment line. |
FulfillLineOrigSysDocumentLineRef | Original reference for the source order line from the source system. |
FulfillLineOrigSysDocumentRef | Original reference for the source order from the source system. |
FulfillLineOriginalInventoryItemId | Value that identifies the original inventory item on the fulfillment line when it was created. |
FulfillLineOverrideScheduleDateFlag | Indicates whether the schedule date has been overridden. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineOwnerId | Value that identifies the owner of the fulfillment line. |
FulfillLinePackingInstructions | Instructions for packing the item on the fulfillment. |
FulfillLineParentFulfillLineId | Value that identifies the immediate parent fulfillment line. This value describes the fulfillment line hierarchy for a configured item or kits. |
FulfillLinePartialShipAllowedFlag | Indicates whether shipping can split a shipment for the ship item in the fulfillment line. A list of accepted values is defined in the lookup type YES_NO. The default value is Y. |
FulfillLinePaymentTermId | Value that identifies the payment term on the fulfillment line. |
FulfillLinePaymentTermIdDerived | Value that identifies the corresponding payment term defined in the Oracle Fusion application. |
FulfillLinePoStatusCode | Status of the purchase order. |
FulfillLinePrefOverriddenBitset | Value that identifies if the fulfillment line has been overridden. This is used to determine if header changes should be cascaded to a fulfillment line. |
FulfillLinePriceUsingSecUomFlag | Contains one of the following values: true or false. If true, then Oracle Order Management Cloud uses the secondary ordered quantity and the secondary unit of measure to price the order line. If false or empty, then Order Management uses the ordered quantity and the ordered unit of measure to price the order line. |
FulfillLinePricedOn | Date when pricing priced the order line. The application sets this date to the system date when pricing begins pricing the order line. |
FulfillLinePrjRecIndicator | Indicates whether a project record exists for the fulfillment line. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineProcessId | Value that identifies the orchestration process assigned on the fulfillment line. |
FulfillLineProcessInstanceId | Values the identifies the orchestration process instance associated to the fulfillment line. |
FulfillLineProcessNumber | Value that identifies the orchestration process. |
FulfillLineProcessSet | Value that identifies the process name to group all fulfillment lines in a single process. |
FulfillLineProdFcCategId | Value that uniquely identifies the product fiscal category for tax classification. |
FulfillLineProductCategory | Value that identifies the item classification that the tax authority uses to tax the item. |
FulfillLineProductType | Value that identifies the type of item classification in Oracle Fusion Tax. The value of the product type specifies whether the transaction line is for an item or service, or whether it's a memo line. |
FulfillLinePromiseArrivalDate | Date when was promised to the customer that the item would arrive. |
FulfillLinePromiseShipDate | Date when was promised to the customer that the item would be shipped. |
FulfillLinePromotionItemFlag | Contains one of the following values: true or false. If true, then the line is a promotion item line added automatically by Oracle Fusion Pricing. If false, then the line isn't added automatically by Oracle Fusion Pricing. The default value is false. |
FulfillLinePurchasingEnabledFlag | Value that identifies whether a purchase order can include the item on the fulfillment line. If true, then the purchase order can include the item on the fulfillment line. If false, then the purchase order can't include the item on the fulfillment line. The default value is set based on the item setup |
FulfillLinePurchasingUom | Value that identifies the unit of measure that procurement set on the purchase order for the supplier. |
FulfillLineQuantityPerModel | Value that identifies the quantity for a configure option on a single configured item. |
FulfillLineRatePlanDocumentId | Value that uniquely identifies the JSON document for a rate plan in Oracle Fusion Pricing Cloud. |
FulfillLineRatePlanId | Value that uniquely identifies a rate plan in Oracle Fusion Pricing Cloud. |
FulfillLineReceivablesOrgId | Value that identifies the receivables business unit. |
FulfillLineReferenceFlineId | Value that identifies the previous fulfillment line. Order Management uses this value when processing change orders. |
FulfillLineRemnantFlag | Indicates whether the corresponding configuration has been partially shipped. A list of accepted values is defined in the lookup type YES_NO. The default value is N. |
FulfillLineRequestArrivalDate | Date when the customer requested that the item would arrive. |
FulfillLineRequestCancelDate | Date when the customer requested to cancel the fulfillment line. |
FulfillLineRequestShipDate | Date when the customer requested that the item would be shipped. |
FulfillLineRequestType | Type of scheduling request. |
FulfillLineRequestedRatePlanId | Value that uniquely identifies the rate plan requested by the user. The rate plan is maintained in Oracle Fusion Cloud Pricing. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions and Rate Usage With Events features. |
FulfillLineRequiredFulfillmentDate | Date when the customer requires fulfillment of the fulfillment line. |
FulfillLineRequisitionBuId | Value that identifies the requisition business unit. |
FulfillLineRequisitionInventoryOrgId | Value that identifies the requisition organization. |
FulfillLineReservableFlag | Indicates whether the item can be reserved. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineReservationId | Value that identifies the reservation. |
FulfillLineReservedQty | Quantity of the item that has been reserved. |
FulfillLineReturnReasonCode | Code that identifies the reason to return the fulfillment line. A list of accepted values is defined in the lookup type DOO_RETURN_REASON. |
FulfillLineReturnableFlag | Indicates whether the item can be returned. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineRmaDeliveredQty | Quantity of the item that has been delivered for the return fulfillment line. |
FulfillLineRootParentFulfillLineId | Value that identifies the root parent fulfillment line. This value describes the fulfillment line hierarchy for a configured item or kit. |
FulfillLineSalesProductTypeCode | Code that identifies the sales product type of the item on the fulfillment line. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. |
FulfillLineSalespersonId | Value that identifies the primary salesperson. |
FulfillLineScheduleArrivalDate | Date when the item is scheduled to arrive. |
FulfillLineScheduleShipDate | Date when the item is scheduled for shipment. |
FulfillLineSchedulingReasonCode | Code that identifies the reason for scheduling. A list of accepted values is defined in the lookup type DOO_SCHEDULE_REASON. |
FulfillLineSecondaryFulfilledQty | Value that identifies the quantity on the fulfillment line for the item or service in the secondary unit of measure that the application uses to fulfill the sales order line. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineSecondaryOrderedQty | Value that identifies the ordered quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineSecondaryRmaDeliveredQty | Value that identifies the delivered quantity on the fulfillment line for the returned item or service in the secondary unit of measure. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineSecondaryShippedQty | Value that identifies the shipped quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineSecondaryUom | Value that identifies the secondary unit of measure for the ordered quantity on the fulfillment line. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
FulfillLineSellingProfitCenterBUId | Value that identifies the profit center business unit for the fulfillment line. |
FulfillLineServiceCancelDate | Date when cancellation of the service item becomes effective. |
FulfillLineServiceDuration | Duration for the coverage or subscription product on the fulfillment line. |
FulfillLineServiceDurationPeriodCode | Code that identifies the duration unit of measure for the coverage or subscription product on the fulfillment line. |
FulfillLineShipClassOfService | Code that identifies the priority of transportation that affects how quickly the product is transported. |
FulfillLineShipModeOfTransport | Code that identifies the type of transportation that's used to ship the product, such as truck, air, or boat. |
FulfillLineShipSetName | Name of the ship set that groups the fulfillment lines for shipping together. |
FulfillLineShipToContactId | Value that identifies the contact of the ship-to account on the fulfillment line. |
FulfillLineShipToContactPointId | Value that identifies the contact point for the ship-to contact. |
FulfillLineShipToCustomerId | Value that identifies the account of the ship-to customer on the fulfillment line. |
FulfillLineShipToPartyContactId | Value that identifies the person whom the product is shipped to or is the contact for the ship-to customer. |
FulfillLineShipToPartyId | Value that identifies the ship-to customer on the fulfillment line. This value contains the person, company, or organization whom the product is shipped to. |
FulfillLineShipToPartySiteId | Value that identifies the address of the ship-to customer on the fulfillment line. |
FulfillLineShipToSiteUseId | Value that identifies the address of the ship-to account on the fulfillment line. |
FulfillLineShipmentPriorityCode | Code that identifies the priority of shipment for the fulfillment line. |
FulfillLineShippableFlag | Indicates whether the item can be shipped. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineShippedQty | Quantity of the item that has been shipped. |
FulfillLineShippedUom | Value that identifies the unit of measure for the quantity shipped. |
FulfillLineShippingInstructions | Instructions for shipping the item on the fulfillment. |
FulfillLineShowInSales | Value that identifies whether to show the ordered item in the Sales Summary page including Configurator summary page. |
FulfillLineSourceLineId | Value that identifies the transaction line from the source system. |
FulfillLineSourceLineNumber | Number of the source order line. |
FulfillLineSourceOrderId | Value that uniquely identifies the transaction from the source system. |
FulfillLineSourceOrderNumber | Number of the source order. |
FulfillLineSourceOrderSystem | Code that identifies the source system that created the source order. |
FulfillLineSourceOrgId | Value that identifies the business unit for the source order. |
FulfillLineSourceRevisionNumber | Revision number of the source order. |
FulfillLineSourceScheduleId | Value that identifies the transaction line schedule from the source system. |
FulfillLineSourceScheduleNumber | Number of the source order line schedule. |
FulfillLineSplitFromFlineId | Value that identifies the source fulfillment line that this fulfillment line was split from. |
FulfillLineStatusCode | Code that identifies the status of the fulfillment line. |
FulfillLineStatusRulesetId | Value that identifies the status rule set that contains the set of conditions used to evaluate the status of the fulfillment line. |
FulfillLineSubinventory | Value that identifies the physical or logical location of the item. |
FulfillLineSubscriptionInterfacedFlag | Value that identifies whether the fulfillment line is interfaced to Oracle Subscription Management Cloud. If true, then the fulfillment line is interfaced to Oracle Subscription Management Cloud. If false, then the fulfillment line isn't interfaced to Subscription Management. |
FulfillLineSubscriptionProfileId | Value that uniquely identifies the subscription profile. |
FulfillLineSubstituteAllowedFlag | Indicates whether the item on the fulfillment line can be substituted. A list of accepted values is defined in the lookup type YES_NO. The default value is Y. |
FulfillLineSubstituteReasonCode | Code that identifies the reason to substitute the item on fulfillment line. A list of accepted values is defined in the lookup type DOO_SUBSTITUTION_REASON. |
FulfillLineSupplierId | Value that identifies the supplier if the item on the fulfillment line is drop shipped. |
FulfillLineSupplierSiteId | Value that identifies the address of the supplier. |
FulfillLineSupplyStatusCode | Status of the supply for the fulfillment line. |
FulfillLineTaxClassificationCode | Code that identifies the tax classification for the fulfillment line. |
FulfillLineTaxClassificationCodeDerived | Value that identifies a group of taxes. |
FulfillLineTaxExemptFlag | Indicates whether the fulfillment line is exempted from taxes. |
FulfillLineTaxExemptionReasonCode | Code that identifies the reason to exempt the tax for the item on fulfillment line. |
FulfillLineTaxExemptionReasonCodeDerived | Value that identifies the corresponding tax exemption reason code as defined in the application. Tax exemption reason code is a collected entity. The value of this attribute denotes the value derived from the collected value stored by Planning. |
FulfillLineTaxInvoiceDate | Value that identifies the tax invoice date that tax reporting uses, depending on the requirements of different countries. |
FulfillLineTaxInvoiceNumber | Value that identifies the invoice number that tax reporting uses depending on the requirements of different countries. |
FulfillLineThirdPtyRegId | Value that identifies the registration number that the customer specifies in the purchase order. |
FulfillLineTotalContractAmount | Value that identifies the total amount for the contract duration according to the total contract quantity. |
FulfillLineTotalContractQuantity | Value that identifies the total quantity for the contract duration including the number of time frames for recurring billing. |
FulfillLineTradeComplianceDate | Value that identifies the most recent date when the application screened the order line for trade compliance. |
FulfillLineTradeComplianceResultCode | Value that identifies the result of trade compliance screening of the fulfillment line. |
FulfillLineTransportationPlannedFlag | Value that identifies whether the transportation planning system plans the fulfillment line. If true, then the transportation planning system plans the fulfillment line. If false, then the transportation planning system doesn't plan the fulfillment line. |
FulfillLineTrxBusinessCategory | Value that identifies the tax classification that the tax authority requires. |
FulfillLineUnitListPrice | Price that the buyer pays for one unit of the item. |
FulfillLineUnitQuantity | Value that identifies the number of units for the item. |
FulfillLineUnitSellingPrice | Selling price for each unit of the item before applying discounts. |
FulfillLineUnreferencedReturnFlag | Indicates whether the customer returned the item without the receipt. A list of accepted values is defined in the lookup type YES_NO. |
FulfillLineUserDefinedFiscClass | Value that identifies the tax classification that the user defines. |
FulfillLineUserUpdateIndicatorBitset | Value that identifies whether the fulfillment line has been updated by the user. This is used in change processing. |
FulfillLineValidConfigurationFlag | Value that identifies whether the configured item is valid. If true, then the configured item is valid. If false, then the configured item isn't valid. The default value is set only for root lines based on configuration validation. |