[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GASNO_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GASNO_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
GML_GASNO_DETAILS contains detail line data of the order that the shipment generated from to support the edi outbound transaction GASNO (OPM Outbound Advanced Ship Notice (856/DESADV)). The information in this table is based primarily on data stored in the OP_ORDR_DTL table of OPM Order Fulfillment.
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_DETAILS 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 |
|---|---|---|---|---|
| RUN_ID | NUMBER | Run Id | ||
| ORDER_ID | NUMBER | Reference to order which contains this line | ||
| BOL_ID | NUMBER | Reference to shipment which contains this line | ||
| LINE_ID | NUMBER | Unique identifies each row | ||
| LINE_STATUS | NUMBER | Indicates status of line | ||
| SHIP_STATUS | NUMBER | Indicates shipment status of order line. Valid values are: 0 - line has not been shipped; 10 - shipment has been picked; 20 - shipment has been released (shipped). | ||
| SO_LINE_NO | NUMBER | Line number assigned by systerm for this line | ||
| TRANS_CNT | NUMBER | Transaction count | ||
| ACTUAL_SHIPDATE | DATE | Date is required in shipping before a shipment is released. | ||
| REQUESTED_SHIPDATE | DATE | Requested shipping date. Defaults from header. | ||
| PROMISED_SHIPDATE | DATE | Promised ship date. Defaults from header. | ||
| SCHED_SHIPDATE | DATE | Scheduled ship date. Defaults from header. | ||
| ACTUAL_DLVDATE | DATE | Actual delivery date to customer | ||
| REQUIRED_DLVDATE | DATE | Required delivery date. Defaults from header. It is used to calculate the sched_shipdate. | ||
| HOLD_EXPIRATION | DATE | Date when hold indicated by hold reason code will expire. Defaults to system max date. | ||
| EXPORT_DATE | DATE | Date when the shipment line was exported to oracle financials a/r system for invoicing. Defaults to system minimum date and is updated to the interface date by the oracle financials interface program. | ||
| LINE_COMMENT | VARCHAR2 | (80) | Comment for line | |
| SO_DETAIL_CATEGORY | VARCHAR2 | (30) | Sales order detail attribute category | |
| SO_DETAIL_ATTRIBUTE1 | VARCHAR2 | (240) | Sales order detail attribute 1 | |
| SO_DETAIL_ATTRIBUTE2 | VARCHAR2 | (240) | Sales order detail attribute 2 | |
| SO_DETAIL_ATTRIBUTE3 | VARCHAR2 | (240) | Sales order detail attribute 3 | |
| SO_DETAIL_ATTRIBUTE4 | VARCHAR2 | (240) | Sales order detail attribute 4 | |
| SO_DETAIL_ATTRIBUTE5 | VARCHAR2 | (240) | Sales order detail attribute 5 | |
| SO_DETAIL_ATTRIBUTE6 | VARCHAR2 | (240) | Sales order detail attribute 6 | |
| SO_DETAIL_ATTRIBUTE7 | VARCHAR2 | (240) | Sales order detail attribute 7 | |
| SO_DETAIL_ATTRIBUTE8 | VARCHAR2 | (240) | Sales order detail attribute 8 | |
| SO_DETAIL_ATTRIBUTE9 | VARCHAR2 | (240) | Sales order detail attribute 9 | |
| SO_DETAIL_ATTRIBUTE10 | VARCHAR2 | (240) | Sales order detail attribute 10 | |
| SO_DETAIL_ATTRIBUTE11 | VARCHAR2 | (240) | Sales order detail attribute 11 | |
| SO_DETAIL_ATTRIBUTE12 | VARCHAR2 | (240) | Sales order detail attribute 12 | |
| SO_DETAIL_ATTRIBUTE13 | VARCHAR2 | (240) | Sales order detail attribute 13 | |
| SO_DETAIL_ATTRIBUTE14 | VARCHAR2 | (240) | Sales order detail attribute 14 | |
| SO_DETAIL_ATTRIBUTE15 | VARCHAR2 | (240) | Sales order detail attribute 15 | |
| SO_DETAIL_ATTRIBUTE16 | VARCHAR2 | (240) | Sales order detail attribute 16 | |
| SO_DETAIL_ATTRIBUTE17 | VARCHAR2 | (240) | Sales order detail attribute 17 | |
| SO_DETAIL_ATTRIBUTE18 | VARCHAR2 | (240) | Sales order detail attribute 18 | |
| SO_DETAIL_ATTRIBUTE19 | VARCHAR2 | (240) | Sales order detail attribute 19 | |
| SO_DETAIL_ATTRIBUTE20 | VARCHAR2 | (240) | Sales order detail attribute 20 | |
| SO_DETAIL_ATTRIBUTE21 | VARCHAR2 | (240) | Sales order detail attribute 21 | |
| SO_DETAIL_ATTRIBUTE22 | VARCHAR2 | (240) | Sales order detail attribute 22 | |
| SO_DETAIL_ATTRIBUTE23 | VARCHAR2 | (240) | Sales order detail attribute 23 | |
| SO_DETAIL_ATTRIBUTE24 | VARCHAR2 | (240) | Sales order detail attribute 24 | |
| SO_DETAIL_ATTRIBUTE25 | VARCHAR2 | (240) | Sales order detail attribute 25 | |
| SO_DETAIL_ATTRIBUTE26 | VARCHAR2 | (240) | Sales order detail attribute 26 | |
| SO_DETAIL_ATTRIBUTE27 | VARCHAR2 | (240) | Sales order detail attribute 27 | |
| SO_DETAIL_ATTRIBUTE28 | VARCHAR2 | (240) | Sales order detail attribute 28 | |
| SO_DETAIL_ATTRIBUTE29 | VARCHAR2 | (240) | Sales order detail attribute 29 | |
| SO_DETAIL_ATTRIBUTE30 | VARCHAR2 | (240) | Sales order detail attribute 30 | |
| SHIP_METHOD_INT | VARCHAR2 | (4) | Internal ship method code. Defaults from header but can be overridden. | |
| SHIP_METHOD_EXT1 | VARCHAR2 | (20) | External ship method code 1. | |
| SHIP_METHOD_EXT2 | VARCHAR2 | (20) | External ship method code 2 | |
| SHIP_METHOD_EXT3 | VARCHAR2 | (20) | External ship method code 3 | |
| SHIP_METHOD_EXT4 | VARCHAR2 | (20) | External ship method code 4 | |
| SHIP_METHOD_EXT5 | VARCHAR2 | (20) | External ship method code 5 | |
| BASE_CURRENCY_INT | VARCHAR2 | (4) | Internally defined currency of organization identified with order. Defaults from gl_plcy_mst and can not be modified by user. | |
| BASE_CURRENCY_EXT1 | VARCHAR2 | (20) | Externally defined base currency 1 | |
| BASE_CURRENCY_EXT2 | VARCHAR2 | (20) | Externally defined base currency 2 | |
| BASE_CURRENCY_EXT3 | VARCHAR2 | (20) | Externally defined base currency 3 | |
| BASE_CURRENCY_EXT4 | VARCHAR2 | (20) | Externally defined base currency 4 | |
| BASE_CURRENCY_EXT5 | VARCHAR2 | (20) | Externally defined base currency 5 | |
| BILLING_CURRENCY_INT | VARCHAR2 | (4) | Internal currency that customer will be billed and currency that order is denominated. Defaults from header. | |
| BILLING_CURRENCY_EXT1 | VARCHAR2 | (20) | External billing currency 1 | |
| BILLING_CURRENCY_EXT2 | VARCHAR2 | (20) | External billing currency 2 | |
| BILLING_CURRENCY_EXT3 | VARCHAR2 | (20) | External billing currency 3 | |
| BILLING_CURRENCY_EXT4 | VARCHAR2 | (20) | External billing currency 4 | |
| BILLING_CURRENCY_EXT5 | VARCHAR2 | (20) | External billing currency 5 | |
| HOLDREAS_CODE_INT | VARCHAR2 | (4) | Internal code to uniquely identify a hold reason. | |
| HOLDREAS_CODE_EXT1 | VARCHAR2 | (20) | External hold reason code 1 | |
| HOLDREAS_CODE_EXT2 | VARCHAR2 | (20) | External hold reason code 2 | |
| HOLDREAS_CODE_EXT3 | VARCHAR2 | (20) | External hold reason code 3 | |
| HOLDREAS_CODE_EXT4 | VARCHAR2 | (20) | External hold reason code 4 | |
| HOLDREAS_CODE_EXT5 | VARCHAR2 | (20) | External hold reason code 5 | |
| EXCHANGE_RATE | NUMBER | Exchange rate between billing_currency and base_currency. It is retrived from gl_xchg_rte. | ||
| BILLTO_CUST_ID | NUMBER | Customer to be invoiced. | ||
| BILLTO_CODE_INT | VARCHAR2 | (240) | Internally defined bill-to customer reference from column orig_system_reference in table ra_addresses_all | |
| BILLTO_CODE_EXT1 | VARCHAR2 | (80) | External bill-to customer code 1 | |
| BILLTO_CODE_EXT2 | VARCHAR2 | (80) | External bill-to customer code 2 | |
| BILLTO_CODE_EXT3 | VARCHAR2 | (80) | External bill-to customer code 3 | |
| BILLTO_CODE_EXT4 | VARCHAR2 | (80) | External bill-to customer code 4 | |
| BILLTO_CODE_EXT5 | VARCHAR2 | (80) | External bill-to customer code 5 | |
| BILLTO_CUST_NAME | VARCHAR2 | (80) | Name of customer to be invoiced. | |
| BILLTO_ADDR1 | VARCHAR2 | (70) | Address line 1 for bill-to customer | |
| BILLTO_ADDR2 | VARCHAR2 | (70) | Address line 2 for bill-to customer | |
| BILLTO_ADDR3 | VARCHAR2 | (70) | Address line 3 for bill-to customer | |
| BILLTO_ADDR4 | VARCHAR2 | (70) | Address line 4 for bill-to customer | |
| BILLTO_POSTAL_CODE | VARCHAR2 | (60) | Postal code for bill-to customer | |
| BILLTO_COUNTRY_CODE_INT | VARCHAR2 | (60) | Internal country code for bill-to customer | |
| BILLTO_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | External country code 1 for bill-to customer | |
| BILLTO_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | External country code 2 for bill-to customer | |
| BILLTO_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | External country code 3 for bill-to customer | |
| BILLTO_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | External country code 4 for bill-to customer | |
| BILLTO_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | External country code 5 for bill-to customer | |
| BILLTO_STATE_CODE_INT | VARCHAR2 | (60) | Internal state code for bill-to customer | |
| BILLTO_STATE_CODE_EXT1 | VARCHAR2 | (80) | External state code 1 for bill-to customer | |
| BILLTO_STATE_CODE_EXT2 | VARCHAR2 | (80) | External state code 2 for bill-to customer | |
| BILLTO_STATE_CODE_EXT3 | VARCHAR2 | (80) | External state code 3 for bill-to customer | |
| BILLTO_STATE_CODE_EXT4 | VARCHAR2 | (80) | External state code 4 for bill-to customer | |
| BILLTO_STATE_CODE_EXT5 | VARCHAR2 | (80) | External state code 5 for bill-to customer | |
| BILLTO_PROVINCE_CODE_INT | VARCHAR2 | (60) | Internal province code for bill-to customer | |
| BILLTO_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | External province code 1 for bill-to customer | |
| BILLTO_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | External province code 2 for bill-to customer | |
| BILLTO_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | External province code 3 for bill-to customer | |
| BILLTO_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | External province code 4 for bill-to customer | |
| BILLTO_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | External province code 5 for bill-to customer | |
| BILLTO_COUNTY | VARCHAR2 | (60) | County code for bill-to customer | |
| BILLTO_LAST_NAME | VARCHAR2 | (50) | Bill to customer contact last name | |
| BILLTO_FIRST_NAME | VARCHAR2 | (40) | Bill to customer contact firstt name | |
| BILLTO_JOB_TITLE | VARCHAR2 | (50) | Bill to customer contact job title | |
| BILLTO_AREA_CODE | VARCHAR2 | (10) | Bill to customer contact area code | |
| BILLTO_TELEPHONE | VARCHAR2 | (60) | Bill to customer contact telephone | |
| NET_WT | NUMBER | Weight of item in shipwt_um unit of measure not including defaults from header | ||
| TARE_WT | NUMBER | Weight of packaging materials for item in shipwt_um unit of measure. Defaults from packaged item, if entered. | ||
| PALLET_WT | NUMBER | Pallet weight for item being shipped in shipwt_um. Defauts from packaged item, if entered. Otherwise entered/overridden by user. | ||
| FRTBILL_WT | NUMBER | Freight bill weight equals the net_wt+tare_wt+pallet_wt in shipwt_um and can be modified by user in shipping. Weight for freight billing purposes. | ||
| SHIPWT_UM_INT | VARCHAR2 | (4) | Internal ship weight unit of measure | |
| SHIPWT_UM_EXT1 | VARCHAR2 | (20) | External ship weight unit of measure 1 | |
| SHIPWT_UM_EXT2 | VARCHAR2 | (20) | External ship weight unit of measure 2 | |
| SHIPWT_UM_EXT3 | VARCHAR2 | (20) | External ship weight unit of measure 3 | |
| SHIPWT_UM_EXT4 | VARCHAR2 | (20) | External ship weight unit of measure 4 | |
| SHIPWT_UM_EXT5 | VARCHAR2 | (20) | External ship weight unit of measure 5 | |
| SHIP_VOLUME | NUMBER | Volume computed by system 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 sales order. | ||
| SHIPVOLUME_UM_INT | VARCHAR2 | (4) | Internal ship volume unit of measure | |
| SHIPVOLUME_UM_EXT1 | VARCHAR2 | (20) | External ship volume unit of measure 1 | |
| SHIPVOLUME_UM_EXT2 | VARCHAR2 | (20) | External ship volume unit of measure 2 | |
| SHIPVOLUME_UM_EXT3 | VARCHAR2 | (20) | External ship volume unit of measure 3 | |
| SHIPVOLUME_UM_EXT4 | VARCHAR2 | (20) | External ship volume unit of measure 4 | |
| SHIPVOLUME_UM_EXT5 | VARCHAR2 | (20) | External ship volume unit of measure 5 | |
| ORDR_QTY1 | NUMBER | Quantity ordered in unit of measure indicated in column order_um1 | ||
| SHIP_QTY1 | NUMBER | Quantity shipped in order_um1. Defaults in order entry to order_qty1 and is updated in shipping to the actual ship quantity. | ||
| ORDER_UM1_INT | VARCHAR2 | (4) | Internal defined unit of measure for order quantity 1. Defaults to item_um1 of item, but can be modified by user within same unit of measure type. | |
| ORDER_UM1_EXT1 | VARCHAR2 | (20) | External unit of measure 1 for order quantity 1. | |
| ORDER_UM1_EXT2 | VARCHAR2 | (20) | External unit of measure 2 for order quantity 1. | |
| ORDER_UM1_EXT3 | VARCHAR2 | (20) | External unit of measure 3 for order quantity 1. | |
| ORDER_UM1_EXT4 | VARCHAR2 | (20) | External unit of measure 4 for order quantity 1. | |
| ORDER_UM1_EXT5 | VARCHAR2 | (20) | External unit of measure 5 for order quantity 1. | |
| ORDR_QTY2 | NUMBER | Quantity ordered in unit of measure indicated in column order_um2. This uom is always equivalent to the item_um2 of item. User can edit order_qty2 within tolerances established in item (ic_item_mst). | ||
| SHIP_QTY2 | NUMBER | Quantity shipped in order_um2. Defaults in order entry to order_qty2 and is updated in shipping to the actual ship quantity. | ||
| ORDER_UM2_INT | VARCHAR2 | (4) | Internal defined unit of measure for order quantity 2. Defaults to item_um2 of item and can not be modified by user. | |
| ORDER_UM2_EXT1 | VARCHAR2 | (20) | External unit of measure 1 for order quantity 2. | |
| ORDER_UM2_EXT2 | VARCHAR2 | (20) | External unit of measure 2 for order quantity 2. | |
| ORDER_UM2_EXT3 | VARCHAR2 | (20) | External unit of measure 3 for order quantity 2. | |
| ORDER_UM2_EXT4 | VARCHAR2 | (20) | External unit of measure 4 for order quantity 2. | |
| ORDER_UM2_EXT5 | VARCHAR2 | (20) | External unit of measure 5 for order quantity 2. | |
| ITEM_NO | VARCHAR2 | (32) | Name of item | |
| ITEM_DESC1 | VARCHAR2 | (70) | Description of item | |
| GENERIC_ITEM | VARCHAR2 | (32) | Generic or customer item number. This is the number that the customer uses (custierm item) or is generally used throughout the industry (generic item). This number can be entered in order entry in place of an item number. | |
| LINE_DESC | VARCHAR2 | (70) | Describtion of line. | |
| TO_WHSE | VARCHAR2 | (4) | destination warehouse for intra-enterprise shipments and consignments. | |
| TO_WHSE_NAME | VARCHAR2 | (40) | Name of to-whse | |
| PRICEREAS_CODE_INT | VARCHAR2 | (4) | Internal reason code for price change. | |
| PRICEREAS_CODE_EXT1 | VARCHAR2 | (20) | External reason code 1 for price change. | |
| PRICEREAS_CODE_EXT2 | VARCHAR2 | (20) | External reason code 2 for price change. | |
| PRICEREAS_CODE_EXT3 | VARCHAR2 | (20) | External reason code 3 for price change. | |
| PRICEREAS_CODE_EXT4 | VARCHAR2 | (20) | External reason code 4 for price change. | |
| PRICEREAS_CODE_EXT5 | VARCHAR2 | (20) | External reason code 5 for price change. | |
| PRICEREAS_DESC | VARCHAR2 | (40) | Description of price reason code. | |
| BASE_PRICE | NUMBER | Base price retrieved from the pricing tables for item/customer/warehouse, etc. on this order line. It is comverted to price_um and billing_currency for this line. | ||
| NET_PRICE | NUMBER | Defaults from system_price, but can be overridden by user. This is the price that the user will be charged for this order line in price_um and billing_currency. | ||
| EXTENDED_PRICE | NUMBER | Total price for line which equals order_qty1 multiplied by net_price. | ||
| LIST_PRICE | NUMBER | Price obtained from pricing tables designated as list prices. | ||
| SYSTEM_PRICE | NUMBER | Price obtained for this line item for the pricing tables. Defaults from header. Value of 0 means that no coa taking into account. Converted to order_um1 is required. Value of 1 means that a coa must be created and sent and biling_currency on the line to customer. | ||
| NET_TAX | NUMBER | Net tax. Defaults to 0. If automatic tax calculatin in use, it needs to be retrieved. Indicated if exchange rate is multiplied then field contains tax amount calculated for this line, or devide into billing currency to arrive at base currency. Value of 0 means mutiply; value of 1 means divide. | ||
| BILL_QTY | NUMBER | Quantity of order line billed in order_um1. Defaults in invoicing to ship_qty1 and can be changed by user. | ||
| 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 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 | |
| FROM_WHSE_COUNTRY_CODE_INT | VARCHAR2 | (60) | Internal country code of shipping warehouse | |
| FROM_WHSE_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | External country code 1 of shipping warehouse | |
| FROM_WHSE_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | External country code 2 of shipping warehouse | |
| FROM_WHSE_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | External country code 3 of shipping warehouse | |
| FROM_WHSE_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | External country code 4 of shipping warehouse | |
| FROM_WHSE_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | External country code 5 of shipping warehouse | |
| FROM_WHSE_STATE_CODE_INT | VARCHAR2 | (60) | Internal state code of shipping warehouse | |
| FROM_WHSE_STATE_CODE_EXT1 | VARCHAR2 | (80) | External state code 1 of shipping warehouse | |
| FROM_WHSE_STATE_CODE_EXT2 | VARCHAR2 | (80) | External state code 2 of shipping warehouse | |
| FROM_WHSE_STATE_CODE_EXT3 | VARCHAR2 | (80) | External state code 3 of shipping warehouse | |
| FROM_WHSE_STATE_CODE_EXT4 | VARCHAR2 | (80) | External state code 4 of shipping warehouse | |
| FROM_WHSE_STATE_CODE_EXT5 | VARCHAR2 | (80) | External state code 5 of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_INT | VARCHAR2 | (60) | Internal province code of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | External province code 1 of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | External province code 2 of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | External province code 3 of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | External province code 4 of shipping warehouse | |
| FROM_WHSE_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | External province code 5 of shipping warehouse | |
| FROM_WHSE_COUNTY | VARCHAR2 | (60) | County code of shipping warehouse | |
| TRANSACTION_RECORD_ID | NUMBER | Unique identifier which links this table to its associated extension table GML_GASNO_DETAILS_X. | ||
| 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 | |
| LINE_STATUS_CODE | VARCHAR2 | (16) | Line Status Code |
Cut, paste (and edit) the following text to query this object:
SELECT RUN_ID
, ORDER_ID
, BOL_ID
, LINE_ID
, LINE_STATUS
, SHIP_STATUS
, SO_LINE_NO
, TRANS_CNT
, ACTUAL_SHIPDATE
, REQUESTED_SHIPDATE
, PROMISED_SHIPDATE
, SCHED_SHIPDATE
, ACTUAL_DLVDATE
, REQUIRED_DLVDATE
, HOLD_EXPIRATION
, EXPORT_DATE
, LINE_COMMENT
, SO_DETAIL_CATEGORY
, SO_DETAIL_ATTRIBUTE1
, SO_DETAIL_ATTRIBUTE2
, SO_DETAIL_ATTRIBUTE3
, SO_DETAIL_ATTRIBUTE4
, SO_DETAIL_ATTRIBUTE5
, SO_DETAIL_ATTRIBUTE6
, SO_DETAIL_ATTRIBUTE7
, SO_DETAIL_ATTRIBUTE8
, SO_DETAIL_ATTRIBUTE9
, SO_DETAIL_ATTRIBUTE10
, SO_DETAIL_ATTRIBUTE11
, SO_DETAIL_ATTRIBUTE12
, SO_DETAIL_ATTRIBUTE13
, SO_DETAIL_ATTRIBUTE14
, SO_DETAIL_ATTRIBUTE15
, SO_DETAIL_ATTRIBUTE16
, SO_DETAIL_ATTRIBUTE17
, SO_DETAIL_ATTRIBUTE18
, SO_DETAIL_ATTRIBUTE19
, SO_DETAIL_ATTRIBUTE20
, SO_DETAIL_ATTRIBUTE21
, SO_DETAIL_ATTRIBUTE22
, SO_DETAIL_ATTRIBUTE23
, SO_DETAIL_ATTRIBUTE24
, SO_DETAIL_ATTRIBUTE25
, SO_DETAIL_ATTRIBUTE26
, SO_DETAIL_ATTRIBUTE27
, SO_DETAIL_ATTRIBUTE28
, SO_DETAIL_ATTRIBUTE29
, SO_DETAIL_ATTRIBUTE30
, SHIP_METHOD_INT
, SHIP_METHOD_EXT1
, SHIP_METHOD_EXT2
, SHIP_METHOD_EXT3
, SHIP_METHOD_EXT4
, SHIP_METHOD_EXT5
, BASE_CURRENCY_INT
, BASE_CURRENCY_EXT1
, BASE_CURRENCY_EXT2
, BASE_CURRENCY_EXT3
, BASE_CURRENCY_EXT4
, BASE_CURRENCY_EXT5
, BILLING_CURRENCY_INT
, BILLING_CURRENCY_EXT1
, BILLING_CURRENCY_EXT2
, BILLING_CURRENCY_EXT3
, BILLING_CURRENCY_EXT4
, BILLING_CURRENCY_EXT5
, HOLDREAS_CODE_INT
, HOLDREAS_CODE_EXT1
, HOLDREAS_CODE_EXT2
, HOLDREAS_CODE_EXT3
, HOLDREAS_CODE_EXT4
, HOLDREAS_CODE_EXT5
, EXCHANGE_RATE
, BILLTO_CUST_ID
, BILLTO_CODE_INT
, BILLTO_CODE_EXT1
, BILLTO_CODE_EXT2
, BILLTO_CODE_EXT3
, BILLTO_CODE_EXT4
, BILLTO_CODE_EXT5
, BILLTO_CUST_NAME
, BILLTO_ADDR1
, BILLTO_ADDR2
, BILLTO_ADDR3
, BILLTO_ADDR4
, BILLTO_POSTAL_CODE
, BILLTO_COUNTRY_CODE_INT
, BILLTO_COUNTRY_CODE_EXT1
, BILLTO_COUNTRY_CODE_EXT2
, BILLTO_COUNTRY_CODE_EXT3
, BILLTO_COUNTRY_CODE_EXT4
, BILLTO_COUNTRY_CODE_EXT5
, BILLTO_STATE_CODE_INT
, BILLTO_STATE_CODE_EXT1
, BILLTO_STATE_CODE_EXT2
, BILLTO_STATE_CODE_EXT3
, BILLTO_STATE_CODE_EXT4
, BILLTO_STATE_CODE_EXT5
, BILLTO_PROVINCE_CODE_INT
, BILLTO_PROVINCE_CODE_EXT1
, BILLTO_PROVINCE_CODE_EXT2
, BILLTO_PROVINCE_CODE_EXT3
, BILLTO_PROVINCE_CODE_EXT4
, BILLTO_PROVINCE_CODE_EXT5
, BILLTO_COUNTY
, BILLTO_LAST_NAME
, BILLTO_FIRST_NAME
, BILLTO_JOB_TITLE
, BILLTO_AREA_CODE
, BILLTO_TELEPHONE
, NET_WT
, TARE_WT
, PALLET_WT
, FRTBILL_WT
, SHIPWT_UM_INT
, SHIPWT_UM_EXT1
, SHIPWT_UM_EXT2
, SHIPWT_UM_EXT3
, SHIPWT_UM_EXT4
, SHIPWT_UM_EXT5
, SHIP_VOLUME
, SHIPVOLUME_UM_INT
, SHIPVOLUME_UM_EXT1
, SHIPVOLUME_UM_EXT2
, SHIPVOLUME_UM_EXT3
, SHIPVOLUME_UM_EXT4
, SHIPVOLUME_UM_EXT5
, ORDR_QTY1
, SHIP_QTY1
, ORDER_UM1_INT
, ORDER_UM1_EXT1
, ORDER_UM1_EXT2
, ORDER_UM1_EXT3
, ORDER_UM1_EXT4
, ORDER_UM1_EXT5
, ORDR_QTY2
, SHIP_QTY2
, ORDER_UM2_INT
, ORDER_UM2_EXT1
, ORDER_UM2_EXT2
, ORDER_UM2_EXT3
, ORDER_UM2_EXT4
, ORDER_UM2_EXT5
, ITEM_NO
, ITEM_DESC1
, GENERIC_ITEM
, LINE_DESC
, TO_WHSE
, TO_WHSE_NAME
, PRICEREAS_CODE_INT
, PRICEREAS_CODE_EXT1
, PRICEREAS_CODE_EXT2
, PRICEREAS_CODE_EXT3
, PRICEREAS_CODE_EXT4
, PRICEREAS_CODE_EXT5
, PRICEREAS_DESC
, BASE_PRICE
, NET_PRICE
, EXTENDED_PRICE
, LIST_PRICE
, SYSTEM_PRICE
, NET_TAX
, BILL_QTY
, 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
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LINE_STATUS_CODE
FROM GML.GML_GASNO_DETAILS;
GML.GML_GASNO_DETAILS does not reference any database object
GML.GML_GASNO_DETAILS is referenced by following:
APPS
GML_GASNO_DETAILS
|
|
|
|