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

About

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

Removed tables

VendorPortalLockBox ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
LockOwner	Vendor portal lock owner	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer

New tables

AccountingDistributionCDR ()

Name	Label	Type	Length
AccountingDistribution	Reference	RecId
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

AssetIntercompanyTransferSourceStaging (Fixed assets intercompany transfer header)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Name	Name	String	60
ParentRowId	ParentRowId	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RowId	RowId	Integer
SourceCompany	Source legal entity	String	4
Status	Transfer status	Enum
TransferDate	Transfer date	Date
TransferId	Intercompany transfer ID	String	20
TransferStatus	Staging to target status	Enum

AssetIntercompanyTransferWorksheetLineStaging (Fixed assets intercompany transfer worksheet book details)

Name	Label	Type	Length
AcquisitionPrice	Acquisition price	Real
CurrentOperationsTax	Posting layer	Enum
DefinitionGroup	Processing group	String	60
Depreciation	Depreciation	Real
DestinationAssetBookId	Destination book	String	10
DestinationAssetGroup	Destination asset group	String	10
DestinationAssetId	Destination asset number	String	20
DestinationCompany	Destination legal entity	String	4
DestinationDefaultDimensionDisplayValue	Default dimension display value	String	500
ExecutionId	Job ID	String	90
FinTag_DisplayValue	Financial tag display value	Bin/Memo/Container
IsSelected	Select	Enum
NetBookValue	Net book value	Real
ParentRowId	ParentRowId	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RowId	RowId	Integer
SourceAssetBookId	Source book	String	10
SourceAssetGroup	Source asset group	String	10
SourceAssetId	Source asset number	String	20
SourceCompany	Source legal entity	String	4
TransferAcquisitionPrice	Acquisition transfer amount	Real
TransferAmountDepreciation	Depreciation transfer amount	Real
TransferId	Intercompany transfer ID	String	20
TransferNetBookValue	Net book transfer amount	Real
TransferStatus	Staging to target status	Enum
WorksheetLineNum	Line number	Real

AssetIntercompanyTransferWorksheetStaging (Fixed assets intercompany transfer worksheet)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DestinationAssetGroup	Destination asset group	String	10
DestinationAssetId	Destination asset number	String	20
DestinationCompany	Destination legal entity	String	4
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNum	Line number	Real
ParentRowId	ParentRowId	Integer
RateType	Rate type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RowId	RowId	Integer
ServiceLifeCaculationType	Service life	Enum
SourceAssetGroup	Source asset group	String	10
SourceAssetId	Source asset number	String	20
SourceCompany	Source legal entity	String	4
TransferAmount	Transfer amount	Real
TransferDate	Transfer date	Date
TransferId	Intercompany transfer ID	String	20
TransferMethod	Transfer method	Enum
TransferPercent	Percent	Real
TransferStatus	Staging to target status	Enum
TransferValueType	Transfer value method	Enum

AssetInventTransCDR ()

Name	Label	Type	Length
AssetInventTrans	Reference	RecId
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

AssetTransCDR ()

Name	Label	Type	Length
AssetTrans	Reference	RecId
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

AtlSCTTracingActivityDataCollection ()

Name	Label	Type	Length
ActivityId	Activity Id	String	20
Key	Key	String	64
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransactionContractRefRecId	Reference	RecId
Value	Value	String	256

AtlSCTTracingTransactionContract ()

Name	Label	Type	Length
ActivityId	Activity Id	String	20
DatePhysical	Physical date	Date
ErrorQty	Quantity	Real
GoodQty	Quantity	Real
InventBatchId	Batch number	String	20
InventDirection	In/Out	Enum
InventQty	Quantity	Real
InventSerialId	Serial number	String	20
ItemId	Item number	String	20
ProductType	ProductType	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UnitOfMeasureSymbol	Unit	String	10
VendAccount	Vendor account	String	20

BankAccountTransCDR ()

Name	Label	Type	Length
BankAccountTrans	Reference	RecId
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

BankPendingReviewDocument (Bank reconciliation temporary posting records)

Name	Label	Type	Length
BankAccountId	Bank account	String	10
BankCurrencyAmount	Amount	Real
BankReconciliationMatchingType	The matching type of bank reconciliation	Enum
BankTransType	Bank transaction type	String	10
CreditAmount	Credit	Real
DebitAmount	Debit	Real
Description	Description	String	512
DocumentNum	Document number	String	20
DocumentType	Document type	Enum
JournalNum	Journal batch number	String	20
LedgerJournalTrans	Reference	RecId
ManualMatchingType	The bank reconciliation manual matching types	Enum
PaymId	Payment ID	String	200
RecId	Record-ID	RecId
ReconciliationHeader	Reference	RecId
recVersion	Record Version	Integer
Reference	Payment reference	String	35
RelatedPartyAccount	Related party	String	30
RelatedPartyCompany	Company	String	4
RelatedPartyName	Related party name	String	160
RelatedPartyType	Related party type	Enum
Status	Status	String	20
TransactionCurrency	Transaction currency	String	3
TransactionCurrencyAmount	Transaction currency amount	Real
TransactionDate	Date	Date

BankStatementLinePendingPostingInformation (Bank statement line pending posting information)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AccountingDistributionTemplate	Template ID	RecId
BankReconciliationHeader	Reference	RecId
BankStmtISOReportEntry	Reference	RecId
BankTransType	Bank transaction type	String	10
DefaultDimension	Dimension	RecId
FinTag	Financial tag	RecId
OffsetDefaultDimension	Dimension	RecId
OffsetLedgerDimension	Offset account number	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TransactionTxt	Description	String	512

BusinessDocumentProjectInvoiceBaseV2Staging (Business document project invoice base V2)

Name	Label	Type	Length
CurrencyId	Sales currency	String	3
CustTableRecId	Record-ID	RecId
DataArea	Company	String	4
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InvoiceAccount	Customer account	String	20
InvoiceAccountAddress	Address	String	250
InvoiceAccountAddressAdditional	Address	String	250
InvoiceAccountName	Name	String	60
InvoiceAccountVATRegistrationNumber	Registration number	String	60
InvoiceAmount	Invoice amount	Real
InvoiceDate	Date	Date
IsSelected	Select	Enum
LedgerVoucher	Voucher	String	20
NumberSequenceGroupId	Number sequence group	String	10
OrderAccount	Order account	String	20
Prepayment	Prepayment	Enum
ProjInvoiceId	Invoice	String	50
ProjInvoiceJourRecId	Record-ID	RecId
ProjInvoiceJourTableId	Table ID	Integer
ProjInvoiceType	Invoice type	Enum
ProjInvoiceTypeStr	String 50	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SumLineDisc	Line discount	Real
TaxInvoiceSalesId_ID	Tax invoice ID - sales	String	50
TransferStatus	Staging to target status	Enum

BusinessDocumentProjInvoiceEmplLineV2Staging (Business document project invoice employee lines V2)

Name	Label	Type	Length
DataArea	Company	String	4
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InvoiceDate	Date	Date
IsSelected	Select	Enum
LedgerVoucher	Voucher	String	20
LineAmount	Line amount	Real
ProjInvoiceEmplRecId	Record-ID	RecId
ProjInvoiceEmplTableId	Table ID	Integer
ProjInvoiceId	Invoice	String	50
Qty	Hours	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesPrice	Price unit	Real
TaxAmount	Sales tax amount	Real
TaxGroupId	Sales tax group	String	10
TransDate	Project date	Date
TransferStatus	Staging to target status	Enum
TransId	Transaction ID	String	20
Txt	Description	String	255

BusinessProcessAgentTasks (Business process agent tasks)

Name	Label	Type	Length
Description	Description	String	150
IsEnabled	IsEnabled	Enum
Name	Employee onboarding copilot step	Enum
ProcessHeader	Business process	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaskId	Task ID	Guid
TaskName	Task	String	60

CDRTableProcessingExposureStatus ()

Name	Label	Type	Length
CountryLawReference	Country law reference	String	2
IsInitialSyncCompleted	IsInitialSyncCompleted	Enum
IsVirtualEntityEnabled	IsVirtualEntityEnabled	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TableName	Table name	String	81

CDRTableProcessingLastSysRowVersion ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
DependentTableName	Table name	String	81
IsInitialSyncCompleted	IsInitialSyncCompleted	Enum
LastSysRowVersion	LastSysRowVersion	Big integer
OperationType	Operation type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TableName	Table name	String	81

CDRTableProcessingQueue ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
OperationType	Operation type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceTableId	Reference table ID	Integer
TransDate1	Date	Date
TransDate2	Date	Date

ContactPersonCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
ContactPerson	Reference	RecId
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustInvoiceJour_WCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustInvoiceJour_W	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustInvoiceJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustInvoiceJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustInvoiceTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustInvoiceTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustPackingSlipJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustPackingSlipJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustPackingSlipTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustPackingSlipTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustQuotationTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustQuotationTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustSettlementCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustSettlement	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
CustTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

CustVendSettleDelayedSettlementContext (Delayed settlement context)

Name	Label	Type	Length
Balance01	Amount settled	Real
CashDiscToTake	Cash discount amount to take	Real
Code	Current specification code used for references	String	20
CrossRate	Cross rate	Real
CustTransId	Record-ID	RecId
ErrorCodePayment	Error code	String	30
FullSettlement	Full settlement	Enum
Payment	Payment	Enum
PaymentStatus	Payment status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefCompany	Company accounts ID	String	4
RefRecId	Marked	RecId
RefTableId	Reference table ID	Integer
SelectedDateUsedToCalcCashDisc	Date	Date
SpecCompany	Company accounts ID	String	4
SpecRecId	Reference	RecId
SpecTableId	Reference table ID	Integer
VendTransId	Record-ID	RecId

CustVendSettleRecoverSettlementTracking (Recover settlement log)

Name	Label	Type	Length
BatchJobId	Batch job ID	RecId
ContextRecId	Reference	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DelayedSettlementStatus	DelayedSettlementStatus	Enum
ExecutionId	ExecutionId	Guid
JournalNum	Journal batch number	String	20
Log	Log	Bin/Memo/Container
MessageSeverity	MessageSeverity	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
RecoverSettlementAction	Recover settlement action	Enum
recVersion	Record Version	Integer

DataQualityAgentTask (Tasks)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
JobId	JobId	Guid
Metadata	Metadata	Bin/Memo/Container
modifiedDateTime	Modified date and time	Date time
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetryAttempts	Retry attempts	Integer
Status	Status	Enum
TaskId	Task ID	Guid

DataQualityProfile (Data profiles)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
DateFilterFieldId	Field ID	Integer
DateFilterFieldTableId	Reference table ID	Integer
DefinitionClassId	Class ID	Integer
Description	Description	String	500
EstimationFormula	Formula	String	1000
EvaluationRecurrenceDays	Recurrence days	Integer
Instructions	Instructions	Bin/Memo/Container
IsActive	Active	Enum
MeasureFormula	Formula	String	1000
MeasureName	Name	String	60
MeasurePeriodDaysFrom	Start (relative to today)	Integer
MeasurePeriodDaysTo	End (relative to today)	Integer
MinObservationCount	Minimum observation count	Integer
modifiedDateTime	Modified date and time	Date time
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceQuery	Query	Bin/Memo/Container
TransactionDateFieldId	Field ID	Integer
TransactionDateFieldTableId	Reference table ID	Integer
VariancePercentageThreshold	Variance percentage threshold	Real

DataQualityProfileDimensionField (Profile dimension fields)

Name	Label	Type	Length
DimensionFieldId	Field ID	Integer
DimensionRelationType	DimensionRelationType	Enum
DimensionTableId	Reference table ID	Integer
Name	Name	String	60
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DataQualityProfileMonitor (Monitors)

Name	Label	Type	Length
DateFilterFieldId	Field ID	Integer
DateFilterFieldTableId	Reference table ID	Integer
Description	Description	String	500
MonitorPeriodDaysFrom	Start (relative to today)	Integer
MonitorPeriodDaysTo	End (relative to today)	Integer
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SelectionQuery	Query	Bin/Memo/Container

DataQualityProfilePredictionDimension (Prediction dimensions)

Name	Label	Type	Length
DimensionName	Name	String	60
LevelNumber	Level	Integer
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DataQualityProfileUpdateTarget (Update targets)

Name	Label	Type	Length
CurrentValueFormula	Formula	String	1000
Description	Description	String	500
Instructions	Instructions	Bin/Memo/Container
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TargetFieldId	Field ID	Integer
TargetQuery	Query	Bin/Memo/Container
TargetTableId	Reference table ID	Integer
UpdateValueFormula	Formula	String	1000

DataQualityRecommendation (Recommendations)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
ObeservationFromDateTime	From date	Date
ObeservationToDateTime	To date	Date
Priority	Priority	Integer
ProfileName	Data profile name	String	200
RecId	Record-ID	RecId
RecommendationDateTimeWindowEnd	End date/time	Date time
RecommendationDateTimeWindowStart	Start date/time	Date time
recVersion	Record Version	Integer
Status	Status	Enum
Summary	Summary	String	500
TaskId	Task ID	Guid

