[Home] [Help] [Dependency Information]
Object Name: | WSH_CC_TRANS_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | WSH |
FND Design Data: | WSH.WSH_CC_TRANS_HEADERS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_HEADER_ID | NUMBER | Yes | Primary Key of the table | |
TRANSACTION_CONTROL_ID | NUMBER | Yes | Foreign key references WSH_CC_TRANS_CONTROL.TRANSACTION_CONTROL_ID | |
ORIGINAL_SYSTEM_REFERENCE | NUMBER | Yes | Reference Number eg Order Header id (OM) | |
SHIP_FROM_ORG_ID | NUMBER | Ship From org identifier | ||
SHIP_TO_ORG_ID | NUMBER | Ship to org identifier | ||
INVOICE_TO_ORG_ID | NUMBER | Invoice to Org Identifier | ||
SOLD_TO_ORG_ID | NUMBER | Sold to Org identifier | ||
SF_COUNTRY | VARCHAR2 | (35) | Ship from country | |
ST_COUNTRY | VARCHAR2 | (35) | Ship to country | |
SF_PARTY_NAME | VARCHAR2 | (240) | Ship From Party Name | |
SF_PARTY_ADDRESS | VARCHAR2 | (2000) | Ship from Party Address | |
SF_PARTY_CITY | VARCHAR2 | (240) | Ship from Party City | |
SF_PARTY_STATE | VARCHAR2 | (240) | Ship from party State | |
SF_PARTY_COUNTRY | VARCHAR2 | (240) | Ship From Party Country | |
SF_POSTAL_CODE | VARCHAR2 | (240) | Ship from postal code | |
ST_PARTY_NAME | VARCHAR2 | (240) | Ship to party name | |
ST_PARTY_ADDRESS | VARCHAR2 | (2000) | Ship to Party Address | |
ST_PARTY_CITY | VARCHAR2 | (240) | Ship to Party City | |
ST_PARTY_STATE | VARCHAR2 | (240) | Ship to party state | |
ST_PARTY_COUNTRY | VARCHAR2 | (240) | Ship to party country | |
ST_POSTAL_CODE | VARCHAR2 | (240) | Ship to postal code | |
IT_PARTY_NAME | VARCHAR2 | (240) | Invoice to Party Name | |
IT_PARTY_ADDRESS | VARCHAR2 | (2000) | Invoice to Party Address | |
IT_PARTY_CITY | VARCHAR2 | (240) | Invoice to party City | |
IT_PARTY_STATE | VARCHAR2 | (240) | Invoice to Party State | |
IT_PARTY_COUNTRY | VARCHAR2 | (240) | Invoice to Party Country | |
IT_POSTAL_CODE | VARCHAR2 | (240) | Invoice to Postal Code | |
CUST_PARTY_NAME | VARCHAR2 | (240) | Customer name | |
CUST_PARTY_COUNTRY | VARCHAR2 | (240) | Customer Party Country | |
WF_ITEM_KEY | NUMBER | Workflow Item Key | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
SF_CONTACT_NAME | VARCHAR2 | (240) | Ship from contact name | |
SF_PHONE | VARCHAR2 | (240) | Ship From Phone | |
SF_EMAIL | VARCHAR2 | (240) | Ship From email | |
SF_FAX | VARCHAR2 | (240) | Fax Number for Ship from | |
ST_CONTACT_NAME | VARCHAR2 | (240) | Ship to contact name | |
ST_PHONE | VARCHAR2 | (240) | Ship to phone | |
ST_EMAIL | VARCHAR2 | (240) | Ship to email | |
ST_FAX | VARCHAR2 | (240) | Ship to fax | |
IT_CONTACT_NAME | VARCHAR2 | (240) | Invoice to contact name | |
IT_PHONE | VARCHAR2 | (240) | Invoice to Phone | |
IT_EMAIL | VARCHAR2 | (240) | Invoice to email | |
IT_FAX | VARCHAR2 | (240) | Fax Number for Invoice to | |
CUST_PARTY_ADDRESS | VARCHAR2 | (240) | Customer address | |
CUST_PARTY_CITY | VARCHAR2 | (240) | City for the customer | |
CUST_PARTY_STATE | VARCHAR2 | (240) | Customer State | |
CUST_POSTAL_CODE | VARCHAR2 | (240) | Postal Code for Customer | |
CUST_CONTACT_NAME | VARCHAR2 | (240) | Customer Contact Name | |
CUST_PHONE | VARCHAR2 | (240) | Customer Phone Number | |
CUST_EMAIL | VARCHAR2 | (240) | Customer's email | |
CUST_FAX | VARCHAR2 | (240) | Customer's fax Number | |
CREATION_DATE | DATE | Standard Who Columns | ||
CREATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_DATE | DATE | Standard Who Columns | ||
LAST_UPDATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
DELIVER_TO_ORG_ID | NUMBER | Deliver to Org id | ||
DT_PARTY_NAME | VARCHAR2 | (240) | Deliver to party name | |
DT_PARTY_ADDRESS | VARCHAR2 | (2000) | Deliver to party Address | |
DT_PARTY_CITY | VARCHAR2 | (240) | Deliver to Party City | |
DT_PARTY_STATE | VARCHAR2 | (240) | Deliver to party state | |
DT_PARTY_COUNTRY | VARCHAR2 | (240) | Deliver to Party Country | |
DT_POSTAL_CODE | VARCHAR2 | (240) | Deliver to Postal Code | |
DT_CONTACT_NAME | VARCHAR2 | (240) | Delivery to contact name | |
DT_PHONE | VARCHAR2 | (240) | Deliver to Phone | |
DT_EMAIL | VARCHAR2 | (240) | Deliver to email | |
DT_FAX | VARCHAR2 | (240) | Deliver to fax |
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;
WSH.WSH_CC_TRANS_HEADERS does not reference any database object
WSH.WSH_CC_TRANS_HEADERS is referenced by following:
|
|
|