DEEP DIVE: What's new in D365 Finance & Supply Chain Management Comparison between versions 10.0.42 and 10.0.43

About

Welcome to the comparison overview between versions 10.0.42 and 10.0.43.

This page highlights key updates introduced in the new release, with clear insights into changes made to the database schema.

You'll find:

• Newly added tables
• Fields introduced to existing tables
• Tables with modified fields or labels
• Adjustments in row counts

Our aim is to help you quickly identify what’s changed and stay informed about the evolution of this release.

For more detailed analysis, explore the specific sections in the sidebar.

Removed tables

AppCopilotAgentTaskHistory (AppCopilotAgentTaskHistory)

Name	Label	Type	Length
AgentTaskRecId	Record-ID	RecId
AgentTaskTitle	AgentTaskTitle	String	200
BotSchema	BotSchema	String	100
ConversationId	ConversationId	Guid
createdBy	Created by	String	20
Details	Details	Bin/Memo/Container
Followup	Followup	Bin/Memo/Container
Message	Message	Bin/Memo/Container
modifiedBy	Modified by	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TransDateTime	Transaction time	Date time
UserId	Name	String	81

LogisticsAddressZipcodeJapanStaging (ZIP Postal Code Japan)

Name	Label	Type	Length
City	City	String	60
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
KanaCity	City in Kana	String	60
KanaStreetName	Street in Kana	String	250
RecId	Record-ID	RecId
recVersion	Record Version	Integer
State	State	String	10
StreetName	Street	String	250
TransferStatus	Staging to target status	Enum
UpdateFlag	UpdateFlag	Integer
ZipCode	ZIP/postal code	String	10

PurchCopilotAgentResultEmail (Agent created emails)

Name	Label	Type	Length
AddresseeEmail	Contact email	String	80
AgentResultRecId	Agent result record	RecId
EmailBody	Email body	Bin/Memo/Container
EmailSubject	Subject	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResultReviewTimestamp	Created on	Date time
UserSpecifiedAddresseeEmail	Contact email	String	80
UserSpecifiedEmailBody	Email body	Bin/Memo/Container
UserSpecifiedEmailSubject	Subject	String	200

PurchCopilotPurchaseFollowupResultPurchLineLink (Agent result - Purchase order relations)

Name	Label	Type	Length
PurchCopilotAgentResultEmailRecId	Reference	RecId
PurchId	Purchase order	String	20
PurchLineRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

SCMCopilotAgent (Agent)

Name	Label	Type	Length
AgentDefinitionClassId	Class ID	Integer
AgentId	Agent id	Guid
Configuration	Agent configuration	Bin/Memo/Container
Description	Desciption	Bin/Memo/Container
LastRun	Last run	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
User	User ID	String	20

SCMCopilotAgentResult (Result)

Name	Label	Type	Length
AgentConfigurationId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResultCreationTimestamp	Created on	Date time
ResultId	Result Id	Guid
State	State	Enum

New tables

AccountingDistributionHistory (Accounting distribution history)

Name	Label	Type	Length
AccountingCurrency	Currency	String	3
AccountingCurrencyAmount	Amount	Real
AccountingDate	Accounting date	Date
AccountingEvent	Accounting event	RecId
AccountingLegalEntity	Legal entity	RecId
AllocationFactor	Factor	Real
AmountSource	AmountSource	Enum
FinalizeAccountingEvent	Accounting event	RecId
FinTag	Financial tag	RecId
LedgerDimension	Ledger account	RecId
MonetaryAmount	Monetary amount	Enum
Number	Number	Big integer
ParentDistribution	Distribution	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceDistribution	accounting distribution	RecId
ReferenceRole	Reference role	Enum
SourceDocumentHeader	Reference	RecId
SourceDocumentLine	Source document line	RecId
TransactionCurrency	Currency	String	3
TransactionCurrencyAmount	Amount in transaction currency	Real
Type	Account role	Enum

AccountingEventHistory (Accounting event history)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
DelayedAccountingEventType	Event type	Enum
DocumentDataAreaId	Company	String	4
EventDateTime	Change date	Date time
IsAccountingRequired	IsAccountingRequired	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeader	Source document	RecId
State	State	Enum
Type	Event type	Enum

AppCopilotAgentHistory (AppCopilotAgentHistory)

Name	Label	Type	Length
AgentTaskRecId	Record-ID	RecId
AgentTaskTitle	AgentTaskTitle	String	200
BotSchema	BotSchema	String	100
ConversationId	ConversationId	Guid
createdBy	Created by	String	20
Details	Details	Bin/Memo/Container
Followup	Followup	Bin/Memo/Container
Message	Message	Bin/Memo/Container
modifiedBy	Modified by	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TransDateTime	Transaction time	Date time
UserId	Name	String	81

CredManSalesTotals (Credit management sales total)

Name	Label	Type	Length
AccountNum	Customer account	String	20
BalanceAllAmountMST	Amount	Real
BalanceDeliveredAmountMST	Amount	Real
createdBy	Created by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesId	Sales order	String	20
Status	Status	Enum

CredManSalesTotalsProcessingQueue (Credit management sales total processing queue)

Name	Label	Type	Length
AccountNum	Customer account	String	20
createdDateTime	Created date and time	Date time
DataArea	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesId	Sales order	String	20

CustAutomationProcessStepCountTableV2 (CustAutomationProcessStepCountTableV2)

Name	Label	Type	Length
CustAutomationProcessCount	Collections process automation step count	Integer
CustAutomationStrategy	Collections process name	String	60
CustTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustVendExchRateAdjAutomationParams (Foreign currency revaluation)

Name	Label	Type	Length
CustVendExchPrinciples	Method	Enum
Description	Description	String	60
DimSpec	Dimension	Enum
ExchRateDaysOff	Number of days adjustment for date of rate	Integer
Notes	Notes	Bin/Memo/Container
PostingDaysOff	Number of days adjustment for considered date	Integer
PostingProfile	Posting profile	String	10
PostingProfileSource	Use posting profile from	Enum
ProcessScheduleOccurrence	Reference	RecId
ProcessScheduleSeries	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustVendPaymGenerateFileThresholdMin (CustVendPaymGenerateFileThresholdMin)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Value	Maximum number of transactions per payment file	Integer

DimensionDisabledTriggersTable (Disabled triggers for a specified table)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TriggerName	Trigger name	String	128

EDInvoiceLineStaging (Exchange difference invoice line (TR))

Name	Label	Type	Length
AccountType	Customer or vendor	Enum
AmountCur	Amount in transaction currency	Real
AmountMST	Amount	Real
AmountReporting	Amount in reporting currency	Real
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
EDAmount	Adjusted exchange difference amount	Real
EDAmountReporting	Adjusted exchange difference reporting amount	Real
EDCalc	Calculated exchange difference amount	Real
EDCalcReporting	Calculated exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
ExchRate	Exchange rate	Real
ExecutionId	Job ID	String	90
Invoice	Invoice	String	50
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyExchRate	Exchange rate	Real
Resource	Source	Enum
TransDate	Date	Date
TransferStatus	Staging to target status	Enum
TransRecId	Reference	RecId
Voucher	Voucher	String	20

EDInvoiceLineTR (Exchange difference invoice lines)

Name	Label	Type	Length
AccountType	Customer or vendor	Enum
AmountCur	Amount in transaction currency	Real
AmountMST	Amount	Real
AmountReporting	Amount in reporting currency	Real
CurrencyCode	Currency	String	3
EDAmount	Adjusted exchange difference amount	Real
EDAmountReporting	Adjusted exchange difference reporting amount	Real
EDCalc	Calculated exchange difference amount	Real
EDCalcReporting	Calculated exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
ExchRate	Exchange rate	Real
Invoice	Invoice	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyExchRate	Exchange rate	Real
Resource	Source	Enum
TransDate	Date	Date
TransRecId	Reference	RecId
Voucher	Voucher	String	20

EDInvoiceSettlementStaging (Exchange difference invoice settlement (TR))

Name	Label	Type	Length
AccountType	Customer or vendor	Enum
CurrencyCode	Currency	String	3
CustVendTransRecId	Reference	RecId
DefinitionGroup	Processing group	String	60
EDAmount	Adjusted exchange difference amount	Real
EDAmountReporting	Adjusted exchange difference reporting amount	Real
EDCalc	Calculated exchange difference amount	Real
EDCalcReporting	Calculated exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
ExchRate	Exchange rate	Real
ExecutionId	Job ID	String	90
Invoice	Invoice	String	50
InvoiceLineRecId	Reference	RecId
IsSelected	Select	Enum
OffsetTransVoucher	Offset voucher	String	20
PaymentCurrencyCode	Payment currency	String	3
PaymentDate	Payment date	Date
PaymentExchRate	Payment exchange rate	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Resource	Source	Enum
SettleAmountCur	Settled currency	Real
SettleAmountMST	Amount settled	Real
SettleAmountReporting	Amount in reporting currency	Real
TransDate	Date	Date
TransferStatus	Staging to target status	Enum
TransRecId	Reference	RecId
Voucher	Voucher	String	20

EDInvoiceSettlementTR (Settled transactions)

Name	Label	Type	Length
AccountType	Customer or vendor	Enum
CurrencyCode	Currency	String	3
CustVendTransRecId	Reference	RecId
EDAmount	Adjusted exchange difference amount	Real
EDAmountReporting	Adjusted exchange difference reporting amount	Real
EDCalc	Calculated exchange difference amount	Real
EDCalcReporting	Calculated exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
ExchRate	Exchange rate	Real
Invoice	Invoice	String	50
InvoiceLineRecId	Reference	RecId
OffsetTransVoucher	Offset voucher	String	20
PaymentCurrencyCode	Payment currency	String	3
PaymentDate	Payment date	Date
PaymentExchRate	Payment exchange rate	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyExchRate	Exchange rate	Real
Resource	Source	Enum
SettleAmountCur	Settled currency	Real
SettleAmountMST	Amount settled	Real
SettleAmountReporting	Amount in reporting currency	Real
TransDate	Date	Date
TransRecId	Reference	RecId
Voucher	Voucher	String	20

EDInvoiceTableStaging (Exchange difference invoice table (TR))

