[Home] [Help] [Dependency Information]
Object Name: | WSH_CC_TRANS_HEADERS# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | Yes | ||
TRANSACTION_CONTROL_ID | NUMBER | Yes | ||
ORIGINAL_SYSTEM_REFERENCE | NUMBER | Yes | ||
SHIP_FROM_ORG_ID | NUMBER | |||
SHIP_TO_ORG_ID | NUMBER | |||
INVOICE_TO_ORG_ID | NUMBER | |||
SOLD_TO_ORG_ID | NUMBER | |||
SF_COUNTRY | VARCHAR2 | (35) | ||
ST_COUNTRY | VARCHAR2 | (35) | ||
SF_PARTY_NAME | VARCHAR2 | (240) | ||
SF_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
SF_PARTY_CITY | VARCHAR2 | (240) | ||
SF_PARTY_STATE | VARCHAR2 | (240) | ||
SF_PARTY_COUNTRY | VARCHAR2 | (240) | ||
SF_POSTAL_CODE | VARCHAR2 | (240) | ||
ST_PARTY_NAME | VARCHAR2 | (240) | ||
ST_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
ST_PARTY_CITY | VARCHAR2 | (240) | ||
ST_PARTY_STATE | VARCHAR2 | (240) | ||
ST_PARTY_COUNTRY | VARCHAR2 | (240) | ||
ST_POSTAL_CODE | VARCHAR2 | (240) | ||
IT_PARTY_NAME | VARCHAR2 | (240) | ||
IT_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
IT_PARTY_CITY | VARCHAR2 | (240) | ||
IT_PARTY_STATE | VARCHAR2 | (240) | ||
IT_PARTY_COUNTRY | VARCHAR2 | (240) | ||
IT_POSTAL_CODE | VARCHAR2 | (240) | ||
CUST_PARTY_NAME | VARCHAR2 | (240) | ||
CUST_PARTY_COUNTRY | VARCHAR2 | (240) | ||
WF_ITEM_KEY | NUMBER | |||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
SF_CONTACT_NAME | VARCHAR2 | (240) | ||
SF_PHONE | VARCHAR2 | (240) | ||
SF_EMAIL | VARCHAR2 | (240) | ||
SF_FAX | VARCHAR2 | (240) | ||
ST_CONTACT_NAME | VARCHAR2 | (240) | ||
ST_PHONE | VARCHAR2 | (240) | ||
ST_EMAIL | VARCHAR2 | (240) | ||
ST_FAX | VARCHAR2 | (240) | ||
IT_CONTACT_NAME | VARCHAR2 | (240) | ||
IT_PHONE | VARCHAR2 | (240) | ||
IT_EMAIL | VARCHAR2 | (240) | ||
IT_FAX | VARCHAR2 | (240) | ||
CUST_PARTY_ADDRESS | VARCHAR2 | (240) | ||
CUST_PARTY_CITY | VARCHAR2 | (240) | ||
CUST_PARTY_STATE | VARCHAR2 | (240) | ||
CUST_POSTAL_CODE | VARCHAR2 | (240) | ||
CUST_CONTACT_NAME | VARCHAR2 | (240) | ||
CUST_PHONE | VARCHAR2 | (240) | ||
CUST_EMAIL | VARCHAR2 | (240) | ||
CUST_FAX | VARCHAR2 | (240) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
DELIVER_TO_ORG_ID | NUMBER | |||
DT_PARTY_NAME | VARCHAR2 | (240) | ||
DT_PARTY_ADDRESS | VARCHAR2 | (2000) | ||
DT_PARTY_CITY | VARCHAR2 | (240) | ||
DT_PARTY_STATE | VARCHAR2 | (240) | ||
DT_PARTY_COUNTRY | VARCHAR2 | (240) | ||
DT_POSTAL_CODE | VARCHAR2 | (240) | ||
DT_CONTACT_NAME | VARCHAR2 | (240) | ||
DT_PHONE | VARCHAR2 | (240) | ||
DT_EMAIL | VARCHAR2 | (240) | ||
DT_FAX | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_HEADER_ID
, TRANSACTION_CONTROL_ID
, ORIGINAL_SYSTEM_REFERENCE
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID
, SOLD_TO_ORG_ID
, SF_COUNTRY
, ST_COUNTRY
, SF_PARTY_NAME
, SF_PARTY_ADDRESS
, SF_PARTY_CITY
, SF_PARTY_STATE
, SF_PARTY_COUNTRY
, SF_POSTAL_CODE
, ST_PARTY_NAME
, ST_PARTY_ADDRESS
, ST_PARTY_CITY
, ST_PARTY_STATE
, ST_PARTY_COUNTRY
, ST_POSTAL_CODE
, IT_PARTY_NAME
, IT_PARTY_ADDRESS
, IT_PARTY_CITY
, IT_PARTY_STATE
, IT_PARTY_COUNTRY
, IT_POSTAL_CODE
, CUST_PARTY_NAME
, CUST_PARTY_COUNTRY
, WF_ITEM_KEY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SF_CONTACT_NAME
, SF_PHONE
, SF_EMAIL
, SF_FAX
, ST_CONTACT_NAME
, ST_PHONE
, ST_EMAIL
, ST_FAX
, IT_CONTACT_NAME
, IT_PHONE
, IT_EMAIL
, IT_FAX
, CUST_PARTY_ADDRESS
, CUST_PARTY_CITY
, CUST_PARTY_STATE
, CUST_POSTAL_CODE
, CUST_CONTACT_NAME
, CUST_PHONE
, CUST_EMAIL
, CUST_FAX
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELIVER_TO_ORG_ID
, DT_PARTY_NAME
, DT_PARTY_ADDRESS
, DT_PARTY_CITY
, DT_PARTY_STATE
, DT_PARTY_COUNTRY
, DT_POSTAL_CODE
, DT_CONTACT_NAME
, DT_PHONE
, DT_EMAIL
, DT_FAX
FROM WSH.WSH_CC_TRANS_HEADERS#;
|
|
|