Receivables Lines Interface
The interface table that stores transaction line information.
QName: {http://xmlns.oracle.com/apps/financials/receivables/transactions/invoices/invoiceService/}InterfaceLine
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
|
Contains |
Receivables Transaction Line Region Information Flexfield SDO |
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccountingRuleDuration |
long |
Revenue scheduling rule duration. |
AccountingRuleId |
long |
Identifier of the revenue scheduling rule. |
AccountingRuleName |
string |
Name of the revenue scheduling rule. |
AddressVerificationCode |
string |
Credit card address verification code from the Oracle Payment Server. |
Amount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Amount of the transaction line. |
AmountIncludesTax |
string |
Code that indicates whether the line amount is inclusive of tax. If the value is NULL, use the value on the tax rate code. |
ApplicationId |
long |
Source application importing transactions into Receivables. |
ApprovalCode |
string |
Payment approval code from the credit card issuer. |
AssessableValue |
decimal |
Deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. |
AuthorizationComplete |
string |
Indicates whether the billing for the credit check authorization is complete. |
AuthorizationNumber |
string |
Credit check authorization number linked to the invoice. |
BatchSourceName |
string |
Indicates the transaction source associated with the row. |
BillContactPartyNumber |
string |
Value used to uniquely identify the bill-to contact party for the transaction. |
BillCustomerAccountNumber |
string |
Value used to uniquely identify the bill-to customer account number of the transaction. |
BillCustomerSiteNumber |
string |
Value used to uniquely identify the bill-to customer site for the transaction. |
BillingDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Billing date to use for invoice creation in the format YYYY/MM/DD. |
Comments |
string |
Comments for the transaction line. |
ConsBillingNumber |
string |
Used for custom billing and print formatting. Not used for balance forward bills. |
ContractEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
End date of the contract, if the transaction line is associated with a contract. |
ContractId |
long |
Contract identifier. |
ContractLineAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Either the original item amount on the contract or the new item amount after any credits on the contract, if the transaction line is associated with a contract. |
ContractLineId |
long |
Contract line identifier. |
ContractLineQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Either the original item quantity on the contract or the new item quantity after any credits on the contract, if the transaction line is associated with a contract. |
ContractLineUnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Either the original item unit price on the contract or the new item unit price after any credits on the contract, if the transaction line is associated with a contract. |
ContractStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Start date of the contract, if the transaction line is associated with a contract. For recurring invoices, this is the billing period start date on the first invoice. |
ContractedPeriods |
int |
Number of recurring invoices to issue. |
ConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date used to calculate the currency conversion rate, if the currency on the transaction line is not the ledger currency, in the format YYYY/MM/DD. |
ConversionRate |
decimal |
Conversion rate for the currency on the transaction line, if it is not the ledger currency. |
ConversionType |
string |
Conversion type for the currency on the transaction line. |
CreditMethodForAccountRule |
string |
Credit method for crediting a transaction that uses a revenue scheduling rule. Valid values are PRORATE, UNIT, LIFO. LIFO (Last In First Out) backs out revenue starting with the last general ledger period and reverses all prior periods until it has used up the credit memo. PRORATE credits an equal percentage to all account assignments for the invoice. UNIT reverses the revenue for the number of units specified from an original line of the invoice. Do not use if the line type is TAX or CHARGES, or for header freight charges. |
CreditMethodForInstallments |
string |
Credit method for crediting a transaction that uses split payment terms. Valid values are PRORATE, LIFO, or FIFO or NULL. FIFO (First In First Out) credits the first installment first. LIFO (Last In First Out) credits the last installment first. PRORATE credits the installments of the credited transaction and prorates them based on the amount remaining for each installment. Do not use if the line type is TAX or CHARGES, or when passing header freight charges. |
CurrencyCode |
string |
Three-character currency code of the currency on the transaction line. |
CustomerBankAccountName |
string |
Name of the bill-to customer bank account. |
CustomerTrxTypeName |
string |
Indicates the transaction type associated with the row. |
CustomerTrxTypeSequenceId |
long |
Transaction type identifier. |
DefaultTaxationCountry |
string |
Default taxation country for tax reporting purposes. |
DeferralExclusion |
string |
Option that indicates whether AutoInvoice excludes the transaction line from automated revenue deferral. |
Description |
string |
Description of the transaction line. |
DocumentNumber |
long |
Document number of the transaction. |
DocumentSubType |
string |
In certain countries, a tax or governmental authority defines and classifies document types for reporting purposes. |
EnforceSequenceDateCorrelation |
string |
Value that determines if the chronological document sequencing should be enforced or not. |
ExceptionId |
long |
Tax exception identifier. |
ExemptionId |
long |
Tax exemption identifier. |
FOBPoint |
string |
Free on board point, which is the location at which the ownership title of the goods is transferred from the seller to the buyer. |
FifthOverrideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Override amount for the period captured in the fifth override period. |
FifthOverridePeriod |
long |
Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. |
FifthOverrideQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Override quantity for the period indicated in the fifth override period. |
FinalDischargeLocationCode |
string |
Final destination location code or final customer location where shipment will be sent. |
FinalDischargeLocationId |
long |
Final destination location ID or final customer location where shipment will be sent. |
FirstOverrideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Override amount for the period captured in the fifth override period. |
FirstOverridePeriod |
long |
Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. |
FirstOverrideQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Override quantity for the period indicated in the first override period. |
FirstPtyRegId |
long |
First party tax registration ID of the transaction. Derived from the legal entity of the transaction. |
FirstPtyRegNumber |
string |
First party tax registration number of the transaction. Derived from the legal entity of the transaction. |
FourthOverrideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Override amount for the period captured in the fifth override period. |
FourthOverridePeriod |
long |
Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. |
FourthOverrideQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Override quantity for the period indicated in the fourth override period. |
GlDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Identifies the accounting date of the transaction. Must be in an open or future enterable accounting period. |
IntendedUseClassifId |
long |
Intended use identifier of the transaction line that identifies the purpose for which the product is used. |
InterfaceStatus |
string |
Interface Status. For Oracle Internal use only. |
InternalNotes |
string |
Additional user comments. |
InventoryItemId |
long |
Inventory item identifier for the transaction. |
InvoicedLineAcctgLevel |
string |
Identifies the accounting level for lines eligible for invoice creation in the original system. |
InvoicingRuleId |
long |
Identifier of the invoicing rule on the transaction. |
InvoicingRuleName |
string |
Invoicing rule name for the transaction. Valid values are Advance Invoice and Arrears Invoice. This column is optional. For invoice lines with rules, you must enter a value. Use either InvoicingRuleId or InvoicingRuleName, but not both. |
ItemNumber |
string |
Inventory item number of the line item. |
LastPeriodToCredit |
int |
Last period number for crediting. Credit memo use only. Must be between 0 and the invoice accounting rule duration (inclusive). Positive integers only. |
LastTrxDebitAuth |
string |
Specifies whether a transaction is the last one of a recurrent series of ISO20022 direct debit collections for a given debit authorization. Valid values are Y and N. |
LegalEntityId |
long |
Identifies the legal entity responsible for issuing the transaction line. |
LineIntendedUse |
string |
Code used to classify items when the intended use of the item is a factor in tax determination. |
LineType |
string |
Specifies the line type for the transaction. Valid values are LINE, TAX, FREIGHT, CHARGES. (CHARGES refers to finance charges.) Required column. For credit memos enter the type of line you are crediting. |
MemoLineName |
string |
Name of the standard memo line for the transaction. |
MemoLineSequenceId |
long |
Standard memo line sequence ID for the transaction. |
OrgId |
long |
Indicates the identifier of the business unit associated with the row. |
OrigSystemBatchName |
string |
Original batch identifier from the source system. |
OrigSystemBillAddressId |
long |
Identifier that uniquely identifies the bill-to customer address from the feeder system. |
OrigSystemBillAddressReference |
string |
Reference value used to uniquely identify the bill-to customer address from the feeder system. |
OrigSystemBillContactId |
long |
Identifier that uniquely identifies the bill-to customer contact from the feeder system. |
OrigSystemBillContactReference |
string |
Reference value used to uniquely identify the bill-to customer contact from the feeder system. |
OrigSystemBillCustomerId |
long |
Identifier that uniquely identifies the bill-to customer from the feeder system. |
OrigSystemBillCustomerReference |
string |
Reference value used to uniquely identify the bill-to customer from the feeder system. |
OrigSystemShipAddressId |
long |
Identifier that uniquely identifies the customer account ship-to address from the feeder system. |
OrigSystemShipAddressReference |
string |
Reference value used to uniquely identify the customer account ship-to address from the feeder system. |
OrigSystemShipContactId |
long |
Identifier that uniquely identifies the customer account ship-to contact from the feeder system. |
OrigSystemShipContactReference |
string |
Reference value used to uniquely identify the customer account ship-to contact from the feeder system. |
OrigSystemShipCustomerId |
long |
Identifier that uniquely identifies the ship-to customer account from the feeder system. |
OrigSystemShipCustomerReference |
string |
Reference value used to uniquely identify the ship-to customer account from the feeder system. |
OrigSystemShipPartyId |
long |
Identifier that uniquely identifies the ship-to customer from the feeder system. |
OrigSystemShipPartyReference |
string |
Reference value used to uniquely identify the ship-to customer from the feeder system. |
OrigSystemShipPartySiteId |
long |
Identifier that uniquely identify the customer ship-to address from the feeder system. |
OrigSystemShipPartySiteReference |
string |
Reference value used to uniquely identify the customer ship-to address from the feeder system. |
OrigSystemShipPtyContactId |
long |
Identifier that uniquely identifies the customer ship-to contact from the feeder system. |
OrigSystemShipPtyContactReference |
string |
Reference value used to uniquely identify the customer ship-to contact from the feeder system. |
OrigSystemSoldCustomerId |
long |
Identifier that uniquely identifies the sold-to customer account from the feeder system. |
OrigSystemSoldCustomerReference |
string |
Reference value used to identify the sold-to customer account from the feeder system. |
OrigSystemSoldPartyId |
long |
Identifier that uniquely identifies the sold-to customer from the feeder system. |
OrigSystemSoldPartyReference |
string |
Reference value used to identify the sold-to customer from the feeder system. |
OverrideAutoAccounting |
string |
Option that indicates whether AutoInvoice uses the deferred revenue account provided through the interface table for revenue accounting. If not enabled, AutoInvoice uses the accounts generated by AutoAccounting. |
PaymentAttributes |
string |
Payment attributes used for grouping transaction lines. |
PaymentServerOrderNumber |
string |
Number that indicates whether the credit card payment was authorized by the Oracle Payment Server. |
PaymentSetId |
long |
Identifies the prepayment application payment set ID. |
PaymentTermsId |
long |
Identifier of the payment terms associated with the row. |
PaymentTermsName |
string |
Indicates the name of the payment terms associated with the row. |
PaymentTrxnExtensionId |
long |
Oracle Fusion Payments transaction identifier for processing a credit card or bank account payment. For internal use only. |
Periodicity |
string |
Period of the recurring invoice. Valid values are DAY, WEEK, MONTH, QUARTER, YEAR. A value is required if RecurringBill is Y. |
PrimarySalesrepNumber |
string |
Number that identifies the primary salesperson. |
PrintingOption |
string |
Indicates whether the transaction can be printed. |
ProdFcCategId |
long |
Product fiscal classification identifier of the inventory item. |
ProductCategory |
string |
Code used to classify non-inventory items and other special product classification needs for tax determination or tax reporting purposes. |
ProductFiscClassification |
string |
Code used to classify products that have a tax requirement for tax determination or tax reporting purposes. |
ProductType |
string |
Identifies a transaction line item for tax purposes. Valid values are Goods and Services. |
PurchaseOrder |
string |
Purchase order number for the transaction. |
PurchaseOrderDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date of the purchase order. |
PurchaseOrderRevision |
string |
Purchase order revision number. |
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Either the number of units shipped on a transaction line, or the number of units on a credit memo line. |
QuantityOrdered |
decimal |
Original number of units customer sales ordered for the transaction. |
ReasonCode |
string |
Reason code for the transaction. |
ReasonCodeMeaning |
string |
Credit memo reason code meaning. |
ReceiptMethodId |
long |
Identifier of the receipt method for the transaction. |
ReceiptMethodName |
string |
Name of the receipt method for the transaction. |
RecurringBill |
string |
Option that indicates whether the transaction line is for a recurring invoice. Valid values are Y, N, and Null. Null is the same as N. |
ReferenceLineId |
long |
Reference line identifier. |
RelatedBatchSourceName |
string |
Name of the batch source of the document to which the transaction is related. |
RelatedTrxNumber |
string |
Document number to which the transaction is related. |
ResetTrxDate |
string |
Option that indicates whether AutoInvoice resets the transaction date to the accounting date when the transaction date is not passed. |
ResourceSalesrepId |
long |
Primary salesperson identifier for the transaction. |
RuleEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date to end the revenue scheduling rule for a transaction. |
RuleStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date that to start the revenue scheduling rule for a transaction. |
SalesOrder |
string |
Sales order number. |
SalesOrderDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Sales order date/RMA date in the format YYYY/MM/DD. |
SalesOrderLine |
string |
Sales order line number for the transaction. |
SalesOrderRevision |
decimal |
Sales order revision number. |
SalesOrderSource |
string |
Source of the sales order. |
SalesTaxId |
long |
Sales tax identifier. |
SecondBillingPeriodStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
For recurring invoices, the start date of the billing period on the second invoice, if the first invoice did not cover a full billing period. |
SecondInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Transaction date of the second invoice for recurring invoices, if the first invoice was for a partial period. |
SecondOverrideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The override amount for the period captured in the fifth override period. |
SecondOverridePeriod |
long |
Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. |
SecondOverrideQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Override quantity for the period indicated in the second override period. |
SetOfBooksId |
long |
Primary ledger identifier. |
ShipContactPartyNumber |
string |
Value used to uniquely identify the ship-to contact party for the transaction. |
ShipCustomerAccountNumber |
string |
Value used to uniquely identify the ship-to customer account for the transaction. |
ShipCustomerSiteNumber |
string |
Value used to uniquely identify the ship-to customer site for the transaction. |
ShipDateActual |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Shipment date. |
ShipVia |
string |
Code that identifies the shipping method. |
SoldCustomerAccountNumber |
string |
Sold-to customer account for the transaction. |
SourceApplicationId |
long |
Source application identifier. Used for tax purposes. |
SourceEntityCode |
string |
Source entity code. Used for tax purposes. |
SourceEventClassCode |
string |
Source event class code. Used for tax purposes. |
SourceTrxDetailTaxLineId |
long |
Source transaction detail tax line identifier. Used for tax purposes. |
SourceTrxId |
long |
Source transaction identifier. Used for tax purposes. |
SourceTrxLineId |
long |
Source transaction line identifier. Used for tax purposes. |
SourceTrxLineType |
string |
Source transaction line type. Used for tax purposes. |
Tax |
string |
Code that represents a charge imposed by a fiscal or tax authority within a tax regime. |
TaxCode |
string |
Tax classification code assigned to the transaction line. Required if LineType is TAX. Do not use if LineType is CHARGES or FREIGHT. |
TaxExempt |
string |
Indicates the applicable tax exemption value for the transaction line. |
TaxExemptNumber |
string |
Number of the tax exemption certificate for line items that have the Tax Exempt option set to E (Exempt). Use if LineType is LINE and Tax Exempt is E. Otherwise, leave blank. |
TaxExemptReasonCode |
string |
Code that provides the reason for a tax exemption for a line item. |
TaxExemptReasonCodeMeaning |
string |
Text description of the code entered in the Tax Exempt Reason Code column. |
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date on a fiscal document generated during the shipment of goods. |
TaxInvoiceNumber |
string |
Number on a fiscal document generated during the shipment of goods. |
TaxJurisdictionCode |
string |
Code that represents a geographic area where taxes are levied, defined within the scope of a tax and tax regime. |
TaxPrecedence |
decimal |
Number that indicates the order in which a tax is calculated in the compounding process, when more than one tax applies to an invoice line. Taxes are calculated in ascending order of compounding precedence. |
TaxRate |
decimal |
Tax rate for a tax line. If LineType is TAX, enter a value for either this or the AMOUNT column. Do not use if LineType is LINE, CHARGES, or FREIGHT. |
TaxRateCode |
string |
Code that represents the numeric value for calculating the amount of a certain tax, defined within the scope of a tax status, tax, and tax regime. |
TaxRegimeCode |
string |
Code that represents a high-level entity for defining a common set of tax rules for one or more taxes with the same tax requirement. |
TaxStatusCode |
string |
Code that represents the taxable nature of a product in the context of a transaction and a specific tax on the transaction, defined within the scope of a tax and tax regime. |
Taxable |
string |
Determines whether the current line is taxable. Valid values are Y, N, and NULL. |
TaxableAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Calculated taxable basis amount. The tax amount is derived by applying the tax rate to the taxable amount. |
ThirdOverrideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The override amount for the period captured in the fifth override period. |
ThirdOverridePeriod |
long |
Number indicating the period that has an override amount. For example, the first invoice is for period 1, the second invoice is for period 2, and so on. |
ThirdOverrideQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Override quantity for the period indicated in the third override period. |
ThirdPtyRegId |
long |
Third party tax registration identifier of the transaction, derived from the bill-to customer of the transaction. |
ThirdPtyRegNumber |
string |
Third party tax registration number of the transaction, derived from the bill-to customer of the transaction. |
TransactionInterfaceGdf |
Receivables Transaction Region Information global descriptive flexfield belonging to the lines interface table. |
|
TransactionInterfaceHeaderDff |
Receivables Transaction Header Flexfield. |
|
TransactionInterfaceLineDff |
Line Transactions descriptive flexfield belonging to the lines interface table. |
|
TransactionInterfaceLinkToDff |
Link-to Transactions descriptive flexfield belonging to the lines interface table. |
|
TransactionInterfaceReferenceDff |
Reference Transactions descriptive flexfield belonging to the lines interface table. |
|
TransactionLineDff |
Invoice Lines descriptive flexfield belonging to the lines interface table. |
|
TransactionLineInterfaceGdf |
Receivables Transaction Line Region Information global descriptive flexfield belonging to the lines interface table. |
|
TranslatedDescription |
string |
Translated description of the transaction line. |
TrxBusinessCategory |
string |
Code used to classify business transactions for tax purposes. |
TrxDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Transaction date in the format YYYY/MM/DD. |
TrxNumber |
string |
Identifier of the transaction, either generated automatically or provided by the user. |
UOMCode |
string |
Unit of measure code. |
UOMName |
string |
Unit of measure name. |
UnitSellingPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Selling price per unit. |
UnitStandardPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Sales item standard price per unit in inventory. |
UserDefinedFiscClass |
string |
Code used to classify any tax requirements not defined using the existing fiscal classification types. |
VATTaxId |
long |
Value added tax identifier. |
WarehouseCode |
string |
Inventory organization code indicating the ship-from location. |
WarehouseId |
long |
Inventory organization identifier indicating the ship-from location. |
WaybillNumber |
string |
Waybill number. |