Name	Label	Type	Length
AccountName	Account name	String	60
AccountNum	Account number	String	20
AccountType	Account type	Enum
ApproveDate	Approved date	Date
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
Description	Description	String	60
DimensionDefaultDisplayValue	Default dimension display value	String	500
EDAmount	Exchange difference amount	Real
EDAmountReporting	Exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
EDType	Exchange difference type	Enum
ExecutionId	Job ID	String	90
InvoiceDate	Date	Date
InvoiceId	Invoice	String	50
InvoiceTxt	Invoice description	String	60
IsApproved	Approved	Enum
IsExcluded	Is excluded?	Enum
IsSelected	Select	Enum
LedgerChartOfAccountsName	Chart of accounts	String	60
MailSended	Reconciliation statement sent	Enum
MainAccountMainAccountId	Main account	String	20
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefVoucher	Reference voucher	String	20
RefVoucherDate	Reference voucher date	Date
TaxAmount	Sales tax amount	Real
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TaxWriteCode	Print code	String	10
TransferStatus	Staging to target status	Enum
Voucher	Voucher	String	20

EDInvoiceTableTR (Exchange difference invoicing)

Name	Label	Type	Length
AccountName	Account name	String	60
AccountNum	Account number	String	20
AccountType	Account type	Enum
ApproveDate	Approved date	Date
CurrencyCode	Currency	String	3
Description	Description	String	60
DimensionDefault	Dimension	RecId
EDAmount	Exchange difference amount	Real
EDAmountReporting	Exchange difference reporting amount	Real
EDInvoiceId	Exchange difference invoice	String	20
EDType	Exchange difference type	Enum
InvoiceDate	Date	Date
InvoiceId	Invoice	String	50
InvoiceTxt	Invoice description	String	60
IsApproved	Approved	Enum
IsExcluded	Is excluded?	Enum
MailSended	Reconciliation statement sent	Enum
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
ProfitLossAccountRecId	Exchange difference account	RecId
PSPrefixTR	Serial prefix	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefVoucher	Reference voucher	String	20
RefVoucherDate	Reference voucher date	Date
TaxAmount	Sales tax amount	Real
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TaxWriteCode	Print code	String	10
TransRecId	Reference	RecId
Voucher	Voucher	String	20

EDParametersStaging (Exchange difference invoicing parameters (TR))

Name	Label	Type	Length
ApproveStatus	Require invoice approval	Enum
CurrencyControlRequirementInSettling	Require same currency in settlement	Enum
CustExchangeDifferenceTransDescription	Copy description to voucher transaction	Enum
CustFillInvoiceNum	Default invoice prefix	Enum
CustGetFullSettledInvoice	Include only fully settled invoices	Enum
CustGroupingByDimension	Group by dimension	Enum
CustGroupingByProfitLoss	Group by profit or loss	Enum
CustGroupingByTax	Group by tax group	Enum
CustSingleInvoice	Separate exchange difference invoice for each invoice	Enum
DefinitionGroup	Processing group	String	60
DescriptionCust	Copy invoice description to journal line	Enum
DescriptionVend	Copy invoice description to journal line	Enum
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Key	ID	Integer
PostingProfControlRequirementInSettling	Require same posting profile in settlement	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
VendExchangeDifferenceTransDescription	Copy description to voucher transaction	Enum
VendFillInvoiceNum	Default invoice prefix	Enum
VendGetFullSettledInvoice	Include only fully settled invoices	Enum
VendGroupingByDimension	Group by dimension	Enum
VendGroupingByProfitLoss	Group by profit or loss	Enum
VendGroupingByTax	Group by tax group	Enum
VendSingleInvoice	Separate exchange difference invoice for each invoice	Enum

EDParametersTR (EDExchDiffInvoicingParameters)

Name	Label	Type	Length
ApproveStatus	Require invoice approval	Enum
CurrencyControlRequirementInSettling	Require same currency in settlement	Enum
CustExchangeDifferenceTransDescription	Copy description to voucher transaction	Enum
CustFillInvoiceNum	Default invoice prefix	Enum
CustGetFullSettledInvoice	Include only fully settled invoices	Enum
CustGroupingByDimension	Group by dimension	Enum
CustGroupingByProfitLoss	Group by profit or loss	Enum
CustGroupingByTax	Group by tax group	Enum
CustSingleInvoice	Separate exchange difference invoice for each invoice	Enum
DescriptionCust	Copy invoice description to journal line	Enum
DescriptionVend	Copy invoice description to journal line	Enum
ERAdjustmentFormatMappingID	Exchange difference invoice	Big integer
ERStatementFormatMappingID	Exchange difference invoice voucher	Big integer
Key	ID	Integer
PostingProfControlRequirementInSettling	Require same posting profile in settlement	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VendExchangeDifferenceTransDescription	Copy description to voucher transaction	Enum
VendFillInvoiceNum	Default invoice prefix	Enum
VendGetFullSettledInvoice	Include only fully settled invoices	Enum
VendGroupingByDimension	Group by dimension	Enum
VendGroupingByProfitLoss	Group by profit or loss	Enum
VendGroupingByTax	Group by tax group	Enum
VendSingleInvoice	Separate exchange difference invoice for each invoice	Enum

ELBranchParametersStaging (E-ledger branch parameters entity (TR))

Name	Label	Type	Length
BranchDescription	Branch name	String	60
BranchId	E-ledger branch ID	String	4
DefinitionGroup	Processing group	String	60
DimensionValue	Dimension value	String	30
DocumentCreator	Personnel number	String	25
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

ELBranchParametersTR (E-ledger branch parameters)

