[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CS_ESTIMATE_DETAILS |
|---|---|
| Object Type: | TABLE |
| Owner: | CS |
| FND Design Data: |  CS.CS_ESTIMATE_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
CS_ESTIMATE_DETAILS stores details about Charges lines in Service. Charge lines can be created on behalf of a Service Request, a Depot Repair Order, or a Service/Debrief, but they will always have a parent Service Request.
INCIDENT_ID specifies the internal id of the parent Service Request.
CONTRACT_ID specifies the contract which, if specified, may be used to discount the final amounts of the Charge lines.
BUSINESS_PROCESS_ID associates the charge with a business process.
PRICE_LIST_ID is the id of the Charge line Price List in Oracle Pricing..
The bill-to and ship-to information is stored in INVOICE_TO_ORG_ID and SHIP_TO_ORG_ID. Both of these are foriegn keys to HZ_PARTY_SITES.
TXN_BILLING_TYPE_ID specifys the transaction type and the billing type for the charge line.
Installed base attributes, such as CUSTOMER_PRODUCT_ID, INSTALLED_CP_RETURN_BY_DATE, NEW_CP_RETURN_BY_DATE, and are used for transactions that update the Install Base.
ORDER_HEADER_ID and ORDER_LINE_ID hold order-specific information for the line in Order Entry/Shipping. SELLING_PRICE holds the unit price as obtained from the price list.
AFTER_WARRANTY_COST holds the final amount to charge, after all contracts/discounts have been applied.
The primary key of this table is ESTIMATE_DETAIL_ID.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CS_ESTIMATE_DETAILS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ESTIMATE_DETAIL_ID
|
| CS_ESTIMATE_DETAILS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INCIDENT_ID
|
| CS_ESTIMATE_DETAILS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TECHNICIAN_ID
|
| CS_ESTIMATE_DETAILS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_ID
SOURCE_CODE
|
| CS_ESTIMATE_DETAILS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_ORG_ID
|
| CS_ESTIMATE_DETAILS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVOICE_TO_ORG_ID
|
| CS_ESTIMATE_DETAILS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORDER_HEADER_ID
ORDER_LINE_ID
|
| CS_ESTIMATE_DETAILS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_SUBMITTED
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ESTIMATE_DETAIL_ID | NUMBER | (15) | Yes | Unique identifier for the charge record |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ESTIMATE_ID | NUMBER | (15) | ||
| LINE_NUMBER | NUMBER | Line number of the charge | ||
| INVENTORY_ITEM_ID | NUMBER | (15) | Product used in inventory by the charge line | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial number of the returned product | |
| QUANTITY_REQUIRED | NUMBER | Quantity of the product used | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | UOM of the product | |
| SELLING_PRICE | NUMBER | Selling price of product in Order Management | ||
| AFTER_WARRANTY_COST | NUMBER | Cost after applying contract coverages or manual discounts | ||
| DIAGNOSIS_ID | NUMBER | (15) | ||
| ESTIMATE_BUSINESS_GROUP_ID | NUMBER | (15) | ||
| TRANSACTION_TYPE_ID | NUMBER | Transaction type Id for the Charge line. This is a FK to CS_TRANSACTION_TYPES.transaction_type_id. | ||
| CUSTOMER_PRODUCT_ID | NUMBER | (15) | Installed base reference, if any, for the product chosen; needed for certain transactions | |
| ORDER_HEADER_ID | NUMBER | Order Management information for sales order created | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | ||
| ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | ||
| INSTALLED_CP_RETURN_BY_DATE | DATE | Expected return date for the installed product | ||
| NEW_CP_RETURN_BY_DATE | DATE | Expected return date for the new product | ||
| INTERFACE_TO_OE_FLAG | VARCHAR2 | (1) | Indicates whether line has been interfaced to Order Entry/Shipping for sales order creation | |
| ROLLUP_FLAG | VARCHAR2 | (1) | Indicates whether the item used should be rolled up to an item defined in a profile option for that item type- Material, Labor, Expense | |
| ADD_TO_ORDER | VARCHAR2 | (1) | ||
| SYSTEM_ID | NUMBER | (15) | ||
| RMA_HEADER_ID | NUMBER | (15) | ||
| RMA_NUMBER | NUMBER | (30) | ||
| RMA_LINE_ID | NUMBER | (15) | ||
| RMA_LINE_NUMBER | NUMBER | (30) | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Pricing Attributes descriptive flexfield structure defining column | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| TECHNICIAN_ID | NUMBER | (15) | Not used | |
| TXN_START_TIME | DATE | Not used | ||
| TXN_END_TIME | DATE | Not used | ||
| ORGANIZATION_ID | NUMBER | |||
| COVERAGE_BILL_RATE_ID | NUMBER | Not used | ||
| COVERAGE_BILLING_TYPE_ID | NUMBER | (15) | ||
| TIME_ZONE_ID | NUMBER | (15) | ||
| TXN_BILLING_TYPE_ID | NUMBER | (15) | Transaction Billing Type | |
| BUSINESS_PROCESS_ID | NUMBER | (15) | Yes | Transaction group for the charge |
| INCIDENT_ID | NUMBER | (15) | Yes | Unique identifier for service request |
| ORIGINAL_SOURCE_ID | NUMBER | (15) | Yes | Original source ID for the charge line eg - Debrief, Depot Repair |
| ORIGINAL_SOURCE_CODE | VARCHAR2 | (10) | Yes | Original source Code for the charge line eg - Debrief, Depot Repair |
| SOURCE_ID | NUMBER | (15) | Current source ID for the charge line eg - Debrief, Depot Repair | |
| SOURCE_CODE | VARCHAR2 | (10) | Current Source Code for the charge line eg - Debrief, Depot Repair | |
| CONTRACT_ID | NUMBER | Identifier for the contract | ||
| COVERAGE_ID | NUMBER | Not used | ||
| COVERAGE_TXN_GROUP_ID | NUMBER | Not used | ||
| INVOICE_TO_ORG_ID | NUMBER | (15) | Bill-to Information. This is a foriegn key to HZ_PARTY_SITES. | |
| SHIP_TO_ORG_ID | NUMBER | (15) | Ship-To Information. This is a foriegn key to HZ_PARTY_SITES. | |
| PURCHASE_ORDER_NUM | VARCHAR2 | (50) | Purchase Order Number in Order Management | |
| LINE_TYPE_ID | NUMBER | (15) | Not used | |
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Line Category Code in Order Management . It can have return or Order | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| CONVERSION_RATE | NUMBER | Conversion Rate | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Conversion Type Code | |
| CONVERSION_RATE_DATE | DATE | Conversion Date | ||
| RETURN_REASON_CODE | VARCHAR2 | (30) | Reason for return | |
| ORDER_LINE_ID | NUMBER | Order Line Information for Sales Order in Order Management | ||
| PRICE_LIST_HEADER_ID | NUMBER | Price List identifier | ||
| FUNC_CURR_AFT_WARR_COST | NUMBER | Not Used. | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (50) | Name of the original Schema object for this row. This is only used for upgrade. | |
| ORIG_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | ||
| ADD_TO_ORDER_FLAG | VARCHAR2 | (1) | Indicates whether the line is to be added to an existing order or a new order | |
| EXCEPTION_COVERAGE_USED | VARCHAR2 | (1) | Flag which identifies whether exception coverage is used | |
| TAX_CODE | VARCHAR2 | (30) | Not used. | |
| EST_TAX_AMOUNT | NUMBER | (15) | Not used. | |
| OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
| PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | Pricing Attributes descriptive flexfield segment | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| UPGRADED_STATUS_FLAG | VARCHAR2 | (1) | Upgrade status tor this row. Used in the 11i upgrade process. | |
| ORIG_SYSTEM_REFERENCE_ID | NUMBER | ID of the original Schema object for this row. This is only used for upgrade. | ||
| NO_CHARGE_FLAG | VARCHAR2 | (1) | No charge indicator for row. When this is 'Y', the total chrage for this line is zero. | |
| ORG_ID | NUMBER | The Operating Unit of the Charge line. If null use the Operating Unit of the parent Service Request. | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item revision code from Inventory. Only used if the item is revision controlled. | |
| TRANS_INV_ORGANIZATION_ID | NUMBER | |||
| TRANS_SUBINVENTORY | VARCHAR2 | (10) | ||
| ACTIVITY_DATE | DATE | |||
| ACTIVITY_START_TIME | DATE | |||
| ACTIVITY_END_TIME | DATE | |||
| GENERATED_BY_BCA_ENGINE_FLAG | VARCHAR2 | (1) | Flag indicated that Charge line was created by the Auto Charges API. | |
| TRANSACTION_INVENTORY_ORG | NUMBER | Transaction Inventory Organization (Warehouse) to be used on the Order in OM. | ||
| TRANSACTION_SUB_INVENTORY | VARCHAR2 | (10) | Not used | |
| ACTIVITY_START_DATE_TIME | DATE | Start date and time of Activity for Labor lines | ||
| ACTIVITY_END_DATE_TIME | DATE | End date and time of Activity for Labor lines | ||
| CHARGE_LINE_TYPE | VARCHAR2 | (30) | Type of Charge Line. This can be 'Actual', 'Estimate', or 'In Progress'. | |
| SHIP_TO_CONTACT_ID | NUMBER | Ship to Contact ID for the selected Ship to Party Site | ||
| BILL_TO_CONTACT_ID | NUMBER | Bill to Contact ID for the selected Bill to Party Site | ||
| SHIP_TO_ACCOUNT_ID | NUMBER | Ship to Account for the Order created in OM | ||
| INVOICE_TO_ACCOUNT_ID | NUMBER | Bill to Account for the Order created in OM | ||
| LIST_PRICE | NUMBER | List Price (per unit) as calculate from the Price list | ||
| CONTRACT_DISCOUNT_AMOUNT | NUMBER | Amount discounted by the contract from the list price. | ||
| BILL_TO_PARTY_ID | NUMBER | Bill to Party Id for Charge line | ||
| SHIP_TO_PARTY_ID | NUMBER | Ship to Party Id of Charge line | ||
| SUBMIT_RESTRICTION_MESSAGE | VARCHAR2 | (2000) | Captures the submit restriction message that is preventing this charge line form being submitted. | |
| SUBMIT_ERROR_MESSAGE | VARCHAR2 | (2000) | Captures the error message that is preventing this charge line from being submitted. | |
| SUBMIT_FROM_SYSTEM | VARCHAR2 | (30) | Captures the system used to submit the charge line (i.e. Charges UI, Deport Repair, Auto Submit process, Other) | |
| LINE_SUBMITTED | VARCHAR2 | (1) | Tracks whether charge line has been submitted. Values are 'N' and null. This is being added to increase performance. Null means charge line has been submitted to OM. | |
| CONTRACT_LINE_ID | NUMBER | Identifier for the Contract line | ||
| RATE_TYPE_CODE | VARCHAR2 | (40) | Contracts Labor Rate Code | |
| INSTRUMENT_PAYMENT_USE_ID | NUMBER | (15) | Instrument Payment Identifier. | |
| PARENT_INSTANCE_ID | NUMBER | (15) | Parent Instance Id | |
| SHIPPING_METHOD | VARCHAR2 | (240) | Shiping method | |
| ARRIVAL_DATE_TIME | DATE | Arrival date time | ||
| COST | NUMBER | (15) | Cost | |
| AVAILABLE_QUANTITY | NUMBER | (15) | Quantity available | |
| RETURN_TYPE | VARCHAR2 | (240) | Return Type | |
| LOCATION_ID | NUMBER | (15) | Location Id | |
| SHIPPING_DISTANCE | VARCHAR2 | (50) | ||
| NEED_BY_DATE | DATE | |||
| PROJECT_ID | NUMBER | Project identifier | ||
| PROJECT_TASK_ID | NUMBER | Project task id for particular project | ||
| EXPENDITURE_ORG_ID | NUMBER | Expenditure org id |
Cut, paste (and edit) the following text to query this object:
SELECT ESTIMATE_DETAIL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ESTIMATE_ID
, LINE_NUMBER
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, QUANTITY_REQUIRED
, UNIT_OF_MEASURE_CODE
, SELLING_PRICE
, AFTER_WARRANTY_COST
, DIAGNOSIS_ID
, ESTIMATE_BUSINESS_GROUP_ID
, TRANSACTION_TYPE_ID
, CUSTOMER_PRODUCT_ID
, ORDER_HEADER_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, INSTALLED_CP_RETURN_BY_DATE
, NEW_CP_RETURN_BY_DATE
, INTERFACE_TO_OE_FLAG
, ROLLUP_FLAG
, ADD_TO_ORDER
, SYSTEM_ID
, RMA_HEADER_ID
, RMA_NUMBER
, RMA_LINE_ID
, RMA_LINE_NUMBER
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, TECHNICIAN_ID
, TXN_START_TIME
, TXN_END_TIME
, ORGANIZATION_ID
, COVERAGE_BILL_RATE_ID
, COVERAGE_BILLING_TYPE_ID
, TIME_ZONE_ID
, TXN_BILLING_TYPE_ID
, BUSINESS_PROCESS_ID
, INCIDENT_ID
, ORIGINAL_SOURCE_ID
, ORIGINAL_SOURCE_CODE
, SOURCE_ID
, SOURCE_CODE
, CONTRACT_ID
, COVERAGE_ID
, COVERAGE_TXN_GROUP_ID
, INVOICE_TO_ORG_ID
, SHIP_TO_ORG_ID
, PURCHASE_ORDER_NUM
, LINE_TYPE_ID
, LINE_CATEGORY_CODE
, CURRENCY_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, RETURN_REASON_CODE
, ORDER_LINE_ID
, PRICE_LIST_HEADER_ID
, FUNC_CURR_AFT_WARR_COST
, ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_LINE_REFERENCE
, ADD_TO_ORDER_FLAG
, EXCEPTION_COVERAGE_USED
, TAX_CODE
, EST_TAX_AMOUNT
, OBJECT_VERSION_NUMBER
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, PRICING_ATTRIBUTE60
, SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG
, ORIG_SYSTEM_REFERENCE_ID
, NO_CHARGE_FLAG
, ORG_ID
, ITEM_REVISION
, TRANS_INV_ORGANIZATION_ID
, TRANS_SUBINVENTORY
, ACTIVITY_DATE
, ACTIVITY_START_TIME
, ACTIVITY_END_TIME
, GENERATED_BY_BCA_ENGINE_FLAG
, TRANSACTION_INVENTORY_ORG
, TRANSACTION_SUB_INVENTORY
, ACTIVITY_START_DATE_TIME
, ACTIVITY_END_DATE_TIME
, CHARGE_LINE_TYPE
, SHIP_TO_CONTACT_ID
, BILL_TO_CONTACT_ID
, SHIP_TO_ACCOUNT_ID
, INVOICE_TO_ACCOUNT_ID
, LIST_PRICE
, CONTRACT_DISCOUNT_AMOUNT
, BILL_TO_PARTY_ID
, SHIP_TO_PARTY_ID
, SUBMIT_RESTRICTION_MESSAGE
, SUBMIT_ERROR_MESSAGE
, SUBMIT_FROM_SYSTEM
, LINE_SUBMITTED
, CONTRACT_LINE_ID
, RATE_TYPE_CODE
, INSTRUMENT_PAYMENT_USE_ID
, PARENT_INSTANCE_ID
, SHIPPING_METHOD
, ARRIVAL_DATE_TIME
, COST
, AVAILABLE_QUANTITY
, RETURN_TYPE
, LOCATION_ID
, SHIPPING_DISTANCE
, NEED_BY_DATE
, PROJECT_ID
, PROJECT_TASK_ID
, EXPENDITURE_ORG_ID
FROM CS.CS_ESTIMATE_DETAILS;
CS.CS_ESTIMATE_DETAILS does not reference any database object
CS.CS_ESTIMATE_DETAILS is referenced by following:
CS
CS_ESTIMATE_DETAILS#
|
|
|
|