DOO_FULFILL_LINES_ALL

SharedUsed in 17 subject areas93 reporting columns

Order Management (DOO) — line table — one row per line item under the header.

Likely primary key: FULFILL_HEADER_ID, FULFILL_LINE_ID (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
ACTUAL_COMPLETION_DATE		●	Actual completion date.
ACTUAL_SHIP_DATE		●	Actual shipment date.
ASSET_GROUP_NUMBER		●	Asset group number.
ASSET_TRACKED_FLAG		●	Indicator (Y/N) for the asset tracked.
BILLING_SET_ID		●	Identifier for the billing set.
BILLING_SET_NAME		●	Name of the billing set.
BILL_TO_SITE_USE_ID		●	Identifier for the bill to site use.
CANCELED_FLAG		●	Indicator (Y/N) for the canceled.
CANCELED_QTY		●	Canceled quantity.
CANCEL_BACKORDERS_FLAG		●	Indicator (Y/N) for the cancel backorders.
CANCEL_REASON_CODE		●	Code identifying the cancel reason.
CATEGORY_CODE		●	Code identifying the category.
CONFIG_ITEM_VERSION		●	Config item version.
CONTRACT_END_DATE		●	Contract end date.
CONTRACT_START_DATE		●	Contract start date.
CREATION_DATE		●	Date and time the row was created.
CUSTOMER_PO_LINE_NUMBER		●	Customer purchase order line number.
CUSTOMER_PO_NUMBER		●	Customer purchase order number.
DEMAND_CLASS_CODE		●	Code identifying the demand class.
DEMAND_SOURCE_LINE_REFERENCE		●	Demand source line reference.
DRAFT_SCHEDULED_FLAG		●	Indicator (Y/N) for the draft scheduled.
EARLIEST_ACCEPTABLE_SHIP_DATE		●	Earliest acceptable shipment date.
END_CREDIT_METHOD_CODE		●	Code identifying the end credit method.
END_DATE		●	End date.
END_REASON_CODE		●	Code identifying the end reason.
ENFORCE_SINGLE_SHIPMENT_FLAG		●	Indicator (Y/N) for the enforce single shipment.
EXEMPTION_CERTIFICATE_NUMBER		●	Exemption certificate number.
EXTERNAL_PRICE_BOOK_NAME		●	Name of the external price book.
FULFILLED_QTY		●	Fulfilled quantity.
FULFILLMENT_DATE		●	Fulfillment date.
FULFILLMENT_SPLIT_REF_ID		●	Identifier for the fulfillment split reference.
FULFILL_HEADER_ID	PK?	○	Identifier for the fulfill header.
FULFILL_LINE_ID	PK?	●	Identifier for the fulfill line.
FULFILL_LINE_NUMBER		●	Fulfill line number.
FULFILL_TOLERANCE_ABOVE		●	Fulfill tolerance above.
FULFILL_TOLERANCE_BELOW		●	Fulfill tolerance below.
HEADER_ID		●	Identifier for the header.
INVENTORY_INTERFACED_FLAG		●	Indicator (Y/N) for the inventory interfaced.
INVENTORY_ITEM_ID		●	Identifier for the inventory item.
INVENTORY_TRANSACTION_FLAG		●	Indicator (Y/N) for the inventory transaction.
INVOICE_INTERFACE_STATUS		●	Status of the invoice interface.
ITEM_SUB_TYPE_CODE		●	Code identifying the item sub type.
ITEM_TYPE_CODE		●	Code identifying the item type.
LAST_UPDATED_BY		●	User who last updated the row.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
LATEST_ACCEPTABLE_ARRIVAL_DATE		●	Latest acceptable arrival date.
LATEST_ACCEPTABLE_SHIP_DATE		●	Latest acceptable shipment date.
LINE_ID		●	Identifier for the line.
LINE_TYPE_CODE		●	Code identifying the line type.
ONE_TIME_CONFIG_FLAG		●	Indicator (Y/N) for the one time config.
ON_HOLD		●	On hold.
OPEN_FLAG		●	Indicator (Y/N) for the open.
ORDERED_QTY		●	Ordered quantity.
ORDERED_UOM		●	Ordered unit of measure.
PACKING_INSTRUCTIONS		●	Packing instructions.
PARTIAL_SHIP_ALLOWED_FLAG		●	Indicator (Y/N) for the partial shipment allowed.
PRICE_USING_SEC_UOM_FLAG		●	Indicator (Y/N) for the price using sec unit of measure.
PROMISE_ARRIVAL_DATE		●	Promise arrival date.
PROMISE_SHIP_DATE		●	Promise shipment date.
PROMOTION_ITEM_FLAG		●	Indicator (Y/N) for the promotion item.
REQUEST_ARRIVAL_DATE		●	Request arrival date.
REQUEST_SHIP_DATE		●	Request shipment date.
RESERVABLE_FLAG		●	Indicator (Y/N) for the reservable.
RESERVED_QTY		●	Reserved quantity.
RETURN_REASON_CODE		●	Code identifying the return reason.
RMA_DELIVERED_QTY		●	Rma delivered quantity.
ROOT_PARENT_FULFILL_LINE_ID		●	Identifier for the root parent fulfill line.
SALES_PRODUCT_TYPE_CODE		●	Code identifying the sales product type.
SCHEDULE_ARRIVAL_DATE		●	Schedule arrival date.
SCHEDULE_SHIP_DATE		●	Schedule shipment date.
SCHEDULING_REASON_CODE		●	Code identifying the scheduling reason.
SECONDARY_FULFILLED_QTY		●	Secondary fulfilled quantity.
SECONDARY_ORDERED_QTY		●	Secondary ordered quantity.
SECONDARY_RMA_DELIVERED_QTY		●	Secondary rma delivered quantity.
SECONDARY_SHIPPED_QTY		●	Secondary shipped quantity.
SECONDARY_UOM		●	Secondary unit of measure.
SERVICE_CANCEL_DATE		●	Service cancel date.
SERVICE_DURATION		●	Service duration.
SERVICE_DURATION_PERIOD_CODE		●	Code identifying the service duration period.
SHIPPABLE_FLAG		●	Indicator (Y/N) for the shippable.
SHIPPED_QTY		●	Shipped quantity.
SHIPPING_INSTRUCTIONS		●	Shipping instructions.
SHIP_CLASS_OF_SERVICE		●	Shipment class of service.
SHIP_MODE_OF_TRANSPORT		●	Shipment mode of transport.
SHIP_SET_NAME		●	Name of the shipment set.
SOURCE_LINE_NUMBER		●	Source line number.
SOURCE_ORDER_NUMBER		●	Source order number.
STATUS_CODE		●	Code identifying the status.
SUBSCRIPTION_INTERFACED_FLAG		●	Indicator (Y/N) for the subscription interfaced.
SUPPLIER_ID		●	Identifier for the supplier.
TAX_EXEMPT_FLAG		●	Indicator (Y/N) for the tax exempt.
UNIT_LIST_PRICE		●	Unit list price.
UNIT_SELLING_PRICE		●	Unit selling price.
UNREFERENCED_RETURN_FLAG		●	Indicator (Y/N) for the unreferenced return.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for DOO_FULFILL_LINES_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us