[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_RESALE_LINES_INT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_RESALE_LINES_INT_ALL
|
| Subobject Name: | |
| Status: | VALID |
This interface table temporarily stores the indirect sales data.
The data remains in this table until it is processed, and payments are made successfully. It is then copied into the ozf_resale_lines_all table. This table can handle data submission for Chargeback or Special Pricing purposes.
Scope: public
Product: OZF
Lifecycle: active
Display Name: Indirect Sales Interface
Category: BUSINESS_ENTITY OZF_INDIRECT_SALES
Category: OPEN_INTERFACE OZF_RESALE_INTERFACE 1
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_RESALE_LINES_INT_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RESALE_LINE_INT_ID
|
| OZF_RESALE_LINES_INT_ALL_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BILL_TO_LOCATION
|
| OZF_RESALE_LINES_INT_ALL_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_LOCATION
|
| OZF_RESALE_LINES_INT_ALL_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
END_CUST_LOCATION
|
| OZF_RESALE_LINES_INT_ALL_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOLD_FROM_CUST_ACCOUNT_ID
REQUEST_ID
ORG_ID
CURRENCY_CODE
DATE_ORDERED
|
| OZF_RESALE_LINES_INT_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESALE_BATCH_ID
STATUS_CODE
|
| OZF_RESALE_LINES_INT_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
|
| OZF_RESALE_LINES_INT_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BILL_TO_CUST_ACCOUNT_ID
|
| OZF_RESALE_LINES_INT_ALL_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORDER_NUMBER
BILL_TO_CUST_ACCOUNT_ID
|
| OZF_RESALE_LINES_INT_ALL_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORDER_NUMBER
SOLD_FROM_CUST_ACCOUNT_ID
|
| OZF_RESALE_LINES_INT_ALL_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_CODE
|
| OZF_RESALE_LINES_INT_ALL_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
END_CUST_PARTY_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESALE_LINE_INT_ID | NUMBER | Yes | Unique Identifier | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number used for database locking control when using HTML as a user interface | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| REQUEST_ID | NUMBER | Standard WHO Column | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATED_FROM | VARCHAR2 | (30) | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
| PROGRAM_APPLICATION_ID | NUMBER | Standard WHO Column | ||
| PROGRAM_UPDATE_DATE | DATE | Standard WHO Column | ||
| PROGRAM_ID | NUMBER | Standard WHO Column | ||
| RESALE_BATCH_ID | NUMBER | Resale Batch Identifier | ||
| STATUS_CODE | VARCHAR2 | (30) | Interface Line Status | |
| RESALE_TRANSFER_TYPE | VARCHAR2 | (30) | Product Transfer Type | |
| PRODUCT_TRANSFER_MOVEMENT_TYPE | VARCHAR2 | (30) | Indicates the direction of product transfer | |
| PRODUCT_TRANSFER_DATE | DATE | Product Transfer Date | ||
| TRACING_FLAG | VARCHAR2 | (1) | Indicates if the line is used for product tracing | |
| SHIP_FROM_CUST_ACCOUNT_ID | NUMBER | Shipping Customer Account Identifier | ||
| SHIP_FROM_SITE_ID | NUMBER | Shipping Customer Site Identifier | ||
| SHIP_FROM_PARTY_NAME | VARCHAR2 | (360) | Shipping Customer Name | |
| SHIP_FROM_LOCATION | VARCHAR2 | (40) | Shipping Customer Location Code | |
| SHIP_FROM_ADDRESS | VARCHAR2 | (240) | Address of Shipping Customer | |
| SHIP_FROM_CITY | VARCHAR2 | (60) | City of Shipping Customer | |
| SHIP_FROM_STATE | VARCHAR2 | (60) | State of Shipping Customer | |
| SHIP_FROM_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of Shipping Customer | |
| SHIP_FROM_COUNTRY | VARCHAR2 | (60) | Country of Shipping Customer | |
| SHIP_FROM_CONTACT_PARTY_ID | NUMBER | Shipping Customer Contact Party Identifier | ||
| SHIP_FROM_CONTACT_NAME | VARCHAR2 | (360) | Shipping Customer Contact Name | |
| SHIP_FROM_EMAIL | VARCHAR2 | (2000) | Shipping Customer Email Address | |
| SHIP_FROM_FAX | VARCHAR2 | (60) | Shipping Customer Fax Number | |
| SHIP_FROM_PHONE | VARCHAR2 | (60) | Shipping Customer Phone Number | |
| SOLD_FROM_CUST_ACCOUNT_ID | NUMBER | Selling Customer Account Identifier | ||
| SOLD_FROM_SITE_ID | NUMBER | Selling Customer Site Identifier | ||
| SOLD_FROM_PARTY_NAME | VARCHAR2 | (360) | Selling Customer Name | |
| SOLD_FROM_LOCATION | VARCHAR2 | (40) | Selling Customer Location Code | |
| SOLD_FROM_ADDRESS | VARCHAR2 | (240) | Address of Selling Customer | |
| SOLD_FROM_CITY | VARCHAR2 | (60) | City of Selling Customer | |
| SOLD_FROM_STATE | VARCHAR2 | (60) | State of Selling Customer | |
| SOLD_FROM_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of Selling Customer | |
| SOLD_FROM_COUNTRY | VARCHAR2 | (60) | Country of Selling Customer | |
| SOLD_FROM_CONTACT_PARTY_ID | NUMBER | Selling Customer Contact Party Identifier | ||
| SOLD_FROM_CONTACT_NAME | VARCHAR2 | (360) | Selling Customer Contact Name | |
| SOLD_FROM_EMAIL | VARCHAR2 | (2000) | Selling Customer Email Address | |
| SOLD_FROM_PHONE | VARCHAR2 | (60) | Selling Customer Phone Number | |
| SOLD_FROM_FAX | VARCHAR2 | (60) | Selling Customer Fax Number | |
| BILL_TO_CUST_ACCOUNT_ID | NUMBER | Buying Customer Account Identifier | ||
| BILL_TO_SITE_USE_ID | NUMBER | Buying Customer Account Site Use Identifier | ||
| BILL_TO_PARTY_ID | NUMBER | Buying Customer Party Identifier | ||
| BILL_TO_PARTY_SITE_ID | NUMBER | Buying Customer Party Site Identifier | ||
| BILL_TO_PARTY_NAME | VARCHAR2 | (360) | Buying Customer Name | |
| BILL_TO_DUNS_NUMBER | VARCHAR2 | (30) | Buying Customer DUNS Number | |
| BILL_TO_LOCATION | VARCHAR2 | (40) | Buying Customer Location Code | |
| BILL_TO_ADDRESS | VARCHAR2 | (240) | Address of Buying Customer | |
| BILL_TO_CITY | VARCHAR2 | (60) | City of Buying Customer | |
| BILL_TO_STATE | VARCHAR2 | (60) | State of Buying Customer | |
| BILL_TO_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of Buying Customer | |
| BILL_TO_COUNTRY | VARCHAR2 | (60) | Country of Buying Customer | |
| BILL_TO_CONTACT_PARTY_ID | NUMBER | Buying Customer Contact Party Identifier | ||
| BILL_TO_CONTACT_NAME | VARCHAR2 | (360) | Buying Customer Contact Name | |
| BILL_TO_EMAIL | VARCHAR2 | (2000) | Buying Customer Email Address | |
| BILL_TO_PHONE | VARCHAR2 | (60) | Buying Customer Phone Number | |
| BILL_TO_FAX | VARCHAR2 | (60) | Buying Customer Fax Number | |
| SHIP_TO_CUST_ACCOUNT_ID | NUMBER | Receiving Customer Account Identifier | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Receiving Customer Account Site Use Identifier | ||
| SHIP_TO_PARTY_ID | NUMBER | Receiving Customer Party Identifier | ||
| SHIP_TO_PARTY_SITE_ID | NUMBER | Receiving Customer Party Site Identifier | ||
| SHIP_TO_PARTY_NAME | VARCHAR2 | (360) | Receiving Customer Name | |
| SHIP_TO_DUNS_NUMBER | VARCHAR2 | (30) | Receiving Customer DUNS Number | |
| SHIP_TO_LOCATION | VARCHAR2 | (40) | Receiving Customer Location Code | |
| SHIP_TO_ADDRESS | VARCHAR2 | (240) | Address of Receiving Customer | |
| SHIP_TO_CITY | VARCHAR2 | (60) | City of Receiving Customer | |
| SHIP_TO_COUNTRY | VARCHAR2 | (60) | Country of Receiving Customer | |
| SHIP_TO_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of Receiving Customer | |
| SHIP_TO_STATE | VARCHAR2 | (60) | State of Receiving Customer | |
| SHIP_TO_CONTACT_PARTY_ID | NUMBER | Receiving Customer Contact Party Identifier | ||
| SHIP_TO_CONTACT_NAME | VARCHAR2 | (360) | Receiving Customer Contact Name | |
| SHIP_TO_EMAIL | VARCHAR2 | (2000) | Receiving Customer Email Address | |
| SHIP_TO_PHONE | VARCHAR2 | (60) | Receiving Customer Phone Number | |
| SHIP_TO_FAX | VARCHAR2 | (60) | Receiving Customer Fax Number | |
| END_CUST_PARTY_ID | NUMBER | End Customer Party Identifier | ||
| END_CUST_SITE_USE_ID | NUMBER | End Customer Site Use Identifier | ||
| END_CUST_SITE_USE_CODE | VARCHAR2 | (30) | End Customer Site Use Code | |
| END_CUST_PARTY_SITE_ID | NUMBER | End Customer Party Site Identifier | ||
| END_CUST_PARTY_NAME | VARCHAR2 | (360) | End Customer Name | |
| END_CUST_LOCATION | VARCHAR2 | (40) | End Customer Location Code | |
| END_CUST_ADDRESS | VARCHAR2 | (240) | Address of End Customer | |
| END_CUST_CITY | VARCHAR2 | (60) | City of End Customer | |
| END_CUST_STATE | VARCHAR2 | (60) | State of End Customer | |
| END_CUST_POSTAL_CODE | VARCHAR2 | (60) | Postal Code of End Customer | |
| END_CUST_COUNTRY | VARCHAR2 | (60) | Country of End Customer | |
| END_CUST_CONTACT_PARTY_ID | NUMBER | End Customer Contact Party Identifier | ||
| END_CUST_CONTACT_NAME | VARCHAR2 | (360) | End Customer Contact Name | |
| END_CUST_EMAIL | VARCHAR2 | (2000) | End Customer Email Address | |
| END_CUST_PHONE | VARCHAR2 | (60) | End Customer Phone Number | |
| END_CUST_FAX | VARCHAR2 | (60) | End Customer Fax Number | |
| DIRECT_CUSTOMER_FLAG | VARCHAR2 | (1) | Flag | |
| ORDER_TYPE_ID | NUMBER | Order Type Identifier | ||
| ORDER_TYPE | VARCHAR2 | (30) | Order Type | |
| ORDER_CATEGORY | VARCHAR2 | (30) | Order Category | |
| AGREEMENT_TYPE | VARCHAR2 | (30) | Agreement Type | |
| AGREEMENT_ID | NUMBER | Agreement Identifier | ||
| AGREEMENT_NAME | VARCHAR2 | (240) | Agreement Number | |
| AGREEMENT_PRICE | NUMBER | Contract Price | ||
| AGREEMENT_UOM_CODE | VARCHAR2 | (3) | Base Unit of Measurement for price | |
| CORRECTED_AGREEMENT_ID | NUMBER | Corrected Agreement Identifier | ||
| CORRECTED_AGREEMENT_NAME | VARCHAR2 | (240) | Corrected Agreement Name | |
| PRICE_LIST_ID | NUMBER | Price List Identifier | ||
| PRICE_LIST_NAME | VARCHAR2 | (240) | Price List Name | |
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (30) | reference in the original system | |
| ORIG_SYSTEM_LINE_REFERENCE | VARCHAR2 | (30) | line reference in the original system | |
| ORIG_SYSTEM_CURRENCY_CODE | VARCHAR2 | (15) | currency code in original system | |
| ORIG_SYSTEM_SELLING_PRICE | NUMBER | selling price in original system | ||
| ORIG_SYSTEM_QUANTITY | NUMBER | quantity in orig_system_uom | ||
| ORIG_SYSTEM_UOM | VARCHAR2 | (240) | uom in the original system | |
| ORIG_SYSTEM_PURCHASE_UOM | VARCHAR2 | (240) | Origination System Purchasing UOM | |
| ORIG_SYSTEM_PURCHASE_CURR | VARCHAR2 | (15) | Originating System Purchasing Currency Code | |
| ORIG_SYSTEM_PURCHASE_PRICE | NUMBER | Originating System Purcase Price | ||
| ORIG_SYSTEM_PURCHASE_QUANTITY | NUMBER | Originating System Purchasing Quantity | ||
| ORIG_SYSTEM_AGREEMENT_UOM | VARCHAR2 | (240) | Originating System Agreement UOM | |
| ORIG_SYSTEM_AGREEMENT_NAME | VARCHAR2 | (240) | Originating System Agreement Name | |
| ORIG_SYSTEM_AGREEMENT_TYPE | VARCHAR2 | (30) | Originating System Agreement Type | |
| ORIG_SYSTEM_AGREEMENT_STATUS | VARCHAR2 | (30) | Originating System Agreement Status | |
| ORIG_SYSTEM_AGREEMENT_CURR | VARCHAR2 | (15) | Originating System Agreement Currency | |
| ORIG_SYSTEM_AGREEMENT_PRICE | NUMBER | Originating System Agreement Price | ||
| ORIG_SYSTEM_AGREEMENT_QUANTITY | NUMBER | Originating System Agreement Quantity | ||
| ORIG_SYSTEM_ITEM_NUMBER | VARCHAR2 | (240) | Originating System Item Number | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| EXCHANGE_RATE | NUMBER | Exchange Rate for currency | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Market on which exchange rate is based on | |
| EXCHANGE_RATE_DATE | DATE | Exchange Rate Date | ||
| PO_NUMBER | VARCHAR2 | (50) | Purchase Order Number | |
| PO_RELEASE_NUMBER | VARCHAR2 | (240) | Version Nmber of Purchase Order | |
| PO_TYPE | VARCHAR2 | (30) | Type of Purchase Order | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Invoice Number | |
| DATE_INVOICED | DATE | Invoice Date | ||
| ORDER_NUMBER | VARCHAR2 | (30) | Order number | |
| DATE_ORDERED | DATE | Date Ordered | ||
| DATE_SHIPPED | DATE | Date Shipped | ||
| CLAIMED_AMOUNT | NUMBER | Claimed Amount | ||
| ALLOWED_AMOUNT | NUMBER | Allowed Amount | ||
| TOTAL_ALLOWED_AMOUNT | NUMBER | Total Allowed Amount | ||
| ACCEPTED_AMOUNT | NUMBER | Accepted Amount | ||
| TOTAL_ACCEPTED_AMOUNT | NUMBER | Total Accepted Amount | ||
| LINE_TOLERANCE_AMOUNT | NUMBER | Line Tolerance Amount | ||
| TOLERANCE_FLAG | VARCHAR2 | (1) | Indicates if line falls within tolerance | |
| TOTAL_CLAIMED_AMOUNT | NUMBER | Total Claimed Amount | ||
| PURCHASE_PRICE | NUMBER | Purchase Price | ||
| PURCHASE_UOM_CODE | VARCHAR2 | (3) | Purchase Price Unit Of Measure | |
| ACCTD_PURCHASE_PRICE | NUMBER | Purchase Price in Functional Currency | ||
| SELLING_PRICE | NUMBER | Selling Price | ||
| ACCTD_SELLING_PRICE | NUMBER | Selling Price in Functional Currency | ||
| UOM_CODE | VARCHAR2 | (3) | Unit Of Measure | |
| QUANTITY | NUMBER | Quantity | ||
| CALCULATED_PRICE | NUMBER | Calculated Price | ||
| ACCTD_CALCULATED_PRICE | NUMBER | Calculated Price in Functional Currency | ||
| CALCULATED_AMOUNT | NUMBER | Calculated Amount | ||
| CREDIT_CODE | VARCHAR2 | (30) | Credit Code | |
| CREDIT_ADVICE_DATE | DATE | Credit Advice Date | ||
| UPC_CODE | VARCHAR2 | (30) | UPC Code | |
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
| ITEM_NUMBER | VARCHAR2 | (240) | Item Number | |
| ITEM_DESCRIPTION | VARCHAR2 | (30) | Item Description | |
| INVENTORY_ITEM_SEGMENT1 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT2 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT3 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT4 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT5 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT6 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT7 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT8 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT9 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT10 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT11 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT12 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT13 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT14 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT15 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT16 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT17 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT18 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT19 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| INVENTORY_ITEM_SEGMENT20 | VARCHAR2 | (40) | Descriptive flexfield segment for Inventory Item | |
| PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
| CATEGORY_NAME | VARCHAR2 | (240) | Category Name | |
| DUPLICATED_LINE_ID | NUMBER | Identifier of the Duplicate Line | ||
| DUPLICATED_ADJUSTMENT_ID | NUMBER | Identifier of the Duplicate Adjustment | ||
| RESPONSE_TYPE | VARCHAR2 | (30) | Response Type | |
| RESPONSE_CODE | VARCHAR2 | (30) | Response Code for Outbound Transmission | |
| REJECT_REASON_CODE | VARCHAR2 | (30) | Reason for rejecting the claim | |
| FOLLOWUP_ACTION_CODE | VARCHAR2 | (30) | Followup Actions allowed for resubmission of claim | |
| NET_ADJUSTED_AMOUNT | NUMBER | Net Adjusted Amount | ||
| DISPUTE_CODE | VARCHAR2 | (30) | Dispute Code | |
| DATA_SOURCE_CODE | VARCHAR2 | (30) | Data Source Code | |
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column for header only | |
| HEADER_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| HEADER_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment for header | |
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column for line only | |
| LINE_ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| LINE_ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment for line | |
| ORG_ID | NUMBER | Organization identifier | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| INVOICE_LINE_NUMBER | VARCHAR2 | (30) | Supplier Item Cost | |
| ORDER_LINE_NUMBER | VARCHAR2 | (30) | Order Line Number | |
| SUPPLIER_ITEM_COST | NUMBER | Supplier Item Cost | ||
| SUPPLIER_ITEM_UOM | VARCHAR2 | (3) | Supplier Item Uom |
Cut, paste (and edit) the following text to query this object:
SELECT RESALE_LINE_INT_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, REQUEST_ID
, CREATED_BY
, CREATED_FROM
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, RESALE_BATCH_ID
, STATUS_CODE
, RESALE_TRANSFER_TYPE
, PRODUCT_TRANSFER_MOVEMENT_TYPE
, PRODUCT_TRANSFER_DATE
, TRACING_FLAG
, SHIP_FROM_CUST_ACCOUNT_ID
, SHIP_FROM_SITE_ID
, SHIP_FROM_PARTY_NAME
, SHIP_FROM_LOCATION
, SHIP_FROM_ADDRESS
, SHIP_FROM_CITY
, SHIP_FROM_STATE
, SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY
, SHIP_FROM_CONTACT_PARTY_ID
, SHIP_FROM_CONTACT_NAME
, SHIP_FROM_EMAIL
, SHIP_FROM_FAX
, SHIP_FROM_PHONE
, SOLD_FROM_CUST_ACCOUNT_ID
, SOLD_FROM_SITE_ID
, SOLD_FROM_PARTY_NAME
, SOLD_FROM_LOCATION
, SOLD_FROM_ADDRESS
, SOLD_FROM_CITY
, SOLD_FROM_STATE
, SOLD_FROM_POSTAL_CODE
, SOLD_FROM_COUNTRY
, SOLD_FROM_CONTACT_PARTY_ID
, SOLD_FROM_CONTACT_NAME
, SOLD_FROM_EMAIL
, SOLD_FROM_PHONE
, SOLD_FROM_FAX
, BILL_TO_CUST_ACCOUNT_ID
, BILL_TO_SITE_USE_ID
, BILL_TO_PARTY_ID
, BILL_TO_PARTY_SITE_ID
, BILL_TO_PARTY_NAME
, BILL_TO_DUNS_NUMBER
, BILL_TO_LOCATION
, BILL_TO_ADDRESS
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_POSTAL_CODE
, BILL_TO_COUNTRY
, BILL_TO_CONTACT_PARTY_ID
, BILL_TO_CONTACT_NAME
, BILL_TO_EMAIL
, BILL_TO_PHONE
, BILL_TO_FAX
, SHIP_TO_CUST_ACCOUNT_ID
, SHIP_TO_SITE_USE_ID
, SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_NAME
, SHIP_TO_DUNS_NUMBER
, SHIP_TO_LOCATION
, SHIP_TO_ADDRESS
, SHIP_TO_CITY
, SHIP_TO_COUNTRY
, SHIP_TO_POSTAL_CODE
, SHIP_TO_STATE
, SHIP_TO_CONTACT_PARTY_ID
, SHIP_TO_CONTACT_NAME
, SHIP_TO_EMAIL
, SHIP_TO_PHONE
, SHIP_TO_FAX
, END_CUST_PARTY_ID
, END_CUST_SITE_USE_ID
, END_CUST_SITE_USE_CODE
, END_CUST_PARTY_SITE_ID
, END_CUST_PARTY_NAME
, END_CUST_LOCATION
, END_CUST_ADDRESS
, END_CUST_CITY
, END_CUST_STATE
, END_CUST_POSTAL_CODE
, END_CUST_COUNTRY
, END_CUST_CONTACT_PARTY_ID
, END_CUST_CONTACT_NAME
, END_CUST_EMAIL
, END_CUST_PHONE
, END_CUST_FAX
, DIRECT_CUSTOMER_FLAG
, ORDER_TYPE_ID
, ORDER_TYPE
, ORDER_CATEGORY
, AGREEMENT_TYPE
, AGREEMENT_ID
, AGREEMENT_NAME
, AGREEMENT_PRICE
, AGREEMENT_UOM_CODE
, CORRECTED_AGREEMENT_ID
, CORRECTED_AGREEMENT_NAME
, PRICE_LIST_ID
, PRICE_LIST_NAME
, ORIG_SYSTEM_REFERENCE
, ORIG_SYSTEM_LINE_REFERENCE
, ORIG_SYSTEM_CURRENCY_CODE
, ORIG_SYSTEM_SELLING_PRICE
, ORIG_SYSTEM_QUANTITY
, ORIG_SYSTEM_UOM
, ORIG_SYSTEM_PURCHASE_UOM
, ORIG_SYSTEM_PURCHASE_CURR
, ORIG_SYSTEM_PURCHASE_PRICE
, ORIG_SYSTEM_PURCHASE_QUANTITY
, ORIG_SYSTEM_AGREEMENT_UOM
, ORIG_SYSTEM_AGREEMENT_NAME
, ORIG_SYSTEM_AGREEMENT_TYPE
, ORIG_SYSTEM_AGREEMENT_STATUS
, ORIG_SYSTEM_AGREEMENT_CURR
, ORIG_SYSTEM_AGREEMENT_PRICE
, ORIG_SYSTEM_AGREEMENT_QUANTITY
, ORIG_SYSTEM_ITEM_NUMBER
, CURRENCY_CODE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
, PO_NUMBER
, PO_RELEASE_NUMBER
, PO_TYPE
, INVOICE_NUMBER
, DATE_INVOICED
, ORDER_NUMBER
, DATE_ORDERED
, DATE_SHIPPED
, CLAIMED_AMOUNT
, ALLOWED_AMOUNT
, TOTAL_ALLOWED_AMOUNT
, ACCEPTED_AMOUNT
, TOTAL_ACCEPTED_AMOUNT
, LINE_TOLERANCE_AMOUNT
, TOLERANCE_FLAG
, TOTAL_CLAIMED_AMOUNT
, PURCHASE_PRICE
, PURCHASE_UOM_CODE
, ACCTD_PURCHASE_PRICE
, SELLING_PRICE
, ACCTD_SELLING_PRICE
, UOM_CODE
, QUANTITY
, CALCULATED_PRICE
, ACCTD_CALCULATED_PRICE
, CALCULATED_AMOUNT
, CREDIT_CODE
, CREDIT_ADVICE_DATE
, UPC_CODE
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_SEGMENT1
, INVENTORY_ITEM_SEGMENT2
, INVENTORY_ITEM_SEGMENT3
, INVENTORY_ITEM_SEGMENT4
, INVENTORY_ITEM_SEGMENT5
, INVENTORY_ITEM_SEGMENT6
, INVENTORY_ITEM_SEGMENT7
, INVENTORY_ITEM_SEGMENT8
, INVENTORY_ITEM_SEGMENT9
, INVENTORY_ITEM_SEGMENT10
, INVENTORY_ITEM_SEGMENT11
, INVENTORY_ITEM_SEGMENT12
, INVENTORY_ITEM_SEGMENT13
, INVENTORY_ITEM_SEGMENT14
, INVENTORY_ITEM_SEGMENT15
, INVENTORY_ITEM_SEGMENT16
, INVENTORY_ITEM_SEGMENT17
, INVENTORY_ITEM_SEGMENT18
, INVENTORY_ITEM_SEGMENT19
, INVENTORY_ITEM_SEGMENT20
, PRODUCT_CATEGORY_ID
, CATEGORY_NAME
, DUPLICATED_LINE_ID
, DUPLICATED_ADJUSTMENT_ID
, RESPONSE_TYPE
, RESPONSE_CODE
, REJECT_REASON_CODE
, FOLLOWUP_ACTION_CODE
, NET_ADJUSTED_AMOUNT
, DISPUTE_CODE
, DATA_SOURCE_CODE
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, ORG_ID
, SECURITY_GROUP_ID
, INVOICE_LINE_NUMBER
, ORDER_LINE_NUMBER
, SUPPLIER_ITEM_COST
, SUPPLIER_ITEM_UOM
FROM OZF.OZF_RESALE_LINES_INT_ALL;
OZF.OZF_RESALE_LINES_INT_ALL does not reference any database object
OZF.OZF_RESALE_LINES_INT_ALL is referenced by following:
OZF
OZF_RESALE_LINES_INT_ALL#
|
|
|
|