DataQualityRecommendationAction (Recommendation actions)

Name	Label	Type	Length
ActionType	Action type	Enum
createdDateTime	Created date and time	Date time
DataQualityRecommendation	Reference	RecId
Description	Description	String	255
IsUserAdjusted	User adjusted	Enum
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
UpdateParameters	UpdateParameters	Bin/Memo/Container

DataQualityRecommendationDimension (Recommendation dimensions)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
DataQualityRecommendation	Reference	RecId
DimensionName	Name	String	60
DimensionValue	Value	String	10
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DimensionAttributeAudit (Dimension operations audit)

Name	Label	Type	Length
CallStack	CallStack	Bin/Memo/Container
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
DimensionAttribute	Dimension name	RecId
DimensionOperation	Operation	Enum
DimensionStatus	Status	Enum
IsFromForm	IsFromForm	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
PreviousName	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DirPartyTableCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
DirPartyTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

DirPersonCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
DirPerson	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

DirPersonNameCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
DirPersonName	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ERFormatFileDestinationStaging (File destination)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ERFormatDestinationNamedTable_Name	Name	String	60
ERFormatFileDestinationTable_ConvertToPdf	Convert to PDF	Enum
ERFormatFileDestinationTable_DocumentType	Document type	Enum
ERFormatFileDestinationTable_EmailSource	Email source	String	600
ERFormatFileDestinationTable_EmailSourceType	Email source type	Enum
ERFormatFileDestinationTable_EmailSourceXML	XML document	Bin/Memo/Container
ERFormatFileDestinationTable_ExecuteActions	ERFormatFileDestinationTable_ExecuteActions	String	255
ERFormatFileDestinationTable_FileGuid	GUID string type	String	38
ERFormatFileDestinationTable_IsGrouped	ERFormatFileDestinationTable_IsGrouped	Enum
ERFormatFileDestinationTable_Name	Name	String	60
ERFormatFileDestinationTable_OfficeDocumentLayoutPropeties	XML document	Bin/Memo/Container
ERFormatFileDestinationTable_OfficeDocumentLayoutPropetiesFileName	File name	String	259
ERFormatFileDestinationTable_PdfConversionSettings	Source	Bin/Memo/Container
ERFormatFileDestinationTable_PdfConversionSettingsFileName	File name	String	259
ERFormatFileDestinationTable_SendFolderAs	Send folder as	Enum
ERFormatFileDestinationTable_Settings	Source	Bin/Memo/Container
ERFormatFileDestinationTable_SettingsFileName	File name	String	259
ERFormatFileDestinationTable_StopProcessingOnFailure	Stop processing on failure	Enum
ExecutionId	Job ID	String	90
Format_GUID	GUID	Guid
Format_Name	Name	String	60
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

FinTagWork (FinTag work tracking table)

Name	Label	Type	Length
ChunkingFactor	Chunking factor	Integer
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FinTagWorkProcess	FinTag Work Process	Enum
FromRecIdToFix	RecId from which a fix starts	RecId
MaxTimeInMinutesPerRun	Max time in minutes per run	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OverwriteExisting	Overwrite existing	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Reprocess	Reprocess	Enum
SkipValidation	Skip validation	Enum

GeneralJournalAccountEntryCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
GeneralJournalAccountEntry	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

GeneralJournalEntryCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
GeneralJournalEntry	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

GeneralLedgerBalanceCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
GeneralLedgerBalance	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

GeneralLedgerMainAccountBalanceCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
GeneralLedgerMainAccountBalance	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

GUPPricingRuleConditionLookup (Unified pricing rule lookup data)

Name	Label	Type	Length
AttributeValue1	Condition	String	1000
AttributeValue10	Condition	String	1000
AttributeValue11	Condition	String	1000
AttributeValue12	Condition	String	1000
AttributeValue13	Condition	String	1000
AttributeValue14	Condition	String	1000
AttributeValue15	Condition	String	1000
AttributeValue2	Condition	String	1000
AttributeValue3	Condition	String	1000
AttributeValue4	Condition	String	1000
AttributeValue5	Condition	String	1000
AttributeValue6	Condition	String	1000
AttributeValue7	Condition	String	1000
AttributeValue8	Condition	String	1000
AttributeValue9	Condition	String	1000
DisableMultiReference	DisableMultiReference	Enum
Exclusion	Exclusion	String	500
ExclusionType	Price rule exclusion type	Enum
PriceAttributeGroupName	Price attribute group	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RuleId	Rule id	RecId

GUPRetailDataMigrationDiscountOfferIdMapping ()

Name	Label	Type	Length
NewOfferId	Offer number	String	40
OriginalOfferId	Offer number	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionGuid	GUID	Guid

GUPRetailDataMigrationPriceGroupIdMapping ()

Name	Label	Type	Length
NewGroupId	New price group	String	10
OriginalGroupId	Original price group	String	10
PriceGroupType	Mapping type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

GUPRetailDataMigrationPriceGroupIdMappingStaging ()

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
NewGroupId	New price group	String	10
OriginalGroupId	Original price group	String	10
PriceGroupType	Mapping type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

GUPRetailDataMigrationPriceGroupLookup ()

Name	Label	Type	Length
CreatedPriceGroup	Retail price group	RecId
OriginalPriceGroup	Retail price group	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionGuid	GUID	Guid

GUPRetailDataMigrationPricingRuleLookup ()

Name	Label	Type	Length
AttributeName1	Attribute name	String	60
AttributeName2	Attribute name	String	60
AttributeName3	Attribute name	String	60
AttributeName4	Attribute name	String	60
AttributeName5	Attribute name	String	60
AttributeName6	Attribute name	String	60
AttributeName7	Attribute name	String	60
AttributeSourceLevel	AttributeSourceLevel	Enum
AttributeValue1	Condition	String	1000
AttributeValue2	Condition	String	1000
AttributeValue3	Condition	String	1000
AttributeValue4	Condition	String	1000
AttributeValue5	Condition	String	1000
AttributeValue6	Condition	String	1000
AttributeValue7	Condition	String	1000
Int64Name1	Attribute name	String	60
Int64Name2	Attribute name	String	60
Int64Name3	Attribute name	String	60
Int64Name4	Attribute name	String	60
Int64Value1	Int64Value1	Big integer
Int64Value2	Int64Value2	Big integer
Int64Value3	Int64Value3	Big integer
Int64Value4	Int64Value4	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RuleId	Record id	RecId
SessionGuid	GUID	Guid

GUPRetailDataMigrationProductVariantInventDimMapping ()

Name	Label	Type	Length
DistinctProductVariant	Reference	RecId
InventDimId	Dimension number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionGuid	GUID	Guid

GUPRetailDataMigrationRetailGroupMemberLineMapping ()

Name	Label	Type	Length
CreatedRecId	Retail price group	RecId
OriginalRecId	Retail price group	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionGuid	GUID	Guid

GUPRetailDataMigrationTracking ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
DestRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefTableId	Reference table ID	Integer
SessionGuid	GUID	Guid
SourceRecId	Reference	RecId

HcmJobDuration (Job durations)

Name	Label	Type	Length
Job	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidFrom	Activation	Date time
ValidTo	Retirement	Date time

HcmJobDurationStaging (Job durations)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
HcmJob_FK_JobId	Job	String	100
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
ValidFrom	Activation	Date time
ValidTo	Retirement	Date time

HcmOnboardTemplateAgentTasks (HcmOnboard template agent tasks)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	150
IsEnabled	IsEnabled	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Employee onboarding copilot step	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaskId	Task ID	Guid
TaskName	Task	String	60
TemplateHeader	Business process template	RecId

