[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GASNO_SHIPMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GASNO_SHIPMENTS
|
| Subobject Name: | |
| Status: | VALID |
GML_GASNO_SHIPMENTS (OPM Advanced Ship Notice (866/DESADV)) contains shipping and associated trading partner data to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)).
All columns denoted with an "INT" represent Applications internal values. All columns with "EXT" represent the equivalent external values.
Each row in the GML_GASNO_SHIPMENTS is purged after the data is written to the data file.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MAP_ID | NUMBER | Map ID for processing document. | ||
| COMMUNICATION_METHOD | VARCHAR2 | (2) | Communication method for EDI transactions. Currently it is set to 'EC'. | |
| TEST_INDICATOR | VARCHAR2 | (1) | Indicating if the transaction is for testing. If it is set for testing, there will be no inventory transaction occured. | |
| DOCUMENT_ID | VARCHAR2 | (6) | Iindicating the transaction type. It is GASNO for OPM outbound advanced shipment notice. | |
| TP_HEADER_ID | NUMBER | Trading partner header id. | ||
| TP_DETAIL_ID | NUMBER | Trading partner detail id. | ||
| RUN_ID | NUMBER | Run id | ||
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | This code identifies the transaction as the original, change, replacement or other appropriate status for the given transaction. | |
| TP_DOCUMENT_CODE | VARCHAR2 | (32) | This is the prinary trasaction code. The code is the key document identified for the specific transaction. | |
| TP_CODE | VARCHAR2 | (35) | Trading partner code. | |
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | This is trading partner location code as defined by the trading partner for the given transaction. This is usually found in the ASC X12 N104 ID code or the EDIFACT NAD segment. | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Description for trading partner. | |
| TP_REFERENCE1 | VARCHAR2 | (240) | Trading partner reference code 1 as defined in the e-Commerce Gateway for the primary trading partner location for outbound transactions. | |
| TP_REFERENCE2 | VARCHAR2 | (240) | Trading partner reference code 2 as defined in the e-Commerce Gateway for the primary trading partner location for outbound transactions. | |
| TRANSACTION_DATE | DATE | Date and time that the transaction is created. | ||
| TP_HEADER_CATEGORY | VARCHAR2 | (150) | Attribute category for trading partner header. | |
| TP_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Attribute 1 for trading partner header. | |
| TP_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Attribute 2 for trading partner header. | |
| TP_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Attribute 3 for trading partner header. | |
| TP_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Attribute 4 for trading partner header. | |
| TP_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Attribute 5 for trading partner header. | |
| TP_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Attribute 6 for trading partner header. | |
| TP_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Attribute 7 for trading partner header. | |
| TP_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Attribute 8 for trading partner header. | |
| TP_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Attribute 9 for trading partner header. | |
| TP_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Attribute 10 for trading partner header. | |
| TP_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Attribute 11 for trading partner header. | |
| TP_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Attribute 12 for trading partner header. | |
| TP_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Attribute 13 for trading partner header. | |
| TP_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Attribute 14 for trading partner header. | |
| TP_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Attribute 15 for trading partner header. | |
| TP_DETAIL_CATEGORY | VARCHAR2 | (150) | Attribute category for trading partner detail. | |
| TP_DETAIL_ATTRIBUTE1 | VARCHAR2 | (150) | Attribute 1 for trading partner detail. | |
| TP_DETAIL_ATTRIBUTE2 | VARCHAR2 | (150) | Attribute 2 for trading partner detail. | |
| TP_DETAIL_ATTRIBUTE3 | VARCHAR2 | (150) | Attribute 3 for trading partner detail. | |
| TP_DETAIL_ATTRIBUTE4 | VARCHAR2 | (150) | Attribute 4 for trading partner detail. | |
| TP_DETAIL_ATTRIBUTE5 | VARCHAR2 | (150) | Attribute 5 for trading partner detail. | |
| BOL_ID | NUMBER | Surrogate key to uniquely identify the shipment. | ||
| BOL_NO | VARCHAR2 | (32) | Bill of lading number. | |
| ORGN_CODE | VARCHAR2 | (4) | Organization code to which the shipment belongs. | |
| BOL_COMMENT | VARCHAR2 | (70) | Comments for the bill of lading. | |
| WAYBILL_NO | VARCHAR2 | (32) | Waybill number. Unvalidated column. | |
| FRTBILL_MTHD_INT | VARCHAR2 | (4) | Internal code for freight bill method. | |
| FRTBILL_MTHD_EXT1 | VARCHAR2 | (30) | External code 1 for freight bill method. | |
| FRTBILL_MTHD_EXT2 | VARCHAR2 | (30) | External code 2 for freight bill method. | |
| FRTBILL_MTHD_EXT3 | VARCHAR2 | (30) | External code 3 for freight bill method. | |
| FRTBILL_MTHD_EXT4 | VARCHAR2 | (30) | External code 4 for freight bill method. | |
| FRTBILL_MTHD_EXT5 | VARCHAR2 | (30) | External code 5 for freight bill method. | |
| FRTBILL_DESC | VARCHAR2 | (40) | Description for freight bill method. | |
| EMBARKATION_PORT_INT | VARCHAR2 | (8) | Internal code to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_EXT1 | VARCHAR2 | (30) | External code 1 to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_EXT2 | VARCHAR2 | (30) | External code 2 to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_EXT3 | VARCHAR2 | (30) | External code 3 to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_EXT4 | VARCHAR2 | (30) | External code 4 to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_EXT5 | VARCHAR2 | (30) | External code 5 to identify the port of loading/port of discharge for shipments. | |
| EMBARKATION_PORT_DESC | VARCHAR2 | (70) | Description of the embarkation port code. | |
| DEBARKATION_PORT_INT | VARCHAR2 | (8) | Internal code to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_EXT1 | VARCHAR2 | (30) | External code 1 to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_EXT2 | VARCHAR2 | (30) | External code 2 to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_EXT3 | VARCHAR2 | (30) | External code 3 to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_EXT4 | VARCHAR2 | (30) | External code 4 to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_EXT5 | VARCHAR2 | (30) | External code 5 to define the port of entry/port shipment is unloaded. | |
| DEBARKATION_PORT_DESC | VARCHAR2 | (70) | Description of the debarkation port code. | |
| FOB_CODE_INT | VARCHAR2 | (4) | Internal free-on-board code. | |
| FOB_CODE_EXT1 | VARCHAR2 | (30) | External free-on-board code 1. | |
| FOB_CODE_EXT2 | VARCHAR2 | (30) | External free-on-board code 2. | |
| FOB_CODE_EXT3 | VARCHAR2 | (30) | External free-on-board code 3. | |
| FOB_CODE_EXT4 | VARCHAR2 | (30) | External free-on-board code 4. | |
| FOB_CODE_EXT5 | VARCHAR2 | (30) | External free-on-board code 5. | |
| FOB_NAME | VARCHAR2 | (40) | Name of free-on-board. | |
| SHIPPER_CODE_INT | VARCHAR2 | (4) | Internal unique identifier of carrier (shipper). | |
| SHIPPER_CODE_EXT1 | VARCHAR2 | (20) | External identifier 1 of carrier (shipper). | |
| SHIPPER_CODE_EXT2 | VARCHAR2 | (20) | External identifier 2 of carrier (shipper). | |
| SHIPPER_CODE_EXT3 | VARCHAR2 | (20) | External identifier 3 of carrier (shipper). | |
| SHIPPER_CODE_EXT4 | VARCHAR2 | (20) | External identifier 4 of carrier (shipper). | |
| SHIPPER_CODE_EXT5 | VARCHAR2 | (20) | External identifier 5 of carrier (shipper). | |
| SHIPPER_NAME | VARCHAR2 | (40) | Name of carrier (shipper). | |
| SHIP_MTHD_INT | VARCHAR2 | (4) | Internal unique identifier of shipping method. | |
| SHIP_MTHD_EXT1 | VARCHAR2 | (20) | External identifier 1 of shipping method. | |
| SHIP_MTHD_EXT2 | VARCHAR2 | (20) | External identifier 2 of shipping method. | |
| SHIP_MTHD_EXT3 | VARCHAR2 | (20) | External identifier 3 of shipping method. | |
| SHIP_MTHD_EXT4 | VARCHAR2 | (20) | External identifier 4 of shipping method. | |
| SHIP_MTHD_EXT5 | VARCHAR2 | (20) | External identifier 5 of shipping method. | |
| METH_DESC1 | VARCHAR2 | (40) | Description one of shipping method. | |
| NET_WT | NUMBER | Weight of packaging materials for item in shipwt_um. | ||
| TARE_WT | NUMBER | Weight of packaging materials for item in shipwt_um unit of measure. Defaults from packaged item, if entered. Can be entered or overridden by user. | ||
| PALLET_WT | NUMBER | Pallet weight for item being shipped in shipwt_um. Defaults from packaged item, if entered. Otherwise entered/overridden by user. | ||
| BOLSHIP_WT | NUMBER | User-modifiable total shipping weight. Defaults to system-calculated ship weight. | ||
| BOL_UM_INT | VARCHAR2 | (4) | Internal bol unit of measure to bol shipping weight. Defaults to system variable shipping weight uom. | |
| BOL_UM_EXT1 | VARCHAR2 | (20) | External bol unit of measure 1. | |
| BOL_UM_EXT2 | VARCHAR2 | (20) | External bol unit of measure 2. | |
| BOL_UM_EXT3 | VARCHAR2 | (20) | External bol unit of measure 3. | |
| BOL_UM_EXT4 | VARCHAR2 | (20) | External bol unit of measure 4. | |
| BOL_UM_EXT5 | VARCHAR2 | (20) | External bol unit of measure 5. | |
| SHIP_VOLUME | NUMBER | Volume computed by systerm using order_qty1 and converting it to shipvolume_um or by using defaults established for the packaged item. This value can not be updated by the user in shipping or order entry. | ||
| SHIPVOLUME_UM_INT | VARCHAR2 | (4) | Internal unit of measure for shipping volume. Can not be changed by user. | |
| SHIPVOLUME_UM_EXT1 | VARCHAR2 | (20) | External unit of measure 1 for shipping volume. | |
| SHIPVOLUME_UM_EXT2 | VARCHAR2 | (20) | External unit of measure 2 for shipping volume. | |
| SHIPVOLUME_UM_EXT3 | VARCHAR2 | (20) | External unit of measure 3 for shipping volume. | |
| SHIPVOLUME_UM_EXT4 | VARCHAR2 | (20) | External unit of measure 4 for shipping volume. | |
| SHIPVOLUME_UM_EXT5 | VARCHAR2 | (20) | External unit of measure 5 for shipping volume. | |
| SHIPTO_CUST_ID | NUMBER | Surrogate key for shipping customer. | ||
| SHIPTO_CODE_INT | VARCHAR2 | (240) | Code from ra_addresses_all for column orig_system_reference. | |
| SHIPTO_CODE_EXT1 | VARCHAR2 | (80) | External code 1 for ship-to customer. | |
| SHIPTO_CODE_EXT2 | VARCHAR2 | (80) | External code 2 for ship-to customer. | |
| SHIPTO_CODE_EXT3 | VARCHAR2 | (80) | External code 3 for ship-to customer. | |
| SHIPTO_CODE_EXT4 | VARCHAR2 | (80) | External code 4 for ship-to customer. | |
| SHIPTO_CODE_EXT5 | VARCHAR2 | (80) | External code 5 for ship-to customer. | |
| SHIPTO_CUST_NAME | VARCHAR2 | (80) | Name of ship-to customer. | |
| SHIPTO_ADDR1 | VARCHAR2 | (70) | Address line 1 for ship-to customer. | |
| SHIPTO_ADDR2 | VARCHAR2 | (70) | Address line 2 for ship-to customer. | |
| SHIPTO_ADDR3 | VARCHAR2 | (70) | Address line 3 for ship-to customer. | |
| SHIPTO_ADDR4 | VARCHAR2 | (70) | Address line 4 for ship-to customer. | |
| SHIPTO_POSTAL_CODE | VARCHAR2 | (60) | Postal code of ship-to customer. | |
| SHIPTO_COUNTRY_CODE_INT | VARCHAR2 | (60) | Internal country code for ship-to customer. | |
| SHIPTO_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | External country code 1 for ship-to customer. | |
| SHIPTO_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | External country code 2 for ship-to customer. | |
| SHIPTO_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | External country code 3 for ship-to customer. | |
| SHIPTO_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | External country code 4 for ship-to customer. | |
| SHIPTO_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | External country code 5 for ship-to customer. | |
| SHIPTO_STATE_CODE_INT | VARCHAR2 | (60) | Internal state code for ship-to customer. | |
| SHIPTO_STATE_CODE_EXT1 | VARCHAR2 | (80) | External state code 1 for ship-to customer. | |
| SHIPTO_STATE_CODE_EXT2 | VARCHAR2 | (80) | External state code 2 for ship-to customer. | |
| SHIPTO_STATE_CODE_EXT3 | VARCHAR2 | (80) | External state code 3 for ship-to customer. | |
| SHIPTO_STATE_CODE_EXT4 | VARCHAR2 | (80) | External state code 4 for ship-to customer. | |
| SHIPTO_STATE_CODE_EXT5 | VARCHAR2 | (80) | External state code 5 for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_INT | VARCHAR2 | (60) | Internal province code for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | External province code 1 for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | External province code 2 for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | External province code 3 for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | External province code 4 for ship-to customer. | |
| SHIPTO_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | External province code 5 for ship-to customer. | |
| SHIPTO_COUNTY | VARCHAR2 | (60) | County code for ship-to customer. | |
| SHIPTO_LAST_NAME | VARCHAR2 | (50) | Last name of ship-to customer contact. | |
| SHIPTO_FIRST_NAME | VARCHAR2 | (40) | First name of ship-to customer contact. | |
| SHIPTO_JOB_TITLE | VARCHAR2 | (50) | Job title of ship-to customer contact. | |
| SHIPTO_AREA_CODE | VARCHAR2 | (10) | Area code of ship-to customer contact. | |
| SHIPTO_TELEPHONE | VARCHAR2 | (60) | Phone number of ship-to customer contact. | |
| BOLADDR_ID | NUMBER | Pointer to address. | ||
| BOLADDR_ADDR1 | VARCHAR2 | (70) | BOL address line 1. | |
| BOLADDR_ADDR2 | VARCHAR2 | (70) | BOL address line 2. | |
| BOLADDR_ADDR3 | VARCHAR2 | (70) | BOL address line 3. | |
| BOLADDR_ADDR4 | VARCHAR2 | (70) | BOL address line 4. | |
| BOLADDR_POSTAL_CODE | VARCHAR2 | (60) | BOL address postal code. | |
| BOLADDR_COUNTRY_CODE_INT | VARCHAR2 | (60) | Internal BOL address country code. | |
| BOLADDR_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | External BOL address country code 1. | |
| BOLADDR_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | External BOL address country code 2. | |
| BOLADDR_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | External BOL address country code 3. | |
| BOLADDR_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | External BOL address country code 4. | |
| BOLADDR_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | External BOL address country code 5. | |
| BOLADDR_STATE_CODE_INT | VARCHAR2 | (60) | Internal BOL address state code. | |
| BOLADDR_STATE_CODE_EXT1 | VARCHAR2 | (80) | External BOL address state code 1. | |
| BOLADDR_STATE_CODE_EXT2 | VARCHAR2 | (80) | External BOL address state code 2. | |
| BOLADDR_STATE_CODE_EXT3 | VARCHAR2 | (80) | External BOL address state code 3. | |
| BOLADDR_STATE_CODE_EXT4 | VARCHAR2 | (80) | External BOL address state code 4. | |
| BOLADDR_STATE_CODE_EXT5 | VARCHAR2 | (80) | External BOL address state code 5. | |
| BOLADDR_PROVINCE_CODE_INT | VARCHAR2 | (60) | Internal BOL address province code. | |
| BOLADDR_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | External BOL address province code 1. | |
| BOLADDR_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | External BOL address province code 2. | |
| BOLADDR_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | External BOL address province code 3. | |
| BOLADDR_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | External BOL address province code 4. | |
| BOLADDR_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | External BOL address province code 5. | |
| BOLADDR_COUNTY | VARCHAR2 | (60) | BOL address county code. | |
| EDI_TRANS_CNT | NUMBER | Flag to monitor the number of shipments that generated by GASNO transaction. | ||
| DROPOFF_TIME | DATE | For demurrage determination. Date and time of dropoff. | ||
| PICKUP_TIME | DATE | For demurrage determination. Date and time of pickup. | ||
| PRINT_COUNT | NUMBER | Number of time a bol is printed. | ||
| PRINT_DATE | DATE | Date and time that bill of lading was printed. | ||
| DEMURRAGE_AMT | NUMBER | Amount of demurrage penalty. Demurrage is the amount charged for detainment of a shipment. | ||
| DEMURRAGE_CURRENCY_CODE_INT | VARCHAR2 | (4) | Internal currency code defined for demurrage charge. | |
| DEMURRAGE_CURRENCY_EXT1 | VARCHAR2 | (80) | External currency code 1 for demurrage charge. | |
| DEMURRAGE_CURRENCY_EXT2 | VARCHAR2 | (80) | External currency code 2 for demurrage charge. | |
| DEMURRAGE_CURRENCY_EXT3 | VARCHAR2 | (80) | External currency code 3 for demurrage charge. | |
| DEMURRAGE_CURRENCY_EXT4 | VARCHAR2 | (80) | External currency code 4 for demurrage charge. | |
| DEMURRAGE_CURRENCY_EXT5 | VARCHAR2 | (80) | External currency code 5 for demurrage charge. | |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links this table to its associated extension table GML_GASNO_SHIPMENTS_X. | ||
| FROM_WHSE | VARCHAR2 | (4) | Shipping warehouse. | |
| FROM_WHSE_NAME | VARCHAR2 | (50) | Name of shipping warehouse. | |
| FROM_WHSE_CONTACT | VARCHAR2 | (50) | Contact of shipping warehouse. | |
| FROM_WHSE_PHONE | VARCHAR2 | (60) | Contact phone number of shipping warehouse. | |
| FROM_WHSE_ADDR1 | VARCHAR2 | (70) | Address line 1 of shipping warehouse. | |
| FROM_WHSE_ADDR2 | VARCHAR2 | (70) | Address line 2 of shipping warehouse. | |
| FROM_WHSE_ADDR3 | VARCHAR2 | (70) | Address line 3 of shipping warehouse. | |
| FROM_WHSE_ADDR4 | VARCHAR2 | (70) | Address line 4 of shipping warehouse. | |
| FROM_WHSE_POSTAL_CODE | VARCHAR2 | (60) | Postal code of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_INT | VARCHAR2 | (60) | Internal country code of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | External country code 1 of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | External country code 2 of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | External country code 3 of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | External country code 4 of shipping warehouse address. | |
| FROM_WHSE_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | External country code 5 of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_INT | VARCHAR2 | (60) | Internal state code of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_EXT1 | VARCHAR2 | (80) | External state code 1 of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_EXT2 | VARCHAR2 | (80) | External state code 2 of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_EXT3 | VARCHAR2 | (80) | External state code 3 of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_EXT4 | VARCHAR2 | (80) | External state code 4 of shipping warehouse address. | |
| FROM_WHSE_STATE_CODE_EXT5 | VARCHAR2 | (80) | External state code 5 of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_INT | VARCHAR2 | (60) | Internal province code of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | External province code 1 of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | External province code 2 of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | External province code 3 of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | External province code 4 of shipping warehouse address. | |
| FROM_WHSE_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | External province code 5 of shipping warehouse address. | |
| FROM_WHSE_COUNTY | VARCHAR2 | (60) | County code of shipping warehouse address. | |
| CREATION_DATE | DATE | Standard who column. | ||
| CREATED_BY | NUMBER | (15) | Standard who column. | |
| LAST_UPDATE_DATE | DATE | Standard who column. | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column. | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
| REQUEST_ID | NUMBER | (15) | Standard who column. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column. | |
| PROGRAM_ID | NUMBER | (15) | Standard who column. | |
| PROGRAM_UPDATE_DATE | NUMBER | (15) | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT MAP_ID
, COMMUNICATION_METHOD
, TEST_INDICATOR
, DOCUMENT_ID
, TP_HEADER_ID
, TP_DETAIL_ID
, RUN_ID
, DOCUMENT_PURPOSE_CODE
, TP_DOCUMENT_CODE
, TP_CODE
, TP_LOCATION_CODE_EXT
, TP_DESCRIPTION
, TP_REFERENCE1
, TP_REFERENCE2
, TRANSACTION_DATE
, TP_HEADER_CATEGORY
, TP_HEADER_ATTRIBUTE1
, TP_HEADER_ATTRIBUTE2
, TP_HEADER_ATTRIBUTE3
, TP_HEADER_ATTRIBUTE4
, TP_HEADER_ATTRIBUTE5
, TP_HEADER_ATTRIBUTE6
, TP_HEADER_ATTRIBUTE7
, TP_HEADER_ATTRIBUTE8
, TP_HEADER_ATTRIBUTE9
, TP_HEADER_ATTRIBUTE10
, TP_HEADER_ATTRIBUTE11
, TP_HEADER_ATTRIBUTE12
, TP_HEADER_ATTRIBUTE13
, TP_HEADER_ATTRIBUTE14
, TP_HEADER_ATTRIBUTE15
, TP_DETAIL_CATEGORY
, TP_DETAIL_ATTRIBUTE1
, TP_DETAIL_ATTRIBUTE2
, TP_DETAIL_ATTRIBUTE3
, TP_DETAIL_ATTRIBUTE4
, TP_DETAIL_ATTRIBUTE5
, BOL_ID
, BOL_NO
, ORGN_CODE
, BOL_COMMENT
, WAYBILL_NO
, FRTBILL_MTHD_INT
, FRTBILL_MTHD_EXT1
, FRTBILL_MTHD_EXT2
, FRTBILL_MTHD_EXT3
, FRTBILL_MTHD_EXT4
, FRTBILL_MTHD_EXT5
, FRTBILL_DESC
, EMBARKATION_PORT_INT
, EMBARKATION_PORT_EXT1
, EMBARKATION_PORT_EXT2
, EMBARKATION_PORT_EXT3
, EMBARKATION_PORT_EXT4
, EMBARKATION_PORT_EXT5
, EMBARKATION_PORT_DESC
, DEBARKATION_PORT_INT
, DEBARKATION_PORT_EXT1
, DEBARKATION_PORT_EXT2
, DEBARKATION_PORT_EXT3
, DEBARKATION_PORT_EXT4
, DEBARKATION_PORT_EXT5
, DEBARKATION_PORT_DESC
, FOB_CODE_INT
, FOB_CODE_EXT1
, FOB_CODE_EXT2
, FOB_CODE_EXT3
, FOB_CODE_EXT4
, FOB_CODE_EXT5
, FOB_NAME
, SHIPPER_CODE_INT
, SHIPPER_CODE_EXT1
, SHIPPER_CODE_EXT2
, SHIPPER_CODE_EXT3
, SHIPPER_CODE_EXT4
, SHIPPER_CODE_EXT5
, SHIPPER_NAME
, SHIP_MTHD_INT
, SHIP_MTHD_EXT1
, SHIP_MTHD_EXT2
, SHIP_MTHD_EXT3
, SHIP_MTHD_EXT4
, SHIP_MTHD_EXT5
, METH_DESC1
, NET_WT
, TARE_WT
, PALLET_WT
, BOLSHIP_WT
, BOL_UM_INT
, BOL_UM_EXT1
, BOL_UM_EXT2
, BOL_UM_EXT3
, BOL_UM_EXT4
, BOL_UM_EXT5
, SHIP_VOLUME
, SHIPVOLUME_UM_INT
, SHIPVOLUME_UM_EXT1
, SHIPVOLUME_UM_EXT2
, SHIPVOLUME_UM_EXT3
, SHIPVOLUME_UM_EXT4
, SHIPVOLUME_UM_EXT5
, SHIPTO_CUST_ID
, SHIPTO_CODE_INT
, SHIPTO_CODE_EXT1
, SHIPTO_CODE_EXT2
, SHIPTO_CODE_EXT3
, SHIPTO_CODE_EXT4
, SHIPTO_CODE_EXT5
, SHIPTO_CUST_NAME
, SHIPTO_ADDR1
, SHIPTO_ADDR2
, SHIPTO_ADDR3
, SHIPTO_ADDR4
, SHIPTO_POSTAL_CODE
, SHIPTO_COUNTRY_CODE_INT
, SHIPTO_COUNTRY_CODE_EXT1
, SHIPTO_COUNTRY_CODE_EXT2
, SHIPTO_COUNTRY_CODE_EXT3
, SHIPTO_COUNTRY_CODE_EXT4
, SHIPTO_COUNTRY_CODE_EXT5
, SHIPTO_STATE_CODE_INT
, SHIPTO_STATE_CODE_EXT1
, SHIPTO_STATE_CODE_EXT2
, SHIPTO_STATE_CODE_EXT3
, SHIPTO_STATE_CODE_EXT4
, SHIPTO_STATE_CODE_EXT5
, SHIPTO_PROVINCE_CODE_INT
, SHIPTO_PROVINCE_CODE_EXT1
, SHIPTO_PROVINCE_CODE_EXT2
, SHIPTO_PROVINCE_CODE_EXT3
, SHIPTO_PROVINCE_CODE_EXT4
, SHIPTO_PROVINCE_CODE_EXT5
, SHIPTO_COUNTY
, SHIPTO_LAST_NAME
, SHIPTO_FIRST_NAME
, SHIPTO_JOB_TITLE
, SHIPTO_AREA_CODE
, SHIPTO_TELEPHONE
, BOLADDR_ID
, BOLADDR_ADDR1
, BOLADDR_ADDR2
, BOLADDR_ADDR3
, BOLADDR_ADDR4
, BOLADDR_POSTAL_CODE
, BOLADDR_COUNTRY_CODE_INT
, BOLADDR_COUNTRY_CODE_EXT1
, BOLADDR_COUNTRY_CODE_EXT2
, BOLADDR_COUNTRY_CODE_EXT3
, BOLADDR_COUNTRY_CODE_EXT4
, BOLADDR_COUNTRY_CODE_EXT5
, BOLADDR_STATE_CODE_INT
, BOLADDR_STATE_CODE_EXT1
, BOLADDR_STATE_CODE_EXT2
, BOLADDR_STATE_CODE_EXT3
, BOLADDR_STATE_CODE_EXT4
, BOLADDR_STATE_CODE_EXT5
, BOLADDR_PROVINCE_CODE_INT
, BOLADDR_PROVINCE_CODE_EXT1
, BOLADDR_PROVINCE_CODE_EXT2
, BOLADDR_PROVINCE_CODE_EXT3
, BOLADDR_PROVINCE_CODE_EXT4
, BOLADDR_PROVINCE_CODE_EXT5
, BOLADDR_COUNTY
, EDI_TRANS_CNT
, DROPOFF_TIME
, PICKUP_TIME
, PRINT_COUNT
, PRINT_DATE
, DEMURRAGE_AMT
, DEMURRAGE_CURRENCY_CODE_INT
, DEMURRAGE_CURRENCY_EXT1
, DEMURRAGE_CURRENCY_EXT2
, DEMURRAGE_CURRENCY_EXT3
, DEMURRAGE_CURRENCY_EXT4
, DEMURRAGE_CURRENCY_EXT5
, TRANSACTION_RECORD_ID
, FROM_WHSE
, FROM_WHSE_NAME
, FROM_WHSE_CONTACT
, FROM_WHSE_PHONE
, FROM_WHSE_ADDR1
, FROM_WHSE_ADDR2
, FROM_WHSE_ADDR3
, FROM_WHSE_ADDR4
, FROM_WHSE_POSTAL_CODE
, FROM_WHSE_COUNTRY_CODE_INT
, FROM_WHSE_COUNTRY_CODE_EXT1
, FROM_WHSE_COUNTRY_CODE_EXT2
, FROM_WHSE_COUNTRY_CODE_EXT3
, FROM_WHSE_COUNTRY_CODE_EXT4
, FROM_WHSE_COUNTRY_CODE_EXT5
, FROM_WHSE_STATE_CODE_INT
, FROM_WHSE_STATE_CODE_EXT1
, FROM_WHSE_STATE_CODE_EXT2
, FROM_WHSE_STATE_CODE_EXT3
, FROM_WHSE_STATE_CODE_EXT4
, FROM_WHSE_STATE_CODE_EXT5
, FROM_WHSE_PROVINCE_CODE_INT
, FROM_WHSE_PROVINCE_CODE_EXT1
, FROM_WHSE_PROVINCE_CODE_EXT2
, FROM_WHSE_PROVINCE_CODE_EXT3
, FROM_WHSE_PROVINCE_CODE_EXT4
, FROM_WHSE_PROVINCE_CODE_EXT5
, FROM_WHSE_COUNTY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM GML.GML_GASNO_SHIPMENTS;
GML.GML_GASNO_SHIPMENTS does not reference any database object
GML.GML_GASNO_SHIPMENTS is referenced by following:
APPS
GML_GASNO_SHIPMENTS
|
|
|
|