Transaction Header
The transaction header view object contains information about transactions, 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.
Data Store Key : FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionHeaderExtractPVO
Primary Keys : RaCustomerTrxCustomerTrxId
Initial Extract Date : RaCustomerTrxCreationDate
Incremental Extract Date : RaCustomerTrxLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
RaCustomerTrxAddressVerificationCode | The code that verifies the credit card address of the bill-to customer. |
RaCustomerTrxAgreementId | The identifier of the customer agreement used when creating a transaction. |
RaCustomerTrxApplicationId | The identifier of the application that imported transactions into Receivables. |
RaCustomerTrxApprovalCode | The payment approval code from the credit card issuer to indicate that funds are available. |
RaCustomerTrxAttribute1 | A segment of the Receivables Transaction descriptive flexfield 1. |
RaCustomerTrxAttribute10 | A segment of the Receivables Transaction descriptive flexfield 10. |
RaCustomerTrxAttribute11 | A segment of the Receivables Transaction descriptive flexfield 11. |
RaCustomerTrxAttribute12 | A segment of the Receivables Transaction descriptive flexfield 12. |
RaCustomerTrxAttribute13 | A segment of the Receivables Transaction descriptive flexfield 13. |
RaCustomerTrxAttribute14 | A segment of the Receivables Transaction descriptive flexfield 14. |
RaCustomerTrxAttribute15 | A segment of the Receivables Transaction descriptive flexfield 15. |
RaCustomerTrxAttribute2 | A segment of the Receivables Transaction descriptive flexfield 2. |
RaCustomerTrxAttribute3 | A segment of the Receivables Transaction descriptive flexfield 3. |
RaCustomerTrxAttribute4 | A segment of the Receivables Transaction descriptive flexfield 4. |
RaCustomerTrxAttribute5 | A segment of the Receivables Transaction descriptive flexfield 5. |
RaCustomerTrxAttribute6 | A segment of the Receivables Transaction descriptive flexfield 6. |
RaCustomerTrxAttribute7 | A segment of the Receivables Transaction descriptive flexfield 7. |
RaCustomerTrxAttribute8 | A segment of the Receivables Transaction descriptive flexfield 8. |
RaCustomerTrxAttribute9 | A segment of the Receivables Transaction descriptive flexfield 9. |
RaCustomerTrxAttributeCategory | The descriptive flexfield context name of the Receivables Transaction descriptive flexfield. |
RaCustomerTrxAttributeDate1 | A segment of the Receivables Transaction Date descriptive flexfield 1. |
RaCustomerTrxAttributeDate2 | A segment of the Receivables Transaction Date descriptive flexfield 2. |
RaCustomerTrxAttributeDate3 | A segment of the Receivables Transaction Date descriptive flexfield 3. |
RaCustomerTrxAttributeDate4 | A segment of the Receivables Transaction Date descriptive flexfield 4. |
RaCustomerTrxAttributeDate5 | A segment of the Receivables Transaction Date descriptive flexfield 5. |
RaCustomerTrxAttributeNumber1 | A segment of the Receivables Transaction Number descriptive flexfield 1. |
RaCustomerTrxAttributeNumber2 | A segment of the Receivables Transaction Number descriptive flexfield 2. |
RaCustomerTrxAttributeNumber3 | A segment of the Receivables Transaction Number descriptive flexfield 3. |
RaCustomerTrxAttributeNumber4 | A segment of the Receivables Transaction Number descriptive flexfield 4. |
RaCustomerTrxAttributeNumber5 | A segment of the Receivables Transaction Number descriptive flexfield 5. |
RaCustomerTrxBatchId | The identifier of the transaction batch used to create the transaction. |
RaCustomerTrxBatchSourceSeqId | The identifier of the transaction source assigned to the transaction. |
RaCustomerTrxBillPlanPeriod | The period that identifies the number of recurring invoices for the bill plan. |
RaCustomerTrxBillTemplateId | The identifier of the template used to print transactions. |
RaCustomerTrxBillTemplateName | The template used to print transactions. This template is also used to preview the transaction through the ADF UI. |
RaCustomerTrxBillToAddressId | The identifier of the bill-to customer address assigned to the transaction. |
RaCustomerTrxBillToContactId | The identifier of the bill-to customer contact assigned to the transaction. |
RaCustomerTrxBillToCustomerId | The identifier of the bill-to customer assigned to the transaction. |
RaCustomerTrxBillToSiteUseId | The identifier of the bill-to customer site use assigned to the transaction. |
RaCustomerTrxBillingDate | The date when the balance forward bill transactions are billed. |
RaCustomerTrxBillingExtRequestId | The request that processed the billing line details of the document. |
RaCustomerTrxBrAmount | The total amount of a bill receivable with all the debit and credit items. |
RaCustomerTrxBrOnHoldFlag | The option that indicates that the bill receivable is on hold and can't be remitted. |
RaCustomerTrxBrUnpaidFlag | The option that indicates that the drawee failed to pay the bill receivable on the maturity date. |
RaCustomerTrxCcErrorCode | The error code generated from the credit card payment processor. |
RaCustomerTrxCcErrorFlag | The option that indicates whether a credit card processing error exists. |
RaCustomerTrxCcErrorText | The user enterable description for the credit card error code. |
RaCustomerTrxComments | The user-entered comments associated with the transaction. |
RaCustomerTrxCompleteFlag | The option that indicates whether a transaction is complete. |
RaCustomerTrxControlCompletionReasonCode | Lookup codes under the ORA_AR_CNTRL_COMPLETION_REASON lookup type that determine the reason for control on transaction completion. Valid values are NEGATIVE_LINE_AMT, ALL, ALLOWED_TO_COMPLETE. The value is updated to ALLOWED_TO_COMPLETE using the Web Service once the transaction is reviewed and validated. |
RaCustomerTrxCreatedBy | The user who created the Receivables transaction. |
RaCustomerTrxCreatedFrom | The option that indicates from which application the transaction is created. |
RaCustomerTrxCreationDate | The date and time the transaction was created. |
RaCustomerTrxCreditMethodForInstallments | The credit method for invoices with multiple installments. A list of accepted values is defined in the lookup type CREDIT_METHOD_FOR_INSTALLMENTS. |
RaCustomerTrxCreditMethodForRules | The credit method for invoices with rules. A list of accepted values is defined in the lookup type CREDIT_METHOD_FOR_RULES. |
RaCustomerTrxCtReference | The reference field derived from the Interface Header attribute based on the batch source. |
RaCustomerTrxCustTrxTypeSeqId | The identifier of the transaction type sequence. |
RaCustomerTrxCustomerBankAccountId | The identifier of the customer bank account. |
RaCustomerTrxCustomerReference | The reference for the customer transaction. |
RaCustomerTrxCustomerReferenceDate | The reference date for the customer transaction. |
RaCustomerTrxCustomerTrxId | The identifier of the transaction used when creating the transaction. |
RaCustomerTrxDefaultTaxExemptFlag | The option that indicates whether the transaction has a default value for tax exemption processing. |
RaCustomerTrxDefaultTaxationCountry | The default country used to calculate tax. |
RaCustomerTrxDelContactEmailAddress | The email address of the customer bill-to contact who receives printed transactions. |
RaCustomerTrxDeliveryMethodCode | The method used to deliver printed transactions. Valid values are E-Mail, Paper, and XML. |
RaCustomerTrxDocSequenceId | The identifier of the transaction document sequence. |
RaCustomerTrxDocSequenceValue | The transaction document sequence number. |
RaCustomerTrxDocumentCreationDate | The date when the document is created in the source application for Revenue Management. |
RaCustomerTrxDocumentSubType | The document fiscal classification used in tax determination for the transaction. |
RaCustomerTrxDocumentTypeId | The identifier of the source document type used to integrate transactions with Revenue Management as revenue lines. |
RaCustomerTrxDraweeBankAccountId | The identifier of the bill receivable drawee bank account. |
RaCustomerTrxDraweeContactId | The identifier of the bill receivable drawee contact used when creating the transaction. |
RaCustomerTrxDraweeId | The identifier of the bill receivable drawee. |
RaCustomerTrxDraweeSiteUseId | The identifier of the bill receivable drawee site use. |
RaCustomerTrxExchangeDate | The date when the transaction currency was converted. |
RaCustomerTrxExchangeRate | The conversion rate used to convert the transaction currency. |
RaCustomerTrxExchangeRateType | The conversion type used to convert the transaction currency. |
RaCustomerTrxFinanceCharges | The option that indicates whether the transaction is exempt from late charges. |
RaCustomerTrxFirstPtyRegId | The tax registration number of the deploying company. |
RaCustomerTrxFiscalDocAccessKey | The identifier for the fiscal document in the government system. |
RaCustomerTrxFiscalDocStatus | The status of the fiscal document returned by the fiscal authority. If a fiscal document request originates from shipping and the fiscal document is approved without error, shipping can ship the goods. Similarly, if the request is made from Receivables, Receivables invoices can be completed after the fiscal document is approved. |
RaCustomerTrxFobPoint | The Free On Board point, where the title of goods transfers from the seller to the buyer. |
RaCustomerTrxGlobalAttribute1 | A segment of the Receivables Transaction global descriptive flexfield 1. |
RaCustomerTrxGlobalAttribute10 | A segment of the Receivables Transaction global descriptive flexfield 10. |
RaCustomerTrxGlobalAttribute11 | A segment of the Receivables Transaction global descriptive flexfield 11. |
RaCustomerTrxGlobalAttribute12 | A segment of the Receivables Transaction global descriptive flexfield 12. |
RaCustomerTrxGlobalAttribute13 | A segment of the Receivables Transaction global descriptive flexfield 13. |
RaCustomerTrxGlobalAttribute14 | A segment of the Receivables Transaction global descriptive flexfield 14. |
RaCustomerTrxGlobalAttribute15 | A segment of the Receivables Transaction global descriptive flexfield 15. |
RaCustomerTrxGlobalAttribute16 | A segment of the Receivables Transaction global descriptive flexfield 16. |
RaCustomerTrxGlobalAttribute17 | A segment of the Receivables Transaction global descriptive flexfield 17. |
RaCustomerTrxGlobalAttribute18 | A segment of the Receivables Transaction global descriptive flexfield 18. |
RaCustomerTrxGlobalAttribute19 | A segment of the Receivables Transaction global descriptive flexfield 19. |
RaCustomerTrxGlobalAttribute2 | A segment of the Receivables Transaction global descriptive flexfield 2. |
RaCustomerTrxGlobalAttribute20 | A segment of the Receivables Transaction global descriptive flexfield 20. |
RaCustomerTrxGlobalAttribute21 | A segment of the Receivables Transaction global descriptive flexfield 21. |
RaCustomerTrxGlobalAttribute22 | A segment of the Receivables Transaction global descriptive flexfield 22. |
RaCustomerTrxGlobalAttribute23 | A segment of the Receivables Transaction global descriptive flexfield 23. |
RaCustomerTrxGlobalAttribute24 | A segment of the Receivables Transaction global descriptive flexfield 24. |
RaCustomerTrxGlobalAttribute25 | A segment of the Receivables Transaction global descriptive flexfield 25. |
RaCustomerTrxGlobalAttribute26 | A segment of the Receivables Transaction global descriptive flexfield 26. |
RaCustomerTrxGlobalAttribute27 | A segment of the Receivables Transaction global descriptive flexfield 27. |
RaCustomerTrxGlobalAttribute28 | A segment of the Receivables Transaction global descriptive flexfield 28. |
RaCustomerTrxGlobalAttribute29 | A segment of the Receivables Transaction global descriptive flexfield 29. |
RaCustomerTrxGlobalAttribute3 | A segment of the Receivables Transaction global descriptive flexfield 3. |
RaCustomerTrxGlobalAttribute30 | A segment of the Receivables Transaction global descriptive flexfield 30. |
RaCustomerTrxGlobalAttribute4 | A segment of the Receivables Transaction global descriptive flexfield 4. |
RaCustomerTrxGlobalAttribute5 | A segment of the Receivables Transaction global descriptive flexfield 5. |
RaCustomerTrxGlobalAttribute6 | A segment of the Receivables Transaction global descriptive flexfield 6. |
RaCustomerTrxGlobalAttribute7 | A segment of the Receivables Transaction global descriptive flexfield 7. |
RaCustomerTrxGlobalAttribute8 | A segment of the Receivables Transaction global descriptive flexfield 8. |
RaCustomerTrxGlobalAttribute9 | A segment of the Receivables Transaction global descriptive flexfield 9. |
RaCustomerTrxGlobalAttributeCategory | The descriptive flexfield context name of the Receivables Transaction global descriptive flexfield. |
RaCustomerTrxGlobalAttributeDate1 | A segment of the Receivables Transaction Date global descriptive flexfield 1. |
RaCustomerTrxGlobalAttributeDate2 | A segment of the Receivables Transaction Date global descriptive flexfield 2. |
RaCustomerTrxGlobalAttributeDate3 | A segment of the Receivables Transaction Date global descriptive flexfield 3. |
RaCustomerTrxGlobalAttributeDate4 | A segment of the Receivables Transaction Date global descriptive flexfield 4. |
RaCustomerTrxGlobalAttributeDate5 | A segment of the Receivables Transaction Date global descriptive flexfield 5. |
RaCustomerTrxGlobalAttributeNumber1 | A segment of the Receivables Transaction Number global descriptive flexfield 1. |
RaCustomerTrxGlobalAttributeNumber10 | A segment of the Receivables Transaction Number global descriptive flexfield 10. |
RaCustomerTrxGlobalAttributeNumber11 | A segment of the Receivables Transaction Number global descriptive flexfield 11. |
RaCustomerTrxGlobalAttributeNumber12 | A segment of the Receivables Transaction Number global descriptive flexfield 12. |
RaCustomerTrxGlobalAttributeNumber2 | A segment of the Receivables Transaction Number global descriptive flexfield 2. |
RaCustomerTrxGlobalAttributeNumber3 | A segment of the Receivables Transaction Number global descriptive flexfield 3. |
RaCustomerTrxGlobalAttributeNumber4 | A segment of the Receivables Transaction Number global descriptive flexfield 4. |
RaCustomerTrxGlobalAttributeNumber5 | A segment of the Receivables Transaction Number global descriptive flexfield 5. |
RaCustomerTrxGlobalAttributeNumber6 | A segment of the Receivables Transaction Number global descriptive flexfield 6. |
RaCustomerTrxGlobalAttributeNumber7 | A segment of the Receivables Transaction Number global descriptive flexfield 7. |
RaCustomerTrxGlobalAttributeNumber8 | A segment of the Receivables Transaction Number global descriptive flexfield 8. |
RaCustomerTrxGlobalAttributeNumber9 | A segment of the Receivables Transaction Number global descriptive flexfield 9. |
RaCustomerTrxInitialCustomerTrxId | The identifier of the initial transaction number. |
RaCustomerTrxIntercompanyFlag | The option that indicates whether an invoice is intercompany. |
RaCustomerTrxInterestHeaderId | The identifier of the interest header of the late charge batch header for which the transaction is created. |
RaCustomerTrxInterfaceHeaderAttribute1 | The interface header attribute of the interfaceHeaderAttribute 1. |
RaCustomerTrxInterfaceHeaderAttribute10 | The interface header attribute of the interfaceHeaderAttribute 10. |
RaCustomerTrxInterfaceHeaderAttribute11 | The interface header attribute of the interfaceHeaderAttribute 11. |
RaCustomerTrxInterfaceHeaderAttribute12 | The interface header attribute of the interfaceHeaderAttribute 12. |
RaCustomerTrxInterfaceHeaderAttribute13 | The interface header attribute of the interfaceHeaderAttribute 13. |
RaCustomerTrxInterfaceHeaderAttribute14 | The interface header attribute of the interfaceHeaderAttribute 14. |
RaCustomerTrxInterfaceHeaderAttribute15 | The interface header attribute of the interfaceHeaderAttribute 15. |
RaCustomerTrxInterfaceHeaderAttribute2 | The interface header attribute of the interfaceHeaderAttribute 2. |
RaCustomerTrxInterfaceHeaderAttribute3 | The interface header attribute of the interfaceHeaderAttribute 3. |
RaCustomerTrxInterfaceHeaderAttribute4 | The interface header attribute of the interfaceHeaderAttribute 4. |
RaCustomerTrxInterfaceHeaderAttribute5 | The interface header attribute of the interfaceHeaderAttribute 5. |
RaCustomerTrxInterfaceHeaderAttribute6 | The interface header attribute of the interfaceHeaderAttribute 6. |
RaCustomerTrxInterfaceHeaderAttribute7 | The interface header attribute of the interfaceHeaderAttribute 7. |
RaCustomerTrxInterfaceHeaderAttribute8 | The interface header attribute of the interfaceHeaderAttribute 8. |
RaCustomerTrxInterfaceHeaderAttribute9 | The interface header attribute of the interfaceHeaderAttribute 9. |
RaCustomerTrxInterfaceHeaderContext | The interface header context for InterfaceHeaderContext. |
RaCustomerTrxInterfaceHeaderDate1 | A segment of the Interface Header Date descriptive flexfield 1. |
RaCustomerTrxInterfaceHeaderDate2 | A segment of the Interface Header Date descriptive flexfield 2. |
RaCustomerTrxInterfaceHeaderDate3 | A segment of the Interface Header Date descriptive flexfield 3. |
RaCustomerTrxInterfaceHeaderDate4 | A segment of the Interface Header Date descriptive flexfield 4. |
RaCustomerTrxInterfaceHeaderDate5 | A segment of the Interface Header Date descriptive flexfield 5. |
RaCustomerTrxInterfaceHeaderNumber1 | A segment of the Interface Header Number descriptive flexfield 1. |
RaCustomerTrxInterfaceHeaderNumber2 | A segment of the Interface Header Number descriptive flexfield 2. |
RaCustomerTrxInterfaceHeaderNumber3 | A segment of the Interface Header Number descriptive flexfield 3. |
RaCustomerTrxInterfaceHeaderNumber4 | A segment of the Interface Header Number descriptive flexfield 4. |
RaCustomerTrxInterfaceHeaderNumber5 | A segment of the Interface Header Number descriptive flexfield 5. |
RaCustomerTrxInternalNotes | The internal notes associated with the transaction. |
RaCustomerTrxInvoiceCurrencyCode | The code of the invoice transaction currency. |
RaCustomerTrxInvoicingRuleId | The identifier of the invoicing rule used in the transaction. |
RaCustomerTrxLastPrintedSequenceNum | The last printed document sequence number. |
RaCustomerTrxLastUpdateDate | The date and time the transaction was last updated. |
RaCustomerTrxLastUpdateLogin | The session login of the user who last updated the transaction. |
RaCustomerTrxLastUpdatedBy | The user who last updated the transaction. |
RaCustomerTrxLateChargesAssessed | The option that indicates whether late charges are assessed on the transaction. |
RaCustomerTrxLegalEntityId | The identifier of the legal entity associated with the transaction. |
RaCustomerTrxObjectVersionNumber | The number 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. |
RaCustomerTrxOldTrxNumber | The column that stores the value of the old document sequence number. |
RaCustomerTrxOrgId | The identifier of the business unit associated with the transaction. |
RaCustomerTrxOrigSystemBatchName | The batch name derived from the originating system. |
RaCustomerTrxOverrideRemitAccountFlag | The option that indicates whether the remittance bank account can be overridden. |
RaCustomerTrxPayingCustomerId | The identifier of the paying customer. |
RaCustomerTrxPayingSiteUseId | The identifier of the paying customer site. |
RaCustomerTrxPaymentAttributes | The attribute used to group transactions for payment processing. |
RaCustomerTrxPaymentServerOrderNum | The number of the payment server order originated from Payments. |
RaCustomerTrxPaymentTrxnExtensionId | The identifier of the payment transaction extension for credit card or bank account payment processing. |
RaCustomerTrxPostingControlId | The identifier of the transaction posting status. |
RaCustomerTrxPrepaymentFlag | The option that indicates whether prepayment exists for the transaction in anticipation of the provision of goods or services. |
RaCustomerTrxPreviousCustomerTrxId | The identifier of the previous transaction number associated with a credit memo. |
RaCustomerTrxPrimaryResourceSalesrepId | The identifier of the primary salesperson. This is the primary key of the Primary Salesperson Number view object. |
RaCustomerTrxPrintRequestId | The option that indicates the request identifier of the last print from the Enterprise Service Scheduler. |
RaCustomerTrxPrintingCount | The count of the number of times a transaction has been printed. |
RaCustomerTrxPrintingLastPrinted | The date when the transaction was last printed. |
RaCustomerTrxPrintingOption | The option that indicates whether printing is enabled for the transaction. |
RaCustomerTrxPrintingOriginalDate | The date the transaction was first printed. |
RaCustomerTrxPrintingPending | The status that indicates whether the transaction has finished printing. |
RaCustomerTrxProgramApplicationId | The application that last updated the transaction. |
RaCustomerTrxProgramId | The process that last updated the transaction. |
RaCustomerTrxProgramUpdateDate | The date a process last updated the transaction. |
RaCustomerTrxPurchaseOrder | The purchase order number assigned to the transaction. |
RaCustomerTrxPurchaseOrderDate | The purchase order date. |
RaCustomerTrxPurchaseOrderRevision | The number that identifies revisions to the purchase order. |
RaCustomerTrxRaCustomerTrxBillPlanId | The identifier of the recurring bill plan. |
RaCustomerTrxReadyForXmlDeliveryFlag | The option that indicates whether the transaction is eligible for XML invoice delivery. |
RaCustomerTrxReasonCode | The reason code associated with the transaction. |
RaCustomerTrxReceiptMethodId | The identifier of the receipt method assigned to the transaction. |
RaCustomerTrxRecurredFromTrxNumber | The original transaction number used to copy a transaction. |
RaCustomerTrxRelatedBatchSourceSeqId | The identifier of the related transaction source sequence. |
RaCustomerTrxRelatedCustomerTrxId | The identifier of the related customer on the transaction. |
RaCustomerTrxRemitBankAcctUseId | The identifier of the remittance bank account used for the transaction. |
RaCustomerTrxRemitToAddressId | The identifier of the remit-to address on the transaction. |
RaCustomerTrxRemitToAddressSeqId | The identifier of the remit-to address sequence on the transaction. |
RaCustomerTrxRemittanceBankAccountId | The identifier of the bill receivable drawee remittance bank account. |
RaCustomerTrxRemittanceBatchId | The identifier of the remittance batch used by the bill receivable. |
RaCustomerTrxRequestId | The request identifier of the process that created or last updated the transaction. |
RaCustomerTrxRequiresManualScheduling | The option that indicates whether manual scheduling is required. |
RaCustomerTrxRevRecApplication | The option that indicates whether the application is used for revenue recognition. |
RaCustomerTrxReversedCashReceiptId | The identifier of the reversed cash receipt. |
RaCustomerTrxSetOfBooksId | The identifier of the ledger associated with the interface line. |
RaCustomerTrxShipDateActual | The date the goods were shipped to the customer. |
RaCustomerTrxShipToAddressId | The identifier of the ship-to customer address. |
RaCustomerTrxShipToContactId | The identifier of the ship-to customer contact. |
RaCustomerTrxShipToCustomerId | The identifier of the ship-to customer. |
RaCustomerTrxShipToPartyAddressId | The identifier of the ship-to party address. |
RaCustomerTrxShipToPartyContactId | The identifier of the ship-to party contact. |
RaCustomerTrxShipToPartyId | The identifier of the ship-to party. |
RaCustomerTrxShipToPartySiteUseId | The identifier of the ship-to party site use. |
RaCustomerTrxShipToSiteUseId | The identifier of the ship-to site use. |
RaCustomerTrxShipVia | The party that ships the goods to the customer. |
RaCustomerTrxShipmentId | The identifier of the shipment. |
RaCustomerTrxSoldToContactId | The identifier of the sold-to customer contact. |
RaCustomerTrxSoldToCustomerId | The identifier of the sold-to customer. |
RaCustomerTrxSoldToPartyId | The identifier of the sold-to party. |
RaCustomerTrxSoldToSiteUseId | The identifier of the sold-to site use. |
RaCustomerTrxSourceDocumentId | The identifier of the source document. |
RaCustomerTrxSourceDocumentType | The identifier of the source document type. |
RaCustomerTrxSourceSystem | The source system sending the data from the source to Revenue Management. |
RaCustomerTrxSpecialInstructions | The special instructions printed on an invoice. |
RaCustomerTrxSrcInvoicingRuleId | The invoice rule internal identifier for the invoices with revenue managed by Revenue Management. |
RaCustomerTrxStatusTrx | The status that indicates whether the transaction is complete or incomplete. |
RaCustomerTrxStructuredPaymentReference | An industry standard reference on receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, transaction lines, and payments to the customer and bank. |
RaCustomerTrxTermDueDate | The identifier of the payment terms due date. |
RaCustomerTrxTermId | The identifier of the payment terms. |
RaCustomerTrxTerritoryId | The identifier of the territory. |
RaCustomerTrxThirdPtyRegId | The tax registration number of the bill-to customer. |
RaCustomerTrxTrxBusinessCategory | The transaction business category used in tax determination for the transaction. |
RaCustomerTrxTrxClass | The transaction class. |
RaCustomerTrxTrxClassLookupType | The transaction class of the transaction. Valid values are: Invoice, Credit Memo, Debit Memo, Chargeback. |
RaCustomerTrxTrxDate | The date when the transaction is created. |
RaCustomerTrxTrxNumber | The number that identifies the transaction with information about the goods and services sold. |
RaCustomerTrxUpgradeMethod | The method that signifies how the customer upgraded from a previous version of Oracle Applications to the current version of Oracle Applications. |
RaCustomerTrxUserDefinedFiscClass | The user-defined fiscal classification used in tax determination for the transaction. |
RaCustomerTrxWaybillNumber | The number used to identify and follow the movements of the shipment through the network. |
RaCustomerTrxWhUpdateDate | The date when the transaction was last updated. |