DEEP DIVE: What's new in D365 Finance & Supply Chain Management

About

Welcome to the comprehensive comparison between versions 10.0.44 and 10.0.45. This page highlights the key updates introduced in the new release, providing insights into the changes made to the database schema. You'll find detailed information about newly added tables, fields introduced to existing tables, as well as tables with modified fields or labels. Additionally, we have outlined tables where the row count has been adjusted. Our goal is to make it easy for you to track changes and stay informed about the improvements made in this version update. For more detailed information, please refer to the sidebar where you can explore specific sections.

Removed tables

ProdAgentInsight (Insights)

Name	Label	Type	Length
ApplicableObjectId	Applicable object id	String	50
ApplicableSubObjectId	Applicable sub object id	String	10
ApplicableType	Applicable Type	Enum
createdDateTime	Created date and time	Date time
InsightType	Insight type	Enum
InventDimId	Dimension number	String	20
ItemId	Item number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ProdAgentInsightMetric (Insight merics)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Insight	Insight	RecId
MetricName	Metric name	Enum
MetricValue	Metric value	Real
Occurrences	NumberOfObservation	Integer
OutliersMaxValue	Outliers maximum value	Integer
OutliersMinValue	Outliers minimum value	Integer
ProdAgentInsight	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ProdAgentRouteAnalyticMetric (Route analytics)

Name	Label	Type	Length
AverageValue	Average value	Real
createdDateTime	Created date and time	Date time
InventDimId	Dimension number	String	20
ItemId	Item number	String	20
MaxValue	Maximum value	Real
MedianValue	Median value	Real
MetricName	Metric name	Enum
MinValue	Minimum value	Real
Occurrences	NumberOfObservation	Integer
OperationId	Operation	String	10
OperationNum	Oper. No.	Integer
OprNumNext	Next	Integer
OutliersMaxValue	Outliers maximum value	Integer
OutliersMinValue	Outliers minimum value	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResourceId	Item/Resource	String	30
RouteId	RouteId	String	20

New tables

AccountingDistributionJournalize (AccountingDistributionJournalize)

Name	Label	Type	Length
AccountEntryEventRole	Account entry role	Enum
AccountingCurrency	Currency	String	3
AccountingCurrencyAmount	Amount	Real
AccountingCurrencyAmountUnrounded	Amount	Real
AccountingDate	Accounting date	Date
AccountingDistribution	accounting distribution	RecId
AccountingEvent	Reference	RecId
AmountSign	AmountSign	Enum
BondBatchTrans_RU	Correspondence link	Big integer
DueFromLedgerDimension	Ledger account	RecId
DueToLedgerDimension	Ledger account	RecId
ExchangeRate1	Exchange rate	Real
ExchangeRate2	Exchange rate	Real
ExchangeRateDate	Accounting date	Date
FinalizeAccountingEvent	Reference	RecId
FiscalCalendarPeriod	Reference	RecId
HistoricalExchangeRateDate	Historical exchange rate date	Date
InterCompanyPostingType	Posting type	Enum
IsCorrection	IsCorrection	Enum
IsExchangeRateVariance	IsExchangeRateVariance	Enum
IsFinalizing	IsFinalizing	Enum
IsIntercompany	IsIntercompany	Enum
IsRelieving	IsRelieving	Enum
IsYearEnd	IsYearEnd	Enum
Ledger	Ledger	RecId
LedgerDimension	Ledger account	RecId
LedgerDimensionDefaultAccount	Main account	RecId
LedgerName	Ledger name	String	20
LegalEntity	Legal entity	RecId
NegativeAccountingCurrencyAmount	Amount	Real
NegativeAmountSign	NegativeAmountSign	Enum
NegativeReportingCurrencyAmount	Amount in reporting currency	Real
NegativeTransactionCurrencyAmount	Amount	Real
Offset	Offset	Enum
ParentDistribution	Reference	RecId
PostingType	Posting type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceRole	Reference role	Enum
RelievingSubledgerJournalEntryType	Subledger journal entry type	Enum
ReportingCurrency	Currency	String	3
ReportingCurrencyAmount	Amount in reporting currency	Real
ReportingCurrencyAmountUnrounded	Amount	Real
ReportingExchangeRate1	Exchange rate	Real
ReportingExchangeRate2	Exchange rate	Real
RoundingLevel	Rounding amount	Enum
SourceDocLineAccountingCurrencyAmount	Amount	Real
SourceDocLineLegalEntity	Legal entity	RecId
SourceDocLineNegAccountingCurrencyAmount	Amount	Real
SourceDocLineNegReportingCurrencyAmount	Amount in reporting currency	Real
SourceDocLineReportingCurrencyAmount	Amount in reporting currency	Real
SourceDocumentHeader	Reference	RecId
SourceDocumentLine	Source document line	RecId
SubledgerJournalEntryType	Subledger journal entry type	Enum
TransactionCurrency	Currency	String	3
TransactionCurrencyAmount	Amount	Real
TransactionText	Description	String	512
TransactionTextLabelId	Label ID	String	120
TransferPolicy	Transfer policy	Enum
YearEndReversalSubledgerJournalEntryType	Subledger journal entry type	Enum

AssetBookHistorical_JPStaging (Fixed asset book historical)

Name	Label	Type	Length
AcceleratedDepreciationLastRunDate	Date when depreciation was last run	Date
AcceleratedDepreciationProfileId	Accelerated depreciation profile	String	10
AcquisitionDate	Acquisition date	Date
AcquisitionMethodDescription	Acquisition method description	String	60
AcquisitionMethodId	Acquisition method	String	20
AcquisitionPrice	Acquisition price	Real
AcquisitionPriceReportingCurrency	Acquisition price in reporting currency	Real
AllowableLimitForAccumulatedDepreciation	Allowable limit for accumulated depreciation	Enum
AllowDepreciationWhenPlacedInServiceAndDisposalAreInTheSameFiscalYear	Allow depreciation when placed in service and disposal are in the same fiscal year	Enum
AllowNegativeNetBookValue	Allow negative net book value	Enum
AllowNetBookValueHigherThanAcquisitionCosts	Allow net book value higher than acquisition costs	Enum
AlternativeDepreciationProfileId	Alternative depreciation profile	String	10
BookId	Book	String	10
CalculateDepreciation	Calculate depreciation	Enum
ConsumptionEstimated	Estimated consumption	Real
ConsumptionFactorId	Consumption factor	String	10
ConsumptionUnitDepreciation	Unit depreciation price	Real
ConsumptionUnitDepreciationReportingCurrency	Unit depreciation price in reporting currency	Real
ConsumptionUnitId	Consumption unit	String	10
CreateDepreciationAdjustmentsWithBasisAdjustments	Create depreciation adjustments with basis adjustments	Enum
CustomerAccount	Customer account	String	20
CustomerInvoice	Customer invoice	String	20
DefinitionGroup	Processing group	String	60
DepreciationConvention	Depreciation convention	Enum
DepreciationGroupId_W	Depreciation group	String	10
DepreciationLastRunDate	Date when depreciation was last run	Date
DepreciationPeriods	Depreciation periods	Integer
DepreciationPeriodsRemaining	Depreciation periods remaining	Real
DepreciationProfileId	Depreciation profile	String	10
DepreciationRunDate	Depreciation run date	Date
DepreciationValidFrom	Effective	Date
DepreciationValidTo	Expiration	Date
DerogatoryCalculation	Derogatory calculation	String	10
DerogatoryTaxModel	Derogatory tax model	Enum
DimensionDisplayValue	Default dimension display value	String	500
DisposalDate	Disposal date	Date
EquallyDividedStartDate	Equally divided start date	Date
ExecutionId	Job ID	String	90
ExpectedScrapValue	Expected scrap value	Real
ExpectedScrapValueReportingCurrency	Expected scrap value in reporting currency	Real
ExtraordinaryDepreciationLastRunDate	Date when extraordinary depreciation was last run	Date
ExtraordinaryDepreciationProfileId	Extraordinary depreciation profile	String	10
FairValue	Fair value	Real
FixedAssetGroupId	Fixed asset group	String	10
FixedAssetNumber	Fixed asset number	String	20
IsAllowDepreciationAdjSameDate	Allow posting automatic adjustment.	Enum
IsAssetGroupDepreciation	Asset group depreciation	Enum
IsMigratedAsset	Migrated asset	Enum
IsPositiveDepreciation	Calculate positive depreciation	Enum
IsSelected	Select	Enum
LifeTime	Depreciation periods	Integer
LowValuePoolTransferDate	Date transferred to low value pool	Date
LowValuePoolTransferId	Transferred to low value pool	String	20
PlacedInService	Placed in service	Date
PostingProfileId	Posting profile	String	10
ProvisionType	Provision type	String	10
PurchaseOrder	Purchase order	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReducingBalanceCheckMaximumPercent	Check maximum percent	Enum
ReducingBalancePercentageAfterValidation	Percentage after validation	Real
ReducingBalanceStraightLineFactor	RB/SL factor	Real
ReductionEntryAllocationLastRunDate	Date when reduction entry allocation last run	Date
ReductionEntryAllocationStartDate	Reduction entry allocation start date	Date
ReplacementDate	Replacement date	Date
RevaluationGroupId	Revaluation group	String	10
RevisedAcquisitionCost	Revised acquisition cost	Real
RevisedAcquisitionCostStartDate	Revised acquisition cost date	Date
SalesValue	Sales value	Real
ServiceLife	Service life	Real
ServiceLifeMonths	Service life months	Integer
ServiceLifeYears	Service life years	Integer
ShortenedUsefulLife	Shortened useful life	Enum
SortField1Id	Sort field 1	String	10
SortField2Id	Sort field 2	String	10
SortField3Id	Sort field 3	String	10
SpecialDepreciationAllocationLastRunDate	Date when allocation was last run	Date
SpecialDepreciationAllocationPeriods	Allocation periods	Integer
SpecialDepreciationAllocationStartConvention	Allocation start convention	Enum
SpecialDepreciationAllocationUnit	Allocation unit	Enum
SpecialDepreciationRunDate	Extraordinary depreciation run date	Date
Status	Status	Enum
SummarizeByMajorType	Summarize by major type	Enum
TransferStatus	Staging to target status	Enum
VendorAccount	Vendor account	String	20
VendorInvoice	Vendor invoice	String	50

