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

Comparison between versions 10.0.41 and 10.0.42

New tables

AppCopilotAgentTask (AppCopilotAgentTask)

Name	Label	Type	Length
BatchJobRecId	BatchJobRecId	Big integer
BotSchema	BotSchema	String	100
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
InputJson	InputJson	Bin/Memo/Container
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
RecurrenceData	Recurrence	Bin/Memo/Container
recVersion	Record Version	Integer
Title	Title	String	200

AppCopilotAgentTaskHistory (AppCopilotAgentTaskHistory)

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

AssetProposalConfiguration (AssetProposalConfiguration)

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

AssetProposalQueue (AssetProposalQueue)

Name	Label	Type	Length
AcquisitionDate	Acquisition date	Date
AssetBookRecId	Reference	RecId
AssetId	Fixed asset number	String	20
BookId	Book	String	10
createdDateTime	Created date and time	Date time
JournalNum	Journal batch number	String	20
ProposalId	ProposalId	Guid
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Shard	Shard	Integer

AssetProposalRequest (AssetProposalRequest)

Name	Label	Type	Length
AssetProposalType	AssetProposalType	Enum
BatchCreationCompleted	BatchCreationCompleted	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RequestId	RequestId	Guid

CLMIntegrationEntityValidation (CLM integration entity validation)

Name	Label	Type
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
RefTableId	Reference table ID	Integer
ValidationResult	Notes	Bin/Memo/Container

CLMIntegrationExternalNavigationLinkKeyValueStaging (CLM integration external navigation link key-value pairs)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Key	Key	String	255
KeyValueType	Key value type	Enum
NavigationType	Navigation type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
Value	Value	String	1000

CLMIntegrationExternalNavigationLinkStaging (CLM integration external navigation links)

Name	Label	Type	Length
Action	Action	Enum
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
NavigationName	Navigation name	String	60
NavigationType	Navigation type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelativeURL	Relative URL	String	255
ServiceInstanceName	Connection name	String	60
TransferStatus	Staging to target status	Enum

CLMIntegrationServiceInstanceStaging (CLM integration service instance)

Name	Label	Type	Length
BaseURL	Base URL	String	255
ConfigurationStatus	Connection configuration status	Enum
DefinitionGroup	Processing group	String	60
EstablishmentStatus	Connection establishment status	Enum
ExecutionId	Job ID	String	90
ExternalNavigationBaseURL	External navigation base URL	String	255
ID	ID	Integer
InstanceEnabled	Is enabled	Enum
InstanceName	Connection name	String	60
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
ValidationStatus	Connection validation status	Enum

CustAssignedInvoiceNumbers (Assigned free text invoice numbers)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FiscalCalendarRecId	Fiscal calendar of the posted invoice	RecId
InvoiceDate	Date	Date
InvoiceId	Invoice	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustAssignedInvoiceNumbersTempData (CustAssignedInvoiceNumbersTempData)

Name	Label	Type	Length
FiscalEntriesAdded	FiscalEntriesAdded	Enum
InvoiceId	Invoice	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourAdjustmentHistory (CustInvoiceJourAdjustment history data)

Name	Label	Type	Length
AdjustDateTime	New tax invoice date	Date time
AdjustmentType	Adjustment type	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
CustInvoiceJour	Reference	RecId
CustomerPhone	Telephone	String	20
CustomerTeleFax	Fax	String	20
Description	Description	String	60
InvoiceBranch	Branch number	String	15
InvoiceBranchName	Branch name	String	60
InvoiceTaxRegNumber	Registration number	String	60
InvoiceVATNum	Tax payer identification number	String	20
InvoicingAddress	Address	String	250
InvoicingName	Customer name	String	160
IsPrinted	Printed	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Reference	Reference	String	20
TaxInvoiceId	Tax invoice number	String	20

CustInvoiceJourCorrectionTypeHistory_RU (CustInvoiceJourCorrectionType_RU history data)

Name	Label	Type
CorrectionType	Correction type	Enum
CustInvoiceJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourCorrLinkHistory_RU (CustInvoiceJourCorrLink_RU history data)

Name	Label	Type
CorrJourRecId	Reference	RecId
JourRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourExtensionHistory_CN (CustInvoiceJourExtension_CN history data)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustInvoiceJour	Reference	RecId
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VATInvoiceDescTable	VAT invoice description ID	RecId

CustInvoiceJourExtensionHistoryTH (CustInvoiceJourExtensionTH history data)

Name	Label	Type	Length
CustInvoiceJour	Reference	RecId
IsPrinted	Printed	Enum
NoteFormat	Note format	Enum
NumberSequenceId	Reference	RecId
ReasonTableRef	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefInvoiceAmountCur	Reference invoice amount	Real
RefInvoiceId	Reference invoice recid	String	50
TaxAgent	Tax agent reference RecId	RecId

CustInvoiceJourHistory (CustInvoiceJour history data)

Name	Label	Type	Length
ArchiveServiceJobId	Service job id	Guid
Backorder	Backorder sales	Enum
BankLCExportLine	Shipment number	RecId
BillOfLadingId	Bill of lading	String	17
CashDisc	Cash discount	Real
CashDiscBaseDate	Payment terms base date	Date
CashDiscCode	Cash discount	String	10
CashDiscDate	Cash discount date	Date
CashDiscPercent	Discount percentage	Real
CommissionType_IT	Commission settlement	Enum
ContactPersonId	Contact ID	String	20
CovStatus	Cash flow forecast	Integer
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
CustGroup	Group	String	10
CustomerRef	Your ref.	String	60
DefaultDimension	Dimension	RecId
DeliveryName	Delivery name	String	160
DeliveryPostalAddress	Postal address	RecId
DirectDebitMandate	Direct debit mandate ID	RecId
DlvMode	Mode of delivery	String	10
DlvTerm	Delivery terms	String	10
DocumentDate	Document date	Date
DocumentNum	Document number	String	20
DueDate	Due	Date
EInvoiceAccountCode	Dimension account	String	35
EInvoiceLineSpecific	Line-specific	Enum
ElectronicInvoiceFrameworkType_FR	Reference	RecId
EndDisc	Total discount	Real
EndDiscMST	The total discount, in the accounting currency	Real
EnterpriseNumber	Enterprise number	String	50
EUSalesList	Dispatch	String	20
ExchRate	Rate	Real
ExchRateSecondary	Secondary exchange rate	Real
FinTag	Financial tag	RecId
FixedDueDate	Due date	Date
GiroType	Associated payment attachment on customer invoice	Enum
HeaderTax	Sales tax amount	Real
InclTax	Prices include sales tax	Enum
IntentLetterFromDate_IT	From date	Date
IntentLetterId_IT	Intent letter number	String	17
IntentLetterInternalId_IT	Internal Intent letter number	String	10
IntentLetterToDate_IT	To date	Date
InterCompanyCompanyId	Intercompany company	String	4
InterCompanyPosted	Posted via intercompany	Enum
InterCompanyPurchId	Intercompany purchase order	String	20
IntrastatDispatch	Shipment batch	String	20
IntrastatFulfillmentDate_HU	Intrastat fulfillment date	Date
inventLocationId	Warehouse	String	10
InvoiceAccount	Invoice account	String	20
InvoiceAmount	Invoice amount	Real
InvoiceAmountMST	The invoice amount in the accounting currency	Real
InvoiceDate	Date	Date
InvoiceId	Invoice	String	20
InvoicePostalAddress	Postal address	RecId
InvoiceRoundOff	Round-off	Real
InvoiceRoundOffMST	Rounding off in the accounting currency	Real
InvoiceType_W	Invoice type	Enum
InvoicingName	Invoicing name	String	160
IsCorrection	Credit correction	Enum
LanguageId	Language	String	7
LedgerVoucher	Voucher	String	20
Listcode	List code	Enum
Log	Log	String	255
MCRDueAmount	Amount due	Real
MCREmail	Email	String	80
MCRPaymAmount	Paid	Real
modifiedDateTime	Modified date and time	Date time
numberSequenceGroup	Number sequence group	String	10
OnAccountAmount	On-account	Real
OneTimeCustomer	One-time customer	Enum
OrderAccount	Customer account	String	20
ParmId	Parameter ID	String	20
PartyTaxID	Tax registration number	RecId
PaymDayId	Payment day	String	10
Payment	Terms of payment	String	100
PaymentSched	Payment schedule	String	30
PaymId	Payment ID	String	200
PostedState	Posted state	Enum
PostingProfile	Posting profile	String	10
Prepayment	Prepayment journal voucher	Enum
PrintDynamicQRCode_IN	Print dynamic QR code	Enum
PrintedOriginals	Originals printed	Integer
PrintMgmtSiteId	Print site	String	10
Proforma	Pro forma	Enum
ProjectManager_FR	Project manager	String	20
ProvisionalAssessment_IN	Provisional assessment	Enum
PurchaseOrder	Requisition	String	20
QRCode_SA	QR Code SA	String	1000
Qty	Quantity	Real
RCSalesList_UK	Dispatch	String	20
ReasonTableRef	Reason table reference	RecId
ReceiptDateConfirmed_ES	Confirmed receipt date	Date
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefNum	Type	Enum
ReportingCurrencyExchangeRate	Reporting currency fixed exchange rate	Real
ReportingCurrencyExchangeRateSecondary	Secondary exchange rate	Real
ReturnItemNum	RMA number	String	10
ReturnReasonCodeId	Return reason code	String	10
ReturnStatus	Return status	Enum
ReverseChargeAmount	Reverse charge amount	Real
ReversedRecId	Reversed customer invoice	RecId
SalesBalance	Sales subtotal amount	Real
SalesBalanceMST	The sales subtotal amount, in the accounting currency	Real
SalesId	Sales order	String	20
SalesOriginId	Sales origin	String	10
SalesType	Order type	Enum
SentElectronically	Sent electronically	Enum
ServiceCode_FR	Invoice account service code	String	100
ServiceCodeRefRecId	Reference	RecId
ShipCarrierBlindShipment	Blind shipment	Enum
SourceDocumentHeader	Source document	RecId
SourceDocumentLine	Source document line	RecId
SubBillSuppressChildItems	Don't print child items	Enum
SumLineDisc	Line discount	Real
SumLineDiscMST	The line discount in the accounting currency	Real
SumMarkup	Total charges	Real
SumMarkupMST	The summary miscellaneous charges, in the accounting currency	Real
SumTax	Sales tax	Real
SumTaxMST	The sales tax, in the accounting currency	Real
TaxGroup	Sales tax group	String	10
TaxID	Tax registration number	RecId
TaxInvoiceSalesId	Tax invoice ID - sales	String	50
TaxItemGroup	Item sales tax group	String	10
TaxPrintOnInvoice	Write on invoice	Enum
TaxSpecifyByLine	Specified	Enum
TransportationDocument	Transportation details	RecId
Triangulation	Triangulation	Enum
Updated	Updated	Enum
VATNum	Tax exempt number	String	20
Volume	Volume	Real
Weight	Weight	Real
WorkerSalesTaker	Sales taker	RecId

CustInvoiceJourHistory_BR (CustInvoiceJour_BR history data)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustFinalUser_BR	Final user	Enum
CustInvoiceJour	Reference	RecId
FiscalDocumentType_BR	Reference	RecId
FiscalEstablishment_BR	Fiscal establishment ID	RecId
modifiedDateTime	Modified date and time	Date time
PresenceType	Presence type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesPurchOperationType_BR	Reference	RecId
ServiceCodeOnDlvAddress_BR	Service on delivery address	Enum
TransitControlVoucher_BR	Voucher	String	20

CustInvoiceJourHistory_FR (CustInvoiceJour_FR history data)

Name	Label	Type
CustInvoiceJour	Reference	RecId
NumberSequenceId	Reference	RecId
PrintOverdueFineTxt	Print lump sum recovery text	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourHistory_IN (CustInvoiceJour_IN history data)

Name	Label	Type	Length
CustInvoiceJour	Reference	RecId
ExciseInvoiceAddress	Excise invoice address	Enum
ExciseInvoiceId	Excise invoice number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourHistory_Intrastat (CustInvoiceJour_Intrastat history data)

Name	Label	Type	Length
CustInvoiceJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SpecialMovement_CZ	Special movement	String	2

CustInvoiceJourHistory_Officials (CustInvoiceJour_Officials history data)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustInvoiceJour	Reference	RecId
modifiedDateTime	Modified date and time	Date time
OffSessionId	Official session	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourHistory_PL (CustInvoiceJour_PL history data)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustInvoiceJour	Reference	RecId
FiscalDocDate_PL	Fiscal document date	Date
FiscalDocState_PL	Sales document status	Enum
FiscalInvoiceAccount_PL	Fiscal invoice account	String	20
FiscalOrderAccount_PL	Fiscal customer account	String	20
FiscalPrinterCode_PL	Fiscal printer	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourHistory_RU (CustInvoiceJour_RU history data)

Name	Label	Type	Length
AttorneyDate_RU	From	Date
AttorneyId_RU	Proxy number	String	30
AttorneyIssuedName_RU	Issued	String	30
ConsigneeAccount_RU	Consignee	String	20
ConsignorAccount_RU	Shipper	String	20
Correct_RU	Corrective document	Enum
CorrectedInvoiceDate_RU	Invoice date	Date
CorrectedInvoiceId_RU	Invoice	String	50
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustInvoiceJour	Reference	RecId
CustInvoicePrintoutType_RU	Printout	Enum
FacturedFully_RU	Fully factured	Enum
InventOwnerId_RU	Owner	String	40
InventProfileType_RU	Kind of activity	Enum
InvoicePostingType_RU	Posting type	Enum
modifiedDateTime	Modified date and time	Date time
NonRealRevenue_RU	Unrealized revenue	Enum
PrintStandardCurrency_RU	Print in national currency	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SettleVoucher_RU	Settlement type	Enum
VATOnPayment_RU	VAT on payment	Enum

CustInvoiceJourHistory_W (CustInvoiceJour_W history data)

Name	Label	Type	Length
BankAccount_W	Primary company bank account	String	10
CashDiscOrigInvoiceCustTrans_CZ	Reference	RecId
CompanyCurBankAccount_W	Bank code for additional currency	String	10
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustBankAccount_LV	Customer bank account	String	10
CustConsInvoice_JP	Consolidation ID reference	RecId
CustInvoiceJour	Reference	RecId
EntryCertificateReceiptDate_W	Entry certificate receipt date	Date
EntryCertificateReceiptStatus_W	Entry certificate receipt status	Enum
hasReference_MY	hasReference_MY	Enum
IntrastatAddValue_LV	Intrastat additional value	Real
InvoiceType_IT	Invoice type	Enum
InvoiceType_MY	Invoice type	Enum
IsCashDiscReversed_CZ	IsCashDiscReversed_CZ	Enum
modifiedDateTime	Modified date and time	Date time
NoteType_MY	Note type of invoice journal	Enum
NumberSequenceCode_W	Number sequence code	String	10
NumberSequenceId_IT	Reference	RecId
PrintBlankDate_W	Empty date	Enum
QRCode_W	QR Code	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesDate_W	Sales date	Date
StateInvoicePrinted_LV	StateInvoicePrinted_LV	Enum
SubmissionUUID_EG	Invoice UUID	String	50
SubmissionUUID_W	Submission UUID	String	1000
SumTaxWithhold_IN	Amount in transaction currency	Real
TaxReimbursementDoc_HU	Tax reimbursement document	String	20
TaxWithholdAmount_IN	Amount in transaction currency	Real
UnitedVATInvoice_LT	United VAT invoice	Enum
VatSettled_HU	Vat settled	Enum
WhoIsAuthor_LT	Document author	Enum

CustInvoiceJourPrintHistory (CustInvoiceJourPrint history data)

Name	Label	Type
CustInvoiceJour	Reference	RecId
HasOriginalBeenPrinted	HasOriginalBeenPrinted	Enum
NumberOfCopiesPrinted	Copies	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceJourSymbolHistory (CustInvoiceJourSymbol history data)

Name	Label	Type	Length
BankConstantSymbol	Constant symbol	RecId
CustInvoiceJour	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SpecificSymbol	Specific symbol	String	20

CustInvoiceLineAssetHistory (CustInvoiceLineAsset history data)

Name	Label	Type
AssetSaleFactor	Partial sales	Real
CustInvoiceLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceLineCorrLinkHistory_RU (CustInvoiceLineCorrLink_RU history data)

Name	Label	Type
CorrTransRecId	Reference	RecId
CustInvoiceLineRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceLineHistory (CustInvoiceLine history data)

Name	Label	Type	Length
AccountingDistributionTemplate	Template ID	RecId
AmountCur	Amount	Real
AmountDetails	Amount details	Bin/Memo/Container
AssetBookId	Book	String	10
AssetId	Fixed asset number	String	20
AssetId_RU	FA inventory number	String	20
BillingCode	Billing code	String	10
Brand_MX	Brand	String	30
CFOPTable_BR	Reference	RecId
Consignment_MX	Consignment	Enum
CorrectedCustInvoiceLine	Reference	RecId
CountryName_RU	Short name	String	255
CreditNoteInternalRef_PL	Reference	RecId
CustBillingCode	Billing code reference id	RecId
CustDirective_PSN	Reference	RecId
CustInvoiceLineTemplate	Reference	RecId
CustomsDocDate_MX	Custom date	Date
CustomsDocNumber_MX	Custom number	String	21
CustomsName_MX	Custom name	String	60
DefaultDimension	Dimension	RecId
Description	Description	String	512
EInvoiceAccountCode	Dimension account	String	35
ExternalInvoiceId	External invoice number	String	60
FinTag	Financial tag	RecId
IntrastatCommodity	Commodity	RecId
InvoiceGtd_RU	GTD number	String	30
InvoiceTxt	Invoice text	Bin/Memo/Container
LedgerDimension	Main account	RecId
LineNum	Line number	Real
NGPCodesTable_FR	NGP	RecId
OrderLineReference_NO	Order line reference	String	30
OrigCountryRegionId	Country/region of origin	String	10
OrigState	State of origin	String	10
OverrideSalesTax	Override sales tax	Enum
ParentRecId	Reference	RecId
PeriodChargeInvoiceLineBaseFromDate	From date	Date
PeriodChargeInvoiceLineBaseToDate	To date	Date
PKWiUCode_PL	PKWiU	String	20
Port	Port	String	10
ProjCategoryId	Category	String	30
ProjFundingSource	Funding source	RecId
ProjId	Project ID	String	20
ProjTransId	Transaction ID	String	20
PropertyNumber_MX	Property number	String	20
Quantity	Quantity	Real
ReasonRefRecId	Reason table reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefReturnInvoiceTrans_W	Rec. ID of returned invoice line	RecId
SalesUnit_RU	Measurement unit	String	10
Samples_MX	Samples	Enum
SATCustomsQty_MX	Customs quantity	Real
SATCustomUnitOfMeasure_MX	SAT customs unit of measure	String	10
SATProductCode_MX	SAT product code	String	10
SATTariffFraction_MX	SAT tariff fraction	String	10
SATUnitCode_MX	SAT unit code	String	10
ServiceInvoice_BR	Service invoice	Enum
SourceDocumentLine	Source document line	RecId
StatProcId	Statistics procedure	String	10
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TaxAmount	Sales tax amount	Real
TaxAutogenerated	Auto	Enum
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TaxServiceCode_BR	Service code	String	10
TaxWithholdGroup	Withholding tax group	String	10
TaxWithholdItemGroupHeading_TH	Item withholding tax group	RecId
TaxWriteCode	Print code	String	10
TransactionCode	Transaction code	String	10
Transport	Transport	String	10
UnitPrice	Unit price	Real
Weight	Total weight	Real

CustInvoiceLineHistory_W (CustInvoiceLine_W history data)

Name	Label	Type	Length
CustInvoiceLine	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefInvoiceDate_MY	Original invoice date	Date
RefInvoiceID_MY	Original invoice number	String	50

CustInvoiceLineInterProjHistory (CustInvoiceLineInterProj history data)

Name	Label	Type	Length
ActivityNumber	Activity number	String	50
CostPrice	Cost price	Real
CustInvoiceLine	Reference	RecId
HcmWorker	Worker	RecId
IndirectComponentAmount	Indirect cost components	Real
OrigTransCurrency	Currency	String	3
OrigTransRecId	Reference	RecId
OrigTransSourceDocumentLine	Reference	RecId
ProjCategoryId	Category	String	30
ProjDataArea	Company	String	4
ProjId	Project ID	String	20
ProjLinePropertyId	Line property	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesPrice	Sales price	Real
SalesPriceCurrency	Currency	String	3
TransactionOrigin	Transaction origin	Enum
TransDate	Date	Date
TransType	Transaction type	Enum

CustInvoiceLineTaxExtensionHistoryIN (CustInvoiceLineTaxExtensionIN history data)

Name	Label	Type	Length
AssessableValueTransactionCurrency	Assessable value	Real
CustInvoiceLine	Reference	RecId
MaximumRetailPrice	Max. retail price	Real
MaxRetailPricePerUnit	Max. retail price per unit	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TCSGroup	TCS group	String	10
TDSGroup	TDS group	String	10

CustInvoiceTableCalcTotalsHistory (CustInvoiceTableCalcTotals history data)

Name	Label	Type
createdDateTime	Created date and time	Date time
CustInvoiceTable	Reference	RecId
PackedCustFreeInvoiceCalcTotals	PackedCustFreeInvoiceCalcTotals	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceTableExtensionHistory_CN (CustInvoiceTableExtension_CN history data)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CustInvoiceTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VATInvoiceDescTable	VAT invoice description ID	RecId

CustInvoiceTableExtensionHistoryTH (@SYS4083039@AccountsReceivable:CustInvoiceTableExtensionHistoryTHCaption)

Name	Label	Type	Length
CustInvoiceTable	Reference	RecId
NoteFormat	Note format	Enum
ReasonTableRef	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefInvoiceAmountCur	Reference invoice value	Real
RefInvoiceId	Reference invoice	String	50
TaxAgent	Tax agent	RecId

CustInvoiceTableHistory (CustInvoiceTable history data)

Name	Label	Type	Length
AccountingDistributionTemplate	Accounting distribution template	RecId
AdjustingInvoiceDate	Date	Date
AgreementHeaderExt_RU	Agreement ID	RecId
BankAccount_LV	Primary company bank account	String	10
BankCentralBankPurposeCode	Central bank purpose code	String	10
BankCentralBankPurposeText	Purpose text	String	210
CashDiscBaseDate	Payment terms base date	Date
CashDiscBaseDays	Payment terms base days	Integer
CashDiscCode	Cash discount	String	10
CashDiscDate	Cash discount date	Date
CashDiscPercent	Discount percentage	Real
CertificateNumber_MX	Certificate number	String	40
CFDIEInvoicePeriod_MX	Period	Enum
CFDITemporaryExport_MX	Temporary export	Enum
CFOPTable_BR	CFOP	RecId
CFPSId_BR	CFPS code	String	4
ComplementedInvoiceId	Invoice	String	50
ConsigneeAccount_RU	Consignee	String	20
ConsignorAccount_RU	Shipper	String	20
ContactPersonId	Contact ID	String	20
Correct_RU	Corrective document	Enum
CorrectedFactureDate_RU	Facture date	Date
CorrectedFactureExternalId_RU	Facture	String	30
CorrectedInvoiceDate_RU	Invoice date	Date
CorrectedInvoiceId_RU	Invoice	String	50
CorrectedPeriod_RU	Corrected period	Date
CorrectionReasonCode	Reason table reference	RecId
CorrectionType_RU	Correction type	Enum
CovStatus	Cash flow forecast	Integer
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurBankAccount_LV	Bank code for additional currency	String	10
CurrencyCode	Currency	String	3
CustBankAccount_LV	Customer bank accounts	String	10
CustBankAccountId	Bank account	String	10
CustBillingClassification	Billing classification	RecId
CustFinalUser_BR	Final user	Enum
CustGroup	Group	String	10
CustomerInvoiceOriginId	Invoice origin	String	10
CustomerRef	Customer reference	String	60
DefaultDimension	Dimension	RecId
DeliveryDate_ES	Delivery date	Date
DeliveryLocation	Location	RecId
DeliveryPostalAddress	Postal address	RecId
DirectDebitMandate	Direct debit mandate ID	RecId
DlvTerm	Delivery terms	String	10
DocNumberingCode_LT	Numbering	String	10
DocumentDate	Document date	Date
DueDate	Due	Date
EInvoiceAccountCode	Dimension account	String	35
EInvoiceCFDIConfirmNumber_MX	Confirmation number	String	5
EInvoiceLineSpec	Line-specific	Enum
ElectronicInvoiceFrameworkType_FR	Reference	RecId
EnterpriseNumber	Enterprise number	String	50
ExchRate_W	Exchange rate	Real
ExcludeFromDecoupledPostingProcess	Exclude from decoupled posting process	Enum
ExternalInvoiceId	External invoice number	String	60
FineCode_BR	Fine code	String	10
FinTag	Financial tag	RecId
FiscalAddress_MX	Fiscal address	String	10
FiscalDocType_PL	Printed document	Enum
FiscalDocumentType_BR	Fiscal document type	RecId
FiscalEstablishment_BR	Fiscal establishment ID	RecId
ForeignTrade_MX	Foreign trade	Enum
ForInterestAdjustment	ForInterestAdjustment	Enum
GiroType	Associated payment attachment on free text invoice	Enum
InclTax	Prices include sales tax	Enum
IntentLetterId_IT	Internal Intent letter number	String	10
InterCompanyPosted	Posted via intercompany	Enum
InterestCode_BR	Interest code	String	10
IntrastatFulfillmentDate_HU	Intrastat fulfillment date	Date
InvoiceAccount	Invoice account	String	20
InvoiceComplementaryType	Complementary fiscal document type	Enum
InvoiceDate	Date	Date
InvoiceId	Invoice	String	20
InvoiceType_W	Invoice type	Enum
LanguageId	Language	String	7
Listcode	List code	Enum
Log	Log	String	255
ManualInvoiceID_W	Assigned number	String	50
ManualNumbering_W	Invoice auto numbering	Enum
MCRGiftCard	Gift card	Enum
MCRLedgerVoucher	Voucher	String	20
MCRNumberSequenceCode	Number sequence code	String	10
MCRSalesID	Sales order	String	20
Name	Invoice name	String	100
NatureOfAssessee_IN	Nature of assessee	Enum
NonRealRevenue_RU	Unrealized revenue	Enum
numberSequenceGroup	Number sequence group	String	10
NumRegIdTrib_MX	Registration number	String	40
OneTimeCustomer	One-time customer	Enum
OrderAccount	Customer account	String	20
OrderAccountRefRecId	Reference	RecId
OverrideSalesTax	Override sales tax	Enum
Payment	Terms of payment	String	100
PaymentSched	Payment schedule	String	30
PaymMode	Method of payment	String	10
PaymSpec	Payment specification	String	10
Port	Port	String	10
PostalAddress	Postal address	RecId
Posted	Posted	Enum
PostingProfile	Posting profile	String	10
PostponeVAT	Postponed VAT	Enum
PresenceType_BR	Presence type	Enum
PrintDynamicQRCode_IN	Print dynamic QR code	Enum
PrintOverdueFineTxt_FR	Print lump sum recovery text	Enum
ProjectManager_FR	Project manager	String	20
ProjIntercompany	Company	String	4
ProvisionalAssessment_IN	Provisional assessment	Enum
PurchOrderFormNum	Customer requisition	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReleaseDate	Release date	Date time
SalesDate_W	Sales date	Date
SalesId	Sales order	String	20
SalesPurchOperationType_BR	Operation type	RecId
SATIncotermCode_MX	Incoterm	String	10
SATPaymMethod_MX	Payment type	String	10
SATPurpose_MX	Purpose	String	10
ServiceCode_FR	Invoice account service code	String	100
ServiceCodeOnDlvAddress_BR	Service on delivery address	Enum
ServiceCodeRefRecId	Reference	RecId
SourceCertificate_MX	Source certificate	Enum
SourceDocumentHeader	Source document header	RecId
SourceDocumentLine	Source document line	RecId
StatProcId	Statistics procedure	String	10
SubLedgerJournalStatus	Subledger journal status	Enum
TAMDeductionID	Deduction ID	String	20
TAMRebateTransId	Rebate transaction number	String	20
TaxGroup	Sales tax group	String	10
TaxId	Tax registration number	RecId
TaxInvoiceTransactionCode_ID	Tax invoice transaction code	String	2
TaxItemGroup	Item sales tax group	String	10
TaxPeriodPaymentCode_PL	VAT report date code	String	10
TaxWithholdCalculate	TaxWithholdCalculate	Enum
TCSGroup_IN	TCS group	String	10
TDSGroup_IN	TDS group	String	10
Touched	Update	Enum
TransactionCode	Transaction code	String	10
Transport	Transport	String	10
TransportationDocument	Transportation details	RecId
UnitedVATInvoice_LT	United VAT invoice	Enum
UseDefaultFromCustomer	Generate recurring invoices by using the default values from	Enum
VatDueDate_W	Date of VAT register	Date
VATNum	Tax exempt number	String	20
VATNumRecId	Reference	RecId
VATNumTableType	VATNumTableType	Enum
VATOnPayment_RU	VAT on payment	Enum
WithIGSTPayment_IN	With tax payment	Enum
WorkerSalesTaker	Recipient	RecId
WorkflowApprovalState	State	Enum
WorkflowApprovalStatus	Workflow status	Enum
WouldYouClaimRefund_IN	Would you claim refund	Enum

CustInvoiceTableHistory_W (CustInvoiceTable_W history data)

Name	Label	Type	Length
CustInvoiceTable	Reference	RecId
InvoiceType_MY	Invoice type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGSTImportDeclarationNo_MY	Import declaration number	String	20

CustInvoiceTableSymbolHistory (CustInvoiceTableSymbol history data)

Name	Label	Type	Length
BankConstantSymbol	Constant symbol	RecId
CustInvoiceTable	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SpecificSymbol	Specific symbol	String	20

CustInvoiceTransAssetHistory (CustInvoiceTransAsset history data)

Name	Label	Type
AssetSaleFactor	Partial sales	Real
CustInvoiceTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

CustInvoiceTransCorrLinkHistory_RU (CustInvoiceTransCorrLink_RU history data)

Name	Label	Type
CorrTransRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransRecId	Reference	RecId

CustInvoiceTransHistory (CustInvoiceTrans history data)

Name	Label	Type	Length
AssetBookId	Book	String	10
AssetId	Fixed asset number	String	20
BillingCode	Billing code	String	10
CommissAmountCur	Commission	Real
CommissAmountMST	Commission	Real
CommissCalc	Calculated commission	Enum
CountryRegionOfShipment	Country/region of shipment	String	10
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CurrencyCode	Currency	String	3
CustInvoiceLineIdRef	Reference	RecId
CustomerLineNum	Line number	Integer
DefaultDimension	Dimension	RecId
DeliveryPostalAddress	Postal address	RecId
DeliveryType	Delivery type	Enum
DiscAmount	Discount	Real
DiscPercent	Discount percent	Real
DlvDate	Ship date	Date
EInvoiceAccountCode	Dimension account	String	35
ExternalItemId	External	String	20
FinTag	Financial tag	RecId
GoodsForFree_IT	Goods for free	Enum
InterCompanyInventTransId	Lot ID	String	20
IntrastatCommodity	Commodity	RecId
IntrastatDispatchId	Shipment batch	String	20
IntrastatFulfillmentDate_HU	Intrastat fulfillment date	Date
InventDimId	Dimension number	String	20
InventQty	Quantity	Real
InventRefId	Reference number	String	20
InventRefTransId	Reference lot	String	20
InventRefType	Reference type	Enum
InventTransId	Lot ID	String	20
InvoiceDate	Date	Date
InvoiceId	Invoice	String	20
ItemId	Item	String	20
LedgerDimension	Main account	RecId
LineAmount	Amount	Real
LineAmountMST	The amount in the accounting currency	Real
LineAmountTax	Sales tax included in amount	Real
LineAmountTaxMST	The sales tax, in the accounting currency, that is included in the amount	Real
LineCreationSequenceNumber	Line creation sequence number	Integer
LineDisc	Discount	Real
LineHeader	Line heading	String	80
LineNum	Line number	Real
LinePercent	Discount percent	Real
MCRDeliveryName	Delivery name	String	160
MCRDlvMode	Mode of delivery	String	10
modifiedDateTime	Modified date and time	Date time
MultiLnDisc	Multiline discount	Real
MultiLnPercent	Multiline discount percentage	Real
Name	Description	String	1000
NGPCodesTable_FR	NGP	RecId
numberSequenceGroup	Number sequence group	String	10
OLAPCostValue	Cost value	Real
OrderLineReference_NO	Order line reference	String	30
OrigCountryRegionId	Country/region of origin	String	10
OrigSalesId	Sales order	String	20
OrigState	State of origin	String	10
OverrideSalesTax	Override sales tax	Enum
ParentRecId	Reference	RecId
PartDelivery	Part delivery	Enum
PdsCWQty	CW quantity	Real
PdsCWQtyPhysical	CW quantity	Real
PdsCWRemain	CW remaining quantity	Real
PeriodChargeInvoiceLineBaseFromDate	From date	Date
PeriodChargeInvoiceLineBaseToDate	To date	Date
Port	Port	String	10
PriceUnit	Price unit	Real
Qty	Quantity	Real
QtyPhysical	Quantity	Real
ReasonRefRecId	Reason table reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Remain	Remaining quantity	Real
RemainBefore	Remaining quantity	Real
RetailCategory	Retail category	RecId
ReturnArrivalDate	Actual arrival date	Date
ReturnClosedDate	Closed date	Date
ReturnDispositionCodeId	Disposition code	String	10
ReverseCharge_W	Reverse charge	Enum
ReverseChargeSalesList	Reverse charge sales list	Enum
ReversedRecId	Reversed customer invoice line	RecId
RevRecDeferred	Deferred	Enum
RevRecDeferredProcessed	Processed	Enum
RevRecRevenueScheduleId	Revenue schedule	String	10
SalesCategory	Sales category	RecId
SalesGroup	Sales group	String	10
SalesId	Sales order	String	20
SalesMarkup	Charges	Real
SalesPrice	Unit price	Real
SalesUnit	Unit	String	10
SourceDocumentLine	Source document line	RecId
StateOfShipment	State/province of shipment	String	10
StatLineAmountMST	Statistics amount	Real
StatProcId	Statistics procedure	String	10
StockedProduct	Stocked	Enum
SubBillRevenueSplit	Revenue split	Enum
SubBillRevenueSplitAllocationMethod	Allocation method	Enum
SubBillRevenueSplitParentAmount	Parent amount	Real
SubBillRevenueSplitParentLineRecId	Reference	RecId
SumLineDisc	Line discount	Real
SumLineDiscMST	The line discount in the accounting currency	Real
TaxAmount	Sales tax amount	Real
TaxAmountMST	The sales tax amount, in the accounting currency	Real
TaxAutogenerated	Auto	Enum
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
TaxWithholdGroup_TH	Withholding tax group	String	10
TaxWithholdItemGroupHeading_TH	Item withholding tax group	RecId
TaxWriteCode	Print code	String	10
TotalCharge	Amount in transaction currency	Real
TotalTax	Sales tax amount	Real
TransactionCode	Transaction code	String	10
Transport	Transport	String	10
Weight	Weight	Real

CustInvoiceTransHistory_BR (CustInvoiceTrans_BR history data)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CustInvoiceTrans	Reference	RecId
ICMSSTCollectionPaymentMode	ICMS-ST collection payment mode	Enum
ICMSSTCollectionPaymentNumber	ICMS-ST Collection payment number	String	256
modifiedDateTime	Modified date and time	Date time
NfeVbcstretVicmsstretTagsReported	Nfe vBCSTRet and vICMSSTRet tags	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RespWithholdoingICMSST	Responsible for Withholding the ICMS-ST	Enum

CustInvoiceTransHistory_IN (CustInvoiceTrans_IN history data)

Name	Label	Type	Length
AssessableValue_IN	Amount in transaction currency	Real
CompanyLocation_IN	Location	RecId
createdDateTime	Created date and time	Date time
CreditNoteDate_IN	Date	Date
CustInvoiceTrans	Reference	RecId
CustomsTariffCodeTable_IN	Tariff code	RecId
DirectSettlement_IN	Direct settlement	Enum
DSA_IN	DSA	Enum
ExciseRecordType_IN	Excise record type	Enum
ExciseTariffCodes_IN	Tariff code	RecId
ExciseType_IN	Excise type	Enum
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegistrationLocation_IN	Reference	RecId
RegistrationPostalAddress_IN	Reference	RecId
ReturnAction	Return action	String	60
ReturnReasonCodeId	Return reason code	String	10
SalesTaxFormTypes_IN	India sales tax form type	RecId
ServiceCodeTable_IN	Service code	RecId
TaxInformation_IN	Reference	RecId
TaxInventVATCommodityCode_IN	VAT commodity code	RecId
TaxWithholdLineNum_IN	Line number	Real
TaxWithholdReturn_IN	Reference number	String	20
TaxWithholdVoucher_IN	Voucher	String	20
TCSGroup_IN	Withholding tax group	String	10
TDSGroup_IN	Withholding tax group	String	10

CustInvoiceTransHistory_Intrastat (CustInvoiceTrans_Intrastat history data)

Name	Label	Type	Length
CustInvoiceTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SpecialMovement_CZ	Special movement	String	2

CustInvoiceTransHistory_RU (CustInvoiceTrans_RU history data)

Name	Label	Type	Length
AlcoholLicenseSeriesNum_RU	Alcohol license	String	21
AssetId_RU	FA inventory number	String	20
CountryRegionName_RU	Description	String	60
createdDateTime	Created date and time	Date time
CustInvoiceTrans	Reference	RecId
ExciseAmount_RU	Excise amount	Real
ExciseAmountMST_RU	Excise amount	Real
ExciseValue_RU	Excise value	Real
FacturedFully_RU	Fully factured	Enum
FacturedQty_RU	Factured	Real
InventTransIdDelivery_RU	Delivery lot	String	20
InventTransIdTransit_RU	Transit lot	String	20
MCRGiftCardAmount	Gift card amount	Real
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
VATAmount_RU	VAT amount	Real
VATAmountMST_RU	Amount of VAT	Real
VATValue_RU	VAT value	Real

CustInvoiceTransHistory_W (CustInvoiceTrans_W history data)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
CreditNoteInternalRef_W	Reference	RecId
CustInvoiceTrans	Reference	RecId
modifiedDateTime	Modified date and time	Date time
PKWiUCode_PL	PKWiU	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefInvoiceDate_MY	Date	Date
RefInvoiceID_MY	Invoice	String	50
RefReturnInvoiceTrans_W	Rec. ID of returned invoice line	RecId
StatisticValue_LT	Statistical value	Real
TaxReimbursement_HU	Tax reimbursement lines	Enum

CustInvoiceTransTaxExtensionHistoryIN (CustInvoiceTransTaxExtensionIN history data)

Name	Label	Type
CustInvoiceTrans	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TaxInformation	Tax information	RecId

CustomerInvoiceArchiveTrans (Customer invoice archive transactions)

Name	Label	Type	Length
EndDateTime	To date	Date time
InvoiceDataAreaId	Company	String	4
InvoiceDocumentType	Customer invoice document type	Enum
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDateTime	From date	Date time

DMFSingleUseCleanupParameters (Single use cleanup settings)

Name	Label	Type
DaysToRetainRecords	DaysToRetainRecords	Integer
FrequencyInMinutes	FrequencyInMinutes	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UseProcedures	UseProcedures	Enum

DMFSingleUseProjectsToRemove (Old single use projects to Remove)

Name	Label	Type	Length
DefinitionGroupName	Group name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

EcoResInventTableItemIdRenameLog (Item number renaming logs)

Name	Label	Type	Length
DurationMs	Duration in milliseconds	Integer
EndedDateTime	End date/time	Date time
ItemRecId	Item	RecId
NewItemId	New item number	String	20
OldItemId	Previous item number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartedDateTime	Start date/time	Date time

EcoResInventTableItemIdRenameLogLine (Item number renaming log lines)

Name	Label	Type	Length
EcoResInventTableItemIdRenameLog	Record-ID	RecId
EdtName	Field data type	String	81
FieldName	Field	String	81
IsExplicitlyExcluded	Explicitly excluded	Enum
IsExplicitlyIncluded	Explicitly included	Enum
IsInMemory	In memory field	Enum
IsReferencingOrInheritingItemId	References or inherits item number	Enum
IsRelatingToTableRefencingItemId	Has item number relations	Enum
IsSkipped	Skipped	Enum
IsTempDb	Temporary table	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RelatedFieldEdtName	Related field data type	String	81
RelatedFieldName	Related field	String	81
RelatedTableName	Related table	String	81
TableName	Table	String	81
UpdatedRecordsCount	Updated records	Integer
UpdateDurationMs	Update duration in milliseconds	Integer

EximCustInvoiceTransHistory_IN (EximCustInvoiceTrans_IN history data)

Name	Label	Type
ApplyDEPB	Apply DEPB	Enum
AssessableValue	Amount in transaction currency	Real
CustInvoiceTransRecId	Reference	RecId
CustomsTariffCodeTable	Tariff code	RecId
DBKCenvatStatus	CENVAT status	Enum
DBKPercent	Drawback pct.	Real
DBKRateType	Rate type	Enum
EximIncentiveSchemeGroup	Incentive scheme group	RecId
EximPorts	Port ID	RecId
EximProductGroupTable	Product group	RecId
MarketValue	Present market value	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum

FinTagByLegalEntity (Financial tag by legal entity)

Name	Label	Type	Length
DataArea	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Tag01	Financial tag configuration	RecId
Tag02	Financial tag configuration	RecId
Tag03	Financial tag configuration	RecId
Tag04	Financial tag configuration	RecId
Tag05	Financial tag configuration	RecId
Tag06	Financial tag configuration	RecId
Tag07	Financial tag configuration	RecId
Tag08	Financial tag configuration	RecId
Tag09	Financial tag configuration	RecId
Tag10	Financial tag configuration	RecId
Tag11	Financial tag configuration	RecId
Tag12	Financial tag configuration	RecId
Tag13	Financial tag configuration	RecId
Tag14	Financial tag configuration	RecId
Tag15	Financial tag configuration	RecId
Tag16	Financial tag configuration	RecId
Tag17	Financial tag configuration	RecId
Tag18	Financial tag configuration	RecId
Tag19	Financial tag configuration	RecId
Tag20	Financial tag configuration	RecId

FinTagConfigurationGlobalTmp (Financial tag configuration global temp table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FinTagConfiguration	Target	RecId
FinTagConfigurationDataArea	Company	String	4
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	GUID	Guid
TagName	TagName	String	60

FinTagRule (Financial tag rules (preview))

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
IsEnabled	Enabled	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	100
OverwriteExistingValue	Overwrite existing value	Enum
PowerFxFormula	PowerFx formula	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Target	Target	RecId
TransactionEntryPoint	Transaction entry point	Enum
TransactionLevel	Transaction level	Enum
Type	Financial tag rule type	Enum

FinTagRuleCopyTmp (Financial tag rules (preview))

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
GlobalCopyTarget	Target	RecId
IsEnabled	Enabled	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	100
OverwriteExistingValue	Overwrite existing value	Enum
PowerFxFormula	PowerFx formula	String	1000
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	GUID	Guid
Target	Target	RecId
TargetDataArea	Company	String	4
TransactionEntryPoint	Transaction entry point	Enum
TransactionLevel	Transaction level	Enum
Type	Financial tag rule type	Enum

FinTagRuleProcessingTime (Financial tag rule processing time)

Name	Label	Type
ActivityId	GUID	Guid
createdDateTime	Created date and time	Date time
DefaultingRuleRecId	Financial tag defaulting rule	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TimeInMS	Time in milliseconds	Real
TransactionEntryPoint	Transaction entry point	Enum
TransactionLevel	Transaction level	Enum
TriggerLevel	Financial tag rule trigger level	Enum

FinTagRuleStaging (Financial tag rule entity)

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

GUPDiscountClaimTopPickingStaging (GUPDiscountClaimTopPickingStaging)

Name	Label	Type	Length
BatchJobId	Batch job ID	RecId
CountOfDiscountClaims	CountOfDiscountClaims	Big integer
CurrencyCode	Currency	String	3
DiscountId	Discount ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ThreadNumber	ThreadNumber	Integer
VendorAccount	Vendor account	String	20

ImmersiveHomeUserPersonalization (Immersive home user personalization)

Name	Label	Type	Length
CardId	Card id	String	81
createdDateTime	Created date and time	Date time
HasBeenDismissed	Has been dismissed	Enum
HasBeenPinned	Has been pinned	Enum
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	User id	String	20

InventoryServiceDiagnosticProcessStatus (InventoryServiceDiagnosticProcessStatus)

Name	Label	Type	Length
Company	Company	String	4
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum

InventSettlementArchiveTrans (Inventory settlement archive transactions)

Name	Label	Type	Length
ArchiveDataAreaId	Company	String	4
ArchiveDate	Executed date	Date
ArchiveFromDate	From date	Date
ArchiveToDate	To date	Date
ArchiveUserId	Submitted by	String	81
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventSettlementHistory (Inventory settlement)

Name	Label	Type	Length
ArchiveServiceJobId	Service job id	Guid
BalanceSheetLedgerDimension	Balance account	RecId
BalanceSheetPosting	Balance sheet posting	Enum
Cancelled	Canceled	Enum
CostAmountAdjustment	Adjustment	Real
CostAmountSettled	Amount settled	Real
DefaultDimension	Dimension	RecId
InventTransCurrency_RU	Currency	Enum
InventTransId	Lot ID	String	20
ItemGroupId	Item group	String	10
ItemId	Item number	String	20
ITMCostTransRecId	Reference	RecId
ITMCostTypeId	Cost type code	String	20
MarkupCode_RU	Charges code	String	10
OperationsLedgerDimension	Profit and loss account	RecId
OperationsPosting	Profit and loss posting	Enum
PdsCWSettled	Covered CW quantity	Real
Posted	Posted	Enum
QtySettled	Settled quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SettleModel	Principle	Enum
SettleTransId	Transaction	String	20
SettleType	Settlement type	Enum
TransBeginTime	Transaction time	Date time
TransDate	Date	Date
TransRecId	Reference	RecId
VendAccountMarkup_RU	Vendor account	String	20
VendInvoiceIdMarkup_RU	Invoice	String	50
Voucher	Voucher	String	20

InventTransArchiveRecIdFilter (Transactions)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId
SessionId	Session	String	38

InventTransPostingArchiveTrans (Inventory transaction posting archive transactions)

Name	Label	Type	Length
ArchiveDataAreaId	Company	String	4
ArchiveDate	Executed date	Date
ArchiveFromDate	Date	Date
ArchiveToDate	Date	Date
ArchiveUserId	Submitted by	String	81
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventTransPostingHistory (Inventory transaction posting)

Name	Label	Type	Length
ArchiveServiceJobId	ArchiveServiceJobId	Guid
DefaultDimension	Dimension	RecId
InventTransOrigin	Inventory transactions originator	RecId
InventTransPostingType	Type	Enum
IsPosted	Posted	Enum
ItemId	Item number	String	20
LedgerDimension	Ledger account	RecId
OffsetLedgerDimension	Offset account	RecId
PostingType	Posting type	Enum
PostingTypeOffset	Offset account transaction type	Enum
ProjId	Project ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransBeginTime	Transaction time	Date time
TransDate	Date	Date
Voucher	Voucher	String	20

LedgerFiscalPeriodV2Staging (Ledger fiscal calendar period V2)

Name	Label	Type	Length
BankAccessLevel	Bank access level	Enum
BankUserGroupInfo	Bank user group	String	10
Calendar	Calendar	String	10
CustAccessLevel	Customer access level	Enum
CustUserGroupInfo	Customer user group	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
ExpenseAccessLevel	Expense access level	Enum
ExpenseUserGroupInfo	Expense user group	String	10
FixedAssets_RUAccessLevel	Fixed assets (RU) access level	Enum
FixedAssets_RUUserGroupInfo	Fixed assets (RU) user group	String	10
FixedAssetsAccessLevel	Fixed assets access level	Enum
FixedAssetsUserGroupInfo	Fixed assets user group	String	10
InventAccessLevel	Inventory access level	Enum
InventUserGroupInfo	Inventory user group	String	10
IsSelected	Select	Enum
ITMAccessLevel	Landed cost	Enum
ITMUserGroupInfo	Landed cost user group	String	10
LedgerAccessLevel	Ledger access level	Enum
LedgerName	Ledger name	String	20
LedgerUserGroupInfo	Ledger user group	String	10
LegalEntityId	Company	String	4
PayrollAccessLevel	Payroll access level	Enum
PayrollUserGroupInfo	Payroll user group	String	10
PeriodName	Period name	String	60
PeriodStatus	Period status	Enum
ProdAccessLevel	Production access level	Enum
ProdUserGroupInfo	Production user group	String	10
ProjectAccessLevel	Project access level	Enum
ProjectUserGroupInfo	Project user group	String	10
PurchAccessLevel	Purchasing access level	Enum
PurchUserGroupInfo	Purchasing user group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailAccessLevel	Retail access level	Enum
RetailUserGroupInfo	Retail user group	String	10
SalesAccessLevel	Sales access level	Enum
SalesUserGroupInfo	Sales user group	String	10
TaxAccessLevel	Tax access level	Enum
TaxUserGroupInfo	Tax user group	String	10
TransferStatus	Staging to target status	Enum
VendAccessLevel	Vendor access level	Enum
VendUserGroupInfo	Vendor user group	String	10
YearName	Fiscal year	String	10

LedgerTransferOpeningSettlementTmp (LedgerTransferOpeningSettlementTmp)

Name	Label	Type	Length
AccountingCurrencyAmount	Balance 1	Real
CurrencyCode	Currency	String	3
GeneralJournalAccountEntryHash	Reference	RecId
LedgerDimension	Account	RecId
MainAccount	Main account	RecId
OperationsTax	Posting layer	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportingCurrencyAmount	Balance 2	Real
SessionId	Session ID	Integer
TransactionCurrencyAmount	Amount	Real
UTCTimestamp	UTC timestamp	Date time

LedgerTransSettlementMarkedTransaction (Ledger settlements)

Name	Label	Type	Length
AutomationRule	Automation rule	String	60
GeneralJournalAccountEntry	GeneralJournalAccountEntry	Big integer
LedgerTransSettlement	LedgerTransSettlement	Big integer
Marked	Marked	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SettleId	Settlement ID	String	20
UserId	User ID	String	20

LedgerTransSettlementOpen (Ledger partial settlement)

Name	Label	Type
LatestSettleDate	Date settled	Date
OpenAccountingCurrencyAmount	Remaining amount in accounting currency	Real
OpenReportingCurrencyAmount	Remaining amount in reporting currency	Real
OpenTransactionCurrencyAmount	Remaining amount in transaction currency	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SettleStatus	Status	Enum
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TransRecId	Reference	RecId

LTMCustInvoiceJourHistory (LTMCustInvoiceJour history data)

Name	Label	Type	Length
AmountCUR	Amount (Debit / Credit)	Real
AmountMST	Amount	Real
BankAccountNum	Account identification	String	10
BankGroupId	Bank groups	String	10
Beneficiary	Beneficiary	String	60
BussinessName	Name / Company name	String	60
CaiCae	CA number	String	50
CAICAEDueDate	CA due date	Date
CompleteDocumentNum	Document	String	20
Concept1	Free Text 1	String	250
Concept2	Free Text 2	String	250
Concept3	Free Text 3	String	250
ControlCode	Control code	String	50
CountryDocNum	Country identification number	String	40
CountryDocTypeId	Country document type	String	15
CountryRegionId	Based in country/region	String	10
CPDAction	Action	Enum
CPDSource	Check source	Enum
CPDTRXHistoryID	Reference	RecId
CPDTRXOpenID	Reference	RecId
CurrencyCode	Currency	String	3
DocumentClassificationId	Document class Id	String	15
DocumentDate	Document date	Date
DocumentNum	Document number	String	20
DueDate	Due date	Date
ExchRate	Exchange rate	Real
HolderAccountNum	Holder's bank account	String	30
IsCollectPaymDoc	Value document	Enum
IsConcept	Concept	Enum
LedgerJournalTransId	Reference	RecId
LedgerVoucher	Voucher	String	20
ListField01	Description	String	60
ListField02	Description	String	60
ListField03	Description	String	60
ListField04	Description	String	60
ListField05	Description	String	60
ListField06	Description	String	60
ListField07	Description	String	60
ListField08	Description	String	60
ListField09	Description	String	60
ListField10	Description	String	60
ListFieldCode01	Reference code	String	30
ListFieldCode02	Reference code	String	30
ListFieldCode03	Reference code	String	30
ListFieldCode04	Reference code	String	30
ListFieldCode05	Reference code	String	30
ListFieldCode06	Reference code	String	30
ListFieldCode07	Reference code	String	30
ListFieldCode08	Reference code	String	30
ListFieldCode09	Reference code	String	30
ListFieldCode10	Reference code	String	30
Name	Name	String	60
OrigRecId	Record-ID	RecId
OrigTableId	Reference table ID	Integer
ParmId	Parameter ID	String	20
PaymTermId	Terms of payment	String	100
PreserveNum	preserve Number	Enum
PSEnable	Show information of Packing Slip	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefNum	Sales order/project	Enum
RefRecId	Reference	RecId
SalesId	Sales order	String	20
SalesPointId	Sales point	String	10
SalesPointPrefix	Prefix	String	10
SalesType	Order type	Enum
ShiftID	Shift id	String	20
StateDocNum	State identification number	String	30
StateDocTypeId	State document type	String	15
StateId	Jurisdiction registered	String	10
TaxPayerTypeId	Taxpayer type	String	15
TDETimbrado	Stamped	Bin/Memo/Container
WithholdAccruedAmountMST	Cumulative amount	Real
WithholdAccruedBaseMST	Cumulative tax base amount	Real
WithholdingBaseMST	Taxable amount	Real
WithholdingEffectiveRate	Effective tax rate	Real

LTMCustInvoiceTableHistory (LTMCustInvoiceTable history data)

Name	Label	Type	Length
AmountMST	Amount	Real
BankGroupId	Bank groups	String	10
Beneficiary	Beneficiary	String	60
BussinesName	Name / Company name	String	60
CAICAE	CA number	String	50
CaiCaeDueDate	CA due date	Date
CompleteDocumentNum	Document	String	20
Concept1	Free Text 1	String	250
Concept2	Free Text 2	String	250
Concept3	Free Text 3	String	250
ControlCode	Control code	String	50
CountryDocNum	Country identification number	String	40
CountryDocTypeId	Country document type	String	15
CountryRegionId	Based in country/region	String	10
CPDSource	Check source	Enum
CustInvoiceTableRefRecId	Reference	RecId
DocumentClassificationId	Document class Id	String	15
DocumentDate	Document date	Date
DocumentNum	Document number	String	20
DueDate	Due date	Date
HolderAccountNum	Holder's bank account	String	30
LedgerVoucher	Voucher	String	20
ListField01	Description	String	60
ListField02	Description	String	60
ListField03	Description	String	60
ListField04	Description	String	60
ListField05	Description	String	60
ListField06	Description	String	60
ListField07	Description	String	60
ListField08	Description	String	60
ListField09	Description	String	60
ListField10	Description	String	60
ListFieldCode01	Reference code	String	30
ListFieldCode02	Reference code	String	30
ListFieldCode03	Reference code	String	30
ListFieldCode04	Reference code	String	30
ListFieldCode05	Reference code	String	30
ListFieldCode06	Reference code	String	30
ListFieldCode07	Reference code	String	30
ListFieldCode08	Reference code	String	30
ListFieldCode09	Reference code	String	30
ListFieldCode10	Reference code	String	30
PrintAfterPost	Print after post	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesPointId	Sales point	String	10
SalesPointPrefix	Prefix	String	10
StateDocNum	State identification number	String	30
StateDocTypeId	State document type	String	15
StateId	Jurisdiction registered	String	10
TaxPayerTypeId	Taxpayer type	String	15
WithholdingBaseMST	Taxable amount	Real
WithholdingEffectiveRate	Effective tax rate	Real

PayIntV2EmploymentDetail (Payroll integration v2 employment detail table)

Name	Label	Type	Length
AdjustedWorkerStartDate	Worker's adjusted start date	Date time
BenefitEmploymentStatus	Status	Enum
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EmployerNoticeAmount	Employer quantity	Integer
EmployerUnitOfNotice	Employer unit	Enum
EmploymentCategoryId	Employment category	String	25
EmploymentEndDate	Employment end date	Date time
EmploymentStartDate	Employment start date	Date time
EmploymentType	Worker type	Enum
EmploymentTypeId	Employment type	String	20
LastDateWorked	Worker's last date worked	Date time
LegalEntityId	Company	String	4
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OriginalRecId	OriginalRecId	Big integer
PayFrequency	Payment frequency	RecId
PayFrequencyId	Payment frequency	String	20
PersonnelNumber	Personnel number	String	25
ReasonCodeId	Reason code	String	15
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransitionDate	Termination date	Date time
ValidFrom	Effective	Date time
ValidTo	Expiration	Date time
WorkerNoticeAmount	Worker notice amount	Integer
WorkerStartDate	Worker's start date	Date time
WorkerUnitOfNotice	Worker unit of notice	Enum

PayIntV2HcmEmployeeV2 (Payroll integration v2 employee v2)

Name	Label	Type	Length
AddressBooks	Address books	String	1000
AddressCity	City	String	60
AddressCountryRegionId	Country/region	String	10
AddressCountryRegionISOCode	Country/region ISO	String	2
AddressCounty	County	String	30
AddressDistrictName	District	String	60
AddressLocationId	Location ID	String	40
AddressLocationRoles	Purpose	String	1000
AddressNameDescription	Name or description	String	60
AddressState	State	String	10
AddressStreet	Street	String	250
AddressValidFrom	Effective	Date time
AddressValidTo	Expiration	Date time
AddressZipCode	ZIP/postal code	String	10
AdjustedWorkerStartDate	Worker's adjusted start date	Date time
AllowRehire	Rehire	Enum
AnniversaryDateTime	Anniversary date	Date time
BirthDate	Birth date	Date
CalendarDataAreaId	Company	String	4
CalendarId	Calendar	String	10
CitizenshipCountryRegion	Citizenship country/region	String	50
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DeceasedDate	Deceased date	Date
Dimension	Dimension	RecId
DimensionDisplayValue	Ledger account	String	500
DisabledVerificationDate	Verification date	Date
Education	Education	String	30
ElectronicLocationId	Location ID	String	40
EmployeeDetailsEffective	Effective	Date time
EmployeeDetailsExpiration	Expiration	Date time
EmploymentDetailsEffective	Effective	Date time
EmploymentDetailsExpiration	Expiration	Date time
EmploymentEndDate	Employment end date	Date time
EmploymentId	Employment	String	40
EmploymentLegalEntity	Company	RecId
EmploymentLegalEntityId	Company	String	4
EmploymentNoticeEmployerQuantity	Employer quantity	Integer
EmploymentNoticeEmployerUnit	Employer unit	Enum
EmploymentNoticeWorkerQuantity	Worker notice amount	Integer
EmploymentNoticeWorkerUnit	Worker unit of notice	Enum
EmploymentStartDate	Employment start date	Date time
EthnicOrigin	Ethnic origin	RecId
EthnicOriginId	Ethnic origin	String	15
ExpatriateRulingValidFrom	Expatriate ruling valid from	Date
ExpatriateRulingValidTo	Expatriate ruling valid to	Date
FatherBirthCountryRegion	Father country/region of birth	String	10
FirstName	First name	String	50
Gender	Gender	Enum
IsDisabled	Person with disabilities	Enum
IsDisabledVeteran	Disabled veteran	Enum
IsExpatriateRulingApplicable	Expatriate ruling	Enum
IsFulltimeStudent	Full-time student	Enum
KnownAs	Known as	String	160
LanguageId	Language	String	7
LastDateWorked	Worker's last date worked	Date time
LastName	Last name	String	50
LastNamePrefix	Last name prefix	String	25
Location	Building address	RecId
MaritalStatus	Marital status	Enum
MiddleName	Middle name	String	50
MilitaryServiceEndDate	Military service end date	Date
MilitaryServiceStartDate	Military service start date	Date
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
MotherBirthCountryRegion	Mother country/region of birth	String	10
Name	Name	String	160
NameAlias	Search name	String	20
NameSequenceDisplayAs	Display as	String	20
NameValidFrom	Effective	Date time
NameValidTo	Expiration	Date time
NationalityCountryRegion	Nationality country region	String	10
NativeLanguage	Native language	RecId
NativeLanguageId	Language code	String	15
NumberOfDependents	Number of dependents	Integer
OfficeLocation	Office location	String	255
OfficeLocationId	Location ID	String	40
OriginalHireDateTime	Original hire date	Date time
PartyNumber	Party ID	String	40
PartyType	Record type	String	13
PensionEnrollment	Pension plan	Date time
PensionStart	Start date	Date time
Person	Name	RecId
PersonalSuffix	Affix	String	100
PersonalTitle	Affix	String	100
PersonBirthCity	Birth city	String	60
PersonBirthCountryRegion	Country/region of birth	String	10
PersonDetailsValidFrom	Effective	Date time
PersonDetailsValidTo	Expiration	Date time
PersonnelNumber	Personnel number	String	25
PhoneticFirstName	Phonetic first	String	50
PhoneticLastName	Phonetic last	String	50
PhoneticMiddleName	Phonetic middle	String	50
PrimaryAddressLocation	Location	RecId
PrimaryContactEmail	Contact number/address	String	255
PrimaryContactEmailDescription	Description	String	60
PrimaryContactEmailIsIM	Instant message	Enum
PrimaryContactEmailIsPrivate	Private	Enum
PrimaryContactEmailPurpose	Purpose	String	1000
PrimaryContactFacebook	Contact number/address	String	255
PrimaryContactFacebookDescription	Description	String	60
PrimaryContactFacebookIsPrivate	Private	Enum
PrimaryContactFacebookPurpose	Purpose	String	1000
PrimaryContactFax	Contact number/address	String	255
PrimaryContactFaxDescription	Description	String	60
PrimaryContactFaxExtension	Extension	String	10
PrimaryContactFaxIsPrivate	Private	Enum
PrimaryContactFaxPurpose	Purpose	String	1000
PrimaryContactLinkedIn	Contact number/address	String	255
PrimaryContactLinkedInDescription	Description	String	60
PrimaryContactLinkedInIsPrivate	Private	Enum
PrimaryContactLinkedInPurpose	Purpose	String	1000
PrimaryContactPhone	Contact number/address	String	255
PrimaryContactPhoneDescription	Description	String	60
PrimaryContactPhoneExtension	Extension	String	10
PrimaryContactPhoneIsMobile	Mobile	Enum
PrimaryContactPhoneIsPrivate	Private	Enum
PrimaryContactPhonePurpose	Purpose	String	1000
PrimaryContactTwitter	Contact number/address	String	255
PrimaryContactTwitterDescription	Description	String	60
PrimaryContactTwitterIsPrivate	Private	Enum
PrimaryContactTwitterPurpose	Purpose	String	1000
PrimaryContactURL	Contact number/address	String	255
PrimaryContactURLDescription	Description	String	60
PrimaryContactURLIsPrivate	Private	Enum
PrimaryContactURLPurpose	Purpose	String	1000
ProbationPeriod	Probation period	Date time
ProfessionalSuffix	Professional suffix	String	100
ProfessionalTitle	Professional title	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RegulatoryEstablishment	Regulatory establishment	RecId
RegulatoryEstablishmentId	Regulatory establishment	String	30
RelocationReimbursement	Relocation reimbursement	Real
SeniorityDate	Seniority date	Date time
StartDate	Worker's start date	Date time
SummaryValidFrom	Effective	Date time
SummaryValidTo	Expiration	Date time
TerminationDate	Termination date	Date time
TerminationReason	Reason code	RecId
TerminationReasonCodeId	Reason code	String	15
Title	Title	RecId
TitleId	Title	String	65
VeteranStatus	Veteran status	RecId
VeteranStatusId	Veteran status	String	15
WorksFromHome	Works from home	Enum

PayIntV2HcmWorkerBase (Payroll integration v2 worker base)

Name	Label	Type	Length
AllowRehire	Rehire	Enum
BirthDate	Birth date	Date
CitizenshipCountryRegion	Citizenship country/region	String	50
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DeceasedDate	Deceased date	Date
DisabledVerificationDate	Verification date	Date
Education	Education	String	30
ElectronicLocationId	Location ID	String	40
EthnicOrigin	Ethnic origin	RecId
EthnicOriginId	Ethnic origin	String	15
FatherBirthCountryRegion	Father country/region of birth	String	10
FirstName	First name	String	50
Gender	Gender	Enum
IsDisabled	Person with disabilities	Enum
IsFulltimeStudent	Full-time student	Enum
KnownAs	Known as	String	160
LanguageId	Language	String	7
LastName	Last name	String	50
LastNamePrefix	Last name prefix	String	25
MiddleName	Middle name	String	50
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
MotherBirthCountryRegion	Mother country/region of birth	String	10
Name	Name	String	160
NameAlias	Search name	String	20
NameSequenceDisplayAs	Display as	String	20
NameValidFrom	Effective	Date time
NameValidTo	Expiration	Date time
NationalityCountryRegion	Nationality country region	String	10
NativeLanguage	Native language	RecId
NativeLanguageId	Language code	String	15
OriginalRecId	OriginalRecId	Big integer
PartyNumber	Party ID	String	40
PartyType	Record type	String	13
Person	Name	RecId
PersonalSuffix	Affix	String	100
PersonalTitle	Affix	String	100
PersonBirthCity	Birth city	String	60
PersonBirthCountryRegion	Country/region of birth	String	10
PersonnelNumber	Personnel number	String	25
PhoneticFirstName	Phonetic first	String	50
PhoneticLastName	Phonetic last	String	50
PhoneticMiddleName	Phonetic middle	String	50
PrimaryContactEmail	Contact number/address	String	255
ProfessionalSuffix	Professional suffix	String	100
ProfessionalTitle	Professional title	String	100
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PDSCustInvoiceTransPricingCalculationHistory (PDSCustInvoiceTransPricingCalculation history data)

Name	Label	Type
createdDateTime	Created date and time	Date time
CustInvoiceTrans	Reference	RecId
modifiedDateTime	Modified date and time	Date time
OriginalSalesPrice	Sales price	Real
PriceCalculation	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum

PdsRebateCustInvoiceTransHistory (PdsRebateCustInvoiceTrans history data)

Name	Label	Type	Length
CustInvoiceTransRecId	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesLineCreatedDate	Creation date	Date
SalesLinePdsExcludeFromRebate	Exclude from rebate	Enum
SalesLinePdsItemRebateGroupId	Item rebate group	String	10
SalesLineReceiptDateRequested	Requested receipt date	Date
SalesLineShippingDateRequested	Requested ship date	Date
SalesTablePdsCustRebateGroupId	Customer rebate group	String	20
SalesTablePdsRebateProgramTMAGroup	Customer TMA group	String	10
SYSDATASTATECODE	SYSDATASTATECODE	Enum

PurchCopilotAgentResultEmail (Agent created emails)

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

PurchCopilotInboundEmailMappingOrder (Mapped order data from inbound email)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
MatchingOrderRecId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PurchOrderId	PurchOrderId	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StagingEmailAttachmentRecId	Reference	RecId
StagingEmailRecId	Reference	RecId

PurchCopilotInboundEmailMappingOrderLine (Mapped order line data from inbound email)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Item	Item	Bin/Memo/Container
MappingJson	Mapping Json	Bin/Memo/Container
MappingOrderRecId	Reference	RecId
MatchingOrderLineRecId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Qty	Qty	Bin/Memo/Container
ReceiptDate	ReceiptDate	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShipDate	ShipDate	Bin/Memo/Container
UnitOfMeasure	UnitOfMeasure	Bin/Memo/Container

PurchCopilotInboundEmailMatching (Email matching)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EmailType	Email type	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StagingEmailRecId	Reference	RecId
State	State	Enum
VendorAccountNum	Vendor account	String	20

PurchCopilotInboundEmailMatchingOrder (Matching order)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
MatchingRecId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderIntent	Email order intent	Enum
PurchOrderId	Purchase order	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

PurchCopilotInboundEmailMatchingOrderLine (Matching order line)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ItemId	Item number	String	20
MappingItemId	MappingItemId	Bin/Memo/Container
MappingPurchUnit	MappingPurchUnit	Bin/Memo/Container
MappingQty	MappingQty	Bin/Memo/Container
MappingShipDate	MappingShipDate	Bin/Memo/Container
MatchingOrderRecId	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PurchLineRecId	Reference	RecId
PurchUnit	Unit	String	10
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ShipDate	Confirmed ship date	Date
Status	Status	Enum

PurchCopilotPurchaseFollowupResultPurchLineLink (Agent result - Purchase order relations)

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

ReconciliationAutomationFiscalPeriodData (Reconciliation automation framework table)

Name	Label	Type	Length
Company	Company	String	4
EndDate	End date	Date
FiscalCalendarPeriod	Reference	RecId
Ledger	Ledger	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
NumberOfLedgerTransactionsInFiscalPeriod	NumberOfLedgerTransactionsInFiscalPeriod	Big integer
NumberOfSubledgerTransactionsInFiscalPeriod	NumberOfSubledgerTransactionsInFiscalPeriod	Big integer
RecId	Record-ID	RecId
ReconciliationModule	Reconciliation automation module	Enum
ReconciliationProcessStatus	Reconciliation automation period execution status	Enum
recVersion	Record Version	Integer
StartDate	Start date	Date

ReconciliationAutomationLedgerMainAccountMapping (Reconciliation automation framework table)

Name	Label	Type	Length
Company	Company	String	4
Ledger	Ledger	RecId
MainAccount	Main account	RecId
MainAccountDerivationSource	Reconciliation automation main account source	Enum
MainAccountSourceTableId	Table ID	Integer
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

ReconciliationAutomationLinkTransactionDetails (Reconciliation automation link transaction details)

Name	Label	Type
createdDateTime	Created date and time	Date time
LinkAmountInAccountingCurrency	Link amount in accounting currency	Real
LinkAmountInReportingCurrency	Link amount in reporting currency	Real
LinkSourceTransaction	Link source transaction	RecId
LinkTargetTransaction	Link target transaction	RecId
RecId	Record-ID	RecId
ReconciliationAutomationUnreconciledLinkTransactionType	Unreconciled transaction link type	Enum
ReconciliationAutomationVoucherExceptionLog	Reconciliation automation voucher exception log	RecId
recVersion	Record Version	Integer

ReconciliationAutomationParameters (Reconciliation automation framework table)

Name	Label	Type	Length
Company	Company	String	4
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EnableReconciliationAutomation	EnableReconciliationAutomation	Enum
FiscalCalendar	Reference	RecId
Ledger	Ledger	Big integer
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

ReconciliationAutomationVoucherExceptionLog (Reconciliation automation framework table)

Name	Label	Type	Length
ActionReasonComment	Description	String	512
AgentGeneratedSummaryForEvent	Description	String	512
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
ReconciliationAgentSuggestion	ReconciliationAgentSuggestion	Enum
ReconciliationAutomationEventType	Reconciliation automation event type	Enum
ReconciliationAutomationEventTypeValue	Reconciliation automation event value	Enum
ReconciliationAutomationVoucherSummary	Reference	RecId
recVersion	Record Version	Integer

ReconciliationAutomationVoucherSubledgerDetails (Reconciliation automation framework table)

Name	Label	Type	Length
AccountId	Account number	String	20
AccountName	Name	String	160
RecId	Record-ID	RecId
ReconciliationAutomationVoucherSummary	Reference	RecId
recVersion	Record Version	Integer
SubledgerAmountInAccountingCurrency	Amount	Real
SubledgerAmountInReportingCurrency	Amount in reporting currency	Real

ReconciliationAutomationVoucherSummary (Reconciliation automation framework table)

Name	Label	Type	Length
AccountingCurrency	Currency	String	3
AccountingDate	Date	Date
Company	Company	String	4
FiscalCalendarPeriod	Reference	RecId
IsCorrection	IsCorrection	Enum
Ledger	Ledger	RecId
LedgerAccountingCurrencyAmount	Balance 2	Real
LedgerJournalId	Journal batch number	String	20
LedgerReportingCurrencyAmount	Amount in reporting currency	Real
MainAccountId	Main account	String	20
MainAccountName	Account name	String	60
RecId	Record-ID	RecId
ReconciliationAutomationExceptionCategory	Reconciliation automation event value	Enum
ReconciliationAutomationVoucherStatus	ReconciliationAutomationVoucherStatus	Enum
ReconciliationModule	Reconciliation automation module	Enum
recVersion	Record Version	Integer
ReportingCurrency	Currency	String	3
SubledgerAccountingCurrencyAmount	Amount	Real
SubledgerReportingCurrencyAmount	Amount in reporting currency	Real
Voucher	Voucher	String	20

RetailCDXSeedDataHistory (RetailCDXSeedDataHistory)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
IsCore	IsCore	Enum
IsExtension	IsExtension	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SchemaName	Name	String	40
SchemaType	Schema type	Enum
SeedDataXML	SeedDataXML	String	10

RetailCDXTableDistributionHistory (RetailCDXTableDistributionHistory)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SchemaName	Name	String	40
SchemaType	Schema type	Enum
TableDistributionXML	Table distribution	Bin/Memo/Container

RetailCustInvoiceJourTableHistory (RetailCustInvoiceJourTable history data)

Name	Label	Type	Length
CustInvoiceJour	Reference	RecId
IsEInvocieGeneratedFromPOS_SA	IsEInvocieGeneratedFromPOS_SA	Enum
OMInternalOrganization	Reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailChannel	Reference	RecId
RetailHourOfDay	Reference	RecId
RetailStatementId	Statement number	String	20
RetailStoreId	Store number	String	10
RetailTerminalId	Register number	String	10

SCMCopilotAgent (Agent)

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

SCMCopilotAgentInboundEmailAttachmentStaging (Incoming email attachments)

Name	Label	Type	Length
AttachmentId	Attachment Id	String	152
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FileName	File name	String	259
MappingJson	Mapping Json	Bin/Memo/Container
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StagingEmailRecId	Reference	RecId

SCMCopilotAgentInboundEmailStaging (Incoming emails)

Name	Label	Type	Length
Body	Email body	Bin/Memo/Container
ConversationId	Conversation Id	String	152
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EmailId	Message Id	String	320
LatestMessageBody	Email body	Bin/Memo/Container
MappingJson	Mapping Json	Bin/Memo/Container
MessageId	Message Id	String	320
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplyTo	Message Id	String	320
Sender	Sender	String	80
Status	Status	Enum
Subject	Subject	String	200
Timestamp	Timestamp	Date time
WebLink	Web Link	Bin/Memo/Container

SCMCopilotAgentResult (Result)

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

SCMCopilotInboundMatchingField (Contains information of the fields that will participate in matching logic.)

Name	Label	Type	Length
AIFieldDescription	Description	String	255
AIFieldName	Name	String	60
BackingEntityFieldName	Name	String	60
BackingEntityTableName	Table name	String	81
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

SCMCopilotInboundMatchingFieldValue (Contains mapping of field ids with field values, for all the fields that participate in inbound matching process.)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
MappingFieldValue	MappingFieldValue	Bin/Memo/Container
MatchedFieldValue	MatchedFieldValue	Bin/Memo/Container
MatchingField	Reference	RecId
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefMatchingEntityRecId	Reference	RecId
RefMatchingTableName	Table name	String	81

SourceDocumentCleanupForSalesOrderInvoiceRemoveQueue (The table is used in the SourceDocumentCleanupForSalesOrderInvoice data maintenance job. During the activity run, the table will have the recIds of SDH inserted, which potentially would be deleted by the job itself. The table helps to avoid performin)

Name	Label	Type
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeaderRecId	Reference	RecId

SourceDocumentCleanupForSalesOrderPackingSlipRemoveQueue (The table is used in the SourceDocumentCleanupForSalesOrderPackingSlip data maintenance job. During the activity run, the table will have the recIds of SDH inserted, which potentially would be deleted by the job itself. The table helps to avoid perfo)

Name	Label	Type
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceDocumentHeaderRecId	Reference	RecId

SubledgerGLSettlementQueue (SubledgerGLSettlementQueue)

Name	Label	Type
createdDateTime	Created date and time	Date time
IsReversal	IsReversal	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SettlementDate	Date	Date
SettlementGroupTableId	Reference table ID	Integer
SettleType	SettleType	Enum
SkipFCR	SkipFCR	Enum
SubledgerSettlementGroup	Reference	RecId

SubledgerGLSettlementUnsettledTrans (SubledgerGLSettlementUnsettledTrans)

Name	Label	Type
ExchAdjAmountMST	Amount	Real
ExchAdjAmountReporting	Amount in reporting currency	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	RefRecId	Big integer
RefTableId	Reference table ID	Integer
SettleAmountCur	Amount in transaction currency	Real
SettleAmountMST	Amount	Real
SettleAmountReporting	Amount in reporting currency	Real
SubledgerGLSettlementQueue	Reference	RecId

TaxIntegrationTaxFeatureSetupMigrationTaxCodeMap (Tax code mapping during tax feature migration)

Name	Label	Type	Length
FromTaxCode	Sales tax code	String	10
FromTaxGroup	Sales tax group	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxCode	Sales tax code	String	10
TaxFeatureSetupVersion	Feature setup	RecId

TaxTransJurisdictionDetail (Posted sales tax detail)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FlexibleDateField[01]	Flexible date 1	Date
FlexibleDateField[02]	Flexible date 2	Date
FlexibleDateField[03]	Flexible date 3	Date
FlexibleDateField[04]	Flexible date 4	Date
FlexibleDateField[05]	Flexible date 5	Date
FlexibleDateField[06]	Flexible date 6	Date
FlexibleDateField[07]	Flexible date 7	Date
FlexibleDateField[08]	Flexible date 8	Date
FlexibleDateField[09]	Flexible date 9	Date
FlexibleDateField[10]	Flexible date 10	Date
FlexibleIntegerField[01]	Flexible integer 1	Integer
FlexibleIntegerField[02]	Flexible integer 2	Integer
FlexibleIntegerField[03]	Flexible integer 3	Integer
FlexibleIntegerField[04]	Flexible integer 4	Integer
FlexibleIntegerField[05]	Flexible integer 5	Integer
FlexibleIntegerField[06]	Flexible integer 6	Integer
FlexibleIntegerField[07]	Flexible integer 7	Integer
FlexibleIntegerField[08]	Flexible integer 8	Integer
FlexibleIntegerField[09]	Flexible integer 9	Integer
FlexibleIntegerField[10]	Flexible integer 10	Integer
FlexibleRealField[01]	Flexible real 1	Real
FlexibleRealField[02]	Flexible real 2	Real
FlexibleRealField[03]	Flexible real 3	Real
FlexibleRealField[04]	Flexible real 4	Real
FlexibleRealField[05]	Flexible real 5	Real
FlexibleRealField[06]	Flexible real 6	Real
FlexibleRealField[07]	Flexible real 7	Real
FlexibleRealField[08]	Flexible real 8	Real
FlexibleRealField[09]	Flexible real 9	Real
FlexibleRealField[10]	Flexible real 10	Real
FlexibleStringField[01]	Flexible string 1	String	1000
FlexibleStringField[02]	Flexible string 2	String	1000
FlexibleStringField[03]	Flexible string 3	String	1000
FlexibleStringField[04]	Flexible string 4	String	1000
FlexibleStringField[05]	Flexible string 5	String	1000
FlexibleStringField[06]	Flexible string 6	String	1000
FlexibleStringField[07]	Flexible string 7	String	1000
FlexibleStringField[08]	Flexible string 8	String	1000
FlexibleStringField[09]	Flexible string 9	String	1000
FlexibleStringField[10]	Flexible string 10	String	1000
Jurisdiction	Jurisdiction	String	100
JurisdictionLevel	Jurisdiction Level	String	100
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SYSDATASTATECODE	SYSDATASTATECODE	Enum
TaxAmount	Sales tax amount in accounting currency	Real
TaxCode	Sales tax code	String	10
TaxTrans	Tax transaction record ID	RecId
TaxValue	Value	Real

TaxUncommittedJurisdictionDetail (Uncommitted sales tax detail)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FlexibleDateField[01]	Flexible date 1	Date
FlexibleDateField[02]	Flexible date 2	Date
FlexibleDateField[03]	Flexible date 3	Date
FlexibleDateField[04]	Flexible date 4	Date
FlexibleDateField[05]	Flexible date 5	Date
FlexibleDateField[06]	Flexible date 6	Date
FlexibleDateField[07]	Flexible date 7	Date
FlexibleDateField[08]	Flexible date 8	Date
FlexibleDateField[09]	Flexible date 9	Date
FlexibleDateField[10]	Flexible date 10	Date
FlexibleIntegerField[01]	Flexible integer 1	Integer
FlexibleIntegerField[02]	Flexible integer 2	Integer
FlexibleIntegerField[03]	Flexible integer 3	Integer
FlexibleIntegerField[04]	Flexible integer 4	Integer
FlexibleIntegerField[05]	Flexible integer 5	Integer
FlexibleIntegerField[06]	Flexible integer 6	Integer
FlexibleIntegerField[07]	Flexible integer 7	Integer
FlexibleIntegerField[08]	Flexible integer 8	Integer
FlexibleIntegerField[09]	Flexible integer 9	Integer
FlexibleIntegerField[10]	Flexible integer 10	Integer
FlexibleRealField[01]	Flexible real 1	Real
FlexibleRealField[02]	Flexible real 2	Real
FlexibleRealField[03]	Flexible real 3	Real
FlexibleRealField[04]	Flexible real 4	Real
FlexibleRealField[05]	Flexible real 5	Real
FlexibleRealField[06]	Flexible real 6	Real
FlexibleRealField[07]	Flexible real 7	Real
FlexibleRealField[08]	Flexible real 8	Real
FlexibleRealField[09]	Flexible real 9	Real
FlexibleRealField[10]	Flexible real 10	Real
FlexibleStringField[01]	Flexible string 1	String	1000
FlexibleStringField[02]	Flexible string 2	String	1000
FlexibleStringField[03]	Flexible string 3	String	1000
FlexibleStringField[04]	Flexible string 4	String	1000
FlexibleStringField[05]	Flexible string 5	String	1000
FlexibleStringField[06]	Flexible string 6	String	1000
FlexibleStringField[07]	Flexible string 7	String	1000
FlexibleStringField[08]	Flexible string 8	String	1000
FlexibleStringField[09]	Flexible string 9	String	1000
FlexibleStringField[10]	Flexible string 10	String	1000
HeadingRecId	Reference	RecId
HeadingTableId	Reference table ID	Integer
InvoiceId	Invoice	String	50
IsDeleted	Deleted	Enum
Jurisdiction	Jurisdiction	String	100
JurisdictionLevel	Jurisdiction Level	String	100
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceTableId	Reference table ID	Integer
TaxAmount	Sales tax amount	Real
TaxCode	Sales tax code	String	10
TaxValue	Value	Real
Voucher	Voucher	String	20

TrvExpenseCopilotConfiguration (TrvExpenseCopilotConfiguration)

Name	Label	Type	Length
EnableCopilotForExpense	EnableCopilotForExpense	Enum
KeyId	ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportDays	Days on which expense copilot generates Expense Report	String	200
ReportFrequency	Frequency (Daily/Weekly) in which expense copilot generates expense report	Enum
ReportGroupBy	Grouping of Expense Lines(Project/Trip) into a report by expense Agent	Enum
ReportTime	Time at which Expense Agent generates Expense Report	Time

TrvExpenseCopilotConfigurationStaging (Configuration for Expense Agent)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
EnableCopilotForExpense	EnableCopilotForExpense	Enum
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReportDays	Days on which expense copilot generates Expense Report	String	200
ReportFrequency	Frequency (Daily/Weekly) in which expense copilot generates expense report	Enum
ReportGroupBy	Grouping of Expense Lines(Project/Trip) into a report by expense Agent	Enum
ReportTime	Time at which Expense Agent generates Expense Report	Time
TransferStatus	Staging to target status	Enum

TrvExpenseCopilotExecutionDetails (TrvExpenseCopilotExecutionDetails)

Name	Label	Type	Length
executedOn	executedOn	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
workerId	workerId	Big integer

UdsConfigTable (UdsConfigTable)

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

VendAccountNumObjectReferences (Vendor account object references)

Name	Label	Type	Length
CacheType	Record cache type	String	81
DataAreaIdFieldNames	Data area backed field names	String	500
HasTableBeenRemoved	Table remove	Enum
ImpliedDataAreaStripingField	Field name	String	81
IsSaveDataPerCompany	Save data per company	Enum
IsValidTimeState	Is valid time state table	Enum
LedgerFieldNames	Ledger field names	String	500
LegalEntityFieldNames	Legal entity backed field names	String	500
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceFieldName	Reference field name	String	81
ReferenceFieldNum	Reference field number	Integer
ReferenceMetadataTableName	Metadata table name	String	81
ReferenceTableName	Reference table name	String	81
ReferenceTableNum	Reference table number	Integer
SkipReferences	Skip references	Enum
TableGroupType	Table group	String	81

VendAccountNumRenameDataMaintenance (Vendor account rename data maintenance)

Name	Label	Type	Length
Description	Description	String	255
ID	ID	Integer
NewAccountNum	New vendor account	String	20
OldAccountNum	Old vendor account	String	20
PrimaryLedger	Ledger	RecId
ProcessEndDateTime	Process end time	Date time
ProcessStartDateTime	Process start time	Date time
ProcessStatus	Process status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RenamedDateTime	Rename trigger time	Date time

VendAccountNumRenameDataMaintenanceTracking (Vendor account data maintenance tracking table)

Name	Label	Type	Length
OutOfSyncRecordCount	Out of sync record	Integer
ProcessEndDateTime	Process end time	Date time
ProcessStartDateTime	Process start time	Date time
ProcessStatus	Process status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceFieldName	Reference field name	String	81
ReferenceFieldNum	Reference field number	Integer
ReferenceTableName	Reference table name	String	81
ReferenceTableNum	Reference table number	Integer
Selected	Select	Enum
VendAccountNumRenameDataMaintenance	Reference	RecId

VendInvoiceTotalLastValue (VendInvoiceTotalLastValue)

Name	Label	Type	Length
InvoiceTotal	Amount in transaction currency	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TableRefId	Line reference	String	20

WHSGS1PolicyLineIdentifier (Additional application identifiers for policy line)

Name	Label	Type	Length
Identifier	Application identifier	String	10
MDIdentifier	Field	String	32
PolicyName	Policy name	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer

WHSGS1PolicyLineIdentifierStaging (Additional application identifiers for policy line)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
Identifier	Application identifier	String	10
IsSelected	Select	Enum
MDIdentifier	Field	String	32
PolicyName	Policy name	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

Tables with new fields

AssetLeasePostJournalBatchErrorLog Batch error log)

Name	Label	Type	Length
BatchJobId	Batch job ID	Big integer
Company	Company	String	4

BankReconciliationMatchRule_PostingInfo BankReconciliationMatchRule_PostingInfo)

Name	Label	Type	Length
PostingProfile	Posting profile	String	10
Prepayment	Prepayment journal voucher	Enum

BankStatementLinePaymentInformation BankStatementLinePaymentInformation)

Name	Label	Type	Length
PostingProfile	Posting profile	String	10
Prepayment	Prepayment journal voucher	Enum

BrazilParameters Brazilian parameters)

Name	Label	Type	Length
ICMSPresumedCredit	ICMS presumed credit	Enum

CLMIntegrationExternalNavigationLink Contract management external navigation link)

Name	Label	Type	Length
Action	Action	Enum

CustAccountNumRenameDataMaintenance Customer account rename data maintenance)

Name	Label	Type	Length
CustTableRecId	Reference	RecId

CustInvoiceJour Customer invoice journal)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_BR Customer invoice journal information for Brazil)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_FR Customer invoice journal information for France)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_IN Customer invoice journal)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_Intrastat Customer invoice journal information for Intrastat)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_Officials Customer invoice journal information for Officials)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_PL Customer invoice journal information for Poland)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_RU Customer invoice journal information for Russia)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJour_W Customer invoice journal)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourAdjustment Customer invoice journal adjustment)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourCorrectionType_RU Correction types for customer invoice journals)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourCorrLink_RU References to corrected customer invoice journals)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourExtension_CN Customer Invoice Journal extension for China)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourExtensionTH Customer invoice journal for Thailand)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourPrint CustInvoiceJourPrint)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceJourSymbol Customer invoice journal symbols)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLine Customer free text invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLine_W Customer free text invoice line information for other country contexts)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLineAsset Asset customer free text invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLineCorrLink_RU References between corrected customer invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLineInterProj Intercompany free text invoice lines for project)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceLineTaxExtensionIN Free text Invoice line tax extension)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTable Customer free text invoice)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTable_W Customer free tax invoice for other country contexts)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTableCalcTotals Free text invoice calculated totals)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTableExtension_CN Customer Invoice Table extension for China)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTableExtensionTH Customer free text invoice for Thailand)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTableSymbol Customer free text invoice symbols)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans Customer invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans_BR Customer invoice line information for Brazil)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans_IN Customer invoice line information for India)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans_Intrastat Customer invoice line information for Intrastat)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans_RU Customer invoice line information for Russia)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTrans_W Customer invoice line information for other country contexts)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTransAsset Asset customer invoice line)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTransCorrLink_RU References between corrected customer invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustInvoiceTransTaxExtensionIN Cust Invoice trans tax extension)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

