[Home] [Help] [Dependency Information]
Object Name: | ECE_MVSTO_LOCATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EC.ECE_MVSTO_LOCATIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view extracts line location information
for the outbound Movement Statistics (INTRASTAT) transaction.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILL_TO_CODE_INTERNAL | VARCHAR2 | (240) | Yes | Bill To Code (Internal) |
BILL_TO_CODE_EXTERNAL | VARCHAR2 | (40) | Bill To Code (Ext) | |
BILL_TO_NAME | VARCHAR2 | (360) | Yes | Bill To Customer Name |
BILL_TO_ADDRESS1 | VARCHAR2 | (240) | Yes | Bill To Address 1 |
BILL_TO_ADDRESS2 | VARCHAR2 | (240) | Bill To Address 2 | |
BILL_TO_ADDRESS3 | VARCHAR2 | (240) | Bill To Address 3 | |
BILL_TO_ADDRESS4 | VARCHAR2 | (240) | Bill To Address 4 | |
BILL_TO_CITY | VARCHAR2 | (60) | Bill To City | |
BILL_TO_POSTAL_CODE | VARCHAR2 | (60) | Bill To Postal Code | |
BILL_TO_COUNTRY | VARCHAR2 | (60) | Yes | Bill To Country (Internal) |
BILL_TO_STATE | VARCHAR2 | (60) | Bill To State (Internal) | |
BILL_TO_PROVINCE | VARCHAR2 | (60) | Bill To Province (Internal) | |
BILL_TO_COUNTY | VARCHAR2 | (60) | Bill To County | |
BILL_TO_ADDRESS_ID | NUMBER | (15) | Yes | Bill To Address ID |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Yes | Bill To Customer ID |
BILL_TO_SITE_USE_ID | NUMBER | (15) | Bill To Site Use ID | |
SHIP_TO_CODE_INTERNAL | VARCHAR2 | (240) | Yes | Ship To Code (Internal) |
SHIP_TO_CODE_EXTERNAL | VARCHAR2 | (40) | Ship To Code (Ext) | |
SHIP_TO_NAME | VARCHAR2 | (360) | Yes | Ship To Customer Name |
SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Yes | Ship To Address 1 |
SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Ship To Address 2 | |
SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Ship To Address 3 | |
SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Ship To Address 4 | |
SHIP_TO_CITY | VARCHAR2 | (60) | Ship To City | |
SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship To Postal Code | |
SHIP_TO_COUNTRY | VARCHAR2 | (60) | Yes | Ship To Country (Internal) |
SHIP_TO_STATE | VARCHAR2 | (60) | Ship To State (Internal) | |
SHIP_TO_PROVINCE | VARCHAR2 | (60) | Ship To Province (Internal) | |
SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship To County | |
SHIP_TO_ADDRESS_ID | NUMBER | (15) | Yes | Ship To Address ID |
SHIP_TO_CUSTOMER_ID | NUMBER | (15) | Yes | Ship To Customer ID |
SHIP_TO_SITE_USE_ID | NUMBER | (15) | Yes | Ship To Site Use ID |
VENDOR_CODE_INT | NUMBER | Yes | Vendor Code (Internal) | |
VENDOR_CODE_EXT | VARCHAR2 | (60) | Vendor Code (Ext) | |
VENDOR_CUSTOMER_NAME | VARCHAR2 | (240) | Vendor Customer Name | |
VENDOR_ADDRESS1 | VARCHAR2 | (240) | Vendor Address 1 | |
VENDOR_ADDRESS2 | VARCHAR2 | (240) | Vendor Address 2 | |
VENDOR_ADDRESS3 | VARCHAR2 | (240) | Vendor Address 3 | |
VENDOR_ADDRESS4 | VARCHAR2 | (240) | Vendor Address 4 | |
VENDOR_CITY | VARCHAR2 | (60) | Vendor City | |
VENDOR_POSTAL_CODE | VARCHAR2 | (20) | Vendor Postal Code | |
VENDOR_COUNTRY_INT | VARCHAR2 | (25) | Vendor Country (Internal) | |
VENDOR_TO_POSTAL_CODE | VARCHAR2 | (20) | vendor to postal code | |
VENDOR_STATE_INT | VARCHAR2 | (60) | Vendor State (Internal) | |
VENDOR_PROVINCE_INT | VARCHAR2 | (60) | Vendor Province (Internal) | |
VENDOR_COUNTY | VARCHAR2 | (60) | Vendor County | |
TRANSACTION_HEADER_ID | VARCHAR2 | (0) | Transaction Header ID | |
TRANSACTION_LINE_ID | VARCHAR2 | (0) | Transaction Line ID |
Cut, paste (and edit) the following text to query this object:
SELECT BILL_TO_CODE_INTERNAL
, BILL_TO_CODE_EXTERNAL
, BILL_TO_NAME
, BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4
, BILL_TO_CITY
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY
, BILL_TO_STATE
, BILL_TO_PROVINCE
, BILL_TO_COUNTY
, BILL_TO_ADDRESS_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, SHIP_TO_CODE_INTERNAL
, SHIP_TO_CODE_EXTERNAL
, SHIP_TO_NAME
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, SHIP_TO_STATE
, SHIP_TO_PROVINCE
, SHIP_TO_COUNTY
, SHIP_TO_ADDRESS_ID
, SHIP_TO_CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, VENDOR_CODE_INT
, VENDOR_CODE_EXT
, VENDOR_CUSTOMER_NAME
, VENDOR_ADDRESS1
, VENDOR_ADDRESS2
, VENDOR_ADDRESS3
, VENDOR_ADDRESS4
, VENDOR_CITY
, VENDOR_POSTAL_CODE
, VENDOR_COUNTRY_INT
, VENDOR_TO_POSTAL_CODE
, VENDOR_STATE_INT
, VENDOR_PROVINCE_INT
, VENDOR_COUNTY
, TRANSACTION_HEADER_ID
, TRANSACTION_LINE_ID
FROM APPS.ECE_MVSTO_LOCATIONS_V;
APPS.ECE_MVSTO_LOCATIONS_V is not referenced by any database object
|
|
|