Name	Label	Type	Length
BranchDescription	Branch name	String	60
BranchId	E-ledger branch ID	String	4
DimensionValue	Dimension value	String	30
DocumentCreatorRecId	Document creator	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ELCOAStaging (E-ledger main account mapping entity (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DimensionAttributeValueDisplayValue	Combination display	String	30
ExecutionId	Job ID	String	90
GroupCode	E-ledger account group code	String	3
GroupCodeDescription	E-ledger account group description	String	255
IsSelected	Select	Enum
MainAccountDescription	E-ledger main account description	String	255
MainAccountNum	E-ledger main account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

ELCOATR (COA)

Name	Label	Type	Length
DimensionAttributeValueRecId	Dimension value	RecId
GroupCode	E-ledger account group code	String	3
GroupCodeDescription	E-ledger account group description	String	255
MainAccountDescription	E-ledger main account description	String	255
MainAccountNum	E-ledger main account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ELDimensionMainAccountStaging (E-ledger dimension main account entity (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DimensionAttributeName	Dimension name	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LedgerChartOfAccountsName	Chart of accounts	String	60
MainAccountMainAccountId	Main account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

ELDimensionMainAccountTR (Dimension mapping)

Name	Label	Type	Length
DimensionAttributeRecId	Dimension name	RecId
MainAccountRecId	Main account	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ELExcludeLayersStaging (E-ledger excluded layers entity (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Disable	Disable	Enum
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

ELExcludeLayersTR (Posting layer filter)

Name	Label	Type	Length
Disable	Exclude	Enum
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ELJournalFiscalCalendarPeriodStaging (E-ledger fiscal calendar period entity (TR))

Name	Label	Type	Length
BranchId	E-ledger branch ID	String	4
DefinitionGroup	Processing group	String	60
ELTotalAmountCurCredit	E-ledger credit	Real
ELTotalAmountCurDebit	E-ledger debit	Real
ExecutionId	Job ID	String	90
FiscalCalendarCalendarId	Calendar	String	10
FiscalCalendarPeriodName	Period name	String	60
FiscalCalendarYearName	Fiscal year	String	10
IsSelected	Select	Enum
JournalHasNumerated	Journal item numbered	Enum
LastJournalNum	Last journal item number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Sent	Sent	Enum
TotalAmountCurCredit	Credit	Real
TotalAmountCurDebit	Debit	Real
TransferStatus	Staging to target status	Enum

ELJournalFiscalCalendarPeriodTR (Fiscal calendar periods)

Name	Label	Type	Length
BranchId	E-ledger branch ID	String	4
ELTotalAmountCurCredit	E-ledger credit	Real
ELTotalAmountCurDebit	E-ledger debit	Real
FiscalCalendarPeriod	Reference	RecId
JournalHasNumerated	Journal item numbered	Enum
LastJournalNum	Last journal item number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Sent	Sent	Enum
TotalAmountCurCredit	Journal credit total	Real
TotalAmountCurDebit	Journal debit total	Real

ELJournalNumberStaging (E-ledger journal number entity (TR))

Name	Label	Type	Length
AccountingDate	Document date	Date
BranchId	E-ledger branch ID	String	4
DefinitionGroup	Processing group	String	60
DimensionValue	Dimension value	String	30
DocumentNumber	Document number	String	100
DocumentType	E-ledger document type	Enum
EDDocumentTypeDescription	Document type description	String	60
EDEntryComment	Journal item description	String	60
EDPaymentMethod	E-ledger method of payment	String	60
ExecutionId	Job ID	String	90
FiscalCalendarCalendarId	Calendar	String	10
FiscalCalendarPeriodName	Period name	String	60
FiscalCalendarYearName	Fiscal year	String	10
IsSelected	Select	Enum
JournalNum	Ledger item number	Integer
PeriodEndDate	End date	Date
PeriodStartDate	Period start	Date
PersonnelNumber	Personnel number	String	25
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefJournalNumber	Journal number	String	20
TransferStatus	Staging to target status	Enum

ELJournalNumberTR (Ledger item number)

Name	Label	Type	Length
AccountingDate	Document date	Date
BranchId	E-ledger branch ID	String	4
DimensionValue	Dimension value	String	30
DocumentNumber	Document number	String	100
DocumentType	E-ledger document type	Enum
EDDocumentTypeDescription	Document type description	String	60
EDEntryComment	Journal item description	String	60
EDPaymentMethod	E-ledger method of payment	String	60
FiscalCalendarPeriod	Fiscal calendar period	RecId
HcmWorkerRecId	Worker	RecId
JournalNum	Ledger item number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefJournalNumber	Journal number	String	20
Text	Description	String	512

ELOutGoingPoolLineStaging (E-ledger outgoing pool line entity (TR))

Name	Label	Type	Length
AccountMainID	Main account code	String	20
AccountName	Main account name	String	60
AccountSubId	Sub account code	String	20
AccountSubName	Sub account name	String	60
Amount	Amount	Real
DebitCredit	DebitCredit	Enum
DefinitionGroup	Processing group	String	60
DetailComment	Ledger detail comment	String	60
EDOutGoingPool	Reference	RecId
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PostingDate	Ledger date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
VoucherLineNum	Voucher line number	Integer

ELOutGoingPoolLineTR (E-ledger lines)

Name	Label	Type	Length
AccountMainID	Main account code	String	20
AccountName	Main account name	String	60
AccountSubId	Sub account code	String	20
AccountSubName	Sub account name	String	60
Amount	Amount	Real
DebitCredit	Debit or credit	Enum
DetailComment	Ledger detail comment	String	60
EDOutGoingPool	Reference	RecId
PostingDate	Ledger date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VoucherLineNum	Voucher line number	Integer

ELOutGoingPoolStaging (E-ledger outgoing pool entity (TR))

Name	Label	Type	Length
AccountingDate	Document date	Date
BranchDescription	Name	String	60
BranchId	E-ledger branch ID	String	4
DefinitionGroup	Processing group	String	60
DocumentNumber	Document number	String	100
DocumentReference	Document reference	String	20
DocumentType	E-ledger document type	Enum
DocumentTypeDescription	Document type description	String	60
EntryComment	Journal item description	String	60
ExecutionId	Job ID	String	90
FiscalCalendarPeriod	Fiscal calendar period reference	RecId
IsSelected	Select	Enum
JournalNum	Ledger item number	Integer
LineCount	Line count	Integer
PaymentMethod	E-ledger method of payment	String	60
PersonnelNumber	Personnel number	String	25
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalCredit	Total credit	Real
TotalDebit	Total debit	Real
TransferStatus	Staging to target status	Enum

ELOutGoingPoolTR (Send e-ledger information)

Name	Label	Type	Length
AccountingDate	Document date	Date
BranchDescription	Name	String	60
BranchId	E-ledger branch ID	String	4
createdDateTime	Created date and time	Date time
DocumentNumber	Document number	String	100
DocumentReference	Document reference	String	20
DocumentType	E-ledger document type	Enum
DocumentTypeDescription	Document type description	String	60
EntryComment	Journal item description	String	60
FiscalCalendarPeriod	Fiscal calendar period reference	RecId
HcmWorkerRecId	Worker	RecId
JournalNum	Ledger item number	Integer
LineCount	Line count	Integer
modifiedDateTime	Modified date and time	Date time
PaymentMethod	E-ledger method of payment	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalCredit	Total credit	Real
TotalDebit	Total debit	Real

ELParameterSetupStaging (E-ledger parameter setup entity (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DocumentType	E-ledger document type	Enum
DocumentTypeDescription	Document type description	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
JournalCategory	Transaction type	Enum
PaymentMethod	E-ledger method of payment	String	60
PersonnelNumber	Personnel number	String	25
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
UsePaymentMethodsByAccounts	Use payment method mapping	Enum
VoucherFilter	Voucher filter	String	20

ELParameterSetupTR (E-ledger document info update setup)

Name	Label	Type	Length
DocumentType	E-ledger document type	Enum
DocumentTypeDescription	Document type description	String	60
HcmWorkerRecId	Worker	RecId
JournalCategory	Transaction type	Enum
PaymentMethod	E-ledger method of payment	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UsePaymentMethodsByAccounts	Use payment method mapping	Enum
VoucherFilter	Voucher filter	String	20

ELParametersStaging (E-ledger delivery parameters entity (TR))

Name	Label	Type	Length
BranchDescription	Branch name	String	60
BranchId	E-ledger branch ID	String	4
COALookupActive	Enable E-ledger chart of accounts ledger	Enum
DefinitionGroup	Processing group	String	60
DimensionAttributeName	Dimension name	String	60
DimensionMainAccountActivate	Append dimension value to main account	Enum
ExecutionId	Job ID	String	90
HcmWorkerPersonnelNumber	Personnel number	String	25
IsActiveMultiBranch	Enable reporting per branch	Enum
IsSelected	Select	Enum
Key	ID	Integer
MaxBatchSessionsforSendingPool	Maximum batch threads when sending to e-ledger pool	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TakeSameNumForSameVoucher	Single journal number per voucher	Enum
TransferStatus	Staging to target status	Enum

ELParametersTR (E-ledger)

Name	Label	Type	Length
BranchDescription	Branch name	String	60
BranchId	E-ledger branch ID	String	4
COAAttributeRecId	Dimension name	RecId
COALookupActive	Enable E-ledger chart of accounts ledger	Enum
DimensionAttributeRecId	Dimension name	RecId
DimensionMainAccountActivate	Append dimension value to main account	Enum
DocumentCreatorRecId	Document creator	RecId
ERFormatMappingGeneralID	Format mapping for general journal	Big integer
ERFormatMappingID	Format mapping	Big integer
ERFormatMappingLedgerID	Format mapping for ledger book	Big integer
IsActiveMultiBranch	Enable reporting per branch	Enum
Key	ID	Integer
MaxBatchSessionsforSendingPool	Maximum batch threads when sending to e-ledger pool	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TakeSameNumForSameVoucher	Single journal number per voucher	Enum

ELPaymentMethodsByAccountsStaging (E-ledger payment methods by accounts entity (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
MainAccountIdFilter	Number	String	20
PaymentMethod	E-ledger method of payment	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

ELPaymentMethodsByAccountsTR (Payment method setup on the general ledger account)

Name	Label	Type	Length
MainAccountIdFilter	Main account filter	String	20
PaymentMethod	E-ledger method of payment	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

EntAssetWorkOrderLifecycleStateSecurityRoles (Security roles)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoleName	Role AOT name	String	81
WorkOrderLifecycleState	Current lifecycle state	RecId

EntityTableMapping (EntityTableMapping)

Name	Label	Type	Length
DataSourceTableId	Table ID	Integer
EntityName	Reference table name	String	81
RecId	Record-ID	RecId
recVersion	Record Version	Integer

EntityTableMappingStaging (EntityTableMappingStaging)

Name	Label	Type	Length
DataSourceTableId	Table ID	Integer
DefinitionGroup	Processing group	String	60
EntityName	Reference table name	String	81
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

PaymentItem (PaymentItem)

Name	Label	Type	Length
AccountNum	Account number	String	20
AccountType	Account type	Enum
AmountCurToPay	Amount in transaction currency	Real
CashDiscDate	Cash discount date	Date
CashDiscToTake	Cash discount amount	Real
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
Deleted	Deleted	Enum
DueDate	Due date	Date
Invoice	Invoice	String	50
IsInvalid	IsInvalid	Enum
IsOnHold	IsOnHold	Enum
JournalNum	Journal batch number	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OriginalHash	OriginalHash	String	64
PaymDate	Date	Date
PaymentPlanType	Payment plan type	Enum
PaymentProcessRefRecId	Reference	RecId
PaymentStatus	Payment status	Enum
PaymMode	Method of payment	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer
Status	Status	Enum

PaymentPlan (PaymentPlan)

Name	Label	Type	Length
AlertCanceled	AlertCanceled	Enum
AlertEnded	AlertEnded	Enum
AlertError	AlertError	Enum
AutomationStatus	Automation status	Enum
BankAccount	Bank account number	String	48
Company	Company	String	4
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	200
EmailAddress	Email	String	80
Enabled	Enabled	Enum
ExecutionControlContainer	ExecutionControlContainer	Bin/Memo/Container
FromDate	From date	Date
MainAccountRange	Main account range	String	30
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NumberSequenceTable	Voucher series	RecId
PaymentCriteriaContainer	PaymentCriteriaContainer	Bin/Memo/Container
PaymentCurrency	Paying currency	String	3
PaymentDefaultsContainer	PaymentDefaultsContainer	Bin/Memo/Container
PaymentFileName	File name	String	259
PaymentGenerationDataContainer	PaymentGenerationDataContainer	Bin/Memo/Container
PaymentPlanTemplateName	Payment plan template	String	20
PaymentPlanType	Payment plan type	Enum
PaymentScheduleDateTime	Scheduled payment time	Date time
PaymMode	Method of payment	String	10
PlanId	Plan ID	String	20
PlanStatus	Plan status	Enum
ProcessingSeqContainer	ProcessingSeqContainer	Bin/Memo/Container
ProposalScheduleDateTime	Scheduled proposal time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ScheduleStartDateTime	ScheduleStartDateTime	Date time
SentByMail	SentByMail	Enum
ShowPopUp	ShowPopUp	Enum
TimeConstraintContainer	TimeConstraintContainer	Bin/Memo/Container
ToDate	To date	Date
WFApproval	WFApproval	Enum
WFConfiguration	Workflow ID	String	20

PaymentPlanTemplate (PaymentPlanTemplate)

Name	Label	Type	Length
AlertCancel	Canceled	Enum
AlertEnd	Ended	Enum
AlertError	Error	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DeriveDimension	Default financial dimensions from invoice	Enum
Description	Description	String	60
EmailAddress	E-mail address	String	80
EnableJournalPost	Enable posting for payment plan	Enum
EnablePaymFileGeneration	Enable payment generation for payment plan	Enum
EnableWFAutoSubmit	Enable auto submission for approval workflow	Enum
EnableWorkflow	Approval workflow	Enum
IsEmail	Notification by E-mail	Enum
JournalName	Journal name	String	10
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	20
NumberSequenceTable	Plan ID	RecId
PaymentPlanType	Payment plan type	Enum
PaymMode	Method of payment	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShowPopUp	Show pop-up notification	Enum
WFConfiguration	Workflow ID	String	20

PaymentPlanTransferQueue (PaymentPlanTransferQueue)

Name	Label	Type	Length
BatchJobId	Reference	RecId
ExecutionId	ExecutionId	Guid
ExecutionLog	ExecutionLog	Bin/Memo/Container
PAExecutionId	PAExecutionId	Guid
PlanRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferResult	TransferResult	Enum
TransferStatus	TransferStatus	Enum

PaymentProcess (PaymentProcess)

Name	Label	Type	Length
AlertCanceled	AlertCanceled	Enum
AlertEnded	AlertEnded	Enum
AlertError	AlertError	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrentCorrelationId	CurrentCorrelationId	Guid
EmailAddress	Email	String	80
Enabled	Enabled	Enum
ExecutionControlContainer	ExecutionControlContainer	Bin/Memo/Container
IsInExecution	In execution	Enum
IsWaitForContinuation	IsWaitForContinuation	Enum
LastExecutionResult	Execution result	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NextScheduleDateTime	NextScheduleDateTime	Date time
PaymentCriteriaContainer	PaymentCriteriaContainer	Bin/Memo/Container
PaymentDefaultsContainer	PaymentDefaultsContainer	Bin/Memo/Container
PaymentGenerationDataContainer	PaymentGenerationDataContainer	Bin/Memo/Container
PaymentPlanType	Payment plan type	Enum
PaymentProcessArtifactQueryObject	PaymentProcessArtifactQueryObject	Bin/Memo/Container
PaymentProcessState	PaymentProcessState	Enum
PlanId	Plan ID	String	20
PlanRefRecId	Reference	RecId
ProcessingSeqContainer	ProcessingSeqContainer	Bin/Memo/Container
Progress	Progress	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SentByMail	SentByMail	Enum
ShowPopUp	ShowPopUp	Enum
TimeConstraintContainer	TimeConstraintContainer	Bin/Memo/Container
TrackingBatchJobId	Batch job	RecId
WFApprovalStatus	Approval status	Enum

PaymentProcessExecutionLog (PaymentProcessExecutionLog)

Name	Label	Type	Length
BatchJobId	Reference	RecId
CancelPlan	CancelPlan	Enum
CorrelationId	CorrelationId	Guid
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Info	Infolog data	Bin/Memo/Container
LinkedPaymentProcess	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartState	StartState	Enum
Success	Success	Enum
TargetState	TargetState	Enum

ProdAsBuiltBOMProductLotAssociationUpgradeState (ProdAsBuiltBOMProductLotAssociationUpgradeState)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
IsTrackingDimIdxIndexUpgradeCompleted	IsTrackingDimIdxIndexUpgradeCompleted	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

ProjActualsValidationWork (Project actual validations work table)

Name	Label	Type	Length
ActualId	Actual ID	Guid
createdDateTime	Created date and time	Date time
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidationAttempts	Counter	Integer

ProjectAccountingDistributionHistory (Project accounting distribution history.)

Name	Label	Type	Length
AccountingDistribution	Reference	RecId
Currency	Sales currency	RecId
ProjCategory	Category	RecId
ProjCostTransCost	Reference	RecId
ProjCostTransSale	Reference	RecId
ProjEmplTransCost	Reference	RecId
ProjEmplTransSale	Reference	RecId
ProjFundingSource	Funding source	RecId
ProjItemTransCost	Reference	RecId
ProjItemTransSale	Reference	RecId
ProjLineProperty	Line property	RecId
ProjRevenueTransSale	Reference	RecId
ProjTable	Project ID	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
smmActivities	Activity number	RecId
TaxGroupHeading	Sales tax group	RecId
TaxItemGroupHeading	Item sales tax group	RecId
TransactionCurrencyAmount	Sales amount	Real
TransactionCurrencyPrice	Sales price	Real

PSFormatTableStaging (Print series format table (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FormatFieldsA	1.field name	Enum
FormatFieldsB	2.field name	Enum
FormatFieldsC	3.field name	Enum
FormatFieldsD	4.field name	Enum
FormatFieldsE	5.field name	Enum
FormatName	Format name	String	20
FormatSeperatorA	1.separator	String	32
FormatSeperatorB	2.separator	String	32
FormatSeperatorC	3.seperator	String	32
FormatSeperatorD	4.separator	String	32
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

PSFormatTableTR (Serial formats)

Name	Label	Type	Length
FormatFields1	1.field name	Enum
FormatFields2	2.field name	Enum
FormatFields3	3.field name	Enum
FormatFields4	4.field name	Enum
FormatFields5	5.field name	Enum
FormatName	Format name	String	20
FormatSeperator1	1.separator	String	32
FormatSeperator2	2.separator	String	32
FormatSeperator3	3.seperator	String	32
FormatSeperator4	4.separator	String	32
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PSSerialLineStaging (Print series serial line (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InvoiceNumber	Serial number	String	50
IsSelected	Select	Enum
Prefix	Serial prefix	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefTableId	Reference table ID	Integer
SerialType	Document type	Enum
TransferStatus	Staging to target status	Enum

PSSerialLineTR (Serial number lines)

Name	Label	Type	Length
InvoiceNumber	Serial number	String	50
Prefix	Serial prefix	String	10
RecId	Record-ID	RecId
RecordRecId	Related registration number	RecId
recVersion	Record Version	Integer
RefTableId	Reference table ID	Integer
SerialType	Document type	Enum

PSSerialTableStaging (Print series serial table (TR))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Digit	Number of digits	Integer
ExecutionId	Job ID	String	90
FinancialYear	Fiscal year	String	10
FormatName	Serial format	String	20
InvoiceType	Serial type	Enum
IsDefaultPrefix	Default prefix	Enum
IsSelected	Select	Enum
NumberSequenceGroupId	Number sequence group	String	10
Prefix	Serial prefix	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialType	Document type	Enum
TransferStatus	Staging to target status	Enum

PSSerialTableTR (E-invoice serial table)

Name	Label	Type	Length
Digit	Number of digits	Integer
FinancialYear	Fiscal year	String	10
FormatName	Serial format	String	20
InvoiceType	Serial type	Enum
IsDefaultPrefix	Default prefix	Enum
NumberSequenceGroupId	Number sequence group	String	10
Prefix	Serial prefix	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialType	Document type	Enum

PurchCopilotFollowupTask (PurchCopilotFollowupTask)

Name	Label	Type	Length
AgentTaskRecId	Reference	RecId
Configuration	Agent configuration	Bin/Memo/Container
Description	Desciption	Bin/Memo/Container
LastRun	Last run	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotFollowupTaskResultEmail (Agent created emails)

Name	Label	Type	Length
AddresseeEmail	Contact email	String	80
AgentTaskHistoryRecId	Reference	RecId
AllLinesJson	AllLinesJson	Bin/Memo/Container
EmailBody	Email body	Bin/Memo/Container
EmailJson	EmailJson	Bin/Memo/Container
EmailSubject	Subject	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelatedOrdersCount	RelatedOrdersCount	Integer
ResultReviewTimestamp	Created on	Date time
UserSpecifiedAddresseeEmail	Contact email	String	80
UserSpecifiedEmailBody	Email body	Bin/Memo/Container
UserSpecifiedEmailSubject	Subject	String	200
VendorName	Vendor name	String	60

PurchCopilotFollowupTaskResultPurchLineLink (Agent result - Purchase order relations)

Name	Label	Type	Length
PurchCopilotFollowupTaskResultEmailRecId	Reference	RecId
PurchId	Purchase order	String	20
PurchLineRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotInboundEmailProcessingTask (PurchCopilotInboundEmailProcessingTask)

Name	Label	Type	Length
AgentTaskRecId	Reference	RecId
Configuration	Agent configuration	Bin/Memo/Container
Description	Desciption	Bin/Memo/Container
LastRun	Last run	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSApprovedCustomerGroup (Approved customer groups)

Name	Label	Type	Length
Description	Description	String	60
GroupId	Approved customer group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSApprovedCustomerList (Approved customer list)

Name	Label	Type	Length
CustomerCode	Customer code	Enum
CustomerRelation	Customer relation	String	20
InventDimId	Dimension number	String	20
ItemCode	Item code	Enum
ItemRelation	Item relation	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidFrom	Effective	Date
ValidTo	Expiration	Date

QMSApprovedItemGroup (Approved item groups)

Name	Label	Type	Length
Description	Description	String	60
GroupId	Approved item group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSCAPACaseAssociationInventDim (Case association dimensions)

Name	Label	Type	Length
CaseAssociation	Case association	RecId
ImpactedQty	Impacted quantity	Real
InventDimId	Dimension number	String	20
PdsCWUnitId	CW unit	String	10
PdsImpactedCWQty	Impacted catch weight quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UnitId	Unit	String	10

QMSCAPACaseEmailLink (Email notification list)

Name	Label	Type	Length
ActivityStatusClosed	Closed Activity	Enum
ActivityStatusReopened	Reopened Activity	Enum
CaseRecId	Case ID	RecId
CaseStatusCancelled	Canceled CAPA Status	Enum
CaseStatusClosed	Closed CAPA Status	Enum
CaseStatusInProcess	Reopened CAPA Status	Enum
DirPartyRecId	Party	RecId
LineNumber	Line	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WorkerGroupId	CAPA worker group	String	20

QMSCAPACategory (CAPA categories)

Name	Label	Type	Length
CategoryId	CAPA category	String	20
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubCategoryEntityType	CAPA subcategory type	Enum

QMSCAPAClassificationCode (Major/Minor classification codes)

Name	Label	Type	Length
ClassificationCodeId	Major/Minor classification code	String	10
ClassificationDescription	Major/Minor classification description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSCAPAResolution (CAPA resolutions)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResolutionDescription	CAPA resolution type description	String	60
ResolutionType	CAPA resolution type	String	10

QMSCAPARootCause (CAPA root causes)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RootCauseCode	Root cause code	String	20
RootCauseDescription	Description	String	60

QMSCAPASourceCode (CAPA source codes)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceCodeId	CAPA source code	String	10
SourceDescription	CAPA source code description	String	60

QMSCAPASubCategoryUserDefined (User defined CAPA subcategories)

Name	Label	Type	Length
CategoryId	CAPA category	String	20
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubCategoryId	CAPA subcategory	String	20

QMSCAPAType (CAPA types)

Name	Label	Type	Length
CAPATypeDescription	CAPA type description	String	60
CAPATypeId	CAPA type	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSCAPAWorkerGroup (CAPA worker groups)

Name	Label	Type	Length
AllowAnyToChangeState	Allow any member to change stage	Enum
DefaultWorkerAssignment	CAPA worker group member	RecId
GroupId	CAPA worker group	String	20
IsAdminDefaultWorker	Default worker	Enum
IsAdminMember	Implied member of this worker group	Enum
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSCAPAWorkerGroupAssignment (CAPA worker group assignments)

Name	Label	Type	Length
Group	CAPA worker group	RecId
IsAllowedToChangeState	Allowed	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Worker	Worker	RecId

QMSDispensingTicket (Dispensing tickets)

Name	Label	Type	Length
DispensedCWQty	CW dispensed	Real
DispensedQty	Dispensed	Real
ProdJournalBOMRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSDispensingTicketLine (Dispensing ticket lines)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DispensedCWQty	CW dispensed	Real
DispensedGrossQty	Gross	Real
DispensedQty	Dispensed - net	Real
DispensedTareQty	Tare	Real
DispensingTicket	Reference	RecId
IncludeInValidation	Include in validation	Enum
LineNum	Line	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ScalesDeviceId	Scales	String	20

QMSDispensingUserInfo (Dispensing user info)

Name	Label	Type	Length
AuthorizedForDispensing	Authorized for production dispensing	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

QMSFlexibleSamplingPlanHistory (History of flexible sampling plans)

Name	Label	Type	Length
Approved	Approved	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
FlexibleSamplingPlanId	Flexible sampling plan code	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInstrumentCalibrationCertTmp (Test instrument calibration details)

Name	Label	Type	Length
AcquisitionDate	Acquisition date	Date
CalibrationApprovalAssignee	Approval assignee	String	20
CalibrationApprovedBy	Approved by	String	20
CalibrationApprovedDate	Approval date	Date
CalibrationCompletedBy	Completed by	String	20
CalibrationCompletedDate	Completion date	Date
CalibrationCompletionAssignee	Completion assignee	String	20
CalibrationResult	Calibration result	Enum
CalibrationStartedBy	Started by	String	20
CalibrationStartedDate	Started date	Date
createdBy	Created by	String	20
createdTransactionId	Created ID	Big integer
ExternalCalibratingVendor	External calibrating vendor	String	20
ExternalVendName	External vendor name	String	160
InstrumentDescription	Instrument description	String	60
Manufacturer	Manufacturer	String	30
ModelNumber	Model number	String	30
Note	Calibration notes	Bin/Memo/Container
Owner	Owner	String	30
ProcedureDescription	Description	String	30
ProcedureName	Calibration procedure name	String	30
ProcedureNote	Calibration procedure	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialNumber	Serial number	String	10
Specification	Specifications	Bin/Memo/Container
TagDescription	Tag description	String	30
TagNumber	Tag number	String	10
TestDepartment	Test department	String	10
TestInstrumentId	Test instrument type	String	20
TestLocation	Test location	String	10
TestPrecision	Precision	Real
TestProcedure	Test procedures	Bin/Memo/Container
ToolInstrumentDescription	Calibration tool description	String	60
ToolLastCalibrationApprovedDate	Last calibration date	Date
ToolTagDescription	Calibration tool tag description	String	30
ToolTagNumber	Calibration tool tag number	String	10
ToolTestInstrumentId	Calibration tool instrument type	String	20
Unit	Unit	String	10
UsageStatus	Instrument usage status	Enum

QMSInventBatchShelfLifeHistory (Shelf date history)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
InventBatchId	Batch number	String	20
ItemId	Item number	String	20
NewBestBeforeDate	New best before date	Date
NewInventBatchProdDate	New manufacturing date	Date
NewShelfAdviceDate	New shelf advice date	Date
NewVendExpiryDate	New expiration date	Date
OldBestBeforeDate	Old best before date	Date
OldInventBatchProdDate	Old manufacturing date	Date
OldShelfAdviceDate	Old shelf advice date	Date
OldVendExpiryDate	Old expiration date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventCalibrationGroup (Calibration groups)

Name	Label	Type	Length
CalibrationMethod	Calibration method	Enum
CalibrationPeriod	Calibration period	Enum
Description	Description	String	30
GroupId	Calibration group	String	10
MaxUsage	Maximum usage before calibration	Integer
MaxUsageLifetime	Lifetime usage maximum	Integer
PeriodFrequency	Calibration period frequency	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UsageCountTrigger	Usage count trigger for calibration	Integer
UsageIncrement	Usage increment	Integer
UsageUpdateMethod	Calibration usage update method	Enum

QMSInventCalibrationLabelLayout (Calibration label layout)

Name	Label	Type	Length
Description	Description	String	60
LabelLayoutId	Label layout	String	20
LabelLength	Label length (inches)	Integer
LabelPrintDensity	Print density	Enum
LabelWidth	Label width (inches)	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UseFieldName	Use field name	Enum
ZPL	ZPL	Bin/Memo/Container

QMSInventCalibrationProcedure (Calibration procedures)

Name	Label	Type	Length
Description	Description	String	30
ExternalCalibratingVendor	External calibrating vendor	String	20
Name	Calibration procedure name	String	30
Procedure	Calibration procedure	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventCalibrationWorkspaceConfiguration (Calibration workspace configuration)

Name	Label	Type	Length
CreatedDays	Recently created calibration records	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

QMSInventCAPAWorkspaceConfiguration (CAPA workspace configuration)

Name	Label	Type	Length
CaseCreatedDays	Recently created CAPA cases	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

QMSInventFlexSamplingActivityLine (Flexible sampling plan activity details)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
FailActionCode	Fail action code	Enum
FailActionLevel	Fail action level	Integer
InventFlexSamplingActivityRecId	Flexible sampling plan activity record ID	RecId
InventItemSamplingId	Item sampling	String	10
InventTestGroupId	Test group	String	10
Level	Level	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderStatus	Status	Enum
PassActionLevel	Pass action level	Integer
PlanActivityNumber	No.	Integer
QualityOrderId	Quality order	String	20
ReasonCode	Reason code	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Reference	Reference	String	50
RoundNumber	Round number	Integer
RoundsToSkip	Rounds to test	Bin/Memo/Container
RoundTrackingNumber	Round tracking number	Integer
Skip	Skip	Enum
TestPerSampleGroup	Test frequency	Integer
TestSampleGroupSize	Out of frequency	Integer
ValidatedByWorker	Validated by	RecId
ValidatedDateTime	Validated date and time	Date time

QMSInventFlexSamplingActivityTable (Flexible sampling plan activities)

Name	Label	Type	Length
AccountRelation	Account selection	String	20
FlexibleSamplingPlanId	Flexible sampling plan code	String	10
ItemId	Item number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceType	Reference type	Enum
RoundsToSkip	Rounds to test	Bin/Memo/Container
WrkCtrRelation	Resource	String	10

QMSInventFlexSamplingChangeLevelReason (Flexible sampling activity change level reasons)

Name	Label	Type	Length
ReasonCode	Reason code	String	10
ReasonComment	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventFlexSamplingPlanLine (Flexible sampling plan lines)

Name	Label	Type	Length
Consecutive	Consecutive	Enum
FailActionCode	Fail action code	Enum
FailActionLevel	Fail action level	Integer
Fails	Number of fails	Integer
FlexibleSamplingPlanId	Flexible sampling plan code	String	10
ItemSamplingId	Item sampling	String	10
Level	Level	Integer
PassActionLevel	Pass action level	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Rounds	Rounds	Integer
Skip	Skip	Enum
TestGroupId	Test group	String	10
TestPerSampleGroup	Test frequency	Integer
TestSampleGroupSize	Out of frequency	Integer
TimeSpanDays	Time span (days)	Integer

QMSInventFlexSamplingPlanTable (Flexible sampling plans)

Name	Label	Type	Length
Approved	Approved	Enum
Description	Description	String	60
FlexibleSamplingPlanId	Flexible sampling plan code	String	10
LastLevel	Last level	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRole	Alert role	String	81

QMSInventNonConformanceWorkGroup (Non conformance work groups)

Name	Label	Type	Length
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WorkGroupId	Work group	String	10

QMSInventQualityOrderPriority (Quality order priority)

Name	Label	Type	Length
Description	Description	String	60
PriorityId	Quality order priority	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventQualityWorkspaceConfiguration (Quality workspace configuration)

Name	Label	Type	Length
OrderCreatedDays	Recently created quality orders	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

QMSInventTestCalibrationReopenHistory (Test instrument calibration reopen log)

Name	Label	Type	Length
CalibrationApprovedBy	Approved by	String	20
CalibrationApprovedDate	Approval date	Date
CalibrationCompletedBy	Completed by	String	20
CalibrationCompletedDate	Completion date	Date
CalibrationResult	Calibration result	Enum
Comment	Comment	String	60
LineNumber	Line	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReopenedBy	Reopened by	String	20
ReopenedDate	Reopened date	Date
TestInstrumentCalibration	Reference	RecId

QMSInventTestCertOfAnalysisCustGroup (Certificate of analysis customer groups)

Name	Label	Type	Length
CustGroupId	COA customer group	String	10
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestCertOfAnalysisCustReq (Customer COA requirements)

Name	Label	Type	Length
CustomerCode	Customer code	Enum
CustomerRelation	Customer relation	String	20
ExcludeFromCOA	Exclude	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference record ID	RecId
RefTableId	Reference table ID	Integer
ReplaceFailResults	Replace fail results	String	30
ReplacePassResults	Replace pass results	String	30
SupressMinMaxValues	Suppress Min/Max values	Enum
UseCustBatchAttribRange	Use customer specific ranges	Enum

QMSInventTestDepartment (Test departments)

Name	Label	Type	Length
Description	Description	String	30
Name	Test department	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestDiagnosticGroup (Diagnostic groups)

Name	Label	Type	Length
Description	Description	String	60
DiagnosticGroupId	Diagnostic groups	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestDiagnosticGroupDiagnostic (Diagnostic group diagnostic types)

Name	Label	Type	Length
DiagnosticGroupId	Diagnostic groups	String	10
DiagnosticTypeId	Diagnostic	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResponsibleWorker	Worker	RecId

QMSInventTestInstrumentCalibration (Test instrument calibration records)

Name	Label	Type	Length
CalibrationApprovalAssignee	Approval assignee	String	20
CalibrationApprovedBy	Approved by	String	20
CalibrationApprovedDate	Approval date	Date
CalibrationCompletedBy	Completed by	String	20
CalibrationCompletedDate	Completion date	Date
CalibrationCompletionAssignee	Completion assignee	String	20
CalibrationResult	Calibration result	Enum
CalibrationStartedBy	Started by	String	20
CalibrationStartedDate	Started date	Date
createdDateTime	Created date and time	Date time
InventCalibrationProcedure	Calibration procedure name	String	30
InventTestInstrument	Test instrument type	String	20
modifiedDateTime	Modified date and time	Date time
Note	Calibration notes	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Specification	Specifications	Bin/Memo/Container
TestInstrumentTagNumber	Tag number	String	10
TestProcedure	Test procedures	Bin/Memo/Container

QMSInventTestInstrumentCalibrationTool (Instrument calibration tools)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TestInstrumentCalibration	Reference	RecId
TestInstrumentId	Calibration tool	String	20
TestInstrumentTagNumber	Calibration tool tag number	String	10

QMSInventTestInstrumentTag (Test instrument tags)

Name	Label	Type	Length
AcquisitionDate	Acquisition date	Date
AssetId	Fixed asset number	String	20
CalibrationApprovalAssignee	Approval assignee	String	20
CalibrationApprovedDate	Approval date	Date
CalibrationCertificatePrintDate	Date calibration certificate printed	Date
CalibrationCheck	Check if test instrument is being calibrated	Enum
CalibrationCompletedDate	Completion date	Date
CalibrationCompletionAssignee	Completion assignee	String	20
CalibrationGroupId	Calibration group	String	10
CalibrationMethod	Calibration method	Enum
CalibrationNextDate	Next calibration date	Date
CalibrationProcedure	Calibration procedure name	String	30
CalibrationRequired	Calibration required	Enum
CalibrationResult	Calibration result	String	10
CalibrationStartDate	Calibration start date	Date
CalibrationStartedDate	Started date	Date
createdDateTime	Created date and time	Date time
CustTable	Customer account	String	20
Description	Description	String	30
IsForRestrictedUse	Restricted use	Enum
LifetimeUsageCount	Lifetime usage count	Integer
ManufactureDate	Manufacture date	Date
Manufacturer	Manufacturer	String	30
ManufacturerPartNumber	Manufacturer part number	String	30
ModelNumber	Model number	String	30
Note	Notes	Bin/Memo/Container
Owner	Owner	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialNumber	Serial number	String	10
SkipCheckTestInstrumentOnOrder	Skip check for test instrument on open quality order	Enum
Specification	Specifications	Bin/Memo/Container
TagNumber	Tag number	String	10
TestDepartment	Test department	String	10
TestInstrumentId	Test instrument type	String	20
TestLocation	Test location	String	10
TestProcedure	Test procedures	Bin/Memo/Container
UsageCountSinceLastCalibration	Usage count since last calibration	Integer
UsageStatus	Instrument usage status	Enum
VendTable	Vendor account	String	20
WarrantyExpiryDate	Warranty expiry	Date
WarrantyNumber	Warranty number	String	10

QMSInventTestLocation (Test locations)

Name	Label	Type	Length
Description	Description	String	30
LocationId	Test location	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestOperationGroup (Non conformance operation groups)

Name	Label	Type	Length
Description	Description	String	60
OperationGroupId	Non conformance operation groups	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestOperationGroupOperation (Non conformance operation group operations)

Name	Label	Type	Length
OperationGroupId	Non conformance operation groups	String	10
OperationId	Operation	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSInventTestRootCause (Root cause code)

Name	Label	Type	Length
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RootCause	Root cause code	String	10

QMSProdReleaseBOM (Released production BOM quantities)

Name	Label	Type	Length
BOMQty	Proposal	Real
CWInventQty	CW proposal	Real
InventQty	Inventory proposal	Real
ProdBOMRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSScalesDevice (Measuring devices)

Name	Label	Type	Length
Description	Description	String	60
DeviceId	Device Id	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TestInstrumentTagRecId	Test instrument tag	RecId

ReconciliationAutomationAmountMismatchRule (Reconciliation automation amount mismatch rules)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Currency	Currency	String	3
LowerBoundaryValue	Lower boundary value	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
RecommendedAction	Reconciliation automation event value	Enum
ReconciliationAutomationRuleOperator	Reconciliation automation rule operator	Enum
recVersion	Record Version	Integer
UpperBoundaryValue	Upper boundary value	Real

ReconciliationAutomationAmountMismatchRuleHistory (Reconciliation automation amount mismatch rule history)

Name	Label	Type	Length
ActiveFrom	ActiveFrom	Date time
ActiveTo	ActiveTo	Date time
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Currency	Currency	String	3
LowerBoundaryValue	Lower boundary value	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
RecommendedAction	Reconciliation automation event value	Enum
ReconciliationAutomationRuleOperator	Reconciliation automation rule operator	Enum
recVersion	Record Version	Integer
UpperBoundaryValue	Upper boundary value	Real

ReconciliationAutomationSnapshot (Reconciliation automation framework table)

Name	Label	Type	Length
Company	Company	String	4
FiscalCalendarPeriod	Reference	RecId
Ledger	Ledger	RecId
RecId	Record-ID	RecId
ReconciliationModule	Reconciliation automation module	Enum
recVersion	Record Version	Integer

RetailCDXDownloadSessionDataStoreSummaryErrors (Errors by error code)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
ErrorId	Error code	String	80
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Total	Total	Integer

RetailCDXDownloadSessionDataStoreSummaryJobsByStatus (Errors by job and status)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
JobID	Job name	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
Total	Total	Integer

RetailReceiptsContent (RetailReceiptsContent)

Name	Label	Type	Length
ChannelId	Reference	RecId
Content	Content	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44

RetailSharedAzureMapsParameters (Retail shared Azure Maps parameters)

Name	Label	Type	Length
ApiKey	Azure Maps key	String	128
Enabled	Enable Azure Maps	Enum
Key	ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RetailTransactionPriceTransHistory (Archived commerce price transactions)

Name	Label	Type	Length
CalculatedPricingPriorityNumber	Calculated pricing priority	Integer
Channel	Reference	RecId
PriceType	Price Type	Enum
RecId	Record-ID	RecId
RecordId	Reference record ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
SaleLineNum	Sales line number	Real
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
Value	Amount	Real

ReturnInvoiceHeaderCDSStaging (CDS return invoice headers)

Name	Label	Type	Length
CashDiscount	Cash discount	Real
ContactPersonId	Contact ID	String	20
CurrencyCode	Currency	String	3
CustomersOrderReference	Customer reference	String	60
DefinitionGroup	Processing group	String	60
DeliveryModeCode	Mode of delivery	String	10
DeliveryTermsCode	Delivery terms	String	10
EndDiscount	Total discount	Real
ExecutionId	Job ID	String	90
InvoiceAddressCity	City	String	60
InvoiceAddressCountryRegionId	Country/region	String	10
InvoiceAddressCountryRegionISOCode	ISO	String	2
InvoiceAddressState	State	String	10
InvoiceAddressStreet	Street	String	250
InvoiceAddressStreetNumber	Street number	String	20
InvoiceAddressZipCode	ZIP/postal code	String	10
InvoiceCustomerAccountNumber	Invoice account	String	20
InvoiceDate	Date	Date
InvoiceHeaderTaxAmount	Sales tax amount	Real
InvoiceNumber	Invoice	String	20
IsSelected	Select	Enum
LedgerVoucher	Voucher	String	20
PaymentTermsName	Payment	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesOrderNumber	Sales order	String	20
SalesOrderOriginCode	Sales origin	String	10
SalesOrderResponsiblePersonnelNumber	Personnel number	String	25
TotalChargeAmount	Total charges	Real
TotalDiscountCustomerGroupCode	Total discount	Real
TotalInvoiceAmount	Invoice amount	Real
TotalLineDiscount	Line discount	Real
TotalTaxAmount	Sales tax	Real
TransferStatus	Staging to target status	Enum

ReturnInvoiceLineCDSStaging (CDS return invoice lines)

Name	Label	Type	Length
ConfirmedShippingDate	Confirmed ship date	Date
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
DimensionNumber	Dimension number	String	20
ExecutionId	Job ID	String	90
InventorySiteId	Site	String	10
InventoryWarehouseId	Warehouse	String	10
InvoiceDate	Date	Date
InvoicedQuantity	Quantity	Real
InvoiceNumber	Invoice	String	20
IsSelected	Select	Enum
ItemBatchNumber	Batch number	String	20
LedgerVoucher	Voucher	String	20
LineAmount	Amount	Real
LineCreationSequenceNumber	Line creation sequence number	Integer
LineTotalChargeAmount	Amount in transaction currency	Real
LineTotalDiscountAmount	Line discount	Real
LineTotalTaxAmount	Sales tax amount	Real
OrderedInventoryStatusId	Inventory status	String	10
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductDescription	Description	String	1000
ProductName	Product name	String	60
ProductNumber	Product number	String	70
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
ProductVariantName	Product name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesPrice	Unit price	Real
SalesProductCategoryHierarchyName	Name	String	128
SalesProductCategoryName	Name	String	254
SalesUnitSymbol	Unit	String	10
TransferStatus	Staging to target status	Enum

SourceDocumentHeaderHistory (Source document header history)

Name	Label	Type	Length
AccountingStatus	Source document status	Enum
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRelationType	Relation type	Integer
TypeEnumName	Enum name	String	81
TypeEnumValue	SourceDocumentation:SourceDocumentType	Integer

SourceDocumentLineHistory (Source document line history)

Name	Label	Type	Length
AccountingStatus	Source document line status	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DraftVersion	Record Version	Integer
ExchangeRateDate	Accounting date	Date
IsFinal	IsFinal	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ParentSourceDocumentLine	Source document line	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeader	Source document	RecId
SourceImplementationRecId	Reference	RecId
SourceRelationType	Reference table ID	Integer
StateContainer	State container	Bin/Memo/Container
TermQuantity	Quantity	Real
TypeEnumName	Enum name	String	81
TypeEnumValue	SourceDocumentation:SourceDocumentType	Integer

SubBillDetailLineStagingV2 (Subscription billing usage V2)

Name	Label	Type	Length
BillingEndDate	Billing end date	Date
BillingStartDate	Billing start date	Date
Comments	Comments	String	100
ConsumedQuantity	Consumed quantity	Real
CurrentReading	Current reading	Real
DefinitionGroup	Processing group	String	60
EstimatedQty	Estimated quantity	Real
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ItemNumber	Item code	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ScheduleNumber	Billing schedule number	String	20
TransferStatus	Staging to target status	Enum
UsageIdentifier	Usage identifier	String	10
UsageReadingOption	Usage option	Enum

SubBillSalesLineTransactionAuditTrail (SubBillSalesLineTransactionAuditTrail)

Name	Label	Type	Length
LineCreationSequenceNumber	Line creation sequence number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesId	Sales order	String	20
SubBillBillingScheduleNumber	Billing schedule number	String	20

SubledgerJournalAccountEntryDistributionHistory (Subledger journal account entry distribution history)

Name	Label	Type	Length
AccountingCurrencyAmount	Amount	Real
AccountingDistribution	Reference	RecId
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
ParentDistribution	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	The amount in the reporting currency	Real
SourceDocumentLine	Reference	RecId
SubledgerJournalAccountEntry	Reference	RecId

SubledgerJournalAccountEntryHistory (Subledger journal account entry history)

Name	Label	Type	Length
AccountEntryEventRole	Account entry role	Enum
AccountingCurrencyAmount	Amount	Real
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
ExchangeRate1	Exchange rate	Real
ExchangeRate2	Exchange rate	Real
ExchangeRateDate	Accounting date	Date
FinTag	Financial tag	RecId
GeneralJournalAccountEntry	Reference	RecId
HistoricalExchangeRateDate	Historical exchange rate date	Date
IsCorrection	Correction	Enum
IsTransferredInDetail	Transfer policy	Enum
LedgerDimension	Ledger account	RecId
OriginalTransferPolicy	Transfer policy	Enum
PostingType	Posting type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	The amount in the reporting currency	Real
ReportingExchangeRate1	Exchange rate	Real
ReportingExchangeRate2	Exchange rate	Real
Side	side	Enum
SubledgerJournalEntry	Reference	RecId
TransactionCurrency	Currency	String	3
TransactionCurrencyAmount	Transaction amount in standard currency	Real

SubledgerJournalEntryHistory (Subledger journal entry history)

Name	Label	Type	Length
AccountingEvent	Reference	RecId
createdTransactionId	Created ID	Big integer
DocumentDate	Document date	Date
DocumentNumber	Document	String	50
FiscalCalendarPeriod	Reference	RecId
JournalNumber	Number	String	20
Ledger	Ledger	RecId
modifiedDateTime	Modified date and time	Date time
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceIdentityTransferStatus	ReferenceIdentityTransferStatus	Enum
Status	Subledger journal entry status	Enum
TransferId	Transfer identifier	Big integer
TransTxt	Description	String	512
Type	Subledger journal entry type	Enum
Voucher	Voucher	String	20
VoucherDataAreaId	Company accounts ID	String	4

TaxIntegrationFlexibleFieldLabels (Flexible fields)

Name	Label	Type	Length
Field	Flexible field name	String	120
HelpText	Help text	String	255
Label	Label	String	1999
LanguageId	Language	String	7
RecId	Record-ID	RecId
recVersion	Record Version	Integer

UserManagementDVUserInfo (UserManagementDVUserInfo)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EmailAddress	Email	String	80
Enabled	Enabled	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NetworkDomain	NetworkDomain	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserObjectId	UserObjectId	Guid

UserManagementDVUserRole (UserManagementDVUserRole)

Name	Label	Type	Length
EmailAddress	Email	String	80
Enabled	Enabled	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRoleAOTName	Role AOT name	String	81
UserObjectId	UserObjectId	Guid

UserSecGovAuditLog (User security governance audit log)

Name	Label	Type	Length
AuditSource	Audit log source	Enum
createdDateTime	Created date and time	Date time
EventCreatedBy	User ID	String	20
EventDateTime	UTC timestamp	Date time
OperationType	Operation	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Source row RecId	RecId
RefTableId	Audit log generating table	Integer
RowStatus	Generic status	Enum

UserSecGovCategory (Categories)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefCompany	Company	String	4

UserSecGovEntryPoint (Entry points)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccessRight	Securable object access	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
IsEntryPoint	Is entry point	Enum
MaintainUserLicense	Maintain user license	Enum
ManualPermissions	Container	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurableChildName	Securable child name	String	81
SecurableLabel	Label	String	255
SecurableName	Securable name	String	81
SecurableType	Securable type	Enum
TaskId	Task id	String	15
ViewUserLicense	View user license	Enum

UserSecGovEntryPointDuties (Duties for entry points)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
AllEntryPointsCount	All entry points	Integer
DiffEntryPointsCount	Count of different entry points	Integer
EntryPointRef	Entry point	RecId
LineNum	Line number	Real
MatchingEntryPointsCount	Matching entry points	Integer
ObjectAOTName	AOT name	String	81
ObjectDescription	Description	String	255
ObjectID	Securable object	RecId
ObjectLabel	Label	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Selected	Selected	Enum
UserId	UserId	String	20
UserLicenseType	License	Enum

UserSecGovEntryPointPrivileges (Privileges for entry points)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
AllEntryPointsCount	All entry points	Integer
DiffEntryPointsCount	Count of different entry points	Integer
EntryPointRef	Entry point	RecId
LineNum	Line number	Real
MatchingEntryPointsCount	Matching entry points	Integer
ObjectAOTName	AOT name	String	81
ObjectDescription	Description	String	255
ObjectID	Securable object	RecId
ObjectLabel	Label	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Selected	Selected	Enum
UserId	UserId	String	20
UserLicenseType	License	Enum

UserSecGovEntryPointRoles (Roles for entry points)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
AllEntryPointsCount	All entry points	Integer
EntryPointRef	Entry point	RecId
LineNum	Line number	Real
MatchingEntryPointsCount	Matching entry points	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurableName	Securable name	String	81
SecurableType	Securable type	Enum
SecurityRoleAOTName	AOT name	String	81
SecurityRoleDescription	Label	String	255
SecurityRoleName	Role name	String	255
SecurityRoleRefRecId	Reference	RecId
Selected	Selected	Enum
UserId	UserId	String	20
UserLicenseType	License	Enum

UserSecGovLicenseObjects (Licenses usage summary (preview))

Name	Label	Type	Length
BasicLicensePriceType	Basic user license	Enum
DutyIdentifier	Duty identifier	String	81
DutyName	Duty	String	255
ManualBasicLicensePriceType	Manually assigned license	Enum
ObjectType	License object type	Enum
PrivilegeIdentifier	Privilege identifier	String	81
PrivilegeName	Privilege	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoleIdentifier	Role identifier	String	81
RoleName	Role	String	255
UserId	User ID	String	20
UserLicense	User license (legacy)	Enum
UserLicenseActivity	Activity	Enum
UserLicenseActivityCount	Activity	Integer
UserLicenseCommerce	Commerce	Enum
UserLicenseCommerceCount	Commerce	Integer
UserLicenseEnterprise	Operations	Enum
UserLicenseEnterpriseCount	Operations	Integer
UserLicenseFinance	Finance	Enum
UserLicenseFinanceCount	Finance	Integer
UserLicenseHR	HR	Enum
UserLicenseHRCount	Human resources	Integer
UserLicenseNone	None	Enum
UserLicenseNoneCount	None	Integer
UserLicenseProject	Project	Enum
UserLicenseProjectCount	Project	Integer
UserLicenseSCM	SCM	Enum
UserLicenseSCMCount	Supply chain management	Integer
UserLicenseUniversal	Team Members	Enum
UserLicenseUniversalCount	Team members	Integer
UserLicenseWarning	License unknown	Enum
UserName	Operator name	String	60

UserSecGovLicensePrice (License prices)

Name	Label	Type	Length
LicensePriceType	Basic user license	Enum
Price	Price	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer

UserSecGovLicensePriceStaging (License prices)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LicensePriceType	Basic user license	Enum
Price	Price	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

UserSecGovLicensePriceUser (License users)

Name	Label	Type	Length
IsManual	Manual	Enum
LicensePriceType	Basic user license	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

UserSecGovObjectCreateUpdateHistory (Entry points history)

Name	Label	Type	Length
CreatedByUser	Created by	String	20
CreationDateTime	Created date and time	Date time
ModificationDateTime	Modified date and time	Date time
modifiedBy	Modified by	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecObjectGuidId	Element name	String	81

UserSecGovObjectCreateUpdateHistoryDetails (Details of entry points history)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
DependencyUpdate	Dependency update	Enum
NewSecData	New	Bin/Memo/Container
OrigSecData	Original	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecObjectGuidId	Element name	String	81

UserSecGovParameters (Parameters (preview))

Name	Label	Type	Length
AllowUnpublishedObjects	Allow unpublished objects	Enum
CheckSimilarity	Check similarity	Enum
Key	ID	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SimilarityValidationLevel	Level for similarity validation	Real
UserLicenseExcludeSysAdminRole	System administrator	Enum
UserLicenseExcludeUserGroupId	Group	String	10
UserStatPeriod1	Period 1	Integer
UserStatPeriod2	Period 2	Integer
UserStatPeriod3	Period 3	Integer
UserStatPeriod4	Period 4	Integer
UserStatPeriod5	Period 5	Integer

UserSecGovPrivilegedUserManagement (Privileged user management)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
EnableUserIfDisabled	User enabling	Enum
FromDateTime	From date/time (UTC)	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
ToDateTime	To date/time (UTC)	Date time
UserDisabledDateTime	User disabled	Date time
UserEnabledDateTime	User enabled	Date time
UserId	User ID	String	20

UserSecGovPrivilegedUserManagementRecording (Recordings)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FromDateTime	From date/time (UTC)	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PrivilegedUserManagementRecId	Privileged user management	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session ID	Integer
TaskRecorderData	System container	Bin/Memo/Container
ToDateTime	To date/time (UTC)	Date time
UserId	User ID	String	20

UserSecGovProcessRole (Processes)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	255
DisplayOrder	Display order	Real
ExportedAOTName	Exported AOT name	String	81
Level	Level	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Process name	String	60
NestedSetLeft	Reference	RecId
NestedSetRight	Reference	RecId
ParentProcRole	Process role	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefCategory	Security category (preview)	RecId
RefCompany	Company	String	4
State	State	Enum
Version	Version	String	10

UserSecGovProcessRoleRef (Process role to security role reference)

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
ProcessRole	Process role	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRole	Security role	RecId

UserSecGovRelatedObjects (Related entry points)

Name	Label	Type	Length
BasicLicensePriceType	Basic user license	Enum
CorrectAccess	Correct	Enum
CreateAccess	Create	Enum
DeleteAccess	Delete	Enum
DutyIdentifier	Duty identifier	String	81
DutyName	Duty	String	255
InvokeAccess	Invoke	Enum
PrivilegeIdentifier	Privilege identifier	String	81
PrivilegeName	Privilege	String	255
ReadAccess	Read	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Resource	Context \ Resource	String	255
ResourceHelpText	Help text	String	255
ResourceLabel	Label	String	255
ResourceType	Resource type	String	100
RoleIdentifier	Role identifier	String	81
RoleName	Role	String	255
SecurableType	Type	Enum
SubRoleIdentifier	Sub role identifier	String	81
SubRoleName	Sub role	String	255
UpdateAccess	Update	Enum
UserLicense	User license (legacy)	Enum
UserLicenseActivity	Activity	Enum
UserLicenseCommerce	Commerce	Enum
UserLicenseEnterprise	Operations	Enum
UserLicenseFinance	Finance	Enum
UserLicenseHR	HR	Enum
UserLicenseNone	None	Enum
UserLicenseProject	Project	Enum
UserLicenseSCM	SCM	Enum
UserLicenseUniversal	Team Members	Enum
UserLicenseWarning	License unknown	Enum

UserSecGovSecurityDuties (Duties)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
DutyName	Duty name	String	255
DutyRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurableName	Entry point name	String	255
SecurableType	Entry point type	Enum
UserId	UserId	String	20

UserSecGovSecurityObjectComparator (Compare results of security-related data, such as duties and privileges, by evaluating their entry points)

Name	Label	Type	Length
Identifier	Duty identifier	String	81
RecId	Record-ID	RecId
recVersion	Record Version	Integer

UserSecGovSecurityPrivileges (Privileges)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
PrivilegeName	Privilege name	String	81
PrivilegeRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurableName	Entry point name	String	255
SecurableType	Entry point type	Enum
UserId	UserId	String	20

UserSecGovSecurityRoles (Roles)

Name	Label	Type	Length
AccCorrect	Correct	Enum
AccCreate	Create	Enum
AccDelete	Delete	Enum
AccInvoke	Invoke	Enum
AccRead	Read	Enum
AccUpdate	Update	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurableName	Entry point name	String	255
SecurableType	Entry point type	Enum
SecurityRoleName	Role name	String	255
SecurityRoleRefRecId	Reference	RecId
UserId	UserId	String	20

UserSecGovSegregationOfDutiesRoleViolation (Roles violating segregation of duties rules (preview))

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
InfologParameters	Infolog text	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRole	Role name	Big integer
SegregationOfDutiesRule	Segregation of duties rules	RecId

UserSecGovSysSecObjectLookup (Select objects)

Name	Label	Type	Length
createdTransactionId	Created ID	Big integer
Identifier	Identifier	String	81
Name	Name	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer

UserSecGovTaskScript (Security tasks)

Name	Label	Type	Length
Description	Description	String	60
ExportedAOTName	Exported AOT name	String	81
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceName	Reference name	String	81
ReferenceType	Reference type	Enum
RefProcessRole	Process role	RecId
State	State	Enum
TaskId	Task id	String	15
Type	Source	Enum

UserSecGovTaskScriptDutyRef (Security task to security duty reference)

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
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityDuty	Security duty	RecId
TaskScript	Task script	RecId

UserSecGovTaskScriptPrivilege (Task privileges)

Name	Label	Type	Length
ExportedAOTName	Exported AOT name	String	81
RecId	Record-ID	RecId
recVersion	Record Version	Integer
State	State	Enum
TaskId	Task id	String	15

UserSecGovTaskScriptPrivilegeRef (Task privilege to security privilege reference)

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
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityPrivilege	Security privilege	RecId
TaskScriptPrivilege	Task script	RecId

UserSecGovTaskStep (Security task steps)

Name	Label	Type	Length
Description	Description	String	81
IsEntryPoint	Is entry point	Enum
LineNo	Line no.	Integer
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaskId	Task id	String	15

UserSecGovTemporaryRole (Temporary role management (preview))

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoleType	Type	Enum
SecurityRole	Role name	Big integer
TemporaryRoleUser	Temporary role user security	RecId

UserSecGovTemporaryRoleOrg (User role organization assignment)

Name	Label	Type	Length
OMHierarchyType	Reference	RecId
OMInternalOrganization	Internal organization	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRole	Reference	RecId
TemporaryRole	Reference	RecId

UserSecGovTemporaryRoleUser (Temporary role user security)

Name	Label	Type	Length
ActiveFromDateTime	Active start datetime (UTC)	Date time
ActiveToDateTime	Active end datetime (UTC)	Date time
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
FromDateTime	Start date/time (UTC)	Date time
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
TemporaryRoleUserType	Type	Enum
ToDateTime	End date/time (UTC)	Date time
UserId	User ID	String	20

UserSecGovUserRoleChangeLog (User role change log)

Name	Label	Type	Length
AddRemove	Add or remove	Enum
ChangedBy	Created by	String	20
createdDateTime	Created date and time	Date time
OMInternalOrganization	Internal organization	RecId
OMInternalOrganizationId	Organization number	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRole	Reference	RecId
SecurityRoleName	Role name	String	255
UserId	User ID	String	20

UserSecGovVersion (Security versions (preview))

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Version name	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum

UserSecGovVersionCompare (Security version comparisons)

Name	Label	Type	Length
CompletedDateTime	Completed date/time	Date time
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
Version1RefRecId	Security version	RecId
Version2RefRecId	Security version	RecId

UserSecGovVersionCompareRelatedObject (Security version comparison details)

Name	Label	Type	Length
ComparedCorrectAccess	Correct	Enum
ComparedCreateAccess	Create	Enum
ComparedDeleteAccess	Delete	Enum
ComparedInvokeAccess	Invoke	Enum
ComparedReadAccess	Read	Enum
ComparedUpdateAccess	Update	Enum
CompareId	Security version comparison	RecId
CorrectAccess	Correct	Enum
CreateAccess	Create	Enum
DeleteAccess	Delete	Enum
DutyIdentifier	Duty identifier	String	81
DutyName	Duty	String	255
EventType	Event type	Enum
InvokeAccess	Invoke	Enum
ObjectType	Security type	Enum
PrivilegeIdentifier	Privilege identifier	String	81
PrivilegeName	Privilege	String	255
ReadAccess	Read	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Resource	Context \ Resource	String	255
ResourceType	Resource type	String	100
RoleIdentifier	Role identifier	String	81
RoleName	Role	String	255
SecurableType	Type	Enum
SubRoleIdentifier	Sub role identifier	String	81
SubRoleName	Sub role	String	255
UpdateAccess	Update	Enum
UserLicense	User license (legacy)	Enum
VersionRefRecId	Security version	RecId

UserSecGovVersionContent (Version contents)

Name	Label	Type	Length
Content	XML document	Bin/Memo/Container
ContentType	Content type	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VersionRefRecId	Security version	RecId

UserSecGovVersionObjects (Security version objects)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedDateTime	Modified date and time	Date time
ObjectIdentifier	AOT name	String	81
ObjectName	Name	String	255
ObjectType	Security type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VersionRefRecId	Security version	RecId

UserSecGovVersionRelatedObjects (Related entry points)

Name	Label	Type	Length
CorrectAccess	Correct	Enum
CreateAccess	Create	Enum
DeleteAccess	Delete	Enum
DutyIdentifier	Duty identifier	String	81
DutyName	Duty	String	255
InvokeAccess	Invoke	Enum
ObjectType	Security type	Enum
PrivilegeIdentifier	Privilege identifier	String	81
PrivilegeName	Privilege	String	255
ReadAccess	Read	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Resource	Context \ Resource	String	255
ResourceType	Resource type	String	100
RoleIdentifier	Role identifier	String	81
RoleName	Role	String	255
SecurableType	Type	Enum
SubRoleIdentifier	Sub role identifier	String	81
SubRoleName	Sub role	String	255
UpdateAccess	Update	Enum
UserLicense	User license (legacy)	Enum
UserLicenseWarning	License unknown	Enum
VersionRefRecId	Security version	RecId

VendInvoiceImportedSalesTaxPendingAllocateTable (VendInvoiceImportedSalesTaxPendingAllocateTable)

Name	Label	Type	Length
ImportedSalesTax	Imported sales tax	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceTableId	Reference table ID	Integer

VivaIntEssHcmWorkerContactV2Staging (Worker contact v2 details(employee self-service))

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PersonnelNumber	Personnel number	String	25
PrimaryContactPhone	Contact number/address	String	255
PrimaryContactPhoneCallingCode	International calling code	String	5
PrimaryContactPhoneDescription	Description	String	60
PrimaryContactPhoneExtension	Extension	String	10
PrimaryContactPhoneIsPrimary	Primary	Enum
PrimaryContactPhonePurpose	Purpose	String	1000
PrimaryContactPhoneRoles	String 255	String	255
PrimaryContactPhoneType	Type	Enum
PrimaryElectronicAddressId	Electronic address Id	String	40
PrimaryPartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

VRMGlobalVendor (Global vendors)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FeedbackScore	Feedback score	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
URL	URL	String	255
VendorNumber	Global vendor number	String	100
VendorParty	Vendor name	RecId

WHSCrossDockingTemplateWorkCreationLineStaging (Planned cross docking work creation lines)

Name	Label	Type	Length
CrossDockingWorkTemplateId	Work template	String	20
CrossDockTemplateId	Cross docking template ID	String	20
DefinitionGroup	Processing group	String	60
DemandQuery	Packed query run	Bin/Memo/Container
DemandQueryJson	Demand query (JSON format)	Bin/Memo/Container
DemandType	Demand type	Enum
Description	Description	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PutLocationStorageCriteria	Locating type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SequenceNumber	Sequence number	Integer
TransferStatus	Staging to target status	Enum
WarehouseLocationDirectiveCode	Directive code	String	20

WHSCrossDockTemplateWorkCreationLine (Planned cross docking work creation lines)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CrossDockTemplateId	Cross docking template ID	String	20
DemandType	Demand type	Enum
Description	Description	String	60
LocatingType	Locating type	Enum
LocationDirectiveHintCode	Directive code	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PackedQueryRun	Packed query run	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SequenceNumber	Sequence number	Integer
WorkTemplateCode	Work template	String	20

WhsWorkUserAccessPolicy (Work user access policies)

Name	Label	Type	Length
AccessPolicyId	Access policy	String	10
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
InactivityTimeoutMinutes	Inactivity timeout (minutes)	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

WhsWorkUserAccessPolicyStaging (WhsWorkUserAccessPolicyStaging)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Description	Description	String	60
ExecutionId	Job ID	String	90
InactivityTimeoutMinutes	Inactivity timeout (minutes)	Integer
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
WorkUserAccessPolicyCode	Access policy	String	10