ADO.NET Provider for Oracle Fusion Cloud SCM

Build 25.0.9434

InboundShipments

Manages inbound shipment data, including headers, lines, lots, serials, and packing units with flexfield support.

Columns

Name Type Description
ShipmentHeaderId [KEY] Long The unique system-generated identifier assigned to an inbound shipment. This identifier links all related shipment details under a single shipment record, enabling tracking, auditing, and integration with warehouse management, procurement, and receiving processes.
CreatedBy String The username or system identifier that created the inbound shipment record. This field helps track accountability and determine the origin of the shipment entry in the system.
CreationDate Datetime The date and time when the inbound shipment record was initially created in the system. This timestamp is used for tracking shipment processing timelines, auditing records, and monitoring the shipment lifecycle.
LastUpdateDate Datetime The date and time when the inbound shipment record was last updated. This timestamp ensures visibility into modifications such as status changes, quantity adjustments, or updated shipping details.
LastUpdatedBy String The username or system identifier responsible for making the most recent update to the inbound shipment record, allowing for auditing and tracking modifications.
ReceiptSourceCode String A code identifying the source of the inbound shipment. This code indicates whether it originated from a purchase order, a supplier, an internal inventory transfer, or an external third party.
ASNType String The classification of the Advanced Shipping Notice (ASN) linked to the inbound shipment. This classification defines whether the shipment is standard, drop-shipped, cross-docked, or another category.
ShipFromOrganizationId Long The unique identifier for the organization or supplier facility that shipped the inventory. This identifier ensures proper tracking of the shipment source and supplier performance.
ShipFromOrganizationCode String The code representing the shipping organization or supplier facility from which the goods were dispatched. This code aligns logistics data with procurement and supply chain records.
ShipmentNumber String The unique identifier assigned to the inbound shipment by the supplier or carrier. This identifier serves as a reference for shipment tracking, reconciliation, and receiving processes.
ReceiptNumber String A system-generated number assigned to the receipt associated with the inbound shipment. This number links the shipment to receiving transactions and helps track goods once they enter inventory.
BillOfLading String The bill of lading number assigned by the carrier. This number serves as a legally binding document that details the transported goods, the shipper, the consignee, and delivery terms.
PackingSlip String The packing slip number included with the inbound shipment. This field lists the contents, quantities, and packaging details of the shipment, facilitating inventory verification at receiving.
PackagingCode String A standardized code indicating the type of packaging used for the shipment (for example, 'Cartons', 'Pallets', or 'Crates'). This code ensures proper handling, storage, and logistics planning.
SpecialHandlingCode String A code specifying any special handling instructions required for the inbound shipment, such as hazardous materials, temperature control, fragile goods, or security-sensitive items.
ShippedDate Datetime The date and time when the shipment was dispatched from the supplier or originating location. This timestamp marks the official start of the shipment transit period.
FreightCarrierId Long The unique identifier for the freight carrier or shipping provider responsible for transporting the inbound shipment. This identifier ensures traceability and accountability in logistics operations.
Carrier String The name of the freight carrier managing the inbound shipment (for example, FedEx, UPS, or a third-party logistics provider). This field facilitates shipment tracking and coordination.
ExpectedReceiptDate Datetime The estimated date and time when the shipment is expected to arrive at the receiving location. This timestamp enables inventory planning, scheduling, and warehouse resource allocation.
NumberOfContainers Long The total number of containers, cartons, or handling units included in the inbound shipment, ensuring proper logistics coordination and space planning.
WaybillAirbillNumber String The waybill or airbill number assigned by the carrier. This number is used to track the shipment during transit and verify delivery with the carrier’s records.
GrossWeight Decimal The total weight of the inbound shipment, including all packaging materials, pallets, and protective wrapping. This value is used for freight cost calculations, shipping documentation, and weight-based logistics charges.
GrossWeightUOMCode String A code representing the unit of measure (UOM) used for the gross weight, such as 'KG' (kilograms), 'LB' (pounds), or 'TON' (tons). This code ensures consistency in weight calculations across logistics systems.
GrossWeightUOM String A descriptive value specifying the UOM for the gross weight of the shipment. This value ensures clarity in logistics and transportation records.
NetWeight Decimal The total weight of the goods in the inbound shipment, excluding packaging materials, pallets, and additional handling components. This value is used for inventory valuation, product costing, and compliance reporting.
NetWeightUOMCode String A code representing the UOM for the net weight of the shipment. This code ensures standardization in inventory weight tracking and freight calculations.
NetWeightUOM String A description of the UOM for the net weight. This description clarifies how the inventory weight is measured and recorded.
TarWeight Decimal The tare weight of the shipment, which represents the weight of packaging materials, pallets, and containers alone. This value is used to differentiate product weight from total shipment weight in logistics calculations.
TarWeightUOMCode String A code representing the UOM for the tare weight. This code ensures consistency in weight tracking and proper freight cost assessments.
TarWeightUOM String The UOM used for the tare weight of the shipment. This UOM specifies how the weight of packaging materials is quantified. Tare weight refers to the weight of containers, pallets, or other packaging that is excluded from the net weight calculation.
FreightTermsCode String A standardized code that represents the agreed-upon freight terms for the shipment. This cod defines responsibilities for transportation costs, risk liability, and ownership transfer during transit.
FreightTerms String A description of the freight terms that outline whether the supplier, customer, or a third party is responsible for covering freight charges. This field determines the logistics cost structure and delivery conditions.
ShipToOrganizationId Long The unique identifier for the organization that is receiving the shipment. This identifier ensures that the inbound shipment is correctly associated with the intended receiving location in inventory and procurement records.
ShipToOrganizationCode String The organization code representing the receiving entity for the inbound shipment. This code ensures proper categorization within the business structure and inventory management system.
IntegratedSystemCode String A system-generated code that identifies the external or internal system that originated or integrated this shipment record. This code helps ensure proper synchronization between logistics, procurement, and enterprise systems.
Comments String Additional notes, remarks, or special instructions related to the inbound shipment. Comments can include reasons for shipment delays, discrepancies in quantity, or any specific handling requirements.
VendorId Long The unique identifier for the supplier or vendor providing the inbound shipment. This identifier links the record to procurement transactions, supplier contracts, and financial settlements.
SupplierName String The name of the supplier or vendor responsible for fulfilling the shipment. This name is used to track supplier performance, manage procurement relationships, and facilitate payment reconciliation.
SupplierNumber String The unique identifier assigned to the supplier in procurement and financial records. This identifier ensures traceability and consistency in supplier-related transactions.
VendorSiteId Long The unique identifier for the specific vendor site from which the inbound shipment was dispatched. This identifier enables precise tracking of shipments originating from different supplier locations.
SupplierSiteCode String The site code representing the exact location of the supplier’s facility that shipped the goods. This code ensures proper coordination in supplier relationship management and logistics planning.
InvoiceNumber String The unique invoice number provided by the supplier for the inbound shipment. This invoice number is used for financial reconciliation, payment processing, and audit tracking.
InvoiceAmount Decimal The total invoiced amount for the inbound shipment, including item costs, taxes, and additional charges. This field provides a financial record for procurement and accounting purposes.
InvoiceDate Datetime The date the invoice was issued by the supplier. This date is used for tracking payment due dates and ensuring compliance with agreed-upon payment terms.
FreightAmount Decimal The total freight cost associated with transporting the shipment. This information enables accurate cost allocation and expense tracking in financial and logistics records.
TaxAmount Decimal The total tax amount applied to the inbound shipment, ensuring compliance with tax regulations and proper financial reporting.
PaymentTermsId Long The unique identifier referencing the payment terms associated with the inbound shipment. This identifier ensures consistency with supplier contracts and financial policies.
PaymentTerms String The payment terms defining the conditions under which the supplier is to be paid for the inbound shipment, including due dates, discount options, and penalties for late payments.
CurrencyCode String A three-letter currency code representing the currency in which the invoice amount and financial transactions for the shipment are denominated. This code ensures accuracy in multi-currency transactions.
HeaderInterfaceId Long The unique identifier used to interface inbound shipment data between enterprise applications. This identifier enables seamless data integration across procurement, inventory, and financial systems.
BindExpectedReceiptDate Datetime The expected date when the shipment is anticipated to arrive at the receiving location. This date is used for inventory planning, warehouse scheduling, and procurement tracking.
BindOrganizationCode String The code representing the organization associated with the inbound shipment. This code ensures accurate classification within the enterprise structure.
BindOrganizationId Long The unique identifier for the organization receiving or processing the inbound shipment. This identifier ensures consistency in procurement, inventory, and financial records.
BindPOHeaderId Long The unique identifier for the purchase order header associated with the inbound shipment. This identifier links procurement transactions to inbound logistics records.
BindPONumber String The purchase order (PO) number associated with the inbound shipment. This PO number serves as a reference for matching received goods against ordered quantities.
BindShipmentHeaderId Long The unique identifier linking this record to the shipment header. This identifier ensures accurate tracking of all related shipment details within the system.
BindShipmentNumber String The unique shipment number assigned to this inbound shipment. This number allows for easy tracking and reconciliation in logistics and warehouse management.
BindSupplier String The supplier associated with this inbound shipment, ensuring consistency in procurement records and supplier management systems.
BindTONumber String The transfer order (TO) number related to the inbound shipment,. This TO number provides traceability for inventory movements between warehouses or organizational units.
BindTransferOrderHeaderId Long The unique identifier for the transfer order header associated with this inbound shipment. This identifier ensures accurate tracking of inventory transfers between business locations.
BindVendorId Long The unique identifier linking the inbound shipment to a specific vendor. This identifier ensures traceability in supplier transactions, payment processing, and compliance with procurement policies.
Finder String A reference field or search parameter used to locate or filter inbound shipment records efficiently. This field enables streamlined queries and retrieval of shipment data within the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434