ZX_PTNR_LOCATION_INFO_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
ZX_PTNR_LOCATION_INFO_GT_PK |
EVENT_CLASS_MAPPING_ID, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EVENT_CLASS_MAPPING_ID | NUMBER | 18 | Yes | Event class mapping identifier | |
| TRX_ID | NUMBER | Yes | Primary transaction identifier | ||
| TRX_LINE_ID | NUMBER | Yes | Transaction line identifier | ||
| SHIP_TO_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Ship To location | ||
| SHIP_TO_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Ship To location | ||
| SHIP_FROM_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Ship From location | ||
| SHIP_FROM_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Ship from location | ||
| SHIP_FROM_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Ship from location | ||
| POA_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Point of Order Acceptance | ||
| POA_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Point of Order Acceptance | ||
| POO_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Point of Order Origin | ||
| POO_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Point of Order Origin | ||
| BILL_TO_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Bill To location | ||
| BILL_TO_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Bill To location | ||
| BILL_FROM_GEOGRAPHY_TYPE1 | VARCHAR2 | 30 | Geography type of the first element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE1 | VARCHAR2 | 360 | Geography name of the first element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE2 | VARCHAR2 | 30 | Geography type of the second element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE2 | VARCHAR2 | 360 | Geography name of the second element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE3 | VARCHAR2 | 30 | Geography type of the third element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE3 | VARCHAR2 | 360 | Geography name of the third element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE4 | VARCHAR2 | 30 | Geography type of the fourth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE4 | VARCHAR2 | 360 | Geography name of the fourth element of the Bill from location | ||
| BILL_FROM_GEOGRAPHY_TYPE5 | VARCHAR2 | 30 | Geography type of the fifth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE5 | VARCHAR2 | 360 | Geography name of the fifth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE6 | VARCHAR2 | 30 | Geography type of the sixth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE6 | VARCHAR2 | 360 | Geography name of the sixth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE7 | VARCHAR2 | 30 | Geography type of the seventh element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE7 | VARCHAR2 | 360 | Geography name of the seventh element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE8 | VARCHAR2 | 30 | Geography type of the eighth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE8 | VARCHAR2 | 360 | Geography name of the eighth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE9 | VARCHAR2 | 30 | Geography type of the nineth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE9 | VARCHAR2 | 360 | Geography name of the nineth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_TYPE10 | VARCHAR2 | 30 | Geography type of the tenth element of the Bill From location | ||
| BILL_FROM_GEOGRAPHY_VALUE10 | VARCHAR2 | 360 | Geography name of the tenth element of the Bill From location | ||
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | |
| SHIP_TO_PARTY_NUMBER | VARCHAR2 | 30 | Number of the ship to party | ||
| SHIP_TO_PARTY_NAME | VARCHAR2 | 360 | Name of the ship to party | ||
| SHIP_FROM_PARTY_NUMBER | VARCHAR2 | 30 | Number of the ship from party | ||
| SHIP_FROM_PARTY_NAME | VARCHAR2 | 360 | Name of the ship from party | ||
| BILL_TO_PARTY_NUMBER | VARCHAR2 | 30 | Number of the bill to party | ||
| BILL_TO_PARTY_NAME | VARCHAR2 | 360 | Name of the bill to party | ||
| BILL_FROM_PARTY_NUMBER | VARCHAR2 | 30 | Number of the bill from party | ||
| BILL_FROM_PARTY_NAME | VARCHAR2 | 360 | Name of the bill from party |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| ZX_PTNR_LOCATION_INFO_GT_U1 | Unique | EVENT_CLASS_MAPPING_ID, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE |