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

About

Welcome to the comprehensive comparison between versions 10.0.47 and 10.0.48. 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

New tables

AssetInventSettlement (Fixed asset inventory settlement)

Name	Label	Type	Length
AmountMST	Amount	Real
AssetId	Fixed asset number	String	20
BookId	Book	String	10
CurrentOperationsTax	Posting layer	Enum
DefaultDimension	Dimension	RecId
InventTransRecId	Reference	RecId
IsMainBook	IsMainBook	Enum
LedgerDimension	Ledger account	RecId
LedgerPostingType	Posting type	Enum
OffsetLedgerDimension	Ledger account	RecId
OffsetLedgerPostingType	Posting type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	Amount in reporting currency	Real
TransDate	Date	Date
Voucher	Voucher	String	20

AssetTransInventTrans (Fixed asset inventory transaction tracking)

Name	Label	Type	Length
AssetTransRecId	Reference	RecId
InventTransRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDate	Date	Date
Voucher	Voucher	String	20

BudgetAccountStructureValidationDataEntry (Budget account structure validation staging table)

Name	Label	Type	Length
DataverseGuid	DataverseGuid	String	36
DimensionCombinationsHash	DimensionCombinationsHash	String	64
DimensionCombinationsJson	DimensionCombinationsJson	String	2000
IsSyncedToDataverse	IsSyncedToDataverse	Enum
MainAccount	Main account	String	20
ProcessingBundleId	Bundle id	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidationId	ValidationId	String	100

BudgetAccountStructureValidationStaging (Budget account structure validation import entity)

Name	Label	Type	Length
DataverseGuid	DataverseGuid	String	36
DefinitionGroup	Processing group	String	60
DimensionCombinationsHash	DimensionCombinationsHash	String	64
DimensionCombinationsJson	DimensionCombinationsJson	String	2000
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
MainAccount	Main account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
ValidationId	ValidationId	String	100

BusinessDocumentApplicationResponse (Document application response)

Name	Label	Type	Length
AnchorId	AnchorId	String	50
Notes	Note	String	500
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer
relationType	Relation type field	Big integer
ResponseActionCode	Action code	String	20
ResponseActionCodeDetails	Action code details	String	100
ResponseDomain	Application response domain	Enum
ResponseEnterDateTime	ResponseEnterDateTime	Date time
ResponseGuid	GUID	Guid
ResponseProcessingCode	Response code	String	20
ResponseProcessingCodeDetails	Processing code details	String	100
ResponseReasonCode	Reason code	String	20
ResponseReasonCodeDetails	Reason code details	String	100
ResponseTitle	Title	String	50
ResponseToState	State	Enum
ResponseValue	Amount paid	Real
ResponseValueCurrency	Currency	String	3
ResponseValuePercent	ResponseValuePercent	Real