CustParameters Customer parameters)

Name	Label	Type
CheckInvoice	Check the invoice number used	Enum
EnableDelayJournalizationForFreeTextInvoicePosting	Enhanced performance for free text invoice posting	Enum
PrePopulatedInvoiceNumbers	PrePopulatedInvoiceNumbers	Enum

CustVendPaymProposalLine Payment proposal line)

Name	Label	Type	Length
BridgingBankAccount	Bank account	String	10

DimensionAttribute Dimension)

Name	Label	Type	Length
BackingEntityPerCompanyType	Backing entity per company type	Enum

DMFSqlHints DMFSqlHints)

Name	Label	Type	Length
EntityOrTable	Entity	String	300

DocuRef Document references)

Name	Label	Type	Length
isEnabledForVirtualEntitySync	is Enabled Sync for Virtual Entity	Enum

EntAssetRoundTable Maintenance rounds)

Name	Label	Type	Length
RoundActive	Active	Enum

ERFeatureAppSetupBusinessDocumentTypeTable Business document types)

Name	Label	Type	Length
LegalEntityId	Company	String	4

ERFeatureTable Features)

Name	Label	Type	Length
WikiLink	Internet address	String	255

ERFeatureVersionParameter Feature version feature parameters table)

Name	Label	Type	Length
IsLookup	IsLookup	Enum

