[Home] [Help] [Dependency Information]
Object Name: | SO_SALES_CREDITS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | OE |
FND Design Data: | OE.SO_SALES_CREDITS_INTERFACE |
Subobject Name: | |
Status: | VALID |
SO_SALES_CREDITS_INTERFACE stores sales credit information you
import from a feeder system into Oracle Order Entry/Shipping. ID and
name columns corresponding to required information at order entry or
booking are conditionally required depending on whether the order
import source requires IDs. Sales credits can be assigned to orders
or order lines. ORIGINAL_SYSTEM_LINE_REFERENCE is NULL for
header-level sales credits. The column PERCENT indicates the
percentage of credit for the salesperson in SALESREP_NAME.
.
For more information on OrderImport, refer to the Integrating Oracle
Order Entry/Shipping Using OrderImport essay in the Oracle
Manufacturing, Distribution, Sales and Service Open Interfaces Manual,
Release 11.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SO_SALES_CREDITS_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
ORDER_SOURCE_ID
ORIGINAL_SYSTEM_REFERENCE |
SO_SALES_CREDITS_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application of concurrent program which last updated row | |
PROGRAM_ID | NUMBER | (15) | Concurrent program that last updated row | |
PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
REQUEST_ID | NUMBER | Concurrent request that last updated row | ||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Yes | Unique ID of order in old system |
ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | Unique ID for the order line in the old system | |
ORDER_SOURCE_ID | NUMBER | Yes | ID for the order source | |
LINE_NUMBER | NUMBER | Not used | ||
LINE_TYPE | VARCHAR2 | (30) | Not used | |
SALESREP_NAME | VARCHAR2 | (30) | Name of salesperson | |
SALESREP_ID | NUMBER | ID of salesperson | ||
SALES_CREDIT_TYPE | VARCHAR2 | (30) | Type of sales credit given | |
SALES_CREDIT_TYPE_ID | NUMBER | ID of the sales credit type | ||
QUOTA_FLAG | VARCHAR2 | (1) | Flag to show if sales credit is quota credit | |
PERCENT | NUMBER | Yes | Percent of credit | |
USE_IDS_FLAG | VARCHAR2 | (1) | Not used | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
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 | |
INTERFACE_STATUS | VARCHAR2 | (1000) | Contains validation errors which occurred when processing this record | |
ERROR_FLAG | VARCHAR2 | (1) | Value is set to 'Y' if this record has errors | |
OPERATION_CODE | VARCHAR2 | (30) | Used to identify if this record is to be inserted, updated or deleted |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, ORDER_SOURCE_ID
, LINE_NUMBER
, LINE_TYPE
, SALESREP_NAME
, SALESREP_ID
, SALES_CREDIT_TYPE
, SALES_CREDIT_TYPE_ID
, QUOTA_FLAG
, PERCENT
, USE_IDS_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INTERFACE_STATUS
, ERROR_FLAG
, OPERATION_CODE
FROM OE.SO_SALES_CREDITS_INTERFACE;
OE.SO_SALES_CREDITS_INTERFACE does not reference any database object
OE.SO_SALES_CREDITS_INTERFACE is referenced by following:
|
|
|