BusinessDocumentProjInvoiceItemLineV2Staging (Business document project invoice item 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
ItemId	Item number	String	20
LedgerVoucher	Voucher	String	20
LineAmount	Line amount	Real
ProjInvoiceId	Invoice	String	50
ProjInvoiceItemRecId	Record-ID	RecId
ProjInvoiceItemTableId	Table ID	Integer
Qty	Deliver now	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	1000

CustInvoiceJourRegistrationIds (Customer Invoice Registration Id)

Name	Label	Type	Length
CountryRegionId	Country/region	String	10
CustInvoiceJour	Reference	RecId
IsHeadOrPrimary	Is head or primary	Enum
Issuer	Issuing agency	String	60
PartyRole	Party role	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationCategory	Registration category	Enum
RegistrationNumber	Registration number	String	60
RegistrationType	Registration type	String	30
ValidFrom	Effective	Date
ValidTo	Expiration	Date

DimensionHierarchyDeleteAudit (Dimension Hierarchy Delete Audit)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
DimensionHierarchyRecId	Dimension set	RecId
HashKey	Hash key	Guid
HierarchyDescription	Name	String	60
HierarchyName	Dimension tree name	String	60
IsDraft	Draft	Enum
IsSystemGenerated	Auto-generated	Enum
modifiedDateTime	Modified date and time	Date time
modifiedTransactionId	Modified ID	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Dimension Hierarchy Delete Audit Status	Enum
StructureType	Dimension hierarchy type	Enum

DocumentLifecycleAutomationQueue (Document lifecycle framework documents in automation queue)

Name	Label	Type	Length
DocumentAutomationStatus	Document automation status	Enum
DocumentHeaderTableId	Table ID	Integer
DocumentLifecycleAutomationCurrentStage	Document lifecycle stage	Enum
DocumentLifecycleAutomationTargetStage	Document lifecycle stage	Enum
DocumentLifecycleStageTransitionMode	DocumentLifecycleStageTransitionMode	Enum
DocumentRecId	Record-ID	RecId
DocumentType	Document type	Enum
OriginatingCompany	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaskExecutionId	GUID	Guid

DocumentLifecycleEvent (@GlobalDocument:GlobalJournalDocumentLifecycleStageTransition)

Name	Label	Type	Length
DocumentLifecycleStage	Document lifecycle stage	Enum
DocumentLifecycleStageStatus	Document lifecycle status	Enum
DocumentRecId	Reference	RecId
DocumentType	Document type	Enum
EventDateTime	Alert created date and time	Date time
EventId	GUID	Guid
JournalRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaskExecutionId	GUID	Guid

DocumentLifecycleEventDetails (Document lifecycle framework event details for documents)

Name	Label	Type	Length
ActivityStatus	Document lifecycle status	Enum
ApprovalScope	Approval scope	Enum
ApprovalStatus	Approval status	Enum
DocumentLifecycleStageActivity	Document lifecycle stage activities	Enum
DocumentLineRecId	Reference	RecId
DocumentRecId	Reference	RecId
DocumentType	Document type	Enum
ErrorCategory	Error category	Enum
EventId	GUID	Guid
EventUser	User ID	String	20
MessageLabelId	Label ID	String	120
MessageParameters	Blobdata	Bin/Memo/Container
MessageType	Document lifecycle log message type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DOMFulfillmentGroupsProfile (DOM fulfillment groups profile)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FulfillmentGroupId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ProfileId	Profile	String	32
RecId	Record-ID	RecId
recVersion	Record Version	Integer

DOMIntercompanyVendorMapping (DOM Intercompany vendor mapping)

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
SourcingCompanyId	Sourcing company	String	4
VendAccount	Vendor account	String	20

FinancialJournalDocumentStaging (Financial journal documents)

Name	Label	Type	Length
Account	Account	String	20
AccountingCurrencyCreditAmount	Credit - accounting	Real
AccountingCurrencyDebitAmount	Debit - accounting	Real
AccountingDate	Accounting date	Date
AccountType	Account type	Enum
Company	Company	String	4
CurrencyCode	Currency	String	3
DefinitionGroup	Processing group	String	60
Description	Description	String	512
DimensionEight	Dimension8	String	30
DimensionEighteen	Dimension18	String	30
DimensionEleven	Dimension11	String	30
DimensionFifteen	Dimension15	String	30
DimensionFive	Dimension5	String	30
DimensionFour	Dimension4	String	30
DimensionFourteen	Dimension14	String	30
DimensionNine	Dimension9	String	30
DimensionNineteen	Dimension19	String	30
DimensionOne	Dimension1	String	30
DimensionSeven	Dimension7	String	30
DimensionSeventeen	Dimension17	String	30
DimensionSix	Dimension6	String	30
DimensionSixteen	Dimension16	String	30
DimensionTen	Dimension10	String	30
DimensionThirteen	Dimension13	String	30
DimensionThree	Dimension3	String	30
DimensionTwelve	Dimension12	String	30
DimensionTwenty	Dimension20	String	30
DimensionTwo	Dimension2	String	30
DocumentDate	Document date	Date
DocumentNumber	Document number	String	50
DocumentTypeName	Document type setting	String	60
ExecutionId	Job ID	String	90
FinDimension	FinDim	RecId
FinTagDisplayValue	Financial tag	Bin/Memo/Container
Intercompany	Intercompany	Enum
IsCorrection	Correction	Enum
IsSelected	Select	Enum
JournalNumber	Journal batch number	String	20
LedgerName	Ledger name	String	20
LineNumber	Line number	Integer
OffsetAccount	Offset account	String	20
OffsetAccountType	Offset account type	Enum
OffsetCompany	Offset company	String	4
OffsetDescription	Offset description	String	512
OffsetDimensionEight	OffsetDimension8	String	30
OffsetDimensionEighteen	OffsetDimension18	String	30
OffsetDimensionEleven	OffsetDimension11	String	30
OffsetDimensionFifteen	OffsetDimension15	String	30
OffsetDimensionFive	OffsetDimension5	String	30
OffsetDimensionFour	OffsetDimension4	String	30
OffsetDimensionFourteen	OffsetDimension14	String	30
OffsetDimensionNine	OffsetDimension9	String	30
OffsetDimensionNineteen	OffsetDimension19	String	30
OffsetDimensionOne	OffsetDimension1	String	30
OffsetDimensionSeven	OffsetDimension7	String	30
OffsetDimensionSeventeen	OffsetDimension17	String	30
OffsetDimensionSix	OffsetDimension6	String	30
OffsetDimensionSixteen	OffsetDimension16	String	30
OffsetDimensionTen	OffsetDimension10	String	30
OffsetDimensionThirteen	OffsetDimension13	String	30
OffsetDimensionThree	OffsetDimension3	String	30
OffsetDimensionTwelve	OffsetDimension12	String	30
OffsetDimensionTwenty	OffsetDimension20	String	30
OffsetDimensionTwo	OffsetDimension2	String	30
OffsetFinDimension	OffsetFinDim	RecId
OffsetFinTagDisplayValue	Offset financial tag	Bin/Memo/Container
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyCreditAmount	Credit - reporting	Real
ReportingCurrencyDebitAmount	Debit - reporting	Real
ReverseDate	Reversing date	Date
ReverseEntry	Reversing entry	Enum
TransactionCurrencyCreditAmount	Credit	Real
TransactionCurrencyDebitAmount	Debit	Real
TransferStatus	Staging to target status	Enum

FinancialJournalStaging (Financial journals)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
JournalNumber	Journal batch number	String	20
JournalSetting	Journal setting	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
TransferStatus	Staging to target status	Enum

FinDim (FinDim)

Name	Label	Type	Length
CategoryFieldName	Field name	String	81
CategoryFieldValue	RecId of table entry FinDimCustomStripingFieldValue	Big integer
CategoryType	Striping Type	Enum
ColumnOrdinal	Position	Integer
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DataSourceName	Table name	String	81
FinDimTypeId	The FinDim type Class Id	Integer
KeyFieldName	Field name	String	81
Mapping	Field name	String	81
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
NameFieldName	Field name	String	81
ParentDimensionAttribute	Dimension name	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValueFieldName	Field name	String	81

FinDimJob (Optimized financial dimension job)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrentJobStage	FinDimJobStage RecId	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
State	Optimized financial dimension job state	Enum
WorkSize	Work size	Big integer

FinDimJobMessage (Financial dimension job message table)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
ErrorLine	Error line	Integer
ErrorMessage	Error message	Bin/Memo/Container
ErrorNumber	Error number	Integer
ErrorProcedure	Name	String	60
ErrorSeverity	Error severity	Integer
ErrorState	Error state	Integer
FinDimJob	FinDimJob RecId	RecId
MessageType	FinDims message type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimJobStage (Optimized financial dimension job stage)

Name	Label	Type	Length
ChunkSize	Chunk size	Integer
createdDateTime	Created date and time	Date time
FinDimJob	FinDimJob RecId	RecId
Finished	Finished	Enum
OrderId	Order	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TotalWorkComplete	Total work complete	Integer
Type	Optimized financial dimension job stage type	Enum

FinDimLedgerFormat (Financial dimension ledger format)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Ledger	Reference	RecId
Name	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimLedgerFormatLevel (Financial dimension ledger format level)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
FinDim	FinDim RecId	RecId
FinDimLedgerFormat	Ledger format ID	RecId
Ordinal	Position	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimMergeInput (Optimized financial dimension merge input)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
FinDimJob	FinDimJob RecId	RecId
FinDimValueSet1	Dimension Value Set RecId	RecId
FinDimValueSet2	Dimension Value Set RecId	RecId
FinDimValueSet3	Dimension Value Set RecId	RecId
FinDimValueSet4	Dimension Value Set RecId	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Source RecId	RecId

FinDimResolutionInput (FinDim Value Set Resolution Input)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Dimension1	Dimension1	String	30
Dimension2	Dimension2	String	30
Dimension3	Dimension3	String	30
Dimension4	Dimension4	String	30
Dimension5	Dimension5	String	30
Dimension6	Dimension6	String	30
Dimension7	Dimension7	String	30
FinDimJob	FinDimJob RecId	RecId
FinDimResolutionKey	FinDim Resolution Key	String	10
LedgerId	Ledger	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Source RecId	RecId

FinDimResolutionInputHash (FinDim Resolution Internal Hash)

Name	Label	Type	Length
FinDimResolutionInput	Source RecId	RecId
Hash	Hash	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimResolutionOutput (FinDim Value Set Resolution Output)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
FinDimJob	FinDimJob RecId	RecId
FinDimResolutionKey	FinDim Resolution Key	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ResolvedRecId	Resolved RecId	RecId
SourceRecId	Source RecId	RecId

FinDimValidationInput (FinDim validation input)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
DocumentDate	Document date	Date
FinDimJob	FinDimJob RecId	RecId
FinDimValueSet	FinDim value set internal RecId	RecId
Ledger	Ledger	RecId
MainAccountId	Account number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimValidationMessage (FinDims validation messages)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
FinDimValidationInput	FinDimValidationInput RecId	RecId
MessageLabelId	Label ID	String	120
MessageParameters	FinDims message parameters	String	1000
MessageType	FinDims message type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimValidationOutput (FinDim validation output)

Name	Label	Type	Length
FinDimValidationInput	FinDimValidationInput RecId	RecId
IsValid	Valid	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimValueSet (FinDim Value Set)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Dimension1	Dimension1	String	30
Dimension2	Dimension2	String	30
Dimension3	Dimension3	String	30
Dimension4	Dimension4	String	30
Dimension5	Dimension5	String	30
Dimension6	Dimension6	String	30
Dimension7	Dimension7	String	30
Hash	Hash	Bin/Memo/Container
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimValueSetLedgerDimensionMap (Mapping table between FinDim and DimensionAttributeValueCombination)

Name	Label	Type	Length
FinDimValueSetHash	Hash	Bin/Memo/Container
Ledger	Reference	RecId
LedgerDimension	Ledger account	RecId
MainAccountId	Account number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

FinDimValueSetValidCache (FinDim Value Set valid status cache)

Name	Label	Type	Length
ActiveFrom	Active from	Date
ActiveTo	Active to	Date
createdDateTime	Created date and time	Date time
FinDimValueSet	FinDim value set internal RecId	RecId
Ledger	Ledger	RecId
MainAccountId	Account number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

GeneralLedgerDataMaintenanceWork (General ledger data maintenance work)

Name	Label	Type	Length
ActionClassName	Class name	String	81
LatestSettleDate	Calculation date	Date
OpenAccountingCurrencyAmount	Amount	Real
OpenReportingCurrencyAmount	Amount	Real
OpenTransactionCurrencyAmount	Amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TargetSettleStatus	Status	Enum
TransRecId	Reference	RecId

GlobalJournal (Global journal table)

Name	Label	Type	Length
ApprovalStatus	Approval status	Enum
ApprovedBy	Approved by	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
JournalBlockedUserGroupInfo	Blocked by group	RecId
JournalBlockedUserInfo	Blocked by user	RecId
JournalNumber	Journal batch number	String	20
JournalSeries	Journal number series	RecId
JournalSetting	Journal settings (preview)	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum

GlobalJournalDocument (Global journal document)

Name	Label	Type	Length
AccountingDate	Accounting date	Date
AccountingEvent	Accounting event	RecId
ApprovalStatus	Approval status	Enum
ApprovedBy	Approved by	String	20
Company	Company	String	4
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
CurrencyCode	Currency	String	3
DocumentDate	Document date	Date
DocumentNumber	Document number	String	50
DocumentNumberSeries	Document number series	RecId
DocumentType	Document type	Enum
DocumentTypeSetting	Document type setting	RecId
ExchangeRate	Exchange rate	Real
ExchangeRateTriangulation	Secondary exchange rate	Real
GlobalJournal	Reference	RecId
Intercompany	Intercompany	Enum
Ledger	Ledger	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Posted	Posted	Enum
PostedDateTime	Posted on	Date time
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReleaseDate	Release date	Date time
ReleaseDateComment	Release date comment	String	60
ReportingExchangeRate	Reporting exchange rate	Real
ReportingExchangeRateTriangulation	Reporting triangulation exchange rate	Real
ReverseDate	Reversing date	Date
ReverseEntry	Reversing entry	Enum
Voucher	Voucher	String	20
VoucherSeries	Voucher series	RecId

GlobalJournalDocumentLine (Global journal document line)

Name	Label	Type	Length
Account	Account	String	20
AccountingCurrencyCreditAmount	Credit - accounting	Real
AccountingCurrencyDebitAmount	Debit - accounting	Real
AccountType	Account type	Enum
Company	Company	String	4
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
Description	Description	String	512
ExchangeRate	Exchange rate	Real
ExchangeRateTriangulation	Secondary exchange rate	Real
FinDimension	Dimension Value Set RecId	RecId
FinTag	Financial tag	RecId
GlobalJournalDocument	Reference	RecId
IsCorrection	Correction	Enum
LineNumber	Line number	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OffsetAccount	Offset account	String	20
OffsetAccountType	Offset account type	Enum
OffsetCompany	Offset company	String	4
OffsetDescription	Offset description	String	512
OffsetFinDimension	Dimension Value Set RecId	RecId
OffsetFinTag	Offset financial tag	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyCreditAmount	Credit - reporting	Real
ReportingCurrencyDebitAmount	Debit - reporting	Real
ReportingExchangeRate	Reporting exchange rate	Real
ReportingExchangeRateTriangulation	Reporting triangulation exchange rate	Real
TransactionCurrencyCreditAmount	Credit	Real
TransactionCurrencyDebitAmount	Debit	Real

GlobalJournalDocumentLineDistributions (Global journal document line distributions)

Name	Label	Type	Length
AccountingCurrencyAmount	Amount	Real
AccountingCurrencyExchangeRate	Exchange rate adjustment amount	Real
AccountingDate	Accounting date	Date
AccountingEvent	Accounting event	RecId
AccountType	Account type	Enum
FinTag	Financial tag	RecId
ImplementationRecId	Reference	RecId
ImplementationTableId	Reference table ID	Integer
IsCorrection	Correction	Enum
IsOffset	Offset account	Enum
Ledger	Ledger	RecId
LedgerDimension	Ledger account	RecId
LedgerPostingType	Posting type	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
MonetaryAmount	Monetary amount	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	Amount in reporting currency	Real
ReportingCurrencyExchangeRate	Exchange rate	Real
SequenceNumber	Line	Integer
Side	side	Enum
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TransactionCurrencyAmount	Amount in transaction currency	Real
TransactionCurrencyCode	Currency	String	3
TransactionText	Description	String	512

GlobalJournalDocumentSession (Document user session)

Name	Label	Type	Length
GlobalJournalDocument	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session ID	Integer
SessionLoginDateTime	Logon time	Date time

GlobalJournalDocumentTypeSettings (Global journal document type settings)

Name	Label	Type	Length
AllocateVoucherAtPosting	Number allocation at posting	Enum
AllowedCurrencyType	Allow entry in currency	Enum
Approver	Approve	String	10
DefaultCurrency	Default currency	String	3
DocumentNumberSeries	Document number series	RecId
DocumentType	Document type	Enum
DocumentTypeDescription	Description	String	255
DocumentTypeName	Name	String	60
IsApprovalActive	Active	Enum
IsDefaultSetting	Default	Enum
IsDocumentNumberManual	Manual	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VoucherSeries	Voucher series	RecId
Workflow	Workflow	String	20

GlobalJournalDocumentTypeSettingsCompanyOverride (Global journal document type settings company override)

Name	Label	Type	Length
AllocateVoucherAtPosting	Number allocation at posting	Enum
AllowedCurrencyType	Allow entry in currency	Enum
Approver	Approve	String	10
Company	Company	String	4
DefaultCurrency	Default currency	String	3
DocumentNumberSeries	Document number series	RecId
GlobalJournalDocumentTypeSettings	Global journal document type settings	RecId
IsApprovalActive	Active	Enum
IsDocumentNumberManual	Manual	Enum
Ledger	Ledger	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VoucherSeries	Voucher series	RecId
Workflow	Workflow	String	20

GlobalJournalRule (Global journal rule)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Description	Rule name	String	500
DocumentType	Document type	Enum
Enabled	Enabled	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Rule name	String	60
PowerFxFormula	Power Fx formula	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer

GlobalJournalSettingDocumentTypeSettingAssignment (Journal setting and document type setting assignment)

Name	Label	Type	Length
DocumentTypeSetting	Document type setting	RecId
JournalSetting	Journal settings (preview)	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

GlobalJournalSettings (Journal settings (preview))

Name	Label	Type	Length
Approver	Approve	String	10
AssignedUserGroup	Private for user group	String	10
Description	Description	String	255
GlobalJournalType	Journal type	Enum
IsApprovalActive	Active	Enum
IsDefaultSetting	Default	Enum
JournalNumberSeries	Journal number series	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
PostingLayer	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SummarizeAcrossVouchers	Summarize across vouchers	Enum
Workflow	Workflow	String	20

GUPCategoryPriceRuleGroupStaging (Category price rule groups)

Name	Label	Type	Length
CategoryHierarchyName	Name	String	128
Code	Category price rule groups	String	10
DefinitionGroup	Processing group	String	60
Description	Name	String	60
ExecutionId	Job ID	String	90
IsGUPCategoryPriceRuleGroup	IsGUPCategoryPriceRuleGroup	Enum
IsSelected	Select	Enum
PriceGroupId	Comparison price group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SaveAddData	Save pricing data	Enum
SaveBasePrice	Enable price basis	Enum
SaveInventoryCost	Enable inventory cost price	Enum
SaveOtherGroupPrice	Enable comparison price	Enum
SaveSalesPrice	Enable sales price	Enum
TransferStatus	Staging to target status	Enum

GUPCategoryPriceRuleStaging (Category price rules)

Name	Label	Type	Length
AmountPercent	Amount/Percent	Real
CategoryHierarchyName	Name	String	128
CategoryName	Name	String	254
DefinitionGroup	Processing group	String	60
ExactlyMatched	Exactly Matched	Enum
ExecutionId	Job ID	String	90
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Header exclusion	String	500
HeaderExclusionType	Header exclusion type	Enum
IsGUPCategoryPriceRule	IsGUPCategoryPriceRule	Enum
IsSelected	Select	Enum
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Line exclusion	String	500
LineExclusionType	Line exclusion type	Enum
LineNumber	Line number	Real
PriceApplyAdjustment	Allow price adjustment	Enum
PriceAttributeGroupNameHeader	Header price attribute group	String	60
PriceAttributeGroupNameLine	Line price attribute group	String	60
PriceBasis	Price basis	Enum
PriceComponentCombination	Price attribute group combination	RecId
PriceGroup	Price group	String	10
PricePreventDiscount	Prevent discount	Enum
PriceSetupType	Price rule	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SmartRoundingGroup	Rounding version	String	10
TransferStatus	Staging to target status	Enum
UnitAppliesToAll	Allow unit conversion	Enum
UnitId	Unit	String	10
VendorAccount	Vendor account	String	20

GUPItemBasePriceAllHistoryStaging (All base prices)

Name	Label	Type	Length
ActivationDate	Activation date	Date
Calculated	Calculated	Enum
configId	Configuration	String	50
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
inventBatchId	Batch number	String	20
InventColorId	Color	String	10
InventDimId	Dimension number	String	20
InventGtdId_RU	GTD number	String	30
InventLocationId	Warehouse	String	10
InventOwnerId_RU	Owner	String	40
InventProfileId_RU	Inventory profile	String	10
inventSerialId	Serial number	String	20
InventSiteId	Site	String	10
InventSizeId	Size	String	10
InventStatusId	Inventory status	String	10
InventStyleId	Style	String	10
IsSelected	Select	Enum
ItemDisplayName	Product name	String	60
ItemId	Item number	String	20
LicensePlateId	License plate	String	25
Markup	Price charges	Real
MarkupQty	Charges quantity	Real
Price	Price	Real
PriceAllocateMarkup	Incl. in unit price	Enum
PriceCreatedDateTime	Created date and time	Date time
PriceQty	Price quantity	Real
PriceType	Base price type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SHA1HashHex	Hash code	String	40
TransferStatus	Staging to target status	Enum
UnitId	Unit	String	10
VersionId	Version	String	10
wMSLocationId	Location	String	10

GUPSalesOrderAttributeValueStaging (Sales order attributes - Pricing management)

Name	Label	Type	Length
AttributeName	Name	String	60
AttributeTypeName	Attribute type name	String	60
BooleanValue	Boolean	Enum
DecimalValue	Float	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IntValue	Integer value	Integer
IsSalesLine	IsSalesLine	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesDataAreaId	Company	String	4
SalesId	Sales order	String	20
SalesLineNumber	Line number	Real
TextValue	Text	String	1999
TransferStatus	Staging to target status	Enum

GUPSalesQuotationAttributeValueStaging (Sales quotation attributes - Pricing management)

Name	Label	Type	Length
AttributeName	Name	String	60
AttributeTypeName	Attribute type name	String	60
BooleanValue	Boolean	Enum
DecimalValue	Float	Real
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IntValue	Integer value	Integer
IsSalesQuotationLine	IsSalesQuotationLine	Enum
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesQuotationDataAreaId	Company	String	4
SalesQuotationId	Quotation	String	20
SalesQuotationLineNumber	Line number	Real
TextValue	Text	String	1999
TransferStatus	Staging to target status	Enum

InventTransArchiveBundle (Inventory transaction archive task)

Name	Label	Type	Length
BatchTaskId	Batch task Id	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session	String	38

InventTransArchiveValidationResult (Validation results)

Name	Label	Type	Length
ErrorMessage	Error message	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session	String	38
Status	Validation status	Enum
ValidationType	Validation type	Enum

LTMUninvoicedSalesOrdersAuditLog (Uninvoiced packing slip files submission log)

Name	Label	Type	Length
AuditCode	Audit code	String	50
AuditDateTime	Created date and time	Date time
CompanyId	Company	String	4
CompanyName	Company name	String	60
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
File	Archive file	Bin/Memo/Container
InfologData	Infolog data	Bin/Memo/Container
MailFrom	Email from	String	80
MailTo	Email to	String	80
PackingSlipsQty	Uninvoiced packing slips	Real
PeriodDate	Closing date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SendStatus	Send status	Enum
Sequential	Sequential number	Integer
SourceCode	Source code	String	20
UserId	User ID	String	20

LTMUninvoicedSalesOrdersParameters (Audit parameters for uninvoiced packing slips)

Name	Label	Type	Length
AuditCode	Audit code	String	50
CompanyName	Company name	String	160
Email	Email	String	80
Key	ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialNumber	Serial number	String	25
SourceCode	Source code	String	20

LTRDataRecoveryStagingTable (LTR Data Loss Recovery Staging Table)

Name	Label	Type	Length
Data	Data	String	4000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceSysDataStateCode	SourceSysDataStateCode	Enum
SourceSysRowVersion	SourceSysRowVersion	Big integer
TableName	Table name	String	81

LTRDataRecoveryStagingTableA (LTR Data Loss Recovery Staging Table A)

Name	Label	Type	Length
Data	Data	String	4000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceSysDataStateCode	SourceSysDataStateCode	Enum
SourceSysRowVersion	SourceSysRowVersion	Big integer
TableName	Table name	String	81

LTRDataRecoveryStagingTableB (LTR Data Loss Recovery Staging Table B)

Name	Label	Type	Length
Data	Data	String	4000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceSysDataStateCode	SourceSysDataStateCode	Enum
SourceSysRowVersion	SourceSysRowVersion	Big integer
TableName	Table name	String	81

LTRDataRecoveryStagingTableC (LTR Data Loss Recovery Staging Table C)

Name	Label	Type	Length
Data	Data	String	4000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceSysDataStateCode	SourceSysDataStateCode	Enum
SourceSysRowVersion	SourceSysRowVersion	Big integer
TableName	Table name	String	81

LTRDataRecoveryStagingTableD (LTR Data Loss Recovery Staging Table D)

Name	Label	Type	Length
Data	Data	String	4000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceSysDataStateCode	SourceSysDataStateCode	Enum
SourceSysRowVersion	SourceSysRowVersion	Big integer
TableName	Table name	String	81

McpBusinessSkill (Business skills)

Name	Label	Type	Length
Body	Body	Bin/Memo/Container
Description	Description	String	1000
Name	Name	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SkillId	SkillId	String	50

McpSearchIndex (McpSearchIndex)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Embeddings	Embeddings	Bin/Memo/Container
ItemName	ItemName	String	250
ItemType	ItemType	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceRecId	ReferenceRecId	Big integer
TextToEmbed	TextToEmbed	Bin/Memo/Container

ProjInvoiceJourRegistrationIds (Project invoice registration ID)

Name	Label	Type	Length
CountryRegionId	Country/region	String	10
IsHeadOrPrimary	Is head or primary	Enum
Issuer	Issuing agency	String	60
PartyRole	Party role	Enum
ProjInvoiceJour	Project invoice journal	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationCategory	Registration category	Enum
RegistrationNumber	Registration number	String	60
RegistrationType	Name	String	30
ValidFrom	Effective	Date
ValidTo	Expiration	Date

ProjVendInvoiceActualsMatching (Vendor invoice - actuals connection)

Name	Label	Type	Length
ActualsImportId	Actuals import id	Guid
InvoiceNum	Invoice	String	50
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubConLineNumber	Subcontract Line	String	20
SubConProductReceiptId	Product receipt	String	20
VendInvoiceInfoLineRefRecId	Reference	RecId
VendInvoiceInfoTableRecId	Reference	RecId

PurchCopilotDMAMitigationAgentTask ()

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

PurchCopilotGenAction ()

Name	Label	Type	Length
ActionCoordinationInstructions	Instructions	String	300
ActionUsageInstructions	Instructions	String	300
ClassName	Class	String	200
Description	Description	String	60
DisplayLabel	Display label	String	100
GenEntity	GenEntity	Big integer
IsManagedByMicrosoft	Service managed	Enum
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenActionInstance ()

Name	Label	Type	Length
Action	Reference	RecId
ActionPlan	Reference	RecId
LegalEntity	LegalEntity	String	10
Reasoning	Reasoning	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Sequence	Sequence	Integer
Status	Status	Enum

PurchCopilotGenActionParameter ()

Name	Label	Type	Length
Action	Action	Big integer
GenEntityField	Reference	RecId
IsManagedByMicrosoft	Service managed	Enum
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenActionPlan ()

Name	Label	Type	Length
ActionPlanJson	ActionPlanJson	Bin/Memo/Container
Email	Reference	RecId
Issues	Issues	String	200
ReceivedDateTime	ReceivedDateTime	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
Summary	Summary	String	200

PurchCopilotGenEntity ()

Name	Label	Type	Length
Description	Description	String	60
EntityName	Entity name	String	100
Instruction	Instructions	String	300
IsManagedByMicrosoft	Service managed	Enum
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Scenario	Scenario	Big integer
TitleField	TitleField	Big integer

PurchCopilotGenEntityCandidateTmp ()

Name	Label	Type	Length
Name	Name	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityCell ()

Name	Label	Type	Length
ActionDetected	ActionDetected	Enum
DataType	DataType	Enum
DateValue	DateValue	Date
EnumAsStringValue	EnumAsStringValue	String	100
Field	Reference	RecId
IntegerValue	IntegerValue	Integer
RealValue	RealValue	Real
RecId	Record-ID	RecId
Record	Reference	RecId
recVersion	Record Version	Integer
StringValue	StringValue	String	100
WasDetectedInEmail	WasDetectedInEmail	Enum

PurchCopilotGenEntityEmailFilter ()

Name	Label	Type	Length
Email	Email	Big integer
EntityValue	EntityValue	Big integer
Field	Field	Big integer
FilterValue	FilterValue	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityEmailFilterValue ()

Name	Label	Type	Length
EnumValue	EnumValue	Integer
IntegerValue	IntegerValue	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TextValue	TextValue	String	100

PurchCopilotGenEntityEmailTitle ()

Name	Label	Type	Length
Email	Email	Big integer
EntityValue	EntityValue	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Title	Title	String	100

PurchCopilotGenEntityField ()

Name	Label	Type	Length
DataType	Data type	Enum
Description	Description	String	300
DisplayOrder	Display order	Integer
Entity	Reference	RecId
EntityFieldName	Entity field	String	100
Instruction	Instructions	String	300
IsFilter	Is filter	Enum
IsIdentifier	Is identifier	Enum
IsKey	Is key	Enum
IsManagedByMicrosoft	Service managed	Enum
IsVirtual	Is virtual	Enum
IsVisible	Is visible	Enum
Label	Display label	String	100
Name	Name	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityFieldCandidateTmp ()

Name	Label	Type	Length
DataType	DataType	Enum
Entity	Entity	Big integer
Name	Name	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityFieldLookup ()

Name	Label	Type	Length
EntityName	EntityName	String	100
FieldName	FieldName	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityRecord ()

Name	Label	Type	Length
ActionInstance	Reference	RecId
Entity	Reference	RecId
Parent	Parent	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Type	Type	Enum
UserAction	UserAction	Enum

PurchCopilotGenEntityRelation ()

Name	Label	Type	Length
Child	Child	Big integer
IsManagedByMicrosoft	Service managed	Enum
Name	Name	String	100
Parent	Parent	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotGenEntityScenario ()

Name	Label	Type	Length
IsActive	IsActive	Enum
Name	Entity name	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Type	Type	Enum

ReconciliationAutomationPostingProfileChangeHistory ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
IsActive	IsActive	Enum
Ledger	Ledger	RecId
MainAccount	Main account	RecId
MainAccountId	Main account	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
ReconciliationModule	Reconciliation automation module	Enum
recVersion	Record Version	Integer
SourceFieldId	Field ID	Integer
SourceRecId	Reference	RecId
SourceTableId	Table ID	Integer

RegistrationCategoriesAdvancedRules (Invoice party applicability rules)

Name	Label	Type	Length
AddressPurpose	Purpose	String	1000
IsPrimary	Primary	Enum
PartyRole	Party role	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxRegistrationLegislationType	Reference	RecId
TaxRegistrationTypeApplicabilityRule	Registration type	RecId

RegistrationCategoriesAdvancedRulesRoles (Registration categories advanced rules roles)

Name	Label	Type	Length
LogisticsLocationRoleType	Type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationCategoriesAdvancedRule	Reference	RecId

RegistrationCategoriesAdvancedRulesStaging (Invoice party applicability rules)

Name	Label	Type	Length
AddressPurpose	Purpose	String	1000
CountryRegionId	Country/region	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
PartyRole	Party role	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationType	Name	String	30
RegistrationTypesList	Registration category	Enum
TransferStatus	Staging to target status	Enum

RentalAssetDeprSMUBasedUsageHistoryJournalLine (Journal line - rental item usage history relation table)

Name	Label	Type	Length
LedgerJournalTransRefRecId	Depreciation journal line reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemUsageHistoryRefRecId	Rental item usage history reference	RecId
Reversed	Reversed	Enum

RentalAttachmentRule (Attachment validity rules)

Name	Label	Type	Length
AttachmentGroupCode	Attachment group code	RecId
AttachmentModel	Attachment model	RecId
GroupCode	Group code	RecId
Model	Model	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SuggestedForRental	Suggested for rental	Enum

RentalAttachmentTrans (Attachment transactions)

Name	Label	Type	Length
AttachedFromItem	Detached from	String	20
AttachedToItem	Attached to rental item	String	20
AttachmentItemId	Attachment ID	String	20
createdBy	Created by	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDateTime	Date and time	Date time

RentalBestRateCalculationJournalLine (Best rate calculation journal lines)

Name	Label	Type	Length
BestRateCalculationJournalTable	Journal ID	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DayAmount	Day	Real
Days	Days	Integer
EndSMU	End SMU	Real
EndSMUReadingDateTime	Reading date	Date time
EstimatedDateTime	Estimated return date	Date time
HasFixedEstimatedDate	Fixed estimated return date	Enum
HasFixedStartDate	Fixed start date	Enum
HoursAllowed	Hours allowed	Real
InventSerialId	Serial number	String	20
InvoicedAmount	Invoiced amount	Real
InvoicedToDate	Invoiced to	Date
InvoicingAmount	Invoicing amount	Real
IsMainLine	Main line	Enum
MaxAmount	Maximum amount	Real
Month28Amount	Month28	Real
MonthAmount	Month	Real
Months	Months	Integer
Months28	Month28	Integer
OvertimeFee	Overtime fee	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalClassId	Rental class	String	20
RentalDocumentLine	Rental document line	RecId
RentalItemId	Rental item number	String	20
SMUBasedCharge	SMU based charge	Enum
SMUOvertime	SMU overtime	Real
SMUOvertimeInvoicing	SMU overtime invoicing	Enum
SMURate	SMU rate	Real
SMUUsage	Usage	Real
StandDownInvoicedAmount	Invoiced	Real
StandDownInvoicedDays	Days invoiced	Integer
StandDownInvoicedHours	Hours invoiced	Integer
StandDownNotInvoicedAmount	Not invoiced	Real
StandDownNotInvoicedDays	Days not invoiced	Integer
StandDownNotInvoicedHours	Hours not invoiced	Integer
StartDateTime	Start date	Date time
StartSMU	SMU when shipped out	Real
StartSMUReadingDateTime	Reading date	Date time
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TotalLineAmount	Total amount	Real
Validated	Best rate calculation journal line validation statuses	Enum
Week	Week	Integer
WeekAmount	Week	Real

RentalBestRateCalculationJournalTable (Best rate calculation journals)

Name	Label	Type	Length
AdditionalPaymentAmount	Additional payments	Real
Approved	Approved	Enum
BalanceAmount	Balance	Real
EstimatedDateTime	Estimated return date	Date time
GrossInvoicingAmount	Gross invoicing amount	Real
JournalId	Calculation	String	20
JournalPaymentAmount	Journal payments	Real
NetTotalAmount	Amount	Real
Prorate	Prorate calculation	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental ID	RecId
SalesTaxAmount	Sales tax	Real
StartDateTime	Start date	Date time
TotalAmount	Gross amount	Real
TotalInvoicedAmount	Total invoiced amount	Real
TotalInvoicingAmount	Total invoicing amount	Real
TotalSalesTaxAmount	Total sales tax	Real

RentalBillingScenario (Rental billing scenarios)

Name	Label	Type	Length
BillingScenarioId	Billing scenario	String	10
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalBillingScenarioPrice (Billing scenario prices)

Name	Label	Type	Length
BillingScenario	Rental billing scenarios	RecId
GraceDays	Grace days	Integer
PricePeriod	Price period	RecId
PriceSequenceNum	Sequence number	Integer
RecId	Record-ID	RecId
RecurrenceNum	Recurrence number	Integer
recVersion	Record Version	Integer

RentalCallOff (Call-offs)

Name	Label	Type	Length
CallOffDateTime	Call-off date and time	Date time
CallOffId	Call-off ID	String	10
CancelledBy	Cancelled by	String	20
CancelledDateTime	Cancelled date/time	Date time
CancelledReason	Reason code	RecId
ContactPersonId	Contact ID	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustAccount	Customer account	String	20
InventSerialId	Serial number	String	20
ItemMovementId	Rental item movement ID	String	10
Model	Model	RecId
Note	Note	String	254
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalItemTable	Rental item	RecId
ReturnDate	Return date	Date
Status	Call-off status	Enum

RentalCancelledCallOffReasonCode (Cancelled call-off reason codes)

Name	Label	Type	Length
CodeId	Reason code	String	10
Name	Name	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalCarryingCostRunningHistoryLog (Carrying cost running history log)

Name	Label	Type	Length
AssetId	Fixed asset number	String	20
BookId	Book	String	10
LedgerJournalTransRefRecId	Reference	RecId
PeriodEndDate	Period end date	Date
PeriodStartDate	Period start date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemId	Rental item number	String	20

RentalCategory (Rental categories)

Name	Label	Type	Length
CategoryId	Rental category	String	20
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalClassAttachmentSuggestion (Rental class attachment suggestions)

Name	Label	Type	Length
AttachmentClassTable	Rental class	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemClassTable	Rental class	RecId

RentalClassBulkItemSuggestion (Rental class bulk item suggestions)

Name	Label	Type	Length
ItemId	Item number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemClassTable	Rental class	RecId

RentalClassException (Rental class exceptions)

Name	Label	Type	Length
ActualClassTable	Actual rental class	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Reason	Reason	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalDocumentTable	Rental ID	RecId
SuggestedClassTable	Suggested rental class	RecId

RentalClassInventTable (Rental class items)

Name	Label	Type	Length
ConfigId	Configuration	String	50
IsDefault	Default	Enum
ItemId	Item number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalClassId	Rental class	String	20

RentalClassLine (Rental class lines)

Name	Label	Type	Length
ChildClassTable	Rental class	RecId
ClassTable	Rental class	RecId
IsDefault	Default	Enum
NoLimit	Any	Enum
Qty	Quantity	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
RevenuePct	Revenue pct	Real

RentalClassTable (Rental classes)

Name	Label	Type	Length
Category	Rental category	RecId
ClassId	Rental class	String	20
Name	Name	String	60
Note	Note	Bin/Memo/Container
Package	Package	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxItemGroup	Item sales tax group	String	10

RentalContractLineBestRate (Contract line best rates)

Name	Label	Type	Length
ContractLine	Rental document line	RecId
CustAccount	Customer account	String	20
DailyRate	Daily rate	Real
Days	Days	Integer
EndSMU	End SMU	Real
EndSMUReadingDate	Reading date	Date
HoursAllowed	Hours allowed	Real
InvoicedAmount	Invoiced amount	Real
InvoicedTo	Invoiced to	Date
IsProrate	Prorate calculation	Enum
IsSaved	Saved	Enum
IsSMUOvertimeInvoicing	SMU overtime invoicing	Enum
LastDateTime	Last date/time	Date time
MonthlyRate	Monthly rate	Real
Months	Months	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceDate	Reference date	Date
RentalClassTable	Rental class	RecId
SMURate	SMU rate	Real
StartDate	Start date	Date
StartSMU	SMU when shipped out	Real
StartSMUReadingDate	Reading date	Date
WeeklyRate	Weekly rate	Real
Weeks	Weeks	Integer

RentalContractPaymentReferences (Rental contract payment references)

Name	Label	Type	Length
CustTrans	Reference	RecId
LedgerJournalTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocument	Rental ID	RecId

RentalCreditReasonCode (Credit reason codes)

Name	Label	Type	Length
CodeId	Reason code	String	50
Description	Description	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalCustInvoiceJour (Rental customer invoice journals)

Name	Label	Type	Length
CustInvoiceJour	Reference	RecId
InvoiceScheduleTable	Invoice schedule ID	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemTable	Rental item	RecId
SYSDATASTATECODE	SYSDATASTATECODE	Enum

RentalCustInvoiceTrans (Rental customer invoice transactions)

Name	Label	Type	Length
AttachToLineNumber	Attached to a line	Real
CreditNoteInvoiceId	Invoice number	String	20
CustInvoiceTrans	Reference	RecId
InvoiceScheduleLine	Invoice schedule line	RecId
OverAllowance	Over allowance	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId

RentalCustTable (Rental customers)

Name	Label	Type	Length
CustTable	Reference	RecId
DiscountGroup	Rental discount group	RecId
FixedRate	Fixed rate	Enum
NoticeToOwnerExempt	Notice to owner exempt	Enum
PostingProfile	Accounts receivable posting profile	String	10
PurchOrderNumberRequired	PO number required	Enum
RateGroup	Rental rate group	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalCustTransCalculatedFields (Calculated customer transaction fields)

Name	Label	Type	Length
Balance	Balance	Real
CollectorName	Internal collections contact	String	60
CreationDate	Created	Date
CustTrans	Reference	RecId
DaysPastDue	Days past due	Integer
DueDate	Due date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDamageCode (Damage codes)

Name	Label	Type	Length
CodeId	Damage code	String	10
Description	Description	String	200
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDamageDecisionCode (Damage decision codes)

Name	Label	Type	Length
CodeId	Damage decision	String	20
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDamageHistory (Damage history)

Name	Label	Type	Length
AssignedTo	Assigned to	RecId
CommitmentDate	Commitment date	Date
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustomerResponsibilityAmount	Customer responsibility	Real
DamageCode	Damage code	RecId
DamageDecision	Damage decision	RecId
DamageDescription	Damage description	String	200
DamageHistoryId	Rental item damage history ID	String	20
DamageInvoicedAmount	Damage invoiced amount	Real
DamageInvoicedOn	Damage invoiced on	String	50
DamageStatus	Status	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
RecoveryStatus	Recovery status	RecId
recVersion	Record Version	Integer
RentalItemMovementAgreementRelation	Agreement relation (Rental item movement)	String	21
RentalItemMovementTable	Rental item movement ID	RecId
RentalItemTable	Rental item	RecId
RepairDate	Repaired on	Date time
ResponsibleAgreement	Responsible agreement	String	21
ResponsibleCustVendAccount	Responsible customer / vendor	String	20
ResponsibleRentalItemMovementTable	Responsible rental item movement	RecId
User	User ID	String	20

RentalDamageRecoveryStatus (Damage recovery statuses)

Name	Label	Type	Length
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StatusId	Damage recovery status	String	20

RentalDocumentJournalLine (Rental journal lines)

Name	Label	Type	Length
ApplicationPriceFactor	Application	RecId
BillingScenario	Rental billing scenarios	RecId
ClassTable	Rental class	RecId
InvoiceFromDate	Invoice from	Date
InvoiceUntilDate	Invoice until	Date
Name	Name	String	30
ParentJournalLine	Main transaction record ID	RecId
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentJournalTable	Journal ID	RecId
RentalDocumentLine	Rental document line	RecId
RevenueCategory	Revenue categories	RecId
ShiftPriceFactor	Shift	RecId
StorePriceFactor	Store	RecId
TemplateLineId	Rental template line	String	10

RentalDocumentJournalLineItem (Rental journal line items)

Name	Label	Type	Length
AskingPrice	Asking price	Real
AttachedTo	Rental document journal line item reference	RecId
PrimeProduct	Prime product	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentJournalLine	Main transaction record ID	RecId
RentalDocumentLineItem	Rental document line item reference	RecId
RentalItem	Rental item	RecId
StartSMU	SMU when shipped out	Real

RentalDocumentJournalLinePrice (Rental journal line prices)

Name	Label	Type	Length
Amount	Amount	Real
DiscAmount	Discount amount	Real
DiscPct	Discount percentage	Real
HeaderDiscPct	Header discount percentage	Real
HoursAllowed	Hours allowed	Real
InvoiceStatus	Invoice status	Enum
Period	Period	RecId
RateAmount	Rate	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentJournalLine	Main transaction record ID	RecId
RentalDocumentLinePrice	Price line	RecId
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalDocumentJournalTable (Rental journals)

Name	Label	Type	Length
BusRelAccount	Prospect	String	20
CurrencyCode	Currency	String	3
CustAccount	Customer account	String	20
InvoiceAccount	Invoice customer	String	20
JobSite	Job site	RecId
JournalDocumentNumber	Document number	String	20
JournalId	Journal ID	String	10
PrintDate	Print date	Date
QuotationExpiryDate	Expiration date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental ID	RecId
RentalTemplate	Rental template	RecId
StartDateTime	Start date and time	Date time
UpdateDate	Update date	Date

RentalDocumentLine (Rental document lines)

Name	Label	Type	Length
AdjustedFirstMonth	Adjusted first month	Enum
Amount	Amount	Real
ApplicationPriceFactor	Application	RecId
ApprovalRequired	Approval required	Enum
AttachedTo	Attached to line ID	RecId
BestSMUCalculated	Best SMU calculated	Enum
BillingScenario	Rental billing scenarios	RecId
BulkItemId	Item number	String	20
CalculationBase	Calculation base	Enum
CallOffDate	Call-off date	Date
createdBy	Created by	String	20
DefaultDimension	Dimension	RecId
EndDateTime	End date/time	Date time
EstReturnDateTime	Estimated return date and time	Date time
FinalInvoice	Final invoice	Enum
InsuranceExpiryLog	Insurance expiry log ID	RecId
InvoiceFromDate	Invoice from	Date
InvoiceUntilDate	Invoice until	Date
IsMainLine	Main line	Enum
IsMiscCharge	Misc. charge	Enum
JobSite	Job site	RecId
LiabilityInsurance	Liability insurance	RecId
LineNotes	Line notes	String	250
LineNum	Line number	Real
LineStatus	Line status	Enum
LineType	Line type	Enum
LogisticsPostalAddress	Address	RecId
MaxAmount	Maximum amount	Real
MiscChargeType	Misc. charge type	Enum
modifiedBy	Modified by	String	20
Name	Name	String	30
NextInvoiceDueDate	Next invoice due date	Date
NoFee	No fee	Enum
NoFeeOnNegative	No invoice on credit	Enum
NoticeToOwner	Notice to owner	RecId
OvertimeBillingMethod	Overtime billing method	Enum
ParentDocumentLine	Parent line ID	RecId
Percent	Percent	Real
PickupInventLocationId	Pickup warehouse	String	10
PreviousLineStatus	Line status	Enum
PropertyInsurance	Property insurance	RecId
PurchPrice	Line purchase price	Real
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalClass	Rental class	RecId
RentalDocumentTable	Rental ID	RecId
RentalRateType	Rental rate type	Enum
RevenueCategory	Revenue categories	RecId
ShiftPriceFactor	Shift	RecId
ShipFromInventLocationId	Ship from warehouse	String	10
ShipTo	Ship to	Enum
SMUBasedCharge	SMU based charge	Enum
SMUMinHours	Minimum hours	Real
SMUMinHoursModified	SMUMinHoursModified	Enum
SMUPeriodEndDateTime	End date/time	Date time
SMUPeriodStartDateTime	Start date/time	Date time
SMUUsage	Usage	Real
StartDateTime	Start date/time	Date time
StorePriceFactor	Store	RecId
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TemplateLineId	Rental template line	String	10
UseSeparateAddress	Use separate address	Enum

RentalDocumentLineCalendarJour (Calendar calculation journals)

Name	Label	Type	Length
Credit	Credit	Enum
EndDate	End date	Date
FinalPeriod	Final period	Enum
InvoiceAmount	Invoice amount	Real
InvoiceScheduleId	Invoice schedule	String	21
LineNumber	Line number	Real
NumberOfDays	Number of days	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Main line	RecId
StartDate	Start date	Date
Status	Calendar journal status	Enum

RentalDocumentLineHours (Rental document line hours)

Name	Label	Type	Length
AdditionalHours	Additional hours	Real
CallOffDateTime	Call-off date and time	Date time
Closed	Closed	Enum
DocumentLine	Rental document line	RecId
DocumentLinePrice	Price line	RecId
EndDateTime	End date/time	Date time
HourlyRate	Hourly rate	Real
Hours	Hours	Real
InvoicedAmount	Invoiced amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDateTime	Start date/time	Date time

RentalDocumentLineItem (Rental document line items)

Name	Label	Type	Length
AskingPrice	Asking price	Real
ClassTable	Rental class	RecId
ClosedBy	Closed by	String	20
ClosedDateTime	Closed time	Date time
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DeliveryDate	Delivery date	Date
DocumentType	Document type	Enum
EndDateTime	End date/time	Date time
EndFuelLevel	End fuel	Real
EndSMU	End SMU	Real
EstimatedReturnDateTime	Estimated return date and time	Date time
InvoiceFrom	Invoice from	Date
InvoiceUntil	Invoice until	Date
IsRevenueSplitForSwappedItem	Split	Enum
PickupDate	Pickup date	Date
PrimeProduct	Prime product	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalDocumentTable	Rental ID	RecId
RentalItem	Rental item	RecId
ReplacedDocumentLineItem	Replaced rental item	RecId
Reservation	Reservation ID	RecId
RevenuePct	Revenue pct	Real
StartDateTime	Start date/time	Date time
StartFuelLevel	Start fuel	Real
StartSMU	SMU when shipped out	Real
Status	Status	Enum

RentalDocumentLinePrice (Rental document line prices)

Name	Label	Type	Length
Amount	Amount	Real
BestRateCalculationOvertimeValue	Best rate calculation overtime value	Real
BestRateCalculationStatus	Best rate calculation status	Enum
BillingScenarioChangedDate	Billing changed on	Date
BillingScenarioChangedToPeriod	Billing changed to	RecId
DiscAmount	Cash discount amount	Real
DiscPct	Discount percentage	Real
HeaderDiscPct	Header discount percentage	Real
HoursAllowed	Hours allowed	Real
InvoiceCounter	Invoice counter	Integer
InvoiceDays	Invoice days	Integer
InvoicedToDate	Invoiced to	Date
InvoiceStatus	Invoice status	Enum
Period	Period	RecId
ProratedOvertime	Prorated overtime	Real
RateAmount	Rate	Real
RecId	Record-ID	RecId
RecurrenceNumber	Recurrence number	Integer
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalRateType	Rental rate type	Enum
SequenceNumber	Sequence number	Integer
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalDocumentStatusLog (Rental document status change log)

Name	Label	Type	Length
ContractStatus	Contract status	Enum
createdDateTime	Created date and time	Date time
QuotationStatus	Quotation status	Enum
Reason	Reason	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Reference	RecId
Responsible	Responsible	RecId

RentalDocumentTable (Rental documents)

Name	Label	Type	Length
BusRelAccount	Prospect	String	20
CompoundInterest	Compound interest	Enum
ContactPersonId	Contact ID	String	20
ContactPersonName	Name	String	60
ContactPersonPhone	Telephone	String	20
ContractStatus	Contract status	Enum
createdBy	Created by	String	20
CurrencyCode	Currency	String	3
CustomerPONumber	Customer Purchase order number	String	30
DefaultDimension	Dimension	RecId
DeliveryPostalAddress	Address	RecId
DieselCalculation	Diesel calculation	Enum
DieselPrice	Diesel price	Real
DocumentConvertedFrom	Converted from	RecId
DocumentConvertedTo	Converted to	RecId
DocumentType	Document type	Enum
EndDate	End date	Date
EstimatedReturnDateTime	Estimated return date and time	Date time
FuelCalculation	Fuel calculation	Enum
FuelPrice	Fuel price	Real
HasCashPayment	Has cash payment	Enum
HeaderDiscPct	Header discount percentage	Real
HeaderNotes	General contract notes	String	255
InterestCalcStartDate	Interest start date	Date
InvoiceAccount	Invoice customer	String	20
InvoicedRentalItem	Rental item	RecId
InvoiceFromDate	Invoice from	Date
InvoiceInfo	Invoice info	String	600
InvoiceMethod	Invoice method	RecId
InvoicePostalAddress	Postal address	RecId
InvoiceUntilDate	Invoice until	Date
IsRentalPurchaseOption	Rental purchase option	Enum
ItemMovementReasonCode	Rental item movement reason	RecId
JobSite	Job site	RecId
JobSiteContactId	Contact ID	String	20
JobSiteContactName	Job site contact name	String	160
JobSiteContactPhone	Telephone	String	20
JobSitePostalAddress	Jobsite address	RecId
LiabilityInsurance	Liability insurance	RecId
modifiedBy	Modified by	String	20
NoticeToOwner	Notice to owner	RecId
OnsiteContactInformation	Onsite information	String	255
OpportunityId	Opportunity ID	String	10
PaymTermId	Terms of payment	String	100
PickupInventLocationId	Pickup warehouse	String	10
PrintDate	Print date	Date
ProformaContractTotalAmount	Proforma contract total	Real
PropertyInsurance	Property insurance	RecId
QuotationExpiryDate	Expiry date	Date
QuotationReasonId	Reason	String	20
QuotationStatus	Quotation status	Enum
QuotationType	Quotation type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalId	Rental ID	String	21
RentalLocationId	Rental locations	String	100
RentalPurchaseOptionInterestRecId	Interest calculation	RecId
RentalPurchaseOptionInterestType	Interest type	Enum
RentalPurchaseOptionMaxTerm	Maximum term	Integer
RentalPurchaseOptionMaxTermDate	Rental purchase option maximum term date	Date
RentalPurchaseOptionMinTerm	Minimum term	Integer
RentalPurchaseOptionMinTermDate	Rental purchase option minimum term date	Date
RentalPurchaseOptionOrderNumber	Order number	String	20
RentalPurchaseOptionStartDate	Rental purchase option start date	Date
RentalPurchaseOptionTransferStatus	Rental purchase option transfer status	Enum
RentalTemplate	Rental template	RecId
RenterAccount	Renter	String	20
SalesResponsible	Sales taker	RecId
ShipTo	Ship to	Enum
StartDateTime	Start date and time	Date time
Subject	Subject	String	50
TaxGroup	Sales tax group	String	10

RentalDocumentTableToLineParameters (Rental document line update parameters)

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

RentalDriver (Drivers)

Name	Label	Type	Length
DriverId	Driver ID	String	20
IsInternal	Internal	Enum
Name	Driver name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WorkerRecId	Worker	RecId

RentalDynamicPriceFinancialUtilizationTier (Dynamic price financial utilization tiers)

Name	Label	Type	Length
Percent	Percentage	Real
RangeFrom	From	Integer
RangeTo	To	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPriceInventoryLevelTier (Dynamic price inventory level tiers)

Name	Label	Type	Length
Percent	Percentage	Real
RangeFrom	From	Integer
RangeTo	To	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPriceLineSuggestion (Dynamic price suggestion)

Name	Label	Type	Length
ApplicablePercentage	Applicable percentage	Real
BaseRate	Base rate	Real
CalculatedPercentage	Calculated percentage	Real
FinancialUtilization	Dynamic price financial utilization tiers	Real
FinancialUtilizationPercentage	Financial utilization percentage	Real
InventoryLevel	Dynamic price inventory level tiers	Integer
InventoryLevelPercentage	Inventory level percentage	Real
MaximumDecrease	Maximum decrease	Real
MaximumIncrease	Maximum increase	Real
PastCustomerContracts	Dynamic price past contract tiers	Integer
PastCustomerContractsPercentage	Past customer contracts percentage	Real
RateGroupId	Dynamic price rate groups	String	10
RateGroupPercentage	Rate group percentage	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalDocumentLinePrice	Price line	RecId
Reservations	Dynamic price reservations tiers	Integer
ReservationsPercentage	Reservations percentage	Real
TimeUtilization	Dynamic price time utilization tiers	Real
TimeUtilizationPercentage	Time utilization percentage	Real

RentalDynamicPricePastContractTier (Dynamic price past contract tiers)

Name	Label	Type	Length
Percent	Percentage	Real
RangeFrom	From	Integer
RangeTo	To	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPricePeriodLimit (Dynamic price period limits)

Name	Label	Type	Length
MaximumDecreasePercentage	Maximum decrease percentage	Real
MaximumIncreasePercentage	Maximum increase percentage	Real
PeriodCodeId	Period	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPriceRateGroup (Dynamic price rate groups)

Name	Label	Type	Length
Percent	Percentage	Real
RateGroupId	Dynamic price rate groups	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPriceReservationTier (Dynamic price reservations tiers)

Name	Label	Type	Length
Percent	Percent	Real
RangeFrom	From	Integer
RangeTo	To	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalDynamicPriceTimeUtilizationTier (Dynamic price time utilization tiers)

Name	Label	Type	Length
Percent	Percent	Real
RangeFrom	From	Integer
RangeTo	To	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalFleetBatchRelation (Fleet batch relations)

Name	Label	Type	Length
BatchTemplateId	Batch template	String	20
BatchUsed	Used on PO	Enum
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalFleetClassification (Fleet classifications)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FleetClassification	Fleet classification	Enum
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalFleetInventoryAccountHistory (Fleet and inventory account history)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DaysInAssetFleet	Days in asset fleet	Integer
FleetTypeFrom	From fleet type	Enum
FleetTypeTo	To fleet type	Enum
InventTransOrigin	Inventory transactions originator	RecId
LedgerDimensionInvAccFrom	From inventory account	RecId
LedgerDimensionInvAccTo	To inventory account	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
TransDate	Date	Date

RentalHauler (Haulers)

Name	Label	Type	Length
ContactId	Hauler Contact	String	20
ContactName	Hauler contact name	String	60
ContactPhone	Hauler contact phone	String	20
HaulerId	Hauler ID	String	20
Name	Hauler name	String	160
ProviderType	Hauler type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VendAccount	Hauler/Vendor	String	20

RentalHaulerDriver (Hauler driver associations)

Name	Label	Type	Length
Driver	Driver	RecId
Hauler	Hauler	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Trailer	Trailer	RecId
Truck	Truck	RecId

RentalInspectionChecklist (Inspection checklists)

Name	Label	Type	Length
Action	Action	Enum
Description	Description	String	60
Mandatory	Mandatory	Enum
Model	Model	RecId
modifiedDateTime	Modified date and time	Date time
Name	Checklist item	String	10
PhotoMandatory	Photo mandatory	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalInspectionChecklistHistory (Inspection checklist history)

Name	Label	Type	Length
Checked	Checked	Enum
createdDateTime	Created date and time	Date time
Description	Description	String	60
Mandatory	Mandatory	Enum
modifiedDateTime	Modified date and time	Date time
Name	Checklist item	String	10
Note	Note	String	255
PhotoMandatory	Photo mandatory	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
RentalItemMovement	Rental item movement ID	RecId
StatusAction	Action	Enum
UserId	User ID	String	20

RentalInsurance (Insurances)

Name	Label	Type	Length
CustAccount	Customer account	String	20
Dimension	Dimension	RecId
InsuranceId	Insurance ID	String	10
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationType	Type of registration	Enum
Status	Status	Enum
VendAccount	Vendor account	String	20

RentalInsuranceExpiryLog (Insurance expiry log)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
ExpiryDate	Insurance expiry date	Date
Insurance	Insurance ID	RecId
LogId	Insurance expiry log ID	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental ID	RecId

RentalInsuranceTypeDetails (Insurance type details)

Name	Label	Type	Length
Blanket	Blanket	Enum
CurrencyCode	Currency	String	3
DeductibleAmount	Deductible amount	Real
GeneralAggregateAmount	Amount	Real
Insurance	Insurance ID	RecId
InsuranceAgentName	Insurance agent name	String	30
InsuranceCompanyName	Insurance company name	String	30
InsuranceType	Type	Enum
InventSerialId	Serial number	String	20
Limit	Limit	Real
LogisticsLocation	Location	RecId
Model	Model	RecId
PolicyNumber	Policy number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidFrom	Policy effective date	Date
ValidTo	Policy expiration date	Date

RentalInvoiceMethod (Invoice method)

Name	Label	Type	Length
InvoiceDayOfMonth	Specific day to invoice	Integer
InvoiceMethodId	Invoice method	String	10
InvoicingDayOffset	Number of days	Integer
IsArrearInvoicing	In arrears	Enum
Name	Name	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UseFixedDayOfMonth	Use specific day	Enum

RentalInvoiceScheduleLine (Rental invoice schedule lines)

Name	Label	Type	Length
BestRateCalculationOvertimeValue	Best rate calculation overtime value	Real
ClassTable	Rental class	RecId
Credited	Credited	Enum
CreditedInvoiceScheduleLine	Credited invoice schedule line	RecId
CreditType	Invoice schedule credit type	Enum
DefaultDimension	Dimension	RecId
EndSMU	End SMU	Real
InvoicedDate	Invoiced date	Date
InvoicedOvertimeSMUAmount	Invoiced overtime SMU amount	Real
InvoicedSMU	Invoiced SMU amount	Real
InvoiceScheduleTable	Invoice schedule ID	RecId
InvoiceScheduleTxt	Invoice info	String	1000
JobSite	Job site	RecId
LineNum	Line number	Real
NoticeToOwner	Notice to owner	RecId
NumberOfDays	Number of days	Integer
Overtime	Overtime	Enum
Price	Price	Real
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Contract line	RecId
RentalDocumentLinePrice	Price line	RecId
RentalItem	Rental item	RecId
RevenueCategory	Revenue categories	RecId
SalesCategory	Sales category	RecId
SalesId	Sales order	String	20
SalesLine	Reference	RecId
SMUBasedCharge	SMU based charge	Enum
SMUUsage	Usage	Real
StandDown	Stand-down	Enum
StandDownDays	Stand-down days	Integer
StandDownHours	Stand-down hours	Integer
StartSMU	SMU when shipped out	Real
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
UnitPrice	Unit price	Real
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalInvoiceScheduleLineSplitTrans (Revenue split transactions)

Name	Label	Type	Length
CreditAmountCur	Credit	Real
Credited	Credited	Enum
CreditVoucher	Swapping credit voucher	String	20
CurrencyCode	Currency	String	3
DebitAmountCur	Debit	Real
Dimension	Reference	RecId
InvoiceScheduleLine	Invoice schedule line	RecId
MainAccount	Main account	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
TransactionTxt	Transaction text	String	60

RentalInvoiceScheduleProcessLog (Rental invoicing batch job exceptions)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Exception	Exception	Enum
Info	Infolog data	Bin/Memo/Container
InvoiceDate	Invoicing date	Date
InvoiceScheduleId	Invoice schedule ID	String	21
JobCaption	Job caption	String	200
Processed	Processed	Enum
Reason	Reason	String	255
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalId	Rental ID	String	21

RentalInvoiceScheduleTable (Rental invoice schedules)

Name	Label	Type	Length
BookValueRentalItem	Rental item	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CreditedInvoiceNumber	Credited invoice number	String	20
CreditedInvoiceScheduleTable	Credited invoice schedule	RecId
CreditReasonCodeId	Credit reason codes	String	50
CreditType	Invoice schedule credit type	Enum
CurrencyCode	Currency	String	3
CustAccount	Customer account	String	20
CustInvoiceAccount	Invoice customer	String	20
CustomerPONumber	Customer Purchase order number	String	30
DefaultDimension	Dimension	RecId
DeliveryDate	Delivery date	Date
DueDate	Due	Date
InventLocationId	Warehouse	String	10
InvoicedDate	Invoiced date	Date
InvoiceNotes	Invoice notes	String	1000
InvoiceScheduleId	Invoice schedule ID	String	21
InvoiceScheduleTxt	Invoice info	String	1000
InvoicingDate	Invoicing date	Date
IsSupplemental	Is supplemental type	Enum
JobSite	Job site	RecId
NoticeToOwner	Notice to owner	RecId
PaymTermId	Terms of payment	String	100
PeriodName	Period name	String	30
PeriodNumber	Period number	Integer
Proforma	Proforma	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental ID	RecId
Responsible	Responsible	RecId
SalesId	Sales order	String	20
Status	Status	Enum
TaxGroup	Sales tax group	String	10

RentalItemAdjustment (Rental item adjustments)

Name	Label	Type	Length
AdjustmentId	Rental item adjustment ID	String	20
CostAmountAdjustment	Adjustment	Real
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FleetType	Fleet type	Enum
InventSettleTransId	Settlement	String	20
Posted	Posted	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
Voucher	Voucher	String	20

RentalItemDVStaging (DV Rental items)

Name	Label	Type	Length
AgreementStatus	Agreement status	Enum
AttachedToRentalItemNumber	Attached to	String	20
CurrentLocationAccount	Location account	String	20
CurrentLocationJobSiteId	Location job site ID	String	25
CurrentLocationName	Location name	String	60
CurrentLocationType	Location type	Enum
CurrentLogisticsLocationId	Location address ID	String	40
DefinitionGroup	Processing group	String	60
DeliveryDate	Delivery date	Date
ExecutionId	Job ID	String	90
FixedAssetNumber	Fixed asset number	String	20
FleetType	Fleet type	Enum
IsAttachment	Is attachment	Enum
IsSelected	Select	Enum
ItemNumber	Item number	String	20
ManufacturedDate	Manufacture date	Date
ManufacturerId	Manufacturer	String	20
OrderedDate	Order date	Date
PhysicalStatus	Physical status	Enum
ReceivedDate	Received date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemModelId	Model	String	35
RentalItemNumber	Rental item number	String	20
SearchName	Search name	String	20
SerialNumber	Serial number	String	20
ServiceStatus	Service status	Enum
SoldDate	Sell date	Date
StatusReasonCodeId	Status reason code	String	10
TransferStatus	Staging to target status	Enum

RentalItemExcludedAgreementStatus (Excluded rental item agreement statuses)

Name	Label	Type	Length
AgreementStatus	Agreement status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemFeature (Rental item features)

Name	Label	Type	Length
Description	Description	String	60
FeatureId	Rental feature	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemGroupCode (Rental item group codes)

Name	Label	Type	Length
Description	Description	String	60
GroupCodeId	Group code	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemGroupCodeStaging (Rental item group codes)

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

RentalItemManufacturer (Rental item manufacturers)

Name	Label	Type	Length
ManufacturerId	Manufacturer	String	20
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemManufacturerStaging (Rental item manufacturers)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ManufacturerId	Manufacturer ID	String	20
ManufacturerName	Manufacturer name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

RentalItemModel (Rental item models)

Name	Label	Type	Length
AttachedToModel	Attached to	RecId
DayPrice	Days	Real
DayPricePercent	Day %	Real
Description	Description	String	60
FamilyVendor	Vendor family	String	10
FuelType	Fuel type	Enum
GroupCode	Group code	RecId
IsAttachment	Attachment	Enum
Manufacturer	Manufacturer	RecId
ModelId	Model	String	35
MonthPrice	Month	Real
MonthPricePercent	Month %	Real
NotForSale	Not for sale (default)	Enum
NoticeToOwnerExempt	Notice to owner exempt	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SMUPrice	SMU	Real
SMUPricePercent	SMU %	Real
WeekPrice	Week	Real
WeekPricePercent	Week %	Real
YearPrice	Year	Real
YearPricePercent	Year %	Real

RentalItemModelStaging (Rental item models)

Name	Label	Type	Length
AttachedToManufacturerId	Manufacturer	String	20
AttachedToModelId	Attached to model	String	35
DefinitionGroup	Processing group	String	60
Description	Description	String	60
ExecutionId	Job ID	String	90
FuelType	Fuel type	Enum
IsAttachment	Is attachment	Enum
IsExemptFromNoticeToOwner	Is exempt from notice to owner	Enum
IsNotForSaleByDefault	Is not for sale by default	Enum
IsSelected	Select	Enum
ModelId	Model ID	String	35
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemGroupCodeId	Group code	String	20
RentalItemManufacturerId	Manufacturer	String	20
TransferStatus	Staging to target status	Enum

RentalItemMovementActionItem (Rental item movement action items)

Name	Label	Type	Length
ActionItemId	Action item ID	String	10
AssignedTo	Assigned to	RecId
createdDateTime	Created date and time	Date time
Description	Description	String	1000
ItemMovementId	Rental item movement	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemId	Rental item	String	20
ResolvedBy	Resolved by user	String	20
ResolvedDateTime	Resolved date and time	Date time
Status	Status	Enum
Type	Type	Enum

RentalItemMovementJournal (Rental item movement journals)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ItemMovementId	Rental item movement ID	RecId
ItemMovementJournalId	Journal ID	String	10
ItemMovementStatus	Status	Enum
modifiedBy	Modified by	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemMovementJournalHistory (Rental item movement Journal history)

Name	Label	Type	Length
ItemMovementTable	Rental item movement ID	RecId
JournalId	Journal	String	20
PostedDateTime	Posted on	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemMovementLine (Rental item movement Line)

Name	Label	Type	Length
BarCode	Bar code	String	80
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DEFLevel	DEF level	Real
Description	Description	String	80
FuelLevel	Fuel level	Real
InspectionCompleted	Inspection completed	Enum
InventSerialId	Serial number	String	20
ItemId	Item number	String	20
ItemMovementTable	Rental item movement ID	RecId
LastSMU	Last SMU	Real
LineNum	Line number	Real
LineSequence	Sequence	Integer
LineStatus	Line status	Enum
LoadTable	Related Load ID	RecId
ManuallyCreatedLine	Manual	Enum
Model	Model	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Note	Note	String	1000
OrigQty	Original qty	Real
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
SecondarySMU	Secondary SMU	Real
SecondarySMUCapturedDateTime	Secondary SMU capture date	Date time
SMUCapturedDateTime	Capture date time	Date time
SMUReading	Service meter unit	Real
Truck	Truck	String	10
Value	Value	Real

RentalItemMovementReasonCode (Rental item movement reason codes)

Name	Label	Type	Length
CodeId	Reason code	String	20
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalItemMovementReplaceAttachmentLog (Replace attachment log)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Employee	Employee	RecId
NewAttachment	New attachment ID	RecId
NewModel	New model	RecId
PreviousAttachment	Previous attachment ID	RecId
PreviousModel	Previous model	RecId
ReasonCode	Reason code	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemMovement	Rental item movement ID	RecId
ReplacementDate	Replacement date	Date

RentalItemMovementStatusSetup (Rental item movement status setup)

Name	Label	Type	Length
Action	Action	Enum
CustSignature	Customer signature	Enum
Damage	Damage	Enum
DeliveryIssue	Delivery issue	Enum
Direction	Direction	Enum
FuelMandatory	Fuel mandatory	Enum
InspectionMandatory	Inspection mandatory	Enum
ModifyRentReturn	Modified rent return	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemPhysicalStatus	Physical status	Enum
SMUMandatory	Service meter unit mandatory	Enum
Status	Status	Enum

RentalItemMovementTable (Rental item movement table)

Name	Label	Type	Length
ActualDeliveryPickupDateTime	Actual delivery/pickup date and time	Date time
ActualShipDate	Ship/Receive date	Date
AgreementRelation	Agreement relation	String	21
ContactId	Contact ID	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustAccount	Customer	String	20
CustomerContact	Contact ID	String	20
DefaultDimension	Dimension	RecId
DeliveryInfoUpdated	Delivery Info Updated	Enum
DeliveryIssue	Delivery issue	Enum
Direction	Direction	Enum
Driver	Driver	String	60
EstimatedDeliveryPickupDateTime	Estimated delivery/pickup date and time	Date time
FromDeliveryName	Delivery name	String	60
FromLogisticsLocation	Location	RecId
FromRelation	From	String	100
FromRelationType	Relation type	Enum
Hauler	Hauler	String	20
HaulerContact	Hauler contact	String	20
HaulerType	Hauler type	Enum
InUseBy	User ID	String	20
ItemMovementReasonCode	Rental item movement reason	RecId
Locked	Locked	Enum
MainItemMovement	Main rental item movement	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NextFunction	Function	Enum
Note	Note	String	1000
PlateNo	Plate no	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemMovementId	Rental item movement ID	String	10
Responsible	Responsible	RecId
ScheduledWithCentralDispatch	Scheduled with Central Dispatch	Enum
SessionId	Session ID	Integer
SessionLoginDateTime	Session login date/time	Date time
SignatureNotAvailable	Signature not available	Enum
Status	Status	Enum
ToDeliveryName	Delivery name	String	60
ToLogisticsLocation	Location	RecId
ToRelation	To	String	100
ToRelationType	Relation type	Enum

RentalItemPhysicalTrans (Rental item physical transactions)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
InventJournalId	Journal	String	20
PhysicalStatus	Physical status	Enum
PhysicalTransId	Physical transaction ID	String	20
ProjId	Project ID	String	20
PurchId	Purchase order	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item number	RecId
RentalItemMovement	Rental item movement ID	RecId
SalesId	Sales order	String	20
StatusReasonCodeId	Reason code	String	10
ToRelation	To	String	20
ToRelationType	To type	Enum
TransDate	Transaction date	Date

RentalItemPostingProfile (Rental item posting profiles)

Name	Label	Type	Length
AssetGroupId	Fixed asset group	String	10
BookId	Book	String	10
CustCode	Customer code	Enum
CustGroup	Customer group	String	21
FleetType	Fleet type	Enum
ItemCode	Item code	Enum
ItemGroup	Item group	String	21
LedgerDimension	Main account	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemAccountType	Rental item account type	Enum
TaxGroupId	Sales tax group	String	10
VendCode	Vendor code	Enum
VendGroup	Vendor group	String	21

RentalItemRerentFee (Rental item re-rent fee)

Name	Label	Type	Length
Amount	Amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
RentalPeriodCode	Period	RecId

RentalItemReservationLine (Rental item reservation lines)

Name	Label	Type	Length
ConvertReservation	Convert	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
ReservationTable	Reservation ID	RecId

RentalItemReservationRequestCount (Rental item reservation request counters)

Name	Label	Type	Length
ClassTable	Rental class	RecId
Model	Model	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RequestCount	Count	Integer
ReservationRequestSetup	Reservation request setup	RecId

RentalItemReservationRequestSetup (Reservation request setup)

Name	Label	Type	Length
ClassAllowed	Class allowed	Enum
ExpiryTime	Expiry time	Integer
ItemNumberControlEnabled	Control by number of eq	Enum
MaximumDurationDays	Maximum length	Integer
MaximumNumberOfRequestsPerClass	Max per model/class	Integer
MaximumNumberOfRequestsPerItem	Max per rental item	Integer
ModelAllowed	Model allowed	Enum
OpenEndDate	Open end date	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReservationType	Rental item reservation types	RecId

RentalItemReservationRequestSetupFleetType (Rental item reservation request configuration fleet type)

Name	Label	Type	Length
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReservationRequestSetup	Reservation request setup	RecId

RentalItemReservationSetup (Rental item reservation configurations)

Name	Label	Type	Length
ConvertToRentalContract	Convert to rental contract	Enum
ConvertToRentalQuotation	Convert to rental quotation	Enum
ConvertToSalesOrder	Convert to sales order	Enum
ConvertToSalesQuotation	Convert to sales quotation	Enum
CopyEndDate	Copy end date	Enum
CopyStartDate	Copy start date	Enum
CustomerValidation	Customer validation	Enum
ExpiryTime	Expiry time	Integer
MaximumDurationDays	Maximum length	Integer
OpenEndDate	Open end date	Enum
OpportunityRequired	Opportunity required	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReservationType	Rental item reservation types	RecId
StopRentalContract	Stop rental contract	Enum
StopRentalQuotation	Stop rental quotation	Enum
StopSalesOrder	Stop sales order	Enum
StopSalesQuotation	Stop sales quotation	Enum
TimeWindow	Time window	Integer
UserValidation	User validation	Enum

RentalItemReservationSetupFleetType (Rental item reservation configuration fleet types)

Name	Label	Type	Length
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReservationSetup	Rental item reservation configurations	RecId

RentalItemReservationTable (Rental item reservations)

Name	Label	Type	Length
BusRelAccount	Prospect	String	20
ClassTable	Rental class	RecId
ContractLine	Rental document line	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustAccount	Customer account	String	20
Description	Description	String	1000
EndDate	End date	Date
ExpiryDate	Expiration date	Date
Model	Model	RecId
PurchId	Purchase order	String	20
Qty	Quantity	Real
QuotationId	Sales quotation	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental ID	RecId
ReservationId	Reservation ID	String	10
ReservationStage	Type	Enum
ReservationType	Rental item reservation types	RecId
Responsible	Responsible	RecId
SalesId	Sales order	String	20
smmOpportunity	Opportunity ID	String	10
StartDate	Start date	Date
Status	Status	Enum

RentalItemReservationType (Rental item reservation types)

Name	Label	Type	Length
Description	Description	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TypeId	Type	String	10

RentalItemStatusReasonCode (Rental item status reason codes)

Name	Label	Type	Length
Cancelled	Canceled	Enum
CodeId	Reason code	String	10
Description	Description	String	60
ItemMovementReplacement	Item movement replacement	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShowOnAvailability	Show on availability	Enum

RentalItemSum (Rental item on-hand)

Name	Label	Type	Length
InStock	In stock	Real
InStockReserved	In stock reserved	Real
InventDimId	Dimension number	String	20
InventLocationId	Warehouse	String	10
ItemId	Item number	String	20
modifiedDateTime	Modified date and time	Date time
Ordered	Ordered	Real
OrderedReserved	Ordered reserved	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
RentalLocationId	Rental locations	String	100
Total	Total	Real
WMSLocationId	Location	String	10

RentalItemTable (Rental items)

Name	Label	Type	Length
AddressCustVendBusRelAC	Customer/Vendor/Prospect	String	20
AddressJobSite	Job site	RecId
AddressName	Name	String	60
AddressRelationType	Relation type	Enum
AddressRentalLocationId	Rental locations	String	100
AgreementStatus	Agreement status	Enum
AskingPrice	Asking price	Real
AssetId	Fixed asset number	String	20
AttachedTo	Attached to	String	20
AttachmentModel	Attachment model	RecId
BusRelAccount	Prospect	String	20
ConfigId	Configuration	String	50
ConsumedAgainstRentalItemId	Consumed against	String	20
ContactId	Contact ID	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
CustAccount	Customer	String	20
DefaultClass	Default rental class	RecId
DefaultDailyRentalRate	Daily rate	Real
DefaultDimension	Dimension	RecId
DefaultMonthlyCalendarRentalRate	Monthly calendar rate	Real
DefaultMonthlyRentalRate	Monthly rate	Real
DefaultWeeklyRentalRate	Weekly rate	Real
DeliveryDate	Delivery date	Date
FirstRentDate	First rent date	Date
FleetType	Fleet type	Enum
InventoryAge	Inventory age	Real
InventSerialId	Serial number	String	20
IsAttachment	Attachment	Enum
IsDamaged	Damaged	Enum
IsLost	Lost	Enum
IsMissing	Missing	Enum
IsNotUsed	Inactive	Enum
IsRentalPurchaseOption	Rental purchase option	Enum
IsStolen	Stolen	Enum
ItemId	Item number	String	20
LastCalcAgeUpdate	Last calculation from age updates	Date time
LastCalcPriceSearch	Last calculation from price search	Date time
LedgerDimensionInventoryAccount	Inventory account	RecId
Location	Rental item address	RecId
ManufactureDate	Manufacture date	Date
Manufacturer	Manufacturer	RecId
ManufactureYear	Manufacture year	Integer
Model	Model	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NameAlias	Search name	String	20
NoteLastChangeDateTime	Modified on	Date time
Notes	Note	Bin/Memo/Container
NotesCreatedBy	Created by	String	60
NotForSale	Not for sale	Enum
OrderDate	Order date	Date
PhysicalStatus	Physical status	Enum
ReceivedDate	Received date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalAge	Rental age	Real
RentalContract	Rental ID	RecId
RentalFeatureId	Rental feature	String	30
RentalItemId	Rental item number	String	20
RentalQuotation	Rental ID	RecId
SellDate	Sell date	Date
ServiceStatus	Service status	Enum
SoldFromBookId	Sold from value model	String	10
StatusReasonCodeId	Reason code	String	10
TransferDate	Transfer date	Date
TransferRequest	Request ID	RecId
VesselName	Vessel name	String	20

RentalItemTrans (Rental item transactions)

Name	Label	Type	Length
AfterSaleCost	After sale cost	Enum
Amount	Amount	Real
AmountCur	Amount in transaction currency	Real
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
Credited	Credited	Enum
CurrencyCode	Currency	String	3
DefaultDimension	Dimension	RecId
LedgerDimensionAccount	Ledger account	RecId
LedgerPostingType	Posting type	Enum
MainAccountNum	Main account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceId	Reference ID	String	21
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer
RentalItemId	Rental item number	String	20
RentalItemTransId	Rental item transaction ID	String	20
RentalItemTransRefType	Rental item transaction reference type	Enum
RentalItemTransType	Rental item transaction type	Enum
SourceDocumentLine	Source document line	RecId
TransDate	Date	Date
Voucher	Voucher	String	20

RentalItemTranslation (Rental item translations)

Name	Label	Type	Length
Description	Description	String	1000
LanguageId	Language	String	7
Name	Rental item name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId

RentalItemUsage (Rental items usage)

Name	Label	Type	Length
CurrentUsageCounter	Current usage counter	Real
EndUsageCounter	End usage counter	Real
EndUsageDate	Usage end date	Date
EstimatedPeriodNumber	Number of periods	Integer
EstimatedPeriodType	Period type	Enum
EstimatedPeriodUsage	Estimated period usage	Real
GPSLatitude	Latitude	Real
GPSLatitudeBearing	Latitude bearing	Enum
GPSLocationType	Location type	Enum
GPSLongitude	Longitude	Real
GPSLongitudeBearing	Longitude bearing	Enum
GPSPositionCreated	Created	Date time
IsUsageCounterMandatory	Mandatory usage counter	Enum
IsUsageRequired	Usage required	Enum
LifetimeSMU	Expected lifetime SMU	Real
MeasureDate	Measure date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Reference	RecId
SecondaryLifetimeSMU	Secondary lifetime SMU	Real
SecondarySMULast	Last secondary SMU	Real
SecondarySMULastCaptureDateTime	Last secondary SMU capture date	Date time
SecondarySMUUnitSymbol	Secondary SMU unit	String	10
SMULast	Last SMU	Real
SMULastCaptureDateTime	Last SMU capture date	Date time
SMUUnitSymbol	Unit	String	10
StartUsageCounter	Start usage counter	Real
StartUsageDate	Usage start date	Date

RentalItemUsageHistory (Rental item usage historical entries)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CreationDateTime	Capture date	Date time
DepreciationLedgerJournal	Depreciation journal reference	RecId
DocumentReference	Source document reference	RecId
DocumentReferenceId	Document reference ID	String	21
InventSerialId	Serial number	String	20
LifetimeSMU	Expected lifetime SMU	Real
MeterReading	Service meter unit	Real
PreviousSMU	Service meter unit	Real
Processed	Processed	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
SecondaryLifetimeSMU	Secondary lifetime SMU	Real
SecondaryPreviousSMU	Previous secondary SMU	Real
SecondarySMU	Secondary SMU	Real
SecondarySMUCaptureDateTime	Secondary SMU capture date	Date time
SecondarySMUUnitSymbol	Secondary unit	String	10
SMUCaptureDateTime	SMU capture date	Date time
SMUUnitSymbol	Unit	String	10
Source	Source	Enum
Type	Type	Enum
UnexpectedSMU	Unexpected SMU	Enum
UsedForDepreciation	Used for depreciation	Enum
Void	Void	Enum

RentalItemUtilization (Rental items utilization)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FinancialDays1	Financial - %1	Real
FinancialDays2	Financial - %1	Real
FinancialDays3	Financial - %1	Real
FinancialDays4	Financial - %1	Real
FinancialLife	Financial life	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item	RecId
TimeDays1	Time - %1	Real
TimeDays2	Time - %1	Real
TimeDays3	Time - %1	Real
TimeDays4	Time - %1	Real
TimeLife	Time life	Real

RentalItemUtilizationTrans (Rental item utilization transactions)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
InvoicedDays	Invoiced days	Integer
InvoiceScheduleLine	Invoice schedule line	RecId
InvoicingDate	Invoicing date	Date
Period	Period	RecId
PeriodQty	Qty	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalClass	Rental class	RecId
RentalContract	Rental ID	RecId
RentalItem	Rental item	RecId
Revenue	Revenue	Real
SplitTrans	Split transaction reference	RecId
UtilizationTransId	Transaction ID	String	20

RentalJobSite (Job site)

Name	Label	Type	Length
ContactId	Contact ID	String	20
Expired	Expired	Enum
JobSiteId	Job site	String	25
JobSiteName	Name	String	60
JobSiteNote	Note	String	1000
LogisticsLocation	Location	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalJobSiteCustomer (Jobsite and customer relation)

Name	Label	Type	Length
BusRelAccount	Prospect	String	20
ContactId	Contact ID	String	20
CustAccount	Customer account	String	20
CustomerNote	Customer note	String	1000
JobSite	Job site	RecId
NoticeToOwner	Notice to owner	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalJobSiteStaging (Rental job sites)

Name	Label	Type	Length
ContactId	Contact ID	String	20
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsExpired	Is expired	Enum
IsSelected	Select	Enum
JobSiteId	Job site ID	String	25
LogisticsLocationId	Location ID	String	40
Name	Name	String	60
Note	Note	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

RentalLedgerJournalTable (Rental journal header)

Name	Label	Type	Length
CashRegisterJournalDate	Date	Date
CashRegisterPaymMode	Method of payment	String	10
CashRegisterWorker	Employee	RecId
LedgerJournalTableRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferRequest	Request ID	RecId

RentalLoad (Order Board)

Name	Label	Type	Length
ActualDeliveryDateTime	Jobsite Delivery/Pickup Date/Time	Date time
DeliveryInfoUpdated	Delivery Info Updated	Enum
DispatchStatus	Dispatch status	Enum
Driver	Driver	RecId
Hauler	Hauler	RecId
HaulerType	Hauler type	Enum
LoadId	Load ID	String	20
Note	Note	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalQuotation	Related Quotation	RecId
ScheduledDeliveryDateTime	Scheduled Delivery Date/Time	Date time
Trailer	Trailer	RecId
Truck	Truck	RecId

RentalLocation (Rental locations)

Name	Label	Type	Length
Description	Description	String	100
JobSite	Job site	RecId
LocationId	Rental locations	String	100
LocationType	Location type	Enum
LogisticsLocation	Location	RecId
ParentLocationId	Parent location	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransitLocationId	Transit location	String	100

RentalMiscChargeExemption (Miscellaneous charge exemption)

Name	Label	Type	Length
CustAccount	Customer account	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TemplateLine	Rental template line	RecId

RentalNoticeToOwner (Rental notice to owner)

Name	Label	Type	Length
CustAccount	Customer account	String	20
FilingDate	Filing date	Date
FilingNo	Filing No	String	20
FilingStatus	Notice to owner filing status	Enum
JobSite	Job site	RecId
NoticeToOwnerId	Notice to owner	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShipDate	Ship date	Date
StartDate	Start date	Date

RentalParameters (Rental parameters)

Name	Label	Type	Length
AcquisitionAdjustmentNotSold	Acquisition adjustment - fleet	Enum
AcquisitionAdjustmentSold	Acquisition adjustment - sold	Enum
ActivateDynamicPricing	Activate dynamic pricing	Enum
AddRentalItemLifeSuffix	Rental item life	Enum
AllowPriceDecrease	Allow price decrease	Enum
AllowPriceIncrease	Allow price increase	Enum
AllowSerialNoUpdate	Serial number update	Enum
ApprovalRequiredDynamicPricing	Approval required	Enum
AssetPostingProfile	Asset posting profile	String	10
CancelReservationBehindRentalQuotation	Cancel reservation behind rental quotation	Enum
CancelReservationBehindSalesQuotation	Cancel reservation behind sales quotation	Enum
CarryingCostCalculationFrequency	Calculation frequency	Enum
CarryingCostJournalNameId	Journal name	String	10
CarryingCostPeriod	Per	Enum
CarryingCostTransactionText	Transaction text	String	60
CarryingCostTransType	Transaction type	Enum
CashRegisterJournalNameId	Default cash register journal name	String	10
CheckAttachedTo	Check on changing attached to	Enum
CheckOnActive	Check on active	Enum
CheckOnAssign	Check on assign	Enum
CheckOnSwap	Check on swap	Enum
ControlRentalInboundItemMovement	Control on rental inbound rental item movement	Enum
DefaultAttachmentValidation	Default attachment validation	Enum
DefaultRentalItemBarcodeSetupId	Bar code setup	String	10
DefaultUtilizationPeriod	Default utilization period	Enum
DifferentFleetOnAttachmentReplace	Different fleet on attachment replace	Enum
DifferentLocationOnAttachmentReplace	Different location on attachment replace	Enum
DueDateFromSchedule	Due date from schedule	Enum
EnableLoads	Use rental for transportation	Enum
ExpirationBase	Expiration base	Enum
ExpiryOffsetDays	Expiry time	Integer
FinancialUtilizationReferencePeriod	Financial utilization reference period	Enum
FleetTypeSortConsignment	Consignment	Integer
FleetTypeSortLease	Lease	Integer
FleetTypeSortNew	New	Integer
FleetTypeSortRental	Rental	Integer
FleetTypeSortReRent	Re-rent	Integer
FleetTypeSortUsed	Used	Integer
FleetTypeSortUsedLease	Used lease	Integer
FleetTypeSortUsedRental	Used rental	Integer
FleetTypeSortWIP	WIP	Integer
HaulerItemId	Item for external hauler purchase order	String	20
HoldOnSubstitute	Hold on substitute	Enum
IconExactMatch	Exact matching	Enum
IconNotMatch	Not matching	Enum
IconPossibleMatch	Possible	Enum
InboundItemMovementValidation	Inbound rental item movement validation	Enum
InterestCarryingCostPercent	Interest carrying cost %	Real
InventLocationUpdate	Location update	String	10
InventoryLevelByRentalLocation	Inventory level by rental location	Enum
InvoiceUntilDate	Invoice until	Date
ItemMovementActivateTermsAndConditions	Activate terms and conditions	Enum
ItemMovementTermsAndConditions	Terms and conditions	Bin/Memo/Container
ItemMovementValidation	Outbound rental item movement validation	Enum
Key	ID	Integer
MandatoryFleetDimension	Mandatory fleet inventory dimension	Enum
MandatoryRentalItemQty	Mandatory quantity	Enum
MandatoryReservationCustomer	Customer for reservation	Enum
MiscChargeStreamlined	Miscellaneous charge streamlined	Enum
ModifyRentReturnLimit	Modify rent return limit	Real
PaymentSortCustomer	Customer	Integer
PaymentSortRentalTemplate	Rental template	Integer
QuotationExpiryTimeInDays	Expiration time in days	Integer
ReasonCodeForCredit	Reason code for credit	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceDate	Reference date	Date
RentalAssetGroupChangeReversal	Reversal when only fixed asset group changes	Enum
RentalDepreciationStartByContract	Depreciation start by contract	Enum
RentalItemIdCreation	Rental item ID creation	Enum
RentalItemPictureIcon	Picture icon	Enum
RentalItemPictureType	Picture type	String	20
RentalItemSalesOrderDisposal	Sales order disposal	Enum
RentalItemSharingPolicy	Rental item on multi rental	Enum
RentalItemStatus	Rental item status	Enum
RentalItemTransferJournalName	Transfer journal	String	10
RentalItemTransferLedgerDimension	Main account	RecId
RentalItemTransferPostingProfile	Transfer posting profile	String	10
RentalItemTransferWithDetails	Transfer with details	Enum
RentalItemType	Rental item item type	Enum
RentalItemValidation	Rental item validation	Enum
RentalPeriodCode	Period	RecId
RentalTransferDisposalDateClear	Clear disposal date	Enum
RequireExistingRentalItemForAttach	Only existing rental item	Enum
RetainPrices	Retain prices	Enum
RevenueSplitJournalName	Revenue split posting journal	String	10
SalesOrderValidation	Sales order validation	Enum
SalesQuotationReservedRentalItem	Quotation reserved rental item	Enum
SerialNumberUpdateJournalName	Serial number update journal	String	10
SMUControl	Service meter unit control	Enum
TimeUtilizationReferencePeriod	Time utilization reference period	Enum
TransferAttachments	Transfer attachments	Enum
TransferOnSystemDate	Transfer on system date	Enum
TransferRequestInventoryAssetJournalName	Transfer request inventory asset journal	String	10
TransferRequestMovementJournalName	Transfer request movement journal	String	10
UpdateAttachmentOnRentalReservationAndQuotation	Update attachment on rental reservation and quotation	Enum
UpdateStartDateOnDocumentLine	Update start date on rental fee line	Enum
UseAttachedAttachmentRevenueSplit	Use attached attachment revenue split	Enum
UseCashRegister	Use cash register	Enum
UseChecklistForReceiving	Use checklist for receiving	Enum
UseChecklistForShipping	Use checklist for shipping	Enum
UsePackage	Use package	Enum
UtilizationFromAcquisition	Utilization from acquisition	Enum
UtilizationPeriod1	Utilization period 1	Integer
UtilizationPeriod2	Utilization period 2	Integer
UtilizationPeriod3	Utilization period 3	Integer
UtilizationPeriod4	Utilization period 4	Integer

RentalParametersColor (Rental color parameters)

Name	Label	Type	Length
ActiveContract	Active	Integer
ApprovedContract	Approved	Integer
CanceledContract	Canceled	Integer
CanceledQuotation	Cancel	Integer
ClosedContract	Closed	Integer
ConfirmedQuotation	Confirmed	Integer
ConvertedContract	Converted	Integer
CreatedContract	Created	Integer
CreatedQuotation	Created	Integer
ExpiredQuotation	Expired	Integer
Key	ID	Integer
LoadCanceled	Canceled	Integer
LoadCancelRequested	Cancel requested	Integer
LoadCompleted	Completed	Integer
LoadDelay	Delay	Integer
LoadDispatched	Dispatched	Integer
LoadInTransit	In-Transit	Integer
LoadPartialReceive	Partial Receive	Integer
LoadPartialShip	Partial Ship	Integer
LoadRequested	Requested	Integer
LostQuotation	Lost	Integer
OnHoldContract	On hold	Integer
OnHoldQuotation	On hold	Integer
PrintedContract	Printed	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RejectedContract	Rejected	Integer
ReopenedContract	Re-Opened	Integer
SentQuotation	Sent	Integer

RentalPaymentSetup (Rental payment setups)

Name	Label	Type	Length
CustPaymModeId	Method of payment	String	10
JournalNameId	Cash register journal name	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UseInCashRegister	Use in cash register	Enum

RentalPeriodCode (Period codes)

Name	Label	Type	Length
BasePeriod	Base period	Enum
DisplayAs	Display as	String	30
GraceHours	Grace hours	Integer
HourlyBilling	Hourly billing	Enum
InvoiceDays	Invoice days	Integer
InvoiceOnlyOnce	Once	Enum
InvoiceOvertime	Overtime	Enum
Name	Name	String	30
NumberOfTimeUnits	Number	Integer
PeriodCodeId	Period	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SimulateUtilization	Simulate utilization	Enum
StandDownPeriod	Stand-down period	Enum
TimeUnit	Time unit	Enum
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalPeriodHoursAllowance (Rental period hours allowances)

Name	Label	Type	Length
Hours	Hours allowed	Real
PeriodCode	Period	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShiftPriceFactor	Shift	RecId

RentalPhysicalStatusForSummary (Physical statuses for summary)

Name	Label	Type	Length
PhysicalStatus	Physical status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UseInRentalSummary	Available in summary	Enum

RentalPriceFactor (Price factor)

Name	Label	Type	Length
Name	Name	String	60
PriceFactorId	Price factor	String	10
PriceFactorType	Price factor type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalPurchaseOptionInterestCalculation (Rental purchase option interest calculations)

Name	Label	Type	Length
InterestCalculationBasis	Interest calculation basis	Integer
InterestDivisor	Divisor of interest	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalPurchaseOptionName	Name	String	10

RentalPurchaseOptionPeriod (Rental Purchase Option periods)

Name	Label	Type	Length
BaseInterestPercentage	Base interest percentage	Real
FromPeriod	From	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocument	Rental ID	RecId
RentalPercentage	Percentage of rent to apply	Real
RentalTemplate	Rental template	RecId
ToPeriod	To	Integer

RentalPurchaseOptionPrimeInterestRate (Rental Purchase Option prime interest rates)

Name	Label	Type	Length
PrimeInterestRate	Prime interest rate %	Real
PrimeInterestRateEffective	Effective date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalRateConfig (Rental rate configuration)

Name	Label	Type	Length
AccountCode	Account code	Enum
AccountRelation	Account	String	20
ApplicationPriceFactor	Application	RecId
ClassCode	Class code	Enum
ClassRelation	Class	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShiftPriceFactor	Shift	RecId
Sorting	Priority	Integer
StorePriceFactor	Store	RecId
Type	Type	Enum

RentalRateGroup (Rental rate groups)

Name	Label	Type	Length
Name	Name	String	60
RateGroupId	Dynamic price rate groups	String	10
RateGroupType	Type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalRateOverrideLimit (Rate override limit)

Name	Label	Type	Length
AllowedAmount	Allowed amount	Real
AllowedPercentage	Allowed percentage	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalClassTable	Rental class	RecId
RentalPeriodCode	Period	RecId

RentalRateParameters (Rental rate parameters)

Name	Label	Type	Length
DefaultApplication	Default application	RecId
DefaultShift	Default shift	RecId
DefaultStore	Default store	RecId
IsAutomaticRounding	Automatic rounding	Enum
Key	ID	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoundingMethod	Rounding method	Enum
RoundingRule	Rounding rule	Real
ShowRatesInRentalItemAvailability	Rates in rental item availabilty	Enum
SortingValueAllAccount	Sorting all account	Integer
SortingValueAllClass	Sorting all class	Integer
SortingValueBase	Sorting base	Integer
SortingValueDiscApplication	Sorting discount application	Integer
SortingValueDiscShift	Sorting discount shift	Integer
SortingValueDiscStore	Sorting discount store	Integer
SortingValueGroupAccount	Sorting group account	Integer
SortingValueGroupClass	Sorting group class	Integer
SortingValueRateApplication	Sorting rate application	Integer
SortingValueRateShift	Sorting rate shift	Integer
SortingValueRateStore	Sorting rate store	Integer
SortingValueTableAccount	Sorting table account	Integer
SortingValueTableClass	Sorting table class	Integer
UseApplicationByDiscount	Use application by discount	Enum
UseApplicationByRate	Use application by rate	Enum
UseShiftByDiscount	Use shift by discount	Enum
UseShiftByRate	Use shift by rate	Enum
UseStoreByDiscount	Use store by discount	Enum
UseStoreByRate	Use store by rate	Enum

RentalRatePrice (Rate prices)

Name	Label	Type	Length
CurrencyCode	Currency	String	3
DiscountAmount	Discount amount	Real
DiscountPercentage	Discount percentage	Real
HoursAllowed	Hours allowed	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Period	Period	RecId
RateAmount	Rate	Real
RateConfig	Rental Rate Config	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ValidFrom	From date	Date
ValidTo	To date	Date

RentalRevenueCategory (Revenue categories)

Name	Label	Type	Length
Name	Name	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RevenueCategoryId	Revenue categories	String	10
SalesCategory	Sales category	RecId
TaxItemGroup	Item sales tax group	String	10
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalSalesInvoiceHeaderFooterTmp (Show invoice)

Name	Label	Type	Length
ContactPersonId	Contact ID	String	20
createdBy	Created by	String	20
createdTransactionId	Created ID	Big integer
JobSiteAddress	Address	String	250
JobSiteName	Name	String	60
JournalRecId	Reference	RecId
PeriodName	Period name	String	30
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalId	Rental ID	String	21

RentalSalesInvoiceTmp (Show invoice)

Name	Label	Type	Length
BeginningSecondarySMU	Beginning secondary SMU	Real
BeginningSMU	Beginning SMU	Real
BestRateCalculationOvertimeValue	Best rate calculation overtime value	Real
County	County	String	30
createdBy	Created by	String	20
createdTransactionId	Created ID	Big integer
CreditNoteInvoiceId	Invoice number	String	20
CustRentalItemNumber	Customer rental item number	String	30
CustTransRecId	Reference	RecId
DamageDescription	Damage description	String	1000
EndingSecondarySMU	Ending secondary SMU	Real
EndingSMU	Ending SMU	Real
ExternalItemId	External item number	String	20
InventDimPrint	Free Txt	Bin/Memo/Container
InventSerialIdTrans	Serial number	String	20
JournalRecId	Reference	RecId
LineAmountInclTax	Amount	Real
LineHeader	Line heading	String	80
LineNotes	Line notes	String	250
ManufacturerId	Manufacturer	String	20
ModelId	Model	String	35
Name	Text	String	1000
Notes	Note	Bin/Memo/Container
NumberOfDays	Number of days	Integer
Overtime	Overtime	Enum
PackingSlip	String 255	String	255
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RenIsSubLine	Color	Enum
RentalId	Rental ID	String	21
RentalItemId	Rental item number	String	20
RentalParentLineNum	Line number	Real
RentalTaxName	Name	String	30
RenTemplateLine	Name	String	30
SalesInvoiceTmp	Reference	RecId
SecondarySMUUnit	Secondary SMU unit	String	10
SMUDelivery	Service meter unit	Real
SMUUnit	SMU unit	String	10
StandDownDays	Stand-down days	Integer
State	State	String	10
ValidFrom	Valid from	Date
ValidTo	Valid to	Date

RentalServiceStatusHistory (Service status history)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
NewServiceStatus	New service status	Enum
OriginalServiceStatus	Original service status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItem	Rental item number	String	20
ServiceStatusOrigin	Originating document type	Enum
ServiceStatusOriginDocumentNumber	Originating document number	String	30

RentalSMUInvoicingOvertimeApproval (Overtime approvals)

Name	Label	Type	Length
AllowedHours	Allowed hours	Real
CalculatedOvertimeFee	Calculated overtime fee	Real
createdDateTime	Created date and time	Date time
EndSMU	End SMU	Real
EndSMUDate	End SMU date	Date
ModifiedOvertimeFee	Modified overtime fee	Real
NextInvoiceDueDate	Next invoice due date	Date
Overtime	Overtime	Real
OvertimeRate	Rate	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Rental document line	RecId
RentalDocumentLinePrice	Price line	RecId
RentalItem	Rental item	RecId
StartSMU	SMU when shipped out	Real
StartSMUDate	Start SMU date	Date
Status	Status	Enum
TotalUsage	Total usage	Real

RentalStandDownPeriod (Stand-down periods)

Name	Label	Type	Length
ContactPersonId	Contact person	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FromDate	From date	Date
InvoiceScheduleId	Invoice schedule	String	21
Note	Note	String	254
ReasonCode	Stand-down code	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentLine	Main line	RecId
RentalDocumentLineCalendarJour	Calendar calculation journals	Big integer
RentalDocumentLinePrice	Main price	RecId
StandDownAmount	Stand-down amount	Real
StandDownDays	Stand-down days	Integer
StandDownHours	Stand-down hours	Integer
Status	Stand-down status	Enum
ToDate	To date	Date

RentalStandDownReasonCode (Stand-down reason codes)

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

RentalSwapHistory (Swap history)

Name	Label	Type	Length
ContractNumber	Rental ID	String	21
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustAccount	Customer account	String	20
NewRentalItem	Rental item	RecId
OldRentalItem	Old rental item	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SwapDate	Swap date	Date
SwapReasonCode	Swap reason code	Big integer

RentalSwapReasonCode (Swap reason codes)

Name	Label	Type	Length
CodeId	Reason code	String	20
Description	Description	String	200
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RentalTemplate (Rental templates)

Name	Label	Type	Length
AdjustFirstMonth	Adjust first month	Enum
AllowJobsiteSelection	Allow jobsite selection	Enum
BestRateCalculationFullPeriod	Full period	Enum
CalculateGraceHours	Calculate grace hours	Enum
CalendarBasedInvoice	Calendar based invoicing	Enum
CalendarId	Calendar	String	10
CompoundInterest	Compound interest	Enum
ContractNumberSequence	Contract number sequence	RecId
ContractRentalPurchaseOption	Contract rental purchase option	Enum
ContractType	Contract type	Enum
CreateOrScheduleRentalItemMovementForSwap	Create or schedule rental item movement for swap	Enum
CurrencyCode	Currency	String	3
DefaultApplicationPriceFactor	Application	RecId
DefaultExpirationDate	Default expiration date	Integer
DefaultShiftPriceFactor	Shift	RecId
DefaultStorePriceFactor	Store	RecId
DieselCalculation	Diesel calculation	Enum
DieselPrice	Diesel price	Real
Dimension	Dimension	RecId
FuelCalculation	Fuel calculation	Enum
FuelPrice	Fuel price	Real
HourlyBilling	Hourly billing	Enum
HourlyRateRounding	Hourly rate rounding	Enum
InsuranceTolerance	Insurance tolerance	Real
InsuranceValidation	Insurance validation	Enum
InvoiceMethod	Invoice method	RecId
MainLineApprovalRequired	Approval required	Enum
MainLineBillingScenario	Rental billing scenarios	RecId
MainLineBulkRevenueCategory	Revenue category for bulk items	RecId
MainLineId	Main line ID	String	10
MainLineName	Name	String	30
MainLineNoFee	No fee	Enum
MainLineOvertimeBillingMethod	Overtime billing method	Enum
MainLineRevenueCategory	Revenue categories	RecId
MaximumExpirationDate	Maximum expiration date	Integer
MaximumTerm	Maximum term	Integer
MinimumTerm	Minimum term	Integer
PaymTerm	Payment	String	100
PrintContract	Print contract	Enum
ProRateForCalendar	Prorate for calendar	Enum
ProrateOvertime	Prorate overtime	Enum
ProRateStandDown	Prorate stand-down	Enum
PurchOrAskingPrice	Asking price as purchase price	Enum
QuotationNumberSequence	Quotation number sequence	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemMovementActionForCallOff	Rental item movement action when call-off	Enum
RentalItemMovementReasonCode	Rental item movement reason	RecId
RentalItemMovementReasonCodeActivation	Rental item movement reason for activation	RecId
RentalItemMovementReasonCodeCallOff	Rental item movement reason for call-off	RecId
RentalItemMovementReasonCodeSwap	Rental item movement reason for swap	RecId
RentalPurchaseOptionInterestCalculation	Rental purchase option interest calculations	RecId
RentalPurchaseOptionInterestType	Interest type	Enum
RentalPurchaseOptionTransferProcess	Rental purchase option transfer process	Enum
ScheduleCentralDispatchActivation	Schedule with central dispatch at activation	Enum
ScheduleCentralDispatchCallOff	Schedule with central dispatch at call-off	Enum
ScheduleCentralDispatchSwap	Schedule with central dispatch at swap	Enum
ScheduleOutboundRentalItemMovement	Schedule outbound rental item movement	Enum
SMUCalculation	Service meter unit calculation	Enum
TemplateId	Rental template	String	10
TemplateName	Name	String	30
UseCalendarForBestRateCalculation	Use calendar for best rate calculation	Enum
UseCalendarForStandDown	Use calendar for stand-down	Enum
ValidateSuggestedAttachmentsAndBulkItems	Validate suggested attachments and bulk items	Enum

RentalTemplateFleetType (Rental template fleet types)

Name	Label	Type	Length
ContractType	Contract type	Enum
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemType	Rental item attachment or all	Enum
RentalTemplate	Rental template	RecId

RentalTemplateLine (Rental template lines)

Name	Label	Type	Length
AddDamageChargeToContract	Add damage charge to Contract	Enum
Amount	Amount	Real
CalculationBase	Calculation base	Enum
CalculationMethod	Calculation method	Enum
Dimension	Dimension	RecId
FinalInvoice	Final invoice	Enum
Mandatory	Mandatory	Enum
MaxAmount	Maximum amount	Real
MiscChargeDamage	Damage	Enum
MiscChargeFeeType	Fee type	Enum
MiscChargeType	Misc. charge type	Enum
NoFee	No fee	Enum
NoFeeOnNegative	No invoice on credit	Enum
Percent	Percent	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelatedTo	Related to	Enum
RevenueCategory	Revenue categories	RecId
SMUBasedCharge	SMU based charge	Enum
SMUMinHours	Minimum hours	Real
Template	Rental template	RecId
TemplateLineId	Rental template line	String	10
TemplateLineName	Name	String	30

RentalTemplateLineClassRule (Rental template line class rules)

Name	Label	Type	Length
AddToFinalInvoice	Add to final invoice	Enum
ClassCode	Class relation type	Enum
ClassRelation	Class relation	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TemplateLine	Template line	RecId

RentalTrailer (Trailers)

Name	Label	Type	Length
InspectionExpirationDate	Inspection expiration date	Date
IsInternal	Internal	Enum
PlateExpirationDate	License plate expiry date	Date
PlateNumber	Trailer Plate number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TrailerId	Trailer ID	String	20

RentalTransferRequest (Rental transfer requests)

Name	Label	Type	Length
ApproverNotes	Notes of approver	Bin/Memo/Container
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FleetFrom	Fleet from	Enum
FleetTo	Fleet to	Enum
MoveToInventLocationId	Move to Warehouse	String	10
MoveToRentalLocationId	Move to Rental location	String	100
MoveToWMSLocationId	Move to Location	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalDocumentTable	Rental contract	RecId
RentalItemAssignedBy	Rental item assigned by	RecId
RentalItemAssigner	Rental item assigner	RecId
RequestApprovedBy	Request approved by	RecId
RequestApprover	Request approver	RecId
RequestId	Request ID	String	10
TransferApprovedBy	Transfer approved by	RecId
TransferApprover	Transfer approver	RecId
TransferDate	Transfer date	Date
TransferNotes	Note	Bin/Memo/Container
TransferStatus	Transfer status	Enum

RentalTransferRequestPostingReferenceTable (Transfer request posting references)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferRequest	Request ID	RecId
Voucher	Voucher	String	20

RentalTransferRequestStatusLog (Transfer request status change log)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Request	Request ID	RecId
StatusFrom	Status from	Enum
StatusTo	Status to	Enum

RentalTransferRule (Transfer rules)

Name	Label	Type	Length
FleetFrom	Fleet from	Enum
FleetTo	Fleet to	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalPurchaseOptionTransfer	Rental purchase option transfer	Enum

RentalTruck (Trucks)

Name	Label	Type	Length
InspectionExpirationDate	Inspection expiration date	Date
IsInternal	Internal	Enum
PlateExpirationDate	License plate expiry date	Date
PlateNumber	Truck plate number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TruckId	Truck ID	String	20

RentalUserSetup (Rental user setups)

Name	Label	Type	Length
AutoSitePopulation	Auto site population	Enum
InventLocationId	Warehouse	String	10
ManageAllReservations	Manage all reservations	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RentalItemAttachmentAll	Attachment on rental item availability	Enum
RentalItemShowAllOnAvailability	Show all on rental item availability	Enum
RentalTemplate	Rental template	RecId
ReservationType	Rental item reservation types	RecId
ShowUtilizationOnAvailability	Utilization on availability	Enum
UserId	User ID	String	20

RentalWorkerFleetType (Worker fleet type)

Name	Label	Type	Length
FleetType	Fleet type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Worker	Worker	RecId

RetailICFirmPendingPriceRecalc ()

Name	Label	Type	Length
FirmingRunId	Firming run id	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesDataAreaId	Company	String	4
SalesId	Sales order	String	20

RetailPaymentProfile (Payment Profile)

Name	Label	Type	Length
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
ProfileId	Profile number	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RetailPaymentProfileConfiguration (Payment Profiles)

Name	Label	Type	Length
DisplayOrder	Display order	Integer
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ProfileId	Profile number	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TenderTypeId	Payment method	String	10

RetailPaymentProfileConfigurationStaging (Payment Profiles)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
DisplayOrder	Display order	Integer
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
ProfileId	Profile number	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TenderTypeId	Payment method	String	10
TransferStatus	Staging to target status	Enum

RetailPaymentProfileStaging (Payment Profile)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Name	Name	String	60
ProfileId	Profile number	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

SysUserLoginEventsLog ()

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Email	Email	String	80
ExpiryDateTime	End date/time	Date time
modifiedDateTime	Modified date and time	Date time
NotBeforeDateTime	Start date/time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	String 30	String	30
UserObjectId	GUID	Guid

TrvExpenseMobileDimensionSelection (Expense mobile dimension selection)

Name	Label	Type	Length
DimensionAttributeRecId	Reference	RecId
DimensionName	Dimensions	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

UserManagementFinOpsRolesToDVMapping ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DataverseRoleId	DataverseRoleId	Guid
FinOpsRoleAOTName	FinOpsRoleAOTName	String	255
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RoleChecksum	RoleChecksum	String	60

VendInvoiceJourRegistrationIds (Vendor Invoice Registration Ids)

Name	Label	Type	Length
CountryRegionId	Country/region	String	10
IsHeadOrPrimary	Is head or primary	Enum
Issuer	Issuing agency	String	60
PartyRole	Party role	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationCategory	Registration category	Enum
RegistrationNumber	Registration number	String	60
RegistrationType	Registration type	String	30
ValidFrom	Effective	Date
ValidTo	Expiration	Date
VendInvoiceJour	Reference	RecId
VendInvoiceTrans	Reference	RecId

VRMGlobalVendorSyncLog (Global vendor creation log)

Name	Label	Type	Length
BatchCreatedBy	Created by	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EndDateTime	End date/time	Date time
GlobalVendorName	Name	String	160
GlobalVendorNumber	Global vendor number	String	100
GlobalVendorPartyNumber	Global vendor Party ID	String	40
Infolog	Infolog data	Bin/Memo/Container
JobId	Batch job ID	RecId
MergingParties	Merging parties	Bin/Memo/Container
MergingWith	Merging with	String	40
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDateTime	Start date/time	Date time
Status	Status	Enum
Step	Initial sync step	Enum

WHSContainerTablePackingLayout (Container packing layouts)

Name	Label	Type	Length
ContainerId	Container ID	String	25
PackingLayoutJson	PackingLayoutJson	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer

WHSSortPickingWorkLinesWorkQueue (Sort picking work lines work queue)

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
WorkBuildId	Work creation number	String	20
WorkId	Work ID	String	20