[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_ORDERS |
|---|---|
| Object Type: | TABLE |
| Owner: | GML |
| FND Design Data: |  GML.GML_GPOAO_ORDERS
|
| Subobject Name: | |
| Status: | VALID |
GML_GPOAO_ORDERS contains order header 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_HDR 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_ORDERS is purged after the data is written to the data file.
TRANSACTION_RECORD_ID is the unique key that links the GML_GPOAO_ORDERS table to its corresponding extension table GML_GPOAO_ORDERS_X.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MAP_ID | NUMBER | Map ID used for processing document | ||
| COMMUNICATION_METHOD | VARCHAR2 | (2) | Yes | Communication Method |
| TEST_INDICATOR | VARCHAR2 | (1) | Trading Partner Test flag | |
| DOCUMENT_ID | VARCHAR2 | (6) | Document ID | |
| TP_HEADER_ID | NUMBER | Trading Partner Header ID | ||
| TP_DETAIL_ID | NUMBER | Trading Partner Detail ID | ||
| RUN_ID | NUMBER | Transaction Run ID | ||
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | Document Purpose Code | |
| DOCUMENT_CODE | VARCHAR2 | (32) | Trading Partner Document Code | |
| TP_CODE | VARCHAR2 | (35) | Trading Partner Code | |
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | Trading Partner Location Code External | |
| TP_DESCRIPTION | VARCHAR2 | (240) | Trading Partner Description | |
| TP_REFERENCE1 | VARCHAR2 | (240) | Trading Partner Reference 1 | |
| TP_REFERENCE2 | VARCHAR2 | (240) | Trading Partner Reference 2 | |
| TRANSACTION_DATE | DATE | Transaction Date/Time | ||
| TP_HEADER_CATEGORY | VARCHAR2 | (150) | Trading Partner Header Attribute Category | |
| TP_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Header Attribute 1 | |
| TP_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Header Attribute 2 | |
| TP_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Header Attribute 3 | |
| TP_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Header Attribute 4 | |
| TP_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Header Attribute 5 | |
| TP_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Trading Partner Header Attribute 6 | |
| TP_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Trading Partner Header Attribute 7 | |
| TP_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Trading Partner Header Attribute 8 | |
| TP_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Trading Partner Header Attribute 9 | |
| TP_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Trading Partner Header Attribute 10 | |
| TP_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Trading Partner Header Attribute 11 | |
| TP_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Trading Partner Header Attribute 12 | |
| TP_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Trading Partner Header Attribute 13 | |
| TP_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Trading Partner Header Attribute 14 | |
| TP_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Trading Partner Header Attribute 15 | |
| TP_DETAIL_CATEGORY | VARCHAR2 | (150) | Trading Partner Detail Attribute Category | |
| TP_DETAIL_ATTRIBUTE1 | VARCHAR2 | (150) | Trading Partner Detail Attribute 1 | |
| TP_DETAIL_ATTRIBUTE2 | VARCHAR2 | (150) | Trading Partner Detail Attribute 2 | |
| TP_DETAIL_ATTRIBUTE3 | VARCHAR2 | (150) | Trading Partner Detail Attribute 3 | |
| TP_DETAIL_ATTRIBUTE4 | VARCHAR2 | (150) | Trading Partner Detail Attribute 4 | |
| TP_DETAIL_ATTRIBUTE5 | VARCHAR2 | (150) | Trading Partner Detail Attribute 5 | |
| ORDER_ID | NUMBER | Order ID | ||
| ORDER_NO | VARCHAR2 | (32) | Sales Order Number | |
| ORGN_CODE | VARCHAR2 | (4) | Sales Order Organization Code | |
| ORDER_COMMENT | VARCHAR2 | (70) | Sales Order Comment | |
| ORDER_STATUS | NUMBER | Order Status | ||
| CUSTPO_NO | VARCHAR2 | (22) | Customer Purchase Order Number | |
| SO_DATE | DATE | Sales Order Date | ||
| FRTBILL_MTHD_INT | VARCHAR2 | (4) | Freight Bill Method (Int) | |
| FRTBILL_MTHD_EXT1 | VARCHAR2 | (30) | Freight Bill Method (Ext1) | |
| FRTBILL_MTHD_EXT2 | VARCHAR2 | (30) | Freight Bill Method (Ext2) | |
| FRTBILL_MTHD_EXT3 | VARCHAR2 | (30) | Freight Bill Method (Ext3) | |
| FRTBILL_MTHD_EXT4 | VARCHAR2 | (30) | Freight Bill Method (Ext4) | |
| FRTBILL_MTHD_EXT5 | VARCHAR2 | (30) | Freight Bill Method (Ext5) | |
| FRTBILL_DESC | VARCHAR2 | (40) | Freight Bill Method Description | |
| EMBARKATION_PORT_INT | VARCHAR2 | (8) | Embarkation Port (Int) | |
| EMBARKATION_PORT_EXT1 | VARCHAR2 | (30) | Embarkation Port (Ext1) | |
| EMBARKATION_PORT_EXT2 | VARCHAR2 | (30) | Embarkation Port (Ext2) | |
| EMBARKATION_PORT_EXT3 | VARCHAR2 | (30) | Embarkation Port (Ext3) | |
| EMBARKATION_PORT_EXT4 | VARCHAR2 | (30) | Embarkation Port (Ext4) | |
| EMBARKATION_PORT_EXT5 | VARCHAR2 | (30) | Embarkation Port (Ext5) | |
| EMBARKATION_PORT_DESC | VARCHAR2 | (70) | Embarkation Port Description | |
| DEBARKATION_PORT_INT | VARCHAR2 | (8) | Debarkation Port (Int) | |
| DEBARKATION_PORT_EXT1 | VARCHAR2 | (30) | Debarkation Port (Ext1) | |
| DEBARKATION_PORT_EXT2 | VARCHAR2 | (30) | Debarkation Port (Ext2) | |
| DEBARKATION_PORT_EXT3 | VARCHAR2 | (30) | Debarkation Port (Ext3) | |
| DEBARKATION_PORT_EXT4 | VARCHAR2 | (30) | Debarkation Port (Ext4) | |
| DEBARKATION_PORT_EXT5 | VARCHAR2 | (30) | Debarkation Port (Ext5) | |
| DEBARKATION_PORT_DESC | VARCHAR2 | (70) | Debarkation Port Description | |
| FOB_CODE_INT | VARCHAR2 | (4) | Free On Board Code (Int) | |
| FOB_CODE_EXT1 | VARCHAR2 | (30) | Free On Board Code (Ext1) | |
| FOB_CODE_EXT2 | VARCHAR2 | (30) | Free On Board Code (Ext2) | |
| FOB_CODE_EXT3 | VARCHAR2 | (30) | Free On Board Code (Ext3) | |
| FOB_CODE_EXT4 | VARCHAR2 | (30) | Free On Board Code (Ext4) | |
| FOB_CODE_EXT5 | VARCHAR2 | (30) | Free On Board Code (Ext5) | |
| FOB_NAME | VARCHAR2 | (40) | Free On Board Name | |
| SHIPPER_CODE_INT | VARCHAR2 | (4) | Shipper Code (Int) | |
| SHIPPER_CODE_EXT1 | VARCHAR2 | (20) | Shipper Code (Ext1) | |
| SHIPPER_CODE_EXT2 | VARCHAR2 | (20) | Shipper Code (Ext2) | |
| SHIPPER_CODE_EXT3 | VARCHAR2 | (20) | Shipper Code (Ext3) | |
| SHIPPER_CODE_EXT4 | VARCHAR2 | (20) | Shipper Code (Ext4) | |
| SHIPPER_CODE_EXT5 | VARCHAR2 | (20) | Shipper Code (Ext5) | |
| SHIPPER_NAME | VARCHAR2 | (40) | Shipper Name | |
| SHIP_MTHD_INT | VARCHAR2 | (4) | Ship Method (Int) | |
| SHIP_MTHD_EXT1 | VARCHAR2 | (20) | Ship Method (Ext1) | |
| SHIP_MTHD_EXT2 | VARCHAR2 | (20) | Ship Method (Ext2) | |
| SHIP_MTHD_EXT3 | VARCHAR2 | (20) | Ship Method (Ext3) | |
| SHIP_MTHD_EXT4 | VARCHAR2 | (20) | Ship Method (Ext4) | |
| SHIP_MTHD_EXT5 | VARCHAR2 | (20) | Ship Method (Ext5) | |
| METH_DESC1 | VARCHAR2 | (40) | Ship Method Description | |
| BILLTO_CUST_ID | NUMBER | Bill To Customer ID | ||
| BILLTO_CODE_INT | VARCHAR2 | (240) | Bill To Customer Code (Int) | |
| BILLTO_CODE_EXT1 | VARCHAR2 | (80) | Bill To Customer Code (EXT1) | |
| BILLTO_CODE_EXT2 | VARCHAR2 | (80) | Bill To Customer Code (EXT2) | |
| BILLTO_CODE_EXT3 | VARCHAR2 | (80) | Bill To Customer Code (EXT3) | |
| BILLTO_CODE_EXT4 | VARCHAR2 | (80) | Bill To Customer Code (EXT4) | |
| BILLTO_CODE_EXT5 | VARCHAR2 | (80) | Bill To Customer Code (EXT5) | |
| BILLTO_CUST_NAME | VARCHAR2 | (80) | Bill To Customer Name | |
| BILLTO_ADDR1 | VARCHAR2 | (70) | Bill To Address Line 1 | |
| BILLTO_ADDR2 | VARCHAR2 | (70) | Bill To Address Line 2 | |
| BILLTO_ADDR3 | VARCHAR2 | (70) | Bill To Address Line 3 | |
| BILLTO_ADDR4 | VARCHAR2 | (70) | Bill To Address Line 4 | |
| BILLTO_POSTAL_CODE | VARCHAR2 | (60) | Bill To Postal Code | |
| BILLTO_COUNTRY_CODE_INT | VARCHAR2 | (60) | Bill To Country Code (Int) | |
| BILLTO_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | Bill To Country Code (Ext1) | |
| BILLTO_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | Bill To Country Code (Ext2) | |
| BILLTO_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | Bill To Country Code (Ext3) | |
| BILLTO_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | Bill To Country Code (Ext4) | |
| BILLTO_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | Bill To Country Code (Ext5) | |
| BILLTO_STATE_CODE_INT | VARCHAR2 | (60) | Bill To State Code (Int) | |
| BILLTO_STATE_CODE_EXT1 | VARCHAR2 | (80) | Bill To State Code (Ext1) | |
| BILLTO_STATE_CODE_EXT2 | VARCHAR2 | (80) | Bill To State Code (Ext2) | |
| BILLTO_STATE_CODE_EXT3 | VARCHAR2 | (80) | Bill To State Code (Ext3) | |
| BILLTO_STATE_CODE_EXT4 | VARCHAR2 | (80) | Bill To State Code (Ext4) | |
| BILLTO_STATE_CODE_EXT5 | VARCHAR2 | (80) | Bill To State Code (Ext5) | |
| BILLTO_PROVINCE_CODE_INT | VARCHAR2 | (60) | Bill To Province Code (Int) | |
| BILLTO_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | Bill To Province Code (Ext1) | |
| BILLTO_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | Bill To Province Code (Ext2) | |
| BILLTO_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | Bill To Province Code (Ext3) | |
| BILLTO_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | Bill To Province Code (Ext4) | |
| BILLTO_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | Bill To Province Code (Ext5) | |
| BILLTO_COUNTY | VARCHAR2 | (60) | Bill To County | |
| BILLTO_LAST_NAME | VARCHAR2 | (50) | Bill To Last Name | |
| BILLTO_FIRST_NAME | VARCHAR2 | (40) | Bill To First Name | |
| BILLTO_JOB_TITLE | VARCHAR2 | (50) | Bill To Job Title | |
| BILLTO_AREA_CODE | VARCHAR2 | (10) | Bill To Area Code | |
| BILLTO_TELEPHONE | VARCHAR2 | (60) | Bill To Telephone | |
| 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 Number | |
| SHIPADDR_ID | NUMBER | Ship Address Address ID | ||
| SHIPADDR_ADDR1 | VARCHAR2 | (70) | Ship Address Address Line 1 | |
| SHIPADDR_ADDR2 | VARCHAR2 | (70) | Ship Address Address Line 2 | |
| SHIPADDR_ADDR3 | VARCHAR2 | (70) | Ship Address Address Line 3 | |
| SHIPADDR_ADDR4 | VARCHAR2 | (70) | Ship Address Address Line 4 | |
| SHIPADDR_POSTAL_CODE | VARCHAR2 | (60) | Ship Address Postal Code | |
| SHIPADDR_COUNTRY_CODE_INT | VARCHAR2 | (60) | Ship Address Country Code (Int) | |
| SHIPADDR_COUNTRY_CODE_EXT1 | VARCHAR2 | (80) | Ship Address Country Code (Ext1) | |
| SHIPADDR_COUNTRY_CODE_EXT2 | VARCHAR2 | (80) | Ship Address Country Code (Ext2) | |
| SHIPADDR_COUNTRY_CODE_EXT3 | VARCHAR2 | (80) | Ship Address Country Code (Ext3) | |
| SHIPADDR_COUNTRY_CODE_EXT4 | VARCHAR2 | (80) | Ship Address Country Code (Ext4) | |
| SHIPADDR_COUNTRY_CODE_EXT5 | VARCHAR2 | (80) | Ship Address Country Code (Ext5) | |
| SHIPADDR_STATE_CODE_INT | VARCHAR2 | (60) | Ship Address State Code (Int) | |
| SHIPADDR_STATE_CODE_EXT1 | VARCHAR2 | (80) | Ship Address State Code (Ext1) | |
| SHIPADDR_STATE_CODE_EXT2 | VARCHAR2 | (80) | Ship Address State Code (Ext2) | |
| SHIPADDR_STATE_CODE_EXT3 | VARCHAR2 | (80) | Ship Address State Code (Ext3) | |
| SHIPADDR_STATE_CODE_EXT4 | VARCHAR2 | (80) | Ship Address State Code (Ext4) | |
| SHIPADDR_STATE_CODE_EXT5 | VARCHAR2 | (80) | Ship Address State Code (Ext5) | |
| SHIPADDR_PROVINCE_CODE_INT | VARCHAR2 | (60) | Ship Address Province Code (Int) | |
| SHIPADDR_PROVINCE_CODE_EXT1 | VARCHAR2 | (80) | Ship Address Province Code (Ext1) | |
| SHIPADDR_PROVINCE_CODE_EXT2 | VARCHAR2 | (80) | Ship Address Province Code (Ext2) | |
| SHIPADDR_PROVINCE_CODE_EXT3 | VARCHAR2 | (80) | Ship Address Province Code (Ext3) | |
| SHIPADDR_PROVINCE_CODE_EXT4 | VARCHAR2 | (80) | Ship Address Province Code (Ext4) | |
| SHIPADDR_PROVINCE_CODE_EXT5 | VARCHAR2 | (80) | Ship Address Province Code (Ext5) | |
| SHIPADDR_COUNTY | VARCHAR2 | (60) | Ship Address County | |
| EDI_TRANS_CNT | NUMBER | EDI Transaction Count | ||
| PRINT_COUNT | NUMBER | EDI Print Count | ||
| PRINT_DATE | DATE | EDI Print Date | ||
| 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 | |
| SO_HEADER_CATEGORY | VARCHAR2 | (30) | Sales Order Header Attribute Category | |
| SO_HEADER_ATTRIBUTE1 | VARCHAR2 | (240) | Sales Order Header Attribute 1 | |
| SO_HEADER_ATTRIBUTE2 | VARCHAR2 | (240) | Sales Order Header Attribute 2 | |
| SO_HEADER_ATTRIBUTE3 | VARCHAR2 | (240) | Sales Order Header Attribute 3 | |
| SO_HEADER_ATTRIBUTE4 | VARCHAR2 | (240) | Sales Order Header Attribute 4 | |
| SO_HEADER_ATTRIBUTE5 | VARCHAR2 | (240) | Sales Order Header Attribute 5 | |
| SO_HEADER_ATTRIBUTE6 | VARCHAR2 | (240) | Sales Order Header Attribute 6 | |
| SO_HEADER_ATTRIBUTE7 | VARCHAR2 | (240) | Sales Order Header Attribute 7 | |
| SO_HEADER_ATTRIBUTE8 | VARCHAR2 | (240) | Sales Order Header Attribute 8 | |
| SO_HEADER_ATTRIBUTE9 | VARCHAR2 | (240) | Sales Order Header Attribute 9 | |
| SO_HEADER_ATTRIBUTE10 | VARCHAR2 | (240) | Sales Order Header Attribute 10 | |
| SO_HEADER_ATTRIBUTE11 | VARCHAR2 | (240) | Sales Order Header Attribute 11 | |
| SO_HEADER_ATTRIBUTE12 | VARCHAR2 | (240) | Sales Order Header Attribute 12 | |
| SO_HEADER_ATTRIBUTE13 | VARCHAR2 | (240) | Sales Order Header Attribute 13 | |
| SO_HEADER_ATTRIBUTE14 | VARCHAR2 | (240) | Sales Order Header Attribute 14 | |
| SO_HEADER_ATTRIBUTE15 | VARCHAR2 | (240) | Sales Order Header Attribute 15 | |
| SO_HEADER_ATTRIBUTE16 | VARCHAR2 | (240) | Sales Order Header Attribute 16 | |
| SO_HEADER_ATTRIBUTE17 | VARCHAR2 | (240) | Sales Order Header Attribute 17 | |
| SO_HEADER_ATTRIBUTE18 | VARCHAR2 | (240) | Sales Order Header Attribute 18 | |
| SO_HEADER_ATTRIBUTE19 | VARCHAR2 | (240) | Sales Order Header Attribute 19 | |
| SO_HEADER_ATTRIBUTE20 | VARCHAR2 | (240) | Sales Order Header Attribute 20 | |
| SO_HEADER_ATTRIBUTE21 | VARCHAR2 | (240) | Sales Order Header Attribute 21 | |
| SO_HEADER_ATTRIBUTE22 | VARCHAR2 | (240) | Sales Order Header Attribute 22 | |
| SO_HEADER_ATTRIBUTE23 | VARCHAR2 | (240) | Sales Order Header Attribute 23 | |
| SO_HEADER_ATTRIBUTE24 | VARCHAR2 | (240) | Sales Order Header Attribute 24 | |
| SO_HEADER_ATTRIBUTE25 | VARCHAR2 | (240) | Sales Order Header Attribute 25 | |
| SO_HEADER_ATTRIBUTE26 | VARCHAR2 | (240) | Sales Order Header Attribute 26 | |
| SO_HEADER_ATTRIBUTE27 | VARCHAR2 | (240) | Sales Order Header Attribute 27 | |
| SO_HEADER_ATTRIBUTE28 | VARCHAR2 | (240) | Sales Order Header Attribute 28 | |
| SO_HEADER_ATTRIBUTE29 | VARCHAR2 | (240) | Sales Order Header Attribute 29 | |
| SO_HEADER_ATTRIBUTE30 | VARCHAR2 | (240) | Sales Order Header Attribute 30 | |
| 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 | |
| ORDER_STATUS_CODE | VARCHAR2 | (16) | Order Status Code |
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
, 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
, ORDER_ID
, ORDER_NO
, ORGN_CODE
, ORDER_COMMENT
, ORDER_STATUS
, CUSTPO_NO
, SO_DATE
, 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
, 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
, 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
, SHIPADDR_ID
, SHIPADDR_ADDR1
, SHIPADDR_ADDR2
, SHIPADDR_ADDR3
, SHIPADDR_ADDR4
, SHIPADDR_POSTAL_CODE
, SHIPADDR_COUNTRY_CODE_INT
, SHIPADDR_COUNTRY_CODE_EXT1
, SHIPADDR_COUNTRY_CODE_EXT2
, SHIPADDR_COUNTRY_CODE_EXT3
, SHIPADDR_COUNTRY_CODE_EXT4
, SHIPADDR_COUNTRY_CODE_EXT5
, SHIPADDR_STATE_CODE_INT
, SHIPADDR_STATE_CODE_EXT1
, SHIPADDR_STATE_CODE_EXT2
, SHIPADDR_STATE_CODE_EXT3
, SHIPADDR_STATE_CODE_EXT4
, SHIPADDR_STATE_CODE_EXT5
, SHIPADDR_PROVINCE_CODE_INT
, SHIPADDR_PROVINCE_CODE_EXT1
, SHIPADDR_PROVINCE_CODE_EXT2
, SHIPADDR_PROVINCE_CODE_EXT3
, SHIPADDR_PROVINCE_CODE_EXT4
, SHIPADDR_PROVINCE_CODE_EXT5
, SHIPADDR_COUNTY
, EDI_TRANS_CNT
, PRINT_COUNT
, PRINT_DATE
, 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
, SO_HEADER_CATEGORY
, SO_HEADER_ATTRIBUTE1
, SO_HEADER_ATTRIBUTE2
, SO_HEADER_ATTRIBUTE3
, SO_HEADER_ATTRIBUTE4
, SO_HEADER_ATTRIBUTE5
, SO_HEADER_ATTRIBUTE6
, SO_HEADER_ATTRIBUTE7
, SO_HEADER_ATTRIBUTE8
, SO_HEADER_ATTRIBUTE9
, SO_HEADER_ATTRIBUTE10
, SO_HEADER_ATTRIBUTE11
, SO_HEADER_ATTRIBUTE12
, SO_HEADER_ATTRIBUTE13
, SO_HEADER_ATTRIBUTE14
, SO_HEADER_ATTRIBUTE15
, SO_HEADER_ATTRIBUTE16
, SO_HEADER_ATTRIBUTE17
, SO_HEADER_ATTRIBUTE18
, SO_HEADER_ATTRIBUTE19
, SO_HEADER_ATTRIBUTE20
, SO_HEADER_ATTRIBUTE21
, SO_HEADER_ATTRIBUTE22
, SO_HEADER_ATTRIBUTE23
, SO_HEADER_ATTRIBUTE24
, SO_HEADER_ATTRIBUTE25
, SO_HEADER_ATTRIBUTE26
, SO_HEADER_ATTRIBUTE27
, SO_HEADER_ATTRIBUTE28
, SO_HEADER_ATTRIBUTE29
, SO_HEADER_ATTRIBUTE30
, 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
, ORDER_STATUS_CODE
FROM GML.GML_GPOAO_ORDERS;
GML.GML_GPOAO_ORDERS does not reference any database object
GML.GML_GPOAO_ORDERS is referenced by following:
APPS
GML_GPOAO_ORDERS
|
|
|
|