Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

AsnLinesForReceiving

Tracks individual lines of advanced shipment notices (ASNs) that are ready for receiving into inventory.

Columns

Name Type Description
ASN String The unique identifier for the Advance Shipment Notice (ASN), a supplier-generated document that communicates details of an expected shipment to the receiving organization. This identifier improves supply chain visibility, enhances coordination between suppliers and receivers, and helps streamline the inbound logistics process.
ShipmentHeaderId Long The unique identifier for the shipment header associated with the ASN, serving as a reference point for grouping multiple shipment lines under a single shipment transaction. This identifier ensures that all items shipped together are linked for tracking, validation, and reconciliation within the receiving system.
ASNLine Long The unique line number assigned within an ASN to differentiate individual items or packages within a shipment. Each ASN line contains specific details about an item, including its quantity, unit of measure, and packaging information, facilitating precise receipt verification and inventory updates.
ShipmentLineId [KEY] Long The unique identifier for the shipment line, linking each ASN line to its corresponding record in the receiving system. This identifier ensures accurate tracking of expected shipments, supports three-way matching for invoice reconciliation, and enables real-time visibility into the status of each shipment line.
ItemDescription String The unique text description of the item specified in the ASN, providing critical details such as product name, model number, technical specifications, packaging requirements, and special handling instructions. This information helps receiving personnel accurately verify shipments against purchase orders.
OrganizationCode String The unique alphanumeric code representing the organization or business unit responsible for receiving the ASN shipment. This code ensures that shipments are directed to the correct entity within a multi-organization structure, enabling accurate inventory allocation and financial processing.
OrganizationId Long The unique identifier for the organization associated with the ASN shipment, linking the shipment record to the designated receiving entity. This identifier plays a key role in financial reporting, compliance tracking, and inventory control across different business units or warehouses.
BindASN String The unique identifier for an ASN that is associated with this record, allowing for cross-referencing of related ASNs. This identifier can be used when multiple ASNs are linked due to partial shipments, consolidation, or supplier adjustments.
BindASNLine Long A unique line number within the linked ASN, establishing a connection between associated shipment lines. This linkage helps track changes in shipment quantities, manage split deliveries, and validate adjustments made by the supplier or logistics provider.
BindItemDescription String The unique text description of the item from the linked ASN, ensuring uniformity in item tracking across multiple shipment records. This consistency is crucial for inventory reconciliation, order fulfillment accuracy, and compliance with procurement contracts.
BindOrganizationCode String The unique alphanumeric code representing the organization associated with the linked ASN record. This code helps validate the correct allocation of incoming shipments and ensures compliance with internal receiving processes.
BindOrganizationId Long The unique identifier for the organization associated with the linked ASN, establishing a direct reference between related shipment records. This identifier facilitates seamless tracking of shipments across multiple business units, warehouses, or locations.
Finder String The unique searchable reference used within the system to quickly locate specific ASN lines. This feature enhances operational efficiency by enabling users to retrieve ASN records based on key attributes, such as shipment number, supplier, or item details, supporting faster issue resolution and receiving operations.

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