[Home] [Help] [Dependency Information]
Object Name: | ECE_ADVO_HEADERS# |
---|---|
Object Type: | VIEW |
Owner: | EC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADVICE_HEADER_ID | NUMBER | Yes | ||
TP_HEADER_ID | NUMBER | |||
COMMUNICATION_METHOD | VARCHAR2 | (20) | ||
DOCUMENT_TYPE | VARCHAR2 | (25) | ||
DOCUMENT_CODE | VARCHAR2 | (2) | ||
TRANSACTION_DATE | DATE | |||
TRANSACTION_CONTROL1 | VARCHAR2 | (10) | ||
TRANSACTION_CONTROL2 | VARCHAR2 | (10) | ||
TRANSACTION_CONTROL3 | VARCHAR2 | (10) | ||
EDI_PROCESSED_FLAG | VARCHAR2 | (1) | ||
EDI_PROCESS_DATE | DATE | |||
RELATED_DOCUMENT_ID | VARCHAR2 | (6) | ||
EXTERNAL_REFERENCE1 | VARCHAR2 | (80) | ||
EXTERNAL_REFERENCE2 | VARCHAR2 | (80) | ||
EXTERNAL_REFERENCE3 | VARCHAR2 | (80) | ||
EXTERNAL_REFERENCE4 | VARCHAR2 | (80) | ||
EXTERNAL_REFERENCE5 | VARCHAR2 | (80) | ||
EXTERNAL_REFERENCE6 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE1 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE2 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE3 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE4 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE5 | VARCHAR2 | (80) | ||
INTERNAL_REFERENCE6 | VARCHAR2 | (80) | ||
TP_LOCATION_CODE_EXT | VARCHAR2 | (35) | ||
TP_ENTITY_TYPE | VARCHAR2 | (30) | ||
TP_CODE | VARCHAR2 | (240) | ||
TP_NAME | VARCHAR2 | (50) | ||
TP_ADDRESS1 | VARCHAR2 | (240) | ||
TP_ADDRESS2 | VARCHAR2 | (240) | ||
TP_ADDRESS3 | VARCHAR2 | (240) | ||
TP_ADDRESS4 | VARCHAR2 | (240) | ||
TP_CITY | VARCHAR2 | (60) | ||
TP_POSTAL_CODE | VARCHAR2 | (60) | ||
TP_COUNTRY | VARCHAR2 | (60) | ||
TP_STATE | VARCHAR2 | (60) | ||
TP_PROVINCE | VARCHAR2 | (60) | ||
TP_COUNTY | VARCHAR2 | (60) | ||
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) | ||
SECURITY_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADVICE_HEADER_ID
, TP_HEADER_ID
, COMMUNICATION_METHOD
, DOCUMENT_TYPE
, DOCUMENT_CODE
, TRANSACTION_DATE
, TRANSACTION_CONTROL1
, TRANSACTION_CONTROL2
, TRANSACTION_CONTROL3
, EDI_PROCESSED_FLAG
, EDI_PROCESS_DATE
, RELATED_DOCUMENT_ID
, EXTERNAL_REFERENCE1
, EXTERNAL_REFERENCE2
, EXTERNAL_REFERENCE3
, EXTERNAL_REFERENCE4
, EXTERNAL_REFERENCE5
, EXTERNAL_REFERENCE6
, INTERNAL_REFERENCE1
, INTERNAL_REFERENCE2
, INTERNAL_REFERENCE3
, INTERNAL_REFERENCE4
, INTERNAL_REFERENCE5
, INTERNAL_REFERENCE6
, TP_LOCATION_CODE_EXT
, TP_ENTITY_TYPE
, TP_CODE
, TP_NAME
, TP_ADDRESS1
, TP_ADDRESS2
, TP_ADDRESS3
, TP_ADDRESS4
, TP_CITY
, TP_POSTAL_CODE
, TP_COUNTRY
, TP_STATE
, TP_PROVINCE
, TP_COUNTY
, 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
, SECURITY_GROUP_ID
FROM EC.ECE_ADVO_HEADERS#;
|
|
|