[Home] [Help] [Dependency Information]
Object Name: | ASO_I_OE_ORDER_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_OE_ORDER_HEADERS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | Order Header Id | |
ORG_ID | NUMBER | Organization identifier | ||
ORDER_TYPE_ID | NUMBER | Yes | type of order | |
ORDER_NUMBER | NUMBER | Yes | user visible number of the order | |
VERSION_NUMBER | NUMBER | Yes | Order version number. Order number and version is a unique key in this table | |
EXPIRATION_DATE | DATE | date of expiration | ||
ORDER_SOURCE_ID | NUMBER | |||
SOURCE_DOCUMENT_TYPE_ID | NUMBER | |||
ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Order import original source order number | |
SOURCE_DOCUMENT_ID | NUMBER | |||
ORDERED_DATE | DATE | Date order was placed | ||
REQUEST_DATE | DATE | Customer request date | ||
PRICING_DATE | DATE | Date order was priced | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority | |
DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class | |
PRICE_LIST_ID | NUMBER | Price list for order lines | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax-exempt indicator | |
TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exemption certificate number | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exemption reason | |
CONVERSION_RATE | NUMBER | Rate of currency conversion | ||
CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Currency conversion type | |
CONVERSION_RATE_DATE | DATE | Date of currency conversion | ||
PARTIAL_SHIPMENTS_ALLOWED | VARCHAR2 | (1) | Indicates whether all items on the order must ship together or can ship seperately | |
SHIP_TOLERANCE_ABOVE | NUMBER | |||
SHIP_TOLERANCE_BELOW | NUMBER | |||
TRANSACTIONAL_CURR_CODE | VARCHAR2 | (15) | Currency for the order | |
AGREEMENT_ID | NUMBER | Agreement associated with the order | ||
TAX_POINT_CODE | VARCHAR2 | (30) | ||
CUST_PO_NUMBER | VARCHAR2 | (50) | Customer Purchase Order Number | |
INVOICING_RULE_ID | NUMBER | (15) | Invoicing rule used by AR for generating invoices | |
ACCOUNTING_RULE_ID | NUMBER | (15) | Accounting rule used by AR for generating invoices | |
PAYMENT_TERM_ID | NUMBER | (15) | payment terms that apply to this order | |
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Freight Carrier and method. Foreign key to table Org_Freight | |
FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight carrier | |
FOB_POINT_CODE | VARCHAR2 | (30) | Point of ownership transfer | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms | |
SOLD_TO_ORG_ID | NUMBER | Sold to organization id | ||
SOLD_FROM_ORG_ID | NUMBER | Sold from organization id | ||
SHIP_FROM_ORG_ID | NUMBER | Ship from organization id - warehouse | ||
SHIP_TO_ORG_ID | NUMBER | Ship to organization id | ||
INVOICE_TO_ORG_ID | NUMBER | Order level invoice to customer/address | ||
DELIVER_TO_ORG_ID | NUMBER | Order level deliver to customer/address | ||
SOLD_TO_CONTACT_ID | NUMBER | Contact for the order | ||
SHIP_TO_CONTACT_ID | NUMBER | Contact for shipping | ||
INVOICE_TO_CONTACT_ID | NUMBER | Contact for invoicing | ||
DELIVER_TO_CONTACT_ID | NUMBER | Deliver to contact | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Globalization specific descriptive flex-field segment | |
CANCELLED_FLAG | VARCHAR2 | (1) | Indicates whether the order has been cancelled ('Y') or not ('N') | |
OPEN_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the order has been closed ('N') or not ('Y') |
BOOKED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the order has been booked ('Y') or not ('N') |
BOOKED_DATE | DATE | date the order was booked | ||
SALESREP_ID | NUMBER | (15) | Primary salesperson | |
RETURN_REASON_CODE | VARCHAR2 | (30) | Return reason code for a return order, and for defaulting to a return line | |
ORDER_DATE_TYPE_CODE | VARCHAR2 | (30) | ||
EARLIEST_SCHEDULE_LIMIT | NUMBER | |||
LATEST_SCHEDULE_LIMIT | NUMBER | |||
PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Type of payment for the order (e.g., cash, credit card, PO) | |
PAYMENT_AMOUNT | NUMBER | Amount being paid | ||
CHECK_NUMBER | VARCHAR2 | (50) | Check number if payment type is Check | |
CREDIT_CARD_CODE | VARCHAR2 | (80) | Credit card name if payment type is Credit | |
CREDIT_CARD_HOLDER_NAME | VARCHAR2 | (80) | Cardholder name of the credit card | |
CREDIT_CARD_NUMBER | VARCHAR2 | (80) | Credit card number | |
CREDIT_CARD_EXPIRATION_DATE | DATE | Credit card expiration date | ||
CREDIT_CARD_APPROVAL_CODE | VARCHAR2 | (80) | Credit card approval code | |
SALES_CHANNEL_CODE | VARCHAR2 | (30) | Sales channel through which order was placed | |
FIRST_ACK_CODE | VARCHAR2 | (30) | ||
FIRST_ACK_DATE | DATE | |||
LAST_ACK_CODE | VARCHAR2 | (30) | ||
LAST_ACK_DATE | DATE | |||
CHANGE_SEQUENCE | VARCHAR2 | (50) | ||
DROP_SHIP_FLAG | VARCHAR2 | (1) | ||
CUSTOMER_PAYMENT_TERM_ID | NUMBER | customer payment term | ||
ORDER_CATEGORY_CODE | VARCHAR2 | (30) | Yes | |
SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
FLOW_STATUS_CODE | VARCHAR2 | (30) | ||
TP_CONTEXT | VARCHAR2 | (30) | Descriptive flex-field segment | |
TP_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flex-field segment | |
TP_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flex-field segment | |
MARKETING_SOURCE_CODE_ID | NUMBER | Campaign that is applied to this order | ||
CREDIT_CARD_APPROVAL_DATE | DATE | date on which credit card was approved |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, ORG_ID
, ORDER_TYPE_ID
, ORDER_NUMBER
, VERSION_NUMBER
, EXPIRATION_DATE
, ORDER_SOURCE_ID
, SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID
, ORDERED_DATE
, REQUEST_DATE
, PRICING_DATE
, SHIPMENT_PRIORITY_CODE
, DEMAND_CLASS_CODE
, PRICE_LIST_ID
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, PARTIAL_SHIPMENTS_ALLOWED
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, TRANSACTIONAL_CURR_CODE
, AGREEMENT_ID
, TAX_POINT_CODE
, CUST_PO_NUMBER
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, PAYMENT_TERM_ID
, SHIPPING_METHOD_CODE
, FREIGHT_CARRIER_CODE
, FOB_POINT_CODE
, FREIGHT_TERMS_CODE
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID
, SOLD_TO_CONTACT_ID
, SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, CANCELLED_FLAG
, OPEN_FLAG
, BOOKED_FLAG
, BOOKED_DATE
, SALESREP_ID
, RETURN_REASON_CODE
, ORDER_DATE_TYPE_CODE
, EARLIEST_SCHEDULE_LIMIT
, LATEST_SCHEDULE_LIMIT
, 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
, SALES_CHANNEL_CODE
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, CHANGE_SEQUENCE
, DROP_SHIP_FLAG
, CUSTOMER_PAYMENT_TERM_ID
, ORDER_CATEGORY_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, FLOW_STATUS_CODE
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, MARKETING_SOURCE_CODE_ID
, CREDIT_CARD_APPROVAL_DATE
FROM APPS.ASO_I_OE_ORDER_HEADERS_V;
|
|
|