The CData Sync App provides a straightforward way to continuously pipeline your Oracle Financials Cloud data to any database, data lake, or data warehouse, making it easily available for Analytics, Reporting, AI, and Machine Learning.
The Oracle Financials Cloud connector can be used from the CData Sync application to pull data from Oracle Financials Cloud and move it to any of the supported destinations.
Create a connection to Oracle Financials Cloud by navigating to the Connections page in the Sync App application and selecting the corresponding icon in the Add Connections panel. If the Oracle Financials Cloud icon is not available, click the Add More icon to download and install the Oracle Financials Cloud connector from the CData site.
Required properties are listed under the Settings tab. The Advanced tab lists connection properties that are not typically required.
You must set the following to authenticate to Oracle Financials Cloud:
See Financials Data Model for the available entities in the Financials Data Model.
This section shows the available API objects and provides more information on executing SQL to Oracle Financials Cloud APIs.
Stored Procedures are function-like interfaces to Oracle Financials Cloud. They can be used to modify information in Oracle Financials Cloud.
In Oracle Financials Cloud, finders are filters used for searching collection resources. Each finder has several parameters bound to it.
To use a finder filter with a parent view, you need to provide the FinderName in the finder pseudo column and provide values for the finder parameter columns.
SELECT * FROM JournalBatches WHERE finder = 'JournalsFinder' AND JournalCategory = 'test';
To use a finder filter with a child view, you need to provide the FinderName of the parent view in the finder pseudo column and provide values for the finder parameter columns of the parent view.
SELECT * FROM InvoicesinvoiceLinesinvoiceDistributions WHERE finder = 'PrimaryKey' AND InvoiceId = 5484;
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
| Name | Description |
| AccountCombinationsLOV | AccountCombinationsLOV |
| AccountingPeriodsLOV | AccountingPeriodsLOV |
| AccountingPeriodStatusLOV | AccountingPeriodStatusLOV |
| BankAccountUserRules | BankAccountUserRules |
| BudgetaryControlBudgetTransactions | BudgetaryControlBudgetTransactions |
| BudgetaryControlResults | BudgetaryControlResults |
| BudgetaryControlResultsBudgetImpacts | BudgetaryControlResultsBudgetImpacts |
| BudgetaryControlResultsBudgetTransactions | BudgetaryControlResultsBudgetTransactions |
| CashExternalTransactions | CashExternalTransactions |
| CashExternalTransactionsattachments | CashExternalTransactionsattachments |
| CashExternalTransactionscashExternalTransactionDFF | CashExternalTransactionscashExternalTransactionDFF |
| CurrencyConversionTypesLOV | CurrencyConversionTypesLOV |
| CurrencyRates | CurrencyRates |
| CustomerAccountSitesLOV | CustomerAccountSitesLOV |
| DataAccessSetLedgersLOV | DataAccessSetLedgersLOV |
| DataAccessSetsLOV | DataAccessSetsLOV |
| DebitAuthorizations | DebitAuthorizations |
| DebitAuthorizationsdebitAuthorizationVersions | DebitAuthorizationsdebitAuthorizationVersions |
| DisbursementPaymentMethodsLOV | DisbursementPaymentMethodsLOV |
| ErpBusinessEvents | ErpBusinessEvents |
| Erpintegrations | Erpintegrations |
| ExternalBankAccounts | ExternalBankAccounts |
| ExternalBankAccountsaccountOwners | ExternalBankAccountsaccountOwners |
| FinBusinessUnitsLOV | FinBusinessUnitsLOV |
| FixedAssetBooksLOV | FixedAssetBooksLOV |
| InputTaxClassificationsLOV | InputTaxClassificationsLOV |
| InstrumentAssignments | InstrumentAssignments |
| IntercompanyOrganizationsLOV | IntercompanyOrganizationsLOV |
| IntercompanyTransactionTypesLOV | IntercompanyTransactionTypesLOV |
| InvoiceApprovalsAndNotificationsHistory | InvoiceApprovalsAndNotificationsHistory |
| InvoiceHolds | InvoiceHolds |
| InvoiceHoldsinvoiceHoldDff | InvoiceHoldsinvoiceHoldDff |
| Invoices | Invoices |
| InvoicesappliedPrepayments | InvoicesappliedPrepayments |
| Invoicesattachments | Invoicesattachments |
| InvoicesavailablePrepayments | InvoicesavailablePrepayments |
| InvoicesinvoiceDff | InvoicesinvoiceDff |
| InvoicesinvoiceGdf | InvoicesinvoiceGdf |
| InvoicesinvoiceInstallments | InvoicesinvoiceInstallments |
| InvoicesinvoiceInstallmentsinvoiceInstallmentDff | InvoicesinvoiceInstallmentsinvoiceInstallmentDff |
| InvoicesinvoiceInstallmentsinvoiceInstallmentGdf | InvoicesinvoiceInstallmentsinvoiceInstallmentGdf |
| InvoicesinvoiceLines | InvoicesinvoiceLines |
| InvoicesinvoiceLinesinvoiceDistributions | InvoicesinvoiceLinesinvoiceDistributions |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf |
| InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff | InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff |
| InvoicesinvoiceLinesinvoiceLineDff | InvoicesinvoiceLinesinvoiceLineDff |
| InvoicesinvoiceLinesinvoiceLineGdf | InvoicesinvoiceLinesinvoiceLineGdf |
| InvoicesinvoiceLinesinvoiceLineProjectDff | InvoicesinvoiceLinesinvoiceLineProjectDff |
| JournalBatches | JournalBatches |
| JournalBatchesbatchAttachment | JournalBatchesbatchAttachment |
| JournalBatchesjournalActionLogs | JournalBatchesjournalActionLogs |
| JournalBatchesjournalBatchDFF | JournalBatchesjournalBatchDFF |
| JournalBatchesjournalErrors | JournalBatchesjournalErrors |
| JournalBatchesjournalHeaders | JournalBatchesjournalHeaders |
| JournalBatchesjournalHeadersjournalAttachment | JournalBatchesjournalHeadersjournalAttachment |
| JournalBatchesjournalHeadersjournalDFF | JournalBatchesjournalHeadersjournalDFF |
| JournalBatchesjournalHeadersjournalGDF | JournalBatchesjournalHeadersjournalGDF |
| JournalBatchesjournalHeadersjournalLines | JournalBatchesjournalHeadersjournalLines |
| JournalBatchesjournalHeadersjournalLinescapturedInformationDFF | JournalBatchesjournalHeadersjournalLinescapturedInformationDFF |
| JournalBatchesjournalHeadersjournalLinesjournalLineDFF | JournalBatchesjournalHeadersjournalLinesjournalLineDFF |
| JournalBatchesjournalHeadersjournalLinesjournalLineGDF | JournalBatchesjournalHeadersjournalLinesjournalLineGDF |
| JournalCategoriesLOV | JournalCategoriesLOV |
| JournalSourcesLOV | JournalSourcesLOV |
| LedgerBalances | LedgerBalances |
| LedgersLOV | LedgersLOV |
| LegalEntitiesLOV | LegalEntitiesLOV |
| MemoLinesLOV | MemoLinesLOV |
| PartyFiscalClassifications | PartyFiscalClassifications |
| PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations | PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations |
| PartyTaxProfiles | PartyTaxProfiles |
| PayablesAndProcurementOptions | PayablesAndProcurementOptions |
| PayablesCalendarTypes | PayablesCalendarTypes |
| PayablesCalendarTypespayablesCalendarPeriods | PayablesCalendarTypespayablesCalendarPeriods |
| PayablesDistributionSets | PayablesDistributionSets |
| PayablesDistributionSetsLOV | PayablesDistributionSetsLOV |
| PayablesDistributionSetspayablesDistributionSetsLines | PayablesDistributionSetspayablesDistributionSetsLines |
| PayablesIncomeTaxRegions | PayablesIncomeTaxRegions |
| PayablesIncomeTaxTypes | PayablesIncomeTaxTypes |
| PayablesInvoiceHolds | PayablesInvoiceHolds |
| PayablesInvoiceHoldsLOV | PayablesInvoiceHoldsLOV |
| PayablesOptions | PayablesOptions |
| PayablesPayments | PayablesPayments |
| PayablesPaymentspaymentDff | PayablesPaymentspaymentDff |
| PayablesPaymentspaymentGdf | PayablesPaymentspaymentGdf |
| PayablesPaymentsrelatedInvoices | PayablesPaymentsrelatedInvoices |
| PayablesPaymentsrelatedInvoicesrelatedInvoiceGdf | PayablesPaymentsrelatedInvoicesrelatedInvoiceGdf |
| PayablesPaymentTerms | PayablesPaymentTerms |
| PayablesPaymentTermsLOV | PayablesPaymentTermsLOV |
| PayablesPaymentTermspayablesPaymentTermsLines | PayablesPaymentTermspayablesPaymentTermsLines |
| PayablesPaymentTermspayablesPaymentTermsSets | PayablesPaymentTermspayablesPaymentTermsSets |
| PayablesPaymentTermspayablesPaymentTermsTranslations | PayablesPaymentTermspayablesPaymentTermsTranslations |
| PayablesTaxReportingEntities | PayablesTaxReportingEntities |
| PayablesTaxReportingEntitiespayablesTaxReportingEntityLine | PayablesTaxReportingEntitiespayablesTaxReportingEntityLine |
| PayeeBankAccountsLOV | PayeeBankAccountsLOV |
| PaymentCodesLOV | PaymentCodesLOV |
| PaymentProcessRequests | PaymentProcessRequests |
| PaymentsExternalPayees | PaymentsExternalPayees |
| PaymentsExternalPayeesexternalPartyPaymentMethods | PaymentsExternalPayeesexternalPartyPaymentMethods |
| PaymentTermsLOV | PaymentTermsLOV |
| PreferredCurrenciesLOV | PreferredCurrenciesLOV |
| PurchaseToPayLegalEntitiesLOV | PurchaseToPayLegalEntitiesLOV |
| ReceiptMethodAssignments | ReceiptMethodAssignments |
| ReceiptMethods | ReceiptMethods |
| ReceiptMethodsreceiptMethodDFF | ReceiptMethodsreceiptMethodDFF |
| ReceivablesAdjustments | ReceivablesAdjustments |
| ReceivablesAdjustmentsreceivablesAdjustmentDFF | ReceivablesAdjustmentsreceivablesAdjustmentDFF |
| ReceivablesBusinessUnitsLOV | ReceivablesBusinessUnitsLOV |
| ReceivablesCreditMemos | ReceivablesCreditMemos |
| ReceivablesCreditMemosattachments | ReceivablesCreditMemosattachments |
| ReceivablesCreditMemosnotes | ReceivablesCreditMemosnotes |
| ReceivablesCreditMemosreceivablesCreditMemoDFF | ReceivablesCreditMemosreceivablesCreditMemoDFF |
| ReceivablesCreditMemosreceivablesCreditMemoDistributions | ReceivablesCreditMemosreceivablesCreditMemoDistributions |
| ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF | ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF |
| ReceivablesCreditMemosreceivablesCreditMemoGdf | ReceivablesCreditMemosreceivablesCreditMemoGdf |
| ReceivablesCreditMemosreceivablesCreditMemoLines | ReceivablesCreditMemosreceivablesCreditMemoLines |
| ReceivablesCreditMemosreceivablesCreditMemoLinesattachments | ReceivablesCreditMemosreceivablesCreditMemoLinesattachments |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines |
| ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF |
| ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF | ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF |
| ReceivablesCustomerAccountActivities | ReceivablesCustomerAccountActivities |
| ReceivablesCustomerAccountActivitiescreditMemoApplications | ReceivablesCustomerAccountActivitiescreditMemoApplications |
| ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF | ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF |
| ReceivablesCustomerAccountActivitiescreditMemos | ReceivablesCustomerAccountActivitiescreditMemos |
| ReceivablesCustomerAccountActivitiesstandardReceiptApplications | ReceivablesCustomerAccountActivitiesstandardReceiptApplications |
| ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF | ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF |
| ReceivablesCustomerAccountActivitiesstandardReceipts | ReceivablesCustomerAccountActivitiesstandardReceipts |
| ReceivablesCustomerAccountActivitiestransactionAdjustments | ReceivablesCustomerAccountActivitiestransactionAdjustments |
| ReceivablesCustomerAccountActivitiestransactionPaymentSchedules | ReceivablesCustomerAccountActivitiestransactionPaymentSchedules |
| ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers | ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers |
| ReceivablesCustomerAccountSiteActivities | ReceivablesCustomerAccountSiteActivities |
| ReceivablesCustomerAccountSiteActivitiescreditMemoApplications | ReceivablesCustomerAccountSiteActivitiescreditMemoApplications |
| ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF | ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF |
| ReceivablesCustomerAccountSiteActivitiescreditMemos | ReceivablesCustomerAccountSiteActivitiescreditMemos |
| ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications | ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications |
| ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF | ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF |
| ReceivablesCustomerAccountSiteActivitiesstandardReceipts | ReceivablesCustomerAccountSiteActivitiesstandardReceipts |
| ReceivablesCustomerAccountSiteActivitiestransactionAdjustments | ReceivablesCustomerAccountSiteActivitiestransactionAdjustments |
| ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules | ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules |
| ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers | ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers |
| ReceivablesInvoices | ReceivablesInvoices |
| ReceivablesInvoicesattachments | ReceivablesInvoicesattachments |
| ReceivablesInvoicesnotes | ReceivablesInvoicesnotes |
| ReceivablesInvoicesreceivablesInvoiceDFF | ReceivablesInvoicesreceivablesInvoiceDFF |
| ReceivablesInvoicesreceivablesInvoiceDistributions | ReceivablesInvoicesreceivablesInvoiceDistributions |
| ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF | ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF |
| ReceivablesInvoicesreceivablesInvoiceGdf | ReceivablesInvoicesreceivablesInvoiceGdf |
| ReceivablesInvoicesreceivablesInvoiceInstallments | ReceivablesInvoicesreceivablesInvoiceInstallments |
| ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF |
| ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes | ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes |
| ReceivablesInvoicesreceivablesInvoiceLines | ReceivablesInvoicesreceivablesInvoiceLines |
| ReceivablesInvoicesreceivablesInvoiceLinesattachments | ReceivablesInvoicesreceivablesInvoiceLinesattachments |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines |
| ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF | ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF |
| ReceivablesInvoicesreceivablesInvoiceTransactionDFF | ReceivablesInvoicesreceivablesInvoiceTransactionDFF |
| SalespersonReferenceAccounts | SalespersonReferenceAccounts |
| StandardReceipts | StandardReceipts |
| StandardReceiptsattachments | StandardReceiptsattachments |
| StandardReceiptsremittanceReferences | StandardReceiptsremittanceReferences |
| StandardReceiptsstandardReceiptDFF | StandardReceiptsstandardReceiptDFF |
| StandardReceiptsstandardReceiptGdf | StandardReceiptsstandardReceiptGdf |
| TaxAuthorityProfiles | TaxAuthorityProfiles |
| TaxClassifications | TaxClassifications |
| TaxExemptions | TaxExemptions |
| TaxIntendedUsesLOV | TaxIntendedUsesLOV |
| TaxPayerIdentifiers | TaxPayerIdentifiers |
| TaxRegistrations | TaxRegistrations |
| ThirdPartyFiscalClassifications | ThirdPartyFiscalClassifications |
| ThirdPartySiteFiscalClassifications | ThirdPartySiteFiscalClassifications |
| ThirdPartySiteTaxReportingCodeAssociations | ThirdPartySiteTaxReportingCodeAssociations |
| ThirdPartyTaxReportingCodeAssociations | ThirdPartyTaxReportingCodeAssociations |
| TransactionSourcesLOV | TransactionSourcesLOV |
| TransactionTaxLines | TransactionTaxLines |
| TransactionTypesLOV | TransactionTypesLOV |
| WithholdingTaxGroupsLOV | WithholdingTaxGroupsLOV |
| WithholdingTaxLines | WithholdingTaxLines |
| WorkflowUsers | WorkflowUsers |
AccountCombinationsLOV
| Name | Type | Description |
| JgzzReconFlag | String | JgzzReconFlag |
| Reference3 | String | Reference3 |
| FinancialCategory | String | FinancialCategory |
| SummaryFlag | String | SummaryFlag |
| DetailPostingAllowedFlag | String | DetailPostingAllowedFlag |
| AccountType | String | AccountType |
| DetailBudgetingAllowedFlag | String | DetailBudgetingAllowedFlag |
| StartDateActive | Date | StartDateActive |
| EndDateActive | Date | EndDateActive |
| EnabledFlag | String | EnabledFlag |
| _CODE_COMBINATION_ID [KEY] | String | _CODE_COMBINATION_ID |
| _CHART_OF_ACCOUNTS_ID | String | _CHART_OF_ACCOUNTS_ID |
AccountingPeriodsLOV
| Name | Type | Description |
| PeriodNameId | String | PeriodNameId |
| PeriodSetNameId | String | PeriodSetNameId |
| PeriodType | String | PeriodType |
| AdjustmentPeriodFlag | Bool | AdjustmentPeriodFlag |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
| EnteredPeriodName | String | EnteredPeriodName |
| PeriodYear | String | PeriodYear |
| PeriodNumber | String | PeriodNumber |
AccountingPeriodStatusLOV
| Name | Type | Description |
| PeriodNameId | String | PeriodNameId |
| ApplicationId | String | ApplicationId |
| LedgerId | String | LedgerId |
| ClosingStatus | String | ClosingStatus |
| EndDate | Date | EndDate |
| StartDate | Date | StartDate |
| EffectivePeriodNumber | String | EffectivePeriodNumber |
| PeriodYear | String | PeriodYear |
| PeriodNumber | String | PeriodNumber |
| AdjustmentPeriodFlag | Bool | AdjustmentPeriodFlag |
BankAccountUserRules
| Name | Type | Description |
| CountrySpecificUIRuleId [KEY] | String | CountrySpecificUIRuleId |
| CountryCode | String | CountryCode |
| BankAccountFieldName | String | BankAccountFieldName |
| DisplayFlag | Bool | DisplayFlag |
| LabelCode | String | LabelCode |
| BankAccountFieldLabel | String | BankAccountFieldLabel |
| RequiredFlag | Bool | RequiredFlag |
| ObjectVersionNumber | Int | ObjectVersionNumber |
| CreationDate | Datetime | CreationDate |
| CreatedBy | String | CreatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateLogin | String | LastUpdateLogin |
| PageName | String | PageName |
| SeededFlag | Bool | SeededFlag |
| SeedDataSource | String | SeedDataSource |
BudgetaryControlBudgetTransactions
| Name | Type | Description |
| SourceBudget | String | Source control budget name of the budget entry transaction line. |
| TransactionNumber | String | Budget entry transaction number from Enterprise Performance Management. |
| BudgetTransactionPayload | String | Main content of a budget entry transaction line, such as its budget account, budget period, and budget amount, encoded in JSON format. |
| BudgetTransactionType | String | Indicates whether the budget entry transaction is an initial budget or a budget adjustment. |
| BudgetAmountsMode | String | Indicates whether the amounts from the budget entry transactions should overwrite or be added to the existing budget balances. |
| BatchFundsAction | String | Indicates whether funds check or funds reservation is performed for the budget entry transaction. Funds check doesn't update budget balances. Funds reservation updates budget balances when budgetary control validation doesn't fail. |
| AttributeCategory | String | Descriptive flexfield context name for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar1 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar2 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar3 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar4 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar5 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar6 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar7 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar8 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar9 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| AttributeChar10 | String | Segment for the Budget Line Descriptions descriptive flexfield. |
| ApprovalComments | String | Approval comments from the approver for the budget entry transaction. |
| ApprovedDate | Datetime | Date and time when the budget entry transaction was approved. |
| ApprovedBy | String | Person who approved the budget entry transaction. |
| RevisionDescription | String | Description for the budget entry transaction. |
| AttachmentURL | String | Supporting document attached at the budget entry transaction header level. |
| JustificationText | String | Justification provided at the budget entry transaction header level by the budget preparer for the budget approver. |
| BatchFatalErrorMessage | String | The message of an unexpected error. |
| ProcessId | String | The budgetary control process identifier. |
| BatchResultCode | String | The budgetary control status code for the batch, such as success or failed. |
BudgetaryControlResults
| Name | Type | Description |
| TransactionNumber | String | The transaction number. |
| EnteredAmount | String | The entered transaction amount in the transaction currency. |
| EnteredCurrency | String | The transaction currency. |
| Amount | String | The transaction amount in the budget currency. |
| CurrencyCode | String | The currency of the control budget. |
| ControlBudgetId | String | The control budget identifier. |
| Name | String | The control budget name. |
| PeriodName | String | The name of the budget period. |
| BudgetCcid | String | The budget account identifier for the transaction. |
| ConversionDate | Date | The date on which a conversion rate is used to convert the transaction entered amount into the budget currency. |
| ConversionRate | String | The currency conversion rate used to convert the entered transaction amount to the budget currency amount. |
| UserConversionType | String | The source of a currency conversion rate, such as, user defined or corporate, that is used to convert the transactions. |
| SourceHeaderId1 | String | The source transaction identifier 1. |
| SourceHeaderId2 | String | The source transaction identifier 2. |
| SourceLineId1 | String | The source transaction line identifier 1. |
| SourceLineId2 | String | The source transaction line identifier 2. |
| SourceLineId3 | String | The source transaction line identifier 3. |
| SourceLineId4 | String | The source transaction line identifier 4. |
| SourceLineId5 | String | The source transaction line identifier 5. |
| DataSetId | String | The budgetary control validation processing data set identifier. |
| TransactionTypeCode | String | The source transaction type code. |
| DraftFlag | Bool | The funds check versus funds reservation indicator. |
| ResultCode | String | The budgetary control validation status code for the transactions. |
| BudgetAccount | String | The budget account for the transaction. |
| FundsConsumed | String | The amount consumed from the control budget. |
| Status | String | The budgetary control validation status for the transactions. |
| BalanceType | String | The balance type of various amounts, such as obligation, commitment, other, and actual amounts. |
| ProjectBurden | String | Indicates whether a line item listed in the budgetary control results represents a project overhead cost, such as fringe, overhead, and materials handling. |
| BudgetManager | String | The budget manager who manages the control budget. |
BudgetaryControlResultsBudgetImpacts
| Name | Type | Description |
| BudgetCcid | String | The budget account identifier for the transaction. |
| ControlBudgetId | String | The control budget identifier. |
| PeriodName | String | The name of the budget period. |
| TransactionNumber | String | The transaction number. |
| Amount | String | The transaction amount in the budget currency. |
| EnteredAmount | String | The entered transaction amount in the transaction currency. |
| ResultCode | String | The budgetary control validation status code for the transactions. |
| CurrencyCode | String | The currency of the control budget. |
| Name | String | The control budget name. |
| AccountedProjectAmount | String | Reserved project expenditure amount. |
| AccountedPayablesAmount | String | Reserved payables expenditure amount. |
| AccountedReceiptsAmount | String | Reserved receipt expenditure amount. |
| ActualAmount | String | Consumption amount spent and classified as an expenditure. |
| ApprovedAuthorizationAmount | String | Reserved spend authorization amount. |
| ApprovedCommitmentAmount | String | Reserved requisition amount. |
| ApprovedObligationAmount | String | Reserved purchase order amount. |
| BudgetAdjustmentAmount | String | Changes made to the initial budget amount. |
| BudgetAmount | String | The total budget balance amount. |
| CommitmentAmount | String | Consumption amount expected to be spent without a legal obligation. |
| DetailOtherAmount | String | Reserved encumbrance amount excluding commitments or obligations. |
| FundsAvailableAmount | String | Funds available amount for consumption. |
| MiscExpendituresAmount | String | Reserved expenditure amount excluding payables, receipts and projects. |
| ObligationAmount | String | Consumption amount with a legal obligation to pay in the future. |
| OtherAmount | String | Consumption amount for encumbrances excluding commitments or obligations. |
| UnreleasedBudgetAmount | String | Budget amount that is not released for consumption. |
| TotalConsumption | String | Total budget consumption amount consisting of expenditure amounts incurred and amounts at different degrees of committed stages. |
| BudgetAccount | String | The budget account for the transaction. |
| FundsConsumed | String | The amount consumed from the control budget. |
| Status | String | The budgetary control validation status for the transactions. |
| BudgetManager | String | The budget manager who manages the control budget. |
| AdditionalRequired | String | Amount needed beyond the remaining budget funds available to cover the cost of a specific transaction. |
BudgetaryControlResultsBudgetTransactions
| Name | Type | Description |
| TransactionNumber [KEY] | String | The transaction number. |
| LineNumber | String | The budget entry line number. |
| ControlBudget | String | The control budget name. |
| ControlBudgetPeriod | String | The name of the budget period of the control budget. |
| BudgetAccount | String | The combination of budget segment values. |
| TransactionAmount | String | The transaction amount in the budget currency. |
| ControlBudgetAmount | String | The budget entry transaction amount in the control budget currency. |
| ReservedBudgetAmount | String | The amount that was updated to the budget balance of the control budget. |
| BudgetTransactionType | String | Indicates whether the budget entry transaction is an initial budget or a budget adjustment. |
| FundsAction | String | Indicates whether funds check or funds reservation is performed for the budget entry transaction. Funds check doesn't update budget balances. Funds reservation updates budget balances when budgetary control validation doesn't fail. |
| BatchResult | String | The budgetary control status code for the batch, such as success or failed. |
| BatchFatalErrorMessage | String | The message of an unexpected error. |
| HeaderStatus | String | The budgetary control status for a budget entry transaction, such as passed, warning, or failed. |
| HeaderResult | String | The budgetary control result for the budget entry transaction. |
| LineStatus | String | The budgetary control status for a budget entry transaction line, such as passed, warning, or failed. |
| LineResult | String | The budgetary control result for a budget entry transaction line. |
| ActivityStatus | String | The budgetary control status for the control budget activity of the budget entry transaction line such as passed, warning, or failed. |
| ActivityResult | String | The budgetary control result for the control budget activity of the budget entry transaction line. |
| InitialBudgetBalance | String | Initial budget balance of the control budget. |
| BudgetAdjustmentBalance | String | All changes made to the initial budget balance of the control budget. |
| TotalBudgetBalance | String | Total budget balance of the control budget. |
| TotalConsumptionBalance | String | Total budget consumption amount consisting of expenditure amounts incurred and amounts at different degrees of committed stages. |
| FundsAvailableBalance | String | Funds available amount for consumption. |
| BudgetManager | String | The budget manager who manages the control budget. |
| ControlBudgetCurrency | String | The currency of the control budget. |
| TransactionCurrency | String | The transaction currency. |
| ConversionDate | Date | The date when a conversion rate is used to convert the entered budget amount into the control budget currency. |
| ConversionRate | String | The currency conversion rate used to convert the entered transaction amount to the control budget currency amount. |
| UserConversionType | String | The source of a currency conversion rate, such as, user defined or corporate, that is used to convert the transactions. |
CashExternalTransactions
| Name | Type | Description |
| AccountingFlag | Bool | The option that indicates whether the accounting event is raised when the external transaction is reconciled. |
| Amount | String | The transaction amount of the external transaction. |
| ClearedDate | Date | The date when the external transaction is cleared. |
| CreatedBy | String | The user who created the external transaction. |
| CreationDate | Datetime | The date and time when the external transaction was created. |
| CurrencyCode | String | The currency code of the external transaction. |
| Description | String | The description of the external transaction. |
| ExternalTransactionId [KEY] | String | The unique identifier of the external transaction. |
| LastUpdateDate | Datetime | The date and time when the external transaction was last updated. |
| LastUpdateLogin | String | The session login associated with the user who last updated the external transaction. |
| LastUpdatedBy | String | The user who last updated the external transaction. |
| ReferenceText | String | The reconciliation reference of the external transaction. |
| Source | String | The source of the external transaction. The default value is Imported. |
| Status | String | The status of the external transaction. The default value is UNR for Unreconciled. Unreconciled external transactions can be rendered as void by updating this attribute to VOID. |
| TransactionDate | Date | The date when the external transaction is created. |
| TransactionId | String | The sequence number transaction identifier of the external transaction. |
| TransactionType | String | The transaction type of the external transaction. Examples include Bank adjustment, Fee, Check, Electronic funds transfer, Interest, Zero balancing, Lockbox, Miscellaneous, and Automated clearing house. A list of accepted values is defined in the lookup type CE_TRX_TYPE. |
| ValueDate | Date | The actual value date of the external transaction. |
| AssetAccountCombination | String | The cash general ledger account code combination of the external transaction. |
| OffsetAccountCombination | String | The offset general ledger account code combination of the external transaction. |
| BusinessUnitName | String | The name of the business unit associated to the external transaction. |
| LegalEntityName | String | The name of the legal entity associated to the external transaction. |
| BankAccountName | String | The name of the bank account associated to the external transaction. |
| BankConversionRate | String | The accounting conversion rate used to convert the external transaction amount from the bank account currency to the ledger currency. |
| BankConversionRateType | String | The accounting conversion rate type used to convert the external transaction amount from the bank account currency to the ledger currency. |
| TransferId | String | The unique identifier of the bank account transfer or the ad hoc payment that created the external transaction. |
| AccntServicerReference | String | The reference number assigned by the account servicing institution for the underlying payment, receipt, external transaction, or payroll payment. |
| AddendaTxt | String | Additional information about the entry details. |
| CheckNumber | String | The check number of the underlying transaction. |
| ClearingSystemReference | String | The unique identifier assigned by the clearing system to a payment instruction. |
| CustomerReference | String | The customer reference used by BAI format. |
| EndToEndId | String | The unique identification assigned by the initiating party to the transaction. It is passed on unchanged throughout the entire end to end chain. |
| InstructionIdentification | String | The unique identification which is a point to point reference used between the instructing party and the instructed party to refer to an individual instruction. It is assigned by the instructing party to the instructed party and can be included in several messages related to the instruction. |
| ReconReference | String | The reference to the underlying transaction information. |
| StructuredPaymentReference | String | The structured payment reference or receipt reference on the bank statement line. |
| BankTransactionId | String | Unique identifier of the bank transaction on the statement line. |
CashExternalTransactionsattachments
| Name | Type | Description |
| CashExternalTransactionsExternalTransactionId | String | The unique identifier of the external transaction. |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
CashExternalTransactionscashExternalTransactionDFF
| Name | Type | Description |
| CashExternalTransactionsExternalTransactionId | String | The unique identifier of the external transaction. |
| ExternalTransactionId | String | ExternalTransactionId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
CurrencyConversionTypesLOV
| Name | Type | Description |
| ConversionTypeId [KEY] | String | ConversionTypeId |
| UserConversionType | String | UserConversionType |
| Description | String | Description |
CurrencyRates
| Name | Type | Description |
| FromCurrency | String | FromCurrency |
| ToCurrency | String | ToCurrency |
| UserConversionType | String | UserConversionType |
| ConversionDate | Date | ConversionDate |
| ConversionRate | String | ConversionRate |
| ConversionType | String | ConversionType |
CustomerAccountSitesLOV
| Name | Type | Description |
| CustomerName | String | Customer Name |
| AccountNumber | String | Account Number |
| AccountDescription | String | Account Description |
| TaxpayerIdentificationNumber | String | Taxpayer Identification Number |
| TaxRegistrationNumber | String | A unique sequence of letters or numbers assigned to a party or party site by a tax authority when the party or party site is registered and by which the party or party site registration will be identified. |
| CustomerAccountId | String | Customer Account ID |
| PartyNumber | String | Party Number |
| SiteName | String | Site Name |
| PrimarySite | String | Primary Site |
| SiteUseId [KEY] | String | Site Use ID |
| SetName | String | Set Name |
DataAccessSetLedgersLOV
| Name | Type | Description |
| AccessSetId [KEY] | String | AccessSetId |
| LedgerId | String | LedgerId |
| AccountedPeriodType | String | AccountedPeriodType |
| ChartOfAccountsId | String | ChartOfAccountsId |
| EnableBudgetaryControlFlag | Bool | EnableBudgetaryControlFlag |
| ObjectTypeCode | String | ObjectTypeCode |
| PeriodSetName | String | PeriodSetName |
| Name | String | Name |
| Description | String | Description |
| LedgerCategoryCode | String | LedgerCategoryCode |
| BalSegColumnName | String | BalSegColumnName |
| ShortName | String | ShortName |
| LookupCode | String | LookupCode |
| LookupType | String | LookupType |
| Meaning | String | Meaning |
| LedgerSetIds | String | LedgerSetIds |
DataAccessSetsLOV
| Name | Type | Description |
| AccessSetId [KEY] | String | AccessSetId |
| AccountedPeriodType | String | AccountedPeriodType |
| ChartOfAccountsId | String | ChartOfAccountsId |
| Description | String | Description |
| Name | String | Name |
| PeriodSetName | String | PeriodSetName |
| SecuritySegmentCode | String | SecuritySegmentCode |
DebitAuthorizations
| Name | Type | Description |
| DebitAuthorizationReferenceNumber | String | DebitAuthorizationReferenceNumber |
| CustomerBankAccountNumber | String | CustomerBankAccountNumber |
| BankName | String | BankName |
| BankBranchName | String | BankBranchName |
| BankAccountCountry | String | BankAccountCountry |
| BankAccountCurrency | String | BankAccountCurrency |
| IBAN | String | IBAN |
| BIC | String | BIC |
| LegalEntityName | String | LegalEntityName |
| CreditorIdentificationNumber | String | CreditorIdentificationNumber |
| SigningDate | Date | SigningDate |
| CancellationDate | Date | CancellationDate |
| TransactionType | String | TransactionType |
| Frequency | String | Frequency |
| FinalCollectionDate | Date | FinalCollectionDate |
| AuthorizationMethod | String | AuthorizationMethod |
| VersionNumber | Int | VersionNumber |
| ReasonForAmendment | String | ReasonForAmendment |
| EffectiveStartDate | Date | EffectiveStartDate |
| EffectiveEndDate | Date | EffectiveEndDate |
| DirectDebitCount | String | DirectDebitCount |
| PrimaryIndicator | String | PrimaryIndicator |
| Status | String | Status |
| DebitAuthorizationId | String | DebitAuthorizationId |
| CustomerPartyIdentifier | String | CustomerPartyIdentifier |
| CustomerPartyNumber | String | CustomerPartyNumber |
| CustomerPartyName | String | CustomerPartyName |
| CustomerBankAccountIdentifier | String | CustomerBankAccountIdentifier |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
DebitAuthorizationsdebitAuthorizationVersions
| Name | Type | Description |
| DebitAuthorizationsDebitAuthorizationId | String | DebitAuthorizationsDebitAuthorizationId |
| DebitAuthorizationsEffectiveEndDate | Date | DebitAuthorizationsEffectiveEndDate |
| DebitAuthorizationsEffectiveStartDate | Date | DebitAuthorizationsEffectiveStartDate |
| DebitAuthorizationId | String | DebitAuthorizationId |
| EffectiveStartDate | Date | EffectiveStartDate |
| EffectiveEndDate | Date | EffectiveEndDate |
| DebitAuthorizationReferenceNumber | String | DebitAuthorizationReferenceNumber |
| VersionNumber | Int | VersionNumber |
| CreditorIdentificationNumber | String | CreditorIdentificationNumber |
| LegalEntityName | String | LegalEntityName |
| CustomerBankAccountNumber | String | CustomerBankAccountNumber |
| IBAN | String | IBAN |
| CutomerBankAccountIdentifier | String | CutomerBankAccountIdentifier |
| ReasonForAmendment | String | ReasonForAmendment |
| DirectDebitCount | String | DirectDebitCount |
DisbursementPaymentMethodsLOV
| Name | Type | Description |
| PaymentMethodCode [KEY] | String | PaymentMethodCode |
| PaymentMethodName | String | PaymentMethodName |
| PaymentMethodDescription | String | PaymentMethodDescription |
| BillsPayablePaymentMethodIndicator | String | BillsPayablePaymentMethodIndicator |
| MaturityDateOverride | String | MaturityDateOverride |
| ApplicationId | String | ApplicationId |
| AutoPayeeAssignIndicator | String | AutoPayeeAssignIndicator |
ErpBusinessEvents
| Name | Type | Description |
| BusinessEventCode | String | BusinessEventCode |
| BusinessEventIdentifier | String | BusinessEventIdentifier |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| EnabledFlag | Bool | EnabledFlag |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| ErpBusinessEventId [KEY] | String | ErpBusinessEventId |
Erpintegrations
| Name | Type | Description |
| OperationName [KEY] | String | OperationName |
| DocumentId | String | DocumentId |
| DocumentContent | String | DocumentContent |
| FileName | String | FileName |
| ContentType | String | ContentType |
| FileType | String | FileType |
| DocumentAccount | String | DocumentAccount |
| Comments | String | Comments |
| ProcessName | String | ProcessName |
| LoadRequestId | String | LoadRequestId |
| JobPackageName | String | JobPackageName |
| JobDefName | String | JobDefName |
| ReqstId | String | ReqstId |
| RequestStatus | String | RequestStatus |
| JobName | String | JobName |
| ParameterList | String | ParameterList |
| NotificationCode | String | NotificationCode |
| CallbackURL | String | CallbackURL |
| JobOptions | String | JobOptions |
| StatusCode | String | StatusCode |
| ESSParameters | String | ESSParameters |
ExternalBankAccounts
| Name | Type | Description |
| BankAccountNumber | String | BankAccountNumber |
| CountryCode | String | CountryCode |
| BankBranchIdentifier | String | BankBranchIdentifier |
| BankIdentifier | String | BankIdentifier |
| BankAccountId [KEY] | String | BankAccountId |
| CurrencyCode | String | CurrencyCode |
| IBAN | String | IBAN |
| CheckDigits | String | CheckDigits |
| AccountType | String | AccountType |
| AccountSuffix | String | AccountSuffix |
| AgencyLocationCode | String | AgencyLocationCode |
| AllowInternationalPaymentIndicator | String | AllowInternationalPaymentIndicator |
| SecondaryAccountReference | String | SecondaryAccountReference |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
| BankAccountName | String | BankAccountName |
| AlternateAccountName | String | AlternateAccountName |
| BankBranchPartyIndicator | String | BankBranchPartyIndicator |
| BankName | String | BankName |
| BankNumber | String | BankNumber |
| BankBranchName | String | BankBranchName |
| BankBranchNumber | String | BankBranchNumber |
| BIC | String | BIC |
| VendorId | String | VendorId |
| PersonId | String | PersonId |
| Intent | String | Intent |
| PartyId | String | PartyId |
ExternalBankAccountsaccountOwners
| Name | Type | Description |
| ExternalBankAccountsBankAccountId | String | ExternalBankAccountsBankAccountId |
| AccountOwnerPartyIdentifier | String | AccountOwnerPartyIdentifier |
| AccountOwnerPartyNumber | String | AccountOwnerPartyNumber |
| AccountOwnerPartyName | String | AccountOwnerPartyName |
| PrimaryOwnerIndicator | String | PrimaryOwnerIndicator |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
| AccountOwnerId | String | AccountOwnerId |
| Intent | String | Intent |
| PersonId | String | PersonId |
FinBusinessUnitsLOV
| Name | Type | Description |
| BusinessUnitId [KEY] | String | BusinessUnitId |
| BusinessUnitName | String | BusinessUnitName |
| ActiveFlag | Bool | ActiveFlag |
| PrimaryLedgerId | String | PrimaryLedgerId |
| LocationId | String | LocationId |
| ManagerId | String | ManagerId |
| LegalEntityId | String | LegalEntityId |
| ProfitCenterFlag | Bool | ProfitCenterFlag |
FixedAssetBooksLOV
| Name | Type | Description |
| BookTypeCode [KEY] | String | BookTypeCode |
| BookClass | String | BookClass |
| DeprnCalendar | String | DeprnCalendar |
| GlPostingAllowedFlag | Bool | GlPostingAllowedFlag |
| Name | String | Name |
| CurrencyCode | String | CurrencyCode |
| AllowPhysicalInventoryFlag | Bool | AllowPhysicalInventoryFlag |
| DateIneffective | Date | DateIneffective |
InputTaxClassificationsLOV
| Name | Type | Description |
| Description | String | Description |
| EnabledFlag | Bool | EnabledFlag |
| EndDateActive | Date | EndDateActive |
| LookupCode | String | LookupCode |
| LookupType | String | LookupType |
| Meaning | String | Meaning |
| SetId | String | SetId |
| StartDateActive | Date | StartDateActive |
InstrumentAssignments
| Name | Type | Description |
| PaymentInstrumentAssignmentId [KEY] | String | PaymentInstrumentAssignmentId |
| PaymentPartyId | String | PaymentPartyId |
| PaymentInstrumentId | String | PaymentInstrumentId |
| PaymentFlow | String | PaymentFlow |
| PaymentInstrumentType | String | PaymentInstrumentType |
| PrimaryIndicator | String | PrimaryIndicator |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
| MaskedBankAccountNumber | String | MaskedBankAccountNumber |
| MaskedCreditCardNumber | String | MaskedCreditCardNumber |
| VendorId | String | VendorId |
| PersonId | String | PersonId |
| Intent | String | Intent |
IntercompanyOrganizationsLOV
| Name | Type | Description |
| IntercoOrgId [KEY] | String | IntercoOrgId |
| IntercoOrgName | String | IntercoOrgName |
| EnabledFlag | Bool | EnabledFlag |
| Name | String | Name |
IntercompanyTransactionTypesLOV
| Name | Type | Description |
| TrxTypeId [KEY] | String | TrxTypeId |
| TrxTypeName | String | TrxTypeName |
| EnabledFlag | Bool | EnabledFlag |
InvoiceApprovalsAndNotificationsHistory
| Name | Type | Description |
| ApprovalHistoryId [KEY] | String | The unique identifier for every record created under approval or holds resolution cycle. |
| InvoiceId | String | The unique invoice identifier that is generated while creating an invoice. |
| Action | String | Indicates the action for every record created under the approval or holds resolution cycle such as Initiated, Assigned To, and Approved. |
| Approver | String | The user name of approver for the given invoice. |
| ReviewedAmount | String | The invoice amount at time of approver's response. |
| InvoiceCurrency | String | The currency code used on the invoice. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateLogin | String | The session login associated to the user who last updated the record. |
| LineNumber | String | The unique number for the invoice line. |
| HoldId | String | The unique identifier of an invoice hold. |
| HoldReason | String | The reason the hold was placed on the invoice. |
| WorkflowType | String | Indicates the workflow type such as Invoice approval and Holds resolution. |
| ApprovalRequestId | String | The unique identifier for the approval request. |
InvoiceHolds
| Name | Type | Description |
| HoldId [KEY] | String | HoldId |
| InvoiceNumber | String | InvoiceNumber |
| BusinessUnit | String | BusinessUnit |
| Supplier | String | Supplier |
| LineHeld | String | LineHeld |
| HoldDate | Datetime | HoldDate |
| HoldDetails | String | HoldDetails |
| HoldReason | String | HoldReason |
| ReleaseReason | String | ReleaseReason |
| WorkflowStatus | String | WorkflowStatus |
| ReleaseName | String | ReleaseName |
| HoldName | String | HoldName |
| ReleaseDate | Datetime | ReleaseDate |
| HeldBy | String | HeldBy |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateLogin | String | LastUpdateLogin |
| PurchaseOrderNumber | String | PurchaseOrderNumber |
| PurchaseOrderLineNumber | String | PurchaseOrderLineNumber |
| PurchaseOrderScheduleLineNumber | String | PurchaseOrderScheduleLineNumber |
| ReceiptNumber | String | ReceiptNumber |
| ReceiptLineNumber | String | ReceiptLineNumber |
| ConsumptionAdviceNumber | String | ConsumptionAdviceNumber |
| ConsumptionAdviceLineNumber | String | ConsumptionAdviceLineNumber |
InvoiceHoldsinvoiceHoldDff
| Name | Type | Description |
| InvoiceHoldsHoldId | String | InvoiceHoldsHoldId |
| HoldId | String | HoldId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
Invoices
| Name | Type | Description |
| InvoiceId [KEY] | String | InvoiceId |
| InvoiceNumber | String | InvoiceNumber |
| InvoiceCurrency | String | InvoiceCurrency |
| PaymentCurrency | String | PaymentCurrency |
| InvoiceAmount | String | InvoiceAmount |
| InvoiceDate | Date | InvoiceDate |
| BusinessUnit | String | BusinessUnit |
| Supplier | String | Supplier |
| SupplierNumber | String | SupplierNumber |
| ProcurementBU | String | ProcurementBU |
| SupplierSite | String | SupplierSite |
| RequesterId | String | RequesterId |
| Requester | String | Requester |
| InvoiceGroup | String | InvoiceGroup |
| ConversionRateType | String | ConversionRateType |
| ConversionDate | Date | ConversionDate |
| ConversionRate | String | ConversionRate |
| AccountingDate | Date | AccountingDate |
| Description | String | Description |
| DeliveryChannelCode | String | DeliveryChannelCode |
| DeliveryChannel | String | DeliveryChannel |
| PayAloneFlag | Bool | PayAloneFlag |
| InvoiceSourceCode | String | InvoiceSourceCode |
| InvoiceSource | String | InvoiceSource |
| InvoiceType | String | InvoiceType |
| PayGroup | String | PayGroup |
| InvoiceReceivedDate | Date | InvoiceReceivedDate |
| PaymentReasonCode | String | PaymentReasonCode |
| PaymentReason | String | PaymentReason |
| PaymentReasonComments | String | PaymentReasonComments |
| RemittanceMessageOne | String | RemittanceMessageOne |
| RemittanceMessageTwo | String | RemittanceMessageTwo |
| RemittanceMessageThree | String | RemittanceMessageThree |
| PaymentTerms | String | PaymentTerms |
| TermsDate | Date | TermsDate |
| GoodsReceivedDate | Date | GoodsReceivedDate |
| PaymentMethodCode | String | PaymentMethodCode |
| PaymentMethod | String | PaymentMethod |
| SupplierTaxRegistrationNumber | String | SupplierTaxRegistrationNumber |
| FirstPartyTaxRegistrationId | String | FirstPartyTaxRegistrationId |
| FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber |
| LegalEntity | String | LegalEntity |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
| LiabilityDistribution | String | LiabilityDistribution |
| DocumentCategory | String | DocumentCategory |
| DocumentSequence | String | DocumentSequence |
| VoucherNumber | String | VoucherNumber |
| ValidationStatus | String | ValidationStatus |
| ApprovalStatus | String | ApprovalStatus |
| PaidStatus | String | PaidStatus |
| AccountingStatus | String | AccountingStatus |
| ApplyAfterDate | Date | ApplyAfterDate |
| CanceledFlag | Bool | CanceledFlag |
| AmountPaid | String | AmountPaid |
| BaseAmount | String | BaseAmount |
| PurchaseOrderNumber | String | PurchaseOrderNumber |
| Party | String | Party |
| PartySite | String | PartySite |
| ControlAmount | String | ControlAmount |
| DocumentFiscalClassificationCodePath | String | DocumentFiscalClassificationCodePath |
| TaxationCountry | String | TaxationCountry |
| RoutingAttribute1 | String | RoutingAttribute1 |
| RoutingAttribute2 | String | RoutingAttribute2 |
| RoutingAttribute3 | String | RoutingAttribute3 |
| RoutingAttribute4 | String | RoutingAttribute4 |
| RoutingAttribute5 | String | RoutingAttribute5 |
| AccountCodingStatus | String | AccountCodingStatus |
| BudgetDate | Date | BudgetDate |
| FundsStatus | String | FundsStatus |
| CanceledDate | Date | CanceledDate |
| CanceledBy | String | CanceledBy |
| UniqueRemittanceIdentifier | String | UniqueRemittanceIdentifier |
| UniqueRemittanceIdentifierCheckDigit | String | UniqueRemittanceIdentifierCheckDigit |
| CreationDate | Datetime | CreationDate |
| CreatedBy | String | CreatedBy |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| BankAccount | String | BankAccount |
| SupplierIBAN | String | SupplierIBAN |
| ExternalBankAccountId | String | ExternalBankAccountId |
| BankChargeBearer | String | BankChargeBearer |
| SettlementPriority | String | SettlementPriority |
| ReferenceKeyOne | String | ReferenceKeyOne |
| ReferenceKeyTwo | String | ReferenceKeyTwo |
| ReferenceKeyThree | String | ReferenceKeyThree |
| ReferenceKeyFour | String | ReferenceKeyFour |
| ReferenceKeyFive | String | ReferenceKeyFive |
| ProductTable | String | ProductTable |
| ImageDocumentNumber | String | ImageDocumentNumber |
InvoicesappliedPrepayments
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceNumber | String | InvoiceNumber |
| LineNumber | Long | LineNumber |
| Description | String | Description |
| SupplierSite | String | SupplierSite |
| PurchaseOrder | String | PurchaseOrder |
| Currency | String | Currency |
| AppliedAmount | String | AppliedAmount |
| IncludedTax | String | IncludedTax |
| IncludedonInvoiceFlag | Bool | IncludedonInvoiceFlag |
| ApplicationAccountingDate | Date | ApplicationAccountingDate |
Invoicesattachments
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| AttachedDocumentId | String | AttachedDocumentId |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| FileName | String | FileName |
| DmFolderPath | String | DmFolderPath |
| DmDocumentId | String | DmDocumentId |
| DmVersionNumber | String | DmVersionNumber |
| Url | String | Url |
| Uri | String | Uri |
| FileUrl | String | FileUrl |
| UploadedText | String | UploadedText |
| UploadedFileContentType | String | UploadedFileContentType |
| UploadedFileLength | String | UploadedFileLength |
| UploadedFileName | String | UploadedFileName |
| ContentRepositoryFileShared | Bool | ContentRepositoryFileShared |
| Title | String | Title |
| Description | String | Description |
| ErrorStatusCode | String | ErrorStatusCode |
| ErrorStatusMessage | String | ErrorStatusMessage |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| FileContents | String | FileContents |
| ExpirationDate | Datetime | ExpirationDate |
| LastUpdatedByUserName | String | LastUpdatedByUserName |
| CreatedByUserName | String | CreatedByUserName |
| AsyncTrackerId | String | AsyncTrackerId |
| FileWebImage | String | FileWebImage |
| DownloadInfo | String | DownloadInfo |
| Category | String | Category |
| Type | String | Type |
InvoicesavailablePrepayments
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceNumber | String | InvoiceNumber |
| LineNumber | String | LineNumber |
| Description | String | Description |
| SupplierSite | String | SupplierSite |
| PurchaseOrder | String | PurchaseOrder |
| Currency | String | Currency |
| AvailableAmount | String | AvailableAmount |
| IncludedTax | String | IncludedTax |
InvoicesinvoiceDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceId | String | InvoiceId |
| ApprovingDepartment | String | ApprovingDepartment |
| ApprovingUser | String | ApprovingUser |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceGdf
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceId | String | InvoiceId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceInstallments
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InstallmentNumber | String | InstallmentNumber |
| UnpaidAmount | String | UnpaidAmount |
| FirstDiscountAmount | String | FirstDiscountAmount |
| FirstDiscountDate | Date | FirstDiscountDate |
| DueDate | Date | DueDate |
| GrossAmount | String | GrossAmount |
| HoldReason | String | HoldReason |
| PaymentPriority | Int | PaymentPriority |
| SecondDiscountAmount | String | SecondDiscountAmount |
| SecondDiscountDate | Date | SecondDiscountDate |
| ThirdDiscountAmount | String | ThirdDiscountAmount |
| ThirdDiscountDate | Date | ThirdDiscountDate |
| NetAmountOne | String | NetAmountOne |
| NetAmountTwo | String | NetAmountTwo |
| NetAmountThree | String | NetAmountThree |
| HoldFlag | Bool | HoldFlag |
| HeldBy | String | HeldBy |
| HoldType | String | HoldType |
| PaymentMethod | String | PaymentMethod |
| PaymentMethodCode | String | PaymentMethodCode |
| HoldDate | Datetime | HoldDate |
| BankAccount | String | BankAccount |
| ExternalBankAccountId | String | ExternalBankAccountId |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateLogin | String | LastUpdateLogin |
| RemitToAddressName | String | RemitToAddressName |
| RemitToSupplier | String | RemitToSupplier |
| RemittanceMessageOne | String | RemittanceMessageOne |
| RemittanceMessageTwo | String | RemittanceMessageTwo |
| RemittanceMessageThree | String | RemittanceMessageThree |
InvoicesinvoiceInstallmentsinvoiceInstallmentDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceinstallmentsInstallmentNumber | String | InvoiceinstallmentsInstallmentNumber |
| InvoiceId | String | InvoiceId |
| InstallmentNumber | String | InstallmentNumber |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceInstallmentsinvoiceInstallmentGdf
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoiceinstallmentsInstallmentNumber | String | InvoiceinstallmentsInstallmentNumber |
| InvoiceId | String | InvoiceId |
| InstallmentNumber | String | InstallmentNumber |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLines
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| LineNumber | Long | LineNumber |
| LineAmount | String | LineAmount |
| AccountingDate | Date | AccountingDate |
| UOM | String | UOM |
| TaxRateName | String | TaxRateName |
| LineType | String | LineType |
| AssetBook | String | AssetBook |
| TrackAsAssetFlag | Bool | TrackAsAssetFlag |
| BaseAmount | String | BaseAmount |
| Description | String | Description |
| IncomeTaxRegion | String | IncomeTaxRegion |
| Item | String | Item |
| ItemDescription | String | ItemDescription |
| LineSource | String | LineSource |
| Quantity | String | Quantity |
| DistributionCombination | String | DistributionCombination |
| AssetCategory | String | AssetCategory |
| UnitPrice | String | UnitPrice |
| ProrateAcrossAllItemsFlag | Bool | ProrateAcrossAllItemsFlag |
| LandedCostEnabled | String | LandedCostEnabled |
| DiscardedFlag | Bool | DiscardedFlag |
| CanceledFlag | Bool | CanceledFlag |
| IncomeTaxType | String | IncomeTaxType |
| TaxRateCode | String | TaxRateCode |
| TaxRate | String | TaxRate |
| TaxClassification | String | TaxClassification |
| GenerateDistributions | String | GenerateDistributions |
| BudgetDate | Date | BudgetDate |
| FundsStatus | String | FundsStatus |
| ApprovalStatus | String | ApprovalStatus |
| DistributionSet | String | DistributionSet |
| Withholding | String | Withholding |
| ShipToLocationCode | String | ShipToLocationCode |
| ShipToLocation | String | ShipToLocation |
| ShipToCustomerLocation | String | ShipToCustomerLocation |
| TaxControlAmount | String | TaxControlAmount |
| AssessableValue | String | AssessableValue |
| ProductType | String | ProductType |
| ProductCategory | String | ProductCategory |
| ProductCategoryCodePath | String | ProductCategoryCodePath |
| UserDefinedFiscalClassification | String | UserDefinedFiscalClassification |
| UserDefinedFiscalClassificationCode | String | UserDefinedFiscalClassificationCode |
| IntendedUse | String | IntendedUse |
| IntendedUseCode | String | IntendedUseCode |
| ProductFiscalClassification | String | ProductFiscalClassification |
| ProductFiscalClassificationCode | String | ProductFiscalClassificationCode |
| ProductFiscalClassificationType | String | ProductFiscalClassificationType |
| TransactionBusinessCategory | String | TransactionBusinessCategory |
| TransactionBusinessCategoryCodePath | String | TransactionBusinessCategoryCodePath |
| Requester | String | Requester |
| PurchasingCategory | String | PurchasingCategory |
| MatchType | String | MatchType |
| MatchOption | String | MatchOption |
| MatchBasis | String | MatchBasis |
| PurchaseOrderNumber | String | PurchaseOrderNumber |
| PurchaseOrderLineNumber | String | PurchaseOrderLineNumber |
| PurchaseOrderScheduleLineNumber | String | PurchaseOrderScheduleLineNumber |
| ReceiptNumber | String | ReceiptNumber |
| ReceiptLineNumber | String | ReceiptLineNumber |
| ConsumptionAdviceNumber | String | ConsumptionAdviceNumber |
| ConsumptionAdviceLineNumber | String | ConsumptionAdviceLineNumber |
| FinalMatchFlag | Bool | FinalMatchFlag |
| MultiperiodAccountingStartDate | Date | MultiperiodAccountingStartDate |
| MultiperiodAccountingEndDate | Date | MultiperiodAccountingEndDate |
| MultiperiodAccountingAccrualAccount | String | MultiperiodAccountingAccrualAccount |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateLogin | String | LastUpdateLogin |
| RequesterId | String | RequesterId |
| PrepaymentNumber | String | PrepaymentNumber |
| PrepaymentLineNumber | Long | PrepaymentLineNumber |
| PrepaymentIncludedonInvoiceFlag | Bool | PrepaymentIncludedonInvoiceFlag |
| ReferenceKeyTwo | String | ReferenceKeyTwo |
| ProductTable | String | ProductTable |
InvoicesinvoiceLinesinvoiceDistributions
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoiceDistributionId | String | InvoiceDistributionId |
| DistributionLineNumber | String | DistributionLineNumber |
| DistributionLineType | String | DistributionLineType |
| IncomeTaxType | String | IncomeTaxType |
| AccountingStatus | String | AccountingStatus |
| MatchedStatus | String | MatchedStatus |
| ValidationStatus | String | ValidationStatus |
| AccountingDate | Date | AccountingDate |
| DistributionAmount | String | DistributionAmount |
| AssetBook | String | AssetBook |
| DistributionCombination | String | DistributionCombination |
| TrackAsAssetFlag | Bool | TrackAsAssetFlag |
| BaseAmount | String | BaseAmount |
| CanceledFlag | Bool | CanceledFlag |
| Description | String | Description |
| IncomeTaxRegion | String | IncomeTaxRegion |
| ReversedFlag | Bool | ReversedFlag |
| InvoicedQuantity | String | InvoicedQuantity |
| UOM | String | UOM |
| UnitPrice | String | UnitPrice |
| PurchaseOrderDistributionLineNumber | String | PurchaseOrderDistributionLineNumber |
| PurchaseOrderNumber | String | PurchaseOrderNumber |
| PurchaseOrderLineNumber | String | PurchaseOrderLineNumber |
| PurchaseOrderScheduleLineNumber | String | PurchaseOrderScheduleLineNumber |
| ReceiptNumber | String | ReceiptNumber |
| ReceiptLineNumber | String | ReceiptLineNumber |
| ConsumptionAdviceNumber | String | ConsumptionAdviceNumber |
| ConsumptionAdviceLineNumber | String | ConsumptionAdviceLineNumber |
| AssociatedItemDistributionLineNumber | String | AssociatedItemDistributionLineNumber |
| FinalMatchFlag | Bool | FinalMatchFlag |
| MultiperiodAccountingStartDate | Date | MultiperiodAccountingStartDate |
| MultiperiodAccountingEndDate | Date | MultiperiodAccountingEndDate |
| MultiperiodAccountingAccrualAccount | String | MultiperiodAccountingAccrualAccount |
| TaxRegimeName | String | TaxRegimeName |
| TaxName | String | TaxName |
| TaxRecoverable | String | TaxRecoverable |
| TaxRate | String | TaxRate |
| TaxRateName | String | TaxRateName |
| TaxType | String | TaxType |
| IntendedUse | String | IntendedUse |
| IntendedUseCode | String | IntendedUseCode |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| PrepaymentNumber | String | PrepaymentNumber |
| PrepaymentLineNumber | String | PrepaymentLineNumber |
| PrepaymentDistributionLineNumber | String | PrepaymentDistributionLineNumber |
| PrepaymentAvailableAmount | String | PrepaymentAvailableAmount |
| ChargeApplicableToDistId | String | ChargeApplicableToDistId |
| AllocationLineNumber | Long | AllocationLineNumber |
| AllocationDistributionLineNumber | String | AllocationDistributionLineNumber |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoicedistributionsInvoiceDistributionId | String | InvoicedistributionsInvoiceDistributionId |
| InvoiceDistributionId | String | InvoiceDistributionId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionGdf
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoicedistributionsInvoiceDistributionId | String | InvoicedistributionsInvoiceDistributionId |
| InvoiceDistributionId | String | InvoiceDistributionId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLinesinvoiceDistributionsinvoiceDistributionProjectDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoicedistributionsInvoiceDistributionId | String | InvoicedistributionsInvoiceDistributionId |
| InvoiceDistributionId | String | InvoiceDistributionId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLinesinvoiceLineDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoiceId | String | InvoiceId |
| LineNumber | Long | LineNumber |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLinesinvoiceLineGdf
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoiceId | String | InvoiceId |
| LineNumber | Long | LineNumber |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
InvoicesinvoiceLinesinvoiceLineProjectDff
| Name | Type | Description |
| InvoicesInvoiceId | String | InvoicesInvoiceId |
| InvoicelinesLineNumber | Long | InvoicelinesLineNumber |
| InvoiceId | String | InvoiceId |
| LineNumber | Long | LineNumber |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatches
| Name | Type | Description |
| JeBatchId [KEY] | String | JeBatchId |
| AccountedPeriodType | String | AccountedPeriodType |
| DefaultPeriodName | String | DefaultPeriodName |
| BatchName | String | BatchName |
| Status | String | Status |
| ControlTotal | String | ControlTotal |
| BatchDescription | String | BatchDescription |
| ErrorMessage | String | ErrorMessage |
| PostedDate | Date | PostedDate |
| PostingRunId | String | PostingRunId |
| RequestId | String | RequestId |
| RunningTotalAccountedCr | String | RunningTotalAccountedCr |
| RunningTotalAccountedDr | String | RunningTotalAccountedDr |
| RunningTotalCr | String | RunningTotalCr |
| RunningTotalDr | String | RunningTotalDr |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| ActualFlagMeaning | String | ActualFlagMeaning |
| ApprovalStatusMeaning | String | ApprovalStatusMeaning |
| ApproverEmployeeName | String | ApproverEmployeeName |
| FundsStatusMeaning | String | FundsStatusMeaning |
| ParentJeBatchName | String | ParentJeBatchName |
| ChartOfAccountsName | String | ChartOfAccountsName |
| StatusMeaning | String | StatusMeaning |
| CompletionStatusMeaning | String | CompletionStatusMeaning |
| UserPeriodSetName | String | UserPeriodSetName |
| UserJeSourceName | String | UserJeSourceName |
| ReversalDate | Date | ReversalDate |
| ReversalPeriod | String | ReversalPeriod |
| ReversalFlag | Bool | ReversalFlag |
| ReversalMethodMeaning | String | ReversalMethodMeaning |
JournalBatchesbatchAttachment
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| AttachedDocumentId | String | AttachedDocumentId |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| FileName | String | FileName |
| DmFolderPath | String | DmFolderPath |
| DmDocumentId | String | DmDocumentId |
| DmVersionNumber | String | DmVersionNumber |
| Url | String | Url |
| Uri | String | Uri |
| FileUrl | String | FileUrl |
| UploadedText | String | UploadedText |
| UploadedFileContentType | String | UploadedFileContentType |
| UploadedFileLength | String | UploadedFileLength |
| UploadedFileName | String | UploadedFileName |
| ContentRepositoryFileShared | Bool | ContentRepositoryFileShared |
| Title | String | Title |
| Description | String | Description |
| ErrorStatusCode | String | ErrorStatusCode |
| ErrorStatusMessage | String | ErrorStatusMessage |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| FileContents | String | FileContents |
| ExpirationDate | Datetime | ExpirationDate |
| LastUpdatedByUserName | String | LastUpdatedByUserName |
| CreatedByUserName | String | CreatedByUserName |
| AsyncTrackerId | String | AsyncTrackerId |
| FileWebImage | String | FileWebImage |
| DownloadInfo | String | DownloadInfo |
| Category | String | Category |
| Type | String | Type |
JournalBatchesjournalActionLogs
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| ActionDate | Date | ActionDate |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| UserName | String | UserName |
| ActionCodeMeaning | String | ActionCodeMeaning |
JournalBatchesjournalBatchDFF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JeBatchId | String | JeBatchId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatchesjournalErrors
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JeLineNumber | String | JeLineNumber |
| BatchName | String | BatchName |
| HeaderName | String | HeaderName |
| ErrorMessage | String | ErrorMessage |
| ErrorMessageName | String | ErrorMessageName |
| ErrorNumber | String | ErrorNumber |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
JournalBatchesjournalHeaders
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JournalName | String | JournalName |
| AccrualReversalEffectiveDate | Date | AccrualReversalEffectiveDate |
| AccrualReversalPeriodName | String | AccrualReversalPeriodName |
| AccrualReversalStatus | String | AccrualReversalStatus |
| CloseAccountSequenceValue | String | CloseAccountSequenceValue |
| ControlTotal | String | ControlTotal |
| CurrencyCode | String | CurrencyCode |
| CurrencyConversionDate | Date | CurrencyConversionDate |
| CurrencyConversionRate | String | CurrencyConversionRate |
| DefaultEffectiveDate | Date | DefaultEffectiveDate |
| JournalDescription | String | JournalDescription |
| ExternalReference | String | ExternalReference |
| OriginatingBalSegValue | String | OriginatingBalSegValue |
| PeriodName | String | PeriodName |
| ReferenceDate | Date | ReferenceDate |
| RunningTotalAccountedDr | String | RunningTotalAccountedDr |
| PostingAccountSequenceValue | String | PostingAccountSequenceValue |
| RunningTotalCr | String | RunningTotalCr |
| RunningTotalDr | String | RunningTotalDr |
| RunningTotalAccountedCr | String | RunningTotalAccountedCr |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LedgerName | String | LedgerName |
| LegalEntityName | String | LegalEntityName |
| JeFromSlaFlagMeaning | String | JeFromSlaFlagMeaning |
| EncumbranceType | String | EncumbranceType |
| ReversedJeHeaderName | String | ReversedJeHeaderName |
| AccrualReversalJeHeaderName | String | AccrualReversalJeHeaderName |
| CloseAccountSequenceAssignName | String | CloseAccountSequenceAssignName |
| PostingAccountSequenceAssignName | String | PostingAccountSequenceAssignName |
| LedgerCurrencyCode | String | LedgerCurrencyCode |
| InvCurrencyConversionRate | String | InvCurrencyConversionRate |
| UserCurrencyConversionType | String | UserCurrencyConversionType |
| UserJeCategoryName | String | UserJeCategoryName |
JournalBatchesjournalHeadersjournalAttachment
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| AttachedDocumentId | String | AttachedDocumentId |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
| FileName | String | FileName |
| DmFolderPath | String | DmFolderPath |
| DmDocumentId | String | DmDocumentId |
| DmVersionNumber | String | DmVersionNumber |
| Url | String | Url |
| Uri | String | Uri |
| FileUrl | String | FileUrl |
| UploadedText | String | UploadedText |
| UploadedFileContentType | String | UploadedFileContentType |
| UploadedFileLength | String | UploadedFileLength |
| UploadedFileName | String | UploadedFileName |
| ContentRepositoryFileShared | Bool | ContentRepositoryFileShared |
| Title | String | Title |
| Description | String | Description |
| ErrorStatusCode | String | ErrorStatusCode |
| ErrorStatusMessage | String | ErrorStatusMessage |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| FileContents | String | FileContents |
| ExpirationDate | Datetime | ExpirationDate |
| LastUpdatedByUserName | String | LastUpdatedByUserName |
| CreatedByUserName | String | CreatedByUserName |
| AsyncTrackerId | String | AsyncTrackerId |
| FileWebImage | String | FileWebImage |
| DownloadInfo | String | DownloadInfo |
| Category | String | Category |
| Type | String | Type |
JournalBatchesjournalHeadersjournalDFF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JeHeaderId | String | JeHeaderId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatchesjournalHeadersjournalGDF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JeHeaderId | String | JeHeaderId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatchesjournalHeadersjournalLines
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JeLineNumber | String | JeLineNumber |
| AccountedCr | String | AccountedCr |
| AccountedDr | String | AccountedDr |
| Description | String | Description |
| CurrencyConversionDate | Date | CurrencyConversionDate |
| CurrencyConversionRate | String | CurrencyConversionRate |
| CurrencyCode | String | CurrencyCode |
| EnteredCr | String | EnteredCr |
| EnteredDr | String | EnteredDr |
| JgzzReconReference | String | JgzzReconReference |
| Reference1 | String | Reference1 |
| Reference9 | String | Reference9 |
| Reference8 | String | Reference8 |
| Reference7 | String | Reference7 |
| Reference6 | String | Reference6 |
| Reference5 | String | Reference5 |
| Reference4 | String | Reference4 |
| Reference3 | String | Reference3 |
| Reference2 | String | Reference2 |
| Reference10 | String | Reference10 |
| StatAmount | String | StatAmount |
| CreationDate | Datetime | CreationDate |
| CreatedBy | String | CreatedBy |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| JgzzReconDate | Date | JgzzReconDate |
| JgzzReconId | String | JgzzReconId |
| ReconciliationReference | String | ReconciliationReference |
| JgzzReconStatusMeaning | String | JgzzReconStatusMeaning |
| UserCurrencyConversionType | String | UserCurrencyConversionType |
| AccountCombination | String | AccountCombination |
| ChartOfAccountsName | String | ChartOfAccountsName |
JournalBatchesjournalHeadersjournalLinescapturedInformationDFF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JournallinesJeLineNumber | String | JournallinesJeLineNumber |
| JeHeaderId | String | JeHeaderId |
| JeLineNum | String | JeLineNum |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatchesjournalHeadersjournalLinesjournalLineDFF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JournallinesJeLineNumber | String | JournallinesJeLineNumber |
| JeHeaderId | String | JeHeaderId |
| JeLineNum | String | JeLineNum |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalBatchesjournalHeadersjournalLinesjournalLineGDF
| Name | Type | Description |
| JournalBatchesJeBatchId | String | JournalBatchesJeBatchId |
| JournallinesJeLineNumber | String | JournallinesJeLineNumber |
| JeHeaderId | String | JeHeaderId |
| JeLineNum | String | JeLineNum |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
JournalCategoriesLOV
| Name | Type | Description |
| JeCategoryName [KEY] | String | JeCategoryName |
| Description | String | Description |
| UserJeCategoryName | String | UserJeCategoryName |
| DisallowMjeFlag | Bool | DisallowMjeFlag |
JournalSourcesLOV
| Name | Type | Description |
| JeSourceName [KEY] | String | JeSourceName |
| UserJeSourceName | String | UserJeSourceName |
| Description | String | Description |
LedgerBalances
| Name | Type | Description |
| AccountGroupName | String | AccountGroupName |
| AccountName | String | AccountName |
| LedgerSetName | String | LedgerSetName |
| LedgerName | String | LedgerName |
| Currency | String | Currency |
| CurrentAccountingPeriod | String | CurrentAccountingPeriod |
| PeriodName | String | PeriodName |
| CurrentPeriodBalance | String | CurrentPeriodBalance |
| ActualBalance | String | ActualBalance |
| BudgetBalance | String | BudgetBalance |
| Scenario | String | Scenario |
| AccountCombination | String | AccountCombination |
| DetailAccountCombination | String | DetailAccountCombination |
| BeginningBalance | String | BeginningBalance |
| PeriodActivity | String | PeriodActivity |
| EndingBalance | String | EndingBalance |
| AmountType | String | AmountType |
| CurrencyType | String | CurrencyType |
| ErrorDetail | String | ErrorDetail |
| Segment1TreeCode | String | Segment1TreeCode |
| Segment2TreeCode | String | Segment2TreeCode |
| Segment3TreeCode | String | Segment3TreeCode |
| Segment4TreeCode | String | Segment4TreeCode |
| Segment5TreeCode | String | Segment5TreeCode |
| Segment6TreeCode | String | Segment6TreeCode |
| Segment7TreeCode | String | Segment7TreeCode |
| Segment8TreeCode | String | Segment8TreeCode |
| Segment9TreeCode | String | Segment9TreeCode |
| Segment10TreeCode | String | Segment10TreeCode |
| Segment11TreeCode | String | Segment11TreeCode |
| Segment12TreeCode | String | Segment12TreeCode |
| Segment13TreeCode | String | Segment13TreeCode |
| Segment14TreeCode | String | Segment14TreeCode |
| Segment15TreeCode | String | Segment15TreeCode |
| Segment16TreeCode | String | Segment16TreeCode |
| Segment17TreeCode | String | Segment17TreeCode |
| Segment18TreeCode | String | Segment18TreeCode |
| Segment19TreeCode | String | Segment19TreeCode |
| Segment20TreeCode | String | Segment20TreeCode |
| Segment21TreeCode | String | Segment21TreeCode |
| Segment22TreeCode | String | Segment22TreeCode |
| Segment23TreeCode | String | Segment23TreeCode |
| Segment24TreeCode | String | Segment24TreeCode |
| Segment25TreeCode | String | Segment25TreeCode |
| Segment26TreeCode | String | Segment26TreeCode |
| Segment27TreeCode | String | Segment27TreeCode |
| Segment28TreeCode | String | Segment28TreeCode |
| Segment29TreeCode | String | Segment29TreeCode |
| Segment30TreeCode | String | Segment30TreeCode |
LedgersLOV
| Name | Type | Description |
| AccountedPeriodType | String | AccountedPeriodType |
| ChartOfAccountsId | String | ChartOfAccountsId |
| Description | String | Description |
| EnableBudgetaryControlFlag | Bool | EnableBudgetaryControlFlag |
| LedgerCategoryCode | String | LedgerCategoryCode |
| LedgerId [KEY] | String | LedgerId |
| Name | String | Name |
| LedgerTypeCode | String | LedgerTypeCode |
| PeriodSetName | String | PeriodSetName |
| SequencingModeCode | String | SequencingModeCode |
| ApDocumentSequencingOptionFlag | Bool | ApDocumentSequencingOptionFlag |
| ArDocumentSequencingOptionFlag | Bool | ArDocumentSequencingOptionFlag |
| EnfSequenceDateCorrelationCode | String | EnfSequenceDateCorrelationCode |
| CurrencyCode | String | CurrencyCode |
LegalEntitiesLOV
| Name | Type | Description |
| LegalEntityId [KEY] | String | LegalEntityId |
| Name | String | Name |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| PartyId | String | PartyId |
| LeSystemDateTime | String | LeSystemDateTime |
MemoLinesLOV
| Name | Type | Description |
| MemoLineId [KEY] | String | The unique identifier of the Memo Line. |
| Name | String | Memo line name. |
| Description | String | Memo line description. |
| TaxCode | String | Standard memo line tax code. |
| TaxProductCategory | String | Classifies non-inventory products or services for tax purposes. |
| UOMCode | String | Standard memo line unit of measure. |
| SetName | String | Name of the reference data set value used within the context of transaction setups that are retrived through various reference resources. |
PartyFiscalClassifications
| Name | Type | Description |
| ClassificationTypeCategCode | String | ClassificationTypeCategCode |
| Levels | String | Levels |
| ClassificationTypeCode | String | ClassificationTypeCode |
| ClassificationTypeName | String | ClassificationTypeName |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| OwnerIdChar | String | OwnerIdChar |
| ClassificationTypeLevelCode | String | ClassificationTypeLevelCode |
| ClassificationTypeId [KEY] | String | ClassificationTypeId |
| OwnerTableCode | String | OwnerTableCode |
| PartyClassification | String | PartyClassification |
| ClassificationCategoryMeaning | String | ClassificationCategoryMeaning |
| ClassificationCode | String | ClassificationCode |
| ClassificationMeaning | String | ClassificationMeaning |
PartyFiscalClassificationsfiscalClassificationTypeTaxRegimeAssociations
| Name | Type | Description |
| PartyFiscalClassificationsClassificationTypeId | String | PartyFiscalClassificationsClassificationTypeId |
| ClassificationTypeCode | String | ClassificationTypeCode |
| TaxRegimeCode | String | TaxRegimeCode |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
PartyTaxProfiles
| Name | Type | Description |
| PartyTypeCode | String | PartyTypeCode |
| PartyName | String | PartyName |
| PartyNumber | String | PartyNumber |
| PartySiteNumber | String | PartySiteNumber |
| RoundingLevelCode | String | RoundingLevelCode |
| RoundingRuleCode | String | RoundingRuleCode |
| InclusiveTaxFlag | Bool | InclusiveTaxFlag |
| TaxClassificationCode | String | TaxClassificationCode |
| CustomerFlag | Bool | CustomerFlag |
| SiteFlag | Bool | SiteFlag |
| SupplierFlag | Bool | SupplierFlag |
| AllowOffsetTaxFlag | Bool | AllowOffsetTaxFlag |
| AllowZeroAmountWhtInvoiceFlag | Bool | AllowZeroAmountWhtInvoiceFlag |
| CountryCode | String | CountryCode |
| EffectiveFromUseLe | Date | EffectiveFromUseLe |
| PartyId | String | PartyId |
| ProcessForApplicabilityFlag | Bool | ProcessForApplicabilityFlag |
| RegistrationTypeCode | String | RegistrationTypeCode |
| RepresentativeRegistrationNumber | String | RepresentativeRegistrationNumber |
| UseLeAsSubscriberFlag | Bool | UseLeAsSubscriberFlag |
| WhtDateBasis | String | WhtDateBasis |
| WhtRoundingLevelCode | String | WhtRoundingLevelCode |
| WhtRoundingRuleCode | String | WhtRoundingRuleCode |
| WhtUseLeAsSubscriberFlag | Bool | WhtUseLeAsSubscriberFlag |
| PartyTaxProfileId [KEY] | String | PartyTaxProfileId |
| TaxGrossNetFlagCode | String | TaxGrossNetFlagCode |
PayablesAndProcurementOptions
| Name | Type | Description |
| BillToLocationId | String | BillToLocationId |
| BuyingCompanyIdentifier | String | BuyingCompanyIdentifier |
| GaplessInvoiceNumberingFlag | Bool | GaplessInvoiceNumberingFlag |
| OffsetSegments | String | OffsetSegments |
| RequireConversioRateEntryFlag | Bool | RequireConversioRateEntryFlag |
| BusinessUnitId [KEY] | String | BusinessUnitId |
| TaxRegistrationNumber | String | TaxRegistrationNumber |
| TaxCountryCode | String | TaxCountryCode |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| BusinessUnit | String | BusinessUnit |
| BillToLocation | String | BillToLocation |
| TaxRegistrationMemberState | String | TaxRegistrationMemberState |
| ConversionRateType | String | ConversionRateType |
| Liability | String | Liability |
| DiscountTaken | String | DiscountTaken |
| Freight | String | Freight |
| RealizedGainDistribution | String | RealizedGainDistribution |
| RealizedLossDistribution | String | RealizedLossDistribution |
| BillPayable | String | BillPayable |
| Miscellaneous | String | Miscellaneous |
| OneTimePaymentExpense | String | OneTimePaymentExpense |
| OneTimePaymentLiability | String | OneTimePaymentLiability |
| Prepayment | String | Prepayment |
| PrepaymentTaxDifference | String | PrepaymentTaxDifference |
| ConversionRateVarianceGain | String | ConversionRateVarianceGain |
| ConversionRateVarianceLoss | String | ConversionRateVarianceLoss |
| PaymentTerms | String | PaymentTerms |
| AlwaysTakeDiscount | String | AlwaysTakeDiscount |
| PayDateBasis | String | PayDateBasis |
| InvoiceCurrency | String | InvoiceCurrency |
| PaymentCurrency | String | PaymentCurrency |
| TermsDateBasis | String | TermsDateBasis |
| PayAlone | String | PayAlone |
| AccrueExpenseItems | String | AccrueExpenseItems |
| AutomaticOffsets | String | AutomaticOffsets |
| HoldUnmatchedInvoicesFlag | Bool | HoldUnmatchedInvoicesFlag |
| PaymentConversionRateType | String | PaymentConversionRateType |
PayablesCalendarTypes
| Name | Type | Description |
| ToDate | Date | ToDate |
| FromDate | Date | FromDate |
| CalendarName | String | CalendarName |
| CalendarType | String | CalendarType |
| Description | String | Description |
| PeriodFrequency | String | PeriodFrequency |
| PeriodNameFormat | String | PeriodNameFormat |
| PeriodsPERYear | Long | PeriodsPERYear |
| StartDate | Date | StartDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
PayablesCalendarTypespayablesCalendarPeriods
| Name | Type | Description |
| PayablesCalendarTypescalendarName | String | PayablesCalendarTypescalendarName |
| PayablesCalendarTypescalendarType | String | PayablesCalendarTypescalendarType |
| DueDate | Date | DueDate |
| EndDate | Date | EndDate |
| EnteredPeriodName | String | EnteredPeriodName |
| PeriodName | String | PeriodName |
| Sequence | String | Sequence |
| PeriodYear | String | PeriodYear |
| StartDate | Date | StartDate |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
PayablesDistributionSets
| Name | Type | Description |
| Description | String | Description |
| DistributionSetId [KEY] | String | DistributionSetId |
| Name | String | Name |
| InactiveDate | Date | InactiveDate |
| BusinessUnitId | String | BusinessUnitId |
| Percentage | String | Percentage |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| BusinessUnit | String | BusinessUnit |
PayablesDistributionSetsLOV
| Name | Type | Description |
| DistributionSetId [KEY] | String | DistributionSetId |
| DistributionSetName | String | DistributionSetName |
| OrgId | String | OrgId |
PayablesDistributionSetspayablesDistributionSetsLines
| Name | Type | Description |
| PayablesDistributionSetsdistributionSetId | String | PayablesDistributionSetsdistributionSetId |
| Description | String | Description |
| DistributionSetId | String | DistributionSetId |
| LineNumber | String | LineNumber |
| BusinessUnitId | String | BusinessUnitId |
| Percentage | String | Percentage |
| IncomeTaxType | String | IncomeTaxType |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| DistributionCombination | String | DistributionCombination |
PayablesIncomeTaxRegions
| Name | Type | Description |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
| RegionName | String | RegionName |
| State [KEY] | String | State |
| RegionCode | String | RegionCode |
| ReportingLimit | String | ReportingLimit |
| ReportingLimitMethod | String | ReportingLimitMethod |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
PayablesIncomeTaxTypes
| Name | Type | Description |
| IncomeTaxType [KEY] | String | IncomeTaxType |
| Description | String | Description |
| InactiveDate | Date | InactiveDate |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
PayablesInvoiceHolds
| Name | Type | Description |
| HoldInstruction | String | HoldInstruction |
| HoldType | String | HoldType |
| InactiveDate | Date | InactiveDate |
| HoldsResolutionRoutingFlag | Bool | HoldsResolutionRoutingFlag |
| PostableFlag | Bool | PostableFlag |
| DaysBeforeReminding | String | DaysBeforeReminding |
| UserReleaseableFlag | Bool | UserReleaseableFlag |
| UserUpdateableFlag | Bool | UserUpdateableFlag |
| DaysBeforeNotifying | String | DaysBeforeNotifying |
| Description | String | Description |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| HoldName | String | HoldName |
PayablesInvoiceHoldsLOV
| Name | Type | Description |
| HoldLookupCode [KEY] | String | HoldLookupCode |
| HoldType | String | HoldType |
| Description | String | Description |
| Name | String | Name |
PayablesOptions
| Name | Type | Description |
| SettlementDays | Long | SettlementDays |
| BusinessUnitId [KEY] | String | BusinessUnitId |
| AllowFinalMatchingFlag | Bool | AllowFinalMatchingFlag |
| AllowMatchingDistributionOverrideFlag | Bool | AllowMatchingDistributionOverrideFlag |
| AllowForceApprovalFlag | Bool | AllowForceApprovalFlag |
| AllowAdjustmentsToPaidInvoicesFlag | Bool | AllowAdjustmentsToPaidInvoicesFlag |
| AllowRemitToSupplierOverrideForThirdPartyPaymentsFlag | Bool | AllowRemitToSupplierOverrideForThirdPartyPaymentsFlag |
| AllowPayeeOverrideForThirdPartyPaymentsFlag | Bool | AllowPayeeOverrideForThirdPartyPaymentsFlag |
| AllowOverrideOfSupplierSiteBankAccountFlag | Bool | AllowOverrideOfSupplierSiteBankAccountFlag |
| AlwaysTakeDiscFlag | Bool | AlwaysTakeDiscFlag |
| RequireAccountingBeforeApproval | String | RequireAccountingBeforeApproval |
| EnableInvoiceApprovalFlag | Bool | EnableInvoiceApprovalFlag |
| CreateInterestInvoicesFlag | Bool | CreateInterestInvoicesFlag |
| BankChargeDeductionType | String | BankChargeDeductionType |
| BudgetDateBasis | String | BudgetDateBasis |
| UseDistributionFromPurchaseOrderFlag | Bool | UseDistributionFromPurchaseOrderFlag |
| DiscountAllocationMethod | String | DiscountAllocationMethod |
| ExcludeTaxFromDiscountCalculationFlag | Bool | ExcludeTaxFromDiscountCalculationFlag |
| PaymentRequestPaymentPriority | Long | PaymentRequestPaymentPriority |
| PaymentRequestPayGroup | String | PaymentRequestPayGroup |
| ExcludeFreightFromDiscountCalculationFlag | Bool | ExcludeFreightFromDiscountCalculationFlag |
| GlDateFromReceiptFlag | Bool | GlDateFromReceiptFlag |
| MinimumInterestAmount | String | MinimumInterestAmount |
| InvoiceCurrency | String | InvoiceCurrency |
| AllowInvoiceDocumentCategoryOverrideFlag | Bool | AllowInvoiceDocumentCategoryOverrideFlag |
| LastUpdateDate | Datetime | LastUpdateDate |
| RequireConversionRateEntryForPaymentsFlag | Bool | RequireConversionRateEntryForPaymentsFlag |
| PaymentCurrency | String | PaymentCurrency |
| PayDateBasis | String | PayDateBasis |
| AllowPaymentDocumentCategoryOverrideFlag | Bool | AllowPaymentDocumentCategoryOverrideFlag |
| PaymentPriority | Long | PaymentPriority |
| AllowPaymentDateBeforeTheSystemDateFlag | Bool | AllowPaymentDateBeforeTheSystemDateFlag |
| ShowAvailablePrepaymentsDuringInvoiceEntryFlag | Bool | ShowAvailablePrepaymentsDuringInvoiceEntryFlag |
| InterestAllocationMethodFlag | Bool | InterestAllocationMethodFlag |
| RecalculateInvoiceInstallmentsFlag | Bool | RecalculateInvoiceInstallmentsFlag |
| ReceiptAcceptanceDays | String | ReceiptAcceptanceDays |
| EnableInvoiceAccountCodingWorkflowFlag | Bool | EnableInvoiceAccountCodingWorkflowFlag |
| AllowInvoiceBackdatingForSelfServiceInvoicesFlag | Bool | AllowInvoiceBackdatingForSelfServiceInvoicesFlag |
| LimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag | Bool | LimitInvoiceToSinglePurchaseOrderForSelfServiceInvoicesFlag |
| AllowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices | String | AllowUnitPriceChangeForQuantityBasedMatchesForSelfServiceInvoices |
| TermsDateBasis | String | TermsDateBasis |
| TransferPOdistributionAdditionalInformationFlag | Bool | TransferPOdistributionAdditionalInformationFlag |
| RequireValidationBeforeApprovalFlag | Bool | RequireValidationBeforeApprovalFlag |
| PayGroup | String | PayGroup |
| AccountForPayment | String | AccountForPayment |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| BusinessUnitName | String | BusinessUnitName |
| PaymentRequestPaymentTerms | String | PaymentRequestPaymentTerms |
| InterestExpenseDistribution | String | InterestExpenseDistribution |
| PrepaymentPaymentTerms | String | PrepaymentPaymentTerms |
| AmountTolerances | String | AmountTolerances |
| PaymentTerms | String | PaymentTerms |
| QuantityTolerances | String | QuantityTolerances |
| LedgerId | String | LedgerId |
| LedgerCurrency | String | LedgerCurrency |
| FederalIdentificationNumber | String | FederalIdentificationNumber |
| LocationId | String | LocationId |
| AllowAddressChange | String | AllowAddressChange |
| IncomeTaxCombinedFilingProgram | String | IncomeTaxCombinedFilingProgram |
| IncomeTaxRegion | String | IncomeTaxRegion |
| SupplierTaxRegion | String | SupplierTaxRegion |
| USSGLTransactionCode | String | USSGLTransactionCode |
| USSGLTrxDescriptiveFlexfieldContext | String | USSGLTrxDescriptiveFlexfieldContext |
| IncludeWitholdingDistInIncometaxreports | String | IncludeWitholdingDistInIncometaxreports |
| RequireInvoiceGroup | String | RequireInvoiceGroup |
| AttachmentMandatoryForSelfServiceInvoicesFlag | Bool | AttachmentMandatoryForSelfServiceInvoicesFlag |
| DisallowAttachmentDeleteFlag | Bool | DisallowAttachmentDeleteFlag |
| AccountingDateBasis | String | AccountingDateBasis |
PayablesPayments
| Name | Type | Description |
| CheckId [KEY] | String | CheckId |
| PaymentId | String | PaymentId |
| PaymentReference | String | PaymentReference |
| PaperDocumentNumber | String | PaperDocumentNumber |
| PaymentNumber | String | PaymentNumber |
| PaymentFileReference | String | PaymentFileReference |
| PaymentProcessRequest | String | PaymentProcessRequest |
| PaymentAmount | String | PaymentAmount |
| PaymentDate | Date | PaymentDate |
| AccountingDate | Date | AccountingDate |
| PaymentDescription | String | PaymentDescription |
| ConversionRate | String | ConversionRate |
| ConversionDate | Date | ConversionDate |
| ConversionRateType | String | ConversionRateType |
| ClearingDate | Date | ClearingDate |
| ClearingAmount | String | ClearingAmount |
| ClearingLedgerAmount | String | ClearingLedgerAmount |
| ClearingConversionRate | String | ClearingConversionRate |
| ClearingConversionDate | Date | ClearingConversionDate |
| ClearingConversionRateType | String | ClearingConversionRateType |
| CrossCurrencyRateType | String | CrossCurrencyRateType |
| MaturityDate | Date | MaturityDate |
| MaturityConversionRateType | String | MaturityConversionRateType |
| MaturityConversionDate | Date | MaturityConversionDate |
| MaturityConversionRate | String | MaturityConversionRate |
| AnticipatedValueDate | Date | AnticipatedValueDate |
| ClearingValueDate | Date | ClearingValueDate |
| StopDate | Date | StopDate |
| VoidDate | Date | VoidDate |
| VoidAccountingDate | Date | VoidAccountingDate |
| PaymentStatus | String | PaymentStatus |
| SeparateRemittanceAdviceCreated | String | SeparateRemittanceAdviceCreated |
| AccountingStatus | String | AccountingStatus |
| ReconciledFlag | Bool | ReconciledFlag |
| PaymentType | String | PaymentType |
| PaymentCurrency | String | PaymentCurrency |
| WithheldAmount | String | WithheldAmount |
| BankChargeAmount | String | BankChargeAmount |
| LegalEntity | String | LegalEntity |
| BusinessUnit | String | BusinessUnit |
| PaymentFunction | String | PaymentFunction |
| Payee | String | Payee |
| PartyId | String | PartyId |
| ProcurementBU | String | ProcurementBU |
| PayeeSite | String | PayeeSite |
| EmployeeAddress | String | EmployeeAddress |
| SupplierNumber | String | SupplierNumber |
| ThirdPartySupplier | String | ThirdPartySupplier |
| ThirdPartyAddressName | String | ThirdPartyAddressName |
| ExternalBankAccountId | String | ExternalBankAccountId |
| RemitToAccountNumber | String | RemitToAccountNumber |
| DisbursementBankAccountNumber | String | DisbursementBankAccountNumber |
| DisbursementBankAccountName | String | DisbursementBankAccountName |
| PaymentMethodCode | String | PaymentMethodCode |
| PaymentMethod | String | PaymentMethod |
| PaymentDocument | String | PaymentDocument |
| PaymentProcessProfileCode | String | PaymentProcessProfileCode |
| PaymentProcessProfile | String | PaymentProcessProfile |
| DocumentCategory | String | DocumentCategory |
| DocumentSequence | String | DocumentSequence |
| VoucherNumber | String | VoucherNumber |
| PaymentBaseAmount | String | PaymentBaseAmount |
| PaymentBaseCurrency | String | PaymentBaseCurrency |
| AddressLine1 | String | AddressLine1 |
| AddressLine2 | String | AddressLine2 |
| AddressLine3 | String | AddressLine3 |
| AddressLine4 | String | AddressLine4 |
| City | String | City |
| County | String | County |
| Province | String | Province |
| State | String | State |
| Country | String | Country |
| Zip | String | Zip |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdatedBy | String | LastUpdatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
PayablesPaymentspaymentDff
| Name | Type | Description |
| PayablesPaymentsCheckId | String | PayablesPaymentsCheckId |
| CheckId | String | CheckId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
PayablesPaymentspaymentGdf
| Name | Type | Description |
| PayablesPaymentsCheckId | String | PayablesPaymentsCheckId |
| CheckId | String | CheckId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
PayablesPaymentTerms
| Name | Type | Description |
| TermsId [KEY] | String | TermsId |
| Name | String | Name |
| EnabledFlag | Bool | EnabledFlag |
| FromDate | Date | FromDate |
| ToDate | Date | ToDate |
| CutoffDay | Long | CutoffDay |
| Rank | String | Rank |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| Description | String | Description |
| SetId | String | SetId |
PayablesPaymentTermsLOV
| Name | Type | Description |
| TermId [KEY] | String | TermId |
| Name | String | Name |
| SetId | String | SetId |
PayablesPaymentTermspayablesPaymentTermsLines
| Name | Type | Description |
| PayablesPaymentTermstermsId | String | PayablesPaymentTermstermsId |
| DuePercent | String | DuePercent |
| AmountDue | String | AmountDue |
| Days | Long | Days |
| DayOfMonth | Long | DayOfMonth |
| MonthsAhead | Long | MonthsAhead |
| FirstDiscountPercent | String | FirstDiscountPercent |
| FirstDiscountDays | Long | FirstDiscountDays |
| FirstDiscountDayOfMonth | Long | FirstDiscountDayOfMonth |
| FirstDiscountMonthsForward | Long | FirstDiscountMonthsForward |
| SecondDiscountPercent | String | SecondDiscountPercent |
| SecondDiscountDays | Long | SecondDiscountDays |
| SecondDiscountDayOfMonth | Long | SecondDiscountDayOfMonth |
| SecondDiscountMonthsForward | Long | SecondDiscountMonthsForward |
| ThirdDiscountPercent | String | ThirdDiscountPercent |
| ThirdDiscountDays | Long | ThirdDiscountDays |
| ThirdDiscountDayOfMonth | Long | ThirdDiscountDayOfMonth |
| ThirdDiscountMonthsForward | Long | ThirdDiscountMonthsForward |
| FixedDate | Date | FixedDate |
| Calendar | String | Calendar |
| SequenceNumber | Long | SequenceNumber |
| TermsId | String | TermsId |
PayablesPaymentTermspayablesPaymentTermsSets
| Name | Type | Description |
| PayablesPaymentTermstermsId | String | PayablesPaymentTermstermsId |
| SetName | String | SetName |
PayablesPaymentTermspayablesPaymentTermsTranslations
| Name | Type | Description |
| PayablesPaymentTermstermsId | String | PayablesPaymentTermstermsId |
| Name | String | Name |
| Description | String | Description |
| TermsId | String | TermsId |
| Language | String | Language |
PayablesTaxReportingEntities
| Name | Type | Description |
| ReportingEntityName | String | ReportingEntityName |
| TaxEntityId [KEY] | String | TaxEntityId |
| LocationId | String | LocationId |
| TaxpayerIdentification | String | TaxpayerIdentification |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| LocationDescription | String | LocationDescription |
| BusinessUnit | String | BusinessUnit |
| Location | String | Location |
PayablesTaxReportingEntitiespayablesTaxReportingEntityLine
| Name | Type | Description |
| PayablesTaxReportingEntitiestaxEntityId | String | PayablesTaxReportingEntitiestaxEntityId |
| BalancingSegmentValue | String | BalancingSegmentValue |
| TaxEntityId | String | TaxEntityId |
| CreatedBy | String | CreatedBy |
| CreationDate | Datetime | CreationDate |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdateLogin | String | LastUpdateLogin |
| LastUpdatedBy | String | LastUpdatedBy |
| Description | String | Description |
PayeeBankAccountsLOV
| Name | Type | Description |
| BankAccountId | String | BankAccountId |
| AccountNumber [KEY] | String | AccountNumber |
| IBAN | String | IBAN |
| AccountName | String | AccountName |
| AlternateAccountName | String | AlternateAccountName |
| AccountCountry | String | AccountCountry |
| CurrencyCode | String | CurrencyCode |
| AllowInternationalPaymentsIndicator | String | AllowInternationalPaymentsIndicator |
| BankName | String | BankName |
| BankCode | String | BankCode |
| BranchName | String | BranchName |
| BranchNumber | String | BranchNumber |
| SWIFTCode | String | SWIFTCode |
| CheckDigits | String | CheckDigits |
| AccountSuffix | String | AccountSuffix |
| SecondaryAccountReference | String | SecondaryAccountReference |
| AgencyLocationCode | String | AgencyLocationCode |
| AccountType | String | AccountType |
| FactorAccountIndicator | String | FactorAccountIndicator |
| Description | String | Description |
| StartDate | Date | StartDate |
| EndDate | Date | EndDate |
PaymentCodesLOV
| Name | Type | Description |
| PaymentCode | String | PaymentCode |
| PaymentCodeName | String | PaymentCodeName |
| PaymentCodeType | String | PaymentCodeType |
| PaymentCodeAlias | String | PaymentCodeAlias |
| Country | String | Country |
| PaymentCodeDescription | String | PaymentCodeDescription |
| FromDate | Date | FromDate |
| EndDate | Date | EndDate |
PaymentProcessRequests
| Name | Type | Description |
| PaymentProcessRequestId [KEY] | String | PaymentProcessRequestId |
| SourceApplicationIdentifier | String | SourceApplicationIdentifier |
| PaymentProcessRequestName | String | PaymentProcessRequestName |
| PaymentProcessRequestStatusCode | String | PaymentProcessRequestStatusCode |
| PaymentProcessRequestStatusMeaning | String | PaymentProcessRequestStatusMeaning |
| Action | String | Action |
PaymentsExternalPayees
| Name | Type | Description |
| PayeeId [KEY] | String | PayeeId |
| PaymentFunctionCode | String | PaymentFunctionCode |
| OrganizationIdentifier | String | OrganizationIdentifier |
| OrganizationName | String | OrganizationName |
| OrganizationType | String | OrganizationType |
| PayEachDocumentAloneOption | String | PayEachDocumentAloneOption |
| DefaultPaymentMethodCode | String | DefaultPaymentMethodCode |
| DefaultPaymentMethodName | String | DefaultPaymentMethodName |
| BankChargeBearerCode | String | BankChargeBearerCode |
| BankChargeBearerName | String | BankChargeBearerName |
| BankInstructionCodeOne | String | BankInstructionCodeOne |
| BankInstructionNameOne | String | BankInstructionNameOne |
| BankInstructionCodeTwo | String | BankInstructionCodeTwo |
| BankInstructionNameTwo | String | BankInstructionNameTwo |
| BankInstructionDetails | String | BankInstructionDetails |
| PaymentReasonCode | String | PaymentReasonCode |
| PaymentReasonName | String | PaymentReasonName |
| PaymentReasonComments | String | PaymentReasonComments |
| PaymentTextMessageOne | String | PaymentTextMessageOne |
| PaymentTextMessageTwo | String | PaymentTextMessageTwo |
| PaymentTextMessageThree | String | PaymentTextMessageThree |
| DeliveryChannelCode | String | DeliveryChannelCode |
| DeliveryChannelName | String | DeliveryChannelName |
| ServiceLevelCode | String | ServiceLevelCode |
| ServiceLevelName | String | ServiceLevelName |
| SettlementPriority | String | SettlementPriority |
| DeliveryMethod | String | DeliveryMethod |
| String | ||
| Fax | String | Fax |
| PayeePartyIdentifier | String | PayeePartyIdentifier |
| PartyName | String | PartyName |
| PayeePartyNumber | String | PayeePartyNumber |
| PayeePartySiteIdentifier | String | PayeePartySiteIdentifier |
| SupplierNumber | String | SupplierNumber |
| SupplierSiteCode | String | SupplierSiteCode |
| SupplierSiteIdentifier | String | SupplierSiteIdentifier |
| PayeePartySiteNumber | String | PayeePartySiteNumber |
| PaymentFormatCode | String | PaymentFormatCode |
| PaymentFormatName | String | PaymentFormatName |
| PersonId | String | PersonId |
| Intent | String | Intent |
PaymentsExternalPayeesexternalPartyPaymentMethods
| Name | Type | Description |
| PaymentsExternalPayeesPayeeId | String | PaymentsExternalPayeesPayeeId |
| ExternalPartyPaymentMethodsId | String | ExternalPartyPaymentMethodsId |
| PayeeId | String | PayeeId |
| PayeeName | String | PayeeName |
| PaymentMethodCode | String | PaymentMethodCode |
| PaymentMethodName | String | PaymentMethodName |
| PrimaryIndicator | String | PrimaryIndicator |
| FromDate | Date | FromDate |
| ToDate | Date | ToDate |
| SiteName | String | SiteName |
| AddressName | String | AddressName |
PaymentTermsLOV
| Name | Type | Description |
| PaymentTermsId [KEY] | String | The unique identifier of the payment term. |
| Name | String | Payment term name. |
| Description | String | Payment term description. |
| SetName | String | Name of the reference data set value used within the context of transaction setups that are retrived through various reference resources. |
PreferredCurrenciesLOV
| Name | Type | Description |
| CurrencyCode [KEY] | String | CurrencyCode |
| CurrencyName | String | CurrencyName |
| CurrencyFlag | Bool | CurrencyFlag |
| EnabledFlag | Bool | EnabledFlag |
| DisplaySequence | String | DisplaySequence |
| StartDateActive | Date | StartDateActive |
| EndDateActive | Date | EndDateActive |
| Precision | Int | Precision |
| MinimumAccountableUnit | String | MinimumAccountableUnit |
| Symbol | String | Symbol |
| LedgerSetId | String | LedgerSetId |
| ExtendedPrecision | Int | ExtendedPrecision |
| IssuingTerritoryCode | String | IssuingTerritoryCode |
PurchaseToPayLegalEntitiesLOV
| Name | Type | Description |
| LegalEntityId [KEY] | String | LegalEntityId |
| Name | String | Name |
| PartyId | String | PartyId |
| LegalEntityIdentifier | String | LegalEntityIdentifier |
| TransactingEntityFlag | Bool | TransactingEntityFlag |
| ActivityCode | String | ActivityCode |
| SubActivityCode | String | SubActivityCode |
| TypeOfCompany | String | TypeOfCompany |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| RegistrationNumber | String | RegistrationNumber |
| LegislativeCategory | String | LegislativeCategory |
| AddressLine1 | String | AddressLine1 |
| AddressLine2 | String | AddressLine2 |
| AddressLine3 | String | AddressLine3 |
| TownOrCity | String | TownOrCity |
| PostalCode | String | PostalCode |
| CountryCode | String | CountryCode |
ReceiptMethodAssignments
| Name | Type | Description |
| CustomerReceiptMethodId [KEY] | String | Unique identifier of the customer receipt method. |
| CustomerAccountNumber | String | The account number of the customer. |
| CustomerSiteNumber | String | The site number of the customer account. |
| ReceiptMethodName | String | The name of the receipt method. |
| Primary | String | Indicates if the customer receipt method is primary. |
| StartDate | Date | The start date of the customer receipt method. |
| EndDate | Date | The end date of the customer receipt method. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
ReceiptMethods
| Name | Type | Description |
| ReceiptMethodId [KEY] | String | The identifier of the receipt method used for a REST service. |
| Name | String | The name of the receipt method that associates receipt class, remittance bank, and receipt account information with receipts for a REST service. |
| ReceiptClass | String | The name of the receipt class that identifies the steps involved for processing receipts for a REST service. |
| LastUpdateDate | Datetime | The date the receipt method was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt method for a REST service. |
| CreatedBy | String | The name of the user who created the receipt method for a REST service. |
| CreationDate | Datetime | The date the receipt method was created for a REST service. |
ReceiptMethodsreceiptMethodDFF
| Name | Type | Description |
| ReceiptMethodsReceiptMethodId | String | The unique identifier of the receipt method for a REST service. |
| ReceiptMethodId | String | ReceiptMethodId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesAdjustments
| Name | Type | Description |
| AdjustmentId [KEY] | String | AdjustmentId |
| AdjustmentNumber | String | AdjustmentNumber |
| AdjustmentType | String | AdjustmentType |
| AdjustmentAmount | String | AdjustmentAmount |
| AdjustmentDate | Date | AdjustmentDate |
| AccountingDate | Date | AccountingDate |
| Status | String | Status |
| ReceivablesActivity | String | ReceivablesActivity |
| BusinessUnit | String | BusinessUnit |
| CustomerTransactionId | String | CustomerTransactionId |
| TransactionNumber | String | TransactionNumber |
| TransactionClass | String | TransactionClass |
| AccountedAmount | String | AccountedAmount |
| Currency | String | Currency |
| InstallmentNumber | String | InstallmentNumber |
| InstallmentBalance | String | InstallmentBalance |
| AdjustmentReason | String | AdjustmentReason |
| ApprovedBy | String | ApprovedBy |
| BillToSiteUseId | String | BillToSiteUseId |
| Comments | String | Comments |
| AccountCombination | String | AccountCombination |
| CreationDate | Datetime | CreationDate |
| CreatedBy | String | CreatedBy |
| LastUpdateDate | Datetime | LastUpdateDate |
| LastUpdatedBy | String | LastUpdatedBy |
ReceivablesAdjustmentsreceivablesAdjustmentDFF
| Name | Type | Description |
| ReceivablesAdjustmentsAdjustmentId | String | ReceivablesAdjustmentsAdjustmentId |
| AdjustmentId | String | AdjustmentId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesBusinessUnitsLOV
| Name | Type | Description |
| BusinessUnitId [KEY] | String | BusinessUnitId |
| BusinessUnitName | String | BusinessUnitName |
| PrimaryLedgerId | String | PrimaryLedgerId |
ReceivablesCreditMemos
| Name | Type | Description |
| CustomerTransactionId [KEY] | String | Unique identifier of the credit memo. |
| TransactionNumber | String | The number that identifies the credit memo. |
| TransactionDate | Date | The date when a transaction is created. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time when the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. |
| CreditMemoCurrency | String | The code that identifies the entered currency of the credit memo. |
| BusinessUnit | String | The business unit under which the credit memo is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. |
| TransactionType | String | The transaction type assigned to the credit memo. |
| TransactionSource | String | The transaction source assigned to the credit memo. |
| AccountingDate | Date | The accounting date assigned to the credit memo. |
| LegalEntityIdentifier | String | The unique identifier of the legal entity under which the credit memo is created. A legal entity is a recognized party with rights and responsibilities given by legislation. |
| CreditReason | String | The reason the credit memo was created or applied to a transaction. |
| BillToCustomerNumber | String | The account number of the bill-to customer assigned to the credit memo. |
| BillToSite | String | The number that identifies the bill-to customer site assigned to the credit memo. |
| BillToCustomerName | String | The name of the bill-to customer assigned to the credit memo. |
| EnteredAmount | String | The original credit memo amount in the entered currency. |
| DocumentNumber | String | The document sequence number assigned to the credit memo. |
| CrossReference | String | The reference field default value from the transaction source assigned to the credit memo. The reference field default value is the source document used to identify transactions created using the transaction source. |
| CustomerReference | String | The document that provides additional information about a credit memo. |
| CustomerReferenceDate | Date | The date when the customer requested a credit memo. |
| BillingDate | Date | The balance forward bill date, if the credit memo belongs to a balance forward bill. |
| PurchaseOrder | String | The purchase order number assigned to credit memo. |
| SpecialInstructions | String | The special instructions that accompany the credit memo. |
| CreditMemoComments | String | The user comments that accompany the credit memo. |
| DefaultTaxationCountry | String | The country where the transaction takes place for tax purposes. |
| FreightShipDate | Date | The date when the items on the credit memo were shipped. |
| Carrier | String | The name of the shipping contractor. |
| FreightShippingReference | String | The waybill reference on the credit memo. |
| FreightFOB | String | The location where ownership of goods or services is transferred from seller to buyer. |
| ConversionRateType | String | The grouping of conversion rates between currencies, used to automatically populate a specific rate to the credit memo transaction or transaction line according to business requirements. Valid values are Spot, Corporate, User, and Fixed. |
| ConversionRate | String | The rate used to convert a foreign currency credit memo transaction amount to the ledger currency. |
| ConversionRateDate | Date | The date used to derive a currency conversion rate. |
| FirstPartyRegistrationNumber | String | The registration number for tax purposes assigned to the business unit or legal entity on the credit memo. |
| ThirdPartyRegistrationNumber | String | The registration number for tax purposes assigned to the customer on the credit memo. |
| ShipToCustomerName | String | The name of the customer who receives the goods or services billed. |
| ShipToCustomerNumber | String | The account number of the ship-to customer assigned to the credit memo. |
| ShipToCustomerSite | String | The number that identifies the ship-to customer site assigned to the credit memo. |
| FreightCreditAmount | String | The freight amount credited by the credit memo. |
| PrimarySalesperson | String | The number that identifies the primary salesperson on the credit memo. |
| Intercompany | String | The option used to identify the credit memo as an intercompany transaction.. |
| TransactionBalanceDue | String | The balance due on the credit memo. |
| DeliveryMethod | String | The method used to print and deliver credit memo transactions. Valid values are E-Mail, Paper, and XML. |
| PrintStatus | String | The status that indicates whether a transaction was printed. |
| PrintDate | Date | Date when the credit memo was printed. |
| GenerateBill | String | The option that indicates whether to print the credit memo. |
| DocumentFiscalClassifcation | String | The classification for tax purposes of credit memo transactions that require special documentation to accompany the transaction, as designated by a tax authority. |
| PayingCustomerName | String | The name of the customer who paid for the goods or services on the credit memo. |
| PayingCustomerSite | String | The number that identifies the paying customer site assigned to the credit memo. |
| PayingCustomerAccount | String | The account number of the paying customer assigned to the credit memo. |
| BillToContact | String | The contact details of the bill-to customer. |
| ShipToContact | String | The contact details of the ship-to customer. |
| SoldToPartyNumber | String | The unique number to identify the sold-to customer on the credit memo. |
| PurchaseOrderDate | Date | The date of the purchase order. |
| CreditMemoStatus | String | The value that indicates the level of completion of the credit memo. Valid values are Complete, Incomplete, and Frozen. |
| InternalNotes | String | The user-defined internal notes that accompany the credit memo. |
| PurchaseOrderRevision | String | The revision number for the purchase order. |
| StructuredPaymentReference | String | An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank. |
| AllowCompletion | String | Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is Y. |
| ControlCompletionReason | String | Reason that determines transaction completion. |
ReceivablesCreditMemosattachments
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
ReceivablesCreditMemosnotes
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| NoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| SourceObjectCode | String | This is the source object code for the source object as defined in OBJECTS Metadata. |
| SourceObjectId | String | The unique identifier of the parent source object associated to the note. |
| PartyName | String | The name of the party. |
| NoteTxt | String | The column which stores the actual note text. |
| NoteTypeCode | String | The note type code for categorization of note. |
| VisibilityCode | String | The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private. |
| CreatorPartyId | String | The unique identifier of the party. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| PartyId | String | The unique identifier of the party. |
| CorpCurrencyCode | String | The corporate currency code for extensibility. |
| CurcyConvRateType | String | The currency conversion rate type for extensibility. |
| CurrencyCode | String | The currency code for extensibility. |
| ContactRelationshipId | String | The relationship ID populated when the note is associated with a contact. |
| ParentNoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdatedBy | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdateLogin | String | The login of the user who last updated the record. |
| EmailAddress | String | The email address of the user who created the note. |
| FormattedAddress | String | The address of the user who created the note. |
| FormattedPhoneNumber | String | The phone number of the user who created the note. |
| UpdateFlag | Bool | Indicates whether the user can update the note. |
| DeleteFlag | Bool | Indicates whether the user has access to delete the note. |
| NoteNumber | String | The alternate unique identifier of the note. A user key that is system generated or from an external system. |
| NoteTitle | String | The title of the note entered by the user. |
ReceivablesCreditMemosreceivablesCreditMemoDFF
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| CustomerTrxId | String | CustomerTrxId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoDistributions
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| DistributionId | String | The unique identifier of the credit memo distribution. |
| AccountedAmount | String | The amount of the distribution in the ledger currency. |
| Amount | String | The amount of the distribution in the credit memo currency. |
| Comments | String | The user-defined comments about the distribution. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time when the record was created. |
| DetailedTaxLineNumber | String | The number of the tax line of a credit memo line associated with the distribution. |
| CreditMemoLineNumber | String | The number of the credit memo line associated with the distribution. |
| LastUpdateDate | Datetime | The date and time the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| Percent | String | The percentage of the line amount mapped to this distribution. |
| AccountClass | String | The account class of the distribution. Valid values are Revenue, Receivable, Freight, and Tax. |
| AccountCombination | String | The account code combination for the distribution. |
ReceivablesCreditMemosreceivablesCreditMemoDistributionsreceivablesCreditMemoDistributionDFF
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemodistributionsDistributionId | String | The unique identifier of the credit memo distribution. |
| CustTrxLineGlDistId | String | CustTrxLineGlDistId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoGdf
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| CustomerTrxId | String | CustomerTrxId |
| ExcludeFromNetting | String | ExcludeFromNetting |
| DeliveryDateforTaxPointDate | Date | DeliveryDateforTaxPointDate |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoLines
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| CustomerTransactionLineId | String | Unique identifier of each separate line of the credit memo. |
| LineNumber | String | The number of an individual line of the credit memo. |
| LineDescription | String | The description that identifies the product or service on the credit memo line. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| UnitSellingPrice | String | The price of an individual item on the credit memo line. |
| LineQuantityCredit | String | The quantity of products or services credited on the credit memo line. |
| LineAmountCredit | String | The credited amount on the credit memo line. |
| Warehouse | String | The ship-from location for the item on the credit memo line. This value applies to inventory items. |
| UnitOfMeasure | String | The unit of measure used to quantify the product or service on the credit memo line. |
| ItemNumber | String | The number that identifies the inventory item on the credit memo line. |
| MemoLine | String | The user-defined attribute that identifies a product or service on the credit memo line that is not an inventory item. |
| LineCreditReason | String | The user-defined reason for crediting all or part of the line amount of the credit memo line. |
| LineTranslatedDescription | String | The translated description of the credit memo line. |
| TaxInvoiceNumber | String | A unique identifier of the fiscal document supporting the sale, which is generated upon shipment of goods. |
| TaxInvoiceDate | Date | The date the tax invoice document is generated. |
| TransactionLineAssessableValue | String | The numeric value used as the taxable base amount to calculate tax on a specific credit memo transaction item. |
| SalesOrderNumber | String | The number that identifies the sales order on the credit memo line. |
| SalesOrderDate | Date | The date when the sales order was created. |
| SalesOrderLine | String | The number of the credit memo line where the sales order is referenced. |
| SalesOrderRevision | String | The number that identifies the revision to a sales order on the credit memo line. |
| SalesOrderChannel | String | The medium used to create the sales order on the credit memo line. |
| TaxClassificationCode | String | The code used as a determining factor in tax calculation on the credit memo line. |
| LineFreightCreditAmount | String | The freight line amount credited by the credit memo. |
| LineProductType | String | The nature of the item or product on the credit memo line, sometimes used as a determining factor in tax calculation. Valid values are Goods and Services. |
| ProductFiscalClassification | String | The classification for tax purposes of the taxable nature of the product or product transaction on the credit memo line, as designated by a tax authority. |
| LineProductCategory | String | The classification for tax purposes of a non-inventory based product on the credit memo line, as designated by a tax authority. |
| TransactionBusinessCategory | String | The classification for tax purposes of the business nature of a transaction, as designated by a tax authority. |
| UserDefinedFiscalClassification | String | The user-defined classification for tax purposes of additional tax requirements, as designated by a tax authority. |
| LineTaxExemptionHandling | String | The value that indicates the tax exemption to apply to the credit memo line. Valid values are Standard, Require, Exempt. |
| LineAmountIncludesTax | String | The option that indicates whether the line amount is inclusive of tax, exclusive of tax, or determined by the tax setup. |
| TaxExemptionReason | String | The reason a party or product has a tax exemption on the credit memo line. |
| TaxExemptionCertificateNumber | String | The number that identifies the document that certifies that a party or product is partially or fully exempt from a tax. |
| LineIntendedUse | String | The classification for tax purposes of the intended use of the product on the credit memo line, as designated by a tax authority. |
ReceivablesCreditMemosreceivablesCreditMemoLinesattachments
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId | String | The unique identifier of the credit memo line. |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineDFF
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId | String | The unique identifier of the credit memo line. |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineGdf
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId | String | The unique identifier of the credit memo line. |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTaxLines
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId | String | The unique identifier of the credit memo line. |
| CustomerTrxLineId | String | The unique identifier of each separate tax line of the credit memo. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time when the record was created. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| TaxJurisdictionCode | String | The tax jurisdiction code assigned to the tax line. |
| TaxRate | String | The tax rate assigned to the credit memo line. |
| TaxRateCode | String | The tax rate code assigned to the credit memo line. |
| TaxRegimeCode | String | The tax regime code assigned to the tax line. |
| TaxStatusCode | String | The tax status code assigned to the tax line. |
| Tax | String | The code of the tax assigned to the tax line. |
| TaxAmount | String | The tax amount on the credit memo line in the entered currency. |
| TaxableAmount | String | The amount on the credit memo line eligible for taxation. The tax rate is applied to the taxable amount. |
| TaxPointBasis | String | The transaction event that is the basis for tax on the credit memo line. |
| TaxPointDate | Date | The date when the taxpayer becomes liable for paying the tax to the tax authority. |
| TaxLineNumber | Long | The line number of the tax line of the credit memo line. |
| PlaceOfSupply | Long | The location where the transaction on the credit memo line is determined to take place for tax purposes. |
| TaxInclusiveIndicator | String | The option that indicates whether the credit memo line amount is inclusive of tax. |
ReceivablesCreditMemosreceivablesCreditMemoLinesreceivablesCreditMemoLineTransactionDFF
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| ReceivablescreditmemolinesCustomerTransactionLineId | String | The unique identifier of the credit memo line. |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCreditMemosreceivablesCreditMemoTransactionDFF
| Name | Type | Description |
| ReceivablesCreditMemosCustomerTransactionId | String | The unique identifier of the credit memo. |
| CustomerTrxId | String | CustomerTrxId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCustomerAccountActivities
| Name | Type | Description |
| AccountId [KEY] | String | The unique identifier of a customer account for a REST service. |
| AccountNumber | String | The number that identifies a customer account. |
| CustomerName | String | The name of the customer party associated with the customer account for a REST service. |
| CustomerId | String | The identifier of the customer party associated with the customer account for a REST service. |
| TaxRegistrationNumber | String | The registration number for tax purposes assigned to the bill-to customer for a REST service. |
| TaxpayerIdentificationNumber | String | The number that identifies the customer party to a tax authority to pay and report direct taxes for a REST service. |
| TotalOpenReceivablesForAccount | String | The total open receivables amount in the ledger currency of a customer account for a REST service. |
| TotalTransactionsDueForAccount | String | The total transaction amount due in the ledger currency of a customer account for a REST service. |
| CreatedBy | String | The name of the user who created the customer account for a REST service. |
| CreationDate | Datetime | The date the customer account was created for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the customer account for a REST service. |
| LastUpdateDate | Datetime | The date the customer account was last updated for a REST service. |
ReceivablesCustomerAccountActivitiescreditMemoApplications
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| ApplicationId | String | The identifier of the credit memo application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the credit memo application against a transaction for a REST service. |
| ApplicationAmount | String | The amount in the entered currency of the credit memo application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a credit memo for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment that the credit memo is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction that the credit memo is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction that the credit memo is applied against for a REST service. |
| AccountingDate | Date | The accounting date of the credit memo application for a REST service. |
| CreditMemoId | String | The identifier of the credit memo for a REST service. |
| CreditMemoNumber | String | The number of the credit memo for a REST service. |
| CreditMemoStatus | String | The status of the credit memo application for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the credit memo application against a transaction for a REST service. |
| TransactionType | String | The credit memo application transaction type for a REST service. |
| ActivityName | String | The name of the credit memo activity for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a credit memo for a REST service. Valid values are Y and N. |
| CreationDate | Datetime | The date the credit memo application was created for a REST service. |
| CreatedBy | String | The name of the user who created the credit memo application for a REST service. |
| LastUpdateDate | Datetime | The date the credit memo application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the credit memo application for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the credit memo applied against a transaction. |
| ReferenceTransactionStatus | String | The status of the transaction that the credit memo is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountActivitiescreditMemoApplicationscreditMemoApplicationDFF
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| CreditmemoapplicationsApplicationId | String | The unique identifier of the credit memo application against a transaction for a REST service. |
| ReceivableApplicationId | String | ReceivableApplicationId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCustomerAccountActivitiescreditMemos
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| CreditMemoId | String | The identifier of the credit memo for a REST service. |
| CreditMemoNumber | String | The credit memo number for a REST service. |
| CreditMemoDate | Date | The credit memo transaction date for a REST service. |
| TransactionClass | String | The credit memo transaction class for a REST service. |
| AccountingDate | Date | The credit memo accounting date for a REST service. |
| PurchaseOrder | String | The purchase order number assigned to the credit memo for a REST service. |
| TotalOriginalAmount | String | The original credit memo balance amount in the entered currency for a REST service. |
| TotalBalanceAmount | String | The remaining credit memo balance amount in the entered currency for a REST service. |
| AvailableAmount | String | The remaining credit memo amount in the entered currency of the credit memo application for a REST service. |
| TransactionType | String | The credit memo transaction type for a REST service. |
| InstallmentId | String | The identifier of the credit memo installment for a REST service. |
| CreditMemoCurrency | String | The credit memo currency for a REST service. |
| CreditMemoStatus | String | The credit memo status for a REST service. |
| CreatedBy | String | The name of the user who created the credit memo for a REST service. |
| CreationDate | Datetime | The date the credit memo was created for a REST service. |
| LastUpdateDate | Datetime | The date the credit memo was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the credit memo for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the credit memo. |
ReceivablesCustomerAccountActivitiesstandardReceiptApplications
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| ApplicationId | String | The identifier of the receipt application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the receipt application against a transaction for a REST service. |
| ApplicationAmount | String | The amount of the receipt application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a standard receipt for a REST service. |
| AccountingDate | Date | The accounting date of the receipt application for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment the receipt is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction the receipt is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction the receipt is applied against for a REST service. |
| ActivityName | String | The name of the receipt activity for a REST service. |
| StandardReceiptId | String | The identifier of the receipt number for a REST service. |
| ReceiptNumber | String | The number of the receipt application against a transaction for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the receipt applied against a transaction for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt application against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt application for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a standard receipt for a REST service. Valid values are Y and N. |
| CreatedBy | String | The name of the user who created the receipt application for a REST service. |
| CreationDate | Datetime | The date the receipt application was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt application for a REST service. |
| CustomerSite | String | The name of the customer bill-to site of the receipt applied against a transaction. |
| ReferenceTransactionStatus | String | The status of the transaction that the receipt is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| StandardreceiptapplicationsApplicationId | String | The unique identifier of the receipt application against a transaction for a REST service. |
| ReceivableApplicationId | String | ReceivableApplicationId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCustomerAccountActivitiesstandardReceipts
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| StandardReceiptId | String | The identifier of the receipt applied against a transaction for a REST service. |
| ReceiptNumber | String | The number of the receipt applied against a transaction for a REST service. |
| BusinessUnit | String | The business unit of the receipt applied against a transaction for a REST service. |
| LegalEntity | String | The legal entity of the receipt applied against a transaction for a REST service. |
| ReceiptDate | Date | The date of the receipt applied against a transaction for a REST service. |
| AccountingDate | Date | The accounting date of the receipt applied against a transaction for a REST service. |
| UnappliedAmount | String | The unapplied amount in the entered currency of the receipt applied against a transaction for a REST service. |
| AvailableAmount | String | The remaining receipt amount in the entered currency of the receipt application for a REST service. |
| ReceiptMethod | String | The receipt method used to create the receipt applied against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt applied against a transaction for a REST service. |
| State | String | The tag that identifies the state of a receipt for a REST service. Valid values are: Applied, Unapplied, Unidentified, Insufficient Funds, Reverse Payment, and Stop Payment. |
| Currency | String | The currency code of the receipt applied against a transaction for a REST service. |
| Amount | String | The original receipt amount in the entered currency of the receipt application for a REST service. |
| DocumentNumber | String | The document sequence number of the receipt applied against a transaction for a REST service. |
| CreatedBy | String | The name of the user who created the receipt for a REST service. |
| CreationDate | Datetime | The date the receipt applied against a transaction was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt applied against a transaction was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt applied against a transaction for a REST service. |
| CustomerSite | String | The name of the customer bill-to site of the receipt. |
ReceivablesCustomerAccountActivitiestransactionAdjustments
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| AdjustmentId | String | The identifier of the transaction adjustment for a REST service. |
| AdjustmentNumber | String | The number assigned to the transaction adjustment for a REST service. |
| AdjustmentAmount | String | The amount of the transaction adjustment for a REST service. |
| ApplicationDate | Date | The application date of the transaction adjustment for a REST service. |
| AccountingDate | Date | The accounting date of the transaction adjustment for a REST service. |
| ProcessStatus | String | The process status of the transaction adjustment for a REST service. |
| EnteredCurrency | String | The currency code of the transaction adjustment for a REST service. |
| AdjustmentType | String | The adjustment type assigned to the transaction adjustment for a REST service. |
| AdjustmentReason | String | The reason code assigned to the transaction adjustment for a REST service. |
| ReferenceTransactionNumber | String | The number of the adjusted transaction for a REST service. |
| ReferenceTransactionId | String | The identifier of the adjusted transaction for a REST service. |
| ReferenceInstallmentId | String | The identifier of the adjusted transaction installment for a REST service. |
| LastUpdateDate | Datetime | The date the transaction adjustment was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who last updated the transaction adjustment for a REST service. |
| CreatedBy | String | The name of the user who created the transaction adjustment for a REST service. |
| CreationDate | Datetime | The creation date of the transaction adjustment for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the transaction adjustment. |
| ReferenceTransactionStatus | String | The status of the transaction that the adjustment is made against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountActivitiestransactionPaymentSchedules
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| InstallmentId | String | The identifier of the payment schedule installment for a REST service. |
| InstallmentNumber | String | The number of the payment schedule installment for a REST service. |
| TotalOriginalAmount | String | The original balance amount on the payment schedule installment for a REST service. |
| TotalBalanceAmount | String | The open balance amount on the payment schedule installment for a REST service. |
| PaymentDaysLate | Long | The number of days the payment schedule installment is past due for a REST service. |
| InstallmentStatus | String | The status of the payment schedule installment for a REST service. |
| TransactionNumber | String | The transaction number of the payment schedule installment for a REST service. |
| TransactionId | String | The transaction identifier of the payment schedule installment for a REST service. |
| TransactionDate | Date | The transaction date of the payment schedule installment for a REST service. |
| TransactionClass | String | The transaction class of the payment schedule installment for a REST service. |
| PaymentScheduleDueDate | Date | The payment terms due date of the payment schedule installment for a REST service. |
| AccountingDate | Date | The payment schedule installment accounting date for a REST service. |
| PurchaseOrder | String | The purchase order number assigned to the payment schedule installment for a REST service. |
| TransactionType | String | The transaction type of the payment schedule installment for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt applied against the payment schedule installment for a REST service. |
| EnteredCurrency | String | The currency code of the payment schedule installment for a REST service. |
| TransactionSourceName | String | The name of the transaction source assigned to the payment schedule transaction for a REST service. |
| StructuredPaymentReference | String | The name of the structured payment reference assigned to the payment schedule transaction for a REST service. |
| CreatedBy | String | The name of the user who created the payment schedule installment for a REST service. |
| CreationDate | Datetime | The creation date of the payment schedule installment for a REST service. |
| LastUpdateDate | Datetime | The date the payment schedule installment was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who last updated the payment schedule installment for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the transaction payment schedule. |
ReceivablesCustomerAccountActivitiestransactionsPaidByOtherCustomers
| Name | Type | Description |
| ReceivablesCustomerAccountActivitiesAccountId | String | The unique identifier of a customer account for a REST service. |
| ApplicationId | String | The identifier of the receipt application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the receipt application against a transaction for a REST service. |
| ApplicationAmount | String | The amount of the receipt application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a standard receipt for a REST service. |
| AccountingDate | Date | The accounting date of the receipt application for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment the receipt is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction the receipt is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction the receipt is applied against for a REST service. |
| StandardReceiptId | String | The identifier of the receipt number for a REST service. |
| ReceiptNumber | String | The number of the receipt application against a transaction for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the receipt applied against a transaction for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt application against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt application for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a standard receipt for a REST service. Valid values are Y and N. |
| CreatedBy | String | The name of the user who created the receipt application for a REST service. |
| CreationDate | Datetime | The date the receipt application was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt application for a REST service. |
| ReferenceTransactionStatus | String | The status of the transaction that the receipt is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountSiteActivities
| Name | Type | Description |
| BillToSiteUseId [KEY] | String | The unique identifier of the bill-to site business purpose associated with a customer party for a REST service. |
| BillToSiteNumber | String | The customer site number of the bill-to site associated with a customer party for a REST service. |
| BillToSiteAddress | String | The address of the bill-to site associated with a customer party for a REST service. |
| AccountNumber | String | The number that identifies a customer account. |
| AccountId | String | The unique identifier of a customer account for a REST service. |
| CustomerName | String | The name of the customer party associated with the customer account for a REST service. |
| CustomerId | String | The identifier of the customer party associated with the customer account for a REST service. |
| TaxRegistrationNumber | String | The registration number for tax purposes assigned to the bill-to customer for a REST service. |
| TaxpayerIdentificationNumber | String | The number that identifies the customer party to a tax authority to pay and report direct taxes for a REST service. |
| TotalOpenReceivablesForSite | String | The total open receivables amount in the ledger currency of a customer bill-to site for a REST service. |
| TotalTransactionsDueForSite | String | The total transaction amount due in the ledger currency of a customer bill-to site for a REST service. |
| CreatedBy | String | The name of the user who created the customer account for a REST service. |
| CreationDate | Datetime | The date the customer account was created for a REST service. |
| LastUpdateDate | Datetime | The date the customer account was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the customer account for a REST service. |
ReceivablesCustomerAccountSiteActivitiescreditMemoApplications
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| ApplicationId | String | The identifier of the credit memo application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the credit memo application against a transaction for a REST service. |
| ApplicationAmount | String | The amount in the entered currency of the credit memo application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a credit memo for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment that the credit memo is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction that the credit memo is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction that the credit memo is applied against for a REST service. |
| AccountingDate | Date | The accounting date of the credit memo application for a REST service. |
| CreditMemoId | String | The identifier of the credit memo for a REST service. |
| CreditMemoNumber | String | The number of the credit memo for a REST service. |
| CreditMemoStatus | String | The status of the credit memo application for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the credit memo application against a transaction for a REST service. |
| TransactionType | String | The credit memo application transaction type for a REST service. |
| ActivityName | String | The name of the credit memo activity for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a credit memo for a REST service. Valid values are Y and N. |
| CreationDate | Datetime | The date the credit memo application was created for a REST service. |
| CreatedBy | String | The name of the user who created the credit memo application for a REST service. |
| LastUpdateDate | Datetime | The date the credit memo application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the credit memo application for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the credit memo applied against a transaction. |
| ReferenceTransactionStatus | String | The status of the transaction that the credit memo is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountSiteActivitiescreditMemoApplicationscreditMemoApplicationDFF
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| CreditmemoapplicationsApplicationId | String | The unique identifier of the credit memo application against a transaction for a REST service. |
| ReceivableApplicationId | String | ReceivableApplicationId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCustomerAccountSiteActivitiescreditMemos
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| CreditMemoId | String | The identifier of the credit memo for a REST service. |
| CreditMemoNumber | String | The credit memo number for a REST service. |
| CreditMemoDate | Date | The credit memo transaction date for a REST service. |
| TransactionClass | String | The credit memo transaction class for a REST service. |
| AccountingDate | Date | The credit memo accounting date for a REST service. |
| PurchaseOrder | String | The purchase order number assigned to the credit memo for a REST service. |
| TotalOriginalAmount | String | The original credit memo balance amount in the entered currency for a REST service. |
| TotalBalanceAmount | String | The remaining credit memo balance amount in the entered currency for a REST service. |
| AvailableAmount | String | The remaining credit memo amount in the entered currency of the credit memo application for a REST service. |
| TransactionType | String | The credit memo transaction type for a REST service. |
| InstallmentId | String | The identifier of the credit memo installment for a REST service. |
| CreditMemoCurrency | String | The credit memo currency for a REST service. |
| CreditMemoStatus | String | The credit memo status for a REST service. |
| CreatedBy | String | The name of the user who created the credit memo for a REST service. |
| CreationDate | Datetime | The date the credit memo was created for a REST service. |
| LastUpdateDate | Datetime | The date the credit memo was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the credit memo for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the credit memo. |
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplications
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| ApplicationId | String | The identifier of the receipt application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the receipt application against a transaction for a REST service. |
| ApplicationAmount | String | The amount of the receipt application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a standard receipt for a REST service. |
| AccountingDate | Date | The accounting date of the receipt application for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment the receipt is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction the receipt is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction the receipt is applied against for a REST service. |
| ActivityName | String | The name of the receipt activity for a REST service. |
| StandardReceiptId | String | The identifier of the receipt number for a REST service. |
| ReceiptNumber | String | The number of the receipt application against a transaction for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the receipt applied against a transaction for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt application against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt application for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a standard receipt for a REST service. Valid values are Y and N. |
| CreatedBy | String | The name of the user who created the receipt application for a REST service. |
| CreationDate | Datetime | The date the receipt application was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt application for a REST service. |
| CustomerSite | String | The name of the customer bill-to site of the receipt applied against a transaction. |
| ReferenceTransactionStatus | String | The status of the transaction that the receipt is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountSiteActivitiesstandardReceiptApplicationsstandardReceiptApplicationDFF
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| StandardreceiptapplicationsApplicationId | String | The unique identifier of the receipt application against a transaction for a REST service. |
| ReceivableApplicationId | String | ReceivableApplicationId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesCustomerAccountSiteActivitiesstandardReceipts
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| StandardReceiptId | String | The identifier of the receipt applied against a transaction for a REST service. |
| ReceiptNumber | String | The number of the receipt applied against a transaction for a REST service. |
| BusinessUnit | String | The business unit of the receipt applied against a transaction for a REST service. |
| LegalEntity | String | The legal entity of the receipt applied against a transaction for a REST service. |
| ReceiptDate | Date | The date of the receipt applied against a transaction for a REST service. |
| AccountingDate | Date | The accounting date of the receipt applied against a transaction for a REST service. |
| UnappliedAmount | String | The unapplied amount in the entered currency of the receipt applied against a transaction for a REST service. |
| AvailableAmount | String | The remaining receipt amount in the entered currency of the receipt application for a REST service. |
| ReceiptMethod | String | The receipt method used to create the receipt applied against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt applied against a transaction for a REST service. |
| State | String | The tag that identifies the state of a receipt for a REST service. Valid values are: Applied, Unapplied, Unidentified, Insufficient Funds, Reverse Payment, and Stop Payment. |
| Currency | String | The currency code of the receipt applied against a transaction for a REST service. |
| Amount | String | The original receipt amount in the entered currency of the receipt application for a REST service. |
| DocumentNumber | String | The document sequence number of the receipt applied against a transaction for a REST service. |
| CreatedBy | String | The name of the user who created the receipt for a REST service. |
| CreationDate | Datetime | The date the receipt applied against a transaction was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt applied against a transaction was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt applied against a transaction for a REST service. |
| CustomerSite | String | The name of the customer bill-to site of the receipt. |
ReceivablesCustomerAccountSiteActivitiestransactionAdjustments
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| AdjustmentId | String | The identifier of the transaction adjustment for a REST service. |
| AdjustmentNumber | String | The number assigned to the transaction adjustment for a REST service. |
| AdjustmentAmount | String | The amount of the transaction adjustment for a REST service. |
| ApplicationDate | Date | The application date of the transaction adjustment for a REST service. |
| AccountingDate | Date | The accounting date of the transaction adjustment for a REST service. |
| ProcessStatus | String | The process status of the transaction adjustment for a REST service. |
| EnteredCurrency | String | The currency code of the transaction adjustment for a REST service. |
| AdjustmentType | String | The adjustment type assigned to the transaction adjustment for a REST service. |
| AdjustmentReason | String | The reason code assigned to the transaction adjustment for a REST service. |
| ReferenceTransactionNumber | String | The number of the adjusted transaction for a REST service. |
| ReferenceTransactionId | String | The identifier of the adjusted transaction for a REST service. |
| ReferenceInstallmentId | String | The identifier of the adjusted transaction installment for a REST service. |
| LastUpdateDate | Datetime | The date the transaction adjustment was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who last updated the transaction adjustment for a REST service. |
| CreatedBy | String | The name of the user who created the transaction adjustment for a REST service. |
| CreationDate | Datetime | The creation date of the transaction adjustment for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the transaction adjustment. |
| ReferenceTransactionStatus | String | The status of the transaction that the adjustment is made against for a REST API. Valid values are Open and Closed. |
ReceivablesCustomerAccountSiteActivitiestransactionPaymentSchedules
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| InstallmentId | String | The identifier of the payment schedule installment for a REST service. |
| InstallmentNumber | String | The number of the payment schedule installment for a REST service. |
| TotalOriginalAmount | String | The original balance amount on the payment schedule installment for a REST service. |
| TotalBalanceAmount | String | The open balance amount on the payment schedule installment for a REST service. |
| PaymentDaysLate | Long | The number of days the payment schedule installment is past due for a REST service. |
| InstallmentStatus | String | The status of the payment schedule installment for a REST service. |
| TransactionNumber | String | The transaction number of the payment schedule installment for a REST service. |
| TransactionId | String | The transaction identifier of the payment schedule installment for a REST service. |
| TransactionDate | Date | The transaction date of the payment schedule installment for a REST service. |
| TransactionClass | String | The transaction class of the payment schedule installment for a REST service. |
| PaymentScheduleDueDate | Date | The payment terms due date of the payment schedule installment for a REST service. |
| AccountingDate | Date | The payment schedule installment accounting date for a REST service. |
| PurchaseOrder | String | The purchase order number assigned to the payment schedule installment for a REST service. |
| TransactionType | String | The transaction type of the payment schedule installment for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt applied against the payment schedule installment for a REST service. |
| EnteredCurrency | String | The currency code of the payment schedule installment for a REST service. |
| TransactionSourceName | String | The name of the transaction source assigned to the payment schedule transaction for a REST service. |
| StructuredPaymentReference | String | The name of the structured payment reference assigned to the payment schedule transaction for a REST service. |
| CreatedBy | String | The name of the user who created the payment schedule installment for a REST service. |
| CreationDate | Datetime | The creation date of the payment schedule installment for a REST service. |
| LastUpdateDate | Datetime | The date the payment schedule installment was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who last updated the payment schedule installment for a REST service. |
| BillToSiteNumber | String | The name of the customer bill-to site of the transaction payment schedule. |
ReceivablesCustomerAccountSiteActivitiestransactionsPaidByOtherCustomers
| Name | Type | Description |
| ReceivablesCustomerAccountSiteActivitiesBillToSiteUseId | String | The unique identifier of a customer bill-to site used for a REST service. |
| ApplicationId | String | The identifier of the receipt application against a transaction for a REST service. |
| ApplicationDate | Date | The date of the receipt application against a transaction for a REST service. |
| ApplicationAmount | String | The amount of the receipt application against a transaction for a REST service. |
| ApplicationStatus | String | The value that identifies the application status of an activity on a standard receipt for a REST service. |
| AccountingDate | Date | The accounting date of the receipt application for a REST service. |
| ReferenceInstallmentId | String | The identifier of the transaction installment the receipt is applied against for a REST service. |
| ReferenceTransactionNumber | String | The number of the transaction the receipt is applied against for a REST service. |
| ReferenceTransactionId | String | The identifier of the transaction the receipt is applied against for a REST service. |
| StandardReceiptId | String | The identifier of the receipt number for a REST service. |
| ReceiptNumber | String | The number of the receipt application against a transaction for a REST service. |
| EnteredCurrency | String | The currency code of the entered currency of the receipt applied against a transaction for a REST service. |
| ReceiptMethod | String | The receipt method used for the receipt application against a transaction for a REST service. |
| ProcessStatus | String | The process status of the receipt application for a REST service. |
| IsLatestApplication | String | The value that identifies whether the activity is the latest application on a standard receipt for a REST service. Valid values are Y and N. |
| CreatedBy | String | The name of the user who created the receipt application for a REST service. |
| CreationDate | Datetime | The date the receipt application was created for a REST service. |
| LastUpdateDate | Datetime | The date the receipt application was last updated for a REST service. |
| LastUpdatedBy | String | The name of the user who has last updated the receipt application for a REST service. |
| ReferenceTransactionStatus | String | The status of the transaction that the receipt is applied against for a REST API. Valid values are Open and Closed. |
ReceivablesInvoices
| Name | Type | Description |
| CustomerTransactionId [KEY] | String | The unique identifier of the invoice. |
| DueDate | Date | The date on which the invoice installment is due to be paid. |
| ConversionDate | Date | The date used to derive the invoice currency conversion rate. |
| ConversionRate | String | The rate used to convert the invoice currency to the ledger currency. |
| InvoiceCurrencyCode | String | The code that indicates the currency of the Receivables invoice. |
| SpecialInstructions | String | The special instructions that accompany the invoice. |
| CrossReference | String | The reference field default value from the transaction source assigned to the invoice. The reference field default value is the source document used to identify transactions created using the transaction source. |
| DocumentNumber | String | The document sequence number assigned to the invoice. |
| TransactionNumber | String | The transaction number assigned to the invoice. |
| TransactionDate | Date | The date when the invoice is created. |
| TransactionType | String | The transaction type assigned to the invoice. |
| TransactionSource | String | The transaction source assigned to the invoice. |
| BillToCustomerNumber | String | The account number of the bill-to customer assigned to the invoice. |
| BillToSite | String | The number that identifies the bill-to customer site assigned to the invoice. |
| Comments | String | The user-defined comments that accompany the invoice. |
| InternalNotes | String | The user-defined internal notes that accompany the invoice. |
| PaymentTerms | String | The payment terms associated with the invoice. |
| LegalEntityIdentifier | String | The unique identifier of the legal entity under which the invoice is created. A legal entity is a recognized party with rights and responsibilities given by legislation. |
| ConversionRateType | String | The type used to calculate the currency conversion rate, for example, Corporate, Spot, User. |
| PurchaseOrder | String | The purchase order number on the invoice. |
| PurchaseOrderDate | Date | The date of the purchase order on the invoice. |
| PurchaseOrderRevision | String | The revision number of the purchase order on the invoice. |
| FirstPartyRegistrationNumber | String | The tax registration number of the deploying company. |
| ThirdPartyRegistrationNumber | String | The tax registration number of the bill-to customer. |
| InvoicingRule | String | The accounting approach used to recognize revenue on the invoice. Valid values are In Advance and In Arrears. |
| ShipToCustomerName | String | The name of the customer who receives the goods or services billed on the invoice. |
| ShipToCustomerNumber | String | The account number of the ship-to customer assigned to the invoice. |
| BillingDate | Date | The accounting date assigned to the invoice. |
| BillToPartyId | String | The unique identifier of the bill-to customer assigned to the invoice. |
| BusinessUnit | String | The business unit under which the invoice is created. A business unit is a unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. |
| InvoiceStatus | String | The value that indicates the level of completion of the invoice. Valid values are Complete, Incomplete, and Frozen. |
| AccountingDate | Date | The accounting date assigned to the invoice. |
| ShipToSite | String | The number that identifies the ship-to customer site assigned to the invoice. |
| PayingCustomerName | String | The name of the customer who pays for the goods or services on the invoice. |
| PayingCustomerSite | String | The number that identifies the paying customer site assigned to the invoice. |
| BillToCustomerName | String | The name that identifies the bill-to customer assigned to the invoice. |
| FreightAmount | String | The freight applicable at the Invoice level. |
| Carrier | String | The shipping vendor reference. |
| ShipDate | Date | The date on which the goods are shipped. |
| ShippingReference | String | The way bill reference. |
| BillToContact | String | The contact details of the bill to customer. |
| ShipToContact | String | The contact details of the ship to customer. |
| PrintOption | String | Indicates if transaction should print. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| PayingCustomerAccount | String | The unique number used to identify the account of the paying customer. |
| SoldToPartyNumber | String | The unique number used to identify the the sold to customer. |
| RemitToAddress | String | The address to which the customer should send the payment. |
| DefaultTaxationCountry | String | The default country to calculate tax. |
| EnteredAmount | String | The original invoice amount. |
| InvoiceBalanceAmount | String | The Invoice balance amount. |
| Prepayment | String | The flag that indicates the nature of transaction as prepayment. |
| Intercompany | String | The flag that indicates the nature of transaction as intercompany. |
| DocumentFiscalClassification | String | The transaction header level tax determining attribute referred to in the user interface as document fiscal classification. |
| BankAccountNumber | String | The bank account number of the customer on the invoice. |
| CreditCardAuthorizationRequestIdentifier | String | The authorization request identifier received from the tokenization service provider to authorize the credit card number. |
| CreditCardExpirationDate | String | The expiration date of the credit card. |
| CreditCardIssuerCode | String | The code for the credit card issuer, such as Visa or MasterCard. |
| CreditCardTokenNumber | String | The token number issued by tokenization service provider corresponding to a credit card number. |
| CreditCardVoiceAuthorizationCode | String | The voice authorization code received from tokenization service provider for authorization. |
| CreditCardErrorCode | String | The error code when credit card authorization fails. |
| CreditCardErrorText | String | The error text when credit card authorization fails. |
| CardHolderLastName | String | The last name of the credit card holder. |
| CardHolderFirstName | String | The first name of the credit card holder. |
| ReceiptMethod | String | The Payment Method used to pay the invoice. |
| SalesPersonNumber | String | The number of the primary sales person. |
| StructuredPaymentReference | String | An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction, and its payments to the customer and bank. |
| InvoicePrinted | String | Option that indicates whether the invoice has been printed at least once. The user must enter Y to update print attributes. |
| LastPrintDate | Date | Date when the transaction was last reprinted. |
| OriginalPrintDate | Date | Date when the transaction was first printed. |
| DeliveryMethod | String | Method used to deliver printed transactions. Valid values are Email and Paper. |
| String | Email address of the customer bill-to contact who receives printed transactions. | |
| AllowCompletion | String | Indicates whether the transaction is reviewed and can be allowed to complete. Valid value to allow completion is 'Y'. |
| ControlCompletionReason | String | Reason that determines transaction completion. |
ReceivablesInvoicesattachments
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
ReceivablesInvoicesnotes
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| NoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| SourceObjectCode | String | This is the source object code for the source object as defined in OBJECTS Metadata. |
| SourceObjectId | String | The unique identifier of the parent source object associated to the note. |
| PartyName | String | The name of the party. |
| NoteTxt | String | The column which stores the actual note text. |
| NoteTypeCode | String | The note type code for categorization of note. |
| VisibilityCode | String | The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private. |
| CreatorPartyId | String | The unique identifier of the party. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| PartyId | String | The unique identifier of the party. |
| CorpCurrencyCode | String | The corporate currency code for extensibility. |
| CurcyConvRateType | String | The currency conversion rate type for extensibility. |
| CurrencyCode | String | The currency code for extensibility. |
| ContactRelationshipId | String | The relationship ID populated when the note is associated with a contact. |
| ParentNoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdatedBy | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdateLogin | String | The login of the user who last updated the record. |
| EmailAddress | String | The email address of the user who created the note. |
| FormattedAddress | String | The address of the user who created the note. |
| FormattedPhoneNumber | String | The phone number of the user who created the note. |
| UpdateFlag | Bool | Indicates whether the user can update the note. |
| DeleteFlag | Bool | Indicates whether the user has access to delete the note. |
| NoteNumber | String | The alternate unique identifier of the note. A user key that is system generated or from an external system. |
| NoteTitle | String | The title of the note entered by the user. |
ReceivablesInvoicesreceivablesInvoiceDFF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| CustomerTrxId | String | CustomerTrxId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceDistributions
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| DistributionId | String | The unique identifier of the invoice distribution. |
| InvoiceLineNumber | String | The number of the invoice line associated with the distribution. |
| DetailedTaxLineNumber | String | The number of the tax line of an invoice line associated with the distribution. |
| AccountClass | String | The account class of the distribution. Valid values are Revenue, Receivable, Freight, and Tax. |
| AccountCombination | String | The account code combination for the distribution. |
| Amount | String | The amount of the distribution in the invoice currency. |
| AccountedAmount | String | The amount of the distribution in the ledger currency. |
| Percent | String | The percentage of the line amount mapped to this distribution. |
| Comments | String | The user-defined comments about the distribution. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdateDate | Datetime | The date and time the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
ReceivablesInvoicesreceivablesInvoiceDistributionsreceivablesInvoiceDistributionDFF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicedistributionsDistributionId | String | ReceivablesinvoicedistributionsDistributionId |
| CustTrxLineGlDistId | String | CustTrxLineGlDistId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceGdf
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| CustomerTrxId | String | CustomerTrxId |
| ExcludeFromNetting | String | ExcludeFromNetting |
| DeliveryDateforTaxPointDate | Date | DeliveryDateforTaxPointDate |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceInstallments
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| InstallmentId | String | The unique identifier for installment. |
| InstallmentSequenceNumber | String | The sequence number of an installment. |
| InstallmentDueDate | Date | The due date of the installment. |
| OriginalAmount | String | The original due amount of the installment. |
| PaymentDaysLate | Long | Number of days since the due date of the installment. |
| InstallmentBalanceDue | String | The amount due on the installment. |
| InstallmentStatus | String | The status of the installment. |
| DisputeAmount | String | The amount in dispute on the installment. |
| DisputeDate | Date | The date a dispute was recorded against the installment. |
| InstallmentClosedDate | Date | The actual date when the payment schedule was closed. |
| InstallmentGLClosedDate | Date | The accounting date when the payment schedule was closed. |
| AccountedBalanceDue | String | The amount due on the installment in ledger currency. |
| InstallmentAmountAdjusted | String | The amount that was adjusted on the installment. |
| InstallmentAmountCredited | String | The amount that was credited on the installment. |
| AmountPaid | String | The amount that was paid on the installment. |
| PendingAdjustmentAmount | String | The adjustment amount that is pending approval. |
| InstallmentLineAmountOriginal | String | The original transaction line amount of the installment. |
| InstallmentLineAmountDue | String | The transaction line amount due on the installment. |
| InstallmentFreightAmountOriginal | String | The original freight amount of the installment. |
| InstallmentFreightAmountDue | String | The freight amount due on the installment. |
| InstallmentTaxAmountOriginal | String | The original tax amount of the installment. |
| InstallmentTaxAmountDue | String | The tax amount due on the installment. |
| CreationDate | Datetime | The date and time the record was created. |
| CreatedBy | String | The user who created the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| ExcludeFromCollections | String | Flag that determines if the installment is dummy or not. |
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentGDF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoiceinstallmentsInstallmentId | String | ReceivablesinvoiceinstallmentsInstallmentId |
| PaymentScheduleId | String | PaymentScheduleId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceInstallmentsreceivablesInvoiceInstallmentNotes
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoiceinstallmentsInstallmentId | String | ReceivablesinvoiceinstallmentsInstallmentId |
| NoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| SourceObjectCode | String | This is the source object code for the source object as defined in OBJECTS Metadata. |
| SourceObjectId | String | The unique identifier of the parent source object associated to the note. |
| PartyName | String | The name of the party. |
| NoteTxt | String | The column which stores the actual note text. |
| NoteTypeCode | String | The note type code for categorization of note. |
| VisibilityCode | String | The attribute to specify the visibility level of the note. It indicates whether the note is internal, external, or private. |
| CreatorPartyId | String | The unique identifier of the party. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| PartyId | String | The unique identifier of the party. |
| CorpCurrencyCode | String | The corporate currency code for extensibility. |
| CurcyConvRateType | String | The currency conversion rate type for extensibility. |
| CurrencyCode | String | The currency code for extensibility. |
| ContactRelationshipId | String | The relationship ID populated when the note is associated with a contact. |
| ParentNoteId | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdatedBy | String | The unique identifier of the note. This is the primary key of the notes table. |
| LastUpdateLogin | String | The login of the user who last updated the record. |
| EmailAddress | String | The email address of the user who created the note. |
| FormattedAddress | String | The address of the user who created the note. |
| FormattedPhoneNumber | String | The phone number of the user who created the note. |
| UpdateFlag | Bool | Indicates whether the user can update the note. |
| DeleteFlag | Bool | Indicates whether the user has access to delete the note. |
| NoteNumber | String | The alternate unique identifier of the note. A user key that is system generated or from an external system. |
| NoteTitle | String | The title of the note entered by the user. |
ReceivablesInvoicesreceivablesInvoiceLines
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| CustomerTransactionLineId | String | The line resource is used to identify each of the separate lines of a transaction. |
| LineNumber | String | The line number of the invoice. |
| Description | String | The description that identifies the product or service on the invoice line. |
| Quantity | String | The quantity of products or services referred to on the invoice line. |
| UnitSellingPrice | String | The price of an individual item on the invoice line. |
| TaxClassificationCode | String | The tax classification code for the invoice line. |
| SalesOrder | String | The sales order number on the invoice line. |
| AccountingRuleDuration | String | The number of periods in which revenue is to be recognized. A value is required for invoice lines with fixed and variable duration rules. |
| RuleEndDate | Date | The end date of the revenue scheduling rule. This is applicable for invoices with rules. |
| RuleStartDate | Date | The start date of the revenue scheduling rule. This is applicable for invoices with rules. |
| AccountingRule | String | The rule representing the revenue recognition method to be applied to the invoice line. |
| Warehouse | String | The ship-from location for the item on the invoice line. This value applies to inventory items. |
| MemoLine | String | The memo line that identifies the product or service on the invoice line. |
| UnitOfMeasure | String | The unit of measure used for the product or service on the invoice line. |
| ItemNumber | String | The number that identifies the inventory item on the invoice line. |
| AllocatedFreightAmount | String | The freight amount applicable for the Invoice lines. |
| AssessableValue | String | The assessable value tax determinant. |
| SalesOrderDate | Date | The sales order date. |
| LineAmount | String | The transaction line amount. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| TransacationBusinessCategory | String | The transaction business category tax determinant. |
| UserDefinedFiscalClassification | String | The user defined fiscal classification tax determinant. |
| ProductFiscalClassification | String | The product fiscal classification tax determinant. |
| ProductCategory | String | The product category tax determinant. |
| ProductType | String | The product type tax determinant. |
| LineIntendedUse | String | The transaction line intended use tax determinant. |
| LineAmountIncludesTax | String | The flag that indicates whether the tax is inclusive, exclusive or should calculate based on the tax setup. |
| TaxInvoiceDate | Date | The date the tax invoice document is generated. |
| TaxInvoiceNumber | String | A unique identifier of the fiscal document supporting the sale, which is generated upon shipment of goods. |
| TaxExemptionCertificateNumber | String | Document that certifies that a party or product is partially or fully exempt from a tax. |
| TaxExemptionHandling | String | Value that indicates how to process tax exemptions on invoice lines. |
| TaxExemptionReason | String | Reason that a customer has a tax exemption. |
ReceivablesInvoicesreceivablesInvoiceLinesattachments
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicelinesCustomerTransactionLineId | String | ReceivablesinvoicelinesCustomerTransactionLineId |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineDFF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicelinesCustomerTransactionLineId | String | ReceivablesinvoicelinesCustomerTransactionLineId |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineGdf
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicelinesCustomerTransactionLineId | String | ReceivablesinvoicelinesCustomerTransactionLineId |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTaxLines
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicelinesCustomerTransactionLineId | String | ReceivablesinvoicelinesCustomerTransactionLineId |
| CustomerTransactionLineId | String | The line resource is used to identify each of the separate tax lines of a transaction line. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date and time the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date on which the record is last updated. |
| TaxJurisdictionCode | String | The tax jurisdiction code assigned to the invoice line tax line. |
| TaxRate | String | The tax rate assigned to the invoice line tax line. |
| TaxRateCode | String | The tax rate code assigned to the invoice line tax line. |
| TaxRegimeCode | String | The tax regime code assigned to the invoice line tax line. |
| TaxStatusCode | String | The tax status code assigned to the invoice line tax line. |
| Tax | String | The code of the tax assigned to the invoice line tax line. |
| TaxAmount | String | The tax amount on the invoice line tax line in the entered currency. |
| TaxableAmount | String | The amount on the invoice line eligible for taxation. The tax rate is applied to the taxable amount. |
| TaxPointBasis | String | The transaction event that is the basis for tax on the invoice line tax line. |
| TaxPointDate | Date | The date on which the taxpayer becomes liable for paying the tax to the tax authority. Valid values are delivery date, invoice date, and pickup date. |
| TaxLineNumber | Long | The line number of the tax line of the invoice line. |
| PlaceOfSupply | Long | The location where the transaction is determined to take place for the tax on the invoice line. |
| TaxInclusiveIndicator | String | Option that indicates whether the invoice line amount is inclusive of tax. |
ReceivablesInvoicesreceivablesInvoiceLinesreceivablesInvoiceLineTransactionDFF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| ReceivablesinvoicelinesCustomerTransactionLineId | String | ReceivablesinvoicelinesCustomerTransactionLineId |
| CustomerTrxLineId | String | CustomerTrxLineId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
ReceivablesInvoicesreceivablesInvoiceTransactionDFF
| Name | Type | Description |
| ReceivablesInvoicesCustomerTransactionId | String | ReceivablesInvoicesCustomerTransactionId |
| CustomerTrxId | String | CustomerTrxId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
SalespersonReferenceAccounts
| Name | Type | Description |
| SalespersonId [KEY] | String | The unique identifier of the salesperson. |
| SalespersonNumber | String | The number that identifies the salesperson. The salesperson number is part of the unique set that identifies a reference account. |
| SalespersonName | String | The name of the salesperson. The salesperson name is part of the unique set that identifies a reference account. |
| SalespersonSet | String | The reference set assigned to the salesperson during salesperson creation to support data partitioning. |
| SalespersonStatus | String | The status of the salesperson. Valid values are Active and Inactive. |
| SalespersonStartDate | Date | The date when the salesperson is hired. |
| SalespersonEndDate | Date | The date when the salesperson is terminated. |
| BusinessUnit | String | A unit of an enterprise that performs one or more business functions that can be rolled up in a management hierarchy. The business unit is part of the unique set that identifies a reference account. |
| Ledger | String | A ledger at the business unit level which holds all the accounting information details. |
| ReceivablesAccountCombination | String | The accounting flexfield combination for the Receivables account. |
| FreightAccountCombination | String | The accounting flexfield combination for the Freight account. |
| RevenueAccountCombination | String | The accounting flexfield combination for the Revenue account. |
| CreationDate | Datetime | The date when the record was created. |
| CreatedBy | String | The user who created the record. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
StandardReceipts
| Name | Type | Description |
| StandardReceiptId [KEY] | String | The unique identifier of the standard receipt. |
| ReceiptNumber | String | The receipt number of the standard receipt. |
| BusinessUnit | String | A unit of an enterprise that performs one or more business functions that can be accumulated in a management hierarchy. |
| ReceiptMethod | String | The receipt method used on the standard receipt. |
| ReceiptDate | Date | The date when the standard receipt was created. |
| DocumentNumber | String | The document sequence number on the standard receipt. |
| Amount | String | The amount of a standard receipt. |
| Currency | String | The currency of a standard receipt. |
| ConversionRateType | String | The conversion rate type of a standard receipt. |
| ConversionDate | Date | The date when the standard receipt was converted. |
| ConversionRate | String | The conversion rate between the standard receipt currency and the ledger currency. |
| State | String | The state of the current payment entry progress in the standard receipt. The valid values are APPLIED, UNAPPLIED, UNIDENTIFIED, INSUFFICIENT FUNDS, REVERSE PAYMENT, and STOP PAYMENT. |
| Status | String | The status of the entered payment. The valid values are CONFIRMED, CLEARED, APPROVED, and REMITTED. |
| RemittanceBankName | String | The remittance bank name on the standard receipt. |
| RemittanceBankBranch | String | The remittance bank branch name on the standard receipt. |
| RemittanceBankAccountNumber | String | The remittance bank account number on the standard receipt. |
| RemittanceBankDepositDate | Date | The date when the standard receipt was deposited. |
| RemittanceBankAllowOverride | String | The options that allow the remittance selection process to override the remittance account on a standard receipt. |
| CustomerName | String | The name of the customer on the standard receipt. |
| TaxpayerIdentificationNumber | String | The tax payer identification number of the customer on the standard receipt. |
| CustomerSite | String | The customer site of the customer on the standard receipt. |
| CustomerAccountNumber | String | The customer account number of the customer on the standard receipt. |
| CustomerBank | String | The bank name of the customer on the standard receipt. |
| CustomerBankBranch | String | The bank branch name of the customer on the standard receipt. |
| CustomerBankAccountNumber | String | The bank account number of the customer on the standard receipt. |
| UnappliedAmount | String | The receipt amount that is unapplied to any transaction in the receipt currency. |
| AccountedAmount | String | The receipt amount in the functional currency. |
| AccountingDate | Date | The date when the standard receipt is accounted. |
| MaturityDate | Date | The date when the standard receipt is matured. |
| PostmarkDate | Date | The date when the standard receipt is postmarked. |
| ReceiptAtRisk | String | Identifies whether the receipt is currently at risk with the remittance bank. |
| ReceivablesSpecialist | String | The Receivables specialist assigned to the standard receipt. |
| Comments | String | The comments about this receipt. |
| CreditCardTokenNumber | String | The token number issued by tokenization service provider corresponding to a credit card number. |
| CreditCardAuthorizationRequestIdentifier | String | The authorization request identifier received from the tokenization service provider to authorize the credit card number. |
| CardHolderFirstName | String | The first name of the credit card holder. |
| CardHolderLastName | String | The last name of the credit card holder. |
| CreditCardIssuerCode | String | The code for the credit card issuer, such as Visa or MasterCard. |
| CreditCardExpirationDate | String | The date when the credit card expires. |
| VoiceAuthorizationCode | String | The voice authorization code received from tokenization service provider for authorization. |
| ReversalCategory | String | ReversalCategory |
| ReversalReason | String | ReversalReason |
| ReversalDate | Date | ReversalDate |
| ReversalComments | String | ReversalComments |
| ReceiptBatchName | String | ReceiptBatchName |
| ReceiptBatchDate | Date | ReceiptBatchDate |
| StructuredPaymentReference | String | An industry standard reference on Receivables transactions composed of letters, check digits, and transaction information, used to identify the transaction and its payments to the customer and bank. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
StandardReceiptsattachments
| Name | Type | Description |
| StandardReceiptsStandardReceiptId | String | StandardReceiptsStandardReceiptId |
| AttachedDocumentId | String | The unique identifier of the attached document. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| DatatypeCode | String | A value that indicates the data type. |
| FileName | String | The file name of the attachment. |
| DmFolderPath | String | The folder path from which the attachment is created. |
| DmDocumentId | String | The document ID from which the attachment is created. |
| DmVersionNumber | String | The document version number from which the attachment is created. |
| Url | String | The URL of a web page type attachment. |
| CategoryName | String | The category of the attachment. |
| UserName | String | The login credentials of the user who created the attachment. |
| Uri | String | The URI of a Topology Manager type attachment. |
| FileUrl | String | The URI of the file. |
| UploadedText | String | The text content for a new text attachment. |
| UploadedFileContentType | String | The content type of the attachment. |
| UploadedFileLength | String | The size of the attachment file. |
| UploadedFileName | String | The name to assign to a new attachment file. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared |
| Title | String | The title of the attachment. |
| Description | String | The description of the attachment. |
| ErrorStatusCode | String | The error code, if any, for the attachment. |
| ErrorStatusMessage | String | The error message, if any, for the attachment. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| FileContents | String | The contents of the attachment. |
| ExpirationDate | Datetime | The expiration date of the contents in the attachment. |
| LastUpdatedByUserName | String | The user name who last updated the record. |
| CreatedByUserName | String | The user name who created the record. |
| AsyncTrackerId | String | Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files. |
| FileWebImage | String | The base64 encoded image of the file displayed in .png format if the source is a convertible image. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
StandardReceiptsremittanceReferences
| Name | Type | Description |
| StandardReceiptsStandardReceiptId | String | StandardReceiptsStandardReceiptId |
| RemittanceReferenceId | String | The unique identifier of the remittance reference of the standard receipt. |
| ReceiptMatchBy | String | The document type used to match the standard receipt to a transaction. |
| ReferenceNumber | String | The unique identifier of the selected document type. |
| ReferenceAmount | String | The receipt application amount. |
| CreatedBy | String | The user who created the record. |
| CreationDate | Datetime | The date when the record was created. |
| LastUpdatedBy | String | The user who last updated the record. |
| LastUpdateDate | Datetime | The date when the record was last updated. |
| CustomerReason | String | Customer reason for Channel Revenue Management deductions and overpayments associated with an application. |
| CustomerReference | String | Reference supplied by the customer for a Channel Revenue Management claim. |
StandardReceiptsstandardReceiptDFF
| Name | Type | Description |
| StandardReceiptsStandardReceiptId | String | StandardReceiptsStandardReceiptId |
| CashReceiptId | String | CashReceiptId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
StandardReceiptsstandardReceiptGdf
| Name | Type | Description |
| StandardReceiptsStandardReceiptId | String | StandardReceiptsStandardReceiptId |
| CashReceiptId | String | CashReceiptId |
| _FLEX_Context | String | __FLEX_Context |
| _FLEX_Context_DisplayValue | String | __FLEX_Context_DisplayValue |
TaxAuthorityProfiles
| Name | Type | Description |
| PartyTaxProfileId [KEY] | String | PartyTaxProfileId |
| PartyTypeCode | String | PartyTypeCode |
| AuthorityType | String | AuthorityType |
| PartyName | String | PartyName |
TaxClassifications
| Name | Type | Description |
| LookupType | String | LookupType |
| LookupCode | String | LookupCode |
| Meaning | String | Meaning |
| StartDateActive | Date | StartDateActive |
| EndDateActive | Date | EndDateActive |
| SetId | String | SetId |
TaxExemptions
| Name | Type | Description |
| PartyTypeCode | String | PartyTypeCode |
| PartyName | String | PartyName |
| PartyNumber | String | PartyNumber |
| PartySiteNumber | String | PartySiteNumber |
| PartyType | String | PartyType |
| ExemptionUsageCode | String | ExemptionUsageCode |
| TaxRegimeCode | String | TaxRegimeCode |
| ContentOwner | String | ContentOwner |
| Tax | String | Tax |
| TaxStatusCode | String | TaxStatusCode |
| TaxRateCode | String | TaxRateCode |
| TaxJurisdictionCode | String | TaxJurisdictionCode |
| ItemNumber | String | ItemNumber |
| Organization | String | Organization |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| ExemptCertificateNumber | String | ExemptCertificateNumber |
| RecordingDate | Date | RecordingDate |
| IssueDate | Date | IssueDate |
| ExemptionTypeCode | String | ExemptionTypeCode |
| RateModifier | String | RateModifier |
| ExemptionStatusCode | String | ExemptionStatusCode |
| IssuingTaxAuthority | String | IssuingTaxAuthority |
| ApplyToLowerLevelsFlag | Bool | ApplyToLowerLevelsFlag |
| SuspendFromDate | Date | SuspendFromDate |
| SuspendToDate | Date | SuspendToDate |
| LimitAmount | String | LimitAmount |
| ExemptReasonCode | String | ExemptReasonCode |
| ClauseReference | String | ClauseReference |
| IssueFlag | Bool | IssueFlag |
| PartyTypeFlag | Bool | PartyTypeFlag |
| PrintFlag | Bool | PrintFlag |
| PartyUsage | String | PartyUsage |
| Country | String | Country |
| ContentOwnerId | String | ContentOwnerId |
| CustomerAccountId | String | CustomerAccountId |
| CustomChargeFlag | Bool | CustomChargeFlag |
| DetFactorTemplCode | String | DetFactorTemplCode |
| InventoryOrgId | String | InventoryOrgId |
| IssuingTaxAuthorityId | String | IssuingTaxAuthorityId |
| PartyTaxProfileId | String | PartyTaxProfileId |
| ProductId | String | ProductId |
| RecordTypeCode | String | RecordTypeCode |
| SiteUseId | String | SiteUseId |
| TaxJurisdictionId | String | TaxJurisdictionId |
| TaxExemptionId [KEY] | String | TaxExemptionId |
| ReportingTypeId | String | ReportingTypeId |
| ReportingCodeId | String | ReportingCodeId |
| ReportingTypeName | String | ReportingTypeName |
| ReportingCodeName | String | ReportingCodeName |
| ReportingCodeChar | String | ReportingCodeChar |
| PartyTaxAllowOffsetTaxFlag | Bool | PartyTaxAllowOffsetTaxFlag |
| PartyTaxRoundingLevelCode | String | PartyTaxRoundingLevelCode |
| PartyTaxInclusiveTaxFlag | Bool | PartyTaxInclusiveTaxFlag |
| PartyTaxClassificationCode | String | PartyTaxClassificationCode |
| PartyTaxRoundingRuleCode | String | PartyTaxRoundingRuleCode |
| PartyTaxProcessForApplicabilityFlag | Bool | PartyTaxProcessForApplicabilityFlag |
TaxIntendedUsesLOV
| Name | Type | Description |
| CategoryId | String | CategoryId |
| Name | String | Name |
| Code | String | Code |
| CountryCode | String | CountryCode |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| ClassificationId [KEY] | String | ClassificationId |
| CategoryName | String | CategoryName |
TaxPayerIdentifiers
| Name | Type | Description |
| PartyTypeCode | String | PartyTypeCode |
| PartyName | String | PartyName |
| PartyNumber | String | PartyNumber |
| PartySiteNumber | String | PartySiteNumber |
| ValidationType | String | ValidationType |
| TaxPayerNumber | String | TaxPayerNumber |
| ValidationDigit | String | ValidationDigit |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| ReportingTypeCode | String | ReportingTypeCode |
| CountryCode | String | CountryCode |
| ValidationLevel | String | ValidationLevel |
| UniquenessValidationLevel | String | UniquenessValidationLevel |
| RegistrationTypeCode | String | RegistrationTypeCode |
| CountryName | String | CountryName |
| EntityId | String | EntityId |
| PartyTaxpayerIdntfsId [KEY] | String | PartyTaxpayerIdntfsId |
| TaxpayerCountry | String | TaxpayerCountry |
| PartyTaxAllowOffsetTaxFlag | Bool | PartyTaxAllowOffsetTaxFlag |
| PartyTaxRoundingLevelCode | String | PartyTaxRoundingLevelCode |
| PartyTaxInclusiveTaxFlag | Bool | PartyTaxInclusiveTaxFlag |
| PartyTaxClassificationCode | String | PartyTaxClassificationCode |
| PartyTaxRoundingRuleCode | String | PartyTaxRoundingRuleCode |
| PartyTaxProcessForApplicabilityFlag | Bool | PartyTaxProcessForApplicabilityFlag |
TaxRegistrations
| Name | Type | Description |
| PartyTypeCode | String | PartyTypeCode |
| PartyName | String | PartyName |
| PartyNumber | String | PartyNumber |
| PartySiteNumber | String | PartySiteNumber |
| TaxRegimeCode | String | TaxRegimeCode |
| Tax | String | Tax |
| TaxJurisdictionCode | String | TaxJurisdictionCode |
| TaxPointBasis | String | TaxPointBasis |
| RegistrationTypeCode | String | RegistrationTypeCode |
| RegistrationStatusCode | String | RegistrationStatusCode |
| RepresentativePartyTaxName | String | RepresentativePartyTaxName |
| RegistrationReasonCode | String | RegistrationReasonCode |
| EffectiveFrom | Date | EffectiveFrom |
| EffectiveTo | Date | EffectiveTo |
| LegalRegistrationAddress | String | LegalRegistrationAddress |
| ValidationType | String | ValidationType |
| ValidationLevel | String | ValidationLevel |
| ValidationRule | String | ValidationRule |
| RegistrationNumber | String | RegistrationNumber |
| RegistrationSourceCode | String | RegistrationSourceCode |
| IssuingTaxAuthority | String | IssuingTaxAuthority |
| DefaultRegistrationFlag | Bool | DefaultRegistrationFlag |
| RoundingRuleCode | String | RoundingRuleCode |
| InclusiveTaxFlag | Bool | InclusiveTaxFlag |
| BankAccountNumber | String | BankAccountNumber |
| TaxClassificationCode | String | TaxClassificationCode |
| UniquenessValidationLevel | String | UniquenessValidationLevel |
| Country | String | Country |
| PartyCountryCode | String | PartyCountryCode |
| BankBranchId | String | BankBranchId |
| BankId | String | BankId |
| CollTaxAuthorityId | String | CollTaxAuthorityId |
| LegalLocationId | String | LegalLocationId |
| PartyTaxProfileId | String | PartyTaxProfileId |
| RoundingLevelCode | String | RoundingLevelCode |
| TaxAuthorityId | String | TaxAuthorityId |
| RegistrationId [KEY] | String | RegistrationId |
| PartyTaxAllowOffsetTaxFlag | Bool | PartyTaxAllowOffsetTaxFlag |
| PartyTaxRoundingLevelCode | String | PartyTaxRoundingLevelCode |
| PartyTaxInclusiveTaxFlag | Bool | PartyTaxInclusiveTaxFlag |
| PartyTaxClassificationCode | String | PartyTaxClassificationCode |
| PartyTaxRoundingRuleCode | String | PartyTaxRoundingRuleCode |
| PartyTaxProcessForApplicabilityFlag | Bool | PartyTaxProcessForApplicabilityFlag |
| CountryCode | String | CountryCode |
ThirdPartyFiscalClassifications
| Name | Type | Description |
| CodeAssignmentId [KEY] | String | The unique identifier of the association between the third party and the fiscal classification. |
| PartyNumber | String | The identifying number of the third party. |
| ClassTypeCode | String | The fiscal classification type code. |
| ClassCode | String | The fiscal classification code. |
| StartDateActive | Date | The effective start date for the association between the third party and the fiscal classification. |
| EndDateActive | Date | The effective end date for the association between the third party and the fiscal classification. |
| PartyName | String | The name of the third party. |
ThirdPartySiteFiscalClassifications
| Name | Type | Description |
| CodeAssignmentId [KEY] | String | The unique identifier of the association between the third-party site and the fiscal classification. |
| ClassTypeCode | String | The fiscal classification type code. |
| ClassCode | String | The fiscal classification code. |
| StartDateActive | Date | The effective start date for the association between the third-party site and the fiscal classification. |
| EndDateActive | Date | The effective end date for the association between the third-party site and the fiscal classification. |
| PartySiteNumber | String | The identifying number of the third-party site. |
| PartyNumber | String | The identifying number of the third party. |
| PartyName | String | The name of the third party. |
| PartySiteName | String | The name of the third-party site. |
ThirdPartySiteTaxReportingCodeAssociations
| Name | Type | Description |
| ReportingCodeAssocId [KEY] | String | The unique identifier of the association between the third-party site and the reporting code. |
| PartyNumber | String | The identifying number of the third party. |
| PartySiteNumber | String | The identifying number of the third-party site. |
| TaxReportingTypeCode | String | The reporting type code. |
| ReportingCodeCharValue | String | Alphanumeric value of the reporting code. |
| ReportingCodeDateValue | Date | Date value of the reporting code. |
| ReportingCodeNumericValue | String | Numeric value of the reporting code. |
| EffectiveFrom | Date | The effective start date for the association between the third-party site and the reporting code. |
| EffectiveTo | Date | The effective end date for the association between the third-party site and the reporting code. |
| PartyName | String | The name of the third party. |
| PartySiteName | String | The name of the third-party site. |
| PartyTaxProfileId | String | The unique identifier of the party site tax profile. |
ThirdPartyTaxReportingCodeAssociations
| Name | Type | Description |
| ReportingCodeAssocId [KEY] | String | The unique identifier of the association of the third party and the reporting code. |
| PartyNumber | String | The identifying number of the third party. |
| TaxReportingTypeCode | String | The reporting type code. |
| ReportingCodeCharValue | String | Alphanumeric value of the reporting code. |
| ReportingCodeDateValue | Date | Date value of the reporting code. |
| ReportingCodeNumericValue | String | Numeric value of the reporting code. |
| EffectiveFrom | Date | The effective start date for the association of the third party and the reporting code. |
| EffectiveTo | Date | The effective end date for the association of the third party and the reporting code. |
| PartyName | String | The name of the third party. |
| PartyTaxProfileId | String | The unique identifier of the party tax profile. |
TransactionSourcesLOV
| Name | Type | Description |
| TransactionSourceId [KEY] | String | The unique identifier of the transaction source. |
| Description | String | Transaction source description. |
| Name | String | Transaction source name. |
| SetName | String | Name of the reference data set value used within the context of transaction setups that are retrived through various reference resources. |
TransactionTaxLines
| Name | Type | Description |
| TaxLineId [KEY] | String | TaxLineId |
| TrxId | String | TrxId |
| TrxLineId | String | TrxLineId |
| TrxLineNumber | String | TrxLineNumber |
| TaxLineNumber | Long | TaxLineNumber |
| TaxRateName | String | TaxRateName |
| TaxRateId | String | TaxRateId |
| TaxRateCode | String | TaxRateCode |
| TaxRate | String | TaxRate |
| TaxAmount | String | TaxAmount |
| TaxableAmount | String | TaxableAmount |
| UnroundedTaxAmount | String | UnroundedTaxAmount |
| UnroundedTaxableAmount | String | UnroundedTaxableAmount |
| Cancelled | String | Cancelled |
| TaxAmountIncluded | String | TaxAmountIncluded |
| SelfAssessed | String | SelfAssessed |
| TaxOnlyLine | String | TaxOnlyLine |
| TaxRegimeCode | String | TaxRegimeCode |
| TaxRegimeId | String | TaxRegimeId |
| Tax | String | Tax |
| TaxId | String | TaxId |
| TaxJurisdictionCode | String | TaxJurisdictionCode |
| TaxJurisdictionId | String | TaxJurisdictionId |
| TaxStatusCode | String | TaxStatusCode |
| TaxStatusId | String | TaxStatusId |
| WhtTaxClassificationCode | String | WhtTaxClassificationCode |
| ExemptCertificateNumber | String | ExemptCertificateNumber |
| TaxPointBasis | String | TaxPointBasis |
| TaxPointDate | Date | TaxPointDate |
| PlaceOfSupplyTypeCode | String | PlaceOfSupplyTypeCode |
| TrxLevelType | String | TrxLevelType |
| InternalOrganizationId | String | InternalOrganizationId |
| ApplicationId | String | ApplicationId |
| EntityCode | String | EntityCode |
| EventClassCode | String | EventClassCode |
| WhtGroupId | String | WhtGroupId |
| TrxNumber | String | TrxNumber |
| TaxJurisdictionName | String | TaxJurisdictionName |
| TaxRegimeName | String | TaxRegimeName |
| TaxStatusName | String | TaxStatusName |
| SummaryTaxLineId | String | SummaryTaxLineId |
| LineAmount | String | LineAmount |
| TaxDetermineDate | Date | TaxDetermineDate |
| TaxDate | Date | TaxDate |
| TaxRateType | String | TaxRateType |
| ContentOwnerId | String | ContentOwnerId |
TransactionTypesLOV
| Name | Type | Description |
| TransactionTypeId [KEY] | String | The unique identifier of the transaction type. |
| Name | String | Transaction type name. |
| Description | String | Transaction type description. |
| SetName | String | Name of the reference data set value used within the context of transaction setups that are retrived through various reference resources. |
WithholdingTaxGroupsLOV
| Name | Type | Description |
| GroupId [KEY] | String | GroupId |
| Name | String | Name |
| Description | String | Description |
| EffectiveTo | Date | EffectiveTo |
| EffectiveFrom | Date | EffectiveFrom |
WithholdingTaxLines
| Name | Type | Description |
| TaxLineId [KEY] | String | TaxLineId |
| TrxId | String | TrxId |
| TrxLineId | String | TrxLineId |
| TrxLineNumber | String | TrxLineNumber |
| TaxLineNumber | String | TaxLineNumber |
| TaxRateName | String | TaxRateName |
| TaxRateCode | String | TaxRateCode |
| TaxRateId | String | TaxRateId |
| TaxRate | String | TaxRate |
| UnroundedTaxAmount | String | UnroundedTaxAmount |
| TaxAmount | String | TaxAmount |
| Cancelled | String | Cancelled |
| CalculationPoint | String | CalculationPoint |
| TaxRegimeCode | String | TaxRegimeCode |
| TaxRegimeId | String | TaxRegimeId |
| Tax | String | Tax |
| TaxId | String | TaxId |
| TaxStatusCode | String | TaxStatusCode |
| TaxStatusId | String | TaxStatusId |
| TaxJurisdictionCode | String | TaxJurisdictionCode |
| TaxJurisdictionId | String | TaxJurisdictionId |
| TrxLevelType | String | TrxLevelType |
| InternalOrganizationId | String | InternalOrganizationId |
| ApplicationId | String | ApplicationId |
| EntityCode | String | EntityCode |
| EventClassCode | String | EventClassCode |
| TaxApportionmentLineNumber | String | TaxApportionmentLineNumber |
| TaxJurisdictionName | String | TaxJurisdictionName |
| TaxRegimeName | String | TaxRegimeName |
| TaxStatusName | String | TaxStatusName |
| SummaryTaxLineId | String | SummaryTaxLineId |
WorkflowUsers
| Name | Type | Description |
| Username | String | Name of the workflow user. |
| FirstName | String | First name of a workflow user. |
| LastName | String | Last name of a workflow user. |
| EmailAddress | String | Email address of a workflow user. |
| ManagerName | String | Name of the manager of the workflow user. |
| WorkflowName | String | Name of the workflow. |
| TransactionIdentifier | String | Unique identifier of a transaction associated with the workflow user. |
| LoggedInUser | String | Identifier of the currently active user. |
| PersonId [KEY] | String | Unique identifier of a person. |
The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.
For more information on establishing a connection, see Establishing a Connection.
| Property | Description |
| URL | The Url of the account to connect to. |
| User | The Oracle Financials Cloud user account used to authenticate. |
| Password | The password used to authenticate the user. |
| Property | Description |
| SSLServerCert | The certificate to be accepted from the server when connecting using TLS/SSL. |
| Property | Description |
| FirewallType | The protocol used by a proxy-based firewall. |
| FirewallServer | The name or IP address of a proxy-based firewall. |
| FirewallPort | The TCP port for a proxy-based firewall. |
| FirewallUser | The user name to use to authenticate with a proxy-based firewall. |
| FirewallPassword | A password used to authenticate to a proxy-based firewall. |
| Property | Description |
| ProxyAutoDetect | This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings. |
| ProxyServer | The hostname or IP address of a proxy to route HTTP traffic through. |
| ProxyPort | The TCP port the ProxyServer proxy is running on. |
| ProxyAuthScheme | The authentication type to use to authenticate to the ProxyServer proxy. |
| ProxyUser | A user name to be used to authenticate to the ProxyServer proxy. |
| ProxyPassword | A password to be used to authenticate to the ProxyServer proxy. |
| ProxySSLType | The SSL type to use when connecting to the ProxyServer proxy. |
| ProxyExceptions | A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer . |
| Property | Description |
| LogModules | Core modules to be included in the log file. |
| Property | Description |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
| BrowsableSchemas | This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC. |
| Tables | This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. |
| Views | Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. |
| Property | Description |
| APIVersion | The API Version of Oracle Financials Cloud that the user wants to use. |
| IncludeCustomChildObjects | Property to include Custom Child Objects. |
| IncludeCustomObjects | Property to include Custom Objects. |
| MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
| Other | These hidden properties are used only in specific use cases. |
| PseudoColumns | This property indicates whether or not to include pseudo columns as columns to the table. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |
This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.
| Property | Description |
| URL | The Url of the account to connect to. |
| User | The Oracle Financials Cloud user account used to authenticate. |
| Password | The password used to authenticate the user. |
The Url of the account to connect to.
The Oracle Financials Cloud URL. Typically, the URL of your Oracle Cloud service. For example, https://servername.fa.us2.oraclecloud.com.
The Oracle Financials Cloud user account used to authenticate.
Together with Password, this field is used to authenticate against the Oracle Financials Cloud server.
The password used to authenticate the user.
The User and Password are together used to authenticate with the server.
This section provides a complete list of the SSL properties you can configure in the connection string for this provider.
| Property | Description |
| SSLServerCert | The certificate to be accepted from the server when connecting using TLS/SSL. |
The certificate to be accepted from the server when connecting using TLS/SSL.
If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.
This property can take the following forms:
| Description | Example |
| A full PEM Certificate (example shortened for brevity) | -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE----- |
| A path to a local file containing the certificate | C:\cert.cer |
| The public key (example shortened for brevity) | -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY----- |
| The MD5 Thumbprint (hex values can also be either space or colon separated) | ecadbdda5a1529c58a1e9e09828d70e4 |
| The SHA1 Thumbprint (hex values can also be either space or colon separated) | 34a929226ae0819f2ec14b4a3d904f801cbb150d |
If not specified, any certificate trusted by the machine is accepted.
Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.
This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.
| Property | Description |
| FirewallType | The protocol used by a proxy-based firewall. |
| FirewallServer | The name or IP address of a proxy-based firewall. |
| FirewallPort | The TCP port for a proxy-based firewall. |
| FirewallUser | The user name to use to authenticate with a proxy-based firewall. |
| FirewallPassword | A password used to authenticate to a proxy-based firewall. |
The protocol used by a proxy-based firewall.
This property specifies the protocol that the Sync App will use to tunnel traffic through the FirewallServer proxy. Note that by default, the Sync App connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.
| Type | Default Port | Description |
| TUNNEL | 80 | When this is set, the Sync App opens a connection to Oracle Financials Cloud and traffic flows back and forth through the proxy. |
| SOCKS4 | 1080 | When this is set, the Sync App sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted. |
| SOCKS5 | 1080 | When this is set, the Sync App sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes. |
To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.
The name or IP address of a proxy-based firewall.
This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.
Note that the Sync App uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.
The TCP port for a proxy-based firewall.
This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.
The user name to use to authenticate with a proxy-based firewall.
The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.
A password used to authenticate to a proxy-based firewall.
This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.
This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.
| Property | Description |
| ProxyAutoDetect | This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings. |
| ProxyServer | The hostname or IP address of a proxy to route HTTP traffic through. |
| ProxyPort | The TCP port the ProxyServer proxy is running on. |
| ProxyAuthScheme | The authentication type to use to authenticate to the ProxyServer proxy. |
| ProxyUser | A user name to be used to authenticate to the ProxyServer proxy. |
| ProxyPassword | A password to be used to authenticate to the ProxyServer proxy. |
| ProxySSLType | The SSL type to use when connecting to the ProxyServer proxy. |
| ProxyExceptions | A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer . |
This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.
The hostname or IP address of a proxy to route HTTP traffic through.
The hostname or IP address of a proxy to route HTTP traffic through. The Sync App can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.
If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.
By default, the Sync App uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.
The TCP port the ProxyServer proxy is running on.
The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.
The authentication type to use to authenticate to the ProxyServer proxy.
This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.
Note that the Sync App will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.
The authentication type can be one of the following:
If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.
A user name to be used to authenticate to the ProxyServer proxy.
The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.
You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:
user@domain domain\user
A password to be used to authenticate to the ProxyServer proxy.
This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.
If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.
If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.
For SOCKS 5 authentication or tunneling, see FirewallType.
By default, the Sync App uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.
The SSL type to use when connecting to the ProxyServer proxy.
This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:
| AUTO | Default setting. If the URL is an HTTPS URL, the Sync App will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option. |
| ALWAYS | The connection is always SSL enabled. |
| NEVER | The connection is not SSL enabled. |
| TUNNEL | The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy. |
A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .
The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.
Note that the Sync App uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.
This section provides a complete list of the Logging properties you can configure in the connection string for this provider.
| Property | Description |
| LogModules | Core modules to be included in the log file. |
Core modules to be included in the log file.
Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.
See the Logging page for an overview.
This section provides a complete list of the Schema properties you can configure in the connection string for this provider.
| Property | Description |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
| BrowsableSchemas | This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC. |
| Tables | This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. |
| Views | Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. |
A path to the directory that contains the schema files defining tables, views, and stored procedures.
The path to a directory which contains the schema files for the Sync App (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.
Note: Given that this Sync App supports multiple schemas, the structure for Oracle Financials Cloud custom schema files is as follows:
If left unspecified, the default location is "%APPDATA%\\CData\\OracleERP Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:
This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.
This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the Sync App.
This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.
Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.
Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.
Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the Sync App.
This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.
Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.
Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| APIVersion | The API Version of Oracle Financials Cloud that the user wants to use. |
| IncludeCustomChildObjects | Property to include Custom Child Objects. |
| IncludeCustomObjects | Property to include Custom Objects. |
| MaxRows | Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time. |
| Other | These hidden properties are used only in specific use cases. |
| PseudoColumns | This property indicates whether or not to include pseudo columns as columns to the table. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UserDefinedViews | A filepath pointing to the JSON configuration file containing your custom views. |
The API Version of Oracle Financials Cloud that the user wants to use.
The API Version of Oracle Financials Cloud that the user wants to use.
Property to include Custom Child Objects.
Property to include Custom Child Objects.
Property to include Custom Objects.
Property to include Custom Objects.
Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
These hidden properties are used only in specific use cases.
The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.
Specify multiple properties in a semicolon-separated list.
| DefaultColumnSize | Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000. |
| ConvertDateTimeToGMT | Determines whether to convert date-time values to GMT, instead of the local time of the machine. |
| RecordToFile=filename | Records the underlying socket data transfer to the specified file. |
This property indicates whether or not to include pseudo columns as columns to the table.
This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".
The value in seconds until the timeout error is thrown, canceling the operation.
If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.
If Timeout expires and the operation is not yet complete, the Sync App throws an exception.
A filepath pointing to the JSON configuration file containing your custom views.
User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The Sync App automatically detects the views specified in this file.
You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the Sync App.
This User Defined View configuration file is formatted as follows:
For example:
{
"MyView": {
"query": "SELECT * FROM Invoices WHERE MyColumn = 'value'"
},
"MyView2": {
"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
}
}
Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:
"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"