[Home] [Help] [Dependency Information]
Object Name: | SO_HEADERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OE |
FND Design Data: | OE.SO_HEADERS_ALL |
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: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SO_HEADERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | HEADER_ID |
SO_HEADERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORDER_NUMBER
ORDER_TYPE_ID |
SO_HEADERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CUSTOMER_ID |
SO_HEADERS_N10 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WH_UPDATE_DATE |
SO_HEADERS_N12 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPGRADE_FLAG |
SO_HEADERS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OPEN_FLAG |
SO_HEADERS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PURCHASE_ORDER_NUM |
SO_HEADERS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INVOICE_TO_SITE_USE_ID |
SO_HEADERS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | S1 |
SO_HEADERS_N7 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | S4 |
SO_HEADERS_N8 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | S6 |
SO_HEADERS_N9 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORIGINAL_SYSTEM_REFERENCE
ORIGINAL_SYSTEM_SOURCE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | System-generated ID | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent request that last updated row | ||
PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program which last updated row | ||
PROGRAM_ID | NUMBER | Concurrent program that last updated row | ||
PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
ORDER_NUMBER | NUMBER | Yes | User-visible number of order | |
ORDER_CATEGORY | VARCHAR2 | (30) | Yes | Identifies whether the order is a regular order, return or internal sales order |
ORIGINAL_SYSTEM_SOURCE_CODE | VARCHAR2 | (30) | OrderImport source | |
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | OrderImport original source order number | |
SOURCE_HEADER_ID | NUMBER | The HEADER_ID of the order from which this order was copied | ||
ORDER_TYPE_ID | NUMBER | Yes | Order type | |
CYCLE_ID | NUMBER | Yes | Order cycle this order will follow | |
DATE_ORDERED | DATE | Date order was placed | ||
OPEN_FLAG | VARCHAR2 | (1) | Indicates whether the order is open | |
CANCELLED_FLAG | VARCHAR2 | (1) | Indicates whether the entire order is canceled | |
CUSTOMER_ID | NUMBER | Sold-to customer | ||
ORDERED_BY_CONTACT_ID | NUMBER | Contact that placed the order | ||
SHIP_TO_SITE_USE_ID | NUMBER | Order level ship-to customer/address | ||
SHIP_TO_CONTACT_ID | NUMBER | Contact for shipping | ||
INVOICE_TO_SITE_USE_ID | NUMBER | Order level invoice-to customer/address | ||
INVOICE_TO_CONTACT_ID | NUMBER | Contact for invoicing | ||
PURCHASE_ORDER_NUM | VARCHAR2 | (50) | Customer purchase order number | |
DATE_REQUESTED_CURRENT | DATE | Customer request date | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority | |
SHIP_METHOD_CODE | VARCHAR2 | (30) | Freight carrier | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms | |
FOB_CODE | VARCHAR2 | (30) | Point of ownership transfer | |
SHIP_PARTIAL_FLAG | VARCHAR2 | (1) | Indicates whether all items on the order must ship together or can ship separately | |
WAREHOUSE_ID | NUMBER | Warehouse (Organization) | ||
DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class | |
SHIPPING_INSTRUCTIONS | VARCHAR2 | (240) | Special shipping instructions | |
PACKING_INSTRUCTIONS | VARCHAR2 | (240) | Special packing instructions | |
AGREEMENT_ID | NUMBER | Agreement associated with order | ||
SALESREP_ID | NUMBER | Primary saleperson | ||
SALES_CHANNEL_CODE | VARCHAR2 | (30) | Sales channel through which order was placed | |
PRICE_LIST_ID | NUMBER | Price list for order lines | ||
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency for the order |
CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Currency conversion type | |
CONVERSION_RATE | NUMBER | Rate of currency conversion | ||
CONVERSION_DATE | DATE | Date of currency conversion | ||
TERMS_ID | NUMBER | Payment terms | ||
INVOICING_RULE_ID | NUMBER | Invoicing rule | ||
ACCOUNTING_RULE_ID | NUMBER | Accounting rule | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax-exempt indicator | |
TAX_EXEMPT_NUM | VARCHAR2 | (80) | Tax exemption certificate number | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exemption reason | |
PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Type of payment for order | |
PAYMENT_AMOUNT | NUMBER | Amount being paid | ||
CHECK_NUMBER | VARCHAR2 | (50) | Check number | |
CREDIT_CARD_CODE | VARCHAR2 | (30) | Credit card name | |
CREDIT_CARD_HOLDER_NAME | VARCHAR2 | (50) | Credit card cardholder name | |
CREDIT_CARD_NUMBER | VARCHAR2 | (50) | Credit card number | |
CREDIT_CARD_EXPIRATION_DATE | DATE | Credit card expiration date | ||
CREDIT_CARD_APPROVAL_CODE | VARCHAR2 | (50) | Credit card approval code | |
ORG_ID | NUMBER | Operating unit which performed this transaction | ||
WH_UPDATE_DATE | DATE | Used by Data Warehousing to determine whether any changes have occurred | ||
DATE_SVRID | NUMBER | Standard value rule from which DATE_ORDERED is derived. | ||
ENTRY_STATUS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
TYPE_SVRID | NUMBER | Standard value rule from which Order Type is derived | ||
CUSTOMER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CONTACT_SVRID | NUMBER | Standard value rule from which Ordered By Contact is derived | ||
SHIP_TO_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SHIP_TO_CONTACT_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
INVOICE_TO_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
INVOICE_TO_CONTACT_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
AGREEMENT_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PO_NUMBER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
REQUEST_DATE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SALESPERSON_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SALES_CHANNEL_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PRICE_LIST_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CURRENCY_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CONVERSION_TYPE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CONVERSION_DATE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CONVERSION_RATE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
INVOICING_RULE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
ACCOUNTING_RULE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PAYMENT_TERMS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
TAX_EXEMPT_NUMBER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
TAX_EXEMPT_REASON_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SHIPMENT_PRIORITY_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
FREIGHT_CARRIER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
FREIGHT_TERMS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
FOB_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SHIP_PARTIAL_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
WAREHOUSE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
DEMAND_CLASS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PACKING_INSTRUCTIONS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
SHIPPING_INSTRUCTIONS_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PAYMENT_TYPE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
PAYMENT_AMOUNT_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CHECK_NUMBER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CREDIT_CARD_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CREDIT_CARD_HOLDER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CREDIT_CARD_NUMBER_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CREDIT_CARD_EXP_DATE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
CREDIT_CARD_APP_CODE_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
DF_SVRID | NUMBER | Standard value rule from which attribute is derived | ||
S1 | NUMBER | Entry action status column | ||
S1_DATE | DATE | Entry action status date column | ||
S2 | NUMBER | Cycle action status column | ||
S2_DATE | DATE | Cycle action status date column | ||
S3 | NUMBER | Cycle action status column | ||
S3_DATE | DATE | Cycle action status date column | ||
S4 | NUMBER | Cancel Order action status column | ||
S4_DATE | DATE | Cancel Order action status date column | ||
S5 | NUMBER | Cycle action status column | ||
S5_DATE | DATE | Cycle action status date column | ||
S6 | NUMBER | Complete Order action status column | ||
S6_DATE | DATE | Complete Order action status date column | ||
S7 | NUMBER | Cycle action status column | ||
S7_DATE | DATE | Cycle action status date column | ||
S8 | NUMBER | Cycle action status column | ||
S8_DATE | DATE | Cycle action status date column | ||
S9 | NUMBER | Cycle action status column | ||
S9_DATE | DATE | Cycle action status date column | ||
S10 | NUMBER | Cycle action status column | ||
S10_DATE | DATE | Cycle action status date column | ||
S11 | NUMBER | Cycle action status column | ||
S11_DATE | DATE | Cycle action status date column | ||
S12 | NUMBER | Cycle action status column | ||
S12_DATE | DATE | Cycle action status date column | ||
S13 | NUMBER | Cycle action status column | ||
S13_DATE | DATE | Cycle action status date column | ||
S14 | NUMBER | Cycle action status column | ||
S14_DATE | DATE | Cycle action status date column | ||
S15 | NUMBER | Cycle action status column | ||
S15_DATE | DATE | Cycle action status date column | ||
S16 | NUMBER | Cycle action status column | ||
S16_DATE | DATE | Cycle action status date column | ||
S17 | NUMBER | Cycle action status column | ||
S17_DATE | DATE | Cycle action status date column | ||
S18 | NUMBER | Cycle action status column | ||
S18_DATE | DATE | Cycle action status date column | ||
S19 | NUMBER | Cycle action status column | ||
S19_DATE | DATE | Cycle action status date column | ||
S20 | NUMBER | Cycle action status column | ||
S20_DATE | DATE | Cycle action status date column | ||
S21 | NUMBER | Cycle action status column | ||
S21_DATE | DATE | Cycle action status date column | ||
S22 | NUMBER | Cycle action status column | ||
S22_DATE | DATE | Cycle action status date column | ||
S23 | NUMBER | Cycle action status column | ||
S23_DATE | DATE | Cycle action status date column | ||
S24 | NUMBER | Cycle action status column | ||
S24_DATE | DATE | Cycle action status date column | ||
S25 | NUMBER | Cycle action status column | ||
S25_DATE | DATE | Cycle action status date column | ||
S26 | NUMBER | Cycle action status column | ||
S26_DATE | DATE | Cycle action status date column | ||
S27 | NUMBER | Cycle action status column | ||
S27_DATE | DATE | Cycle action status date column | ||
S28 | NUMBER | Cycle action status column | ||
S28_DATE | DATE | Cycle action status date column | ||
S29 | NUMBER | Cycle action status column | ||
S29_DATE | DATE | Cycle action status date column | ||
S30 | NUMBER | Cycle action status column | ||
S30_DATE | DATE | Cycle action status date column | ||
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
UPGRADE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORDER_NUMBER
, ORDER_CATEGORY
, ORIGINAL_SYSTEM_SOURCE_CODE
, ORIGINAL_SYSTEM_REFERENCE
, SOURCE_HEADER_ID
, ORDER_TYPE_ID
, CYCLE_ID
, DATE_ORDERED
, OPEN_FLAG
, CANCELLED_FLAG
, CUSTOMER_ID
, ORDERED_BY_CONTACT_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID
, INVOICE_TO_SITE_USE_ID
, INVOICE_TO_CONTACT_ID
, PURCHASE_ORDER_NUM
, DATE_REQUESTED_CURRENT
, SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, FOB_CODE
, SHIP_PARTIAL_FLAG
, WAREHOUSE_ID
, DEMAND_CLASS_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, AGREEMENT_ID
, SALESREP_ID
, SALES_CHANNEL_CODE
, PRICE_LIST_ID
, CURRENCY_CODE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE
, CONVERSION_DATE
, TERMS_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUM
, TAX_EXEMPT_REASON_CODE
, PAYMENT_TYPE_CODE
, PAYMENT_AMOUNT
, CHECK_NUMBER
, CREDIT_CARD_CODE
, CREDIT_CARD_HOLDER_NAME
, CREDIT_CARD_NUMBER
, CREDIT_CARD_EXPIRATION_DATE
, CREDIT_CARD_APPROVAL_CODE
, ORG_ID
, WH_UPDATE_DATE
, DATE_SVRID
, ENTRY_STATUS_SVRID
, TYPE_SVRID
, CUSTOMER_SVRID
, CONTACT_SVRID
, SHIP_TO_SVRID
, SHIP_TO_CONTACT_SVRID
, INVOICE_TO_SVRID
, INVOICE_TO_CONTACT_SVRID
, AGREEMENT_SVRID
, PO_NUMBER_SVRID
, REQUEST_DATE_SVRID
, SALESPERSON_SVRID
, SALES_CHANNEL_SVRID
, PRICE_LIST_SVRID
, CURRENCY_SVRID
, CONVERSION_TYPE_SVRID
, CONVERSION_DATE_SVRID
, CONVERSION_RATE_SVRID
, INVOICING_RULE_SVRID
, ACCOUNTING_RULE_SVRID
, PAYMENT_TERMS_SVRID
, TAX_EXEMPT_NUMBER_SVRID
, TAX_EXEMPT_REASON_SVRID
, SHIPMENT_PRIORITY_SVRID
, FREIGHT_CARRIER_SVRID
, FREIGHT_TERMS_SVRID
, FOB_SVRID
, SHIP_PARTIAL_SVRID
, WAREHOUSE_SVRID
, DEMAND_CLASS_SVRID
, PACKING_INSTRUCTIONS_SVRID
, SHIPPING_INSTRUCTIONS_SVRID
, PAYMENT_TYPE_SVRID
, PAYMENT_AMOUNT_SVRID
, CHECK_NUMBER_SVRID
, CREDIT_CARD_SVRID
, CREDIT_CARD_HOLDER_SVRID
, CREDIT_CARD_NUMBER_SVRID
, CREDIT_CARD_EXP_DATE_SVRID
, CREDIT_CARD_APP_CODE_SVRID
, DF_SVRID
, S1
, S1_DATE
, S2
, S2_DATE
, S3
, S3_DATE
, S4
, S4_DATE
, S5
, S5_DATE
, S6
, S6_DATE
, S7
, S7_DATE
, S8
, S8_DATE
, S9
, S9_DATE
, S10
, S10_DATE
, S11
, S11_DATE
, S12
, S12_DATE
, S13
, S13_DATE
, S14
, S14_DATE
, S15
, S15_DATE
, S16
, S16_DATE
, S17
, S17_DATE
, S18
, S18_DATE
, S19
, S19_DATE
, S20
, S20_DATE
, S21
, S21_DATE
, S22
, S22_DATE
, S23
, S23_DATE
, S24
, S24_DATE
, S25
, S25_DATE
, S26
, S26_DATE
, S27
, S27_DATE
, S28
, S28_DATE
, S29
, S29_DATE
, S30
, S30_DATE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, UPGRADE_FLAG
FROM OE.SO_HEADERS_ALL;
OE.SO_HEADERS_ALL does not reference any database object
OE.SO_HEADERS_ALL is referenced by following:
|
|
|