1. Tables and Views for SCM
  2. CMR_ASN_INTRANSIT_AMTS

CMR_ASN_INTRANSIT_AMTS

This table stores quantities and other information related to shipment and receipt for an ASN at purchase order schedule level.

Details

  • Schema: FUSION

  • Object owner: CMR

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CMR_ASN_INTRANSIT_AMTS_PK

ASN_INTRANSIT_ID

Columns

Name Datatype Length Precision Not-null Comments
ASN_INTRANSIT_ID NUMBER 18 Yes Surrogate key identifying the ASN intransit amount record. Value is populated from CMR_PROCESS_RUN_DTLS_S sequence.
BILL_TO_BUSINESS_UNIT_ID NUMBER 18 Yes Bill to Business unit used for creating intransit data.
BUSINESS_UNIT_ID NUMBER 18 Business unit where intransit inventory value is recorded.
INVENTORY_ORG_ID NUMBER 18 Inventory organization where the intransit value is recorded.
PERIOD_NAME VARCHAR2 15 The accounting period for which the intransit is computed and recorded.
RUN_DATE DATE Indicates the date on which the record intransit inventory for external purchases process is run.
PERIOD_START_DATE DATE Indicates the start date of the accounting period.
PERIOD_END_DATE DATE Indicates the end date of the accounting period.
INVENTORY_ITEM_ID NUMBER 18 Inventory item identifier and it references {EGP_SYSTEM_ITEMS_B.inventory_item_id}.
TRANSACTION_DATE DATE Identifies the date of the incoterms intransit transaction.
TRANSACTION_TYPE VARCHAR2 25 Identifies the receiving transaction type.
SHIPMENT_DATE DATE Indicates the date on which the shipment was created.
LATEST_RECEIPT_DATE DATE Indicates the latest receipt date for the PO schedule and ASN line.
RECEIPT_NUMBER VARCHAR2 20 Receipt number for receiving shipment header row and references RCV_SHIPMENT_headers{RECEIPT_NUM}.
SHIPMENT_QUANTITY NUMBER This column stores the quantity shipped in source document UOM for the ASN line at the PO schedule level.
RECEIVED_QUANTITY NUMBER This column stores the quantity received in source document UOM for the ASN line at the PO schedule level.
INTRANSIT_QUANTITY NUMBER This column stores the Intransit quantity in source document UOM for a specific ASN line at the PO schedule level. Intransit quantity is the difference between shipped quantity and received quantity.
INTRANSIT_AMOUNT NUMBER This column stores the intransit amount for the ASN line at the PO schedule level. Intransit amount is the product of intransit quantity and PO Price including any non-recoverable tax.
REVERSAL_QUANTITY NUMBER This column stores the reversal intransit quantity in source document UOM for the ASN line at the PO schedule level. Reversal quantity is calculated as the sum of all new receipt quantity recorded for the ASN line after the intransit was booked.
RUN_MODE VARCHAR2 30 Indicates the run mode of the process which created the record. Possible values are Report and Accounting.
POSTED_FLAG VARCHAR2 1 Flag to indicate if transaction is processed or not.
SHIPMENT_LINE_ID NUMBER 18 This column stores the receiving shipment line unique identifier.
ASN_LINE_NUMBER NUMBER 18 This column stores the receiving shipment line number.
SHIPMENT_HEADER_ID NUMBER 18 This column stores the receiving shipment header unique identifier.
FUNC_CURRENCY_CODE VARCHAR2 15 Identifies the functional currency code of the ledger.
INTRANSIT_AMT_FUNC_CURR NUMBER This column stores the intransit amount for the ASN line at the PO schedule level in functional currency. Intransit amount is the product of intransit quantity, PO Price including any non-recoverable tax and currency conversion rate.
CURRENCY_CODE VARCHAR2 15 Identifies the currency code of the PO price.
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type derived from PO header for currency conversion.
CURRENCY_CONVERSION_RATE NUMBER Currency conversion rate derived from the PO.
CURRENCY_CONVERSION_DATE TIMESTAMP The date used to determine the exchange rates for currency conversion.
ASN_UOM_CODE VARCHAR2 3 This column stores the unit of measure code for the receiving shipment receipt line.
SOURCE_DOC_UOM_CODE VARCHAR2 3 This column stores the source document's unit of measure code.
UOM_CONVERSION_FACTOR NUMBER The conversion factor from shipment transaction UOM to the PO source document UOM.
PO_PRICE NUMBER Purchase price (per unit) specified by the buyer on the purchase order in source document UOM.
NR_TAX NUMBER Non-recoverable tax (per unit) amount in source document UOM.
PO_LINE_LOCATION_ID NUMBER 18 Purchase order shipment schedule identifier.
PO_NUMBER VARCHAR2 40 Yes User specified number for the purchase order.
SHIPMENT_NUMBER VARCHAR2 40 Shipment number assigned by the shipment's source. Corresponds to the asn number, in-transit shipment number and transfer order shipment number.
FOB_LOOKUP_CODE VARCHAR2 30 Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB').
DESTINATION_TYPE_CODE VARCHAR2 25 Identifies type of destination for the material: Inventory, Expense.
VENDOR_ID NUMBER 18 Identifies the supplier and references {PO_VENDORS.vendor_id}.
VENDOR_SITE_ID NUMBER 18 Identifies the supplier site and references {PO_VENDOR_SITES_ALL.vendor_site_id}.
RETURN_QUANTITY NUMBER Identifies the return quantity.
PRIOR_INTRANSIT_QUANTITY NUMBER This column stores the prior intransit quantity in source document UOM for a specific ASN line at the PO schedule level. Prior intransit quantity is the difference between shipped quantity and received quantity.
RETRO_PRICE_FLAG VARCHAR2 2 Identifies the retro price change event.
NEW_PO_PRICE NUMBER Changed purchase price (per unit) specified by the buyer on the purchase order in source document UOM.
NEW_NR_TAX NUMBER Updated non-recoverable tax (per unit) amount in source document UOM.
SCHEDULE_STATUS VARCHAR2 25 Shipment status(applicable only to SPO).
OWNERSHIP_CHANGE VARCHAR2 64 Indicates Ownership change for the FOB code.
LINE_NUMBER VARCHAR2 40 User specified number for the purchase order line.
SHIP_TO_LOCATION_ID NUMBER 18 The identifier of the specific location that the goods are being shipped.
PO_ITEM_DESCRIPTION VARCHAR2 240 Item description specified in purchase order line. Especially needed for purchase orders involving non inventory items.
PO_SCHEDULE_NUMBER VARCHAR2 40 User specified number for the purchase order shipment.
ASN_STATUS VARCHAR2 25 This column stores the shipment line status code. Values: EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
LE_TIMEZONE_CODE VARCHAR2 50 Represents the time zone code of the legal entity.

Indexes

Index Uniqueness Tablespace Columns
CMR_ASN_INTRANSIT_AMTS_N1 Non Unique Default PERIOD_NAME, BILL_TO_BUSINESS_UNIT_ID
CMR_ASN_INTRANSIT_AMTS_N2 Non Unique Default SHIPMENT_LINE_ID
CMR_ASN_INTRANSIT_AMTS_N3 Non Unique Default PO_LINE_LOCATION_ID
CMR_ASN_INTRANSIT_AMTS_N4 Non Unique Default POSTED_FLAG
CMR_ASN_INTRANSIT_AMTS_N5 Non Unique Default RETRO_PRICE_FLAG
CMR_ASN_INTRANSIT_AMTS_U1 Unique Default ASN_INTRANSIT_ID