AssetBookHistory (Asset history)

Name	Label	Type	Length
AssetBookHistoryEventRecordType	Event record type	Enum
AssetBookHistoryEventType	Event type	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DestinationAsset	Destination asset	String	20
DestinationAssetBook	Destination book	String	10
DestinationCompany	Destination legal entity	String	4
OriginRefCompany	Company accounts ID	String	4
OriginRefRecId	Reference	RecId
OriginRefTableId	Reference table ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceAsset	Source asset	String	20
SourceAssetBook	Source book	String	10
SourceAssetBookHistory	Reference	RecId
SourceCompany	Source legal entity	String	4

AssetIntercompanyTransferCompanyMappingTable (Fixed assets intercompany transfer legal entity mapping table)

Name	Label	Type	Length
AllowBidirectionalLookup	Allow bidirectional mapping	Enum
DestinationCompany	Destination legal entity	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceCompany	Source legal entity	String	4

AssetIntercompanyTransferDestination (Fixed assets intercompany transfer destination)

Name	Label	Type	Length
Company	Destination legal entity	String	4
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Percent	Percent	Real
RateType	Rate type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ServiceLifeCaculationType	Service life	Enum
TransferSource	Reference	RecId

AssetIntercompanyTransferFieldMappingTable (Fixed assets intercompany transfer field mapping table)

Name	Label	Type	Length
AssetIntercompanyTransferMappingActionType	Mapping action	Enum
AssetTransferCompanyMappingTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefFieldName	Reference field name	String	81
RefFieldType	Field type	Enum
RefTableId	Reference table ID	Integer

AssetIntercompanyTransferFieldValueMappingTable (AssetIntercompanyTransferFieldValueMappingTable)

Name	Label	Type	Length
AssetIntercompanyTransferFieldMappingTable	Reference	RecId
DestinationDateTimeValue	Destination field value	Date time
DestinationDateValue	Destination field value	Date
DestinationEnumIntValue	DestinationEnumIntValue	Integer
DestinationIntValue	Destination field value	Integer
DestinationRealValue	Destination field value	Real
DestinationStringValue	Destination field value	String	150
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDateTimeValue	Source field value	Date time
SourceDateValue	Source field value	Date
SourceEnumIntValue	SourceEnumIntValue	Integer
SourceIntValue	Source field value	Integer
SourceRealValue	Source field value	Real
SourceStringValue	Source field value	String	150

AssetIntercompanyTransferJournalLine (Fixed assets intercompany transfer journal line)

Name	Label	Type	Length
AccountType	Account type	Enum
AmountCreditReportingCurrency	Credit in reporting currency	Real
AmountCurCredit	Credit	Real
AmountCurDebit	Debit	Real
AmountDebitReportingCurrency	Debit in reporting currency	Real
AssetId	Fixed asset number	String	20
AssetTransSubType	Transaction subtype	Enum
BookId	Book	String	10
Company	Company	String	4
CurrencyCode	Currency	String	3
CurrentOperationsTax	Posting layer	Enum
DefaultDimension	Dimension	RecId
ExchRate	Exchange rate	Real
ExchRateSecond	Secondary exchange rate	Real
FinTag	Financial tag	RecId
LedgerDimension	Account	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyCode	Reporting currency	String	3
ReportingCurrencyExchRate	Exchange rate	Real
ReportingCurrencyExchRateSecondary	Secondary exchange rate	Real
Source	Reference	RecId
TransDate	Date	Date
TransType	Transaction type	Enum
Txt	Description	String	512
VoucherGroup	Voucher group	Integer
Worksheet	Reference	RecId

AssetIntercompanyTransferJournalLineDerived (Fixed assets intercompany transfer journal line derived)

Name	Label	Type	Length
AmountCur	Amount in transaction currency	Real
AssetBookId	Book	String	10
JournalLine	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	Amount in reporting currency	Real

AssetIntercompanyTransferJournalLink (Asset intercompany transfer source journal link)

Name	Label	Type	Length
AssetIntercompanyTransferSource	Reference	RecId
JournalPosted	Posted	Enum
LedgerJournalTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

AssetIntercompanyTransferSource (Fixed assets intercompany transfer source)

Name	Label	Type	Length
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceCompany	Source legal entity	String	4
Status	Transfer status	Enum
TransferDate	Transfer date	Date
TransferId	Intercompany transfer ID	String	20
TransferMethod	Transfer method	Enum
TransferValueType	Transfer value method	Enum
WizardStep	WizardStep	Integer

AssetIntercompanyTransferSourceAsset (Fixed assets intercompany transfer source assets)

Name	Label	Type	Length
AssetGroup	Fixed asset group	String	10
AssetId	Fixed asset number	String	20
AssetName	Name	String	150
AssetType	Type	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferSource	Reference	RecId

AssetIntercompanyTransferWorksheet (AssetIntercompanyTransferWorksheet)

Name	Label	Type	Length
DestinationAssetGeneratedByTransfer	Destination asset generated by transfer	Enum
DestinationAssetGroup	Destination asset group	String	10
DestinationAssetId	Destination asset number	String	20
DestinationCompany	Destination legal entity	String	4
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Percent	Percent	Real
RateType	Rate type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ServiceLifeCaculationType	Service life	Enum
Source	Reference	RecId
SourceAssetGroup	Source asset group	String	10
SourceAssetId	Source asset number	String	20
SourceCompany	Source legal entity	String	4
TransferAmount	Transfer amount	Real
TransferDate	Transfer date	Date
TransferMethod	Transfer method	Enum
TransferValueType	Transfer value method	Enum
UseTransferAmount	Use transfer amount	Enum

AssetIntercompanyTransferWorksheetLine (AssetIntercompanyTransferWorksheetLine)

Name	Label	Type	Length
AcquisitionPrice	Acquisition price	Real
AssetIntercompanyTransferWorksheet	Reference	RecId
CurrentOperationsTax	Posting layer	Enum
Depreciation	Depreciation	Real
DestinationAssetBookId	Destination book	String	10
DestinationCompany	Destination legal entity	String	4
DestinationDefaultDimension	Destination default dimension	RecId
FinTag	Destination financial tag	RecId
NetBookValue	Net book value	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Source	Reference	RecId
SourceAssetBookId	Source book	String	10
SourceAssetId	Source asset number	String	20
TransferAcquisitionPrice	Acquisition transfer amount	Real
TransferAmountDepreciation	Depreciation transfer amount	Real
TransferNetBookValue	Net book transfer amount	Real
UseForSourceAssetValue	Use as source asset value	Enum

