[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ECE_SPSO_HEADERS# |
|---|---|
| Object Type: | VIEW |
| Owner: | EC |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | ||
| TP_TRANSLATOR_CODE | VARCHAR2 | (30) | ||
| TP_DESCRIPTION | VARCHAR2 | (240) | ||
| TRANSACTION_DATE | DATE | |||
| TRANSACTION_CONTROL1 | VARCHAR2 | (80) | ||
| TRANSACTION_CONTROL2 | VARCHAR2 | (80) | ||
| TRANSACTION_CONTROL3 | VARCHAR2 | (80) | ||
| TEST_FLAG | VARCHAR2 | (1) | ||
| TP_REFERENCE_EXT1 | VARCHAR2 | (240) | ||
| TP_REFERENCE_EXT2 | VARCHAR2 | (240) | ||
| COMMUNICATION_METHOD | VARCHAR2 | (30) | Yes | |
| DOCUMENT_ID | VARCHAR2 | (6) | ||
| DOCUMENT_TYPE | VARCHAR2 | (3) | ||
| DOCUMENT_CODE | VARCHAR2 | (20) | ||
| DOCUMENT_PURPOSE_CODE | VARCHAR2 | (2) | ||
| SCHEDULE_ID | NUMBER | |||
| SCHEDULE_TYPE | VARCHAR2 | (25) | ||
| SCHEDULE_SUB_TYPE | VARCHAR2 | (25) | ||
| SCHEDULE_NUMBER_REVISION | VARCHAR2 | (30) | ||
| SCHEDULE_STATUS | VARCHAR2 | (25) | ||
| SCHEDULE_GENERATION_DATE | DATE | |||
| FORECAST_HORIZON_START_DATE | DATE | |||
| FORECAST_HORIZON_END_DATE | DATE | |||
| MULTIPLE_SHIP_TO_ORG_FLAG | VARCHAR2 | (1) | ||
| SHIP_TO_ORG_ENABLE_CUM_FLAG | VARCHAR2 | (1) | ||
| SHIP_TO_ORG_CUM_START_DATE | DATE | |||
| SHIP_TO_ORG_NAME | VARCHAR2 | (240) | ||
| SHIP_TO_ORG_CODE | VARCHAR2 | (10) | ||
| SHIP_TO_ORG_CODE_EXT | VARCHAR2 | (50) | ||
| SHIP_TO_ORG_LOCATION | VARCHAR2 | (60) | ||
| SHIP_TO_ORG_LOCATION_EXT | VARCHAR2 | (60) | ||
| SHIP_TO_ORG_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| SHIP_TO_ORG_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| SHIP_TO_ORG_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| SHIP_TO_ORG_CITY | VARCHAR2 | (30) | ||
| SHIP_TO_ORG_REGION_1 | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_REGION_1_EXT | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_REGION_3 | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_REGION_3_EXT | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_REGION_2 | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_REGION_2_EXT | VARCHAR2 | (120) | ||
| SHIP_TO_ORG_COUNTRY | VARCHAR2 | (60) | ||
| SHIP_TO_ORG_COUNTRY_EXT | VARCHAR2 | (60) | ||
| SHIP_TO_ORG_POSTAL_CODE | VARCHAR2 | (30) | ||
| SHIP_TO_ORG_TELEPHONE | VARCHAR2 | (60) | ||
| SUPPLIER_NAME | VARCHAR2 | (240) | ||
| SUPPLIER_SITE_ADDRESS_LINE_4 | VARCHAR2 | (240) | ||
| SUPPLIER_NUMBER | VARCHAR2 | (30) | ||
| SUPPLIER_NUMBER_EXT | VARCHAR2 | (30) | ||
| SUPPLIER_SITE_CODE | VARCHAR2 | (15) | ||
| SUPPLIER_SITE_CODE_EXT | VARCHAR2 | (50) | ||
| SUPPLIER_SITE_ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
| SUPPLIER_SITE_ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
| SUPPLIER_SITE_ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
| SUPPLIER_SITE_CITY | VARCHAR2 | (25) | ||
| SUPPLIER_SITE_STATE | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_STATE_EXT | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_POSTAL_CODE | VARCHAR2 | (20) | ||
| SUPPLIER_SITE_PROVINCE | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_PROVINCE_EXT | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_COUNTRY | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_COUNTRY_EXT | VARCHAR2 | (150) | ||
| SUPPLIER_SITE_AREA_CODE | VARCHAR2 | (10) | ||
| SUPPLIER_SITE_TELEPHONE | VARCHAR2 | (15) | ||
| SCH_HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| SCH_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| SCH_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| VENDOR_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| VENDOR_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| VENDOR_SITE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| VENDOR_SITE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| SHIP_ORG_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ORG_OPT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ORG_OPT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| TPH_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| TPH_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| TPD_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| TPD_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| TPD_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| TPD_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| TPD_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| TPD_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| RUN_ID | NUMBER | |||
| TRANSACTION_RECORD_ID | NUMBER | |||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| DOCUMENT_STANDARD | VARCHAR2 | (30) | ||
| MAP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TP_LOCATION_CODE_EXT
, TP_TRANSLATOR_CODE
, TP_DESCRIPTION
, TRANSACTION_DATE
, TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3
, TEST_FLAG
, TP_REFERENCE_EXT1
, TP_REFERENCE_EXT2
, COMMUNICATION_METHOD
, DOCUMENT_ID
, DOCUMENT_TYPE
, DOCUMENT_CODE
, DOCUMENT_PURPOSE_CODE
, SCHEDULE_ID
, SCHEDULE_TYPE
, SCHEDULE_SUB_TYPE
, SCHEDULE_NUMBER_REVISION
, SCHEDULE_STATUS
, SCHEDULE_GENERATION_DATE
, FORECAST_HORIZON_START_DATE
, FORECAST_HORIZON_END_DATE
, MULTIPLE_SHIP_TO_ORG_FLAG
, SHIP_TO_ORG_ENABLE_CUM_FLAG
, SHIP_TO_ORG_CUM_START_DATE
, SHIP_TO_ORG_NAME
, SHIP_TO_ORG_CODE
, SHIP_TO_ORG_CODE_EXT
, SHIP_TO_ORG_LOCATION
, SHIP_TO_ORG_LOCATION_EXT
, SHIP_TO_ORG_ADDRESS_LINE_1
, SHIP_TO_ORG_ADDRESS_LINE_2
, SHIP_TO_ORG_ADDRESS_LINE_3
, SHIP_TO_ORG_CITY
, SHIP_TO_ORG_REGION_1
, SHIP_TO_ORG_REGION_1_EXT
, SHIP_TO_ORG_REGION_3
, SHIP_TO_ORG_REGION_3_EXT
, SHIP_TO_ORG_REGION_2
, SHIP_TO_ORG_REGION_2_EXT
, SHIP_TO_ORG_COUNTRY
, SHIP_TO_ORG_COUNTRY_EXT
, SHIP_TO_ORG_POSTAL_CODE
, SHIP_TO_ORG_TELEPHONE
, SUPPLIER_NAME
, SUPPLIER_SITE_ADDRESS_LINE_4
, SUPPLIER_NUMBER
, SUPPLIER_NUMBER_EXT
, SUPPLIER_SITE_CODE
, SUPPLIER_SITE_CODE_EXT
, SUPPLIER_SITE_ADDRESS_LINE_1
, SUPPLIER_SITE_ADDRESS_LINE_2
, SUPPLIER_SITE_ADDRESS_LINE_3
, SUPPLIER_SITE_CITY
, SUPPLIER_SITE_STATE
, SUPPLIER_SITE_STATE_EXT
, SUPPLIER_SITE_POSTAL_CODE
, SUPPLIER_SITE_PROVINCE
, SUPPLIER_SITE_PROVINCE_EXT
, SUPPLIER_SITE_COUNTRY
, SUPPLIER_SITE_COUNTRY_EXT
, SUPPLIER_SITE_AREA_CODE
, SUPPLIER_SITE_TELEPHONE
, SCH_HEADER_ATTRIBUTE_CATEGORY
, SCH_HEADER_ATTRIBUTE1
, SCH_HEADER_ATTRIBUTE2
, SCH_HEADER_ATTRIBUTE3
, SCH_HEADER_ATTRIBUTE4
, SCH_HEADER_ATTRIBUTE5
, SCH_HEADER_ATTRIBUTE6
, SCH_HEADER_ATTRIBUTE7
, SCH_HEADER_ATTRIBUTE8
, SCH_HEADER_ATTRIBUTE9
, SCH_HEADER_ATTRIBUTE10
, SCH_HEADER_ATTRIBUTE11
, SCH_HEADER_ATTRIBUTE12
, SCH_HEADER_ATTRIBUTE13
, SCH_HEADER_ATTRIBUTE14
, SCH_HEADER_ATTRIBUTE15
, VENDOR_ATTRIBUTE_CATEGORY
, VENDOR_ATTRIBUTE1
, VENDOR_ATTRIBUTE2
, VENDOR_ATTRIBUTE3
, VENDOR_ATTRIBUTE4
, VENDOR_ATTRIBUTE5
, VENDOR_ATTRIBUTE6
, VENDOR_ATTRIBUTE7
, VENDOR_ATTRIBUTE8
, VENDOR_ATTRIBUTE9
, VENDOR_ATTRIBUTE10
, VENDOR_ATTRIBUTE11
, VENDOR_ATTRIBUTE12
, VENDOR_ATTRIBUTE13
, VENDOR_ATTRIBUTE14
, VENDOR_ATTRIBUTE15
, VENDOR_SITE_ATTRIBUTE_CATEGORY
, VENDOR_SITE_ATTRIBUTE1
, VENDOR_SITE_ATTRIBUTE2
, VENDOR_SITE_ATTRIBUTE3
, VENDOR_SITE_ATTRIBUTE4
, VENDOR_SITE_ATTRIBUTE5
, VENDOR_SITE_ATTRIBUTE6
, VENDOR_SITE_ATTRIBUTE7
, VENDOR_SITE_ATTRIBUTE8
, VENDOR_SITE_ATTRIBUTE9
, VENDOR_SITE_ATTRIBUTE10
, VENDOR_SITE_ATTRIBUTE11
, VENDOR_SITE_ATTRIBUTE12
, VENDOR_SITE_ATTRIBUTE13
, VENDOR_SITE_ATTRIBUTE14
, VENDOR_SITE_ATTRIBUTE15
, SHIP_ORG_ATTRIBUTE_CATEGORY
, SHIP_ORG_ATTRIBUTE1
, SHIP_ORG_ATTRIBUTE2
, SHIP_ORG_ATTRIBUTE3
, SHIP_ORG_ATTRIBUTE4
, SHIP_ORG_ATTRIBUTE5
, SHIP_ORG_ATTRIBUTE6
, SHIP_ORG_ATTRIBUTE7
, SHIP_ORG_ATTRIBUTE8
, SHIP_ORG_ATTRIBUTE9
, SHIP_ORG_ATTRIBUTE10
, SHIP_ORG_ATTRIBUTE11
, SHIP_ORG_ATTRIBUTE12
, SHIP_ORG_ATTRIBUTE13
, SHIP_ORG_ATTRIBUTE14
, SHIP_ORG_ATTRIBUTE15
, ORG_OPT_ATTRIBUTE_CATEGORY
, ORG_OPT_ATTRIBUTE1
, ORG_OPT_ATTRIBUTE2
, ORG_OPT_ATTRIBUTE3
, ORG_OPT_ATTRIBUTE4
, ORG_OPT_ATTRIBUTE5
, ORG_OPT_ATTRIBUTE6
, ORG_OPT_ATTRIBUTE7
, ORG_OPT_ATTRIBUTE8
, ORG_OPT_ATTRIBUTE9
, ORG_OPT_ATTRIBUTE10
, ORG_OPT_ATTRIBUTE11
, ORG_OPT_ATTRIBUTE12
, ORG_OPT_ATTRIBUTE13
, ORG_OPT_ATTRIBUTE14
, ORG_OPT_ATTRIBUTE15
, TPH_ATTRIBUTE_CATEGORY
, TPH_ATTRIBUTE1
, TPH_ATTRIBUTE2
, TPH_ATTRIBUTE3
, TPH_ATTRIBUTE4
, TPH_ATTRIBUTE5
, TPH_ATTRIBUTE6
, TPH_ATTRIBUTE7
, TPH_ATTRIBUTE8
, TPH_ATTRIBUTE9
, TPH_ATTRIBUTE10
, TPH_ATTRIBUTE11
, TPH_ATTRIBUTE12
, TPH_ATTRIBUTE13
, TPH_ATTRIBUTE14
, TPH_ATTRIBUTE15
, TPD_ATTRIBUTE_CATEGORY
, TPD_ATTRIBUTE1
, TPD_ATTRIBUTE2
, TPD_ATTRIBUTE3
, TPD_ATTRIBUTE4
, TPD_ATTRIBUTE5
, RUN_ID
, 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
, DOCUMENT_STANDARD
, MAP_ID
FROM EC.ECE_SPSO_HEADERS#;
EC
ECE_SPSO_HEADERS
APPS
ECE_SPSO_HEADERS
|
|
|
|