[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_LINE_ACKS |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_LINE_ACKS
|
| Subobject Name: | |
| Status: | VALID |
This is the acknowledgment table for Order Management sales order lines. This table contains sales order line information and is populated by both EDI and XML transactions when acknowledgments are required.
Scope: public
Product: ONT
Lifecycle: active
Display Name: Sales Order Line Acknowledgments
Category: BUSINESS_ENTITY ONT_SALES_ORDER
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_LINE_ACKS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
|
| OE_LINE_ACKS_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
HEADER_ID
LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HEADER_ID | NUMBER | Header id | ||
| ORIG_SYS_DOCUMENT_REF | VARCHAR2 | (50) | Original system document reference | |
| ORIG_SYS_LINE_REF | VARCHAR2 | (50) | Original system line reference | |
| CHANGE_DATE | DATE | Change date | ||
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
| ACCOUNTING_RULE | VARCHAR2 | (30) | Accounting rule used by AR for generating Invoice | |
| ORDER_NUMBER | NUMBER | Order number | ||
| ACCOUNTING_RULE_ID | NUMBER | Accounting rule id used by AR for generating Invoice | ||
| ACKNOWLEDGMENT_FLAG | VARCHAR2 | (1) | Acknowledgment flag | |
| FIRST_ACK_CODE | VARCHAR2 | (30) | Code used when first acknowledged | |
| LAST_ACK_CODE | VARCHAR2 | (30) | Code used when last acknowledged | |
| FIRST_ACK_DATE | DATE | Date first acknowledged | ||
| LAST_ACK_DATE | DATE | Date last acknowledged | ||
| BUYER_SELLER_FLAG | VARCHAR2 | (1) | Buyer seller flag | |
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| ACTUAL_ARRIVAL_DATE | DATE | Actual arrival date | ||
| ACTUAL_SHIPMENT_DATE | DATE | Actual shipment date | ||
| AGREEMENT | VARCHAR2 | (240) | Agreement | |
| AGREEMENT_ID | NUMBER | Agreement id | ||
| ARRIVAL_SET_ID | NUMBER | Arrival set id | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | Arrival set name | |
| PRICE_LIST | VARCHAR2 | (240) | Price list | |
| PRICE_LIST_ID | NUMBER | Price list id | ||
| SHIP_FROM_ORG | VARCHAR2 | (240) | Ship from org | |
| SHIP_FROM_ORG_ID | NUMBER | Ship from org id | ||
| SHIP_TO_ORG | VARCHAR2 | (240) | Ship to org | |
| SHIP_TO_ORG_ID | NUMBER | Ship to org id | ||
| SOLD_FROM_ORG | VARCHAR2 | (240) | Sold from org | |
| SOLD_FROM_ORG_ID | NUMBER | Sold from org id | ||
| SOLD_TO_ORG | VARCHAR2 | (360) | Sold to org | |
| SOLD_TO_ORG_ID | NUMBER | Sold to org id | ||
| ATO_LINE_ID | NUMBER | ATO line id | ||
| ATTRIBUTE1 | 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 | |
| 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 | |
| AUTHORIZED_TO_SHIP_FLAG | VARCHAR2 | (1) | Authorized to ship flag | |
| BOOKED_FLAG | VARCHAR2 | (1) | Booked flag | |
| CALCULATE_PRICE_FLAG | VARCHAR2 | (1) | Calculate price flag | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Cancelled flag | |
| CANCELLED_QUANTITY | NUMBER | Cancelled quantity | ||
| CLOSED_FLAG | VARCHAR2 | (1) | Closed flag | |
| COMMITMENT_ID | NUMBER | Commitment id | ||
| COMPONENT_CODE | VARCHAR2 | (1000) | Component code | |
| COMPONENT_NUMBER | NUMBER | Component number | ||
| COMPONENT_SEQUENCE_ID | NUMBER | Component sequence id | ||
| CONFIG_DISPLAY_SEQUENCE | NUMBER | Config display sequence | ||
| CONFIGURATION_ID | NUMBER | Configuration id | ||
| CONFIG_LINE_REF | VARCHAR2 | (50) | Config line reference | |
| TOP_MODEL_LINE_ID | NUMBER | Top model line id | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| CONTRACT_PO_NUMBER | VARCHAR2 | (150) | Contract PO number | |
| COST_TYPE | VARCHAR2 | (30) | Cost type | |
| COST_TYPE_ID | NUMBER | Cost type id | ||
| COSTING_DATE | DATE | Costing date | ||
| CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (50) | Customer model serial number | |
| CUST_PO_NUMBER | VARCHAR2 | (50) | Customer PO number | |
| CUST_PRODUCTION_SEQ_NUM | VARCHAR2 | (50) | Customer production sequence number | |
| CUSTOMER_DOCK | VARCHAR2 | (50) | Customer dock | |
| CUSTOMER_DOCK_CODE | VARCHAR2 | (50) | Customer dock code | |
| CUSTOMER_ITEM | VARCHAR2 | (2000) | Customer item | |
| CUSTOMER_ITEM_ID | NUMBER | Customer item id | ||
| CUSTOMER_ITEM_REVISION | VARCHAR2 | (50) | Customer item revision | |
| CUSTOMER_JOB | VARCHAR2 | (50) | Customer job | |
| CUSTOMER_PRODUCTION_LINE | VARCHAR2 | (50) | Customer production line | |
| CUSTOMER_TRX_LINE_ID | NUMBER | Customer trx line id | ||
| DELIVERY_ID | NUMBER | Delivery id | ||
| DELIVER_TO_CONTACT | VARCHAR2 | (330) | Deliver to contact | |
| DELIVER_TO_CONTACT_ID | NUMBER | Deliver to contact id | ||
| DELIVER_TO_ORG | VARCHAR2 | (240) | Deliver to org | |
| DELIVER_TO_ORG_ID | NUMBER | Deliver to org id | ||
| DELIVERY_LEAD_TIME | NUMBER | Delivery lead time | ||
| DEMAND_BUCKET_TYPE | VARCHAR2 | (80) | Demand bucket type | |
| DEMAND_BUCKET_TYPE_CODE | VARCHAR2 | (30) | Demand bucket type code | |
| DEMAND_CLASS | VARCHAR2 | (80) | Demand class | |
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand class code | |
| DEMAND_STREAM | VARCHAR2 | (30) | Demand stream | |
| DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | Flag to indicate whether departure planning is required for the line | |
| DPW_ASSIGNED_FLAG | VARCHAR2 | (1) | Dpw assigned flag | |
| EARLIEST_ACCEPTABLE_DATE | DATE | Earliest acceptable date | ||
| ERROR_FLAG | VARCHAR2 | (1) | Error flag | |
| EXPLOSION_DATE | DATE | Explosion date | ||
| FOB_POINT | VARCHAR2 | (240) | FOB point | |
| FOB_POINT_CODE | VARCHAR2 | (30) | FOB point code | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight Carrier code | |
| FREIGHT_TERMS | VARCHAR2 | (80) | Freight terms | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight terms code | |
| FULFILLED_QUANTITY | NUMBER | The fulfilled quantity for the line | ||
| FULFILLMENT_SET_ID | NUMBER | Fulfillment set id | ||
| FULFILLMENT_SET_NAME | VARCHAR2 | (30) | Fulfillment set name | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE1 | 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_ATTRIBUTE2 | VARCHAR2 | (240) | Reserved for country-specific functionality. | |
| GLOBAL_ATTRIBUTE20 | 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. | |
| INDUSTRY_ATTRIBUTE1 | 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_ATTRIBUTE2 | 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_ATTRIBUTE3 | VARCHAR2 | (240) | Industry specific Descriptive Flexfield segment | |
| INDUSTRY_ATTRIBUTE30 | 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_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| INTMED_SHIP_TO_CONTACT_ID | NUMBER | Intmediate ship to contact id | ||
| INTMED_SHIP_TO_ORG_ID | NUMBER | Intmediate ship to org id | ||
| INTERFACE_STATUS | VARCHAR2 | (1000) | Interface status | |
| INVENTORY_ITEM | VARCHAR2 | (240) | Inventory Item | |
| INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
| INVENTORY_ITEM_SEGMENT_1 | 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_2 | VARCHAR2 | (240) | Key Flexfield to Accounting Flexfield. | |
| INVENTORY_ITEM_SEGMENT_20 | 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. | |
| INVOICE_COMPLETE_FLAG | VARCHAR2 | (1) | To indicate whether the invoicing activity is complete | |
| INVOICE_SET_ID | NUMBER | Invoice set id | ||
| INVOICE_SET_NAME | VARCHAR2 | (30) | Invoice set name | |
| INVOICE_NUMBER | VARCHAR2 | (20) | Invoice Number | |
| INVOICE_TO_CONTACT | VARCHAR2 | (330) | Invoice To Contact | |
| INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
| INVOICE_TO_ORG | VARCHAR2 | (240) | Invoice To Organization | |
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| INVOICE_TOLERANCE_ABOVE | NUMBER | Invoice Tolerance Above | ||
| INVOICE_TOLERANCE_BELOW | NUMBER | Invoice Tolerance Below | ||
| INVOICING_RULE | VARCHAR2 | (30) | Invoicing rule | |
| INVOICING_RULE_ID | NUMBER | Invoicing rule id | ||
| ITEM_INPUT | VARCHAR2 | (240) | To Store Ordered Item Name | |
| ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
| ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code | |
| LATEST_ACCEPTABLE_DATE | DATE | Latest acceptable date | ||
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Line category code | |
| LINE_ID | NUMBER | Line id | ||
| LINE_NUMBER | NUMBER | Line number | ||
| LINE_PO_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| LINE_TYPE | VARCHAR2 | (30) | Line type | |
| LINE_TYPE_ID | NUMBER | Line type id | ||
| LINK_TO_LINE_ID | NUMBER | Link to line id | ||
| LINK_TO_LINE_REF | VARCHAR2 | (50) | Link to line reference | |
| LOAD_SEQ_NUMBER | NUMBER | Load sequence number | ||
| LOT | VARCHAR2 | (30) | Lot | |
| MATERIAL_COST | NUMBER | Material cost | ||
| MATERIAL_OVERHEAD_COST | NUMBER | Material overhead cost | ||
| MODEL_GROUP_NUMBER | NUMBER | Model group number | ||
| OPEN_FLAG | VARCHAR2 | (1) | Open flag | |
| OPERATION_CODE | VARCHAR2 | (30) | Operation code | |
| OPTION_FLAG | VARCHAR2 | (1) | Option flag | |
| OPTION_NUMBER | NUMBER | Option number | ||
| ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Order quantity uom | |
| ORDER_SOURCE | VARCHAR2 | (30) | Order source | |
| ORDER_SOURCE_ID | NUMBER | Order source id | ||
| ORDERED_QUANTITY | NUMBER | Ordered quantity | ||
| ORG_ID | NUMBER | Org id | ||
| OUTSIDE_PROCESSING_COST | NUMBER | Outside processing cost | ||
| ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Original system shipment reference | |
| OVER_SHIP_REASON_CODE | VARCHAR2 | (30) | Over shipment reason code, it is populated when shipment is beyond over shipment tolerance | |
| OVER_SHIP_RESOLVED_FLAG | VARCHAR2 | (1) | A flag to indicate whether the shipment beyond over shipment tolerance has been resolved | |
| OVERHEAD_COST | NUMBER | Overhead cost | ||
| PAYMENT_TERM | VARCHAR2 | (30) | Payment term | |
| PAYMENT_TERM_ID | NUMBER | Payment term id | ||
| PAYMENT_TRX | VARCHAR2 | (30) | Payment trx | |
| PAYMENT_TRX_ID | NUMBER | Payment trx id | ||
| PLANNING_PROD_SEQ_NUM | NUMBER | Planning prod seq number | ||
| PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | Pricing Related Descriptive Flexfield segment | |
| PRICING_ATTRIBUTE10 | 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_CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| PRICING_DATE | DATE | Pricing date | ||
| PRICING_QUANTITY | NUMBER | Pricing quantity | ||
| PRICING_QUANTITY_UOM | VARCHAR2 | (3) | Pricing quantity UOM | |
| PROGRAM | VARCHAR2 | (30) | Program | |
| PROGRAM_APPLICATION | VARCHAR2 | (30) | Program application | |
| 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 | ||
| PROJECT | VARCHAR2 | (30) | Project | |
| PROJECT_ID | NUMBER | Project id | ||
| PROMISE_DATE | DATE | Promise date | ||
| REFERENCE_HEADER | VARCHAR2 | (30) | Reference header | |
| REFERENCE_HEADER_ID | NUMBER | Reference header id | ||
| REFERENCE_LINE | VARCHAR2 | (30) | Reference line | |
| REFERENCE_LINE_ID | NUMBER | Reference line id | ||
| REFERENCE_TYPE | VARCHAR2 | (30) | Reference type | |
| RELATED_PO_NUMBER | VARCHAR2 | (50) | Related po number | |
| REQUEST_DATE | DATE | Request date | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| RESERVED_QUANTITY | NUMBER | Reserved quantity | ||
| RESOURCE_COST | NUMBER | Resource cost | ||
| RETURN_ATTRIBUTE1 | 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 | |
| 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_CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | Return reason code | |
| RLA_SCHEDULE_TYPE_CODE | VARCHAR2 | (30) | Rla schedule type code | |
| SALESREP_ID | NUMBER | Salesrep id | ||
| SALESREP | VARCHAR2 | (240) | Salesrep | |
| SCHEDULE_ARRIVAL_DATE | DATE | Schedule arrival date | ||
| SCHEDULE_SHIP_DATE | DATE | Schedule ship date | ||
| SCHEDULE_ITEM_DETAIL | VARCHAR2 | (30) | Schedule item detail | |
| SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Schedule status code | |
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Ship model complete flag | |
| SHIP_SET_ID | NUMBER | Ship set id | ||
| SHIP_SET_NAME | VARCHAR2 | (30) | Ship set name | |
| 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_CONTACT | VARCHAR2 | (330) | Ship to contact | |
| 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_FIRST_NAME | VARCHAR2 | (150) | Ship to contact first name | |
| SHIP_TO_CONTACT_ID | NUMBER | Ship to contact id | ||
| SHIP_TO_CONTACT_JOB_TITLE | VARCHAR2 | (100) | Ship to contact job title | |
| SHIP_TO_CONTACT_LAST_NAME | VARCHAR2 | (150) | Ship to contact last name | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Ship to country | |
| SHIP_TO_COUNTY | VARCHAR2 | (60) | Ship to county | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Ship to postal code | |
| SHIP_TO_STATE | VARCHAR2 | (60) | Ship to state | |
| SHIP_TOLERANCE_ABOVE | NUMBER | Over shipment/return Tolerance | ||
| SHIP_TOLERANCE_BELOW | NUMBER | Under Shipment/Return Tolerance | ||
| SHIPMENT_NUMBER | NUMBER | Shipment number | ||
| SHIPMENT_PRIORITY | VARCHAR2 | (80) | Shipment priority | |
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment priority code | |
| SHIPPED_QUANTITY | NUMBER | Shipped quantity for the line | ||
| SHIPPING_METHOD | VARCHAR2 | (80) | Shipping method | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method code | |
| SHIPPING_QUANTITY | NUMBER | Quantity which has been shippedd by Shipping in Shipping UOM | ||
| SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | The UOM for Shipping Quantity. | |
| SORT_ORDER | VARCHAR2 | (2000) | Sort order | |
| SOURCE_DOCUMENT_ID | NUMBER | Source document id | ||
| SOURCE_DOCUMENT_LINE_ID | NUMBER | Source document line id | ||
| SOURCE_DOCUMENT_TYPE_ID | NUMBER | Source document type id | ||
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | Source type code | |
| SPLIT_FROM_LINE_ID | NUMBER | Split from line id | ||
| SUBINVENTORY | VARCHAR2 | (30) | Subinventory | |
| SUBMISSION_DATETIME | DATE | Submission datetime | ||
| TASK | VARCHAR2 | (30) | Task | |
| TASK_ID | NUMBER | Task id | ||
| TAX | VARCHAR2 | (50) | Tax | |
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| TAX_DATE | DATE | Tax date | ||
| TAX_EXEMPT_FLAG | VARCHAR2 | (30) | Tax exempt flag | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax exempt number | |
| TAX_EXEMPT_REASON | VARCHAR2 | (80) | Tax exempt reason | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax exempt reason code | |
| TAX_POINT | VARCHAR2 | (80) | Tax point | |
| TAX_POINT_CODE | VARCHAR2 | (30) | Tax point code | |
| TAX_RATE | NUMBER | Tax rate | ||
| TAX_VALUE | NUMBER | Tax value | ||
| UNIT_LIST_PRICE | NUMBER | Unit list price | ||
| UNIT_SELLING_PRICE | NUMBER | Unit selling price | ||
| VEH_CUS_ITEM_CUM_KEY_ID | NUMBER | Customer item cum key id | ||
| VISIBLE_DEMAND_FLAG | VARCHAR2 | (1) | Visible demand flag | |
| CUSTOMER_LINE_NUMBER | VARCHAR2 | (50) | Customer line number | |
| CUSTOMER_SHIPMENT_NUMBER | VARCHAR2 | (50) | Customer shipment number | |
| CUSTOMER_ITEM_NET_PRICE | NUMBER | Customer item net price | ||
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | Customer payment term id | ||
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Drop ship flag | |
| SHIP_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI location code for the ship to site. | |
| SPLIT_FROM_LINE_REF | VARCHAR2 | (50) | Split from line reference. | |
| SERVICE_TXN_REASON_CODE | VARCHAR2 | (30) | To store service transaction reason. | |
| SERVICE_TXN_COMMENTS | VARCHAR2 | (2000) | Placeholder for service comments. | |
| SERVICE_DURATION | NUMBER | Internal use only | ||
| SERVICE_START_DATE | DATE | Start Date for the Service | ||
| SERVICE_END_DATE | DATE | Internal use only | ||
| SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | To identify whether the service can be coterminated. | |
| SERVICE_NUMBER | NUMBER | Unique number to identify the service lines. | ||
| SERVICE_PERIOD | VARCHAR2 | (3) | Period for which service is offered. | |
| SERVICE_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | To identify the service reference type. Typical values are Order and Customer Product | |
| SERVICE_REFERENCE_LINE_ID | NUMBER | Identifies the immediate parent line to which the service is attached. | ||
| SERVICE_REFERENCE_SYSTEM_ID | NUMBER | To store system id for either reference type like order or customer product. | ||
| CREDIT_INVOICE_LINE_ID | NUMBER | This column stores the invoice line id this return line applies credit to | ||
| SHIP_TO_PROVINCE | VARCHAR2 | (60) | Province of the Ship To Customer Address. | |
| INVOICE_PROVINCE | VARCHAR2 | (60) | Province of the Bill to Customer Address. | |
| BILL_TO_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code for the Bill to Customer. | |
| INVOICE_CITY | VARCHAR2 | (60) | City of the Bill to Customer. | |
| SHIP_FROM_ADDRESS_1 | VARCHAR2 | (240) | Address Line 1 for the Ship From Address. | |
| SHIP_FROM_ADDRESS_2 | VARCHAR2 | (240) | Address Line 2 for the Ship From Address. | |
| SHIP_FROM_ADDRESS_3 | VARCHAR2 | (240) | Address Line 3 for the Ship From Address. | |
| SHIP_FROM_CITY | VARCHAR2 | (60) | City of the Ship From Address. | |
| SHIP_FROM_POSTAL_CODE | VARCHAR2 | (60) | Postal Code for the Ship From Address. | |
| SHIP_FROM_COUNTRY | VARCHAR2 | (60) | Country of the Ship From Address. | |
| SHIP_FROM_EDI_LOCATION_CODE | VARCHAR2 | (40) | EDI Location Code for the Ship From Address. | |
| SHIP_FROM_REGION1 | VARCHAR2 | (240) | Region 1 for the Ship From Address. | |
| SHIP_FROM_REGION2 | VARCHAR2 | (240) | Region 2 for the Ship From Address. | |
| SHIP_FROM_REGION3 | VARCHAR2 | (240) | Region 3 for the Ship From Address. | |
| SHIP_FROM_ADDRESS_ID | NUMBER | Internal Address ID of the Ship From Address. | ||
| SHIP_TO_ADDRESS_CODE | VARCHAR2 | (240) | Address Code for the Ship To. | |
| SHIP_TO_ADDRESS_NAME | VARCHAR2 | (360) | Address Name of the Ship To. | |
| SHIP_TO_ADDRESS_ID | NUMBER | Internal Address ID of the Ship To. | ||
| INVOICE_ADDRESS_CODE | VARCHAR2 | (40) | Address Code for the Invoice To. | |
| INVOICE_ADDRESS_NAME | VARCHAR2 | (360) | Address Name of the Invoice To. | |
| DELIVER_TO_CUSTOMER | VARCHAR2 | (360) | Deliver To customer. | |
| SERVICED_LINE_ID | NUMBER | Id of the Line, for which the service line. | ||
| SERVICE_REFERENCE_ORDER | VARCHAR2 | (50) | Order Number for the Service Line. | |
| SERVICE_REFERENCE_LINE | VARCHAR2 | (50) | Line Number for the Service Line. | |
| SERVICE_REFERENCE_SYSTEM | VARCHAR2 | (50) | System Number for the Service Line. | |
| 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 | |
| SPLIT_FROM_SHIPMENT_REF | VARCHAR2 | (50) | Original Shipment Number, from which the Line is splitted. | |
| 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 | |
| ACKNOWLEDGMENT_TYPE | VARCHAR2 | (30) | Type of acknowledgement. | |
| USER_ITEM_DESCRIPTION | VARCHAR2 | (1000) | To store user entered item description. | |
| BLANKET_NUMBER | NUMBER | Reference to a Sales Agreement | ||
| BLANKET_LINE_NUMBER | NUMBER | Reference to a Sales Agreement Line | ||
| ORIGINAL_INVENTORY_ITEM_ID | NUMBER | Stores the Original Inventory Item when there is a substitution. | ||
| ORIGINAL_ORDERED_ITEM_ID | NUMBER | Stores the Original Ordered Item when there is a substitution. | ||
| ORIGINAL_ORDERED_ITEM | VARCHAR2 | (2000) | Stores the Original Ordered Item when there is a substitution. | |
| ORDERED_ITEM | VARCHAR2 | (2000) | Stores name of Ordered Item | |
| INVOICE_INTERFACE_STATUS_CODE | VARCHAR2 | (30) | To indicate whether the invoicing activity is complete | |
| PREFERRED_GRADE | VARCHAR2 | (150) | Grade requested by the customer | |
| ORDERED_QUANTITY2 | NUMBER | Ordered quantity in secondary inventory unit of measure | ||
| ORDERED_QUANTITY_UOM2 | VARCHAR2 | (3) | Ordered Quantity unit of measure | |
| SHIPPING_QUANTITY2 | NUMBER | Shipping quantity in secondary shipping unit of measure | ||
| CANCELLED_QUANTITY2 | NUMBER | Cancelled Quantity | ||
| SHIPPED_QUANTITY2 | NUMBER | Shipped quantity in ordered_quantity_uom2 | ||
| SHIPPING_QUANTITY_UOM2 | VARCHAR2 | (3) | Secondary unit of measure the item is shipped | |
| FULFILLED_QUANTITY2 | NUMBER | Fulfilled quantity in ordered_quantity_uom2 | ||
| REVENUE_AMOUNT | NUMBER | For future use | ||
| FULFILLMENT_DATE | DATE | Fulfillment Date for the Line | ||
| ORIGINAL_ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | Stores the Original Item Identifier Type when there is a substitution. | |
| ITEM_SUBSTITUTION_TYPE_CODE | VARCHAR2 | (30) | Used to store the Item Substitution Type. It can be used to override the preferences specified in Item Substitution setup. It can also be used to turn-off substitution for the line. | |
| AUTO_SELECTED_QUANTITY | NUMBER | Not used | ||
| ORDERED_ITEM_ID | NUMBER | Stores Id of Ordered Item | ||
| ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | To distinguish different types of items (internal, customer. and generic items) | |
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Uniquely identifies which bill of material to be used for building a specific Model/Unit Number effectivity controlled item | |
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping instructions for Line | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions for Line. | |
| INVOICED_QUANTITY | NUMBER | To indicate whether the invoicing activity is complete or not. | ||
| REFERENCE_CUSTOMER_TRX_LINE_ID | NUMBER | This column stores the invoice line id this return line references | ||
| SPLIT_BY | VARCHAR2 | (30) | Indicates whether the line is system or user level split | |
| LINE_SET_ID | NUMBER | Line Set id | ||
| UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent-based pricing only) | ||
| UNIT_SELLING_PERCENT | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
| UNIT_PERCENT_BASE_PRICE | NUMBER | Based price used for percent based pricing | ||
| RE_SOURCE_FLAG | VARCHAR2 | (1) | Indicates whether user entered the warehouse or the system did | |
| FLOW_STATUS_CODE | VARCHAR2 | (30) | Workflow status for the line | |
| UNIT_LIST_PRICE_PER_PQTY | NUMBER | Unit list price per pricing quantity. | ||
| UNIT_SELLING_PRICE_PQTY | NUMBER | |||
| ITEM_RELATIONSHIP_TYPE | NUMBER | Stores the Item Relationship type | ||
| UNIT_SELLING_PRICE_PER_PQTY | NUMBER | Unit selling price per pricing quantity. | ||
| SHIP_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Ship To Party | |
| INVOICE_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Invoice To Party | |
| DELIVER_TO_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the Deliver To Party | |
| END_CUSTOMER_NUMBER | VARCHAR2 | (50) | Unique identifier for the End Customer | |
| END_CUSTOMER_PARTY_NUMBER | VARCHAR2 | (30) | Unique identifier for the End Customer Party | |
| END_CUSTOMER_ID | NUMBER | End Customer Id | ||
| END_CUSTOMER_CONTACT_ID | NUMBER | End Customer Contact Id | ||
| END_CUSTOMER_SITE_USE_ID | NUMBER | End Customer Site Org Id | ||
| END_CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | Address Line 1 of End Customer Location | |
| END_CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | Address Line 2 of End Customer Location | |
| END_CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | Address Line 3 of End Customer Location | |
| END_CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | Address Line 4 of End Customer Location | |
| END_CUSTOMER_CITY | VARCHAR2 | (60) | City of End Customer Location | |
| END_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of End Customer Location | |
| END_CUSTOMER_COUNTRY | VARCHAR2 | (60) | Country of End Customer Location | |
| END_CUSTOMER_STATE | VARCHAR2 | (60) | State of End Customer Location | |
| END_CUSTOMER_COUNTY | VARCHAR2 | (60) | County of End Customer Location | |
| END_CUSTOMER_PROVINCE | VARCHAR2 | (60) | Province of End Customer Location | |
| END_CUSTOMER_CONTACT | VARCHAR2 | (360) | End Customer Contact Name | |
| END_CUSTOMER_CONTACT_LAST_NAME | VARCHAR2 | (240) | End Customer Contact Last Name | |
| END_CUSTOMER_CONTACT_FIRST_NAM | VARCHAR2 | (240) | End Customer Contact First Name | |
| END_CUSTOMER_NAME | VARCHAR2 | (360) | End Customer Name | |
| IB_OWNER | VARCHAR2 | (60) | Default Owner | |
| IB_CURRENT_LOCATION | VARCHAR2 | (60) | Default Current Location | |
| IB_INSTALLED_AT_LOCATION | VARCHAR2 | (60) | Default Installed At Location | |
| ORDER_FIRMED_DATE | DATE | Not used | ||
| ACTUAL_FULFILLMENT_DATE | DATE | Not used | ||
| COMMITMENT | VARCHAR2 | (240) | Description for contractual guarantee ID | |
| CUSTOMER_PAYMENT_TERM | VARCHAR2 | (30) | Customer payment term | |
| 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_COUNTRY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_COUNTY | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_POSTAL_CODE | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_PROVINCE | VARCHAR2 | (60) | Delivery address | |
| DELIVER_TO_STATE | VARCHAR2 | (60) | Delivery address | |
| INVOICE_ADDRESS_1 | VARCHAR2 | (240) | Invoice To Address1 | |
| INVOICE_ADDRESS_2 | VARCHAR2 | (240) | Invoice To Address2 | |
| INVOICE_ADDRESS_3 | VARCHAR2 | (240) | Invoice To Address3 | |
| INVOICE_ADDRESS_4 | VARCHAR2 | (240) | Invoice To Address4 | |
| INVOICE_COUNTRY | VARCHAR2 | (60) | Invoice To Country | |
| INVOICE_COUNTY | VARCHAR2 | (60) | Invoice To County | |
| INVOICE_POSTAL_CODE | VARCHAR2 | (60) | Invoice To Postal Code | |
| INVOICE_STATE | VARCHAR2 | (60) | Invoice To State | |
| 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. | |
| CHARGE_PERIODICITY_CODE | VARCHAR2 | (3) | Recurring Charges Project | |
| CONFIG_HEADER_ID | NUMBER | Config Header Id | ||
| CONFIG_REV_NBR | NUMBER | Config Rev Nbr |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF
, CHANGE_DATE
, CHANGE_SEQUENCE
, ACCOUNTING_RULE
, ORDER_NUMBER
, ACCOUNTING_RULE_ID
, ACKNOWLEDGMENT_FLAG
, FIRST_ACK_CODE
, LAST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_DATE
, BUYER_SELLER_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, ACTUAL_ARRIVAL_DATE
, ACTUAL_SHIPMENT_DATE
, AGREEMENT
, AGREEMENT_ID
, ARRIVAL_SET_ID
, ARRIVAL_SET_NAME
, PRICE_LIST
, PRICE_LIST_ID
, SHIP_FROM_ORG
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG
, SHIP_TO_ORG_ID
, SOLD_FROM_ORG
, SOLD_FROM_ORG_ID
, SOLD_TO_ORG
, SOLD_TO_ORG_ID
, ATO_LINE_ID
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTHORIZED_TO_SHIP_FLAG
, BOOKED_FLAG
, CALCULATE_PRICE_FLAG
, CANCELLED_FLAG
, CANCELLED_QUANTITY
, CLOSED_FLAG
, COMMITMENT_ID
, COMPONENT_CODE
, COMPONENT_NUMBER
, COMPONENT_SEQUENCE_ID
, CONFIG_DISPLAY_SEQUENCE
, CONFIGURATION_ID
, CONFIG_LINE_REF
, TOP_MODEL_LINE_ID
, CONTEXT
, CONTRACT_PO_NUMBER
, COST_TYPE
, COST_TYPE_ID
, COSTING_DATE
, CUST_MODEL_SERIAL_NUMBER
, CUST_PO_NUMBER
, CUST_PRODUCTION_SEQ_NUM
, CUSTOMER_DOCK
, CUSTOMER_DOCK_CODE
, CUSTOMER_ITEM
, CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_REVISION
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUSTOMER_TRX_LINE_ID
, DELIVERY_ID
, DELIVER_TO_CONTACT
, DELIVER_TO_CONTACT_ID
, DELIVER_TO_ORG
, DELIVER_TO_ORG_ID
, DELIVERY_LEAD_TIME
, DEMAND_BUCKET_TYPE
, DEMAND_BUCKET_TYPE_CODE
, DEMAND_CLASS
, DEMAND_CLASS_CODE
, DEMAND_STREAM
, DEP_PLAN_REQUIRED_FLAG
, DPW_ASSIGNED_FLAG
, EARLIEST_ACCEPTABLE_DATE
, ERROR_FLAG
, EXPLOSION_DATE
, FOB_POINT
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS
, FREIGHT_TERMS_CODE
, FULFILLED_QUANTITY
, FULFILLMENT_SET_ID
, FULFILLMENT_SET_NAME
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE30
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_CONTEXT
, INTMED_SHIP_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID
, INTERFACE_STATUS
, INVENTORY_ITEM
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_SEGMENT_1
, 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_2
, INVENTORY_ITEM_SEGMENT_20
, 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
, INVOICE_COMPLETE_FLAG
, INVOICE_SET_ID
, INVOICE_SET_NAME
, INVOICE_NUMBER
, INVOICE_TO_CONTACT
, INVOICE_TO_CONTACT_ID
, INVOICE_TO_ORG
, INVOICE_TO_ORG_ID
, INVOICE_TOLERANCE_ABOVE
, INVOICE_TOLERANCE_BELOW
, INVOICING_RULE
, INVOICING_RULE_ID
, ITEM_INPUT
, ITEM_REVISION
, ITEM_TYPE_CODE
, LATEST_ACCEPTABLE_DATE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_NUMBER
, LINE_PO_CONTEXT
, LINE_TYPE
, LINE_TYPE_ID
, LINK_TO_LINE_ID
, LINK_TO_LINE_REF
, LOAD_SEQ_NUMBER
, LOT
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, MODEL_GROUP_NUMBER
, OPEN_FLAG
, OPERATION_CODE
, OPTION_FLAG
, OPTION_NUMBER
, ORDER_QUANTITY_UOM
, ORDER_SOURCE
, ORDER_SOURCE_ID
, ORDERED_QUANTITY
, ORG_ID
, OUTSIDE_PROCESSING_COST
, ORIG_SYS_SHIPMENT_REF
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, OVERHEAD_COST
, PAYMENT_TERM
, PAYMENT_TERM_ID
, PAYMENT_TRX
, PAYMENT_TRX_ID
, PLANNING_PROD_SEQ_NUM
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_CONTEXT
, PRICING_DATE
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, PROGRAM
, PROGRAM_APPLICATION
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT
, PROJECT_ID
, PROMISE_DATE
, REFERENCE_HEADER
, REFERENCE_HEADER_ID
, REFERENCE_LINE
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, RELATED_PO_NUMBER
, REQUEST_DATE
, REQUEST_ID
, RESERVED_QUANTITY
, RESOURCE_COST
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_CONTEXT
, RETURN_REASON_CODE
, RLA_SCHEDULE_TYPE_CODE
, SALESREP_ID
, SALESREP
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SCHEDULE_ITEM_DETAIL
, SCHEDULE_STATUS_CODE
, SHIP_MODEL_COMPLETE_FLAG
, SHIP_SET_ID
, SHIP_SET_NAME
, SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4
, SHIP_TO_CITY
, SHIP_TO_CONTACT
, SHIP_TO_CONTACT_AREA_CODE1
, SHIP_TO_CONTACT_AREA_CODE2
, SHIP_TO_CONTACT_AREA_CODE3
, SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_COUNTRY
, SHIP_TO_COUNTY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_STATE
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIPMENT_NUMBER
, SHIPMENT_PRIORITY
, SHIPMENT_PRIORITY_CODE
, SHIPPED_QUANTITY
, SHIPPING_METHOD
, SHIPPING_METHOD_CODE
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM
, SORT_ORDER
, SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_LINE_ID
, SOURCE_DOCUMENT_TYPE_ID
, SOURCE_TYPE_CODE
, SPLIT_FROM_LINE_ID
, SUBINVENTORY
, SUBMISSION_DATETIME
, TASK
, TASK_ID
, TAX
, TAX_CODE
, TAX_DATE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON
, TAX_EXEMPT_REASON_CODE
, TAX_POINT
, TAX_POINT_CODE
, TAX_RATE
, TAX_VALUE
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, VEH_CUS_ITEM_CUM_KEY_ID
, VISIBLE_DEMAND_FLAG
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID
, DROP_SHIP_FLAG
, SHIP_TO_EDI_LOCATION_CODE
, SPLIT_FROM_LINE_REF
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, SERVICE_NUMBER
, SERVICE_PERIOD
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, CREDIT_INVOICE_LINE_ID
, SHIP_TO_PROVINCE
, INVOICE_PROVINCE
, BILL_TO_EDI_LOCATION_CODE
, INVOICE_CITY
, SHIP_FROM_ADDRESS_1
, SHIP_FROM_ADDRESS_2
, SHIP_FROM_ADDRESS_3
, SHIP_FROM_CITY
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_FROM_EDI_LOCATION_CODE
, SHIP_FROM_REGION1
, SHIP_FROM_REGION2
, SHIP_FROM_REGION3
, SHIP_FROM_ADDRESS_ID
, SHIP_TO_ADDRESS_CODE
, SHIP_TO_ADDRESS_NAME
, SHIP_TO_ADDRESS_ID
, INVOICE_ADDRESS_CODE
, INVOICE_ADDRESS_NAME
, DELIVER_TO_CUSTOMER
, SERVICED_LINE_ID
, SERVICE_REFERENCE_ORDER
, SERVICE_REFERENCE_LINE
, SERVICE_REFERENCE_SYSTEM
, 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
, SPLIT_FROM_SHIPMENT_REF
, 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
, ACKNOWLEDGMENT_TYPE
, USER_ITEM_DESCRIPTION
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ORDERED_ITEM
, INVOICE_INTERFACE_STATUS_CODE
, PREFERRED_GRADE
, ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2
, SHIPPING_QUANTITY2
, CANCELLED_QUANTITY2
, SHIPPED_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
, REVENUE_AMOUNT
, FULFILLMENT_DATE
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, AUTO_SELECTED_QUANTITY
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, END_ITEM_UNIT_NUMBER
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY
, LINE_SET_ID
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, RE_SOURCE_FLAG
, FLOW_STATUS_CODE
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PQTY
, ITEM_RELATIONSHIP_TYPE
, UNIT_SELLING_PRICE_PER_PQTY
, SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY
, END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY
, END_CUSTOMER_STATE
, END_CUSTOMER_COUNTY
, END_CUSTOMER_PROVINCE
, END_CUSTOMER_CONTACT
, END_CUSTOMER_CONTACT_LAST_NAME
, END_CUSTOMER_CONTACT_FIRST_NAM
, END_CUSTOMER_NAME
, IB_OWNER
, IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION
, ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE
, COMMITMENT
, CUSTOMER_PAYMENT_TERM
, DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY
, DELIVER_TO_COUNTRY
, DELIVER_TO_COUNTY
, DELIVER_TO_POSTAL_CODE
, DELIVER_TO_PROVINCE
, DELIVER_TO_STATE
, INVOICE_ADDRESS_1
, INVOICE_ADDRESS_2
, INVOICE_ADDRESS_3
, INVOICE_ADDRESS_4
, INVOICE_COUNTRY
, INVOICE_COUNTY
, INVOICE_POSTAL_CODE
, INVOICE_STATE
, IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE
, CHARGE_PERIODICITY_CODE
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
FROM ONT.OE_LINE_ACKS;
ONT.OE_LINE_ACKS does not reference any database object
ONT.OE_LINE_ACKS is referenced by following:
APPS
OE_LINE_ACKS
|
|
|
|