AssetLeaseLeaseImpairmentTable (Lease impairment table)

Name	Label	Type	Length
ApprovalStatus	Approval status	Enum
CurrencyCode	Currency	String	3
ImpairmentProposalId	Impairment proposal ID	String	20
ImpairmentStatus	Impairment status	Enum
LeaseGroup	Lease group	String	10
LeaseId	Lease ID	String	40
PostingDate	Posting date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer

AssetLeaseReadyForImpairmentBookSummary (Lease impairment lines)

Name	Label	Type	Length
CloseBook	Close book	Enum
ExchangeRate	Accounting currency exchange rate	Real
ExchangeRateReporting	Reporting currency exchange rate	Real
ImpairmentAmount	Impairment amount	Real
LeaseCounter	Version	Integer
LeaseId	Lease ID	String	40
LeaseImpaimentRecId	Reference	RecId
NewRightOfUseAssetAccountingBalance	New asset balance in accounting currency	Real
NewRightOfUseAssetReportingBalance	New asset balance in reporting currency	Real
NewRightOfUseAssetTransactionBalance	New asset balance in transaction currency	Real
PeriodRemaining	Period remaining	Integer
PreviousRightOfUseAssetAccountingBalance	Previous asset balance in accounting currency	Real
PreviousRightOfUseAssetReportingBalance	Previous asset balance in reporting currency	Real
PreviousRightOfUseAssetTransactionBalance	Previous asset balance in transaction currency	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Transaction date	Date

AssetProposalCompanySummary (Asset proposal company summary)

Name	Label	Type	Length
AmountCreditReportingCurrency	Credit in reporting currency	Real
AmountCurCredit	Credit	Real
AmountCurDebit	Debit	Real
AmountDebitReportingCurrency	Debit in reporting currency	Real
AssetCount	Number of fixed assets	Integer
AssetProposalHeader	Asset proposal header	RecId
Company	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer

AssetProposalDetail (Asset proposal detail)

Name	Label	Type	Length
AmountCreditReportingCurrency	Credit in reporting currency	Real
AmountCurCredit	Credit	Real
AmountCurDebit	Debit	Real
AmountDebitReportingCurrency	Debit in reporting currency	Real
AssetCount	Number of fixed assets	Integer
AssetGroup	Fixed asset group	String	10
AssetProposalHeader	Asset proposal header	RecId
BookId	Book	String	10
Company	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer

AssetProposalHeader (Asset proposal header)

Name	Label	Type	Length
AssetProposalType	Type	Enum
BatchJobId	Batch job ID	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
LastRefreshDateTime	Last refreshed on	Date time
Name	Name	String	200
PostedDateTime	Posted on	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalDuration	Duration	String	20

AssetProposalJournalLink (Asset proposal journal link)

Name	Label	Type	Length
AssetProposalHeader	Asset proposal header	RecId
BatchTaskId	Batch task Id	RecId
Company	Company	String	4
LedgerJournalTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

BusinessDocumentCustTransV2Staging (Business document customer transactions V2)

Name	Label	Type	Length
AccountNum	Customer account	String	20
AmountCur	Amount in transaction currency	Real
CustTransRecId	Record-ID	RecId
DataArea	Company	String	4
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
Invoice	Invoice	String	50
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date
TransferStatus	Staging to target status	Enum
TransType	Transaction type	Enum
TransTypeStr	String 50	String	50
Voucher	Voucher	String	20

BusinessDocumentServiceIdentificationLatestResult (BusinessDocumentServiceIdentificationLatestResult)

Name	Label	Type	Length
PackedJson	PackedJson	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefTableId	Reference table ID	Integer

CClassTribTable_BR (cClassTrib)

Name	Label	Type	Length
Code	cClassTrib	String	6
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CSTDescription	Description	String	255
CSTTable	CST code	RecId
Description	Description	Bin/Memo/Container
LCWriting	LC Writing	Bin/Memo/Container
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxBaseDeductionRate	Deduction rate	Real

CClassTribTable_BRStaging (cClassTrib)

Name	Label	Type	Length
Code	cClassTrib	String	6
CSTDescription	Description	String	255
CSTTable_BR_Code	CST code	String	3
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LCWriting	LC Writing	Bin/Memo/Container
ParentRowId	ParentRowId	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RowId	RowId	Integer
TaxBaseDeductionRate	Deduction rate	Real
TransferStatus	Staging to target status	Enum

CPBranchTableStaging (Bank branch table entity (TR))

Name	Label	Type	Length
BankGroupId	Bank groups	String	10
BranchCode	Branch code	String	20
BranchName	Bank branches	String	20
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

CPBranchTableTR (Bank branch name)

Name	Label	Type	Length
BankGroupId	Bank groups	String	10
BranchCode	Branch code	String	20
BranchName	Bank branches	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CPJournalStaging (Check journal entity (TR))

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
AverageMaturity	Average maturity	Date
BankTransType	Bank transaction type	String	10
ChequeJournalNum	Check payroll number	String	20
DefaultDimensionDisplayValue	Default dimension display value	String	500
DefinitionGroup	Processing group	String	60
Description	Description	String	60
ExecutionId	Job ID	String	90
FixedExchRate	Fixed exchange rate	Real
IsFixedExchRate	Activate fixed exchange rate	Enum
IsSelected	Select	Enum
JournalNum	Journal batch number	String	20
OffsetTransCode	Against transaction code	String	10
PaymId	Payment ID	String	200
PaymReference	Payment reference	String	35
PortfolioCode	Portfolio code	String	20
PortfolioDefaultDimensionDisplayValue	Portfolio dimension	String	500
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReverseDate	Reversal date	Date
ReverseJournalNum	Check payroll number	String	20
SessionId	Session ID	Integer
SessionLoginDateTime	Logon time	Date time
TransCode	Transaction code	String	10
TransDate	Date	Date
TransferStatus	Staging to target status	Enum

CPJournalTR (Check and promissory note journal)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
AverageMaturity	Average maturity	Date
BankTransType	Bank transaction type	String	10
ChequeJournalNum	Check payroll number	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DefaultDimension	Dimension	RecId
Description	Description	String	60
FixedExchangeRateTypeId	Fixed exchange rate type	RecId
FixedExchRate	Fixed exchange rate	Real
FixedReportingCurrencyExchRate	Exchange rate	Real
FixedReportingCurrencyExchRateTypeId	Exchange rate type	RecId
IsFixedExchRate	Activate fixed exchange rate	Enum
JournalNum	Journal batch number	String	20
modifiedBy	Modified by	String	20
OffsetTransCode	Against transaction code	String	10
PaymId	Payment ID	String	200
PaymReference	Payment reference	String	35
PortfolioCode	Portfolio code	String	20
PortfolioDefaultDimension	Portfolio dimension	RecId
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReverseDate	Reversal date	Date
ReverseJournalNum	Reversal journal number	String	20
SessionId	Session ID	Integer
SessionLoginDateTime	Logon time	Date time
TransCode	Transaction code	String	10
TransDate	Date	Date

CPParametersStaging (Check and promissory note parameters entity (TR))

Name	Label	Type	Length
BankDimensionName	Bank name	String	60
BankDimensionType	Dimension attribute type	Enum
ChequePrintedNumFldMandatoryForNotes	The Printed number field is mandatory for promissory notes received or given.	Enum
COADimensionName	COA dimension	String	60
COADimensionType	Dimension attribute type	Enum
ControlChequeOutDate	Control of out date for check	Enum
CustDimensionName	Customer name	String	60
CustDimensionType	Dimension attribute type	Enum
CustPaymMode	Customer method of payment	String	10
DefaultDimensionRediscountNotesPayableDisplayValue	Rediscount account dimension of notes payable	String	500
DefaultDimensionRediscountNotesReceivableDisplayValue	Rediscount account dimension of notes receivables	String	500
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InterestExpenseMainAccountMainAccountId	Main account	String	20
InterestIncomeMainAccountMainAccountId	Main account	String	20
IsReverseDate	Is reverse date	Enum
IsSelected	Select	Enum
JournalCancelActive	Cancel active journal	Enum
Key	ID	Integer
LedgerActType	Portfolio account type	Enum
LedgerChartOfAccountsInterestExpenseName	Interest expense account name	String	60
LedgerChartOfAccountsInterestIncomeName	Interest income account name	String	60
LedgerChartOfAccountsNotesPayableName	Notes payable account name	String	60
LedgerChartOfAccountsNotesReceivableName	Rediscount notes receivable account name	String	60
NotesPayableMainAccountMainAccountId	Main account	String	20
NotesReceivableMainAccountMainAccountId	Main account	String	20
PortfolioDimensionName	Dimension name	String	60
PortfolioDimensionType	Dimension attribute type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RediscountAutoPost	Automatic posting	Enum
RediscountDetailLevel	Detail level	Enum
RediscountExchangeRateType	Exchange rate type	String	20
RediscountInterestCalcType	Interest calculation type	Enum
RediscountJournalName	Journal name	String	10
SettledRule	Settlement status	Enum
TransferStatus	Staging to target status	Enum
UseDueDate	Use due date	Enum
VendDimensionName	Vendor name	String	60
VendDimensionType	Dimension attribute type	Enum
VendPaymMode	Vendor method of payment	String	10