EximCustInvoiceTrans_IN Customer invoice lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

FBParametersPerState_BR Fiscal books parameters per state)

Name	Label	Type	Length
PresumedCredit	Presumed credit	Enum

FreeTextInvoiceStaging Customer free text invoice)

Name	Label	Type	Length
HeaderFinTagDisplayValue	Financial tag display value	Bin/Memo/Container
LineFinTagDisplayValue	Financial tag display value	Bin/Memo/Container

GUPItemBasePrice Price)

Name	Label	Type	Length
BasePriceCreatedDateTime	BasePriceCreatedDateTime	Date time

GUPItemBasePriceDelta Price)

Name	Label	Type	Length
BasePriceCreatedDateTime	BasePriceCreatedDateTime	Date time

GUPItemBasePriceValid Price)

Name	Label	Type	Length
BasePriceCreatedDateTime	BasePriceCreatedDateTime	Date time

InventSettlement Inventory settlement)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

InventTransPosting Inventory transaction posting)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LeaveAbsenceParameters Leave and absence parameters)

Name	Label	Type	Length
DisableBuySellLeaveRequest	Disable buy and sell leave	Enum

LedgerJournalTable Ledger journal table)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTable_W Ledger journal table information for other country contexts)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTrans Journal lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTrans_Asset Asset journal lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTrans_Project Project journal lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTrans_W Order line information for other country contexts)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTransAccrual Ledger accruals)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerJournalTransAccrualTrans Ledger accrual transactions)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LedgerParameters Ledger parameters)

Name	Label	Type
EnableLedgerSettlementPartialSettlement	Partial ledger settlements	Enum
EnableLedgerSettlementSubledgerSettlement	Subledger to ledger auto settlement	Enum
PSNCashControlEnable	Enable cash control	Enum

LedgerTransSettlement Ledger settlements)

Name	Label	Type	Length
ExchAdjAccountingCurrencyAmount	Exchange rate adjustment amount	Real
ExchAdjReportingCurrencyAmount	Exchange rate adjustment amount in reporting currency	Real
IsReversed	IsReversed	Enum
OriginalSettleId	Settlement ID	String	20
RefTransRecId	Reference	RecId
SettleAccountingCurrencyAmount	Settled amount in accounting currency	Real
SettlementGroup	Integer	Big integer
SettlementTableId	Reference table ID	Integer
SettleReportingCurrencyAmount	Settled amount in reporting currency	Real
SettleTransactionCurrencyAmount	Settled amount in transaction currency	Real
UserId	User ID	String	20

LedgerTransSettlementHistory LedgerTransSettlement history data.)

Name	Label	Type	Length
ExchAdjAccountingCurrencyAmount	Exchange rate adjustment amount	Real
ExchAdjReportingCurrencyAmount	Exchange rate adjustment amount in reporting currency	Real
IsReversed	IsReversed	Enum
OriginalSettleId	Settlement ID	String	20
RefTransRecId	Reference	RecId
SettleAccountingCurrencyAmount	Settled amount in accounting currency	Real
SettlementGroup	Integer	Big integer
SettlementTableId	Reference table ID	Integer
SettleReportingCurrencyAmount	Settled amount in reporting currency	Real
SettleTransactionCurrencyAmount	Settled amount in transaction currency	Real
UserId	User ID	String	20

LedgerTrialBalanceFiscalYearSnapshotDataStaging Transaction table for trial balance snapshot data)

Name	Label	Type	Length
EndingBalance	Closing balance	Real

LTMCustInvoiceJour Customer invoice journal)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

LTMCustInvoiceTable Customer invoice table)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

MainAccount Main account)

Name	Label	Type	Length
NatureCode_BR	Nature code	String	2

MainAccountStaging Main account)

Name	Label	Type	Length
NatureCode_BR	Nature code	String	10

PayIntV1BankAccountDisbursement Payroll integration v1 bank account disbursement table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
InPrenoteStatus	InPrenoteStatus	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1EmploymentDetail Payroll integration v1 employment detail table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1HcmEmploymentTerm Payroll integration hcm employment term)

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

PayIntV1HcmEmploymentV2 Employment)

Name	Label	Type	Length
CalendarId	Calendar	String	10
CalendarLegalEntityId	Company	String	4

PayIntV1HcmPosition Payroll integration v1 hcm position table)

Name	Label	Type	Length
AreEarningsGeneratedFromSchedule	AreEarningsGeneratedFromSchedule	Enum
BenefitId	Benefit ID	String	20
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DefaultEarningCodeId	Earning code	String	50
InsuranceBenefit	Benefit	RecId
IsSalaryGenerated	IsSalaryGenerated	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PaidBy	Legal entity	RecId
PayPeriodOvertimeHours	Hours	Real
Schedule	Calendar	String	10
ScheduleLegalEntity	Company	String	4

PayIntV1HcmPositionDefaultDimension Position default dimension)

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

PayIntV1HcmPositionWorkerAssignment Payroll integration v1 position worker assignment)

Name	Label	Type
Position	Position	RecId
ReasonCode	Reason code	RecId
Worker	Worker	RecId

PayIntV1HcmVariableCompensationAward Payroll integration variable compensation enrollment)

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

PayIntV1HcmVariableCompensationEnrollment Payroll integration variable compensation enrollment)

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

PayIntV1HcmWorkerPostalAddress Payroll integration v1 worker postal address)

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

PayIntV1OMLegal Payroll integration v1 legal entities table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
ImportVATNum	Tax exempt number	String	20
LocalizationCountryRegionCode	Localized functionality region	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
ProfitMarginScheme	ProfitMarginScheme	Enum
VATNum	Tax exempt number	String	20
VATOnCustomerBehalf	VATOnCustomerBehalf	Enum
VATRefund	VATRefund	Enum

PayIntV1PayrollEmployee Payroll integration v1 payroll employee table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
EmploymentId	Employment	String	40
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1PayrollPositionDetails Payroll integration v1 payroll position details)

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

PayIntV1PayrollPositionJob Payroll position job)

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

PayIntV1PayrollWorkerCurrentAddress Payroll integration v1 payroll worker current address)

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

PayIntV1PositionUnionAgreement Payroll integration v1 position union agreement table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1Worker Payroll integration v1 worker table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1WorkerBankAccount Payroll integration v1 worker bank account table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PayIntV1WorkerContact Payroll integration v1 worker contact table)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time

PDSCustInvoiceTransPricingCalculation Sales invoice information for potency)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

PdsRebateCustInvoiceTrans Customer invoice rebate lines)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

PdsRebateParameters Rebate module parameters)

Name	Label	Type	Length
PdsRebateSummarizeMultipleAccounts	Allow credit notes to include bill-back rebates for multiple accounts	Enum

PmfFormulaLineV2Staging Formula lines V2)

Name	Label	Type	Length
MaterialOverpickPercentage	Material over picking (%)	Real

ProdAsBuiltBOMComponentLotAssociation Tracked component lot associations)

Name	Label	Type	Length
IsFullReset	Is full reset	Enum

ProdAsBuiltBOMProductLotAssociation Tracked product lot associations)

Name	Label	Type	Length
IsFullReset	Is full reset	Enum

ProdBatchOrderFormulaLineStaging Batch order formula lines)

Name	Label	Type	Length
MaterialOverpickPercentage	Material over picking (%)	Real

PSAProjInvoiceHeaderTmp Project invoice)

Name	Label	Type	Length
QRCode_W	Bitmap	Bin/Memo/Container

PurchParameters Purchase parameters)

Name	Label	Type	Length
IntercompanyUseNotActiveRelation	Allow inactive intercompany relationships	Enum
PurchLineDefaultAddressFromHeader	Always default line delivery address from the header	Enum

