ReceivablesTransactionSource
The Receivables Transaction Source business object determines specific behavior of Receivables transactions, including transaction numbering, transaction type and credit memo defaulting, and AutoInvoice behavior for imported transactions.
Business Views
** Available for extracting data- receivablesTransactionSourcesExtract**
The Receivables Transaction Source business object determines specific behavior of Receivables transactions, including transaction numbering, transaction type and credit memo defaulting, and AutoInvoice behavior for imported transactions.
Label, Plural Label
Receivables Transaction Source, Receivables Transaction Source
Data Source
Read-optimized data store
Fields
- accountingDateInAClosedPeriod (enumeration: GeneralLedgerDatePeriodRule)
The rule on an imported transaction source that determines how AutoInvoice processes transaction lines with an accounting date in a closed period. Valid values are Reject and Adjust.
Label
Accounting Date in a Closed Period
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: GeneralLedgerDatePeriodRule
Valid Values
- Adjust
- Reject
-
- accountingFlexfieldImportInformation (enumeration: AccountingFlexfieldRule)
The rule on an imported transaction source that determines how AutoInvoice passes accounting flexfield information on transaction lines. Valid values are Segment and ID.
Label
Accounting Flexfield Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: AccountingFlexfieldRule
Valid Values
- Id
- Segment
-
- accountingRuleImportInformation (enumeration: AccountingRuleImport)
The rule on an imported transaction source that determines how AutoInvoice passes the revenue scheduling rule on transaction lines. Valid values are Value, ID, and None.
Label
Accounting Rule Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: AccountingRuleImport
Valid Values
- Id
- None
- Value
-
- allowDuplicateTransactionNumbersFlag (boolean)
The option on a manual transaction source that indicates whether duplicate transaction numbers are allowed.
Label
Allow Duplicate Transaction Numbers
Properties
- sortable
- allowSalesCreditsFlag (boolean)
The option on an imported transaction source that indicates whether AutoInvoice passes sales credit information on imported transaction lines.
Label
Allow Sales Credits
- automaticTransactionNumberingFlag (boolean)
The option on the transaction source that indicates whether transaction numbering is automatic.
Label
Automatic Transaction Numbering
Properties
- sortable
- batchNumberingFlag (boolean)
The option on the transaction source that indicates whether transaction batch numbering is automatic.
Label
Batch Numbering
- batchSourceSequenceId (int64)
The sequence identifier of the transaction source assigned to the transaction batch.
Label
Transaction Source Sequence Identifier
Properties
- searchable
- sortable
- not nullable
- billToAddressImportInformation (enumeration: BillAddressRule)
The rule on an imported transaction source that determines how AutoInvoice passes the bill-to customer address on the transaction line. Valid values are Value and ID.
Label
Bill-to Address Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BillAddressRule
Valid Values
- Id
- Value
-
- billToContactImportInformation (enumeration: BillContactRule)
The rule on an imported transaction source that determines how AutoInvoice passes the bill-to customer contact on the transaction line. Valid values are Value, ID, and None.
Label
Bill-to Contact Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BillContactRule
Valid Values
- Id
- None
- Value
-
- billToCustomerImportInformation (enumeration: BillCustomerRule)
The rule on an imported transaction source that determines how AutoInvoice passes the bill-to customer name on the transaction line. Valid values are Value and ID.
Label
Bill-to Customer Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BillCustomerRule
Valid Values
- Id
- Value
-
- controlTransactionCompletionFlag (boolean)
Indicates whether control of transaction completion is enabled on the transaction source.
Label
Control Transaction Completion
Properties
- sortable
- copyDocumentNumberToTransactionNumberFlag (boolean)
The option on the transaction source that indicates whether transactions that use document sequences assign the document number as the transaction number.
Label
Copy Document Number to Transaction Number
Properties
- sortable
- copyTransactionInformationFlexfieldToCreditMemoFlag (boolean)
The option on a manual credit memo transaction source that indicates whether to copy the invoice transaction flexfield reference information to the credit memo that's crediting the invoice.
Label
Copy Transaction Information Flexfield to Credit Memo
- createClearingFlag (boolean)
The option on an imported transaction source that indicates whether AutoInvoice uses the AutoInvoice clearing account to store differences between the specified revenue amount and the standard calculated amount on transaction lines.
Label
Create Clearing
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- customerBankAccountImportInformation (enumeration: CustomerBankAccountRule)
The rule on an imported transaction source that determines how AutoInvoice passes the customer bank account on the transaction line. Valid values are Value and ID.
Label
Customer Bank Account Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: CustomerBankAccountRule
Valid Values
- Id
- Value
-
- deriveDateFlag (boolean)
The option on an imported transaction source that indicates whether AutoInvoice derives the accounting date on a transaction line instead of using a default date.
Label
Derive date
- description (string)
The description of the transaction source.
Label
Description
Properties
- sortable
- endDate (date)
The end date of the active transaction source.
Label
To Date
Properties
- searchable
- sortable
- fobPointImportInformation (enumeration: FOBPointRule)
The rule on an imported transaction source that determines how AutoInvoice passes FOB information on the transaction line. Valid values are Code and None.
Label
FOB Point Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: FOBPointRule
Valid Values
- Code
- None
-
- freightCarrierImportInformation (enumeration: ShipViaRule)
The rule on an imported transaction source that determines how AutoInvoice passes freight information on the transaction line. Valid values are Code and None.
Label
Freight Carrier Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ShipViaRule
Valid Values
- Code
- None
-
- invalidLine (enumeration: InvalidLinesRule)
The rule on an imported transaction source that determines how AutoInvoice processes imported transactions with invalid lines. Valid values are: Reject Invoice - reject the transaction and its lines, and Create Invoice - create the transaction with valid lines only.
Label
Invalid Line
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: InvalidLinesRule
Valid Values
- Create
- Reject
-
- inventoryItemImportInformation (enumeration: InventoryItemRule)
The rule on an imported transaction source that determines how AutoInvoice passes inventory item information on the transaction line. Valid values are Segment, ID, and None.
Label
Inventory Item Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: InventoryItemRule
Valid Values
- Id
- None
- Segment
-
- invoicingRuleImportInformation (enumeration: InvoicingRuleImport)
The rule on an imported transaction source that determines how AutoInvoice passes invoicing rule information on the transaction line. Valid values are Value, ID, and None.
Label
Invoicing Rule Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: InvoicingRuleImport
Valid Values
- Id
- None
- Value
-
- lastTransactionNumber (int64)
The last transaction number previously generated, used to determine the starting number for automatic transaction numbering on new transactions created by the transaction source.
Label
Last Transaction Number
Properties
- sortable
- memoLineRuleImportInformation (enumeration: MemoLineRule)
The rule on an imported transaction source that determines how AutoInvoice passes memo line rule information on the transaction line. Valid values are Value and ID.
Label
Memo Line Rule Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: MemoLineRule
Valid Values
- Id
- Value
-
- memoReasonImportInformation (enumeration: MemoReasonRule)
The rule on an imported transaction source that determines how AutoInvoice passes memo reason information on the transaction line. Valid values are Value and ID.
Label
Memo Reason Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: MemoReasonRule
Valid Values
- Id
- Value
-
- name (string)
The name of the transaction batch.
Label
Name
Properties
- searchable
- sortable
- not nullable
- paymentMethodImportInformation (enumeration: ReceiptMethodRule)
The rule on an imported transaction source that determines how AutoInvoice passes receipt method information on the transaction line. Valid values are Value and ID.
Label
Payment Method Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ReceiptMethodRule
Valid Values
- Id
- Value
-
- paymentTermsImportInformation (enumeration: TermRule)
The rule on an imported transaction source that determines how AutoInvoice passes payment terms information on the transaction line. Valid values are Value and ID.
Label
Payment Terms Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: TermRule
Valid Values
- Id
- Value
-
- receiptHandlingForCredits (enumeration: ReceiptHandlingOption)
The option on a credit memo transaction source that indicates how credit memo applications against paid invoices are managed. Valid values are Refund and On Account.
Label
Receipt Handling for Credits
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ReceiptHandlingOption
Properties
- sortable
Valid Values
- ON-ACCOUNT
- REFUND
-
- referenceFieldDefaultValue (string)
The reference information entered on the transaction source that's captured in the transaction flexfield of transactions created with the transaction source.
Label
Reference Field Default Value
Properties
- sortable
- relatedDocumentImportInformation (enumeration: RelatedDocumentRule)
- revenueAccountAllocationImportInformation (enumeration: RevenueAccountAllocationRule)
The rule on an imported transaction source that determines how AutoInvoice passes the revenue account allocation on the transaction line. Valid values are Amount and Percent.
Label
Revenue Account Allocation Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: RevenueAccountAllocationRule
Valid Values
- Amount
- Percent
-
- salesCreditImportInformation (enumeration: SalesCreditRule)
The rule on an imported transaction source that determines how AutoInvoice passes the sales credit allocation on the transaction line. Valid values are Amount and Percent.
Label
Sales Credit Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: SalesCreditRule
Valid Values
- Amount
- Id
- Percent
-
- salesCreditTypeImportInformation (enumeration: SalesCreditTypeRule)
The rule on an imported transaction source that determines how AutoInvoice passes sales credit type information on the transaction line. Valid values are Value and ID.
Label
Sales Credit Type Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: SalesCreditTypeRule
Valid Values
- Id
- Percent
- Value
-
- salespersonImportInformation (enumeration: SalespersonRule)
The rule on an imported transaction source that determines how AutoInvoice passes salesperson information on the transaction line. Valid values are Number and ID.
Label
Salesperson Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: SalespersonRule
Valid Values
- Id
- Number
-
- shipToAddressImportInformation (enumeration: ShipAddressRule)
The rule on an imported transaction source that determines how AutoInvoice passes ship-to address information on the transaction line. Valid values are Value, ID, and None.
Label
Ship-to Address Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ShipAddressRule
Valid Values
- Id
- None
- Value
-
- shipToContactImportInformation (enumeration: ShipAddressRule)
The rule on an imported transaction source that determines how AutoInvoice passes ship-to contact information on the transaction line. Valid values are Value, ID, and None.
Label
Ship-to Contact Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ShipAddressRule
Valid Values
- Id
- None
- Value
-
- shipToCustomerImportInformation (enumeration: ShipAddressRule)
The rule on an imported transaction source that determines how AutoInvoice passes ship-to customer information on the transaction line. Valid values are Value, ID, and None.
Label
Ship-to Customer Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: ShipAddressRule
Valid Values
- Id
- None
- Value
-
- soldToCustomerImportInformation (enumeration: SoldCustomerRule)
The rule on an imported transaction source that determines how AutoInvoice passes sold-to customer information on the transaction line. Valid values are Value and ID.
Label
Sold-to Customer Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: SoldCustomerRule
Valid Values
- Id
- Value
-
- startDate (date)
The start date of the active transaction source.
Label
From Date
Properties
- searchable
- sortable
- status (enumeration: TransactionSourceStatus)
The status of the transaction source. A list of accepted values is defined in the CODE_STATUS lookup type.
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: TransactionSourceStatus
Properties
- searchable
- sortable
Valid Values
- A
- I
-
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- transactionTypeImportInformation (enumeration: BillCustomerRule)
The rule on an imported transaction source that determines how AutoInvoice passes the transaction type on transaction lines. Valid values are Value and ID.
Label
Transaction Type Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BillCustomerRule
Valid Values
- Id
- Value
-
- type (enumeration: BatchSourceType)
The transaction batch type.
Label
Type
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: BatchSourceType
Properties
- sortable
- not nullable
Valid Values
- FOREIGN
- INV
-
- unitOfMeasureImportInformation (enumeration: UnitOfMeasureRule)
The rule on an imported transaction source that determines how AutoInvoice passes unit of measure information on the transaction line. Valid values are Value and ID.
Label
Unit of Measure Import Information
Type
-
Module: oraErpCoreReceivablesSetup
-
Enumeration Type: UnitOfMeasureRule
Valid Values
- Id
- Value
-
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
Reference Object
- autoInvoiceGroupingRule (ReceivablesAutoinvoiceGroupingRule)
The AutoInvoice grouping rule is a set of rules that determines how the invoice interface lines should be grouped to create invoices. It includes details such as name, description, line ordering rule, transaction class, from and to date, and optional grouping characteristics. The AutoInvoice uses these rules to create invoices. The rules specify various transaction attributes that must be identical for the same transaction. For example, if the transaction number is part of the grouping rule and two interface lines have different transaction numbers, then two transactions are created.
Business Object
ReceivablesAutoinvoiceGroupingRuleFields
- groupingRuleId (int64)
The identifier of the grouping rule.
Label
Grouping Rule ID
Properties
- searchable
- sortable
- not nullable
- groupingRuleId (int64)
- creditTransactionSource (ReceivablesTransactionSource)
The Receivables Transaction Source business object determines specific behavior of Receivables transactions, including transaction numbering, transaction type and credit memo defaulting, and AutoInvoice behavior for imported transactions.
Business Object
ReceivablesTransactionSourceFields
- batchSourceSequenceId (int64)
The sequence identifier of the transaction source assigned to the transaction batch.
Label
Transaction Source Sequence Identifier
Properties
- searchable
- sortable
- not nullable
- batchSourceSequenceId (int64)
- legalEntity (LegalEntity)
A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.
Business Object
LegalEntityFields
- legalEntityId (int64)
The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.
Label
Legal Entity ID
Properties
- searchable
- sortable
- not nullable
- legalEntityId (int64)
- setIdSet (SetIdSet)
The set is a logical group used for partitioning and sharing reference data across transactional entities, depending on the business context. The common set indicates that data isn't partitioned and is globally shared.
Business Object
SetIdSetFields
- setId (int64)
The unique identifier of the set ID set.
Label
Set ID
Properties
- searchable
- sortable
- not nullable
- setId (int64)
- sourceDocumentType (RevenueSourceDocumentType)
The source document type provides the sources identified as types in Revenue Management.
Business Object
RevenueSourceDocumentTypeFields
- sourceDocumentTypeId (int64)
The unique identifier of a source document type.
Label
Source Document Type ID
Properties
- searchable
- sortable
- not nullable
- sourceDocumentTypeId (int64)
- transactionType (ReceivablesTransactionType)
The transaction type contains information about transaction types, including transaction type set, legal entity, transaction type name, description, transaction class, transaction status, from date, creation sign, generate bill option, invoice type, credit memo type, application rule set, and payment terms. It contains every transaction type used for invoices, bills receivable, and credit memos.
Business Object
ReceivablesTransactionTypeFields
- customerTransactionTypeId (int64)
The identifier of the transaction type.
Properties
- searchable
- not nullable
- customerTransactionTypeSequenceId (int64)
The sequence identifier of the transaction type.
Label
Customer Transaction Type Sequence ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionTypeId (int64)
- transactionTypeSequence (ReceivablesTransactionType)
The transaction type contains information about transaction types, including transaction type set, legal entity, transaction type name, description, transaction class, transaction status, from date, creation sign, generate bill option, invoice type, credit memo type, application rule set, and payment terms. It contains every transaction type used for invoices, bills receivable, and credit memos.
Business Object
ReceivablesTransactionTypeFields
- customerTransactionTypeSequenceId (int64)
The sequence identifier of the transaction type.
Label
Customer Transaction Type Sequence ID
Properties
- searchable
- sortable
- not nullable
- customerTransactionTypeSequenceId (int64)
- usageCategoryCodeLookup (ERPLookupCode)
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- accountingDateInAClosedPeriod (enumeration: GeneralLedgerDatePeriodRule)