CPParametersTR (Check and promissory note parameters)

Name	Label	Type	Length
BankDimension	Bank dimension	RecId
ChequePrintedNumFldMandatoryForNotes	The Printed number field is mandatory for promissory notes received or given.	Enum
COADimension	COA dimension	RecId
ControlChequeOutDate	Control of out date for check	Enum
CustDimension	Customer dimension	RecId
CustPaymMode	Customer method of payment	String	10
DefaultDimensionRediscountNotesPayable	Rediscount account dimension of notes payable	RecId
DefaultDimensionRediscountNotesReceivable	Rediscount account dimension of notes receivables	RecId
IsReverseDate	Is reverse date	Enum
JournalCancelActive	Cancel active journal	Enum
Key	ID	Integer
LedgerActType	Portfolio account type	Enum
PortfolioDimension	Portfolio dimension	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RediscountAutoPost	Automatic posting	Enum
RediscountDetailLevel	Detail level	Enum
RediscountExchangeRateType	Exchange rate type	String	20
RediscountInterestCalcType	Interest calculation type	Enum
RediscountInterestExpenseMainAccount	Rediscount interest expense account	RecId
RediscountInterestIncomeMainAccount	Rediscount interest income account	RecId
RediscountJournalName	Journal name	String	10
RediscountNotesPayableMainAccount	Rediscount account of notes payable	RecId
RediscountNotesReceivableMainAccount	Rediscount account of notes receivable	RecId
SettledRule	Settlement status	Enum
UseDueDate	Use due date	Enum
VendDimension	Vendor dimension	RecId
VendPaymMode	Vendor method of payment	String	10

CPPortfolioStaging (Check and promissory note portfolio codes)

Name	Label	Type	Length
AccountNum	Account number	String	20
BankAccountID	Bank account for collection	String	10
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LedgerACTType	Account type	Enum
Name	Portfolio name	String	60
PortfolioCode	Portfolio code	String	20
PortfolioType	Portfolio type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

CPPortfolioTR (Check and promissory note portfolio codes)

Name	Label	Type	Length
AccountNum	Account number	String	20
BankAccountID	Bank account for collection	String	10
CurrencyCode	Currency	String	3
LedgerACTType	Account type	Enum
Name	Portfolio name	String	60
PortfolioCode	Portfolio code	String	20
PortfolioType	Portfolio type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CPRediscountInterestRatesStaging (Check rediscount interest rates entity (TR))

Name	Label	Type	Length
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InterestPercent	Interest rate (%)	Real
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date
TransferStatus	Staging to target status	Enum

CPRediscountInterestRatesTR (Interest rates)

Name	Label	Type	Length
CurrencyCode	Currency	String	3
InterestPercent	Interest rate (%)	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date

CPRediscountLineStaging (Rediscount lines)

Name	Label	Type	Length
ChequeAmountCur	Amount in transaction currency	Real
ChequeCurrencyCode	Currency	String	3
ChequeDueDate	Check due date	Date
ChequeOwnCheque	Own check	Enum
ChequePortfolioCode	Portfolio code	String	20
ChequePortfolioType	Portfolio type	Enum
ChequePrintedNum	Check printing number	String	20
ChequeRediscountTableRecId	Rediscount table RecId	Big integer
ChequeTransCode	Transaction code	String	10
ChequeTransferCustAccount	Transferring customer	String	20
DefinitionGroup	Processing group	String	60
DueDayByReferanceDate	Due day by reference date	Integer
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RediscountAmountCur	Rediscount amount	Real
RediscountExchRate	Exchange rate	Real
SystemChequeNum	System number of check	String	20
TransferStatus	Staging to target status	Enum

CPRediscountLineTR (Rediscount lines)

Name	Label	Type	Length
ChequeAmountCur	Amount in transaction currency	Real
ChequeCurrencyCode	Currency	String	3
ChequeDueDate	Check due date	Date
ChequeOwnCheque	Own check	Enum
ChequePortfolioCode	Portfolio code	String	20
ChequePortfolioType	Portfolio type	Enum
ChequePrintedNum	Check printing number	String	20
ChequeRediscountTableRecId	Rediscount table RecId	Big integer
ChequeTransCode	Transaction code	String	10
ChequeTransferCustAccount	Transferring customer	String	20
DueDayByReferanceDate	Due day by reference date	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RediscountAmountCur	Rediscount amount	Real
RediscountExchRate	Exchange rate	Real
SystemChequeNum	System number of check	String	20

CPRediscountTableStaging (Rediscount)

Name	Label	Type	Length
CurrentPeriodJournal	Payroll number	String	20
CurrentPeriodReverseJournal	Reversal journal number	String	20
CurrentReferenceDate	Current reference date	Date
DefinitionGroup	Processing group	String	60
DetailLevel	Detail level	Enum
ExchRateType	Exchange rate type	String	20
ExecutionId	Job ID	String	90
InterestExpenseMainAccountMainAccountId	Main account	String	20
InterestIncomeMainAccountMainAccountId	Main account	String	20
IsSelected	Select	Enum
JournalName	Journal name	String	10
LedgerChartOfAccountsInterestExpenseName	Interest expense account name	String	60
LedgerChartOfAccountsInterestIncomeName	Interest income account name	String	60
LedgerChartOfAccountsNotesPayableName	Notes payable account name	String	60
LedgerChartOfAccountsNotesReceivableName	Chart of accounts	String	60
NextPeriodJournal	Journal number for next period	String	20
NextPeriodReverseJournal	Reversal journal number for next period	String	20
NextReferenceDate	Next reference date	Date
NotesPayableMainAccountMainAccountId	Main account	String	20
NotesReceivableMainAccountMainAccountId	Main account	String	20
Posted	Posted	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
VersionId	Version ID	String	10

CPRediscountTableTR (Rediscount)

Name	Label	Type	Length
CurrentPeriodJournal	Payroll number	String	20
CurrentPeriodReverseJournal	Reversal journal number	String	20
CurrentReferenceDate	Current reference date	Date
DetailLevel	Detail level	Enum
ExchRateType	Exchange rate type	String	20
InterestExpenseMainAccount	Rediscount interest expense account	RecId
InterestIncomeMainAccount	Rediscount interest income account	RecId
JournalName	Journal name	String	10
NextPeriodJournal	Journal number for next period	String	20
NextPeriodReverseJournal	Reversal journal number for next period	String	20
NextReferenceDate	Next reference date	Date
NotesPayableMainAccount	Rediscount account of notes payable	RecId
NotesReceivableMainAccount	Rediscount account of notes receivable	RecId
Posted	Posted	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VersionId	Version ID	String	10

CPTableStaging (Check table entity (TR))

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
Amount	Amount	Real
BankAccountID	Account identification	String	10
BankBranchName	Bank branches	String	20
BankGroupId	Bank groups	String	10
BranchCode	Branch code	String	20
Cancelled	Cancel	Enum
ChequeJournalNum	Check payroll number	String	20
ChequePrintedNum	Check printing number	String	20
ChequeTransactionNum	Check movement number	String	20
CurrencyCode	Currency	String	3
DebitCredit	Debit/Credit	Enum
DefinitionGroup	Processing group	String	60
DirPersonRecId	Name	RecId
Drawer	Drawer	String	50
DrawingDate	Date drawn	Date
DueDate	Check due date	Date
ExecutionId	Job ID	String	90
Guarantor	Guarantor	String	50
IsSelected	Select	Enum
OpeninJournal	Is in use	Enum
OwnCheque	Own check	Enum
PortfolioCode	Portfolio code	String	20
PortfolioType	Check type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SignedBy	Signed	String	50
SystemChequeNum	System number of check	String	20
TransCode	Transaction code	String	10
TransferCustAccount	Transferring customer	String	20
TransferExchRate	Exchange rate	Real
TransferStatus	Staging to target status	Enum

