[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GPOAO_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
GML_GPOAO_DETAILS contains order line detail data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP)).
This table is based primarily on data stored in the OP_ORDR_DTL table of OPM Order Fulfillment.
All columns denoted with an "INT" or "INTERNAL" represent Applications internal values. All columns with "EXT" or "External" represent the equivalent external values sourced from the ECE_XREF_DATA table if code conversion is enabled for the column.
Each row in the GML_GPOA_DETAILS is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_DETAILS table to its corresponding extension table GML_GPOAO_DETAILS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RUN_ID | NUMBER | Transaction Run ID | ||
| ORDER_ID | NUMBER | Sales Order ID | ||
| LINE_ID | NUMBER | Sales Order LIne ID | ||
| LINE_STATUS | NUMBER | Line Status | ||
| SHIP_STATUS | NUMBER | Ship Status | ||
| SO_LINE_NO | NUMBER | Sales Order Line Number | ||
| TRANS_CNT | NUMBER | Transaction Count | ||
| ACTUAL_SHIPDATE | DATE | Actual Ship Date | ||
| REQUESTED_SHIPDATE | DATE | Requested Ship Date | ||
| PROMISED_SHIPDATE | DATE | Promised Ship Date | ||
| SCHED_SHIPDATE | DATE | Scheduled Ship Date | ||
| ACTUAL_DLVDATE | DATE | Actual Delivery Date | ||
| REQUIRED_DLVDATE | DATE | Required Delivery Date | ||
| HOLD_EXPIRATION | DATE | Hold Expiration Date | ||
| EXPORT_DATE | DATE | Financials Export Date | ||
| LINE_COMMENT | VARCHAR2 | (80) | Line Comment | |
| 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) | Ship Method (Int) | |
| SHIP_METHOD_EXT1 | VARCHAR2 | (20) | Ship Method (Ext1) | |
| SHIP_METHOD_EXT2 | VARCHAR2 | (20) | Ship Method (Ext2) | |
| SHIP_METHOD_EXT3 | VARCHAR2 | (20) | Ship Method (Ext3) | |
| SHIP_METHOD_EXT4 | VARCHAR2 | (20) | Ship Method (Ext4) | |
| SHIP_METHOD_EXT5 | VARCHAR2 | (20) | Ship Method (Ext5) | |
| BASE_CURRENCY_INT | VARCHAR2 | (4) | Base Currency (Int) | |
| BASE_CURRENCY_EXT1 | VARCHAR2 | (20) | Base Currency (Ext1) | |
| BASE_CURRENCY_EXT2 | VARCHAR2 | (20) | Base Currency (Ext2) | |
| BASE_CURRENCY_EXT3 | VARCHAR2 | (20) | Base Currency (Ext3) | |
| BASE_CURRENCY_EXT4 | VARCHAR2 | (20) | Base Currency (Ext4) | |
| BASE_CURRENCY_EXT5 | VARCHAR2 | (20) | Base Currency (Ext5) | |
| BILLING_CURRENCY_INT | VARCHAR2 | (4) | Billing Currency (Int) | |
| BILLING_CURRENCY_EXT1 | VARCHAR2 | (20) | Billing Currency (Ext1) | |
| BILLING_CURRENCY_EXT2 | VARCHAR2 | (20) | Billing Currency (Ext2) | |
| BILLING_CURRENCY_EXT3 | VARCHAR2 | (20) | Billing Currency (Ext3) | |
| BILLING_CURRENCY_EXT4 | VARCHAR2 | (20) | Billing Currency (Ext4) | |
| BILLING_CURRENCY_EXT5 | VARCHAR2 | (20) | Billing Currency (Ext5) | |
| HOLDREAS_CODE_INT | VARCHAR2 | (4) | Hold Reason Code (Int) | |
| HOLDREAS_CODE_EXT1 | VARCHAR2 | (20) | Hold Reason Code (Ext1) | |
| HOLDREAS_CODE_EXT2 | VARCHAR2 | (20) | Hold Reason Code (Ext2) | |
| HOLDREAS_CODE_EXT3 | VARCHAR2 | (20) | Hold Reason Code (Ext3) | |
| HOLDREAS_CODE_EXT4 | VARCHAR2 | (20) | Hold Reason Code (Ext4) | |
| HOLDREAS_CODE_EXT5 | VARCHAR2 | (20) | Hold Reason Code (Ext5) | |
| EXCHANGE_RATE | NUMBER | Currency Exchange Rate | ||
| SHIPTO_CUST_ID | NUMBER | Ship To Customer ID | ||
| SHIPTO_CODE_INT | VARCHAR2 | (240) | Ship To Customer Code (Int) | |
| SHIPTO_CODE_EXT1 | VARCHAR2 | (80) | Ship To Customer Code (Ext1) | |
| SHIPTO_CODE_EXT2 | VARCHAR2 | (80) | Ship To Customer Code (Ext2) | |
| SHIPTO_CODE_EXT3 | VARCHAR2 | (80) | Ship To Customer Code (Ext3) | |
| SHIPTO_CODE_EXT4 | VARCHAR2 | (80) | Ship To Customer Code (Ext4) | |
| SHIPTO_CODE_EXT5 | VARCHAR2 | (80) | Ship To Customer Code (Ext5) | |
| SHIPTO_CUST_NAME | VARCHAR2 | (80) | Ship To Customer Name | |
| SHIPTO_ADDR1 | VARCHAR2 | (70) | Ship To Address Line 1 | |
| SHIPTO_ADDR2 | VARCHAR2 | (70) | Ship To Address Line 2 | |
| SHIPTO_ADDR3 | VARCHAR2 | (70) | Ship To Address Line 3 | |
| SHIPTO_ADDR4 | VARCHAR2 | (70) | Ship To Address Line 4 | |
| SHIPTO_POSTAL_CODE | VARCHAR2 | (60) | Ship To Postal Code | |
| SHIPTO_COUNTRY_CODE_INT | VARCHAR2 | (60) | Ship To Country Code (Int) | |
| SHIPTO_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | Ship To Country Code (Ext1) | |
| SHIPTO_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | Ship To Country Code (Ext2) | |
| SHIPTO_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | Ship To Country Code (Ext3) | |
| SHIPTO_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | Ship To Country Code (Ext4) | |
| SHIPTO_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | Ship To Country Code (Ext5) | |
| SHIPTO_STATE_CODE_INT | VARCHAR2 | (60) | Ship To State Code (Int) | |
| SHIPTO_STATE_CODE_EXT1 | VARCHAR2 | (80) | Ship To State Code (Ext1) | |
| SHIPTO_STATE_CODE_EXT2 | VARCHAR2 | (80) | Ship To State Code (Ext2) | |
| SHIPTO_STATE_CODE_EXT3 | VARCHAR2 | (80) | Ship To State Code (Ext3) | |
| SHIPTO_STATE_CODE_EXT4 | VARCHAR2 | (80) | Ship To State Code (Ext4) | |
| SHIPTO_STATE_CODE_EXT5 | VARCHAR2 | (80) | Ship To State Code (Ext5) | |
| SHIPTO_PROVINCE_CODE_INT | VARCHAR2 | (60) | Ship To Province (Int) | |
| SHIPTO_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | Ship To Province (Ext1) | |
| SHIPTO_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | Ship To Province (Ext2) | |
| SHIPTO_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | Ship To Province (Ext3) | |
| SHIPTO_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | Ship To Province (Ext4) | |
| SHIPTO_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | Ship To Province (Ext5) | |
| SHIPTO_COUNTY | VARCHAR2 | (60) | Ship To County | |
| SHIPTO_LAST_NAME | VARCHAR2 | (50) | Ship To Last Name | |
| SHIPTO_FIRST_NAME | VARCHAR2 | (40) | Ship To First Name | |
| SHIPTO_JOB_TITLE | VARCHAR2 | (50) | Ship To Job Title | |
| SHIPTO_AREA_CODE | VARCHAR2 | (10) | Ship To Area Code | |
| SHIPTO_TELEPHONE | VARCHAR2 | (60) | Ship To Telephone | |
| NET_WT | NUMBER | Line Net Weight | ||
| TARE_WT | NUMBER | Line Tare Weight | ||
| PALLET_WT | NUMBER | Line Pallet Weight | ||
| FRTBILL_WT | NUMBER | Line Freight Bill Weight | ||
| SHIPWT_UM_INT | VARCHAR2 | (4) | Line Shipping Weight UOM (Int) | |
| SHIPWT_UM_EXT1 | VARCHAR2 | (20) | Line Shipping Weight UOM (Ext1) | |
| SHIPWT_UM_EXT2 | VARCHAR2 | (20) | Line Shipping Weight UOM (Ext2) | |
| SHIPWT_UM_EXT3 | VARCHAR2 | (20) | Line Shipping Weight UOM (Ext3) | |
| SHIPWT_UM_EXT4 | VARCHAR2 | (20) | Line Shipping Weight UOM (Ext4) | |
| SHIPWT_UM_EXT5 | VARCHAR2 | (20) | Line Shipping Weight UOM (Ext5) | |
| SHIP_VOLUME | NUMBER | Line Volume | ||
| SHIPVOLUME_UM_INT | VARCHAR2 | (4) | Line Volume UOM (Int) | |
| SHIPVOLUME_UM_EXT1 | VARCHAR2 | (20) | Line Volume UOM (Ext1) | |
| SHIPVOLUME_UM_EXT2 | VARCHAR2 | (20) | Line Volume UOM (Ext2) | |
| SHIPVOLUME_UM_EXT3 | VARCHAR2 | (20) | Line Volume UOM (Ext3) | |
| SHIPVOLUME_UM_EXT4 | VARCHAR2 | (20) | Line Volume UOM (Ext4) | |
| SHIPVOLUME_UM_EXT5 | VARCHAR2 | (20) | Line Volume UOM (Ext5) | |
| ORDR_QTY1 | NUMBER | Order Quantity 1 | ||
| SHIP_QTY1 | NUMBER | Shipping Quantity 1 | ||
| ORDER_UM1_INT | VARCHAR2 | (4) | Order UOM (Int) | |
| ORDER_UM1_EXT1 | VARCHAR2 | (20) | Order UOM (Ext1) | |
| ORDER_UM1_EXT2 | VARCHAR2 | (20) | Order UOM (Ext2) | |
| ORDER_UM1_EXT3 | VARCHAR2 | (20) | Order UOM (Ext3) | |
| ORDER_UM1_EXT4 | VARCHAR2 | (20) | Order UOM (Ext4) | |
| ORDER_UM1_EXT5 | VARCHAR2 | (20) | Order UOM (Ext5) | |
| ORDR_QTY2 | NUMBER | Order Quantity 2 | ||
| SHIP_QTY2 | NUMBER | Shipping Quantity 2 | ||
| ORDER_UM2_INT | VARCHAR2 | (4) | Order UOM 2 (Int) | |
| ORDER_UM2_EXT1 | VARCHAR2 | (20) | Order UOM 2 (Ext1) | |
| ORDER_UM2_EXT2 | VARCHAR2 | (20) | Order UOM 2 (Ext2) | |
| ORDER_UM2_EXT3 | VARCHAR2 | (20) | Order UOM 2 (Ext3) | |
| ORDER_UM2_EXT4 | VARCHAR2 | (20) | Order UOM 2 (Ext4) | |
| ORDER_UM2_EXT5 | VARCHAR2 | (20) | Order UOM 2 (Ext5) | |
| ITEM_NO | VARCHAR2 | (32) | Item Number | |
| ITEM_DESC1 | VARCHAR2 | (70) | Item Description | |
| GENERIC_ITEM | VARCHAR2 | (32) | Generic Item Number | |
| LINE_DESC | VARCHAR2 | (70) | Line Description | |
| TO_WHSE | VARCHAR2 | (4) | To Warehouse | |
| TO_WHSE_NAME | VARCHAR2 | (40) | To Warehouse Name | |
| PRICEREAS_CODE_INT | VARCHAR2 | (4) | Price Reason Code (Int) | |
| PRICEREAS_CODE_EXT1 | VARCHAR2 | (20) | Price Reason Code (Ext1) | |
| PRICEREAS_CODE_EXT2 | VARCHAR2 | (20) | Price Reason Code (Ext2) | |
| PRICEREAS_CODE_EXT3 | VARCHAR2 | (20) | Price Reason Code (Ext3) | |
| PRICEREAS_CODE_EXT4 | VARCHAR2 | (20) | Price Reason Code (Ext4) | |
| PRICEREAS_CODE_EXT5 | VARCHAR2 | (20) | Price Reason Code (Ext5) | |
| PRICEREAS_DESC | VARCHAR2 | (40) | Price Reason Code Description | |
| BASE_PRICE | NUMBER | Base Price | ||
| NET_PRICE | NUMBER | Net Price | ||
| EXTENDED_PRICE | NUMBER | Extended Price | ||
| LIST_PRICE | NUMBER | List Price | ||
| SYSTEM_PRICE | NUMBER | System Price | ||
| NET_TAX | NUMBER | Net Tax | ||
| BILL_QTY | NUMBER | Bill Quantity | ||
| FROM_WHSE | VARCHAR2 | (4) | From Warehouse | |
| FROM_WHSE_NAME | VARCHAR2 | (50) | From Warehouse Name | |
| FROM_WHSE_CONTACT | VARCHAR2 | (50) | From Warehouse Contact | |
| FROM_WHSE_PHONE | VARCHAR2 | (60) | From Warehouse Phone Number | |
| FROM_WHSE_ADDR1 | VARCHAR2 | (70) | From Warehouse Address Line 1 | |
| FROM_WHSE_ADDR2 | VARCHAR2 | (70) | From Warehouse Address Line 2 | |
| FROM_WHSE_ADDR3 | VARCHAR2 | (70) | From Warehouse Address Line 3 | |
| FROM_WHSE_ADDR4 | VARCHAR2 | (70) | From Warehouse Address Line 4 | |
| FROM_WHSE_POSTAL_CODE | VARCHAR2 | (60) | From Warehouse Postal Code | |
| FROM_WHSE_COUNTRY_CODE_INT | VARCHAR2 | (60) | From Warehouse Country Code (Int) | |
| FROM_WHSE_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | From Warehouse Country Code (Ext1) | |
| FROM_WHSE_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | From Warehouse Country Code (Ext2) | |
| FROM_WHSE_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | From Warehouse Country Code (Ext3) | |
| FROM_WHSE_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | From Warehouse Country Code (Ext4) | |
| FROM_WHSE_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | From Warehouse Country Code (Ext5) | |
| FROM_WHSE_STATE_CODE_INT | VARCHAR2 | (60) | From Warehouse State Code (Int) | |
| FROM_WHSE_STATE_CODE_EXT1 | VARCHAR2 | (80) | From Warehouse State Code (Ext1) | |
| FROM_WHSE_STATE_CODE_EXT2 | VARCHAR2 | (80) | From Warehouse State Code (Ext2) | |
| FROM_WHSE_STATE_CODE_EXT3 | VARCHAR2 | (80) | From Warehouse State Code (Ext3) | |
| FROM_WHSE_STATE_CODE_EXT4 | VARCHAR2 | (80) | From Warehouse State Code (Ext4) | |
| FROM_WHSE_STATE_CODE_EXT5 | VARCHAR2 | (80) | From Warehouse State Code (Ext5) | |
| FROM_WHSE_PROVINCE_CODE_INT | VARCHAR2 | (60) | From Warehouse Province Code (Int) | |
| FROM_WHSE_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | From Warehouse Province Code (Ext1) | |
| FROM_WHSE_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | From Warehouse Province Code (Ext2) | |
| FROM_WHSE_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | From Warehouse Province Code (Ext3) | |
| FROM_WHSE_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | From Warehouse Province Code (Ext4) | |
| FROM_WHSE_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | From Warehouse Province Code (Ext5) | |
| FROM_WHSE_COUNTY | VARCHAR2 | (60) | From Warehouse County | |
| TRANSACTION_RECORD_ID | NUMBER | Transaction Record ID | ||
| 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
, 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
, 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
, 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_GPOAO_DETAILS;
GML.GML_GPOAO_DETAILS does not reference any database object
GML.GML_GPOAO_DETAILS is referenced by following:
GML
GML_GPOAO_DETAILS#
|
|
|
|