[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_MVSTO_DETAILS# |
|---|---|
| Object Type: | VIEW |
| Owner: | EC |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EDI_SENT_FLAG | VARCHAR2 | (1) | ||
| PERIOD_NAME | VARCHAR2 | (15) | ||
| EDI_TRANSACTION_REFERENCE | VARCHAR2 | (35) | ||
| EDI_TRANSACTION_DATE | DATE | |||
| TRANSACTION_DATE | DATE | |||
| SET_OF_BOOKS_PERIOD | VARCHAR2 | (15) | ||
| CREATION_METHOD | VARCHAR2 | (30) | ||
| CREATION_METHOD_EXT1 | VARCHAR2 | (30) | ||
| CREATION_METHOD_EXT2 | VARCHAR2 | (30) | ||
| CREATION_METHOD_EXT3 | VARCHAR2 | (30) | ||
| CREATION_METHOD_EXT4 | VARCHAR2 | (30) | ||
| CREATION_METHOD_EXT5 | VARCHAR2 | (30) | ||
| FLOW_INDICATOR_CODE | VARCHAR2 | (30) | ||
| FLOW_INDICATOR_CODE_EXT1 | VARCHAR2 | (50) | ||
| FLOW_INDICATOR_CODE_EXT2 | VARCHAR2 | (30) | ||
| FLOW_INDICATOR_CODE_EXT3 | VARCHAR2 | (30) | ||
| FLOW_INDICATOR_CODE_EXT4 | VARCHAR2 | (30) | ||
| FLOW_INDICATOR_CODE_EXT5 | VARCHAR2 | (30) | ||
| STAT_METHOD | VARCHAR2 | (30) | ||
| STAT_METHOD_EXT1 | VARCHAR2 | (30) | ||
| STAT_METHOD_EXT2 | VARCHAR2 | (30) | ||
| STAT_METHOD_EXT3 | VARCHAR2 | (30) | ||
| STAT_METHOD_EXT4 | VARCHAR2 | (30) | ||
| STAT_METHOD_EXT5 | VARCHAR2 | (30) | ||
| STAT_TYPE | VARCHAR2 | (30) | ||
| STAT_TYPE_EXT1 | VARCHAR2 | (30) | ||
| STAT_TYPE_EXT2 | VARCHAR2 | (30) | ||
| STAT_TYPE_EXT3 | VARCHAR2 | (30) | ||
| STAT_TYPE_EXT4 | VARCHAR2 | (30) | ||
| STAT_TYPE_EXT5 | VARCHAR2 | (30) | ||
| TRANSPORT_MODE | VARCHAR2 | (30) | ||
| TRANSPORT_MODE_EXT1 | VARCHAR2 | (30) | ||
| TRANSPORT_MODE_EXT2 | VARCHAR2 | (30) | ||
| TRANSPORT_MODE_EXT3 | VARCHAR2 | (30) | ||
| TRANSPORT_MODE_EXT4 | VARCHAR2 | (30) | ||
| TRANSPORT_MODE_EXT5 | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE_EXT1 | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE_EXT2 | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE_EXT3 | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE_EXT4 | VARCHAR2 | (30) | ||
| TRANSACTION_NATURE_EXT5 | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE_EXT1 | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE_EXT2 | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE_EXT3 | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE_EXT4 | VARCHAR2 | (30) | ||
| MOVEMENT_NATURE_CODE_EXT5 | VARCHAR2 | (30) | ||
| ORIGIN_TERRITORY_EU_CODE | VARCHAR2 | (3) | ||
| ORIGIN_TERRITORY_CODE | VARCHAR2 | (2) | ||
| ORIGIN_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | ||
| ORIGIN_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | ||
| ORIGIN_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | ||
| ORIGIN_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | ||
| ORIGIN_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | ||
| DESTINATION_TERRITORY_EU_CODE | VARCHAR2 | (3) | ||
| DESTINATION_TERRITORY_CODE | VARCHAR2 | (2) | ||
| DEST_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | ||
| DEST_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | ||
| DEST_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | ||
| DEST_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | ||
| DEST_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | ||
| DISPATCH_TERRITORY_EU_CODE | VARCHAR2 | (3) | ||
| DISPATCH_TERRITORY_CODE | VARCHAR2 | (2) | ||
| DISPATCH_TERRITORY_CODE_EXT1 | VARCHAR2 | (2) | ||
| DISPATCH_TERRITORY_CODE_EXT2 | VARCHAR2 | (30) | ||
| DISPATCH_TERRITORY_CODE_EXT3 | VARCHAR2 | (30) | ||
| DISPATCH_TERRITORY_CODE_EXT4 | VARCHAR2 | (30) | ||
| DISPATCH_TERRITORY_CODE_EXT5 | VARCHAR2 | (30) | ||
| TRIANGULATION_COUNTRY_EU_CODE | VARCHAR2 | (30) | ||
| TRIANGULATION_COUNTRY_CODE | VARCHAR2 | (30) | ||
| TRIANG_COUNTRY_CODE_EXT1 | VARCHAR2 | (30) | ||
| TRIANG_COUNTRY_CODE_EXT2 | VARCHAR2 | (30) | ||
| TRIANG_COUNTRY_CODE_EXT3 | VARCHAR2 | (30) | ||
| TRIANG_COUNTRY_CODE_EXT4 | VARCHAR2 | (30) | ||
| TRIANG_COUNTRY_CODE_EXT5 | VARCHAR2 | (30) | ||
| PORT | VARCHAR2 | (30) | ||
| PORT_EXT1 | VARCHAR2 | (30) | ||
| PORT_EXT2 | VARCHAR2 | (30) | ||
| PORT_EXT3 | VARCHAR2 | (30) | ||
| PORT_EXT4 | VARCHAR2 | (30) | ||
| PORT_EXT5 | VARCHAR2 | (30) | ||
| AREA | VARCHAR2 | (30) | ||
| AREA_EXT1 | VARCHAR2 | (30) | ||
| AREA_EXT2 | VARCHAR2 | (30) | ||
| AREA_EXT3 | VARCHAR2 | (30) | ||
| AREA_EXT4 | VARCHAR2 | (30) | ||
| AREA_EXT5 | VARCHAR2 | (30) | ||
| MOVEMENT_ID | NUMBER | Yes | ||
| MOVEMENT_TYPE | VARCHAR2 | (30) | ||
| MOVEMENT_TYPE_EXT1 | VARCHAR2 | (30) | ||
| MOVEMENT_TYPE_EXT2 | VARCHAR2 | (30) | ||
| MOVEMENT_TYPE_EXT3 | VARCHAR2 | (30) | ||
| MOVEMENT_TYPE_EXT4 | VARCHAR2 | (30) | ||
| MOVEMENT_TYPE_EXT5 | VARCHAR2 | (30) | ||
| ZONE_CODE | VARCHAR2 | (10) | ||
| ECONOMIC_ZONE_EXT1 | VARCHAR2 | (10) | ||
| ECONOMIC_ZONE_EXT2 | VARCHAR2 | (30) | ||
| ECONOMIC_ZONE_EXT3 | VARCHAR2 | (30) | ||
| ECONOMIC_ZONE_EXT4 | VARCHAR2 | (30) | ||
| ECONOMIC_ZONE_EXT5 | VARCHAR2 | (30) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CURRENCY_CODE_EXT1 | VARCHAR2 | (30) | ||
| CURRENCY_CODE_EXT2 | VARCHAR2 | (30) | ||
| CURRENCY_CODE_EXT3 | VARCHAR2 | (30) | ||
| CURRENCY_CODE_EXT4 | VARCHAR2 | (30) | ||
| CURRENCY_CODE_EXT5 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE_EXT1 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE_EXT2 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE_EXT3 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE_EXT4 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_TYPE_EXT5 | VARCHAR2 | (30) | ||
| CURRENCY_CONVERSION_DATE | DATE | |||
| CURRENCY_CONVERSION_RATE | NUMBER | |||
| MOVEMENT_AMOUNT | NUMBER | |||
| ITEM_COST | NUMBER | |||
| DOCUMENT_UNIT_PRICE | NUMBER | |||
| DOCUMENT_LINE_EXT_VALUE | NUMBER | |||
| OUTSIDE_CODE | VARCHAR2 | (30) | ||
| OUTSIDE_CODE_EXT1 | VARCHAR2 | (30) | ||
| OUTSIDE_CODE_EXT2 | VARCHAR2 | (30) | ||
| OUTSIDE_CODE_EXT3 | VARCHAR2 | (30) | ||
| OUTSIDE_CODE_EXT4 | VARCHAR2 | (30) | ||
| OUTSIDE_CODE_EXT5 | VARCHAR2 | (30) | ||
| OUTSIDE_EXT_VALUE | NUMBER | |||
| OUTSIDE_UNIT_PRICE | NUMBER | |||
| STAT_ADJ_AMOUNT | NUMBER | |||
| STAT_ADJ_PERCENT | NUMBER | |||
| STAT_EXT_VALUE | NUMBER | |||
| DELIVERY_TERMS | VARCHAR2 | (30) | ||
| DELIVERY_TERMS_EXT1 | VARCHAR2 | (30) | ||
| DELIVERY_TERMS_EXT2 | VARCHAR2 | (30) | ||
| DELIVERY_TERMS_EXT3 | VARCHAR2 | (30) | ||
| DELIVERY_TERMS_EXT4 | VARCHAR2 | (30) | ||
| DELIVERY_TERMS_EXT5 | VARCHAR2 | (30) | ||
| PRIMARY_QUANTITY | NUMBER | |||
| TRANSACTION_QUANTITY | NUMBER | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | (3) | ||
| TRANSACTION_UOM_CODE_EXT1 | VARCHAR2 | (3) | ||
| TRANSACTION_UOM_CODE_EXT2 | VARCHAR2 | (30) | ||
| TRANSACTION_UOM_CODE_EXT3 | VARCHAR2 | (30) | ||
| TRANSACTION_UOM_CODE_EXT4 | VARCHAR2 | (30) | ||
| TRANSACTION_UOM_CODE_EXT5 | VARCHAR2 | (30) | ||
| WEIGHT_METHOD | VARCHAR2 | (30) | ||
| WEIGHT_METHOD_EXT1 | VARCHAR2 | (30) | ||
| WEIGHT_METHOD_EXT2 | VARCHAR2 | (30) | ||
| WEIGHT_METHOD_EXT3 | VARCHAR2 | (30) | ||
| WEIGHT_METHOD_EXT4 | VARCHAR2 | (30) | ||
| WEIGHT_METHOD_EXT5 | VARCHAR2 | (30) | ||
| UNIT_WEIGHT | NUMBER | |||
| TOTAL_WEIGHT | NUMBER | |||
| TOTAL_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
| TOTAL_WEIGHT_UOM_CODE_EXT1 | VARCHAR2 | (30) | ||
| TOTAL_WEIGHT_UOM_CODE_EXT2 | VARCHAR2 | (30) | ||
| TOTAL_WEIGHT_UOM_CODE_EXT3 | VARCHAR2 | (30) | ||
| TOTAL_WEIGHT_UOM_CODE_EXT4 | VARCHAR2 | (30) | ||
| TOTAL_WEIGHT_UOM_CODE_EXT5 | VARCHAR2 | (30) | ||
| ALTERNATE_QUANTITY | NUMBER | |||
| ALTERNATE_UOM_CODE | VARCHAR2 | (3) | ||
| ALTERNATE_UOM_CODE_EXT1 | VARCHAR2 | (3) | ||
| ALTERNATE_UOM_CODE_EXT2 | VARCHAR2 | (30) | ||
| ALTERNATE_UOM_CODE_EXT3 | VARCHAR2 | (30) | ||
| ALTERNATE_UOM_CODE_EXT4 | VARCHAR2 | (30) | ||
| ALTERNATE_UOM_CODE_EXT5 | VARCHAR2 | (30) | ||
| COMMODITY_CODE | VARCHAR2 | (240) | ||
| COMMODITY_DESCRIPTION | VARCHAR2 | (240) | ||
| COMMENTS | VARCHAR2 | (240) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| DOCUMENT_SOURCE_TYPE | VARCHAR2 | (30) | ||
| DOCUMENT_REFERENCE | VARCHAR2 | (50) | ||
| DOCUMENT_LINE_REFERENCE | VARCHAR2 | (30) | ||
| TRANSACTING_FROM_ORG | VARCHAR2 | (50) | ||
| TRANSACTING_TO_ORG | VARCHAR2 | (50) | ||
| DISTRIBUTION_LINE_NUMBER | NUMBER | |||
| AFFILIATION_REFERENCE_CODE | VARCHAR2 | (30) | ||
| AFFILIATION_REF_CODE_EXT1 | VARCHAR2 | (30) | ||
| AFFILIATION_REF_CODE_EXT2 | VARCHAR2 | (30) | ||
| AFFILIATION_REF_CODE_EXT3 | VARCHAR2 | (30) | ||
| AFFILIATION_REF_CODE_EXT4 | VARCHAR2 | (30) | ||
| AFFILIATION_REF_CODE_EXT5 | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE_EXT1 | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE_EXT2 | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE_EXT3 | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE_EXT4 | VARCHAR2 | (30) | ||
| CONTAINER_TYPE_CODE_EXT5 | VARCHAR2 | (30) | ||
| CSA_CODE | VARCHAR2 | (30) | ||
| CSA_CODE_EXT1 | VARCHAR2 | (30) | ||
| CSA_CODE_EXT2 | VARCHAR2 | (30) | ||
| CSA_CODE_EXT3 | VARCHAR2 | (30) | ||
| CSA_CODE_EXT4 | VARCHAR2 | (30) | ||
| CSA_CODE_EXT5 | VARCHAR2 | (30) | ||
| OIL_REFERENCE_CODE | VARCHAR2 | (30) | ||
| OIL_REFERENCE_CODE_EXT1 | VARCHAR2 | (50) | ||
| OIL_REFERENCE_CODE_EXT2 | VARCHAR2 | (50) | ||
| OIL_REFERENCE_CODE_EXT3 | VARCHAR2 | (50) | ||
| OIL_REFERENCE_CODE_EXT4 | VARCHAR2 | (50) | ||
| OIL_REFERENCE_CODE_EXT5 | VARCHAR2 | (50) | ||
| PICK_SLIP_REFERENCE | VARCHAR2 | (50) | ||
| PREFERENCE_CODE | VARCHAR2 | (30) | ||
| PREFERENCE_CODE_EXT1 | VARCHAR2 | (50) | ||
| PREFERENCE_CODE_EXT2 | VARCHAR2 | (50) | ||
| PREFERENCE_CODE_EXT3 | VARCHAR2 | (50) | ||
| PREFERENCE_CODE_EXT4 | VARCHAR2 | (50) | ||
| PREFERENCE_CODE_EXT5 | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE_EXT1 | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE_EXT2 | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE_EXT3 | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE_EXT4 | VARCHAR2 | (50) | ||
| RECEIPT_REFERENCE_EXT5 | VARCHAR2 | (50) | ||
| SHIPMENT_LINE_REFERENCE | VARCHAR2 | (30) | ||
| SHIPMENT_LINE_REFERENCE_EXT1 | VARCHAR2 | (30) | ||
| SHIPMENT_LINE_REFERENCE_EXT2 | VARCHAR2 | (30) | ||
| SHIPMENT_LINE_REFERENCE_EXT3 | VARCHAR2 | (30) | ||
| SHIPMENT_LINE_REFERENCE_EXT4 | VARCHAR2 | (30) | ||
| SHIPMENT_LINE_REFERENCE_EXT5 | VARCHAR2 | (30) | ||
| SHIPMENT_REFERENCE | VARCHAR2 | (50) | ||
| SHIPMENT_REFERENCE_EXT1 | VARCHAR2 | (50) | ||
| SHIPMENT_REFERENCE_EXT2 | VARCHAR2 | (50) | ||
| SHIPMENT_REFERENCE_EXT3 | VARCHAR2 | (50) | ||
| SHIPMENT_REFERENCE_EXT4 | VARCHAR2 | (50) | ||
| SHIPMENT_REFERENCE_EXT5 | VARCHAR2 | (50) | ||
| TARIC_CODE | VARCHAR2 | (30) | ||
| TARIC_CODE_EXT1 | VARCHAR2 | (30) | ||
| TARIC_CODE_EXT2 | VARCHAR2 | (30) | ||
| TARIC_CODE_EXT3 | VARCHAR2 | (30) | ||
| TARIC_CODE_EXT4 | VARCHAR2 | (30) | ||
| TARIC_CODE_EXT5 | VARCHAR2 | (30) | ||
| INVOICE_BATCH_REFERENCE | VARCHAR2 | (50) | ||
| INVOICE_DATE_REFERENCE | DATE | |||
| INVOICE_LINE_EXT_VALUE | NUMBER | |||
| INVOICE_LINE_REFERENCE | VARCHAR2 | (30) | ||
| INVOICE_QUANTITY | NUMBER | |||
| INVOICE_REFERENCE | VARCHAR2 | (50) | ||
| INVOICE_UNIT_PRICE | NUMBER | |||
| INVOICE_BATCH_ID | NUMBER | |||
| INVOICE_ID | NUMBER | |||
| CUSTOMER_LOCATION | VARCHAR2 | (50) | ||
| CUSTOMER_NAME | VARCHAR2 | (240) | ||
| CUSTOMER_NUMBER | VARCHAR2 | (50) | ||
| BILL_TO_NAME | VARCHAR2 | (240) | ||
| BILL_TO_NUMBER | VARCHAR2 | (50) | ||
| BILL_TO_SITE | VARCHAR2 | (50) | ||
| SHIP_TO_NAME | VARCHAR2 | (240) | ||
| SHIP_TO_NUMBER | VARCHAR2 | (50) | ||
| SHIP_TO_SITE | VARCHAR2 | (50) | ||
| BILL_TO_CUSTOMER_ID | NUMBER | |||
| BILL_TO_SITE_USE_ID | NUMBER | |||
| SHIP_TO_CUSTOMER_ID | NUMBER | |||
| SHIP_TO_SITE_USE_ID | NUMBER | |||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| VENDOR_NUMBER | VARCHAR2 | (50) | ||
| VENDOR_SITE | VARCHAR2 | (50) | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_SITE_ID | NUMBER | |||
| CATEGORY_ID | NUMBER | |||
| CUSTOMER_TRX_LINE_ID | NUMBER | |||
| FROM_ORGANIZATION_ID | NUMBER | |||
| TO_ORGANIZATION_ID | NUMBER | |||
| INVENTORY_ITEM_ID | NUMBER | |||
| MTL_TRANSACTION_ID | NUMBER | |||
| RCV_TRANSACTION_ID | NUMBER | |||
| ORDER_HEADER_ID | NUMBER | |||
| ORDER_LINE_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| PARENT_MOVEMENT_ID | NUMBER | |||
| PICKING_LINE_DETAIL_ID | NUMBER | |||
| PICKING_LINE_ID | NUMBER | |||
| PO_HEADER_ID | NUMBER | |||
| PO_LINE_ID | NUMBER | |||
| PO_LINE_LOCATION_ID | NUMBER | |||
| REQUISITION_HEADER_ID | NUMBER | |||
| REQUISITION_LINE_ID | NUMBER | |||
| SHIPMENT_HEADER_ID | NUMBER | |||
| SHIPMENT_LINE_ID | NUMBER | |||
| CREATED_BY | NUMBER | |||
| CREATION_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | |||
| LAST_UPDATED_BY | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| ENTITY_ORG_ID | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| TRANSACTION_RECORD_ID | NUMBER | Yes | ||
| TRANSACTION_HEADER_ID | NUMBER | Yes | ||
| RUN_ID | NUMBER | |||
| SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT EDI_SENT_FLAG
, PERIOD_NAME
, EDI_TRANSACTION_REFERENCE
, EDI_TRANSACTION_DATE
, TRANSACTION_DATE
, SET_OF_BOOKS_PERIOD
, CREATION_METHOD
, CREATION_METHOD_EXT1
, CREATION_METHOD_EXT2
, CREATION_METHOD_EXT3
, CREATION_METHOD_EXT4
, CREATION_METHOD_EXT5
, FLOW_INDICATOR_CODE
, FLOW_INDICATOR_CODE_EXT1
, FLOW_INDICATOR_CODE_EXT2
, FLOW_INDICATOR_CODE_EXT3
, FLOW_INDICATOR_CODE_EXT4
, FLOW_INDICATOR_CODE_EXT5
, STAT_METHOD
, STAT_METHOD_EXT1
, STAT_METHOD_EXT2
, STAT_METHOD_EXT3
, STAT_METHOD_EXT4
, STAT_METHOD_EXT5
, STAT_TYPE
, STAT_TYPE_EXT1
, STAT_TYPE_EXT2
, STAT_TYPE_EXT3
, STAT_TYPE_EXT4
, STAT_TYPE_EXT5
, TRANSPORT_MODE
, TRANSPORT_MODE_EXT1
, TRANSPORT_MODE_EXT2
, TRANSPORT_MODE_EXT3
, TRANSPORT_MODE_EXT4
, TRANSPORT_MODE_EXT5
, TRANSACTION_NATURE
, TRANSACTION_NATURE_EXT1
, TRANSACTION_NATURE_EXT2
, TRANSACTION_NATURE_EXT3
, TRANSACTION_NATURE_EXT4
, TRANSACTION_NATURE_EXT5
, MOVEMENT_NATURE_CODE
, MOVEMENT_NATURE_CODE_EXT1
, MOVEMENT_NATURE_CODE_EXT2
, MOVEMENT_NATURE_CODE_EXT3
, MOVEMENT_NATURE_CODE_EXT4
, MOVEMENT_NATURE_CODE_EXT5
, ORIGIN_TERRITORY_EU_CODE
, ORIGIN_TERRITORY_CODE
, ORIGIN_TERRITORY_CODE_EXT1
, ORIGIN_TERRITORY_CODE_EXT2
, ORIGIN_TERRITORY_CODE_EXT3
, ORIGIN_TERRITORY_CODE_EXT4
, ORIGIN_TERRITORY_CODE_EXT5
, DESTINATION_TERRITORY_EU_CODE
, DESTINATION_TERRITORY_CODE
, DEST_TERRITORY_CODE_EXT1
, DEST_TERRITORY_CODE_EXT2
, DEST_TERRITORY_CODE_EXT3
, DEST_TERRITORY_CODE_EXT4
, DEST_TERRITORY_CODE_EXT5
, DISPATCH_TERRITORY_EU_CODE
, DISPATCH_TERRITORY_CODE
, DISPATCH_TERRITORY_CODE_EXT1
, DISPATCH_TERRITORY_CODE_EXT2
, DISPATCH_TERRITORY_CODE_EXT3
, DISPATCH_TERRITORY_CODE_EXT4
, DISPATCH_TERRITORY_CODE_EXT5
, TRIANGULATION_COUNTRY_EU_CODE
, TRIANGULATION_COUNTRY_CODE
, TRIANG_COUNTRY_CODE_EXT1
, TRIANG_COUNTRY_CODE_EXT2
, TRIANG_COUNTRY_CODE_EXT3
, TRIANG_COUNTRY_CODE_EXT4
, TRIANG_COUNTRY_CODE_EXT5
, PORT
, PORT_EXT1
, PORT_EXT2
, PORT_EXT3
, PORT_EXT4
, PORT_EXT5
, AREA
, AREA_EXT1
, AREA_EXT2
, AREA_EXT3
, AREA_EXT4
, AREA_EXT5
, MOVEMENT_ID
, MOVEMENT_TYPE
, MOVEMENT_TYPE_EXT1
, MOVEMENT_TYPE_EXT2
, MOVEMENT_TYPE_EXT3
, MOVEMENT_TYPE_EXT4
, MOVEMENT_TYPE_EXT5
, ZONE_CODE
, ECONOMIC_ZONE_EXT1
, ECONOMIC_ZONE_EXT2
, ECONOMIC_ZONE_EXT3
, ECONOMIC_ZONE_EXT4
, ECONOMIC_ZONE_EXT5
, CURRENCY_CODE
, CURRENCY_CODE_EXT1
, CURRENCY_CODE_EXT2
, CURRENCY_CODE_EXT3
, CURRENCY_CODE_EXT4
, CURRENCY_CODE_EXT5
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_TYPE_EXT1
, CURRENCY_CONVERSION_TYPE_EXT2
, CURRENCY_CONVERSION_TYPE_EXT3
, CURRENCY_CONVERSION_TYPE_EXT4
, CURRENCY_CONVERSION_TYPE_EXT5
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, MOVEMENT_AMOUNT
, ITEM_COST
, DOCUMENT_UNIT_PRICE
, DOCUMENT_LINE_EXT_VALUE
, OUTSIDE_CODE
, OUTSIDE_CODE_EXT1
, OUTSIDE_CODE_EXT2
, OUTSIDE_CODE_EXT3
, OUTSIDE_CODE_EXT4
, OUTSIDE_CODE_EXT5
, OUTSIDE_EXT_VALUE
, OUTSIDE_UNIT_PRICE
, STAT_ADJ_AMOUNT
, STAT_ADJ_PERCENT
, STAT_EXT_VALUE
, DELIVERY_TERMS
, DELIVERY_TERMS_EXT1
, DELIVERY_TERMS_EXT2
, DELIVERY_TERMS_EXT3
, DELIVERY_TERMS_EXT4
, DELIVERY_TERMS_EXT5
, PRIMARY_QUANTITY
, TRANSACTION_QUANTITY
, TRANSACTION_UOM_CODE
, TRANSACTION_UOM_CODE_EXT1
, TRANSACTION_UOM_CODE_EXT2
, TRANSACTION_UOM_CODE_EXT3
, TRANSACTION_UOM_CODE_EXT4
, TRANSACTION_UOM_CODE_EXT5
, WEIGHT_METHOD
, WEIGHT_METHOD_EXT1
, WEIGHT_METHOD_EXT2
, WEIGHT_METHOD_EXT3
, WEIGHT_METHOD_EXT4
, WEIGHT_METHOD_EXT5
, UNIT_WEIGHT
, TOTAL_WEIGHT
, TOTAL_WEIGHT_UOM_CODE
, TOTAL_WEIGHT_UOM_CODE_EXT1
, TOTAL_WEIGHT_UOM_CODE_EXT2
, TOTAL_WEIGHT_UOM_CODE_EXT3
, TOTAL_WEIGHT_UOM_CODE_EXT4
, TOTAL_WEIGHT_UOM_CODE_EXT5
, ALTERNATE_QUANTITY
, ALTERNATE_UOM_CODE
, ALTERNATE_UOM_CODE_EXT1
, ALTERNATE_UOM_CODE_EXT2
, ALTERNATE_UOM_CODE_EXT3
, ALTERNATE_UOM_CODE_EXT4
, ALTERNATE_UOM_CODE_EXT5
, COMMODITY_CODE
, COMMODITY_DESCRIPTION
, COMMENTS
, ITEM_DESCRIPTION
, DOCUMENT_SOURCE_TYPE
, DOCUMENT_REFERENCE
, DOCUMENT_LINE_REFERENCE
, TRANSACTING_FROM_ORG
, TRANSACTING_TO_ORG
, DISTRIBUTION_LINE_NUMBER
, AFFILIATION_REFERENCE_CODE
, AFFILIATION_REF_CODE_EXT1
, AFFILIATION_REF_CODE_EXT2
, AFFILIATION_REF_CODE_EXT3
, AFFILIATION_REF_CODE_EXT4
, AFFILIATION_REF_CODE_EXT5
, CONTAINER_TYPE_CODE
, CONTAINER_TYPE_CODE_EXT1
, CONTAINER_TYPE_CODE_EXT2
, CONTAINER_TYPE_CODE_EXT3
, CONTAINER_TYPE_CODE_EXT4
, CONTAINER_TYPE_CODE_EXT5
, CSA_CODE
, CSA_CODE_EXT1
, CSA_CODE_EXT2
, CSA_CODE_EXT3
, CSA_CODE_EXT4
, CSA_CODE_EXT5
, OIL_REFERENCE_CODE
, OIL_REFERENCE_CODE_EXT1
, OIL_REFERENCE_CODE_EXT2
, OIL_REFERENCE_CODE_EXT3
, OIL_REFERENCE_CODE_EXT4
, OIL_REFERENCE_CODE_EXT5
, PICK_SLIP_REFERENCE
, PREFERENCE_CODE
, PREFERENCE_CODE_EXT1
, PREFERENCE_CODE_EXT2
, PREFERENCE_CODE_EXT3
, PREFERENCE_CODE_EXT4
, PREFERENCE_CODE_EXT5
, RECEIPT_REFERENCE
, RECEIPT_REFERENCE_EXT1
, RECEIPT_REFERENCE_EXT2
, RECEIPT_REFERENCE_EXT3
, RECEIPT_REFERENCE_EXT4
, RECEIPT_REFERENCE_EXT5
, SHIPMENT_LINE_REFERENCE
, SHIPMENT_LINE_REFERENCE_EXT1
, SHIPMENT_LINE_REFERENCE_EXT2
, SHIPMENT_LINE_REFERENCE_EXT3
, SHIPMENT_LINE_REFERENCE_EXT4
, SHIPMENT_LINE_REFERENCE_EXT5
, SHIPMENT_REFERENCE
, SHIPMENT_REFERENCE_EXT1
, SHIPMENT_REFERENCE_EXT2
, SHIPMENT_REFERENCE_EXT3
, SHIPMENT_REFERENCE_EXT4
, SHIPMENT_REFERENCE_EXT5
, TARIC_CODE
, TARIC_CODE_EXT1
, TARIC_CODE_EXT2
, TARIC_CODE_EXT3
, TARIC_CODE_EXT4
, TARIC_CODE_EXT5
, INVOICE_BATCH_REFERENCE
, INVOICE_DATE_REFERENCE
, INVOICE_LINE_EXT_VALUE
, INVOICE_LINE_REFERENCE
, INVOICE_QUANTITY
, INVOICE_REFERENCE
, INVOICE_UNIT_PRICE
, INVOICE_BATCH_ID
, INVOICE_ID
, CUSTOMER_LOCATION
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, BILL_TO_NAME
, BILL_TO_NUMBER
, BILL_TO_SITE
, SHIP_TO_NAME
, SHIP_TO_NUMBER
, SHIP_TO_SITE
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, VENDOR_NAME
, VENDOR_NUMBER
, VENDOR_SITE
, VENDOR_ID
, VENDOR_SITE_ID
, CATEGORY_ID
, CUSTOMER_TRX_LINE_ID
, FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, MTL_TRANSACTION_ID
, RCV_TRANSACTION_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, ORGANIZATION_ID
, PARENT_MOVEMENT_ID
, PICKING_LINE_DETAIL_ID
, PICKING_LINE_ID
, PO_HEADER_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, ENTITY_ORG_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, TRANSACTION_RECORD_ID
, TRANSACTION_HEADER_ID
, RUN_ID
, SECURITY_GROUP_ID
FROM EC.ECE_MVSTO_DETAILS#;
EC
ECE_MVSTO_DETAILS
APPS
ECE_MVSTO_DETAILS
|
|
|
|