CPTableTR (Checks and promissory notes)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
Amount	Amount	Real
BankAccountID	Account identification	String	10
BankBranchName	Bank branches	String	20
BankGroupId	Bank groups	String	10
BranchCode	Branch code	String	20
Cancelled	Cancel	Enum
ChequeJournalNum	Check payroll number	String	20
ChequePrintedNum	Check printing number	String	20
ChequeTransactionNum	Check movement number	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
DebitCredit	Debit/Credit	Enum
Drawer	Drawer	String	50
DrawingDate	Date drawn	Date
DueDate	Check due date	Date
Guarantor	Guarantor	String	50
OpenInJournal	Is in use	Enum
OwnCheque	Own check	Enum
PortfolioCode	Portfolio code	String	20
PortfolioType	Check type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SignedBy	Signed	String	50
SystemChequeNum	System number of check	String	20
TransCode	Transaction code	String	10
TransferCustAccount	Transferring customer	String	20
TransferExchRate	Exchange rate	Real

CPTransCodeTableStaging (Check or promissory note transaction code)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
BadCheque	Bounce check	Enum
BankTransType	Bank transaction type	String	10
CustVendAutoSettleType	Matching type	Enum
CustVendAutoSpec	Auto settlement	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IncomingCheque	Receipt	Enum
isOffsetTransCode	Against transaction code	Enum
IsSelected	Select	Enum
JournalName	Journal name	String	10
Name	Transaction code description	String	60
NewCheque	New check	Enum
OffsetTransCode	Against transaction code	String	10
OutgoingCheque	Issue	Enum
PaymReceiving	Collection	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReturnedCheque	Return	Enum
TransCode	Transaction code	String	10
TransferStatus	Staging to target status	Enum

CPTransCodeTableTR (Check or promissory note transaction code)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
BadCheque	Bounce check	Enum
BankTransType	Bank transaction type	String	10
CustVendAutoSettleType	Matching type	Enum
CustVendAutoSpec	Auto settlement	Enum
IncomingCheque	Receipt	Enum
isOffsetTransCode	Against transaction code	Enum
JournalName	Journal name	String	10
Name	Transaction code description	String	60
NewCheque	New check	Enum
OffsetTransCode	Against transaction code	String	10
OutgoingCheque	Issue	Enum
PaymReceiving	Collection	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReturnedCheque	Return	Enum
TransCode	Transaction code	String	10

CPTransLinkTR (Check or promissory note transaction link)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer
RefTransRecId	Reference	RecId
SpecRecId	Reference	RecId

CPTransStaging (Check or promissory note transaction table entity (TR))

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
BankTransType	Bank transaction type	String	10
ChequeJournalNum	Check payroll number	String	20
ChequeJournalTransNum	Check movement number	String	20
DebitCredit	Debit/Credit	Enum
DefaultDimensionDisplayValue	Default dimension display value	String	500
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FixedExchangeRateTypeId	Fixed exchange rate type	RecId
FixedExchRate	Fixed exchange rate	Real
FixedReportingCurrencyExchRate	Exchange rate	Real
IsFixedExchRate	Activate fixed exchange rate	Enum
IsSelected	Select	Enum
JournalNum	Journal batch number	String	20
PaymId	Payment ID	String	200
PaymReference	Payment reference	String	35
PortfolioCode	Portfolio code	String	20
PortfolioDefaultDimensionDisplayValue	Portfolio dimension	String	500
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReverseChequeTransNum	Check reversal transaction number	String	20
SystemChequeNum	System number of check	String	20
TransCode	Transaction code	String	10
TransDate	Date	Date
TransferStatus	Staging to target status	Enum
Voucher	Voucher	String	20

CPTransTR (Check and promissory note journal transaction)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
BankTransType	Bank transaction type	String	10
ChequeJournalNum	Check payroll number	String	20
ChequeJournalTransNum	Check movement number	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustVendOpenRecId	Reference	RecId
DebitCredit	Debit/Credit	Enum
DefaultDimension	Dimension	RecId
FixedExchangeRateTypeId	Fixed exchange rate type	RecId
FixedExchRate	Fixed exchange rate	Real
FixedReportingCurrencyExchRate	Exchange rate	Real
FixedReportingCurrencyExchRateTypeId	Exchange rate type	RecId
IsFixedExchRate	Activate fixed exchange rate	Enum
JournalNum	Journal batch number	String	20
PaymId	Payment ID	String	200
PaymReference	Payment reference	String	35
PortfolioCode	Portfolio code	String	20
PortfolioDefaultDimension	Portfolio dimension	RecId
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReverseChequeTransNum	Check reversal transaction number	String	20
SystemChequeNum	System number of check	String	20
TransCode	Transaction code	String	10
TransDate	Date	Date
Voucher	Voucher	String	20

CSTTable_BR (CST)

Name	Label	Type	Length
Code	CST code	String	3
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	255
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CSTTable_BRStaging (CST)

Name	Label	Type	Length
Code	CST code	String	3
DefinitionGroup	Processing group	String	60
Description	Description	String	255
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ParentRowId	ParentRowId	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RowId	RowId	Integer
TransferStatus	Staging to target status	Enum

CustInvoiceLine_BR (Cust invoice line for Brazil)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CustInvoiceLine	Reference	RecId
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

CustInvoiceTable_BR (Cust invoice table for Brazil)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CustInvoiceTable	Reference	RecId
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

