CData Sync App は、Oracle Financials Cloud データをデータベース、データレイク、またはデータウェアハウスに継続的にパイプライン化する簡単な方法を提供し、分析、レポート、AI、および機械学習で簡単に利用できるようにします。
Oracle Financials Cloud コネクタはCData Sync アプリケーションから使用可能で、Oracle Financials Cloud からデータを取得して、サポートされている任意の同期先に移動できます。
Sync App アプリケーションの接続 ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Oracle Financials Cloud への接続を作成します。Oracle Financials Cloud アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからOracle Financials Cloud コネクタをダウンロードおよびインストールします。
必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。
Oracle Financials Cloud への認証には、以下を設定する必要があります。
このセクションでは、利用可能なAPI オブジェクトを示し、Oracle Financials Cloud API へのSQL の実行について詳しく説明します。
ストアドプロシージャ は、Oracle Financials Cloud のファンクションライクなインターフェースです。これらを使用して、Oracle Financials Cloud 内の情報を変更できます。
Oracle Financials Cloud で、ファインダーはコレクションリソースの検索に使用されるフィルタです。各ファインダーには、いくつかのパラメータが割り当てられます。
親ビューにファインダーフィルタを使用するには、ファインダー擬似カラムにFinderName を指定し、ファインダーパラメータカラムに値を指定する必要があります。
SELECT * FROM JournalBatches WHERE finder = 'JournalsFinder' AND JournalCategory = 'test';
子ビューにファインダーフィルタを使用するには、ファインダー擬似カラムに親ビューのFinderName を指定し、親ビューのファインダーパラメータカラムに値を指定する必要があります。
SELECT * FROM InvoicesinvoiceLinesinvoiceDistributions WHERE finder = 'PrimaryKey' AND InvoiceId = 5484;
ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。
ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。
ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。
| 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. |
| プロパティ | 説明 |
| URL | 接続するアカウントのURL。 |
| User | 認証で使用されるOracle Financials Cloud ユーザーアカウント。 |
| Password | ユーザーの認証で使用されるパスワード。 |
| プロパティ | 説明 |
| SSLServerCert | TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。 |
| プロパティ | 説明 |
| FirewallType | プロキシベースのファイアウォールで使われるプロトコル。 |
| FirewallServer | プロキシベースのファイアウォールの名前もしくはIP アドレス。 |
| FirewallPort | プロキシベースのファイアウォールのTCP ポート。 |
| FirewallUser | プロキシベースのファイアウォールに認証するために使うユーザー名。 |
| FirewallPassword | プロキシベースのファイアウォールへの認証に使われるパスワード。 |
| プロパティ | 説明 |
| ProxyAutoDetect | これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。 |
| ProxyServer | HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。 |
| ProxyPort | ProxyServer プロキシが起動しているTCP ポート。 |
| ProxyAuthScheme | ProxyServer プロキシへの認証で使われる認証タイプ。 |
| ProxyUser | ProxyServer プロキシへの認証に使われるユーザー名。 |
| ProxyPassword | ProxyServer プロキシへの認証に使われるパスワード。 |
| ProxySSLType | ProxyServer プロキシへの接続時に使用するSSL タイプ。 |
| ProxyExceptions | ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。 |
| プロパティ | 説明 |
| LogModules | ログファイルに含めるコアモジュール。 |
| プロパティ | 説明 |
| Location | テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。 |
| BrowsableSchemas | このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。 |
| Tables | このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。 |
| Views | 使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。 |
| プロパティ | 説明 |
| APIVersion | ユーザーが使用したいOracle Financials Cloud のAPI バージョン。 |
| IncludeCustomChildObjects | カスタム子オブジェクトを含めるためのプロパティ。 |
| IncludeCustomObjects | カスタム・オブジェクトを含めるためのプロパティ。 |
| MaxRows | クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。 |
| Other | これらの隠しプロパティは特定のユースケースでのみ使用されます。 |
| PseudoColumns | このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。 |
| Timeout | タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。 |
| UserDefinedViews | カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。 |
接続するアカウントのURL。
Oracle Financials Cloud URL。通常はOracle Cloud サービスのURL です。例：https://servername.fa.us2.oraclecloud.com。
認証で使用されるOracle Financials Cloud ユーザーアカウント。
このフィールドは、Password とともに、Oracle Financials Cloud サーバーに対して認証をするために使われます。
このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。
| プロパティ | 説明 |
| SSLServerCert | TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。 |
TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。
TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。
このプロパティは、次のフォームを取ります：
| 説明 | 例 |
| フルPEM 証明書（例では省略されています） | -----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE----- |
| 証明書を保有するローカルファイルへのパス。 | C:\cert.cer |
| 公開鍵（例では省略されています） | -----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY----- |
| MD5 Thumbprint （hex 値はスペースおよびコロン区切り） | ecadbdda5a1529c58a1e9e09828d70e4 |
| SHA1 Thumbprint （hex 値はスペースおよびコロン区切り） | 34a929226ae0819f2ec14b4a3d904f801cbb150d |
これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。
すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。
このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。
| プロパティ | 説明 |
| FirewallType | プロキシベースのファイアウォールで使われるプロトコル。 |
| FirewallServer | プロキシベースのファイアウォールの名前もしくはIP アドレス。 |
| FirewallPort | プロキシベースのファイアウォールのTCP ポート。 |
| FirewallUser | プロキシベースのファイアウォールに認証するために使うユーザー名。 |
| FirewallPassword | プロキシベースのファイアウォールへの認証に使われるパスワード。 |
プロキシベースのファイアウォールで使われるプロトコル。
このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。
| タイプ | デフォルトポート | 説明 |
| TUNNEL | 80 | これが設定されている場合、Sync App はOracle Financials Cloud への接続を開き、プロキシを経由して通信が行われます。 |
| SOCKS4 | 1080 | これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。 |
| SOCKS5 | 1080 | これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。 |
HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。
プロキシベースのファイアウォールの名前もしくはIP アドレス。
ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。
Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。
プロキシベースのファイアウォールのTCP ポート。
ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。
プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。
プロキシベースのファイアウォールへの認証に使われるパスワード。
このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。
このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。
| プロパティ | 説明 |
| ProxyAutoDetect | これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。 |
| ProxyServer | HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。 |
| ProxyPort | ProxyServer プロキシが起動しているTCP ポート。 |
| ProxyAuthScheme | ProxyServer プロキシへの認証で使われる認証タイプ。 |
| ProxyUser | ProxyServer プロキシへの認証に使われるユーザー名。 |
| ProxyPassword | ProxyServer プロキシへの認証に使われるパスワード。 |
| ProxySSLType | ProxyServer プロキシへの接続時に使用するSSL タイプ。 |
| ProxyExceptions | ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。 |
これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。
HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。
SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。
デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。
ProxyServer プロキシが起動しているTCP ポート。
HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。
ProxyServer プロキシへの認証で使われる認証タイプ。
この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。
Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。
認証タイプは、次のどれかになります。
SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。
ProxyServer プロキシへの認証に使われるユーザー名。
ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。
ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。
user@domain domain\user
ProxyServer プロキシへの認証に使われるパスワード。
このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。
HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。
NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。
SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。
デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。
ProxyServer プロキシへの接続時に使用するSSL タイプ。
このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。
| AUTO | デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。 |
| ALWAYS | 接続は、常にSSL 有効となります。 |
| NEVER | 接続は、SSL 有効になりません。 |
| TUNNEL | 接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。 |
ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。
ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。
Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。
ログファイルに含めるコアモジュール。
指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。
概要はログ ページを参照してください。
このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。
| プロパティ | 説明 |
| Location | テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。 |
| BrowsableSchemas | このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。 |
| Tables | このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。 |
| Views | 使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。 |
テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
Sync App のスキーマファイル（テーブルとビューの場合は.rsd ファイル、ストアドプロシージャの場合は.rsb ファイル）を含むディレクトリへのパス。このフォルダの場所は、実行ファイルの場所からの相対パスにすることができます。Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。
Note： このSync App は複数のスキーマをサポートするため、Oracle Financials Cloud カスタムスキーマファイルの構造は以下のようになります。
指定しない場合、デフォルトの場所は"%APPDATA%\\CData\\OracleERP Data Provider\\Schema" となり、%APPDATA% はユーザーのコンフィギュレーションディレクトリに設定されます：
このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、 パフォーマンスが向上します。
このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
テーブルを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でテーブルのリストを提供すると、Sync App のパフォーマンスが向上します。
このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。
カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。 例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。
複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。
使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。
ビューを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でビューのリストを提供すると、Sync App のパフォーマンスが向上します。
このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。
カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。 例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。
複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。
このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。
| プロパティ | 説明 |
| APIVersion | ユーザーが使用したいOracle Financials Cloud のAPI バージョン。 |
| IncludeCustomChildObjects | カスタム子オブジェクトを含めるためのプロパティ。 |
| IncludeCustomObjects | カスタム・オブジェクトを含めるためのプロパティ。 |
| MaxRows | クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。 |
| Other | これらの隠しプロパティは特定のユースケースでのみ使用されます。 |
| PseudoColumns | このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。 |
| Timeout | タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。 |
| UserDefinedViews | カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。 |
ユーザーが使用したいOracle Financials Cloud のAPI バージョン。
ユーザーが使用したいOracle Financials Cloud のAPI バージョン。
カスタム子オブジェクトを含めるためのプロパティ。
カスタム子オブジェクトを含めるためのプロパティ。
カスタム・オブジェクトを含めるためのプロパティ。
カスタム・オブジェクトを含めるためのプロパティ。
クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
これらの隠しプロパティは特定のユースケースでのみ使用されます。
以下にリストされているプロパティは、特定のユースケースで使用可能です。通常のドライバーのユースケースおよび機能では、これらのプロパティは必要ありません。
複数のプロパティをセミコロン区切りリストで指定します。
| DefaultColumnSize | データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。 |
| ConvertDateTimeToGMT | 日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。 |
| RecordToFile=filename | 基底のソケットデータ転送を指定のファイルに記録します。 |
このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Entity Framework ではテーブルカラムでない疑似カラムに値を設定できないため、この設定はEntity Framework で特に便利です。この接続設定の値は、"Table1=Column1, Table1=Column2, Table2=Column3" の形式です。"*=*" のように"*" 文字を使用して、すべてのテーブルとすべてのカラムを含めることができます。
タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。
Timeout の有効期限が切れても処理が完了していない場合は、Sync App は例外をスローします。
カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。
ユーザー定義ビューは、UserDefinedViews.json というJSON 形式のコンフィギュレーションファイルで定義されています。Sync App は、このファイルで指定されたビューを自動的に検出します。
また、複数のビュー定義を持ち、UserDefinedViews 接続プロパティを使用して制御することも可能です。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。
このユーザー定義ビューのコンフィギュレーションファイルは、次のようにフォーマットされています。
次に例を示します。
{
"MyView": {
"query": "SELECT * FROM Invoices WHERE MyColumn = 'value'"
},
"MyView2": {
"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
}
}
UserDefinedViews 接続プロパティを使用して、JSON コンフィギュレーションファイルの場所を指定します。次に例を示します。
"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"