[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_LINES_IFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_LINES_IFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
This is a multi-org table for sales order lines open interface. This table stores order lines information that is imported from a feeder system into Oracle Order Management using Order Import.
For more information on Order Import refer to the Oracle Order Management Suite API's and Open Interfaces Manual.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Lines Interface
Category: BUSINESS_ENTITY ONT_SALES_ORDER
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_LINES_IFACE_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
|
| OE_LINES_IFACE_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SHIP_ADDRESS_REF
ORIG_BILL_ADDRESS_REF
ORIG_DELIVER_ADDRESS_REF
|
| OE_LINES_IFACE_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SHIP_TO_CONTACT_REF
BILL_TO_CONTACT_REF
DELIVER_TO_CONTACT_REF
|
| OE_LINES_IFACE_ALL_U1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
ORIG_SYS_SHIPMENT_REF
SOLD_TO_ORG_ID
SOLD_TO_ORG
CHANGE_SEQUENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_SOURCE_ID | NUMBER | Order source id | ||
| ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
| ORIG_SYS_LINE_REF | VARCHAR2 | (50) | Original system line reference | |
| ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Original system shipment reference | |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
| CHANGE_REQUEST_CODE | VARCHAR2 | (30) | Change request code | |
| ORG_ID | NUMBER | Org id | ||
| LINE_NUMBER | NUMBER | Line number | ||
| SHIPMENT_NUMBER | NUMBER | Shipment number | ||
| LINE_ID | NUMBER | Line id | ||
| SPLIT_FROM_LINE_ID | NUMBER | Split from line id | ||
| LINE_TYPE_ID | NUMBER | Line type id | ||
| LINE_TYPE | VARCHAR2 | (30) | Line type | |
| ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code | |
| INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
| INVENTORY_ITEM | VARCHAR2 | (2000) | Inventory Item | |
| TOP_MODEL_LINE_REF | VARCHAR2 | (50) | Top model line reference | |
| LINK_TO_LINE_REF | VARCHAR2 | (50) | Link to line refernce | |
| EXPLOSION_DATE | DATE | Explosion date | ||
| ATO_LINE_ID | NUMBER | ATO line id | ||
| COMPONENT_SEQUENCE_ID | NUMBER | Component sequence id | ||
| COMPONENT_CODE | VARCHAR2 | (1000) | Component code | |
| SORT_ORDER | VARCHAR2 | (2000) | Sort order | |
| MODEL_GROUP_NUMBER | NUMBER | Model group number | ||
| OPTION_NUMBER | NUMBER | Option number | ||
| OPTION_FLAG | VARCHAR2 | (1) | Option flag | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Ship model complete flag | |
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | Source type code | |
| SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Schedule status code | |
| SCHEDULE_SHIP_DATE | DATE | Schedule ship date | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Schedule arrival date | ||
| ACTUAL_ARRIVAL_DATE | DATE | Actual arrival date | ||
| PROMISE_DATE | DATE | Promise date | ||
| SCHEDULE_DATE | DATE | Schedule date | ||
| DELIVERY_LEAD_TIME | NUMBER | Delivery lead time | ||
| DELIVERY_ID | NUMBER | Delivery id | ||
| ORDERED_QUANTITY | NUMBER | Ordered quantity | ||
| ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Order quantity uom | |
| SHIPPING_QUANTITY | NUMBER | Quantity which has been shippedd by Shipping in Shipping UOM | ||
| SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | The UOM for Shipping Quantity. | |
| SHIPPED_QUANTITY | NUMBER | Shipped quantity | ||
| CANCELLED_QUANTITY | NUMBER | Cancelled quantity | ||
| FULFILLED_QUANTITY | NUMBER | The fulfilled quantity for the line | ||
| PRICING_QUANTITY | NUMBER | Pricing quantity | ||
| PRICING_QUANTITY_UOM | VARCHAR2 | (3) | Pricing quantity uom | |
| SOLD_TO_ORG_ID | NUMBER | Sold to org id | ||
| SOLD_TO_ORG | VARCHAR2 | (360) | Sold to org | |
| SHIP_FROM_ORG_ID | NUMBER | Ship from org id | ||
| SHIP_FROM_ORG | VARCHAR2 | (240) | Ship from org | |
| SHIP_TO_ORG_ID | NUMBER | Ship to org id | ||
| SHIP_TO_ORG | VARCHAR2 | (240) | Ship to org | |
| DELIVER_TO_ORG_ID | NUMBER | Deliver to organization id | ||
| DELIVER_TO_ORG | VARCHAR2 | (240) | Deliver to Organization | |
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| INVOICE_TO_ORG | VARCHAR2 | (240) | Invoice To Organization | |
| SHIP_TO_ADDRESS1 | VARCHAR2 | (240) | Ship to address1 | |
| SHIP_TO_ADDRESS2 | VARCHAR2 | (240) | Ship to address2 | |
| SHIP_TO_ADDRESS3 | VARCHAR2 | (240) | Ship to address3 | |
| SHIP_TO_ADDRESS4 | VARCHAR2 | (240) | Ship to address4 | |
| SHIP_TO_CITY | VARCHAR2 | (60) | Ship to city | |
| SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship to county | |
| SHIP_TO_STATE | VARCHAR2 | (60) | Ship to state | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship to postal code | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship to country | |
| SHIP_TO_CONTACT_FIRST_NAME | VARCHAR2 | (150) | Ship to contact first name | |
| SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ship to contact last name | |
| SHIP_TO_CONTACT_JOB_TITLE | VARCHAR2 | (100) | Ship to contact job title | |
| SHIP_TO_CONTACT_AREA_CODE1 | VARCHAR2 | (10) | Ship to contact area code1 | |
| SHIP_TO_CONTACT_AREA_CODE2 | VARCHAR2 | (10) | Ship to contact area code2 | |
| SHIP_TO_CONTACT_AREA_CODE3 | VARCHAR2 | (40) | Ship to contact area code3 | |
| SHIP_TO_CONTACT_ID | NUMBER | Ship to contact id | ||
| SHIP_TO_CONTACT | VARCHAR2 | (360) | Ship to contact | |
| DELIVER_TO_CONTACT_ID | NUMBER | Deliver to contact id | ||
| DELIVER_TO_CONTACT | VARCHAR2 | (360) | Deliver to contact | |
| INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
| INVOICE_TO_CONTACT | VARCHAR2 | (360) | Invoice To Contact | |
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Drop ship flag | |
| VEH_CUS_ITEM_CUM_KEY_ID | NUMBER | Customer item cum key id | ||
| CUST_PRODUCTION_SEQ_NUM | VARCHAR2 | (50) | Customer production sequence number | |
| LOAD_SEQ_NUMBER | NUMBER | Load sequence number | ||
| OVER_SHIP_REASON_CODE | VARCHAR2 | (30) | Over ship reason code | |
| OVER_SHIP_RESOLVED_FLAG | VARCHAR2 | (1) | Over ship resolved flag | |
| AUTHORIZED_TO_SHIP_FLAG | VARCHAR2 | (1) | Authorized to ship flag | |
| SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment/return Tolerance | ||
| SHIP_TOLERANCE_BELOW | NUMBER | Under Shipment/Return Tolerance | ||
| SHIP_SET_ID | NUMBER | Ship set id | ||
| SHIP_SET_NAME | VARCHAR2 | (30) | Ship set name | |
| ARRIVAL_SET_ID | NUMBER | Arrival set id | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | Arrival set name | |
| INVOICE_SET_ID | NUMBER | Invoice set id | ||
| INVOICE_SET_NAME | VARCHAR2 | (30) | Invoice set name | |
| FULFILLMENT_SET_ID | NUMBER | Fulfillment set id | ||
| FULFILLMENT_SET_NAME | VARCHAR2 | (30) | Fulfillment set name | |
| PRICE_LIST_ID | NUMBER | Price list id | ||
| PRICE_LIST | VARCHAR2 | (240) | Price list | |
| PRICING_DATE | DATE | Pricing date | ||
| UNIT_LIST_PRICE | NUMBER | Unit list price | ||
| UNIT_SELLING_PRICE | NUMBER | Unit selling price | ||
| CALCULATE_PRICE_FLAG | VARCHAR2 | (1) | Calculate price flag | |
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| TAX | VARCHAR2 | (50) | Tax | |
| TAX_VALUE | NUMBER | Tax value | ||
| TAX_DATE | DATE | Tax date | ||
| TAX_POINT_CODE | VARCHAR2 | (30) | Tax point code | |
| TAX_POINT | VARCHAR2 | (80) | Tax point | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (30) | Tax exempt flag | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exempt number | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code | |
| TAX_EXEMPT_REASON | VARCHAR2 | (80) | Tax exempt reason | |
| AGREEMENT_ID | NUMBER | Agreement id | ||
| AGREEMENT | VARCHAR2 | (240) | Agreement | |
| INVOICING_RULE_ID | NUMBER | Invoicing rule id used by AR for generating Invoice | ||
| INVOICING_RULE | VARCHAR2 | (30) | Invoicing rule used by AR for generating Invoice | |
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule id used by AR for generating Invoice | ||
| ACCOUNTING_RULE | VARCHAR2 | (30) | Accounting rule used by AR for generating Invoice | |
| PAYMENT_TERM_ID | NUMBER | Payment term id | ||
| PAYMENT_TERM | VARCHAR2 | (30) | Payment term | |
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class code | |
| DEMAND_CLASS | VARCHAR2 | (80) | Demand class | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority code | |
| SHIPMENT_PRIORITY | VARCHAR2 | (80) | Shipment priority | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method code | |
| SHIPPING_METHOD | VARCHAR2 | (80) | Shipping method | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight Carrier code | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms code | |
| FREIGHT_TERMS | VARCHAR2 | (80) | Freight terms | |
| FOB_POINT_CODE | VARCHAR2 | (30) | FOB point code | |
| FOB_POINT | VARCHAR2 | (80) | FOB point | |
| SALESREP_ID | NUMBER | Salesrep id | ||
| SALESREP | VARCHAR2 | (240) | Salesrep | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | Return reason code | |
| REFERENCE_TYPE | VARCHAR2 | (30) | Reference type | |
| REFERENCE_HEADER_ID | NUMBER | Reference header id | ||
| REFERENCE_HEADER | VARCHAR2 | (30) | Reference header | |
| REFERENCE_LINE_ID | NUMBER | Reference line id | ||
| REFERENCE_LINE | VARCHAR2 | (30) | Reference line | |
| CREDIT_INVOICE_LINE_ID | NUMBER | Used for Returns | ||
| CUSTOMER_PO_NUMBER | VARCHAR2 | (50) | Customer PO number | |
| CUSTOMER_LINE_NUMBER | VARCHAR2 | (50) | Customer line number | |
| CUSTOMER_SHIPMENT_NUMBER | VARCHAR2 | (50) | Customer shipment number | |
| CUSTOMER_ITEM_ID | NUMBER | Customer item id | ||
| CUSTOMER_ITEM_ID_TYPE | VARCHAR2 | (30) | Customer item id type | |
| CUSTOMER_ITEM_REVISION | VARCHAR2 | (50) | Customer item revision | |
| CUSTOMER_ITEM_NET_PRICE | NUMBER | Customer item net price | ||
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | Customer payment term id | ||
| CUSTOMER_PAYMENT_TERM | VARCHAR2 | (30) | Customer payment term | |
| DEMAND_BUCKET_TYPE_CODE | VARCHAR2 | (30) | Demand bucket type code | |
| DEMAND_BUCKET_TYPE | VARCHAR2 | (80) | Demand bucket type | |
| SCHEDULE_ITEM_DETAIL | VARCHAR2 | (30) | Schedule item detail | |
| DEMAND_STREAM | VARCHAR2 | (30) | Demand stream | |
| CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | Customer dock code | |
| CUSTOMER_DOCK | VARCHAR2 | (50) | Customer dock | |
| CUSTOMER_JOB | VARCHAR2 | (50) | Customer job | |
| CUSTOMER_PRODUCTION_LINE | VARCHAR2 | (50) | Customer production line | |
| CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (50) | Customer model serial number | |
| PROJECT_ID | NUMBER | Project id | ||
| PROJECT | VARCHAR2 | (30) | Project | |
| TASK_ID | NUMBER | Task id | ||
| TASK | VARCHAR2 | (30) | Task | |
| ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
| CLOSED_FLAG | VARCHAR2 | (1) | Closed flag | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Cancelled flag | |
| CONTRACT_PO_NUMBER | VARCHAR2 | (150) | Contract PO number | |
| LINE_PO_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| 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 | |
| INDUSTRY_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE1 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE2 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE3 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE4 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE5 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE6 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE7 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE8 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE9 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE10 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE11 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE12 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE13 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE14 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE15 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE16 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE17 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE18 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE19 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE20 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE21 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE22 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE23 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE24 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE25 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE26 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE27 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE28 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE29 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE30 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| PRICING_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| RETURN_ATTRIBUTE1 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE2 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE3 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE4 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE5 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE6 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE7 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE8 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE9 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE10 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE11 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE12 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE13 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE14 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| RETURN_ATTRIBUTE15 | VARCHAR2 | (240) | Returns specific Descriptive Flexfield segment | |
| INVENTORY_ITEM_SEGMENT_1 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_2 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_3 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_4 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_5 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_6 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_7 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_8 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_9 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_10 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_11 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_12 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_13 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_14 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_15 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_16 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_17 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_18 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_19 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_20 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program that last updated row. | ||
| PROGRAM_ID | NUMBER | Concurrent program that last updated row. | ||
| PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| OPERATION_CODE | VARCHAR2 | (30) | Operation code | |
| ERROR_FLAG | VARCHAR2 | (1) | Error flag | |
| STATUS_FLAG | VARCHAR2 | (1) | Status flag | |
| INTERFACE_STATUS | VARCHAR2 | (1000) | Interface status | |
| CHANGE_REASON | VARCHAR2 | (30) | Change reason | |
| CHANGE_COMMENTS | VARCHAR2 | (2000) | Change comments | |
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | End item unit number | |
| FULFILLED_FLAG | VARCHAR2 | (1) | Flag to indicate whether a line has been fulfilled or not. | |
| REQUEST_DATE | DATE | Request date | ||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping Instructions | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions | |
| SOLD_FROM_ORG_ID | NUMBER | Sold from org id | ||
| SOLD_FROM_ORG | VARCHAR2 | (240) | Sold from org | |
| REJECTED_FLAG | VARCHAR2 | (1) | Rejected flag | |
| SERVICE_TXN_REASON_CODE | VARCHAR2 | (30) | Service txn reason code | |
| SERVICE_TXN_COMMENTS | VARCHAR2 | (2000) | Service txn comments | |
| SERVICE_DURATION | NUMBER | Service duration | ||
| SERVICE_START_DATE | DATE | Service start date | ||
| SERVICE_END_DATE | DATE | Service end date | ||
| SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | Service coterminate flag | |
| UNIT_SELLING_PERCENT | NUMBER | Unit selling percent | ||
| UNIT_LIST_PERCENT | NUMBER | Unit list percent | ||
| UNIT_PERCENT_BASE_PRICE | NUMBER | Unit percent base price | ||
| SERVICE_NUMBER | NUMBER | Service number | ||
| SERVICED_LINE_ID | NUMBER | Serviced line id | ||
| SERVICE_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE1 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE2 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE3 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE4 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE5 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE6 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE7 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE8 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE9 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE10 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE11 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE12 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE13 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE14 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| SERVICE_ATTRIBUTE15 | VARCHAR2 | (240) | Service related Descriptive Flexfield segment | |
| CUSTOMER_ITEM_NAME | VARCHAR2 | (2000) | Customer item name | |
| SERVICE_PERIOD | VARCHAR2 | (3) | Service period | |
| TP_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| TP_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| SERVICE_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | Service reference type code | |
| SERVICE_REFERENCE_ORDER | VARCHAR2 | (50) | Service reference order | |
| SERVICE_REFERENCE_LINE | VARCHAR2 | (50) | Service reference line | |
| SERVICE_REFERENCE_SYSTEM | VARCHAR2 | (50) | Service reference system | |
| PREFERRED_GRADE | VARCHAR2 | (150) | This column is used by Oracle Process Management(OPM) | |
| ORDERED_QUANTITY2 | NUMBER | This column is used by Oracle Process Management(OPM) | ||
| ORDERED_QUANTITY_UOM2 | VARCHAR2 | (3) | This column is used by Oracle Process Management(OPM) | |
| SHIPPED_QUANTITY2 | NUMBER | This column is used by Oracle Process Management(OPM) | ||
| CANCELLED_QUANTITY2 | NUMBER | This column is used by Oracle Process Management(OPM) | ||
| SHIPPING_QUANTITY2 | NUMBER | This column is used by Oracle Process Management(OPM) | ||
| SHIPPING_QUANTITY_UOM2 | VARCHAR2 | (3) | This column is used by Oracle Process Management(OPM) | |
| FULFILLED_QUANTITY2 | NUMBER | This column is used by Oracle Process Management(OPM) | ||
| COMMITMENT_ID | NUMBER | A contractual garantee with a customer for future purchase. | ||
| COMMITMENT | VARCHAR2 | (240) | Description for contractual garantee ID. | |
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory. | |
| UNIT_LIST_PRICE_PER_PQTY | NUMBER | Unit list price per pricing quantity. | ||
| UNIT_SELLING_PRICE_PER_PQTY | NUMBER | Unit selling price per pricing quantity. | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| RETURN_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| EARLIEST_ACCEPTABLE_DATE | DATE | Earliest Acceptable Date | ||
| LATEST_ACCEPTABLE_DATE | DATE | Latest Acceptable Date | ||
| INVOICE_TO_ADDRESS1 | VARCHAR2 | (240) | Invoice to address1 | |
| INVOICE_TO_ADDRESS2 | VARCHAR2 | (240) | Invoice to address2 | |
| INVOICE_TO_ADDRESS3 | VARCHAR2 | (240) | Invoice to address3 | |
| INVOICE_TO_ADDRESS4 | VARCHAR2 | (240) | Invoice to address4 | |
| INVOICE_TO_CITY | VARCHAR2 | (60) | Invoice to city | |
| INVOICE_TO_COUNTY | VARCHAR2 | (60) | Invoice to county. | |
| INVOICE_TO_STATE | VARCHAR2 | (60) | Invoice to state | |
| INVOICE_TO_POSTAL_CODE | VARCHAR2 | (60) | Invoice to postal code. | |
| INVOICE_TO_COUNTRY | VARCHAR2 | (60) | Invoice to country. | |
| SPLIT_FROM_LINE_REF | VARCHAR2 | (50) | Split from line reference. | |
| PRICE_REQUEST_CODE | VARCHAR2 | (240) | Code identifies pricing transaction applied to Order Line interface | |
| ORIG_SHIP_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new ship to address. There should a record in oe_customer_info_iface_all for this reference | |
| ORIG_BILL_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new bill to address. There should a record in oe_customer_info_iface_all for this reference | |
| ORIG_DELIVER_ADDRESS_REF | VARCHAR2 | (50) | Pass this value if you are creating a new deliver to address. There should a record in oe_customer_info_iface_all for this reference | |
| SHIP_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new ship to contact. There should a record in oe_customer_info_iface_all for this reference | |
| BILL_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new bill to contact. There should a record in oe_customer_info_iface_all for this reference | |
| DELIVER_TO_CONTACT_REF | VARCHAR2 | (50) | Pass this value if you are creating a new deliver to contact. There should a record in oe_customer_info_iface_all for this reference | |
| SPLIT_FROM_SHIPMENT_REF | VARCHAR2 | (50) | Split from shipment | |
| DELIVER_TO_ADDRESS1 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS2 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS3 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_ADDRESS4 | VARCHAR2 | (240) | Delivery address | |
| DELIVER_TO_CITY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_COUNTY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_COUNTRY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_STATE | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_PROVINCE | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_POSTAL_CODE | VARCHAR2 | (60) | Delivery address | |
| ATTRIBUTE_STATUS | VARCHAR2 | (2000) | Internal identifier for attributes that failed processing in BULK mode. | |
| CONFIGURATION_ID | NUMBER | Not used | ||
| CONFIG_HEADER_ID | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| CONFIG_REV_NBR | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | Id for the Ship to Customer | ||
| INVOICE_TO_CUSTOMER_ID | NUMBER | Id for the Bill To customer | ||
| DELIVER_TO_CUSTOMER_ID | NUMBER | Id for the Deliver to Customer | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Ship to Customer | |
| SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Ship to Customer | |
| INVOICE_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Bill to Customer | |
| INVOICE_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Bill to Customer | |
| DELIVER_TO_CUSTOMER_NAME | VARCHAR2 | (360) | Name for the Deliver to Customer | |
| DELIVER_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | Number for the Deliver to Customer | |
| ACCOUNTING_RULE_DURATION | NUMBER | (15) | Number of accounting periods, across which revenue is recognized. | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| USER_ITEM_DESCRIPTION | VARCHAR2 | (1000) | To store user entered item description. | |
| OVERRIDE_ATP_DATE_CODE | VARCHAR2 | (30) | By setting this code, User can force a 'Schedule Ship Date' , even if the supply is not available. | |
| LATE_DEMAND_PENALTY_FACTOR | NUMBER | This column can be used to specify the 'Penalty Factor for Late Demand' on the sales order line. This value is used in Planning. | ||
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Line Category Code Ex: Return for RMA Line | |
| XML_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | This Code will determine the transaction that Inserted the data into the interface tables. | |
| BLANKET_NUMBER | NUMBER | Reference to a Sales Agreement. | ||
| BLANKET_LINE_NUMBER | NUMBER | Reference to a Sales Agreement Line | ||
| ACTUAL_SHIPMENT_DATE | DATE | Actual Shipment Date of the line | ||
| PLANNING_PRIORITY | NUMBER | Planning Priority | ||
| SHIP_TO_PARTY_ID | NUMBER | Party Id of the Ship To customer | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Ship To customer | ||
| SHIP_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Ship To customer | ||
| DELIVER_TO_PARTY_ID | NUMBER | Party Id of the Deliver To customer | ||
| DELIVER_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Deliver To customer | ||
| DELIVER_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Deliver To customer | ||
| INVOICE_TO_PARTY_ID | NUMBER | Party Id of the Bill To customer | ||
| INVOICE_TO_PARTY_SITE_ID | NUMBER | Party Site Id of the Bill To customer | ||
| INVOICE_TO_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the Bill To customer | ||
| SHIP_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Ship To customer | ||
| DELIVER_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Deliver To customer | ||
| INVOICE_TO_ORG_CONTACT_ID | NUMBER | Contact Id of the Bill To customer | ||
| SHIP_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Ship To customer | |
| INVOICE_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Bill To customer | |
| DELIVER_TO_PARTY_NUMBER | VARCHAR2 | (30) | Party Number of the Deliver To customer | |
| END_CUSTOMER_NAME | VARCHAR2 | (360) | End customer name | |
| END_CUSTOMER_NUMBER | VARCHAR2 | (50) | End customer number | |
| END_CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | End customer party number | |
| END_CUSTOMER_ID | NUMBER | End customer id | ||
| END_CUSTOMER_PARTY_ID | NUMBER | Party Id of the end customer | ||
| END_CUSTOMER_ORG_CONTACT_ID | NUMBER | Contact Id of the end customer | ||
| END_CUSTOMER_CONTACT_ID | NUMBER | Contact Id of end customer contact | ||
| END_CUSTOMER_CONTACT | VARCHAR2 | (360) | Name of the end customer contact | |
| END_CUSTOMER_LOCATION | VARCHAR2 | (240) | End customer location name | |
| END_CUSTOMER_SITE_USE_ID | NUMBER | Site Use Id of the end customer | ||
| END_CUSTOMER_PARTY_SITE_ID | NUMBER | Party Site Id of the end customer | ||
| END_CUSTOMER_PARTY_SITE_USE_ID | NUMBER | Party Site Use Id of the end customer | ||
| END_CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | End customer address | |
| END_CUSTOMER_CITY | VARCHAR2 | (60) | End customer city | |
| END_CUSTOMER_STATE | VARCHAR2 | (60) | End customer state | |
| END_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | End customer zip | |
| END_CUSTOMER_COUNTRY | VARCHAR2 | (60) | End customer country | |
| END_CUSTOMER_PROVINCE | VARCHAR2 | (60) | End customer province | |
| END_CUSTOMER_COUNTY | VARCHAR2 | (60) | End customer county | |
| IB_OWNER | VARCHAR2 | (60) | Install Base Owner | |
| IB_CURRENT_LOCATION | VARCHAR2 | (60) | Install Base current location | |
| IB_INSTALLED_AT_LOCATION | VARCHAR2 | (60) | Installed at location | |
| ORDER_FIRMED_DATE | DATE | Demand firm date | ||
| ACTUAL_FULFILLMENT_DATE | DATE | Date the line was fulfilled | ||
| IB_OWNER_CODE | VARCHAR2 | (30) | To capture IB Owner Information. | |
| IB_INSTALLED_AT_LOCATION_CODE | VARCHAR2 | (30) | To capture IB Installed at Location information. | |
| IB_CURRENT_LOCATION_CODE | VARCHAR2 | (30) | To capture IB Current Location Information. | |
| INST_ID | NUMBER | used in RAC INSTANCE AFFINITY for context setting | ||
| SHIP_TO_PROVINCE | VARCHAR2 | (60) | To capture Ship to province Information. | |
| INVOICE_TO_PROVINCE | VARCHAR2 | (60) | To capture Invoice to province Information. | |
| SERVICE_BILL_PROFILE_ID | NUMBER | Stores the Billing Profile ID for Service Lines | ||
| SERVICE_BILLING_PROFILE | VARCHAR2 | (240) | Stores the Billing Profile value for Service Lines | |
| SERVICE_COV_TEMPLATE_ID | NUMBER | Stores Service Coverage Template ID for Extended Warranty Lines | ||
| SERVICE_COVERAGE_TEMPLATE | VARCHAR2 | (240) | Stores Service Coverage Template for Extended Warranty Lines | |
| SERVICE_SUBS_TEMPLATE_ID | NUMBER | Stores Subscription Template ID for Subscription Service Lines | ||
| SERVICE_SUBSCRIPTION_TEMPLATE | VARCHAR2 | (240) | Stores Subscription Template for Subscription Service Lines | |
| SERVICE_BILL_OPTION_CODE | VARCHAR2 | (10) | Stores the Serivce Billing Option Code that specifies how the Service Lines should be billed, should they be billed completly from Order Management, completely from Service Contracts, or first period from OM and subsequent periods from Service Contracts | |
| SUBSCRIPTION_ENABLE_FLAG | VARCHAR2 | (1) | Stores a value of either 'Y' or 'N' to indicate if the Line has to be treated as Subscription Service Line or a Standard Line |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE
, ORG_ID
, LINE_NUMBER
, SHIPMENT_NUMBER
, LINE_ID
, SPLIT_FROM_LINE_ID
, LINE_TYPE_ID
, LINE_TYPE
, ITEM_TYPE_CODE
, INVENTORY_ITEM_ID
, INVENTORY_ITEM
, TOP_MODEL_LINE_REF
, LINK_TO_LINE_REF
, EXPLOSION_DATE
, ATO_LINE_ID
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, SORT_ORDER
, MODEL_GROUP_NUMBER
, OPTION_NUMBER
, OPTION_FLAG
, SHIP_MODEL_COMPLETE_FLAG
, SOURCE_TYPE_CODE
, SCHEDULE_STATUS_CODE
, SCHEDULE_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE
, ACTUAL_ARRIVAL_DATE
, PROMISE_DATE
, SCHEDULE_DATE
, DELIVERY_LEAD_TIME
, DELIVERY_ID
, ORDERED_QUANTITY
, ORDER_QUANTITY_UOM
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM
, SHIPPED_QUANTITY
, CANCELLED_QUANTITY
, FULFILLED_QUANTITY
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, SOLD_TO_ORG_ID
, SOLD_TO_ORG
, SHIP_FROM_ORG_ID
, SHIP_FROM_ORG
, SHIP_TO_ORG_ID
, SHIP_TO_ORG
, DELIVER_TO_ORG_ID
, DELIVER_TO_ORG
, INVOICE_TO_ORG_ID
, INVOICE_TO_ORG
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_COUNTY
, SHIP_TO_STATE
, SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_CONTACT_AREA_CODE1
, SHIP_TO_CONTACT_AREA_CODE2
, SHIP_TO_CONTACT_AREA_CODE3
, SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_CONTACT
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT
, DROP_SHIP_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, CUST_PRODUCTION_SEQ_NUM
, LOAD_SEQ_NUMBER
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, AUTHORIZED_TO_SHIP_FLAG
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIP_SET_ID
, SHIP_SET_NAME
, ARRIVAL_SET_ID
, ARRIVAL_SET_NAME
, INVOICE_SET_ID
, INVOICE_SET_NAME
, FULFILLMENT_SET_ID
, FULFILLMENT_SET_NAME
, PRICE_LIST_ID
, PRICE_LIST
, PRICING_DATE
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, CALCULATE_PRICE_FLAG
, TAX_CODE
, TAX
, TAX_VALUE
, TAX_DATE
, TAX_POINT_CODE
, TAX_POINT
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON
, AGREEMENT_ID
, AGREEMENT
, INVOICING_RULE_ID
, INVOICING_RULE
, ACCOUNTING_RULE_ID
, ACCOUNTING_RULE
, PAYMENT_TERM_ID
, PAYMENT_TERM
, DEMAND_CLASS_CODE
, DEMAND_CLASS
, SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY
, SHIPPING_METHOD_CODE
, SHIPPING_METHOD
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_TERMS
, FOB_POINT_CODE
, FOB_POINT
, SALESREP_ID
, SALESREP
, RETURN_REASON_CODE
, REFERENCE_TYPE
, REFERENCE_HEADER_ID
, REFERENCE_HEADER
, REFERENCE_LINE_ID
, REFERENCE_LINE
, CREDIT_INVOICE_LINE_ID
, CUSTOMER_PO_NUMBER
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_ID_TYPE
, CUSTOMER_ITEM_REVISION
, CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID
, CUSTOMER_PAYMENT_TERM
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_BUCKET_TYPE
, SCHEDULE_ITEM_DETAIL
, DEMAND_STREAM
, CUSTOMER_DOCK_CODE
, CUSTOMER_DOCK
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_MODEL_SERIAL_NUMBER
, PROJECT_ID
, PROJECT
, TASK_ID
, TASK
, ITEM_REVISION
, CLOSED_FLAG
, CANCELLED_FLAG
, CONTRACT_PO_NUMBER
, LINE_PO_CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INDUSTRY_CONTEXT
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, 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
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, INVENTORY_ITEM_SEGMENT_1
, INVENTORY_ITEM_SEGMENT_2
, INVENTORY_ITEM_SEGMENT_3
, INVENTORY_ITEM_SEGMENT_4
, INVENTORY_ITEM_SEGMENT_5
, INVENTORY_ITEM_SEGMENT_6
, INVENTORY_ITEM_SEGMENT_7
, INVENTORY_ITEM_SEGMENT_8
, INVENTORY_ITEM_SEGMENT_9
, INVENTORY_ITEM_SEGMENT_10
, INVENTORY_ITEM_SEGMENT_11
, INVENTORY_ITEM_SEGMENT_12
, INVENTORY_ITEM_SEGMENT_13
, INVENTORY_ITEM_SEGMENT_14
, INVENTORY_ITEM_SEGMENT_15
, INVENTORY_ITEM_SEGMENT_16
, INVENTORY_ITEM_SEGMENT_17
, INVENTORY_ITEM_SEGMENT_18
, INVENTORY_ITEM_SEGMENT_19
, INVENTORY_ITEM_SEGMENT_20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_FLAG
, STATUS_FLAG
, INTERFACE_STATUS
, CHANGE_REASON
, CHANGE_COMMENTS
, END_ITEM_UNIT_NUMBER
, FULFILLED_FLAG
, REQUEST_DATE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, SOLD_FROM_ORG_ID
, SOLD_FROM_ORG
, REJECTED_FLAG
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_SELLING_PERCENT
, UNIT_LIST_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICED_LINE_ID
, SERVICE_CONTEXT
, SERVICE_ATTRIBUTE1
, SERVICE_ATTRIBUTE2
, SERVICE_ATTRIBUTE3
, SERVICE_ATTRIBUTE4
, SERVICE_ATTRIBUTE5
, SERVICE_ATTRIBUTE6
, SERVICE_ATTRIBUTE7
, SERVICE_ATTRIBUTE8
, SERVICE_ATTRIBUTE9
, SERVICE_ATTRIBUTE10
, SERVICE_ATTRIBUTE11
, SERVICE_ATTRIBUTE12
, SERVICE_ATTRIBUTE13
, SERVICE_ATTRIBUTE14
, SERVICE_ATTRIBUTE15
, CUSTOMER_ITEM_NAME
, SERVICE_PERIOD
, 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
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_ORDER
, SERVICE_REFERENCE_LINE
, SERVICE_REFERENCE_SYSTEM
, PREFERRED_GRADE
, ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2
, SHIPPED_QUANTITY2
, CANCELLED_QUANTITY2
, SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
, COMMITMENT_ID
, COMMITMENT
, SUBINVENTORY
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PER_PQTY
, CONTEXT
, RETURN_CONTEXT
, EARLIEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE
, INVOICE_TO_ADDRESS1
, INVOICE_TO_ADDRESS2
, INVOICE_TO_ADDRESS3
, INVOICE_TO_ADDRESS4
, INVOICE_TO_CITY
, INVOICE_TO_COUNTY
, INVOICE_TO_STATE
, INVOICE_TO_POSTAL_CODE
, INVOICE_TO_COUNTRY
, SPLIT_FROM_LINE_REF
, PRICE_REQUEST_CODE
, ORIG_SHIP_ADDRESS_REF
, ORIG_BILL_ADDRESS_REF
, ORIG_DELIVER_ADDRESS_REF
, SHIP_TO_CONTACT_REF
, BILL_TO_CONTACT_REF
, DELIVER_TO_CONTACT_REF
, SPLIT_FROM_SHIPMENT_REF
, DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY
, DELIVER_TO_COUNTY
, DELIVER_TO_COUNTRY
, DELIVER_TO_STATE
, DELIVER_TO_PROVINCE
, DELIVER_TO_POSTAL_CODE
, ATTRIBUTE_STATUS
, CONFIGURATION_ID
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, SHIP_TO_CUSTOMER_ID
, INVOICE_TO_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER
, INVOICE_TO_CUSTOMER_NAME
, INVOICE_TO_CUSTOMER_NUMBER
, DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CUSTOMER_NUMBER
, ACCOUNTING_RULE_DURATION
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, USER_ITEM_DESCRIPTION
, OVERRIDE_ATP_DATE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, LINE_CATEGORY_CODE
, XML_TRANSACTION_TYPE_CODE
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, ACTUAL_SHIPMENT_DATE
, PLANNING_PRIORITY
, SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_SITE_USE_ID
, DELIVER_TO_PARTY_ID
, DELIVER_TO_PARTY_SITE_ID
, DELIVER_TO_PARTY_SITE_USE_ID
, INVOICE_TO_PARTY_ID
, INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_SITE_USE_ID
, SHIP_TO_ORG_CONTACT_ID
, DELIVER_TO_ORG_CONTACT_ID
, INVOICE_TO_ORG_CONTACT_ID
, SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NAME
, END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID
, END_CUSTOMER_PARTY_ID
, END_CUSTOMER_ORG_CONTACT_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_CONTACT
, END_CUSTOMER_LOCATION
, END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_PARTY_SITE_USE_ID
, END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY
, END_CUSTOMER_STATE
, END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY
, END_CUSTOMER_PROVINCE
, END_CUSTOMER_COUNTY
, IB_OWNER
, IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION
, ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE
, IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE
, INST_ID
, SHIP_TO_PROVINCE
, INVOICE_TO_PROVINCE
, SERVICE_BILL_PROFILE_ID
, SERVICE_BILLING_PROFILE
, SERVICE_COV_TEMPLATE_ID
, SERVICE_COVERAGE_TEMPLATE
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_SUBSCRIPTION_TEMPLATE
, SERVICE_BILL_OPTION_CODE
, SUBSCRIPTION_ENABLE_FLAG
FROM ONT.OE_LINES_IFACE_ALL;
ONT.OE_LINES_IFACE_ALL does not reference any database object
ONT.OE_LINES_IFACE_ALL is referenced by following:
ONT
OE_LINES_IFACE_ALL#
|
|
|
|