CustomerInvoiceDocumentLifecycleStageTransition (CustomerInvoiceDocumentLifecycleStageTransition table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustomerInvoiceBatchJobId	Batch job ID	RecId
CustomerInvoiceBatchTaskHistoryId	Reference	RecId
CustomerInvoiceDocumentHeaderRecId	Reference	RecId
CustomerInvoiceDocumentLifecycleStages	Customer Invoice Document Lifecycle stages	Enum
CustomerInvoiceDocumentLifecycleStatus	Customer Invoice Document Lifecycle status	Enum
CustomerInvoiceDocumentLifecycleTimestamp	Start date/time	Date time
CustomerInvoiceDocumentLineCount	CustomerInvoiceDocumentLineCount	Integer
CustomerInvoiceDocumentLineRecId	Reference	RecId
CustomerInvoiceDocumentParmId	Parameter ID	String	20
CustomerInvoiceDocumentSummaryUpdate	CustomerInvoiceDocumentSummaryUpdate	Enum
CustomerInvoiceDocumentType	Document type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UniqueGuid	UniqueGuid	Guid

CustomerInvoiceDocumentLifecycleStageTransitionLog (CustomerInvoiceDocumentLifecycleStageTransitionLog table)

Name	Label	Type	Length
CustomerInvoiceDocumentHeaderRecId	Reference	RecId
MessageLabelId	System language	String	7
MessageParameters	Blobdata	Bin/Memo/Container
MessageType	Document lifecycle log message type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UniqueGuid	UniqueGuid	Guid

FBSpedADCRBillCollectionCodeTable_BR (Bill collection code)

Name	Label	Type	Length
Code	Bill collection code	String	6
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinTagRuleV3Staging (Financial tag rule (CSV) V3 entity)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsEnabled	Enabled	Enum
IsSelected	Select	Enum
Name	Name	String	100
OverwriteExistingValue	Overwrite existing value	Enum
QualifiedPowerFxFormula	PowerFx formula	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TargetName	Financial tag name	String	60
TransactionEntryPointDocumentName	TransactionEntryPointDocumentName	String	150
TransactionLevel	Transaction level	Enum
TransferStatus	Staging to target status	Enum
Type	Financial tag rule type	Enum

FiscalDocumentSettledPayment_BR (Fiscal document journal lines)

Name	Label	Type	Length
AccountingAmount	Accounting amount	Real
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FiscalBookingPeriod	Booking period	RecId
FiscalDocument	Fiscal document	RecId
InvoiceAmount	Accounting amount	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaymentDate	Due date/Payment date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventInventoryDataServiceStatusCache (InventInventoryDataServiceStatusCache)

Name	Label	Type	Length
InventoryServiceAtpStatus	Status	Enum
InventoryServiceStatus	Status	Enum
Key	Key	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventTransferTable2LineParameters (Order line update parameters)

Name	Label	Type	Length
FieldId	Field ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Table2LineUpdate	Update	Enum

LedgerDimensionUsageCount (Ledger dimension usage count)

Name	Label	Type	Length
DimensionCount	Dimension usage count	Big integer
DimensionName	Dimension name	String	60
LedgerDimensionUsageCountCategory	Dimension usage category	Enum
LedgerDimensionUsageCountCheckHistory	Reference	RecId
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerDimensionUsageCountCheckHistory (Dimension usage count check history)

Name	Label	Type	Length
FiscalCalendarYear	Reference	RecId
IsEnabled	Enabled	Enum
LatestCreatedDateTime	Created date and time	Date time
Ledger	Ledger	RecId
modifiedDateTime	Modified date and time	Date time
ProcessDateTime	Process date/time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ServiceJobStatus	Status	Enum
TotalLedgerDimensionCount	Total unique dimension usage count	Integer

LedgerDimensionUsageCountParameters (Ledger dimension usage count service parameters)

Name	Label	Type	Length
ExecutionTimeLimit	ExecutionTimeLimit	Integer
ExtremelyHighlyVariableThreshold	ExtremelyHighlyVariableThreshold	Integer
HighlyVariableThreshold	HighlyVariableThreshold	Integer
NumberOfYearsToCheck	NumberOfYearsToCheck	Integer
PossibleHighlyVariableThreshold	PossibleHighlyVariableThreshold	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalHighlyVariableThreshold	TotalHighlyVariableThreshold	Integer

LedgerInterCompany_Asset (Fixed assets intercompany transfer)

Name	Label	Type	Length
CurrentOperationsTax	Posting layer	Enum
DestinationCompany	Destination company	String	4
DestinationJournalName	Destination journal	String	10
OriginatingCompany	Originating company	String	4
OriginatingJournalName	Name of journal	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerJournalTable_Asset (Ledger journal asset table)

Name	Label	Type	Length
IsFixedAssetIntercompanyTransfer	IsFixedAssetIntercompanyTransfer	Enum
LedgerJournalTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerJournalTransHistory_BR (LedgerJournalTrans_BR history data.)

Name	Label	Type	Length
LedgerJournalTrans	Reference	RecId
modifiedDateTime	Modified date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

LedgerJournalTransTaxExtension_BR (Journal lines for Brazil.)

Name	Label	Type	Length
LedgerJournalTrans	Reference	RecId
modifiedDateTime	Modified date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

LTMWithholdingSetStaging (Sets withholding)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Description	Description	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
WithholdingSetID	Withholding tax group	String	30

MarkupTrans_BR (Charge transaction information for Brazil)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
MarkupTrans	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PayIntV2HcmVariableCompensationEnrollmentPosition (Payroll integration variable compensation enrollment position)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OriginalRecId	OriginalRecId	Big integer
PartyNumber	Party ID	String	40
Person	Name	RecId
PersonnelNumber	Personnel number	String	25
PlanId	Plan	String	10
PlanValidFrom	Effective date	Date
PositionId	Position	String	25
PositionValidFrom	Assignment start	Date time
PositionValidTo	Assignment end	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PaymentTimesBillTCPDataset_AU (TCP dataset for PTRS report)

Name	Label	Type	Length
CreditCardPayment	Credit card payment	Enum
DocumentDate	Document date	Date
InvoiceAccount	Account number	String	20
InvoiceDate	Invoice date	Date
InvoiceDueDate	Due date	Date
InvoiceId	Invoice	String	50
InvoiceReceivedDate	Invoice receipt date	Date
IsSBTCPDataset	SBTCP	Enum
PartialPayment	Partial payment	Enum
PayeeName	Payee name	String	160
PayerABN	Payer ABN	String	25
PayerACN	Payer ACN	String	9
PayerName	Payer name	String	60
PaymentAmount	Payment amount	Real
PaymentDate	Payment date	Date
PaymentTerm	Payment term	Integer
PaymentTime	Payment time	Integer
PaymentTimesBillId	Reference	RecId
PaymTermId	Terms of payment	String	100
PeppolEInvoicing	Peppol eInvoice enabled	Enum
PurchAgreementId	Purchase agreement	String	20
PurchId	Purchase order	String	20
RCTI	RCTI	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefDataAreaId	Source legal entity	String	4
SmallBusiness	Small business	Enum
SupplyChainFinance	Supply chain finance arrangement	Enum
VATNum	Payee ABN	String	20

ProdAgentAnalyticMetric (Analytic metrics)

Name	Label	Type	Length
AverageValue	Average value	Real
createdDateTime	Created date and time	Date time
DimensionKey	Dimension key	String	500
DimensionValue	Dimension value	String	500
EndDate	Time window end date	Date time
Mape	Mape	Real
MaxValue	Maximum value	Real
MedianValue	Median value	Real
MedianVariancePercentage	Median variance	Real
MetricName	Metric name	Enum
MinValue	Minimum value	Real
NumberOfOccurrences	Number of occurrences	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDate	Time window end date	Date time

ProdAgentChartDataTmp (Chart data)

Name	Label	Type	Length
Actual	Normalized consumption	Real
Estimation	Normalized estimation	Real
FieldGroupBy	Group by	String	500
ObejctKey	Key	String	500
ObjectValue	Id	String	500
Proposed	Adjustment	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date
Unit	Unit	Enum

ProdAgentProcessTimeTmp (Route operation process time)

Name	Label	Type	Length
Estimation	Original estimation (hours)	Real
ProdId	Production	String	20
Quantity	Quantity	Real
RealConsumption	Actual process time (hours)	Real
RealQuantity	Real quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date
Variance	Variance	Real

ProdAgentPurchaseLeadTimeTmp (Purchase lead time)

Name	Label	Type	Length
ActualDeliveryDate	Physical date	Date
DeliveryDate	Requested receipt date	Date
LeadTime	Purchase lead time	Integer
PurchId	Purchase order	String	20
PurchName	Name	String	60
PurchQty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Created date and time	Date time

ProjAdjustmentStatus (Adjust transactions status)

Name	Label	Type	Length
AdjustmentDate	AdjustmentDate	Date
AdjustmentType	Transaction type	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Log	Reason	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransId	Transaction ID	String	20

ProjInvoiceProposalExportStaging (Project Operations integration invoice proposal export entity)

Name	Label	Type	Length
ContractName	Name	String	60
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FundingSourceId	Funding source ID	String	20
Invoice	Invoice	String	50
InvoiceDate	Date	Date
InvoiceHeaderText	Header	Bin/Memo/Container
InvoiceProposalId	Invoice Proposal ID	String	50
IsSelected	Select	Enum
LineProperty	Invoice proposal status	Enum
ProjectContractId	Project contract ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesCurrency	Sales currency	String	3
TransferStatus	Staging to target status	Enum

ProjMaterialUsageCreateStaging (Project material usage create)

Name	Label	Type	Length
ActivityNumber	Activity number	String	50
CostPrice	Cost price	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InventSiteId	Site	String	10
IsSelected	Select	Enum
ProductNumber	Product number	String	70
ProjId	Project ID	String	20
ProjTransId	Transaction ID	String	20
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesUnit	Unit	String	10
TransactionCategory	Category ID	String	28
TransDate	Project date	Date
TransferStatus	Staging to target status	Enum
Txt	Description	String	1000
WarehouseId	Warehouse	String	10

ProjProposalCost_BR (Invoice proposal - expense for Brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override for tax reform	Enum
ProjProposalCost	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

ProjProposalEmpl_BR (Invoice proposal - employee for Brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override for tax reform	Enum
ProjProposalEmpl	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

ProjProposalItem_BR (Invoice proposal - items for Brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override for tax reform	Enum
ProjProposalItem	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

ProjProposalOnAcc_BR (Invoice proposal - on-account for Brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override for tax reform	Enum
ProjProposalOnAcc	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

ProjProposalRevenue_BR (Invoice proposal - fee for Brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override for tax reform	Enum
ProjProposalRevenue	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PurchLine_BR (Purchase order line for brazil)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
modifiedDateTime	Modified date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
PurchLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PurchLineHistory_BR (The purchase order history table for brazil)

Name	Label	Type	Length
OverrideSalesTax_BR	Use override	Enum
PurchLineHistory	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PurchReqLineHistoryTaxExtensionBR (Purch Requisition line history tax extension for brazil)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
OverrideSalesTax_BR	Use override	Enum
PurchReqLineHistory	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PurchReqLineTaxExtensionBR (Purch Requisition line tax extension for brazil)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
PurchReqLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

PurchRFQLineTaxExtensionBR (Request from quotation line tax fields for brazil tax reform)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
PurchRFQLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

QMSAQLChartAcceptanceQualityLevelStaging (AQL chart acceptance quantity levels)

Name	Label	Type	Length
AcceptanceNumber	Ac	Integer
CellContentType	Content type	Enum
ChartId	Acceptance sampling chart name	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IndexId	Acceptable quality limit index	String	10
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleLetterCode	Sample letter	String	1
SampleSize	Sample size	Integer
TransferStatus	Staging to target status	Enum

QMSAQLChartIndexStaging (AQL chart indexes)

Name	Label	Type	Length
ChartId	Acceptance sampling chart name	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IndexId	Acceptable quality limit index	String	10
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLChartInspectionLevelStaging (AQL chart inspection levels)

Name	Label	Type	Length
ChartId	Acceptance sampling chart name	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InspectionLevelId	Inspection level	String	10
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLChartLotSizeRangeStaging (AQL chart lot size ranges)

Name	Label	Type	Length
ChartId	Acceptance sampling chart name	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LotSizeMaximumQuantity	To	Integer
LotSizeMinimumQuantity	From	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLChartSamplingLetterCodeStaging (AQL chart sample letter codes)

Name	Label	Type	Length
ChartId	Acceptance sampling chart name	String	10
ChartLotSizeMinimumQuantity	From	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InspectionLevelId	Inspection level	String	10
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleLetterCode	Sample letter	String	1
TransferStatus	Staging to target status	Enum

QMSAQLChartStaging (AQL charts)

Name	Label	Type	Length
ChartDescription	Description	String	60
ChartId	Acceptance sampling chart name	String	10
ChartIsValid	Validated	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLDefectTypeStaging (AQL defect types)

Name	Label	Type	Length
DefectCategory	Defect category	Enum
DefectDescription	Description	String	60
DefectTypeId	Defect type	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLIndexStaging (AQL indexes)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IndexDescription	Description	String	60
IndexId	Acceptable quality limit index	String	10
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSAQLInspectionLevelStaging (AQL inspection levels)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InspectionLevelDescription	Description	String	60
InspectionLevelId	Inspection level	String	10
InspectionLevelType	Inspection level type	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSQualityOrderPriorityStaging (Quality order priorities)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PriorityDescription	Description	String	60
PriorityId	Quality order priority	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSSample (Samples)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
ExpireDate	Expiration date	Date
InventDimId	Dimension number	String	20
InventTransId	Lot ID	String	20
ItemId	Item number	String	20
ItemSamplingId	Item sampling	String	10
LabelLayoutId	Label layout	String	20
LifecycleStateId	Sample lifecycle state	String	10
ProdId	Production	String	20
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegisteredByWorker	Registered by	RecId
RegisteredDateTime	Registered date time	Date time
SampleId	Sample ID	String	20
SampleInspectionMethod	Sample inspection method	Enum
SampleTypeId	Sample type	String	10
ScrappedByWorker	Scrapped by	RecId
ScrappedDateTime	Scrapped date time	Date time
TestedByWorker	Tested by	RecId
TestedDateTime	Tested date time	Date time
TestGroupId	Test group	String	10
UnitId	Unit	String	10

QMSSampleAssociation (Sample associations)

Name	Label	Type	Length
ContinuousSampleTypeId	Continuous sample type	String	10
ContinuousScrapDays	Continuous sample scrap in days	Integer
InlineDefaultItemSamplingId	Default item sampling for inline	String	10
InlineDefaultTestGroupId	Default inline test group	String	10
InlineSampleTypeId	Inline sample type	String	10
InlineScrapDays	Inline sample scrap in days	Integer
ItemCode	Item code	Enum
ItemRelation	Item	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSSampleAssociationProcedure (Sample association procedures)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleAssociation	Sample associations	RecId
SampleProcedureId	Sample procedure ID	String	10

QMSSampleAuditLog (Sample audit log)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FromValue	From	String	50
LineNum	Line number	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Reference	Reference	String	100
SampleEventType	Sample event	Enum
SampleId	Sample ID	String	20
ToValue	To	String	50

QMSSampleLifecycleState (Sample lifecycle states)

Name	Label	Type	Length
Description	Sample lifecycle state description	String	60
QualityOrderCreated	Quality order created	Enum
QualityOrderValidated	Quality order validated	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleScrapped	Sample scrapped	Enum
StateId	Sample lifecycle state	String	10

QMSSampleProcedure (Sample procedures)

Name	Label	Type	Length
Description	Description	String	60
InspectionMethod	Sample inspection method	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleProcedureDetails	Sample procedure details	Bin/Memo/Container
SampleProcedureId	Sample procedure ID	String	10
SampleProcedureTypeId	Sample procedure type	String	10

QMSSampleProcedureType (Sample procedure types)

Name	Label	Type	Length
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleProcedureTypeId	Sample procedure type	String	10

QMSSampleTrackingEntry (Sample tracking entries)

Name	Label	Type	Length
CreationSequenceNumber	Sample creation sequence number	Integer
InventDimId	Dimension number	String	20
InventQualityOrderId	Quality order	String	20
InventTransId	Lot ID	String	20
ItemId	Item number	String	20
ProdId	Production	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleId	Sample ID	String	20

QMSSampleType (Sample types)

Name	Label	Type	Length
Description	Description	String	60
LabelLayoutId	Label layout	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleInspectionMethod	Sample inspection method	Enum
SampleLifecycleStateId	Sample lifecycle state	String	10
SampleTypeId	Sample type	String	10

QMSSampleTypeStateAssignment (Sample type state assignments)

Name	Label	Type	Length
Line	Line	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleLifecycleState	Sample lifecycle state	RecId
SampleType	Sample type	RecId

ReconciliationAutomationFiscalPeriodBreakdownData (ReconciliationAutomationFiscalPeriodBreakdownData)

Name	Label	Type	Length
EndDate	End date	Date
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NumberOfLedgerTransactions	NumberOfLedgerTransactions	Big integer
NumberOfSubledgerTransactions	NumberOfSubledgerTransactions	Big integer
RecId	Record-ID	RecId
ReconciliationAutomationFiscalPeriodData	Reference	RecId
ReconciliationProcessStatus	Reconciliation automation period execution status	Enum
recVersion	Record Version	Integer
StartDate	Start date	Date

RetailCDXRemovedDataDistributionTable (Removed data distribution filters table)

Name	Label	Type	Length
IsRemovedIndirect	Indirectly removed	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RemovedTableName	Table name	String	120
RetailConnChannelSchema	Commerce channel schema	RecId

RetailTerminalStateJournal (RetailTerminalStateJournal)

Name	Label	Type	Length
DatabaseSizeInMB	Database size (MB)	Big integer
EventDateTime	UTC timestamp	Date time
MPOSVersion	Modern POS version	String	50
OfflineAvailable	Offline available	Enum
OfflineConnectionStatus	Offline connection status	Enum
OfflineDbDataSizeInMB	Offline DB data size (MB)	Big integer
OfflineDbIndexSizeInMB	Offline DB index size (MB)	Big integer
OfflineDBVersion	Offline DB version	String	50
OfflineOperation	Last offline operation	Enum
OfflineOperationError	Last offline error	Bin/Memo/Container
OfflineOperatorId	Last offline staff ID	String	25
OfflineReason	Reason for offline switch	Enum
PendingTransactions	Pending transactions	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTerminalStateData	Reference	RecId
StaffWithFailedOfflineLogonList	Users with failed offline logon	Bin/Memo/Container
TerminalId	Register number	String	10
TerminalStateDateTime	Status timestamp	Date time
UnallocatedSpaceInMB	Offline DB Unallocated space (MB)	Big integer
UnusedSpaceInMB	Offline DB Unused Space (MB)	Big integer

SalesQuotationLine_BR (SalesQuotationLine_BR)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
modifiedDateTime	Modified date and time	Date time
OverrideSalesTax_BR	Use override for tax reform	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesQuotationLine	Reference	RecId
TaxGroup_BR	Tax group for tax reform	String	10
TaxItemGroup_BR	Item tax group for tax reform	String	10

SelectedLeavePlans (Selected leave plans)

Name	Label	Type	Length
Plan	Plan	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Worker	Worker	RecId

SourceDocumentAccountingDataProcessed (SourceDocumentAccountingDataProcessed)

Name	Label	Type	Length
AccountingEvent	Accounting event	RecId
HasIntercompany	HasIntercompany	Enum
HasRelieving	HasRelieving	Enum
HasYearEnd	HasYearEnd	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeader	Reference	RecId
ValidateDebitCredit	ValidateDebitCredit	Enum

SourceDocumentLineItemJournalize (SourceDocumentLineItemJournalize)

Name	Label	Type	Length
AccountingCurrency	Currency	String	3
AccountingEvent	Accounting event	RecId
CurrencyCode	Currency	String	3
DocumentsInterCompanyBusinessEvent	DocumentsInterCompanyBusinessEvent	Enum
ExchangeRate1	Exchange rate	Real
ExchangeRate2	Exchange rate	Real
ExchangeRateDate	Accounting date	Date
FiscalCalendarPeriod	Reference	RecId
HistoricalExchangeRateDate	Historical exchange rate date	Date
Ledger	Ledger	RecId
LedgerName	Ledger name	String	20
LegalEntity	Legal entity	RecId
OffsetSide	OffsetSide	Enum
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
ReclassifyDistributionAmounts	ReclassifyDistributionAmounts	Enum
recVersion	Record Version	Integer
ReportingCurrency	Currency	String	3
ReportingExchangeRate1	Exchange rate	Real
ReportingExchangeRate2	Exchange rate	Real
Side	Side	Enum
SourceDocLineAccountingCurrencyAmount	Amount	Real
SourceDocLineNegAccountingCurrencyAmount	Amount	Real
SourceDocLineNegReportingCurrencyAmount	Amount in reporting currency	Real
SourceDocLineReportingCurrencyAmount	Amount in reporting currency	Real
SourceDocLineTransactionCurrencyAmount	Amount in transaction currency	Real
SourceDocumentHeader	Reference	RecId
SourceDocumentLine	Source document line	RecId
SubledgerJournalEntryType	Subledger journal entry type	Enum
SubledgerJournalRelievingMethod	SubledgerJournalRelievingMethod	Enum
TypeEnumName	Enum name	String	81

SourceDocumentLineItemJournalizeIntermediate (SourceDocumentLineItemJournalizeIntermediate)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AccountingEvent	Accounting event	RecId
ExchangeRateDate	Accounting date	Date
IsFinal	IsFinal	Enum
ParentSourceDocumentLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeader	Reference	RecId
SourceDocumentLine	Reference	RecId
SourceRelationType	Reference table ID	Integer
Status	Source document line status	Enum
TypeEnumName	Enum name	String	81
TypeEnumValue	SourceDocumentation:SourceDocumentType	Integer

SourceDocumentLineJournalizeIntermediate (SourceDocumentLineJournalizeIntermediate)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AccountingEvent	Accounting event	RecId
ExchangeRateDate	Accounting date	Date
IsFinal	IsFinal	Enum
ParentSourceDocumentLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeader	Reference	RecId
SourceDocumentLine	Reference	RecId
SourceRelationType	Reference table ID	Integer
Status	Source document line status	Enum
TypeEnumName	Enum name	String	81
TypeEnumValue	SourceDocumentation:SourceDocumentType	Integer

SubBillDeferralScheduleAdjustmentTable (SubBillDeferralScheduleAdjustmentTable)

Name	Label	Type	Length
DeferralSchedRecId	Reference	RecId
InventClosingVoucherRecId	Reference	RecId
InventTransId	Lot ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Adjustment method	Enum

SubBillDeferralScheduleFailedAdjustmentTable (SubBillDeferralScheduleFailedAdjustmentTable)

Name	Label	Type	Length
DeferralSchedRecId	Reference	RecId
InventClosingVoucherRecId	Reference	RecId
InventTransId	Lot ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Remarks	Remarks	Bin/Memo/Container
Status	Adjustment method	Enum
SubBillDeferralScheduleNumber	Deferral schedule number	String	20
Voucher	Voucher	String	20

SubBillInventClosingVoucherProcessingTable (Inventory vouchers for deferrals)

Name	Label	Type	Length
AdjustmentType	Type	Enum
Company	Company accounts ID	String	4
InventClosingVoucherRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Adjustment method	Enum
TransDate	Date	Date
Voucher	Voucher	String	20

SubledgerJournalEntryIdentityNotProcessed (Subledger journal entries failed to get Reference Identity)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceIdentityAttemptCount	Reference Identity Attempts Count	Integer
SubledgerJournalEntry	Reference	RecId

TrvExpenseCopilotMasterDataStaging (Expense copilot master data)

Name	Label	Type	Length
ApplyPreOpsFilter	ApplyPreOpsFilter	Enum
CreatingWorker	CreatingWorker	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsAbilityToItemizeRecurringExpensesQuicklyEnabled	IsAbilityToItemizeRecurringExpensesQuicklyEnabled	Enum
IsExpenseOCREnabled	IsExpenseOCREnabled	Enum
IsReImaginedPerDiemEnabled	IsReImaginedPerDiemEnabled	Enum
IsReimaginedUIEnabled	IsReimaginedUIEnabled	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
UserId	ID	String	20
UserName	Name	String	81
UserNetworkAlias	Email	String	255
UserPreferredHelpLanguage	UserPreferredHelpLanguage	String	7
UserPreferredLanguage	UserPreferredLanguage	String	7
UserPreferredLegalEntity	Company	String	4
UserPreferredLocale	Preferred locale	String	85
UserPreferredTimeZone	UserPreferredTimeZone	Enum
UserPreferredTimeZoneId	UserPreferredTimeZoneId	String	1000
WorkerDefaultTaxGroup	WorkerDefaultTaxGroup	String	1000

TrvExpenseCopilotReceipt (TrvExpenseCopilotReceipt)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ReceiptDetails	ReceiptDetails	Bin/Memo/Container
ReceiptId	ReceiptId	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

TrvExpenseCopilotReceiptStaging (TrvExpenseCopilotReceiptStaging)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ReceiptDetails	ReceiptDetails	Bin/Memo/Container
ReceiptId	ReceiptId	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

TrvExpenseCopilotUnattachedDocumentStaging (Expense copilot unattached document entity)

Name	Label	Type	Length
ActualCompanyId	Company accounts	String	4
Author	Author	RecId
CapturedDocument	CapturedDocument	Bin/Memo/Container
ContentType	ContentType	String	50
CreatingDateTime	Created date and time	Date time
CreatingWorker	Reference	RecId
DefaultAttachment	Is default attachment	Enum
DefinitionGroup	Processing group	String	60
DocumentCreatedBy	Created by	String	20
DocumentCreatedDateTime	Created date and time	Date time
DocumentId	Document ID	Guid
DocuRefTableName	DocuRefTableName	String	40
EntRecId	Record-ID	RecId
ExecutionId	Job ID	String	90
ExpTransNumber	ExpTransNumber	String	20
FileExtension	FileExtension	String	10
FileName	Description	String	60
IsJustification	IsJustification	Enum
IsReceiptAttached	IsReceiptAttached	Enum
IsReceiptValid	IsReceiptValid	Enum
IsSelected	Select	Enum
Notes	Note	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefCompanyId	Company account	String	4
RefRecId	Reference record ID	RecId
RefTableId	Reference table ID	Integer
TransferStatus	Staging to target status	Enum
ValueRecId	Document value record ID	RecId

VendSharedTable (VendSharedTable)

Name	Label	Type	Length
FailedVendTableAccountNumReferenceCount	FailedVendTableAccountNumReferenceCount	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalVendTableAccountNumReferenceCount	TotalVendTableAccountNumReferenceCount	Integer

VRMEntityFieldMetadata (Entity field metadata for supplier portal)

Name	Label	Type	Length
CompanyId	Legal entity	String	4
EntityName	Entity name	String	81
FieldName	Field name	String	81
RecId	Record-ID	RecId
recVersion	Record Version	Integer