AutoInvoice Interface Table RA_INTERFACE_SALESCREDITS_ALL

This table stores sales credit information for transactions. This table must be populated if AutoAccounting derives segment values based on Salesperson.

If AutoAccounting doesn’t depend on Salesperson, then the settings of the Require salespersonReceivables system option and the Allow sales credits option on the transaction source determine whether you must enter sales credit information.

If you’re importing invoices, debit memos, and on-account credits, and the Require salesperson Receivables system option is enabled, you must enter sales credit information, regardless of the setting of the Allow sales credits option on the transaction source.

If you’re importing credit memos and the Require salesperson Receivables system option is enabled, entering sales credit information is optional. If you don't provide sales credit information on the credit memo, AutoInvoice uses the sales credit information of the invoice being credited. If the invoice doesn't have sales credit information, AutoInvoice creates a 100% No Sales Credit line for this invoice. This sales credit line is then used to determine the sales credit amount for the credit memo.

Regardless of the type of transaction you’re importing, if the Require salesperson Receivables system option isn’t enabled, but the Allow sales credits option on the transaction source is enabled, you can optionally provide sales credit information. AutoInvoice validates and passes this information with the transaction. If the Require salesperson Receivables system option isn’t enabled and the Allow sales credits option on the transaction source isn’t enabled, AutoInvoice ignores any values that you pass.

ATTRIBUTE1-15

Enter the Descriptive Flexfield attribute information for this sales or revenue credit assignment. Descriptive Flexfield attributes allow you to store additional columns, the contents of which you define. These columns are optional.

validation

None.

destination

RA_CUST_TRX_LINES_SALESREPS_ALL.ATTRIBUTE1-15

ATTRIBUTE_CATEGORY

Enter the Descriptive Flexfield category information for this sales credit assignment. Descriptive Flexfield categories allow you to store different categories of attributes. This column is optional.

validation

None.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.ATTRIBUTE_CATEGORY

INTERFACE_LINE_ATTRIBUTE1-15

Enter the same Line Transaction Flexfield for the transaction with which you want to associate this sales or revenue credit assignment. The values you enter here provide you with an audit trail from Receivables back to your original system. You must enter a value for each attribute you enabled.

validation

destination

INTERFACE_LINE_CONTEXT

Enter the context name of the Line Transaction Flexfield data that you entered in RA_INTERFACE_SALESCREDITS_ALL.INTERFACE_LINE_ATTRIBUTE1-15. You must enter a value in this column.

validation

None.

destination

None.

INTERFACE_LINE_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using RA_INTERFACE_SALESCREDITS_ALL.INTERFACE_LINE_ATTRIBUTE1-15.

validation

None.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.CUSTOMER_TRX_LINE_ID

INTERFACE_SALESCREDIT_ID

This column is used by AutoInvoice and should be left null. AutoInvoice enters a value in this column using the sequence RA_CUST_TRX_LINE_SALESREPS_S.

validation

None.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.CUST_TRX_LINE_SALESREP_ID

INTERFACE_STATUS

This column is used by AutoInvoice and should be left null.

validation

None.

destination

None.

LAST_UPDATE_LOGIN

This column is used by AutoInvoice and should be left null. AutoInvoice updates this column when it selects rows from the RA_INTERFACE_SALESCREDITS_ALL table for processing.

validation

None.

destination

None.

REQUEST_ID

This column is used by AutoInvoice and should be left null.

validation

None.

destination

None.

SALES_CREDIT_AMOUNT_SPLIT

Enter the sales credit amount for this salesperson. This column is optional. Depending on the setting of the Sales Credit option (Amount or Percent) in the Import Information section of the transaction source, you must enter either an amount in this column or a percentage in the SALES_CREDIT_PERCENT_SPLIT column. If you specified Percent in the transaction source, AutoInvoice calculates an amount for this column.

validation

If the sales credit type is Quota, the sum of sales credit amounts for a transaction must equal the amount of the transaction.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_AMOUNT_SPLIT, if the sales credit type is Quota. RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_AMOUNT_SPLIT, if the sales credit type isn’t Quota.

SALES_CREDIT_PERCENT_SPLIT

Enter the sales credit percentage for this salesperson. This column is optional. Depending on the setting of the Sales Credit option (Amount or Percent) in the Import Information section of the transaction source, you must enter either a percentage in this column or an amount in the SALES_CREDIT_PERCENT_SPLIT column. If you specified Amount in the transaction source, AutoInvoice calculates a percentage for this column.

validation

Your sales or revenue credit percentage must be between 0 and 100. If the sales credit type is Quota, the sales credit percentage for a transaction must add up to 100.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_AMOUNT_SPLIT, if the sales credit type is Quota. RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_AMOUNT_SPLIT, if the sales credit type isn’t Quota.

SALES_CREDIT_TYPE_ID

Enter the ID of the sales credit type for this sales credit assignment. This column is optional. Depending on the setting of the Sales Credit Type option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the SALES_CREDIT_TYPE_NAME column. If you specified Value in the transaction source, AutoInvoice enters a corresponding ID in this column.

validation

Must exist in SO_SALES_CREDIT_TYPES.SALES_CREDIT_TYPE_ID.

destination

None.

SALES_CREDIT_TYPE_NAME

Enter the name of the sales credit type for this sales credit assignment. This column is optional. Depending on the setting of the Sales Credit Type option (Value or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the SALES_CREDIT_TYPE_ID column.

validation

Must exist in SO_SALES_CREDIT_TYPES.NAME.

destination

None.

SALES_GROUP_ID

Enter the sales organization ID for this sales credit assignment. This column is optional.

validation

Must exist in JTF_RS_GROUP_USAGES.GROUP_ID and have JTF_RS_GROUP_USAGES.USAGE = SALES.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.REVENUE_SAL ESGROUP_ID or RA_CUST_TRX_LINE_SALESREPS_ALL.NON_REVENUE_SALESGROUP_ID.

SALESREP_ID

Enter the salesperson ID for this sales credit assignment. This column is optional. Depending on the setting of the Salesperson option (Number or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the SALESREP_NUMBER column. If you specified Number in the transaction source, AutoInvoice enters a corresponding ID in this column.

validation

Must exist in RA_SALESREPS.SALESREP_ID.

destination

RA_CUST_TRX_LINE_SALESREPS_ALL.SALESREP_ID

SALESREP_NUMBER

Enter the salesperson number for this sales credit assignment. This column is optional. Depending on the setting of the Salesperson option (Number or ID) in the Import Information section of the transaction source, you must enter a value either in this column or in the SALESREP_ID column.

validation

Must exist in RA_SALESREPS.SALESREP_NUMBER.

destination

None.