PurchProcurementDocumentEntryPolicyStaging Procurement type document entry policies)

Name	Label	Type	Length
ShouldPurchLineDefaultAddressFromHeader	Always default line delivery address from the header	Enum

RetailCustInvoiceJourTable Retail customer invoice journal)

Name	Label	Type	Length
SYSDATASTATECODE	SYSDATASTATECODE	Enum

RetailPricingSimulatorLineDiscount Periodic discount)

Name	Label	Type	Length
CalculatedPricingPriorityNumber	Calculated pricing priority	Integer

RetailTransactionDiscountTrans Discount transactions)

Name	Label	Type	Length
CalculatedPricingPriorityNumber	Calculated pricing priority	Integer
EffectivePercentage	Discount percentage	Real

RetailTransactionPriceTrans Price transaction)

Name	Label	Type	Length
CalculatedPricingPriorityNumber	Calculated pricing priority	Integer

SalesOrderLineD365SalesStaging Dynamics 365 Sales order lines)

Name	Label	Type	Length
DefaultLineNumberFromLineCreationSequenceNumber	Default line number from line creation sequence number	Enum

SalesOrderLineV3Staging Sales order lines V3)

Name	Label	Type	Length
DefaultLineNumberFromLineCreationSequenceNumber	Default line number from line creation sequence number	Enum

SalesParameters Sales parameters)

Name	Label	Type	Length
SalesOrderLineDateFieldValidation	Validate sales order line ship dates	Enum

SalesRebateParametersStaging Rebate module parameters)

Name	Label	Type	Length
PdsRebateSummarizeMultipleAccounts	Allow credit notes to include bill-back rebates for multiple accounts	Enum

SourceDocumentParametersGlobal This table contains a single row. Inside this row, global settings for the SourceDocument framework are stored.)

Name	Label	Type
ReconciliationAutomationNumberOfParallelTask	ReconciliationAutomationNumberOfParallelTask	Integer
ReconciliationAutomationStartDate	Start date	Date
SourceDocumentCleanupForSalesOrderInvoiceStartScanningDate	Start date	Date
SourceDocumentCleanupForSalesOrderPackingSlipStartScanningDate	Start date	Date

SubBillSalesLine Subscription billing sales line)

Name	Label	Type	Length
DiscountAmount	Total discount amount	Real

SubBillSalesLineConsolidated Subscription billing sales line consolidated)

Name	Label	Type	Length
DiscountAmount	Total discount amount	Real

SubBillTermScheduleLineAudit Subscription billing termination schedule line audit)

Name	Label	Type	Length
DiscountAmount	Total discount amount	Real

SysIntParameters Integration Parameters)

Name	Label	Type	Length
CaptureDMFErrors	DMF Errors	Enum

TaxIntegrationTaxServiceParameters Tax Calculation Parameter)

Name	Label	Type	Length
EnableTaxCodeLevelRounding	Enable tax code level rounding	Enum

TaxParameters Sales tax parameters)

Name	Label	Type	Length
SAFTJPKKRERFormatMapping_PL	SAF Accounting Books Income Tax	Big integer

TaxServiceTaxCodeTable Tax calculation tax code table)

Name	Label	Type
RealMeasure[1]	Amount	Real
RealMeasure[2]	Amount	Real
RealMeasure[3]	Amount	Real
RealMeasure[4]	Amount	Real
RealMeasure[5]	Amount	Real

TaxServiceTaxFeatureSetupCalculationParameter Tax calculation tax feature setup calculation parameter)

Name	Label	Type	Length
EnableTaxCodeLevelRounding	Enable tax code level rounding	Enum

TaxTrans_Reporting Posted sales tax)

Name	Label	Type	Length
IsReversedOnSameDate	Tax transaction is reversed on the same date	Enum

TaxTransHistory_Reporting Posted sales tax history)

Name	Label	Type	Length
IsReversedOnSameDate	Tax transaction is reversed on the same date	Enum

TaxWithholdTrans_IN Withholding tax transaction)

Name	Label	Type	Length
TaxCalcAsNonTaxTransInVoucher	taxed transaction voucher which tax calculated as non taxed transaction.	String	20

TMSParameters TRX Parameters)

Name	Label	Type	Length
FreightBillDiscardVendorInvoiceJournalCreationPolicy	Freight bill discard vendor invoice journal creation policy	Enum

TMSTransportationManagementParametersStaging Transportation management parameters)

Name	Label	Type	Length
FreightBillDiscardVendorInvoiceJournalCreationPolicy	Freight bill discard vendor invoice journal creation policy	Enum

VendInvoiceInfoTable Vendor invoices)

Name	Label	Type	Length
AllowLineQtyChange	AllowLineQtyChange	Enum

VendParameters Vendor parameters)

Name	Label	Type	Length
AutomationAllowNoLineInvoiceImport	Allow invoice to be imported with no derived lines	Enum

WHSEWInboundShipmentOrderLineInventDimUpdate External warehouse inbound shipment order line inventory dimension updates)

Name	Label	Type	Length
BatchExpirationDate	Expiration date	Date
BatchManufacturingDate	Manufacturing date	Date

WHSInboundLoadHeaderStaging Inbound load header)

Name	Label	Type	Length
LoadSplitShipmentConfirmationPolicy	Load split shipment confirmation policy	Enum

WHSLoadTable Loads)

Name	Label	Type	Length
LoadSplitShipConfirmPolicy	Load split shipment confirmation policy	Enum

WHSLoadTemplate Load templates)

Name	Label	Type	Length
LoadSplitShipConfirmPolicy	Load split shipment confirmation policy	Enum

WHSLoadTemplateStaging Load templates)

Name	Label	Type	Length
LoadSplitShipmentConfirmationPolicy	Load split shipment confirmation policy	Enum

WHSOutboundLoadHeaderStaging Outbound load header)

Name	Label	Type	Length
LoadSplitShipConfirmPolicy	Load split shipment confirmation policy	Enum

Tables with modified fields

BatchHeartbeat (Batch heartbeat table)

Name	Label	Type	Length
Zone	@SYS:Zone Zone	Enum

BatchServerConfig (Batch server schedule)

Name	Label	Type	Length
Zone	@SYS:Zone Zone	Enum

BudgetSourceTracking (Budget source tracking)

Name	Label	Type	Length
BudgetModelDataAreaId	Company Company ID related to the budget model	String	4

LTMDocumentClassification (Document class)

Name	Label	Type	Length
ConceptLabel1	Contact person concept label 1 Concept label 1	String	255
ConceptLabel2	Contact person concept label 2 Concept label 2	String	255
ConceptLabel3	Contact person concept label 3 Concept label 3	String	255

MpsPlanRegenerationProductFilter (Plan regeneration product filters)

Name	Label	Type	Length
ItemId	User ID Item number	String	20

ProjProjectContractLineMilestoneHeader (Progress billing milestone header)

Name	Label	Type
Amount	Amount Milestone amount	Real
NextInvoicePercent	Next invoice percent Next invoice %	Real
PercentInvoicedToDate	Percent invoiced to date % invoiced to date	Real

ProjProjectContractLineMilestoneHeaderStaging (Progress billing milestone header)

Name	Label	Type	Length
NextInvoicePercent	Next invoice percent Next invoice %	Real
PercentInvoicedToDate	Percent invoiced to date % invoiced to date	Real

TrvExpMobileReceiptAttachedToExpenseLineStaging (View Attached Receipts to Expense Lines)

Name	Label	Type	Length
ExpenseLineAttachedTo	ExpenseLineAttachedTo	String	10 20

Tables with changed labels

Name	Label
InventInventoryCountingReasonCodeV2Staging	Counting reason codes Counting reason codes V2
ProjCostTrans	Expense Project expense transactions
ProjCostTransCost	Expense Project expense transactions - cost
ProjCostTransSale	Expense Project expense transactions - sale
ProjEmplTrans	Hours Project hour transactions
ProjEmplTransCost	Hours Project hour transactions - cost
ProjEmplTransSale	Hours Project hour transactions - sale
ProjItemTrans	Items Project item transactions
ProjItemTransCost	Items - project expenses Project item transactions - cost
ProjItemTransSale	Items Project item transactions - sale
ProjOnAccTrans	On-account Project on-account transactions
ProjOnAccTransSale	On-account Project on-account transactions - sale
ProjRevenueTrans	Fee Project fee transactions
ProjRevenueTransSale	Fee Project fee transactions - sale
WHSGS1PolicyLine	Policy line Policy lines

Tables with changed row count

Name	Label	Row count
ArchiveServiceType	Archive service types	8 11
Batch	Batch transactions	13005 13001
BatchHeartbeat	Batch heartbeat table	1 2
BatchHistory	Batch tasks history	2635 2667
BatchJob	Batch job	13441 13461
BatchJobAlerts	Batch job alerts	17211 17238
BatchJobHistory	Batch jobs history	3499 3552
BatchJobRecurrenceCount	Batch job recurrence count	15714 15741
BatchServerConfig	Batch server schedule	6 7
BatchServerGroup	Batch server groups	62 63
BatchThrottledClass	Batch throttled classes	0 1
BusinessDocumentParameters	Electronic document parameters	0 1
BusinessEventsTable	Business Events	12268 12493
CDSVirtualEntityList	Dataverse virtual entity	3859 3932
ConfCompTableStats	Row count	14164 14173
CustAccountNumObjectReferences	CustTable accountNum object references	611 683
DataMaintenanceAction	Available actions	98 100
DataMaintenanceActionHistory	Action history	28 22
DataMaintenanceActionHistoryStatus	Action history status	84 66
DataMaintenanceTaskHistory	Task history	29 23
DataMaintenanceTaskHistoryStatus	Task history	86 68
DiagnosticsValidationRule	DiagnosticsValidationRule	100 101
DimensionDataIntegrityScanActionStatus	Dimension data integrity scan action recent status table	34 33
DimensionObjectStorageTableReferences	Dimension object table references	1208 1227
DimensionValueRenameAudit	@DimensionValueRenameAuditLabel	0 4
DimensionWork	Dimension work tracking table	4 3
ERFeatureDesignSetupRestorationTable	Feature design-time restoration table	0 1
ERInvoicingServiceParameters	Electronic Invoicing parameters	0 1
FeatureManagementMetadata	Feature management metadata	848 872
FeatureManagementMetadataTranslation	Feature management metadata translation	54556 56074
FeatureManagementState	FeatureManagementState	823 847
FormControlReactGridState	FormControlReactGridState	10 5
FormRunConfiguration	Form configurations	304 302
FormRunConfigurationDefaultView	FormRunConfigurationDefaultView	6 5
FormRunConfigurationPageCaption	Page titles	688896 691782
FormRunConfigurationProperty	Form configuration properties	2807 2805
FormRunConfigurationPropertyRecommendation	FormRunConfigurationPropertyRecommendation	15 14
ProcessExecutionMessageLog	Process automation message log	9479 9390
ProcessExecutionSourceLink	Execution source link	11005 10916
ProcessExecutionStatusLog	Execution status log	8397 8385
ProcessScheduleSeries	Schedule series	36 38
ProcessScheduleSeriesPattern	Schedule series pattern	51 53
ProcessScheduleType	Schedule type	45 47
ReportingSysSetupHistory	ReportingSysSetupHistory	14 15
RetailCdxAxTableId	Table ID	695 696
RetailCDXChangeTrackingQueue	SQL change tracking query queue	13169 13175
RetailCDXChangeTrackingSQL	SQL change tracking queries for Async Server	4036 4039
RetailCdxDataDistributionQuery	Data distribution query	1726 1728
RetailCdxDataDistributionQueryFilter	Data distribution query filter	2253 2254
RetailCDXDataDistributionTable	Data distribution table	681 682
RetailCDXDateFilterField	RetailCDXDateFilterField	690 691
RetailCDXMetadataSyncTombstone	Metadata sync tombstone	358354 374376
RetailConnLocationDesignTable	Channel table	784 785
RetailConnLocationDesignTableField	Channel table fields	7138 7158
RetailConnSchedulerJobLine	Scheduler job lines	862 864
RetailConnSchedulerSubjobFieldList	Retail Scheduler subjob field list	7138 7158
RetailConnSchedulerSubjobTable	Scheduler sub jobs	784 785
RetailPostSetupActions	RetailPostSetupActions	6 7
RetailTableIdTable	TableId metadata	25516 25759
RetentionEnabledEntityList	RetentionEnabledEntityList	94 151
SecurityDuty	Security duty view	2661 2674
SecurityEntryPointInferredTables	Security role entry point inferred tables	34382 34534
SecurityPrivilege	Security privilege view	18805 18864
SecurityRoleDutyExplodedGraph	Security role duty exploded graph	5717 5740
SecurityRolePrivilegeExplodedGraph	Security role privilege exploded graph	78904 79122
SecurityRoleRuntime	Security role runtime	192346 192962
SelfHealingOpportunity	Optimization opportunity	182 179
SourceDocumentAcctEventReferenceIdentity	Source document accounting event reference identity	468 524
SourceDocumentHeader	Source document header	39209 39968
SourceDocumentLine	Source document line	1129256 1139256
SourceDocumentLineReferenceIdentity	Source document line reference identity	5621 5705
SqlDictionary	Table list	477121 482895
SysAADClientTable	Microsoft Entra ID applications	14 15
SysCacheFlush	System cache flush	13 6
SysClientSessions	Current client sessions	80 117
SysCustomFieldLabels	Custom field labels	150 148
SysDataChangeDetectionEventTable	Change detection events	6 8
SysDraining	Contains system draining information	69 71
SysEncryptionLog	SysEncryptionLog	16825 16843
SysEvent	System events	97 99
SysGlobalConfiguration	System level configurations	155 157
SysLastValue	LastValue	33 25
SysSecAuthorizationExtendedLog	SysSecAuthorizationExtendedLog	374 190
SysServerConfig	Server configuration	2 3
SysServerSessions	Current AOS instances	7 10
SysSqlTableIndexLockEscalation	SysSqlTableIndexLockEscalation	2218 2274
SysSqlTableLockEscalation	SysSqlTableLockEscalation	519 545
SysTableIdTable	TableId metadata	32042 32285
SystemNotificationUser	System user notifications	61 59
SysUserLog	User log	684 681

About

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

Prepared using ConfigCompare