[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_COA_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | GMD |
| FND Design Data: |  GMD.GMD_COA_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
Certificate of Analysis report header information
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| GMD_COA_ID | NUMBER | (10) | Yes | Distinct number of the header |
| ORDER_ID | NUMBER | (10) | Key to customer order | |
| LINE_ID | NUMBER | (10) | Key to customer order line | |
| ORGN_CODE | VARCHAR2 | (4) | Organization which can use the specification. May be global | |
| ORDER_NO | VARCHAR2 | (32) | Order number | |
| CUSTPO_NO | VARCHAR2 | (40) | Customer purchase number | |
| SHIPDATE | DATE | Order ship date | ||
| CUST_ID | NUMBER | (15) | Customer ID | |
| CUST_NO | VARCHAR2 | (32) | Customer number | |
| CUST_NAME | VARCHAR2 | (360) | Name of customer | |
| BOL_ID | NUMBER | (10) | Key to bill of lading | |
| BOL_NO | VARCHAR2 | (32) | Bill of lading number | |
| ITEM_ID | NUMBER | (10) | Key to item | |
| ITEM_NO | VARCHAR2 | (32) | Item number | |
| ITEM_DESC1 | VARCHAR2 | (70) | Item description | |
| WHSE_CODE | VARCHAR2 | (4) | Warehouse code | |
| WHSE_NAME | VARCHAR2 | (40) | Warehouse name | |
| LOT_ID | NUMBER | (10) | Key to lot and any sublot | |
| LOT_NO | VARCHAR2 | (32) | Lot number | |
| LOT_DESC | VARCHAR2 | (40) | Lot description | |
| SUBLOT_NO | VARCHAR2 | (32) | Sublot number | |
| ORDER_QTY1 | NUMBER | Order quantity in the primary UOM | ||
| ORDER_UM1 | VARCHAR2 | (4) | Primary UOM | |
| ORDER_QTY2 | NUMBER | Order quantity in the secondary UOM | ||
| ORDER_UM2 | VARCHAR2 | (4) | Secondary UOM | |
| SHIP_QTY1 | NUMBER | Shipping quantity in the primary UOM | ||
| SHIP_QTY2 | NUMBER | Shipping quantity in the secondary UOM | ||
| REPORT_TITLE | VARCHAR2 | (4) | Certificate of Analysis or Certificate of Conformance | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| OPM_CUST_ID | NUMBER | (10) | Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes. | |
| SESSION_ID | NUMBER | session id of coa run | ||
| SHIP_UOM1 | VARCHAR2 | (4) | This is the Unit of Measure for Shipping Quantity 1 | |
| SHIP_UOM2 | VARCHAR2 | (4) | This is the Unit of Measure for Shipping Quantity 2 | |
| INVENTORY_ITEM_ID | NUMBER | This is Inventory Item ID | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | This is Item Description | |
| ITEM_NUMBER | VARCHAR2 | (240) | This is Item Number | |
| LOT_DESCRIPTION | VARCHAR2 | (240) | This is Lot Description | |
| LOT_NUMBER | VARCHAR2 | (80) | This is Lot Number | |
| ORDER_INV_UOM | VARCHAR2 | (3) | This is Order Inv UOM | |
| ORDER_UOM1 | VARCHAR2 | (3) | This is Order UOM 1 | |
| ORDER_UOM2 | VARCHAR2 | (3) | This is Order UOM 2 | |
| ORGANIZATION_CODE | VARCHAR2 | (3) | This is Organization Code | |
| ORGANIZATION_ID | NUMBER | This is Organization ID | ||
| REVISION | VARCHAR2 | (3) | This is Revision | |
| SHIP_QTY_UOM1 | VARCHAR2 | (3) | This is Ship Qty UOM 1 | |
| SHIP_QTY_UOM2 | VARCHAR2 | (3) | This is Ship Qty UOM 2 | |
| SPEC_HDR_TEXT_CODE | NUMBER | (10) | This is Spec header text code | |
| SUBINVENTORY | VARCHAR2 | (10) | This is Subinventory |
Cut, paste (and edit) the following text to query this object:
SELECT GMD_COA_ID
, ORDER_ID
, LINE_ID
, ORGN_CODE
, ORDER_NO
, CUSTPO_NO
, SHIPDATE
, CUST_ID
, CUST_NO
, CUST_NAME
, BOL_ID
, BOL_NO
, ITEM_ID
, ITEM_NO
, ITEM_DESC1
, WHSE_CODE
, WHSE_NAME
, LOT_ID
, LOT_NO
, LOT_DESC
, SUBLOT_NO
, ORDER_QTY1
, ORDER_UM1
, ORDER_QTY2
, ORDER_UM2
, SHIP_QTY1
, SHIP_QTY2
, REPORT_TITLE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OPM_CUST_ID
, SESSION_ID
, SHIP_UOM1
, SHIP_UOM2
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, ITEM_NUMBER
, LOT_DESCRIPTION
, LOT_NUMBER
, ORDER_INV_UOM
, ORDER_UOM1
, ORDER_UOM2
, ORGANIZATION_CODE
, ORGANIZATION_ID
, REVISION
, SHIP_QTY_UOM1
, SHIP_QTY_UOM2
, SPEC_HDR_TEXT_CODE
, SUBINVENTORY
FROM GMD.GMD_COA_HEADERS;
GMD.GMD_COA_HEADERS does not reference any database object
GMD.GMD_COA_HEADERS is referenced by following:
GMD
GMD_COA_HEADERS#
|
|
|
|