HREmployeeOnboardingStateTable (Employee onboarding copilot state table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Email	Email Id of employee	String	80
FailureMessage	Reason of failure	Bin/Memo/Container
FnOTaskName	Task name of onboarding checklist assigned to employee	String	60
IsOnboardingComplete	Employee onboarding completed successfully	Enum
IsSkipped	Skipped	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PersonnelNumber	Personnel number	String	25
RecId	Record-ID	RecId
recVersion	Record Version	Integer
State	Employee onboarding copilot state	Enum
Step	Employee onboarding copilot step	Enum

IndOpCodes_BR (Operation Indicator Codes)

Name	Label	Type	Length
IndOpCode	Operation Indicator Code	String	10
Name	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventJournalTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventJournalTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

InventTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

InventTransferJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventTransferJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

InventTransferJourLineCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventTransferJourLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

InventTransOriginCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventTransOrigin	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

InventTransPostingCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
InventTransPosting	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

IoTIntMfgJobProgressCounter (Job progress counter)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CurrentProducedQty	Current produced quantity	Integer
JobActive	Auto report job active	Enum
JobId	Job	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerJournalTableCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
LedgerJournalTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

LedgerJournalTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
LedgerJournalTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

LedgerTransVoucherLinkCDR ()

Name	Label	Type	Length
CDRDataAreaId	CDRDataAreaId	String	10
CountryLawReference	Country law reference	String	2
LedgerTransVoucherLink	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

LicensingUserEffectiveRoles (Licensing user effective roles table)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoleName	Role name	String	255
SecurityRole	Role name	Big integer
Source	Enum to differentiate directly assigned roles vs group assigned roles	Enum
UserId	User ID	String	20
UserObjectId	UserObjectId	Guid

LogisticsElectronicAddressCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
LogisticsElectronicAddress	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

LogisticsPostalAddressCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
LogisticsPostalAddress	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

LTMTaxGroupDetailStaging (Tax group detail)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxCode	Sales tax code	String	10
TaxGroupId	Set of taxes id	String	15
TransferStatus	Staging to target status	Enum

LTMTaxGroupStaging (Set of taxes)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroupId	Set of taxes id	String	15
TaxGroupName	Name of set of taxes	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingBaseBalanceStaging (Calculation basis)

Name	Label	Type	Length
CalculateOver	Calculated over	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Sign	+/-	Enum
TaxGroupId	Set of taxes id	String	15
TaxWithholdAmountType	Type of the amount	Enum
TaxWithholdCode	Withholding tax code	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingBaseDefStaging (Calculation basis)

Name	Label	Type	Length
CalculateOver	Calculated over	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Sign	+/-	Enum
TaxGroupId	Set of taxes id	String	15
TaxWithholdAmountType	Type of the amount	Enum
TaxWithholdCode	Withholding tax code	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingDocumentClassificationStaging (Withholding vouchers)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DocumentClassificationId	Document class Id	String	15
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxWithholdCode	Withholding tax code	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingGroupDetailStaging (Withholding group detail)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DocumentClassificationId	Document class Id	String	15
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxWithholdGroup	Withholding group id	String	15
TaxWithholdName	Withholding tax name	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingGroupStaging (Withholding Set)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxWithholdGroupId	Withholding group id	String	15
TaxWithholdGroupName	Withholding group name	String	30
TransferStatus	Staging to target status	Enum

LTMTaxWithholdingRangeValueStaging (Withholding range value)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FixedAmount	Fixed Amount	Real
FromAmount	From Amount	Real
FromDate	From date	Date
IsSelected	Select	Enum
MinAmount	Over amount	Real
Percentage	Percentage	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxWithholdCode	Withholding tax code	String	30
ToAmount	To Amount	Real
ToDate	To date	Date
TransferStatus	Staging to target status	Enum

LTMVendWithholdingStaging (Vendor withholding)

Name	Label	Type	Length
AccountNum	Account number	String	20
DefinitionGroup	Processing group	String	60
EnableReduction	Enable reduction	Enum
EnableValue	Enable Value	Enum
ExecutionId	Job ID	String	90
FromDate	Date from	Date
IsSelected	Select	Enum
OperationType	Operation type	Enum
PublicationDate	Date of Publication	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxesFilter	Taxes filter	Enum
ToDate	Date to	Date
TransferStatus	Staging to target status	Enum
Value	Value	Real
VoucherSelection	Vouchers distinction	Enum
WithholdingCode	Withholding tax code	String	30
WithholdingReduction	Reduction	Real
WithholdingSetID	Withholding tax group	String	30

LTMWithholdingSetWithCodesStaging (Withholding set and codes combinations)

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

LTMWithholdingTableStaging (Withholding code)

Name	Label	Type	Length
CalcAccumulated	Calculate Accumulated	Enum
CalculateOver	Calculated over	Enum
CalFirstPayment	Calculated on the First Payment	Enum
DefinitionGroup	Processing group	String	60
DocNum	Document No	String	30
DocTypeId	Country document type	String	15
DocumentClassificationId	Document class Id	String	15
ExecutionId	Job ID	String	90
FiscalCalendar	Fiscal calendar	Enum
InterPeriod	Interval of Period	Enum
IsSelected	Select	Enum
MinAccumAmntToWithhold	Minimum accumulated amount to calculate withholding	Real
MinAmountSResta	Subtract minimum subject amount	Enum
MMinimun	Minimum subject amount	Real
MWithholding	Minimum Withholding	Real
NumberUnits	Number of units	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Retroactive	Retroactive	Enum
TransferStatus	Staging to target status	Enum
WithholdingCode	Withholding tax code	String	30
WithholdingName	Withholding tax name	String	60

MarkupTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
MarkupTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

MCPAllowedClientTable (Allowed MCP clients)

Name	Label	Type	Length
Allowed	Allowed	Enum
ClientId	ClientId	String	38
ClientName	Name	String	100
createdBy	Created by	String	20
IsFirstParty	IsFirstParty	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

NBSCodes_BR (NBS codes)

Name	Label	Type	Length
Name	Description	String	60
NBSCode	NBS code	String	9
RecId	Record-ID	RecId
recVersion	Record Version	Integer

NBSIndOpCodeRelation_BR (Relation between NBS Codes and Operator Indicator Codes)

Name	Label	Type	Length
IndOpCodeRefRecId	Reference	RecId
NBSCodeRefRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

NoSaleFiscalDocumentTransaction_BRStaging (No-sales fiscal document)

Name	Label	Type	Length
Channel	Channel	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OriginalStoreId	Store number	String	10
OriginalTerminalId	Register number	String	10
OriginalTransactionId	Transaction number	String	44
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

ProcCategoryDelivery (Procurement Category Delivery)

Name	Label	Type	Length
DeliveryDataAreaId	Company	String	4
OverDeliveryPct	Overdelivery	Real
ProcurementCategory	Category	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UnderDeliveryPct	Underdelivery	Real

ProcurementProductCategoryDeliveryAssignmentStaging (Procurement Product Category Delivery Assignments)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DeliveryDataAreaId	Company	String	4
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OverDeliveryPct	Overdelivery	Real
ProductCategoryHierarchyName	Product category hierarchy name	String	128
ProductCategoryName	Product category name	String	254
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
UnderDeliveryPct	Underdelivery	Real

ProdBatchOrderRouteOperationResourceRequirementStaging (Batch order route operation resource requirements)

Name	Label	Type	Length
BatchOrderNumber	Production	String	20
BatchOrderRouteOperationNumber	Operation number	Integer
BatchOrderRouteOperationPriority	Priority	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
MinimumRequiredCapabilityLevel	Minimum level needed	Real
RecId	Record-ID	RecId
RecordId	Record-ID	RecId
recVersion	Record Version	Integer
RequiredCapabilityName	Capability	String	60
RequiredCertificateType	Certificate type	String	15
RequiredCourseId	Course ID	String	10
RequiredOperationsResourceGroupId	Resource group	String	10
RequiredOperationsResourceId	Resource	String	10
RequiredOperationsResourceType	Resource type	Enum
RequiredSkillId	Skill	String	15
RequiredSkillLevel	Level	String	10
RequiredTitleId	Title	String	65
TransferStatus	Staging to target status	Enum
WillJobSchedulingUseRequirement	Job scheduling	Enum
WillOperationSchedulingUseRequirement	Operations scheduling	Enum

ProdBatchOrderRouteOperationStaging (Batch order route operations)

Name	Label	Type	Length
AccumulatedScrapPercentage	Accumulated scrap percentage	Real
BatchOrderNumber	Batch number	String	20
CostingOperationResourceId	Costing resource	String	10
DefaultLedgerDimensionDisplayValue	Default dimension display value	String	500
DefinitionGroup	Processing group	String	60
EstimatedOperationQuantity	Estimated operation quantity	Real
EstimatedProcessTime	Estimated process time	Real
EstimatedSetupTime	Setup	Real
ExecutionId	Job ID	String	90
IsConstantConsumptionReleased	Constant released	Enum
IsOperationCompleted	Is operation completed	Enum
IsOperationStarted	Is operation started	Enum
IsSelected	Select	Enum
LoadPercentage	Load percentage	Real
NextOperationLinkType	Next operation link type	Enum
NextOperationNumber	Next operation number	Integer
OperationId	Operation	String	10
OperationNumber	Operation number	Integer
OperationPriority	Priority	Enum
OperationsTimeToHourConversionFactor	Hours/time	Real
OverlapOperationQuantity	Overlap quantity	Real
ProcessCompletionPercentage	Processing percentage - process	Real
ProcessCostCategoryId	Process category id	String	30
ProcessProductionJobId	Process job ID	String	20
ProcessQuantity	Process quantity	Real
ProcessTime	Run time	Real
QuantityCostCategoryId	Quantity cost category id	String	30
QueueTimeAfter	Queue time after	Real
QueueTimeBefore	Queue time before	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResourceQuantity	Resource quantity	Integer
RouteGroupId	Route group	String	10
RouteOperationRateMethod	Hourly rate / piecework rate	Enum
RouteOperationRemainderStatus	Remain status	Enum
RouteOperationSequence	Route level	Integer
RouteType	Route type	Enum
ScheduledEndDate	End date	Date
ScheduledEndTime	End time	Time
ScheduledFromDate	Start date	Date
ScheduledFromTime	Start time	Time
ScrapPercentage	Scrap percentage	Real
SetupCompletionPercentage	Processing percentage - setup	Real
SetupCostCategoryId	Setup cost category id	String	30
SetupProductionJobId	Set up job ID	String	20
SetupTime	Setup time	Real
TransferBatchQuantity	Transfer batch	Real
TransferStatus	Staging to target status	Enum
TransitTime	Transit time	Real
WorkingTimeSchedulingPropertyId	Property	String	10

ProjActualsArchiveTrans (Project actuals archive transactions)

Name	Label	Type	Length
ArchiveDataAreaId	Company	String	4
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EndDateTime	To date time	Date time
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDateTime	From date time	Date time
TransType	Transaction type	Enum

ProjCDSActualsImportHistory (Project actuals import)

Name	Label	Type	Length
AccountingAmount	Accounting amount	Real
AccountingDate	Accounting date	Date
ActivityNumber	Activity number	String	50
ActualId	Actual ID	Guid
ActualsIdSearch	ActualIdSearch	String	60
ActualsImportId	Actuals import id	Guid
AdjustmentAmount	Adjustment amount	Real
AdjustmentDate	Adjustment date	Date
AdjustmentStatus	Adjustment status	Big integer
Amount	Amount	Real
AmountMST	Amount	Real
ArchiveServiceJobId	Service job id	Guid
BillingStatusId	Billing status ID	Big integer
BillingType	Billing type	Enum
BookableResourceName	Bookable resource name	String	60
ContractId	Project contract ID	String	20
ContractingUnit	Contracting unit	Guid
ContractLine	Contract line	Integer
ContractLineId	Contract line ID	String	10
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustomerAccountNumber	Account number	String	20
Description	Description	String	255
DocumentDate	Document date	Date
EndDate	End date	Date time
ExchangeRate	Exchange rate	Real
ExchangeRateDate	Exchange rate date	Date
ExternalDescription	External description	String	255
ExternalOriginReference	External origin reference	String	50
ExternalReference	External reference	String	60
FeeAmount	Fee Amount	Real
FeeProjAdvancedJournalLine	Project fee advanced journal line	RecId
FundingSourceId	Funding source ID	String	20
IntegrationCount	Integration count	Integer
inventBatchId	Batch number	String	20
InventLocationId	Warehouse	String	10
inventSerialId	Serial number	String	20
InventSiteId	Site	String	10
InvoiceId	Invoice ID	String	50
InvoiceProposalFeeLineTransId	Transaction ID	String	20
InvoiceProposalId	Invoice proposal	String	50
InvoiceProposalLineTransId	Transaction ID	String	20
IsDuplicate	Duplicate	Enum
IsJournalized	Journalized	Enum
IsProcessed	Processed	Enum
LineDiscount	Line discount	Real
MatchedVendorInvoice	Matched Vendor Invoice	String	100
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OwningBusinessId	Owning business ID	Guid
OwningUser	Owning user	Guid
ProductDescription	Description	String	255
ProductNumber	Product number	String	70
ProjActualsIntegrationStatus	Integration status	Enum
ProjAdvancedJournalLine	Project advanced journal line	RecId
ProjBegBalJournalTransCostSales	Beginning balance journal line(Exp/Hour/Item)	RecId
ProjBegBalJournalTransFee	Beginning balance journal line(Fee)	RecId
ProjBegBalJournalTransOnAcc	Beginning balance journal line(On-Account)	RecId
ProjectDataAreaId	Project company	String	4
ProjectId	Project ID	String	20
ProjExternalRefSourceDocType	External reference source document type	Enum
ProjTransId	Transaction ID	String	20
Quantity	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResourceId	Resource ID	Guid
ResourceOperationUnitId	Resource operation unit ID	Guid
ResourcingCompany	Resourcing company	String	4
SalesTaxAmount	Sales tax amount	Real
StartDate	Start date	Date time
Status	Status	Big integer
StatusReason	Status reason	Big integer
SubConInvoiceId	Subcontract Invoice ID	String	50
SubConProductReceiptId	Product receipt	String	20
SubcontractLine	Subcontract Line	String	20
SyncRetryCount	SyncRetryCount	Integer
TaskId	Task ID	Guid
TransactionCategory	Transaction category	Guid
TransactionCategoryId	Category ID	String	28
TransactionClassification	Transaction classification	Big integer
TransactionCurrencyId	Transaction currency	String	3
TransType	Transaction type	Enum
UnitOfMeasure	Unit	String	10
UnitPrice	Unit price	Real
UnitPriceMST	Unit price in monetary standard (national currency)	Real
VendInvoiceLineProjTransId	Transaction ID	String	20
VoucherNumber	Voucher number	String	20
wMSLocationId	Location	String	10

ProjCDSTransactionRelationshipImportHistory (Project transaction relationship import)

Name	Label	Type	Length
ConnectionId	Connection ID	Guid
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
SyncRetryCount	SyncRetryCount	Integer
Transaction1Id	Transaction ID 1	Guid
Transaction1Role	Transaction role 1	String	100
Transaction1Type	Transaction type 2	String	100
Transaction2Id	Transaction ID 2	Guid
Transaction2Role	Transaction role 2	String	100
Transaction2Type	Transaction type 2	String	100
TransactionRelationshipId	Transaction relationship id	Guid

ProjInvoiceCostCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceCost	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjInvoiceEmplCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceEmpl	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjInvoiceItemCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceItem	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjInvoiceJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjInvoiceOnAccCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceOnAcc	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjInvoiceRevenueCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjInvoiceRevenue	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjItemTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
ProjItemTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ProjLedgerJournalTableSync (Store data about Journal header records being created in Dataverse)

Name	Label	Type	Length
ConfirmJournalRetryCount	ConfirmJournalRetryCount	Integer
createdDateTime	Created date and time	Date time
DataverseGuid	DataverseGuid	Guid
LastDVConfirmDateTime	LastDVConfirmDateTime	Date time
LastRetriedDateTime	LastRetriedDateTime	Date time
modifiedDateTime	Modified date and time	Date time
PostStatus	Dataverse journal post status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	RefRecId	Big integer
RetryCount	RetryCount	Integer
SyncStatus	Dataverse journal sync status	Enum

ProjLedgerJournalTransSync (Store data about Journal line records being created in Dataverse)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
DataverseCostGuid	DataverseCostGuid	Guid
DataverseSalesGuid	DataverseSalesGuid	Guid
LastRetriedDateTime	LastRetriedDateTime	Date time
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	RefRecId	Big integer
RetryCount	RetryCount	Integer
SyncStatus	Dataverse journal sync status	Enum

PSSerialLineStagingV2 (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

PurchCopilotDMAEvent (Disruption events)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Impact	Impact	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Source	Disruption source selection type	Enum
SourceRefRecId	Reference	RecId

PurchCopilotDMAEventTarget (Disruption event target details)

Name	Label	Type	Length
EventRecId	Reference	RecId
NewFieldValue	New value	String	60
OldFieldValue	Old value	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TargetFieldId	Field ID	Integer
TargetRefRecId	Reference	RecId
TargetTableId	Table ID	Integer

PurchCopilotDMAImpactAnalysisJob (Disruption mitigation agent analysis job)

Name	Label	Type	Length
EventRecId	Reference	RecId
Impact	Impact	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Impact analysis job status	Enum

PurchCopilotDMAImpactAnalysisJobEventTarget (Disruption mitigation agent analysis job targets)

Name	Label	Type	Length
EventTargetRecId	Reference	RecId
ImpactAnalysisJobRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotDMAImpactAnalysisTask ()

Name	Label	Type	Length
AgentTaskRecId	Reference	RecId
Configuration	Agent configuration	Bin/Memo/Container
ConfigurationHistoryRecId	Reference	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Desciption	Bin/Memo/Container
LastRun	Last run	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

QMSCAPACaseAssociationDimensionStaging (CAPA case association dimensions)

Name	Label	Type	Length
CaseId	Case ID	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ImpactedCatchWeightQuantity	Impacted catch weight quantity	Real
ImpactedCatchWeightUnitId	CW unit	String	10
ImpactedQuantity	Impacted quantity	Real
ImpactedUnitId	Unit	String	10
InventoryOwnerId	Owner	String	40
InventorySiteId	Site	String	10
InventoryStatusId	Inventory status	String	10
InventoryWarehouseId	Warehouse	String	10
IsSelected	Select	Enum
ItemBatchNumber	Batch number	String	20
ItemNumber	Item number	String	20
ItemSerialNumber	Serial number	String	20
LicensePlateNumber	License plate	String	25
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
WarehouseLocationId	Location	String	10

QMSCAPACaseEmailNotificationStaging (Email notification list)

Name	Label	Type	Length
CaseId	Case ID	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNumber	Line	Real
PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SendNoticeOnActivityStatusClosed	Closed Activity	Enum
SendNoticeOnActivityStatusReopened	Reopened Activity	Enum
SendNoticeOnCaseStatusCancelled	Canceled CAPA Status	Enum
SendNoticeOnCaseStatusClosed	Closed CAPA Status	Enum
SendNoticeOnCaseStatusInProcess	Reopened CAPA Status	Enum
TransferStatus	Staging to target status	Enum
WorkerGroupId	CAPA worker group	String	20

QMSCAPACaseStaging (CAPA cases)

Name	Label	Type	Length
AnswerId	Answer	String	10
BillingProjectId	Billing project	String	20
CAPACaseClassification	Case classification	Enum
CAPACategoryId	CAPA category	String	20
CAPAClassificationCode	Major/Minor classification code	String	10
CAPAClassificationCodeId	Major/Minor classification code	String	10
CAPACreatedDate	Creation date	Date
CAPADueDate	Due date	Date
CAPAResolutionNote	CAPA resolution note	Bin/Memo/Container
CAPAResolutionSummary	CAPA resolution	String	100
CAPAResolutionTypeId	CAPA resolution type	String	10
CAPARootCauseCode	Root cause code	String	20
CAPARootCauseCodeId	Root cause code	String	20
CAPASourceCode	CAPA source	String	10
CAPASourceCodeId	CAPA source	String	10
CAPASubCategoryId	CAPA subcategory	String	20
CAPATypeId	CAPA type	String	20
CaseCreatedDateAndTime	Created date and time	Date time
CaseId	Case ID	String	10
CaseStatus	Status	Enum
ClosedBy	Closed by	String	20
ClosedDateAndTime	Closed date and time	Date time
Compliance	Compliance	Real
ContactId	Contact ID	String	20
DefinitionGroup	Processing group	String	60
DepartmentNumber	Department number	String	30
Description	Description	String	60
EmailId	Email ID	String	10
EmployeeResponsibleName	Name	String	160
EmployeeResponsiblePersonnelNumber	Personnel number	String	25
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Name	Name	String	160
Notes	Notes	Bin/Memo/Container
PartyNumber	Party ID	String	40
PlannedEffectiveDate	Planned effective date	Date
Priority	Priority	String	20
ProcessId	Case process	String	20
QuestionnaireId	Questionnaire	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Resolution	Resolution	Enum
ServiceLevelAgreementId	Service level agreement	String	10
ServiceLevelAgreementStatus	Status	Enum
ServiceLevelCompletionDate	Completion date	Date time
ServiceStageId	Service stage	String	10
TransferStatus	Staging to target status	Enum

QMSCAPARootCauseStaging (CAPA root causes)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RootCauseCode	Root cause code	String	20
RootCauseDescription	Description	String	60
TransferStatus	Staging to target status	Enum

QMSCAPATypeStaging (CAPA types)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
TypeDescription	CAPA type description	String	60
TypeId	CAPA type	String	20

QMSSampleAssociationProcedureStaging (Quality sample association procedures)

Name	Label	Type	Length
AssociationItemCode	Item code	Enum
AssociationItemRelation	Item	String	20
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleProcedureId	Sample procedure ID	String	10
TransferStatus	Staging to target status	Enum

QMSSampleAssociationStaging (Quality sample associations)

Name	Label	Type	Length
ContinuousSampleTypeId	Continuous sample type	String	10
ContinuousScrapDays	Continuous sample scrap in days	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InlineDefaultItemSamplingId	Default item sampling for inline	String	10
InlineDefaultTestGroupId	Default inline test group	String	10
InlineSampleTypeId	Inline sample type	String	10
InlineScrapDays	Inline sample scrap in days	Integer
IsSelected	Select	Enum
ItemCode	Item code	Enum
ItemRelation	Item	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSSampleAuditLogStaging (Quality sample audit logs)

Name	Label	Type	Length
AuditReference	Reference	String	100
ChangeFromValue	From	String	50
ChangeToValue	To	String	50
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNumber	Line number	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleEventType	Sample event	Enum
SampleId	Sample ID	String	20
TransferStatus	Staging to target status	Enum

QMSSampleLabelLayoutStaging (Quality sample label layouts)

Name	Label	Type	Length
AreExistingFieldNamesUsedInLabel	Use field name	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LabelLength	Label length (inches)	Integer
LabelPrintDensity	Print density	Enum
LabelWidth	Label width (inches)	Integer
LayoutDescription	Description	String	60
LayoutId	Label layout	String	20
LayoutTemplate	ZPL	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSSampleLifecycleStateStaging (Quality sample lifecycle states)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsQualityOrderCreated	Quality order created	Enum
IsQualityOrderValidated	Quality order validated	Enum
IsSampleScrapped	Sample scrapped	Enum
IsSelected	Select	Enum
LifecycleStateDescription	Sample lifecycle state description	String	60
LifecycleStateId	Sample lifecycle state	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

QMSSampleProcedureStaging (Quality sample procedures)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InspectionMethod	Sample inspection method	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleProcedureDescription	Description	String	60
SampleProcedureDetails	Sample procedure details	Bin/Memo/Container
SampleProcedureId	Sample procedure ID	String	10
SampleProcedureTypeId	Sample procedure type	String	10
TransferStatus	Staging to target status	Enum

QMSSampleProcedureTypeStaging (Quality sample procedure types)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleProcedureTypeDescription	Description	String	60
SampleProcedureTypeId	Sample procedure type	String	10
TransferStatus	Staging to target status	Enum

QMSSampleStaging (Quality samples)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InventoryLotId	Lot ID	String	20
InventoryOwnerId	Owner	String	40
InventorySiteId	Site	String	10
InventoryStatusId	Inventory status	String	10
InventoryWarehouseId	Warehouse	String	10
IsSelected	Select	Enum
ItemBatchNumber	Batch number	String	20
ItemNumber	Item number	String	20
ItemSamplingId	Item sampling	String	10
ItemSerialNumber	Serial number	String	20
LicensePlateNumber	License plate	String	25
LifecycleStateId	Sample lifecycle state	String	10
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductionOrderNumber	Production	String	20
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
QualityOrderId	Quality order	String	20
QualityTestGroupId	Test group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegisteredByWorkerPersonnelNumber	Personnel number	String	25
RegisteredDateTime	Registered date time	Date time
SampleExpirationDate	Expiration date	Date
SampleId	Sample ID	String	20
SampleInspectionMethod	Sample inspection method	Enum
SampleLabelLayoutId	Label layout	String	20
SampleQuantity	Quantity	Real
SampleTypeId	Sample type	String	10
SampleUnitId	Unit	String	10
ScrappedByWorkerPersonnelNumber	Personnel number	String	25
ScrappedDateTime	Scrapped date time	Date time
TestedByWorkerPersonnelNumber	Personnel number	String	25
TestedDateTime	Tested date time	Date time
TransferStatus	Staging to target status	Enum
WarehouseLocationId	Location	String	10

QMSSampleTrackingEntryStaging (Quality sample tracking entries)

Name	Label	Type	Length
CreationSequenceNumber	Sample creation sequence number	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InventoryLotId	Lot ID	String	20
InventoryOwnerId	Owner	String	40
InventorySiteId	Site	String	10
InventoryStatusId	Inventory status	String	10
InventoryWarehouseId	Warehouse	String	10
IsManualQualityOrder	Is manual quality order	Enum
IsManualSample	Is manual sample	Enum
IsSelected	Select	Enum
ItemBatchNumber	Batch number	String	20
ItemNumber	Item number	String	20
ItemSerialNumber	Serial number	String	20
LicensePlateNumber	License plate	String	25
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductionOrderNumber	Production	String	20
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
QualityOrderId	Quality order	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleId	Sample ID	String	20
TransferStatus	Staging to target status	Enum
WarehouseLocationId	Location	String	10

QMSSampleTypeStaging (Quality sample types)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleInspectionMethod	Sample inspection method	Enum
SampleLabelLayoutId	Label layout	String	20
SampleTypeDescription	Description	String	60
SampleTypeId	Sample type	String	10
TransferStatus	Staging to target status	Enum

QMSSampleTypeStateAssignmentStaging (Quality sample type state assignment)

Name	Label	Type	Length
AssignmentLineNumber	Line	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SampleLifecycleStateId	Sample lifecycle state	String	10
SampleTypeId	Sample type	String	10
TransferStatus	Staging to target status	Enum

RCashTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RCashTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

ReconciliationAutomationAdjustmentJournalLink (Reconciliation voucher summary adjustment journal link)

Name	Label	Type	Length
JournalNum	Journal batch number	String	20
JournalPosted	Posted	Enum
LedgerJournalTable	Reference	RecId
LedgerJournalTableOffset	Reference	RecId
RecId	Record-ID	RecId
ReconciliationAutomationVoucherSummary	Reconciliation automation voucher summary	RecId
recVersion	Record Version	Integer

ReconciliationAutomationMatchSuggestion (Reconciliation automation framework table)

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
Score	Score	Real
SourceId	SourceId	Big integer

ReconciliationAutomationMatchSuggestionLine (Reconciliation automation framework table)

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
ReconciliationAutomationMatchSuggestion	Reference	RecId
recVersion	Record Version	Integer
TargetId	TargetId	Big integer

RetailAsyncCustomerAffiliationStaging (Retail async customer affiliation)

Name	Label	Type	Length
ChannelReferenceId	Channel Reference Identifier	String	38
CustAccount	Customer account	String	20
CustAccountAsync	Customer account	String	38
DefinitionGroup	Processing group	String	60
Description	Description	String	255
ExecutionId	Job ID	String	90
HideInChannels	Hide in channels	Enum
IsSelected	Select	Enum
LanguageId	Language	String	7
LastKnownError	Last known error	Bin/Memo/Container
Name	Name	String	64
OMOperatingUnit_PartyNumber	Party ID	String	40
OnlineOperationCompleted	OnlineOperationCompleted	Enum
Operation	Retail Async Operation	Enum
OperationId	Operation ID	String	38
OperationTimeStamp	Operation Timestamp	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
TransferStatus	Staging to target status	Enum

RetailAsyncCustomerContactStaging (Retail async customer contact)

Name	Label	Type	Length
Changes	Changes	Bin/Memo/Container
ChannelReferenceId	Channel Reference Identifier	String	38
CustAccount	Customer account	String	20
CustAccountAsync	Customer account	String	38
DefinitionGroup	Processing group	String	60
Description	Description	String	60
ExecutionId	Job ID	String	90
IsMobilePhone	Mobile	Enum
IsPrimary	Primary	Enum
IsPrivate	Private	Enum
IsSelected	Select	Enum
LastKnownError	Last known error	Bin/Memo/Container
Locator	Contact number/address	String	255
LocatorExtension	Extension	String	10
OMOperatingUnit_PartyNumber	Party ID	String	40
OnlineOperationCompleted	OnlineOperationCompleted	Enum
Operation	Retail Async Operation	Enum
OperationId	Operation ID	String	38
OperationTimeStamp	Operation Timestamp	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
RetailMarketingOptIn	Marketing opt-in	Enum
TransferStatus	Staging to target status	Enum
Type	Type	Enum

RetailAsyncCustomerStaging (Retail async customer)

Name	Label	Type	Length
AddressEmail	Contact number/address	String	255
AddressName	Name	String	160
AddressPhone	Telephone	String	20
AddressTaxGroup	Sales tax group	String	10
AddressType	Type	Enum
AddressUrl	Internet address	String	255
Blocked	Invoicing and delivery on hold	Enum
BuildingComplement	Building complement	String	60
CellularPhone	Mobile phone	String	20
City	City	String	60
cnpjCpfNum_BR	CNPJ/CPF	String	20
ContactPersonId	Contact ID	String	20
Country	Country/region	String	10
County	County	String	30
CreditMax	Credit limit	Real
Currency	Currency	String	3
CustAccount	Customer account	String	20
CustAccountAsync	Customer account	String	38
CustGroup	Customer group	String	10
CustName	Name	String	160
DefinitionGroup	Processing group	String	60
DistrictName	District	String	60
Email	Contact number/address	String	255
EndDisc	Total discount group	String	10
ExecutionId	Job ID	String	90
FirstName	First name	String	50
IdentificationNumber	ID number	String	50
InvoiceAccount	Invoice account	String	20
IsSelected	Select	Enum
LanguageId	Language	String	7
LastName	Last name	String	50
LineDisc	Line discount group	String	10
MandatoryCreditLimit	Mandatory credit limit	Enum
MiddleName	Middle name	String	50
MultiLineDisc	Multiline disc. group	String	10
OnlineCustCreated	OnlineCustCreated	Enum
OrganizationId	National Registry number	String	10
Phone	Telephone	String	20
PhoneExtension	Extension	String	10
PriceGroup	Price group	String	10
ReceiptEmail	Receipt email	String	80
ReceiptOption	Receipt option	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelationshipType	Relation type field	Big integer
ReplicationCounterFromOrigin	Replication counter	Integer
RetailCustAffiliations	RetailCustAffiliations	Bin/Memo/Container
State	State	String	10
StoreRecId	StoreRecId	Big integer
Street	Street	String	250
StreetNumber	Street number	String	20
TaxGroup	Sales tax group	String	10
TransferStatus	Staging to target status	Enum
Url	Internet address	String	255
UseOrderNumberReference	Use order number reference	Enum
UsePurchRequest	Purchase request required	Enum
VatNum	Tax exempt number	String	20
ZipCode	ZIP/postal code	String	10

RetailAsyncCustomerV2Staging (Retail async customer (V2))

Name	Label	Type	Length
AddressEmail	Contact number/address	String	255
AddressName	Name	String	160
AddressPhone	Telephone	String	20
AddressTaxGroup	Sales tax group	String	10
AddressType	Type	Enum
AddressUrl	Internet address	String	255
Blocked	Invoicing and delivery on hold	Enum
BuildingComplement	Building complement	String	60
CellularPhone	Mobile phone	String	20
Changes	Changes	Bin/Memo/Container
City	City	String	60
cnpjCpfNum_BR	CNPJ/CPF	String	20
ContactPersonId	Contact ID	String	20
Country	Country/region	String	10
County	County	String	30
CreditMax	Credit limit	Real
Currency	Currency	String	3
CustAccount	Customer account	String	20
CustAccountAsync	Customer account	String	38
CustGroup	Customer group	String	10
CustName	Name	String	160
DefinitionGroup	Processing group	String	60
DistrictName	District	String	60
Email	Contact number/address	String	255
EndDisc	Total discount group	String	10
ExecutionId	Job ID	String	90
FirstName	First name	String	50
IdentificationNumber	ID number	String	50
InvoiceAccount	Invoice account	String	20
IsSelected	Select	Enum
LanguageId	Language	String	7
LastKnownError	Last known error	Bin/Memo/Container
LastName	Last name	String	50
LineDisc	Line discount group	String	10
MandatoryCreditLimit	Mandatory credit limit	Enum
MiddleName	Middle name	String	50
MultiLineDisc	Multiline disc. group	String	10
OMOperatingUnit_PartyNumber	Party ID	String	40
OnlineOperationCompleted	OnlineOperationCompleted	Enum
Operation	Retail Async Operation	Enum
OperationId	Operation ID	String	38
OperationTimeStamp	Operation Timestamp	Date time
OptOutPersonalization	Disable personalization	Enum
OptOutWebActivityTracking	Do not track web activity	Enum
OrganizationId	National Registry number	String	10
Phone	Telephone	String	20
PhoneExtension	Extension	String	10
PriceGroup	Price group	String	10
ReceiptEmail	Receipt email	String	80
ReceiptOption	Receipt option	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelationshipType	Relation type field	Big integer
ReplicationCounterFromOrigin	Replication counter	Integer
RetailCustAffiliations	RetailCustAffiliations	Bin/Memo/Container
State	State	String	10
StoreRecId	StoreRecId	Big integer
Street	Street	String	250
StreetNumber	Street number	String	20
TaxGroup	Sales tax group	String	10
TransferStatus	Staging to target status	Enum
Url	Internet address	String	255
UseOrderNumberReference	Use order number reference	Enum
UsePurchRequest	Purchase request required	Enum
VatNum	Tax exempt number	String	20
ZipCode	ZIP/postal code	String	10

RetailAsynchronousPaymentNotification (Asynchronous payment notifications)

Name	Label	Type	Length
Content	Content	Bin/Memo/Container
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EventDateTime	Event timestamp	Date time
EventType	Event type	String	60
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaymentConnectorName	Connector	String	50
PaymentId	Payment identifier	String	50
ProcessingStatus	Processing status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100

RetailAsynchronousPaymentNotificationStaging (Asynchronous payment notifications)

Name	Label	Type	Length
Content	Content	Bin/Memo/Container
DefinitionGroup	Processing group	String	60
EventDateTime	Event timestamp	Date time
EventType	Event type	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PaymentConnectorName	Connector	String	50
PaymentId	Payment identifier	String	50
ProcessingStatus	Processing status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
TransferStatus	Staging to target status	Enum

RetailAuthenticationLogStaging (Authentication log)

Name	Label	Type	Length
AuthenticationOperation	Represents the retail authentication operations to be logged in the retail authentication log table.	Enum
AuthenticationStatus	Authentication status	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LogDateTime	System UtcDateTime	Date time
LogId	GUID	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StaffId	Operator ID	String	25
TransferStatus	Staging to target status	Enum

RetailBusinessPartnerOperationStaging (Business partner operation)

Name	Label	Type	Length
B2BUserId	B2B user identification	Guid
BusinessPartnerID	BusinessPartnerID	Bin/Memo/Container
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
OperationID	Operation Id	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
TransferStatus	Staging to target status	Enum
Type	Business partner operation type	Enum
Value	Value	Bin/Memo/Container

RetailCardInteractionTypeTableStaging (Payment Input Type)

Name	Label	Type	Length
CardInteractionType	Payment Input Type	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StoreTenderType_tenderTypeId	Payment method	String	10
TransferStatus	Staging to target status	Enum

RetailCreditVoucherChannelTableStaging (Credit memo channel transactions)

Name	Label	Type	Length
applied	Applied	Enum
appliedAmount	Amount	Real
appliedByLineNum	Line number	Real
appliedByReceiptId	Receipt number	String	18
appliedByStaffId	Operator ID	String	25
appliedByTerminalId	Register number	String	10
appliedByTransactionId	Transaction number	String	44
appliedDate	Applied date	Date
appliedInStoreId	Store number	String	10
appliedTime	Applied time	Time
DefinitionGroup	Processing group	String	60
entryId	Credit memo number	String	30
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
operation	Operation	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
reserved	Reserved	Enum
reservedByStoreId	Store number	String	10
reservedByTerminalId	Register number	String	10
TransferStatus	Staging to target status	Enum

RetailCustomerOrderCancellationHistory ()

Name	Label	Type	Length
Channel	Channel	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesId	Sales order	String	20
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44

RetailDocumentOperationRequestStaging (Document operation request)

Name	Label	Type	Length
CommittedDateTime	Committed date	Date time
Company	Company	String	4
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OperationName	Type of an operation's operation name	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
RequestId	Type of an operation's request id	Guid
RequestPayload	Request payload	Bin/Memo/Container
TransferStatus	Staging to target status	Enum

RetailExternalIdToAsyncCustomerMapStaging ()

Name	Label	Type	Length
AsyncCustomerAccountNumber	Customer account	String	38
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ExternalIdentityId	External identifier	String	512
IsSelected	Select	Enum
ProviderId	ProviderId	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
TransferStatus	Staging to target status	Enum

RetailExternalIdToAsyncCustomerMapV2Staging (RetailExternalIdToAsyncCustomerMapV2)

Name	Label	Type	Length
CustAccount	Customer account	String	20
CustAccountAsync	Customer account	String	38
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ExternalIdentityId	External identifier	String	512
IsActivated	IsActivated	Enum
IsAutoLinked	IsAutoLinked	Enum
IsSelected	Select	Enum
OnlineOperationCompleted	OnlineOperationCompleted	Enum
Operation	Retail Async Operation	Enum
OperationId	Operation ID	String	38
OperationTimeStamp	Operation Timestamp	Date time
ProviderId	ProviderId	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
TransferStatus	Staging to target status	Enum

RetailFiscalDocTaxTransPovertyFund_BRStaging (FCP tax)

Name	Label	Type	Length
Channel	Channel	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalDocumentNumber	Number	String	20
FiscalDocumentSeries	Series	String	9
IsSelected	Select	Enum
LineNum	Line number	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
Store	Store number	String	10
TaxCode	Sales tax code	String	10
TaxPovertyFundAmount	FCP tax amount	Real
TaxPovertyFundBaseAmount	FCP tax base amount	Real
TaxPovertyFundPercentage	FCP %	Real
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalDocumentContingency_BRStaging (Retail Fiscal Document)

Name	Label	Type	Length
Channel	Channel	Big integer
ContingencyAccessKey	Access key	String	45
ContingencyDateTime	Contingency mode date and time	Date time
ContingencyDateTimeOffset	Contingency mode time offset	Big integer
ContingencyFiscalDocumentNumber	Number	String	20
ContingencyFiscalDocumentSeries	Series	String	9
ContingencyMode	Contingency mode	Enum
ContingencyQrcodeText	QRCode Text	Bin/Memo/Container
ContingencyReason	Contingency reason	String	255
ContingencyXmlRequest	Request	Bin/Memo/Container
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalDocumentNumber	Number	String	20
FiscalDocumentSeries	Series	String	9
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
store	Store number	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalDocumentModel2_BRStaging (Fiscal receipt payment transactions)

Name	Label	Type	Length
ConsumerCNPJCPFNumber	CNPJ/CPF	String	20
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalDocumentAccountNum	Account	String	20
FiscalDocumentDate	Date	Date
FiscalDocumentNumber	Number	String	20
FiscalDocumentSeries	Series	String	9
IsSelected	Select	Enum
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
Status	Status	Enum
StoreId	Store number	String	10
TerminalId	Register number	String	10
TotalAmount	Amount	Real
TotalDiscountAmount	Cash discount amount	Real
TotalSurchargeAmount	Total surcharge amount	Real
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalDocumentModel2Line_BRStaging (Fiscal document (model 2) lines)

Name	Label	Type	Length
CFOP	CFOP	String	5
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ItemId	Item number	String	20
LineAmount	Amount	Real
LineDiscount	Line discount	Real
LineNum	Line number	Real
LineSurcharge	Surcharge amount	Real
Origin	Location number	String	50
Quantity	Unit quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
Unit	Unit	String	10
UnitPrice	Price	Real

RetailFiscalDocumentModel2TaxTrans_BRStaging (Fiscal document (model 2) tax transactions)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalValue	Fiscal value	Enum
IsSelected	Select	Enum
LineNum	Line number	Real
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TaxAmount	Sales tax amount	Real
TaxationCode	Taxation code	String	3
TaxationOrigin	Taxation origin	Enum
TaxBaseAmount	Amount origin	Real
TaxCode	Sales tax code	String	10
TaxReductionPct	Value	Real
TaxType	Tax type	Enum
TaxValue	Value	Real
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalDocumentReference_BRStaging (Retail fiscal document references)

Name	Label	Type	Length
AccountNum	Account	String	20
Channel	Channel	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalDocumentNumber	Number	String	20
FiscalDocumentSeries	Series	String	9
FiscalDocumentSourceText	Text ID	String	10
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefAccessKey	Access key	String	45
RefDocumentDate	Date	Date
RefModel	Document model	String	3
RefNum	Line number	Real
RefPrinterSerialNumber	Fiscal printer serial number	String	20
RefReceiptNumber	Invoice	String	50
RefTerminalNumber	Fiscal printer number	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
SourceTableId	Reference table ID	Integer
store	Store number	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalPrinter_BRStaging (Fiscal printers)

Name	Label	Type	Length
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalEstablishment	Fiscal establishment ID	String	10
FiscalReceiptModel	Document model	String	3
IsSelected	Select	Enum
Manufacturer	Manufacturer	String	20
ModelNumber	Model number	String	30
NationalCode	National code	String	6
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
RestartOperationNumber	Restart operation counter	Integer
SerialNumber	Fiscal printer serial number	String	20
SoftwareDate	Software date	Date
SoftwareVersion	Software version	String	10
StoreId	Store number	String	10
TerminalId	Register number	String	10
TerminalNumber	Fiscal printer number	Integer
TransferStatus	Staging to target status	Enum
Type	Fiscal printer type	String	10

RetailFiscalPrinterReport_BRStaging (Fiscal printer reports)

Name	Label	Type	Length
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
CreditDebitReceiptNumber	Document number	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalPrinterSerialNumber	Fiscal printer serial number	String	20
IsSelected	Select	Enum
ManagementReportNumber	Document number	Integer
NonFiscalOperationNumber	Document number	Integer
Origin	Location number	String	50
ReceiptNumber	Document number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
ReportDateTime	Transaction time	Date time
ReportType	Fiscal printer report type	String	2
RestartOperationNumber	Document number	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionDateTime	Transaction time	Date time
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalReceipt_BRStaging (Fiscal receipts)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
ConsumerCNPJCPFNumber	CNPJ/CPF	String	20
ConsumerName	Name	String	160
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalEstablishment	Fiscal establishment ID	String	10
FiscalPrinterSerialNumber	Fiscal printer serial number	String	20
FiscalReceiptDateTime	Transaction time	Date time
FiscalReceiptModel	Document model	String	3
FiscalReceiptNumber	Fiscal receipt number	Integer
IsSelected	Select	Enum
IsStatementPosted	Is statement posted	Enum
Origin	Location number	String	50
PrintedTotalDiscountAmount	Total discount	Real
PrintedTotalSurchargeAmount	Surcharge amount	Real
QuantityDecimals	Decimals	Integer
ReceiptNumber	Receipt number	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
Status	Status	Enum
StoreId	Store number	String	10
TerminalId	Register number	String	10
TotalAmount	Net amount	Real
TotalDiscountAmount	Total discount	Real
TotalSurchargeAmount	Surcharge amount	Real
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
UnitDecimals	Decimals	Integer
VoidedAfterEndReceipt	Voided after end receipt	Integer
Voucher	Voucher	String	20
ZReportNumber	Z report number	Integer

RetailFiscalReceiptLine_BRStaging (Fiscal receipt lines)

Name	Label	Type	Length
CancelledQuantity	Canceled quantity	Real
CFOP	CFOP	String	5
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ItemId	Item number	String	20
ItemType	Product type	String	10
LineAmount	Gross amount	Real
LineDiscountAmount	Line discount	Real
LineNum	Line number	Real
LineSurchargeAmount	Surcharge amount	Real
Origin	Location number	String	50
PrintedLineDiscountAmount	Line discount	Real
PrintedLineSurchargeAmount	Surcharge amount	Real
Quantity	Unit quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
Unit	Unit	String	10
UnitPrice	Price	Real

RetailFiscalReceiptTaxTrans_BRStaging (Fiscal receipt tax transactions)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalValue	Fiscal value	Enum
IsSelected	Select	Enum
LineNum	Line number	Real
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TaxAmount	Taxable amount	Real
TaxationCode	Taxation code	String	3
TaxationOrigin	Taxation origin	Enum
TaxBaseAmount	Tax base amount	Real
TaxCode	Sales tax code	String	10
TaxType	Tax type	Enum
TaxValue	Sales tax rate	Real
TerminalId	Register number	String	10
TotalizerIndex	Totalizer index	Integer
TotalizerName	Totalizer name	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalTransPaymentTransAdjustmentStaging (Payment transaction adjustment)

Name	Label	Type	Length
AdjustmentAmount	Tendered	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalTransLineNum	Line number	Real
FiscalTransRecordGuid	GUID	Guid
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
PaymentTransLineNum	Line number	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailFiscalTransSalesTransAdjustmentStaging (Sales transaction adjustment)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Exclude	Exclude from sales reports	Enum
ExecutionId	Job ID	String	90
FiscalTransLineNum	Line number	Real
FiscalTransRecordGuid	GUID	Guid
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
SalesTransLineNum	Line number	Real
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailGiftCardChannelTransactionsStaging (Gift card channel transactions)

Name	Label	Type	Length
amount	Amount	Real
cardNumber	Gift card number	String	30
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
operation	Operation	Enum
receiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
staffId	Operator ID	String	25
terminalId	Register number	String	10
transactionId	Transaction number	String	44
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time

RetailLogStaging (Log)

Name	Label	Type	Length
BatchId	Shift ID	Big integer
ClosedBatchId	Shift ID	Big integer
CodeUnit	Code unit	String	100
DefinitionGroup	Processing group	String	60
durationInMilliSec	Duration in ticks	Integer
EventType	Event type	Enum
ExecutionId	Job ID	String	90
Id	Receipt format	Integer
IsSelected	Select	Enum
LogDate	Date	Date
LogLevel	Log level	Enum
LogString	Log string	Bin/Memo/Container
LogTime	Time	Time
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
RetailLogId	Retail Log Id	Big integer
StaffId	Operator ID	String	25
StoreId	Store number	String	10
terminalId	Register number	String	10
TransferStatus	Staging to target status	Enum
UploadType	Uploaded via	Enum

RetailLogTransactionReferenceStaging (Retail log transaction reference)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
OMOperatingUnit1_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Retail log reference Id	Big integer
RefStore	Store number	String	10
RefTerminal	Register number	String	10
RefTransactionId	Transaction number	String	44
replicationCounterFromOrigin	Replication counter from origin	Integer
RetailLogId	Retail Log Id	Big integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransferStatus	Staging to target status	Enum
UploadType	Uploaded via	Enum

RetailPaymentProviderNotification (Payment processor notifications)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
Content	Content	Bin/Memo/Container
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
EventDateTime	Event timestamp	Date time
EventType	Event type	String	60
MerchantAccountId	Merchant account Id	String	255
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaymentId	Payment identifier	String	50
ProcessingStatus	Processing status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
Success	Event successful	Enum

RetailPaymentProviderNotificationStaging (Payment processor notifications)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
Content	Content	Bin/Memo/Container
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
EventDateTime	Event timestamp	Date time
EventType	Event type	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
MerchantAccountId	Merchant account Id	String	255
PaymentId	Payment identifier	String	50
ProcessingStatus	Processing status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
Success	Event successful	Enum
TransferStatus	Staging to target status	Enum

RetailPosBatchAccountTransStaging (Shift account transactions)

Name	Label	Type	Length
AccountNum	Account number	String	10
AccountType	Account type	Enum
Amount	Total	Real
BatchID	Shift ID	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounter	Replication counter	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransferStatus	Staging to target status	Enum

RetailPosBatchTableStaging (Shifts)

Name	Label	Type	Length
BatchID	Shift ID	Big integer
CancellationCharges	Amount	Real
ChargeTotal	Charge totals	Real
ClosedAtBatchId	Shift ID	Big integer
CloseDate	Closed date	Date
CloseDateTimeUtc	Closed time	Date time
ClosedAtTerminal	Register number	String	10
CloseTime	Closed time	Time
CustomerOrdersCanceled	Amount	Real
CustomerOrdersEdited	Amount	Real
CustomerOrdersPlaced	Amount	Real
CustomerOrdersVoidedLines	Amount	Real
CustomersCount	Customer sales	Integer
DefinitionGroup	Processing group	String	60
DepositCollected	Amount	Real
DepositRedeemed	Amount	Real
DepositRefunded	Amount	Real
DiscountTotal	Discounts	Real
Error	Shift validation error	Bin/Memo/Container
ErrorCode	Error code	Enum
ErrorCodeDateTime	Error Acknowledged date and time	Date time
ErrorCodeEditUser	Last user who modified the shift	String	20
ExecutionId	Job ID	String	90
GiftCardCashOutTotal	Gift card cash out total	Real
GiftCardsTotal	Amount	Real
GoodsSoldQty	Items sold	Real
HasPendingOfflineTransactions	Pending offline transactions	Enum
IsSelected	Select	Enum
LogonsCount	Logon	Integer
MarkForFinancialStatement	Mark for financial statement	Enum
NoSaleCount	Open drawer	Integer
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
PaidToAccountTotal	To account	Real
Posted	Posted	Enum
PriceOverrideTotal	Manual price reductions	Real
ReceiptCopiesCount	Receipt copies	Integer
ReceiptCopiesTotal	Receipt copies	Real
ReceiptsCount	Cash receipts	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounter	Replication counter	Integer
ReturnsCount	Returns	Integer
ReturnsGrandTotal	Grand return	Real
ReturnsTotal	Returns	Real
RoundedAmountTotal	Rounded	Real
SalesCount	Sales	Integer
SalesGrandTotal	Grand sales	Real
SalesTotal	Sales	Real
SalesTotalExcludingTax	Total Sales excluding VAT	Real
SalesTotalIncludingTax	Total Sales including VAT	Real
ServicesSoldQty	Services sold	Real
ShiftReturnsTotal	Total cash returns	Real
ShiftSalesTotal	Total cash sales	Real
StaffId	Operator ID	String	25
StartDate	Start date	Date
StartDateTimeUtc	Start time	Date time
StartTime	Start time	Time
StatementId	Statement number	String	20
Status	Status	Enum
StoreId	Store number	String	10
SuspendedCount	Suspended	Integer
SuspendedTotal	Suspended	Real
TaxTotal	Taxes	Real
TerminalId	Register number	String	10
TrainingCount	Training	Integer
TrainingTotal	Training	Real
TransactionsCount	Number of transactions	Integer
TransferStatus	Staging to target status	Enum
VoidedSalesTotal	Voided amount	Real
VoidsCount	Voided sales	Integer
ZeroSalesCount	Zero sales	Integer

RetailPosBatchTenderTransStaging (Shift tender transactions)

Name	Label	Type	Length
AddToTenderAmount	Added	Real
AddToTenderAmountCur	Added	Real
BankDropAmount	Bank drop	Real
BankDropAmountCur	Bank drop	Real
BatchID	Shift ID	Big integer
CardTypeId	Card ID	String	10
ChangeAmount	Change	Real
ChangeAmountCur	Change	Real
Count	Transactions	Integer
CountingRequired	Counting required	Enum
Currency	Currency	String	3
DeclareTenderAmount	Counted	Real
DeclareTenderAmountCur	Counted	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Notes	Notes	String	1000
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
Overridden	Are amounts overridden	Enum
OverrideAddToTenderAmount	Overriden add to tender amount	Real
OverrideAddToTenderAmountCur	Overriden add to tender amount	Real
OverrideBankDropAmount	Overriden bank drop amount	Real
OverrideBankDropAmountCur	Overriden bank drop amount	Real
OverrideChangeAmount	Overriden change amount	Real
OverrideChangeAmountCur	Overriden change amount	Real
OverrideDeclareTenderAmount	Overriden declare tender amount	Real
OverrideDeclareTenderAmountCur	Overriden declare tender amount	Real
OverrideRemoveTenderAmount	Overriden remove tender amount	Real
OverrideRemoveTenderAmountCur	Overriden remove tender amount	Real
OverrideSafeDropAmount	Overriden safe drop amount	Real
OverrideSafeDropAmountCur	Overriden safe drop amount	Real
OverrideStartingAmount	Overriden starting amount	Real
OverrideStartingAmountCur	Overriden starting amount	Real
OverrideTenderedAmount	Overriden tendered amount	Real
OverrideTenderedAmountCur	Overriden tendered amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RemoveTenderAmount	Removed	Real
RemoveTenderAmountCur	Removed	Real
ReplicationCounter	Replication counter	Integer
SafeDropAmount	Safe drop	Real
SafeDropAmountCur	Safe drop	Real
StartingAmount	Started	Real
StartingAmountCur	Started	Real
StoreId	Store number	String	10
TenderedAmount	Tendered	Real
TenderedAmountCur	Tendered	Real
TenderTypeId	Payment method	String	10
TerminalId	Register number	String	10
TransferStatus	Staging to target status	Enum

RetailProductListLineUpdateStaging ()

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DeletedDateTime	DeletedDateTime	Date time
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LastUpdated	Modified date and time	Date time
LineId	Product list line ID	String	40
ProductListId	Product list ID	String	40
Quantity	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
SyncDateTime	Modified date and time	Date time
TransferStatus	Staging to target status	Enum
UnitOfMeasure	Unit	String	10

RetailProductListUpdateStaging ()

Name	Label	Type	Length
CustomerId	Account number	String	20
DefinitionGroup	Processing group	String	60
DeletedDateTime	UTC timestamp	Date time
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LastUpdated	Modified date and time	Date time
Name	Product list name	String	250
ProductListId	Product list ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
SyncDateTime	Modified date and time	Date time
TransferStatus	Staging to target status	Enum
Type	Type	Enum

RetailSalesTableAsynchronousPayment (Asynchronous payment)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
AsynchronousPaymentStatus	Asynchronous payment status	Enum
AuthorizedAmount	Authorized amount	Real
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
ExpirationDateTime	Expiration date time	Date time
IsNonRecurring	Is non-recurring	Enum
IsPreauthorizationOnly	Is pre-authorization only	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaymentLinkId	Payment link identifier	String	100
PaymentLinkStatus	Payment link status	Enum
PaymentLinkUrl	Payment link URL	String	255
PaymentType	Payment type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
SalesId	Sales order	String	20
ServiceAccountId	Service account ID	String	50
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TenderTypeId	Payment method	String	10

RetailSalesTableAsynchronousPaymentStaging (Asynchronous payment)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
AsynchronousPaymentStatus	Asynchronous payment status	Enum
AuthorizedAmount	Authorized amount	Real
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ExpirationDateTime	Expiration date time	Date time
IsNonRecurring	Is non-recurring	Enum
IsPreauthorizationOnly	Is pre-authorization only	Enum
IsSelected	Select	Enum
PaymentLinkId	Payment link identifier	String	100
PaymentLinkStatus	Payment link status	Enum
PaymentLinkUrl	Internet address	String	255
PaymentType	Payment type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
SalesId	Sales order	String	20
ServiceAccountId	Service account ID	String	50
TenderTypeId	Payment method	String	10
TransferStatus	Staging to target status	Enum

RetailTransactionAddressTransStaging (Retail Transaction Address)

Name	Label	Type	Length
AttentionToAddressLine	Attention	String	255
BuildingCompliment	Name	String	60
City	City	String	60
CountryRegionId	Country/region	String	10
County	County	String	30
DefinitionGroup	Processing group	String	60
DeliveryName	Name	String	160
DistrictName	District	String	60
Email	Email	String	80
EmailContent	RetailEmailAddressContent	String	400
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
Phone	Telephone	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
SaleLineNum	Line number	Real
SalesName	Name	String	60
State	State	String	10
store	Store number	String	10
Street	Street	String	250
StreetNumber	Street number	String	20
terminal	Register number	String	10
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
ZipCode	ZIP/postal code	String	10

RetailTransactionAffiliationTransStaging (Affiliations for transactions)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
ReceiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
RetailAffiliation_Name	Name	String	64
RetailAffiliation1_Name	Name	String	64
RetailLoyaltyTier_TierId	Tier	String	64
StaffId	Operator ID	String	25
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionAsynchronousPaymentTrans (Asynchronous payment transaction)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
AsynchronousPaymentStatus	Asynchronous payment status	Enum
Channel	Channel	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
ExpirationDateTime	Expiration date time	Date time
IsNonRecurring	Is non-recurring	Enum
IsPreauthorizationOnly	Is pre-authorization only	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaymentLinkId	Payment link identifier	String	100
PaymentLinkStatus	Payment link status	Enum
PaymentLinkUrl	Internet address	String	255
PaymentType	Payment type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
ReplicationCounterFromOrigin	Replication counter	Integer
ServiceAccountId	Service account ID	String	50
Store	Store number	String	10
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TenderTypeId	Payment method	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44

RetailTransactionAsynchronousPaymentTransStaging (Asynchronous payment transaction)

Name	Label	Type	Length
Amount	Amount in transaction currency	Real
AsynchronousPaymentStatus	Asynchronous payment status	Enum
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ExpirationDateTime	Expiration date time	Date time
IsNonRecurring	Is non-recurring	Enum
IsPreauthorizationOnly	Is pre-authorization only	Enum
IsSelected	Select	Enum
OperatingUnitNumber	Operating unit number	String	30
PaymentLinkId	Payment link identifier	String	100
PaymentLinkStatus	Payment link status	Enum
PaymentLinkUrl	Internet address	String	255
PaymentType	Payment type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Merchant reference Id	String	100
ServiceAccountId	Service account ID	String	50
TenderTypeId	Payment method	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionAttributeTransStaging (Sales order attributes)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
HeaderOrLineNum	Line number	Real
IsSelected	Select	Enum
Name	Name	String	60
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
store	Store number	String	10
terminal	Register number	String	10
TextValue	Text	String	1999
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionChargeTaxTransGTEStaging (Commerce charge GTE tax transactions)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsIncludedInPrice	Tax included in price	Enum
IsSelected	Select	Enum
MarkupLineNum	Markup line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
SaleLineNum	Sales line number	Real
StoreId	Store number	String	10
TaxAmount	Tax amount	Real
TaxBasis	Amount	Real
TaxComponent	Tax component	String	60
TaxPercentage	Value	Real
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionCheckoutErrorLog (Retail transaction checkout errors)

Name	Label	Type	Length
Channel	Channel	RecId
ErrorDateTime	UTC timestamp	Date time
ErrorLineNum	Line number	Real
ErrorLocalizedMessage	Localized error message	Bin/Memo/Container
ErrorResourceId	Error resource Id	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
TransactionId	Transaction number	String	44

RetailTransactionCustomerAccountDepositTransStaging ()

Name	Label	Type	Length
amount	Amount	Real
businessDate	Date	Date
comment	comment	String	60
counter	Counter	Integer
custAccount	Customer account	String	38
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
lineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
receiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicated	Replicated	Enum
replicationCounterFromOrigin	Replication counter from origin	Integer
shift	Shift	String	10
shiftDate	Shift date	Date
staff	Operator ID	String	25
statementCode	Statement code	String	25
statementId	Statement number	String	20
store	Store number	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time

RetailTransactionDiscountTransStaging (Discount transactions)

Name	Label	Type	Length
Amount	Full discount amount	Real
AppliedDiscountLineNum	Line number	Real
BundleId	Bundle ID	Integer
CustomerDiscountType	Customer discount type	Enum
DealPrice	Deal price	Real
DefinitionGroup	Processing group	String	60
DiscountAmount	Cash discount amount	Real
DiscountCode	Discount code	String	60
DiscountCost	Discount cost	Real
DiscountOriginType	Discount origin type	Enum
EffectivePercentage	Discount percentage	Real
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNum	Line number	Real
ManualDiscountType	Manual discount type	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
Percentage	Discount percentage	Real
PeriodicDiscountOfferId	Offer ID	String	20
RecId	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
TransferStatus	Staging to target status	Enum

RetailTransactionFiscalCustomerCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTransactionFiscalCustomer	Reference	RecId
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

RetailTransactionIncomeExpenseTransStaging (Income/Expense transaction)

Name	Label	Type	Length
accountType	Account type	Enum
amount	Amount	Real
businessDate	Business date	Date
counter	Counter	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
incomeExepenseAccount	Account number	String	10
IsSelected	Select	Enum
lineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
receiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicated	Replicated	Enum
replicationCounterFromOrigin	Replication counter from origin	Integer
shift	Shift	String	10
shiftDate	Shift date	Date
staff	Operator ID	String	25
statementCode	Statement code	String	25
statementId	Statement number	String	20
store	Store number	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time

RetailTransactionInfocodeTransStaging (Info code transactions)

Name	Label	Type	Length
amount	Amount	Real
businessDate	Date	Date
counter	Counter	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
fiscalTransParentGuid	GUID	Guid
infoAmount	Reason code amount	Real
infocodeId	Info code number	String	10
information	Information	String	100
inputType	Input type	Enum
IsSelected	Select	Enum
itemTender	ID number	String	10
lineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
parentLineNum	Line number	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicated	Replicated	Enum
replicationCounterFromOrigin	Replication counter from origin	Integer
sourceCode	Source number	String	20
sourceCode2	Source number	String	20
sourceCode3	Source number	String	20
staff	Operator ID	String	25
statementCode	Statement code	String	25
statementId	Statement number	String	20
store	Store number	String	10
subInfocodeId	Subcode number	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time
type	Transaction type	Enum

RetailTransactionLoyaltyRewardPointTransStaging (Loyalty reward point transaction)

Name	Label	Type	Length
CardNumber	Card number	String	30
CustAccount	Customer account	String	20
DefinitionGroup	Processing group	String	60
EntryDate	Entry date	Date
EntryTime	Entry time	Time
EntryType	Entry type	Enum
ExecutionId	Job ID	String	90
ExpirationDate	Expiration date	Date
IsSelected	Select	Enum
LineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
ReceiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter	Integer
RetailAffiliation_Name	Name	String	64
RetailAffiliation1_Name	Name	String	64
RetailLoyaltyRewardPoint_RewardPointId	Reward point ID	String	64
RetailLoyaltyTier_TierId	Tier	String	64
RetailTransactionSalesTransLineNum	Line number	Real
RewardPointAmountQty	Reward points	Real
StaffId	Operator ID	String	25
storeId	Store number	String	10
terminalId	Register number	String	10
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionMarkupTransStaging (Retail Transaction charges)

Name	Label	Type	Length
CalculatedAmount	Calculated value	Real
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
Description	Description	String	512
ExecutionId	Job ID	String	90
Exempt_IN	Exempt	Enum
HSNCode_IN	HSN codes	String	10
IsOverriddenLine	This charge has been manually overwritten by a user.	Enum
IsSelected	Select	Enum
ITCCategory_IN	ITC Category	Enum
Keep	Keep	Enum
MarkupCode	Charges code	String	10
markupLineNum	Line number	Real
Method	Category	Enum
ModuleType	Charges module	Enum
NonGST_IN	Non-GST	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
saleLineNum	Sales line number	Real
ServiceAccountingCode_IN	Service accounting codes	String	10
ServiceCategory_IN	Service category	Enum
store	Store number	String	10
TaxAmount	Sales tax amount	Real
TaxAmountExclusive	Inclusive tax amount	Real
TaxAmountInclusive	Exclusive tax amount	Real
TaxExemptPriceInclusiveOriginalPrice	Price before inclusive tax exemption	Real
TaxExemptPriceInclusiveReductionAmount	Inclusive tax exemption amount	Real
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TaxRateType	Tax rate type	String	60
terminalId	Register number	String	10
transactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
Value	Charges value	Real

RetailTransactionOrderInvoiceTransStaging (Transaction order invoice transaction)

Name	Label	Type	Length
amountCur	Amount in transaction currency	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
invoiceId	Invoice	String	50
IsSelected	Select	Enum
lineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter from origin	Integer
salesId	Sales order	String	20
salesOrderInvoiceType	Sales order/Invoice	Enum
statementId	Statement number	String	20
storeId	Store number	String	10
terminalId	Register number	String	10
transactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
TransferStatus	Staging to target status	Enum

RetailTransactionPaymentTrans_BRStaging (Fiscal document (model 2) payment transactions)

Name	Label	Type	Length
amountCur	Amount in transaction currency	Real
amountTendered	Paid amount	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
lineNum	Line number	Real
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
tenderType	Payment method	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time

RetailTransactionPaymentTransExtStaging (Payment transaction extensions for countries)

Name	Label	Type	Length
AmountTenderedAdjustment	Tendered	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionPriceTransStaging (Price transaction)

Name	Label	Type	Length
Channel	Channel	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PriceType	Price Type	Enum
RecId	Record-ID	RecId
RecordId	Reference record ID	Big integer
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
TransferStatus	Staging to target status	Enum
Value	Amount	Real

RetailTransactionSalesTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTransactionSalesTrans	Reference	RecId
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

RetailTransactionSalesTransExtStaging (Sales transaction extensions for countries)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
SkipReports	Exclude from sales reports	Enum
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionSupplementaryInvoiceCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTransactionSupplementaryInvoice	Reference	RecId
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

RetailTransactionTable_RUStaging (Transactions)

Name	Label	Type	Length
Channel	Channel	Big integer
DefinitionGroup	Processing group	String	60
EKLZSerialNumber	ESCT factory number	String	10
ExecutionId	Job ID	String	90
FiscalDocumentSerialNumber	Document serial number	String	10
FiscalPrinterSerialNumber	Printer serial number	String	20
FiscalPrinterShiftID	Shift ID	String	5
IsSelected	Select	Enum
KPKNumber	CCK number	String	8
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
Store	Store number	String	10
Terminal	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionTableCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTransactionTable	Reference	RecId
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

RetailTransactionTaxTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailTransactionTaxTrans	Reference	RecId
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date

RetailTransactionTaxTransGTEStaging (GTE tax transaction)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsIncludedInPrice	Is inclusive	Enum
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter	Integer
SaleLineNum	Line number	Real
StoreId	Store number	String	10
TaxAmount	Amount	Real
TaxBasis	Amount	Real
TaxComponent	Tax component	String	60
TaxPercentage	Value	Real
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionTaxTransStaging (Tax transactions)

Name	Label	Type	Length
Amount	Amount	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsExempt	Exempt	Enum
IsIncludedInPrice	Is inclusive	Enum
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicationCounterFromOrigin	Replication counter	Integer
SaleLineNum	Sales line number	Real
StoreId	Store number	String	10
TaxBaseAmount	Amount origin	Real
TaxCode	Sales tax code	String	10
TaxPercentage	Value	Real
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum

RetailTransactionTenderDeclarationTransStaging (Tender declaration transaction)

Name	Label	Type	Length
amountCur	Amount in transaction currency	Real
amountMST	Amount	Real
amountTendered	Tendered	Real
businessDate	Business date	Date
cardId	Card ID	String	10
currency	Currency	String	3
DefinitionGroup	Processing group	String	60
exchRate	Exchange rate	Real
exchRateMST	Exchange rate	Real
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
lineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
Origin	Location number	String	50
POSCurrency	POS currency	String	3
qty	Quantity	Real
receiptId	Receipt number	String	18
RecId	Record-ID	RecId
recVersion	Record Version	Integer
replicated	Replicated	Enum
replicationCounterFromOrigin	Replication counter from origin	Integer
shift	Shift	String	10
shiftDate	Shift date	Date
staff	Operator ID	String	25
statementCode	Statement code	String	25
statementId	Statement number	String	20
store	Store number	String	10
tenderType	Payment method	String	10
terminal	Register number	String	10
transactionId	Transaction number	String	44
transactionStatus	Entry status	Enum
transDate	Date	Date
TransferStatus	Staging to target status	Enum
transTime	Transaction time	Time

RetailWarrantyTransactionSalesTransStaging (Warranty sales transaction)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LineNum	Line number	Real
OMOperatingUnit_PartyNumber	Party ID	String	40
OMOperatingUnit1_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter from origin	Integer
Store	Store number	String	10
TerminalId	Register number	String	10
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
WarrantableLineNumber	Line number of transaction with warrantable product	Real
WarrantableSerialId	Serial number	String	20
WarrantableStore	Store of transaction with warrantable product	String	10
WarrantableTerminalId	Terminal ID of transaction with warrantable product	String	10
WarrantableTransactionId	Transaction number of transaction with warrantable product	String	44

RetailXZReportTableStaging (End of day report)

Name	Label	Type	Length
BatchId	Shift ID	Big integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
OMOperatingUnit_PartyNumber	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
ReportDateTime	Report date and time	Date time
ReportId	Report ID	Big integer
ReportType	Report type	Enum
ReportValue	XML	Bin/Memo/Container
StoreId	Store number	String	10
TerminalId	Register number	String	10
TransferStatus	Staging to target status	Enum

RetailZReport_BRStaging (Z reports)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
COFINSAmount	COFINS amount	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FinalGrandTotalAmount	Grand total	Real
FirstReceiptNumber	First document number	Integer
FiscalEstablishment	Fiscal establishment ID	String	10
FiscalPrinterSerialNumber	Fiscal printer serial number	String	20
FiscalReceiptModel	Document model	String	3
GrossDailySale	Gross daily sales amount	Real
InitialGrandTotalAmount	Amount	Real
ISSDiscount	ISSDiscount	Enum
IsSelected	Select	Enum
IsStatementPosted	Is statement posted	Enum
LastReceiptNumber	Last document number	Integer
NetAmount	Net amount	Real
Origin	Location number	String	50
PISAmount	PIS amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
RestartOperationNumber	Restart operation counter	Integer
StoreId	Store number	String	10
TerminalId	Register number	String	10
TerminalNumber	Fiscal printer number	Integer
TransactionId	Transaction number	String	44
TransferStatus	Staging to target status	Enum
Version	Version	Enum
Voucher	Voucher	String	20
ZReportDateTime	Issue date	Date time
ZReportNumber	Z report number	Integer

RetailZReportTotalizer_BRStaging (Z report tax totalizers)

Name	Label	Type	Length
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalPrinterSerialNumber	Fiscal printer serial number	String	20
IsSelected	Select	Enum
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TaxAmount	Taxable amount	Real
TaxValue	Totalizer tax value	Real
TerminalId	Register number	String	10
TotalizerAmount	Tax base amount	Real
TotalizerName	Totalizer name	String	10
TotalizerSintegraName	Totalizer name	String	10
TransferStatus	Staging to target status	Enum
ZReportNumber	Document number	Integer

RetailZReportTotalizerTaxTrans_BRStaging (Z report totalizer tax transactions)

Name	Label	Type	Length
AdditionalFiscalMemoryIndex	Fiscal memory index	Integer
CFOP	CFOP	String	5
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FiscalPrinterSerialNumber	Fiscal printer serial number	String	20
FiscalValue	Fiscal value	Enum
IsSelected	Select	Enum
Origin	Location number	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplicationCounterFromOrigin	Replication counter	Integer
StoreId	Store number	String	10
TaxAmount	Taxable amount	Real
TaxationCode	Taxation code	String	3
TaxationOrigin	Taxation origin	Enum
TaxBaseAmount	Tax base amount	Real
TaxBaseAmountExempt	Exempt base amount	Real
TaxBaseAmountOther	Other base amount	Real
TaxCode	Sales tax code	String	10
TaxType	Tax type	Enum
TaxValue	Value	Real
TerminalId	Register number	String	10
TotalizerName	Totalizer name	String	10
TransferStatus	Staging to target status	Enum
ZReportNumber	Z report number	Integer

SecurityUserToGroupMapping (SecurityUserToGroupMappingTable)

Name	Label	Type	Length
GroupNetworkAlias	GroupNetworkAlias	String	255
GroupObjectId	GroupObjectId	Guid
GroupUserId	User ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20
UserNetworkAlias	UserNetworkAlias	String	255
UserObjectId	UserObjectId	Guid

SourceDocumentLineStateContainerCleanerUpdateQueue (Table to store recids of SDL which potentially will be cleaned by the SourceDocumentLineStateContainerCleaner data maintenance job)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentLineRecId	Reference	RecId

SourceDocumentUpdateReferenceIdentityTransferStatusToTransferredQueue (Queue table for SubledgerJournalEntry records pending reference identity status update)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubledgerJournalEntryRecId	Subledger journal entry	RecId

SubBillDeferralScheduleFailedAdjustmentWorkItems ()

Name	Label	Type	Length
ProcessId	ProcessId	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId

TaxReportAdjustmentTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TaxReportAdjustmentTrans	Reference	RecId

TaxTrans_ReportingCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TaxTrans_Reporting	Reference	RecId

TaxTrans_WCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TaxTrans_W	Reference	RecId

TaxTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TaxTrans	Reference	RecId

TaxTransGeneralJournalAccountEntryCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TaxTransGeneralJournalAccountEntry	Reference	RecId

TMSShippingCarrierPostalAddressV2Staging (Shipping carrier postal addresses V2)

Name	Label	Type	Length
AddressBuildingCompliment	Building complement	String	60
AddressCity	City	String	60
AddressCityInKana	City in Kana	String	60
AddressCountryRegionId	Country/region	String	10
AddressCountryRegionISOCode	Country/region ISO	String	2
AddressCountyId	County	String	30
AddressDescription	Name or description	String	60
AddressDistrictName	District	String	60
AddressLatitude	Latitude	Real
AddressLocationId	Location ID	String	40
AddressLocationRoles	Address role	String	1000
AddressLongitude	Longitude	Real
AddressPostBox	Post box	String	20
AddressStateId	State	String	10
AddressStreet	Street	String	250
AddressStreetInKana	Street in Kana	String	250
AddressStreetNumber	Street number	String	20
AddressTimezone	Time zone	Enum
AddressValidFrom	Effective	Date time
AddressValidTo	Expiration	Date time
AddressZipCode	ZIP/postal code	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FormattedAddress	Address	String	250
IsPrimaryAddress	Primary	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShippingCarrierId	Shipping carrier	String	20
ShippingCarrierLegalEntityId	Company	String	4
TransferStatus	Staging to target status	Enum

TransactionReversalTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
TransactionReversalTrans	Reference	RecId

TrvCopilotAttachedReceiptStaging (Expense copilot attached receipt details)

Name	Label	Type	Length
ActualCompanyId	Company accounts	String	4
Author	Author	RecId
CapturedDocument	CapturedDocument	Bin/Memo/Container
ContactPersonId	Contact ID	String	20
DefaultAttachment	Is default attachment	Enum
DefinitionGroup	Processing group	String	60
DocCreatedBy	Created by	String	20
DocCreatedDateTime	Created date and time	Date time
DocModifiedBy	Modified by	String	20
DocModifiedDateTime	Modified date and time	Date time
DocumentId	Document ID	Guid
DocuRefTableName	DocuRefTableName	String	20
EncyclopediaItemId	Knowledge article item ID	String	10
EntRecId	Record-ID	RecId
ExecutionId	Job ID	String	90
ExpenseLineAttachedTo	ExpenseLineAttachedTo	String	20
FileExtension	FileExtension	String	10
InterCompanySkipUpdate	Skip intercompany update	Enum
IsCashExpense	IsCashExpense	Enum
IsJustification	IsJustification	Enum
IsSelected	Select	Enum
Name	Description	String	60
Notes	Note	Bin/Memo/Container
Party	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefCompanyId	Company account	String	4
RefRecId	Reference record ID	RecId
RefTableId	Reference table ID	Integer
Restriction	Restriction	Enum
smmEMailEntryID	Entry ID	String	255
smmEMailStoreID	Store ID	String	300
smmTable	Sales and marketing table	Enum
TransferStatus	Staging to target status	Enum

TrvExpMobileCompanyInfoV2Staging (Expense legal entity V2)

Name	Label	Type	Length
Company	Company	String	4
DefaultCurrency	Currency	String	3
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IntercompanyLEs	IntercompanyLEs	Bin/Memo/Container
IsEmployed	IsEmployed	Enum
IsSelected	Select	Enum
Language	Language	String	7
LegalEntityRecId	Record-ID	RecId
Name	Name	String	160
PartyID	Party ID	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

UserManagementDVAppRole ()

Name	Label	Type	Length
AssignmentStatus	AssignmentStatus	Enum
EntraClientId	GUID string type	String	38
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SecurityRoleAOTName	AOT Name	String	81

UserManagementDVAppUserInfo ()

Name	Label	Type	Length
Email	Email	String	80
Enabled	Enabled	Enum
EntraClientId	GUID string type	String	38
isDVCreated	isDVCreated	Enum
isMicrosoftAccount	isMicrosoftAccount	Enum
Name	Name	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User ID	String	20

VendInvoiceIntrastatCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendInvoiceIntrastat	Reference	RecId

VendInvoiceJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendInvoiceJour	Reference	RecId

VendInvoiceTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendInvoiceTrans	Reference	RecId

VendPackingSlipJourCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendPackingSlipJour	Reference	RecId

VendPackingSlipTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendPackingSlipTrans	Reference	RecId

VendSettlementCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendSettlement	Reference	RecId

VendTransCDR ()

Name	Label	Type	Length
CDRDataAreaId	Company	String	4
CountryLawReference	Country law reference	String	2
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetentionEndDate	Retention end date	Date
RetentionStartDate	Retention start date	Date
VendTrans	Reference	RecId

WHSItemStoragePolicy (Item storage policy)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Description	String	60
Id	Item storage policy	String	20
InventLocationId	Warehouse	String	10
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WarehouseGroupAll	Warehouse selection	Enum
WarehouseGroupId	Warehouse group	String	20

WHSItemStoragePolicyAllocation (Item storage policy allocation)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ItemId	Item number	String	20
ItemOrGroup	Applicable to	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ProductVariantInventDimId	Dimension number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WHSItemStoragePolicyId	Item storage policy	String	20
WHSItemStoragePolicyItemGroupId	Storage policy item group	String	20

WHSItemStoragePolicyAllocationLine (Item storage policy allocation line)

Name	Label	Type	Length
AllocatedLocations	Allocated locations	Integer
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
UnlimitedLocations	Unlimited locations	Enum
WHSItemStoragePolicyAllocation	Reference	RecId
WHSItemStoragePolicyLine	Reference	RecId

WHSItemStoragePolicyItemGroup (Storage policy item group)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Id	Storage policy item group	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WHSItemStoragePolicyId	Item storage policy	String	20

WHSItemStoragePolicyItemGroupItem (Storage policy item group item)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ItemId	Item number	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WHSItemStoragePolicyItemGroup	Reference	RecId

WHSItemStoragePolicyLine (Item storage policy line)

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
ReplenishFromZoneId	Replenish from zone	String	20
RestrictByUOM	Restrict by unit	Enum
SequenceNumber	Sequence	Integer
WHSItemStoragePolicyId	Item storage policy	String	20
ZoneId	Zone ID	String	20

WHSItemStoragePolicyLineUOM (Item storage policy line unit of measure)

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
UOM	Unit	String	10
WHSItemStoragePolicyLine	Reference	RecId

WHSWarehouseWorkReclassificationScheduleStaging (Work reclassification schedules)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Description	Description	String	255
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ScheduleId	Reclassification schedule ID	String	20
TransferStatus	Staging to target status	Enum

WHSWarehouseWorkTemplateClassificationRuleStaging (Dynamic work classification rules)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Description	Description	String	255
ExecutionId	Job ID	String	90
Formula	Power Fx formula	Bin/Memo/Container
IsSelected	Select	Enum
RecId	Record-ID	RecId
ReclassificationSchedule	Reclassification schedule ID	String	20
ReclassifyOnLoadUpdate	Reclassify work on load update	Enum
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
WorkTemplateClassificationRuleId	Dynamic work classification rule	String	20

WHSWorkReclassificationSchedule (Work reclassification schedules)

Name	Label	Type	Length
Description	Description	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ScheduleId	Reclassification schedule ID	String	20

WHSWorkTemplateClassificationRule (Dynamic work classification rules)

Name	Label	Type	Length
Description	Description	String	255
Formula	Power Fx formula	Bin/Memo/Container
RecId	Record-ID	RecId
ReclassificationSchedule	Reclassification schedule ID	String	20
ReclassifyOnLoadUpdate	Reclassify work on load update	Enum
recVersion	Record Version	Integer
WorkTemplateClassificationRuleId	Dynamic work classification rule	String	20