RA_INTERFACE_SALESCREDITS_ALL
The RA_INTERFACE_SALESCREDITS_ALL table is used by AutoInvoice to import sales credit information for your transactions. The values you enter for the Require Sales person parameter in the System Options window and the Allow Sales Credit parameter in the Transaction Sources window determine if you must enter sales credit information. If you are importing invoices, debit memos, and on-account credits, and the Require Sales person system option requires a sales person, you must provide sales credit information, regardless of the Allow Sales Credit parameter value for this transaction batch source. If you import credit memos and the Require Sales person system option requires a sales person, you can provide sales credit information. If you do not provide sales credit information, AutoInvoice uses sales credit information from the invoice you are crediting. If the invoice that you are crediting does not have sales credit information, AutoInvoice creates a 100% No Sales Credit line for this invoice and uses this sales credit line to determine the sales credit amount for the credit memo. Regardless of the transaction type you are importing, if the Require Sales person system option does not require a salesperson, but your transaction batch source allows sales credits, you can provide sales credit information. AutoInvoice validates the sales credit information and passes this information with your transaction. If the Require Sales person system option does not require a salesperson and your transaction batch source does not allow sales credits, do not provide sales credit information. AutoInvoice ignores any values that you pass. The primary key for this table is INTERFACE_SALESCREDIT_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INTERFACE_SALESCREDIT_ID | NUMBER | 18 | Oracle internal use only. Sales credit identifier. | |||
| INTERFACE_SALESCREDIT_GUID | VARCHAR2 | 32 | Oracle internal use only. Global interface line identifier. | |||
| INTERFACE_LINE_ID | NUMBER | 18 | Oracle internal use only. Interface line identifier. | |||
| INTERFACE_LINE_CONTEXT | VARCHAR2 | 30 | Context code for Line Transactions descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 for the segment values. | |||
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| SALESREP_NUMBER | VARCHAR2 | 30 | Salesperson number. Use Manage Resources task, role Salesperson, to identify valid values. | |||
| SALESREP_ID | NUMBER | 18 | Oracle internal use only. Salesperson identifier. | |||
| SALES_CREDIT_TYPE_NAME | VARCHAR2 | 30 | Sales credit type. Valid values: Quota Sales Credit, Non-quota Sales Credit. | |||
| SALES_CREDIT_TYPE_ID | NUMBER | 18 | Oracle internal use only. Sales credit type identifier. | |||
| SALES_CREDIT_AMOUNT_SPLIT | NUMBER | Sales credit amount for the salesperson. Do not use thousand separators. Use period or comma as decimal separator. | ||||
| SALES_CREDIT_PERCENT_SPLIT | NUMBER | Sales credit percent. Must be between 0 and 100. Use period or comma as decimal separator. If SALES_CREDIT_TYPE_NAME is QUOTA, the sum must be 100% for the transaction. | ||||
| INTERFACE_STATUS | VARCHAR2 | 1 | Oracle internal use only. Interface status. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Interface Sales Credits descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for the segment values. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Original system batch name for grouping transactions. Free text field. Not validated. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Interface Sales Credits descriptive flexfield. | Interface Sales Credits (RA_INTERFACE_SALESCREDITS) | ||
| INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ORG_ID | NUMBER | 18 | Business unit identifier. Use Manage Business units task to identify valid values. | |||
| SALESGROUP_ID | NUMBER | Oracle internal use only. Salesgroup identifier. | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| RESOURCE_SALESREP_ID | NUMBER | 18 | Oracle internal use only. Sales person identifier. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | |||
| BU_NAME | VARCHAR2 | 240 | Indicates the name of the business unit associated with the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RA_INTERFACE_SALESCREDITS_ALL | ar_sales_credit_types | SALES_CREDIT_TYPE_ID |
| RA_INTERFACE_SALESCREDITS_ALL | jtf_rs_salesreps | RESOURCE_SALESREP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RA_INTERFACE_SALESCREDITS_N1 | Non Unique | Default | INTERFACE_LINE_ID |
| RA_INTERFACE_SALESCREDITS_U1 | Unique | Default | INTERFACE_SALESCREDIT_ID |
| RA_INTERFACE_SALESCREDITS_U2 | Unique | Default | INTERFACE_SALESCREDIT_GUID |