CMR_ASN_INTRANSIT_GT
This is a flattened table which stores latest intransit details for all shipments from CMR_ASN_INTRANSIT_AMTS table.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SHIPMENT_LINE_ID | NUMBER | 18 | This column stores the receiving shipment line unique identifier. | ||
| BILL_TO_BUSINESS_UNIT | VARCHAR2 | 240 | Yes | Bill to Business unit used for creating intransit data. | |
| BUSINESS_UNIT | VARCHAR2 | 240 | Business unit where intransit inventory value is recorded. | ||
| INV_ORG_NAME | VARCHAR2 | 240 | Inventory organization where the intransit value is recorded. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | This column stores the item number of an item. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | This column stores the item description of an item. | ||
| PERIOD_NAME | VARCHAR2 | 15 | The accounting period for which the intransit is computed and recorded. | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 25 | Identifies type of destination for the material: Inventory, Expense. | ||
| FOB_LOOKUP_CODE | VARCHAR2 | 30 | Type of free-on-board terms for the document (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB'). | ||
| PO_NUMBER | VARCHAR2 | 40 | Yes | User specified number for the purchase order. | |
| PO_LINE_NUMBER | NUMBER | This column stores the purchase order shipment line number. | |||
| PO_SCHEDULE_NUMBER | NUMBER | This column stores the purchase order shipment schedule identifier. | |||
| PO_STATUS | VARCHAR2 | 25 | This column stores the status of the purchase order schedule. All statuses are applicable. | ||
| ASN_NUMBER | VARCHAR2 | 40 | Shipment number assigned by the shipment's source. Corresponds to the ASN number. | ||
| ASN_LINE_NUMBER | NUMBER | 18 | This column stores the receiving shipment line number. | ||
| ASN_DATE | DATE | Indicates the date on which the shipment was created. | |||
| ASN_STATUS | VARCHAR2 | 25 | This column stores the shipment line status code. Values: EXPECTED, PARTIALLY RECEIVED, FULLY RECEIVED, CANCELLED. | ||
| AGE_OF_THE_ASN | NUMBER | Indicates the age of the ASN. Age of the ASN is computed by comparing system date with shipment date. If report is run for a prior period, then period end date is used to compute the age. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency code of the PO price. | ||
| FUNC_CURRENCY_CODE | VARCHAR2 | 15 | Identifies the functional currency code of the ledger. | ||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | This column stores the source document's unit of measure code. | ||
| 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. | |||
| RETURN_QUANTITY | NUMBER | Identifies the return quantity. | |||
| 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. | |||
| TOTAL_PO_PRICE | NUMBER | Total Purchase price (per unit) specified by the buyer on the purchase order in source document UOM (including taxes). | |||
| 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. | |||
| DISTRIBUTIONS_AMOUNT | NUMBER | Total of intransit amount for which distributions are created. Distributions are generated when the process is run in accounting mode. | |||
| ACCOUNTED_AMOUNT | NUMBER | Total of intransit amount for which distributions are accounted. | |||
| ACCOUNTING_DATE | DATE | Identifies the date on which purchase order intransit transaction is accounted. | |||
| SUPPLIER | VARCHAR2 | 360 | This column stores the supplier name. | ||
| SUPPLIER_SITE | VARCHAR2 | 240 | This column stores the supplier site name. | ||
| SHIP_TO_LOCATION | VARCHAR2 | 240 | This column stores the ship to location name. | ||
| RECEIPT_NUMBER | VARCHAR2 | 20 | Receipt number for receiving shipment header row and references RCV_SHIPMENT_headers{RECEIPT_NUM}. | ||
| LATEST_RECEIPT_DATE | DATE | Indicates the latest receipt date for the PO schedule and ASN line. |