ReceivablesTransactionLine

A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

Expand all

Collapse all

Business Views

** Available for extracting data

• receivablesTransactionLinesExtract**

  A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

  Label, Plural Label

  Receivables Transaction Lines, Receivables Transaction Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedAmountDueRemaining (big-decimal)

    The accounted amount of the remaining balance due on the transaction line.

    Label

    Accounted Amount Due Remaining

  • accountedOriginalAmount (big-decimal)

    The accounted amount of the original balance due on the transaction line.

    Label

    Accounted Original Amount

  • amountDueRemaining (big-decimal)

    The remaining balance due on the transaction line.

    Label

    Amount Due Remaining

    Properties

    • searchable
  • amountIncludesTax (enumeration: AmountIncludesTaxIndicator)

    The option that indicates whether the transaction line amount is tax inclusive. Valid values are: Yes - line amount is inclusive of tax, No - line amount isn't inclusive of tax, and NULL - you can't override the tax or tax group. The value can't be NULL for tax types.

    Label

    Amount Includes Tax

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AmountIncludesTaxIndicator

    Valid Values

    • N
    • S
    • Y
  • amountOriginal (big-decimal)

    The original balance due on the transaction line.

    Label

    Original Amount

  • assessableValue (big-decimal)

    The assessable value used as the taxable base amount on the transaction line.

    Label

    Assessable Value

  • authorizationComplete (enumeration: AuthenticationCompleteIndicator)

    The option that indicates whether the credit check authorization is complete for the transaction line.

    Label

    Authorization Complete

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AuthenticationCompleteIndicator

    Valid Values

    • N
    • Y
  • automaticTax (enumeration: AutotaxIndicator)

    The option that indicates whether the tax line on the transaction line was generated automatically by the tax engine.

    Label

    Automatic Tax

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AutotaxIndicator

    Valid Values

    • N
    • Y
  • autoruleComplete (enumeration: AutoruleCompleteCodeIndicator)

    The option that indicates whether AutoAccounting has created all distributions on the transaction line.

    Label

    AutoRule Complete

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AutoruleCompleteCodeIndicator

    Valid Values

    • N
    • Y
  • autoruleDurationProcessed (int64)

    The number of times revenue recognition has created distributions for the transaction line.

    Label

    AutoRule Duration Processed

  • billingPeriodEndDate (date)

    The end date of the billing period of the recurring bill plan on the transaction line.

    Label

    Billing Period End Date

  • billingPeriodStartDate (date)

    The start date of the billing period of the recurring bill plan on the transaction line.

    Label

    Billing Period Start Date

  • chargesAccountedAmountRemaining (big-decimal)

    The accounted charge amount remaining for the transaction line.

    Label

    Charges Accounted Amount Remaining

  • chargesAmountRemaining (big-decimal)

    The charge amount remaining for the transaction line.

    Label

    Charges Amount Remaining

  • comments (string)

    User-entered comments about the transaction line.

    Label

    Comments

  • commercialDiscount (big-decimal)

    The commercial discount extended to the customer for the purchase of the item on the transaction line.

    Label

    Commercial Discount

  • contractEndDate (date)

    The contract end date of the recurring bill plan on the transaction line.

    Label

    Contract End Date

  • contractStartDate (date)

    The contract start date of the recurring bill plan on the transaction line.

    Label

    Contract Start Date

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerTransactionLineId (int64)

    The identifier of the Receivable transaction line.

    Label

    Customer Transaction Line ID

    Properties

    • searchable
    • sortable
    • not nullable
  • deferralExclusion (enumeration: AutomatedDeferralExclusionIndicator)

    The option that excludes the transaction line from revenue deferral.

    Label

    Deferral Exclusion

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: AutomatedDeferralExclusionIndicator

    Valid Values

    • N
    • Y
  • description (string)

    The description of the transaction line.

    Label

    Description

  • extendedAccountedAmount (big-decimal)

    The total accounted amount of a transaction line in the entered currency including tax, if applicable

    Label

    Extended Accounted Amount

  • extendedAmount (big-decimal)

    The total amount of a transaction line in the entered currency including tax, if applicable

    Label

    Extended Amount

    Properties

    • not nullable
  • fairMarketValueAmount (big-decimal)

    The fair market value amount on the transaction line.

    Label

    Fair Market Value Amount

  • freightAdjustmentAccountedRemaining (big-decimal)

    The freight adjusted accounted amount on the transaction line.

    Label

    Freight Adjustment Accounted Remaining

  • freightAdjustmentRemaining (big-decimal)

    The freight adjusted remaining amount on the transaction line.

    Label

    Freight Adjustment Remaining

  • freightCharge (big-decimal)

    The freight amount on the transaction line.

    Label

    Freight Charge

  • freightEarnedAccountedAmount (big-decimal)

    The earned accounted discount on freight assigned to the transaction line.

    Label

    Freight Earned Accounted Amount

  • freightEarnedAmount (big-decimal)

    The earned discount on freight assigned to the transaction line.

    Label

    Freight Earned Amount

  • freightUnearnedAccountedAmount (big-decimal)

    The unearned accounted discount on freight assigned to the transaction line.

    Label

    Freight Unearned Accounted Amount

  • freightUnearnedAmount (big-decimal)

    The unearned discount on freight assigned to the transaction line.

    Label

    Freight Unearned Amount

  • grossExtendedAmount (big-decimal)

    The total line amount inclusive of tax.

    Label

    Gross Extended Amount

  • grossUnitPrice (big-decimal)

    The transaction line gross unit price inclusive of tax.

    Label

    Gross Unit Price

  • historical (enumeration: HistoricalIndicator)

    The option that indicates whether the transaction line exists prior to Release 12. Valid values are Yes, No, or Null.

    Label

    Historical

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: HistoricalIndicator

    Valid Values

    • N
    • Y
  • insuranceCharge (big-decimal)

    The amount of insurance charged to the customer for the sale of the item on the transaction line.

    Label

    Insurance Charge

  • intendedUse (string)

    The product intended use fiscal classification used in tax determination on the transaction line.

    Label

    Intended Use

  • interfaceLineContext (string)

    The interface line context for InterfaceHeaderContext.

    Label

    Interface Line Context

  • internalNotes (string)

    Internal notes that accompany the transaction line.

    Label

    Internal Notes

  • invoiceLineAccountingLevel (string)

    The identifier of the accounting level for transaction lines eligible for invoicing in the legacy system.

    Label

    Invoice Line Accounting Level

  • itemContext (string)

    The descriptive flexfield context name for the Receivables Transaction Line descriptive flexfield.

    Label

    Item Context

  • lastPeriodToCredit (int64)

    The last period to credit on a credit memo that uses the Unit revenue reversal rule against a transaction line that uses a revenue scheduling rule.

    Label

    Last Period to Credit

  • lineNumber (int64)

    The transaction line number.

    Label

    Line Number

    Properties

    • not nullable
  • lineRecoverableAmount (big-decimal)

    The recoverable tax amount on the transaction line.

    Label

    Line Recoverable Amount

  • lineType (enumeration: StandardLineType)

    The transaction line type. Valid values are Line, Tax, Freight, and Charges.

    Label

    Line Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: StandardLineType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • CB
    • CHARGES
    • FREIGHT
    • LINE
    • REV
    • TAX
  • manualRevenueScheduling (enumeration: RequiresManualSchedulingIndicator)

    Indicates whether a transaction line requires manual scheduling for revenue recognition.

    Label

    Requires Manual Scheduling

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: RequiresManualSchedulingIndicator

    Valid Values

    • N
    • Y
  • miscellaneousCharge (big-decimal)

    The additional amount charged for the item on the transaction line.

    Label

    Miscellaneous Charge

  • overrideAutoaccounting (enumeration: OverrideAutoAccountingIndicator)

    The option that indicates whether the user can override the default accounting created by AutoAccounting.

    Label

    Override AutoAccounting

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: OverrideAutoAccountingIndicator

    Valid Values

    • N
    • Y
  • packingCharge (big-decimal)

    The packing amount charge on the transaction line item.

    Label

    Packing Charge

  • poDate (date)

    The purchase order date.

    Label

    PO Date

  • poNumber (string)

    The purchase order number assigned to the transaction.

    Label

    PO Number

  • poRevision (string)

    The number that identifies revisions to the purchase order.

    Label

    PO Revision

  • prepaymentRemainingAmount (big-decimal)

    Remaining amount available for application on the prepayment transaction.

    Label

    Prepayment Remaining Amount

  • productCategory (string)

    The noninventory-based product category used in tax determination for a transaction line item that's not an inventory item.

    Label

    Product Category

  • productFiscalClassification (string)

    The product fiscal classification used in tax determination on the transaction line.

    Label

    Product Fiscal Classification

  • productType (enumeration: ProductType)

    The product type of the transaction line item. Valid values are Goods and Services.

    Label

    Product Type

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: ProductType

    Valid Values

    • GOODS
    • SERVICES
  • quantityCredited (big-decimal)

    The quantity credited on the transaction line.

    Label

    Quantity Credited

  • quantityInvoiced (big-decimal)

    The quantity billed on the transaction line.

    Label

    Quantity Invoiced

  • quantityOrdered (big-decimal)

    The quantity ordered on the transaction line.

    Label

    Quantity Ordered

  • recurringBill (enumeration: RecurringBillIndicator)

    The option that indicates whether the transaction line was generated by a recurring bill plan. Valid values are Y, N, Null. Null is the same as N.

    Label

    Recurring Bill

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: RecurringBillIndicator

    Valid Values

    • N
    • Y
  • revenueAmount (big-decimal)

    The revenue amount on the transaction line.

    Label

    Revenue Amount

  • revenueRecognitionApplication (string)

    The option that indicates whether the application is used for revenue recognition.

    Label

    Revenue Recognition Application

  • revenueSchedulingRuleEndDate (date)

    The date the revenue scheduling rule expires on the transaction line.

    Label

    Revenue Scheduling Rule End Date

  • revenueSchedulingRuleNumberOfPeriods (int64)

    The number of periods over which revenue is recognized for the revenue scheduling rule on the transaction line.

    Label

    Revenue Scheduling Rule Number of Periods

  • revenueSchedulingRuleStartDate (date)

    The start date of the revenue scheduling rule on the transaction line.

    Label

    Revenue Scheduling Rule Start Date

  • salesOrderChannel (string)

    The source of the sales order on the transaction line.

    Label

    Sales Order Channel

  • salesOrderDate (date)

    The transaction line sales order date.

    Label

    Sales Order Date

  • salesOrderLine (string)

    The transaction line sales order line.

    Label

    Sales Order Line

  • salesOrderNumber (string)

    The transaction line sales order.

    Label

    Sales Order Number

    Properties

    • searchable
  • salesOrderRevision (int64)

    Revisions to the sales order assigned to the transaction line.

    Label

    Sales Order Revision

  • sourceDocumentLineNumber (string)

    The source document line number on the transaction line.

    Label

    Source Document Line Number

  • taxAction (string)

    The Tax Action values used by the Tax API to calculate taxes on the transaction line.

    Label

    Tax Action

  • taxExemptionCertificateNumber (string)

    The tax exemption certificate number of the customer on a transaction line with the status Exempt.

    Label

    Tax Exemption Certificate Number

  • taxInvoiceDate (date)

    The date the fiscal document was generated on the transaction line during the shipment of goods.

    Label

    Tax Invoice Date

  • taxInvoiceNumber (string)

    The fiscal document number generated on the transaction line during the shipment of goods.

    Label

    Tax Invoice Number

  • taxPrecedence (int64)

    The number that indicates the compounding precedence of a tax on the transaction line to define the order in which this tax is calculated in the compounding process.

    Label

    Tax Precedence

  • taxRate (big-decimal)

    The tax rate on the transaction line.

    Label

    Tax Rate

  • taxRecoverableAmount (big-decimal)

    The total recoverable tax amount on the transaction line.

    Label

    Tax Recoverable Amount

  • taxable (enumeration: TaxableCodeIndicator)

    Indicates whether to calculate tax on the transaction line.

    Label

    Taxable

    Type

    • Module: oraErpCoreReceivablesSetup

    • Enumeration Type: TaxableCodeIndicator

    Valid Values

    • N
    • S
    • Y
  • taxableAmount (big-decimal)

    The portion of the transaction line amount that the tax rate is applied to for the calculation of taxes on the transaction line.

    Label

    Taxable Amount

  • 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
  • transactionBusinessCategory (string)

    The transaction business category code used in tax determination on the transaction line.

    Label

    Transaction Business Category

  • translatedDescription (string)

    The translated description on the transaction line.

    Label

    Translated Description

  • unitOfMeasureCode (string)

    The unit of measure on the transaction line.

  • unitPrice (big-decimal)

    The unit selling price on the transaction line.

    Label

    Unit Price

  • unitStandardPrice (big-decimal)

    The unit price of the item on the transaction line.

    Label

    Unit Standard Price

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • userDefinedFiscalClassification (string)

    The user-defined fiscal classification used in tax determination on the transaction line.

    Label

    User-Defined Fiscal Classification

  • warehouseLastUpdatedDate (date)

    The date the inventory item on the transaction line is shipped from the warehouse.

    Label

    Warehouse Last Updated Date

  Expand all

  Collapse all

  Reference Object

  • accountingRule (ReceivablesAccountingRule)

    Business Object

    ReceivablesAccountingRule

    Expand all

    Collapse all

    Fields

    • ruleId (int64)

      Identifier of the invoicing rule and revenue scheduling rule.

      Label

      Rule ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • billingSet (ReceivablesInvoiceConsolidatedBillingSet)

    This provides the details of a value assigned to various sales order lines that's used to group these lines into a single invoice.

    Business Object

    ReceivablesInvoiceConsolidatedBillingSet

    Expand all

    Collapse all

    Fields

    • consolidatedBillingSetId (int64)

      Consolidated billing set identifier.

      Label

      Consolidated Billing Set ID

      Properties

      • creatable
      • searchable
      • sortable
      • not nullable

  • billsReceivableAdjustment (ReceivablesAdjustment)

    An adjustment refers to any modification made to the accounts receivable balance of an organization. It provides information related to adjustments such as adjustment number, adjustment date, receivables activity, accounting date, installment number, installment balance, and adjustment status. The adjustment information is used to update the AMOUNT_ADJUSTED and AMOUNT_DUE_REMAINING columns in the AR_PAYMENT_SCHEDULES_ALL table. If an adjustment is created with a receipt, the ASSOCIATED_CASH_RECEIPT_ID column in the AR_PAYMENT_SCHEDULES_ALL table stores the receipt ID when the adjustment is created against the invoice, debit memo, or chargeback.

    Business Object

    ReceivablesAdjustment

    Expand all

    Collapse all

    Fields

    • adjustmentId (int64)

      The identifier of the adjustment.

      Label

      Adjustment ID

      Properties

      • searchable
      • sortable
      • not nullable

  • billsReceivableReferencePaymentSchedule (ReceivablesTransactionPaymentSchedule)

    A receivables transaction payment schedule outlines the timeline and terms for payments to be made by customers for sales of goods or services. The details include information about all transactions except adjustments and miscellaneous cash receipts. It's updated when activities occur against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt. When a receipt is applied to a transaction, the system updates the amount applied, the remaining amount due, and the transaction status. The status changes from open to closed when the amount due remaining is zero.

    Business Object

    ReceivablesTransactionPaymentSchedule

    Expand all

    Collapse all

    Fields

    • paymentScheduleId (int64)

      The identifier of the payment schedule.

      Label

      Payment Schedule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • billsReceivableReferenceTransaction (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • businessUnit (BusinessUnit)

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • customerTransaction (ReceivablesTransaction)

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentType (RevenueSourceDocumentType)

    The source document type provides the sources identified as types in Revenue Management.

    Business Object

    RevenueSourceDocumentType

    Expand all

    Collapse all

    Fields

    • sourceDocumentTypeId (int64)

      The unique identifier of a source document type.

      Label

      Source Document Type ID

      Properties

      • searchable
      • sortable
      • not nullable

  • fundsCapturePaymentTransactionExtension (FundsCapturePaymentTransactionExtension)

    This business object stores information about Payment attributes for a given funds capture transaction.

    Business Object

    FundsCapturePaymentTransactionExtension

    Expand all

    Collapse all

    Fields

    • trxnExtensionId (int64)

      Unique system-generated primary key. Value from the sequence IBY_FNDCPT_TX_EXTENSIONS_S.nextval.

      Label

      Transaction Extension ID

      Properties

      • searchable
      • sortable
      • not nullable

  • initialTransactionLine (ReceivablesTransactionLine)

    Business Object

    ReceivablesTransactionLine

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the Receivable transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • inventoryItem (Item)

    An object that can be transacted, such as physical product or service offering.

    Business Object

    Item

    Expand all

    Collapse all

    Fields

    • itemId (int64)

      Value that uniquely identifies the part, material, product, or service that's unique as compared with other items by the nature of its attributes.

      Label

      Item

      Properties

      • searchable
      • sortable
      • not nullable
    • organizationId (int64)

      Value that uniquely identifies the organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.

      Label

      Organization

      Properties

      • searchable
      • sortable
      • not nullable

  • lateChargeLine (ReceivablesLateChargeLine)

    The Receivables Late Charge Line business object provides the details of the late charge calculations on each transaction line.

    Business Object

    ReceivablesLateChargeLine

    Expand all

    Collapse all

    Fields

    • interestLineId (int64)

      The identifier of the late charge interest line. This is a primary key of the Late Charge Interest Line view object.

      Label

      Interest Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • linkToTransactionLine (ReceivablesTransactionLine)

    Business Object

    ReceivablesTransactionLine

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the Receivable transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • memoLine (ReceivablesStandardMemoLine)

    The memo line provides information about standard memo lines for invoices, debit memos, on-account credits, debit memo reversals, and chargebacks, including unit of measure, standard price, memo line translation, tax rate code, standard invoicing and revenue scheduling rules, and reference set. It also derives the revenue account when AutoAccounting is based on standard line items.

    Business Object

    ReceivablesStandardMemoLine

    Expand all

    Collapse all

    Fields

    • memoLineSequenceId (int64)

      The sequence identifier of the memo line.

      Label

      Memo Line Sequence ID

      Properties

      • searchable
      • sortable
      • not nullable

  • originalTransactionSource (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

    ReceivablesTransactionSource

    Expand all

    Collapse all

    Fields

    • batchSourceSequenceId (int64)

      The sequence identifier of the transaction source assigned to the transaction batch.

      Label

      Transaction Source Sequence Identifier

      Properties

      • searchable
      • sortable
      • not nullable

  • prepaymentInvoice (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • prepaymentInvoiceLine (ReceivablesTransactionLine)

    A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

    Business Object

    ReceivablesTransactionLine

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the Receivable transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • previousTransaction (ReceivablesTransaction)

    The receivables transaction contains information about transactions, details including transaction number, bill-to-customer, transaction type, transaction date, due date, accounting date, payment terms, and remit-to address, invoices, debit memos, credit memos, and bills receivable are distinguished by their associated transaction types.

    Business Object

    ReceivablesTransaction

    Expand all

    Collapse all

    Fields

    • customerTransactionId (int64)

      The identifier of the transaction used when creating the transaction.

      Label

      Customer Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • previousTransactionLine (ReceivablesTransactionLine)

    A Transaction Line is a specific line item within a transaction record. This line item contains detailed information about a particular transaction related to receivables, such as an invoice, credit memo, debit memo, and bills receivables. The line typically includes details such as item, description, memo line, quantity, unit price, amount, sales order, and tax. For invoices entered manually, the quantity ordered and quantity invoiced are the same. For imported invoices, quantity ordered, quantity invoiced, unit standard price, and unit selling price can differ. Some fields like description, tax rule, quantity ordered, UOM code, unit standard price, and unit selling price are required. The credit memos other than on-account credits, must have a PREVIOUS_CUSTOMER_TRX_LINE_ID value.

    Business Object

    ReceivablesTransactionLine

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the Receivable transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • reason (ERPLookupCode)

    The transaction line reason code.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • receivableTransactionLineDeferredRevenue (ReceivableTransactionLineDeferredRevenue)

    Business Object

    ReceivableTransactionLineDeferredRevenue

    Expand all

    Collapse all

    Fields

    • customerTransactionLineId (int64)

      The identifier of the transaction line revenue deferral transaction line.

      Label

      Customer Transaction Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToContact (CustomerAccountContact)

    The Customer Account Contact provides the details about the designated persons who serve as contacts for the customer account.

    Business Object

    CustomerAccountContact

    Expand all

    Collapse all

    Fields

    • customerAccountContactId (int64)

      Identifier of the customer account contact.

      Label

      Customer Account Contact ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToCustomer (Customer)

    The Customer party represents an entity (either an individual or an organization) that purchases goods or services and to whom invoices and payment requests are issued.

    Business Object

    Customer

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • shipToCustomerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToCustomerContact (Customer)

    The Customer party represents an entity (either an individual or an organization) that purchases goods or services and to whom invoices and payment requests are issued.

    Business Object

    Customer

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • shipToCustomerSite (ReceivablesCustomerAddress)

    The Receivables Customer Address provides the details of the physical or mailing location associated with a customer party site, used for communication, billing, shipping, and tax determination purposes.

    Business Object

    ReceivablesCustomerAddress

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for an address.

      Label

      Site ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • shipToCustomerSitePurpose (AddressUsage)

    Address usage defines how an associated address is used in the application.

    Business Object

    AddressUsage

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the address site usage.

      Label

      Site Usage ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToCustomerSiteUse (CustomerAccountSitePurpose)

    Business Object

    CustomerAccountSitePurpose

    Expand all

    Collapse all

    Fields

    • siteUseId (int64)

      Identifier of the customer account site business purpose.

      Label

      Site Use ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToSiteAddress (CustomerAccountSite)

    Business Object

    CustomerAccountSite

    Expand all

    Collapse all

    Fields

    • customerAccountSiteId (int64)

      Identifier of the customer account site.

      Label

      Customer Account Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxExempt (ERPLookupCode)

    The option that indicates the status of the tax exemption on the transaction line. Valid values are R - Require, E - Exempt, and S - Standard.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • taxExemptReason (StandardLookupCode)

    The tax exemption reason of the customer on a transaction line with the status Exempt.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • taxExemption (TaxExemption)

    A tax exemption is an exemption from all or certain taxes of a state or nation in which part of the taxes that would normally be collected from an individual or an organization are instead foregone.

    Business Object

    TaxExemption

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier for a tax exemption.

      Label

      Exemption ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxLine (TaxLine)

    A tax line represents the tax information associated with a transaction line.

    Business Object

    TaxLine

    Expand all

    Collapse all

    Fields

    • taxLineId (int64)

      The unique identifier of the tax line.

      Label

      Tax Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • warehouse (BusinessUnit)

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

Back to Top