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

About

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

Removed tables

RetailDiscountAlgorithmModeLookup ()

Name	Label	Type	Length
DiscountAlgorithmMode	DiscountAlgorithmMode	Enum
MaxBestDealStepCount	MaxBestDealStepCount	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

New tables

AgentFeed (Agent Feed)

Name	Label	Type	Length
AIContext	AIContext	Bin/Memo/Container
BaseRank	BaseRank	Real
CardProvider	CardProvider	String	250
CorrelationId	CorrelationId	String	38
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
DueDate	DueDate	Date time
FeedItemId	FeedItemID	String	38
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
PermissionsCheck	PermissionsCheck	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
SubTitle	Subtitle	String	250
Summary	Summary	Bin/Memo/Container
TimeToLive	Expiry	Date time
Title	Title	String	250

AgentFeedItemSourceRecord (Agent Feed Item Source Record)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FeedItemID	FeedItemID	String	38
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecID	SourceRecID	RecId
SourceTableID	SourceTableID	Integer
SourceTableName	@AdaptiveAgentFeed:AgentFeedItemSourceRecord_SourceTableName	String	250

AgentFeedMenuItem (Agent Feed menu Item)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
FeedItemId	FeedItemID	String	38
MenuItem	MenuItem	String	250
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer

AgentFeedStaging (Agent Feed)

Name	Label	Type	Length
AIContext	AIContext	Bin/Memo/Container
BaseRank	BaseRank	Real
CardProvider	CardProvider	String	250
CorrelationId	CorrelationId	String	38
CreatedOn	Created date and time	Date time
DefinitionGroup	Processing group	String	60
DueDate	DueDate	Date time
ExecutionId	Job ID	String	90
FeedItemId	FeedItemID	String	38
FeedItemRecId	Record-ID	RecId
IsSelected	Select	Enum
ModifiedOn	Modified date and time	Date time
PermissionsCheck	PermissionsCheck	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
SubTitle	Subtitle	String	250
Summary	Summary	Bin/Memo/Container
TimeToLive	Expiry	Date time
Title	Title	String	250
TransferStatus	Staging to target status	Enum

AgentFeedUserPreference (Agent Feed user Preference)

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
Preferences	Preferences	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
UserId	UserId	String	250

CustFiscalDocumentNote_BR (Customer Fiscal note)

Name	Label	Type	Length
AccessKey	Access key	String	45
ComplementedFiscalDocument	Reference	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Currency	Currency	String	3
CustFinalUser	Final user	Enum
CustTable	Customer account	String	20
DebitCreditNoteType	Business type	Enum
DefaultDimension	Dimension	RecId
Direction	Direction	Enum
DocumentDate	Invoice date	Date
FiscalDocumentNumber	Invoice	String	50
FiscalDocumentType_BR	Fiscal document type	RecId
FiscalEstablishment_BR	Fiscal establishment ID	RecId
InclTax	Prices include sales tax	Enum
Issuer	Fiscal document issuer	Enum
LedgerVoucher	Voucher	String	20
Purpose	Purpose	Enum
ReasonTableRef_BR	Reason table reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
ThirdPartyLogisticsPostalAddress	Postal address	RecId
TotalAmount	Total amount	Real

CustFiscalDocumentNoteLine_BR (Purchase complementary invoice line)

Name	Label	Type	Length
Amount	Net amount	Real
AmountFine	Fine amount	Real
AmountInterest	Interest amount	Real
CFOPTable	CFOP	RecId
CustFiscalDocumentNote	Reference	RecId
DefaultDimension	Dimension	RecId
Description	Line description	String	1000
InventDim	Dimension number	String	20
ItemId	Item number	String	20
LedgerDimension	Main account	RecId
LineNum	Line number	Real
OriginalFiscalDocumentLine	Reference	RecId
OriginalLineAmount	Original line amount	Real
OriginalUnit	Unit	String	10
Quantity	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10

GUPMarginComponentPriceAdjustmentLineV2Staging (Margin component price adjustment line V2 - Pricing management)

Name	Label	Type	Length
CalculationMethod	Calculation type	Enum
CashDiscountAmount	Amount	Real
Color	Color	String	10
Configuration	Configuration	String	50
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
DiscountedSalePriceIncludingTax	Discounted sale price including tax	Real
DiscountMethodN1	Discount method	Enum
DiscountPercentage	Percentage	Real
DiscountPercentOrValue	Percentage off	Real
DiscountPrice	Unit price	Real
DiscountPriceN1	Unit price	Real
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Exclusion	String	500
LineExclusionType	Price rule exclusion type	Enum
LineNum	Line number	Real
LineType	Line Type	Enum
Name	Name	String	60
OfferId	Margin component adjustment	String	20
PriceAttributeGroupName	Price attribute group	String	60
PriceAttributeGroupType	Line group type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Site	Site	String	10
Size	Size	String	10
Style	Style	String	10
Symbol	Unit	String	10
TransferStatus	Staging to target status	Enum
UnitAppliesToAll	UnitAppliesToAll	Enum
Warehouse	Warehouse	String	10

GUPMarginComponentPriceAdjustmentV2Staging (Margin component price adjustment V2 - Pricing management)

Name	Label	Type	Length
ConcurrencyMode	Discount concurrency mode	Enum
CurrencyCode	Currency	String	3
DateValidationType	Date validation type	Enum
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
Disclaimer	Disclaimer	Bin/Memo/Container
DiscountPercentValue	Percentage off	Real
ExecutionId	Job ID	String	90
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Exclusion	String	500
HeaderExclusionType	Price rule exclusion type	Enum
IncludeGenericCurrency	Include generic currency	Enum
IsDiscountCodeRequired	Coupon code required	Enum
IsSelected	Select	Enum
IsTierConfigurationEnabled	Quantity tiers	Enum
Name	Name	String	60
OfferId	Margin component adjustment	String	20
PriceAttributeGroupName	Price attribute group	String	60
PriceAttributeGroupType	Header group type	Enum
PriceComponentCodeName	Price component code	String	80
PrintDescriptionOnFiscalReceipt	Text for fiscal receipt	String	50
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
TierPriceAdjustmentMethod	Calculation type	Enum
TransferStatus	Staging to target status	Enum
ValidationPeriodId	Discount period number	String	10
ValidFrom	Effective	Date
ValidTo	Expiration	Date

GUPOpenTradeAgreementJournalLineV2Staging (Open trade agreement journal line V2 - Pricing management)

Name	Label	Type	Length
AttributeBasedPricingId	Attribute-based pricing ID	String	10
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FixedPriceCharges	Price charges	Real
FromQuantity	From	Real
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Header exclusion	String	500
HeaderExclusionType	Header exclusion type	Enum
IsGenericCurrencySearchEnabled	Include generic currency	Enum
IsSelected	Select	Enum
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Line exclusion	String	500
LineExclusionType	Line exclusion type	Enum
LineNumber	Line number	Real
Price	Amount in currency	Real
PriceApplicableFromDate	From date	Date
PriceApplicableToDate	To date	Date
PriceApplyAdjustment	Allow price adjustment	Enum
PriceAttributeGroupNameHeader	Header price attribute group	String	60
PriceAttributeGroupNameLine	Line price attribute group	String	60
PriceComponentCodeName	Price component code	String	80
PriceComponentCombination	Price attribute group combination	String	180
PriceCurrencyCode	Currency	String	3
PriceGroup	Price group	String	10
PricePreventDiscount	Prevent discount	Enum
PriceSiteId	Site	String	10
PriceWarehouseId	Warehouse	String	10
ProcessingLog	Log	String	255
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
QuantityUnitSymbol	Unit	String	10
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesLeadTimeDays	Lead time	Integer
SalesPriceQuantity	Price unit	Real
ToQuantity	To	Real
TradeAgreementJournalNumber	Price/discount journal number	String	20
TransferStatus	Staging to target status	Enum
UnitAppliesToAll	Allow unit conversion	Enum
WillDeliveryDateControlDisregardLeadTime	Disregard lead time	Enum
WillSearchContinue	Find next	Enum

GUPPriceDiscPriceAttributeCustomerGroupV2Staging (Attribute-based price groups V2)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
GroupCode	Price groups	String	10
GroupName	Name	String	60
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
IsSelected	Select	Enum
PriceAttributeGroupName	Price attribute group	String	60
PricingPriority	Pricing priority	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

GUPPriceTermJournalTransV2Staging (Vendor price term agreement journal lines V2)

Name	Label	Type	Length
AgreementId	Agreement ID	String	20
BatchNumber	Batch number	String	20
Code	Code	String	60
Color	Color	String	10
CompoundCalculationBasis	Compound	Enum
Configuration	Configuration	String	50
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
InventoryStatus	Inventory status	String	10
IsSelected	Select	Enum
LicensePlate	License plate	String	25
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Exclusion	String	500
LineExclusionType	Price rule exclusion type	Enum
LineNum	Value	Real
Location	Location	String	10
Owner	Owner	String	40
PriceAttributeGroup	Price attribute group	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SerialNumber	Serial number	String	20
Site	Site	String	10
Size	Size	String	10
Style	Style	String	10
TransferStatus	Staging to target status	Enum
UnitId	Unit	String	10
ValidFrom	From date	Date
ValidTo	To date	Date
Value	Amount/Percent	Real
Warehouse	Warehouse	String	10

GUPRetailDataMigrationTenderDiscountMapping ()

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

GUPRetailDiscountLineV2Staging (Discount line V2 - Pricing management)

Name	Label	Type	Length
Color	Color	String	10
Configuration	Configuration	String	50
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
DiscountPercentOrValue	Percentage off	Real
ExecutionId	Job ID	String	90
FreeItemGroup	Free item group	Integer
IsDiscountApplyingLine	Is discount applying line	Enum
IsMandatory	Mandatory	Enum
IsSelected	Select	Enum
LeastAmount	Required line amount	Real
LeastQuantity	Required line quantity	Real
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Exclusion	String	500
LineExclusionType	Price rule exclusion type	Enum
LineNum	Line number	Real
LineType	Line Type	Enum
MixAndMatchDiscountType	Calculation type	Enum
MixAndMatchLineGroup	Line group	String	10
MixAndMatchNumberOfItemsNeeded	Number of products needed	Integer
Name	Name	String	60
OfferDiscountAmount	Amount off	Real
OfferDiscountMethod	Calculation type	Enum
OfferDiscountMethodN1	Discount method	Enum
OfferDiscountPercentage	Percentage off	Real
OfferId	Discount	String	20
OfferPrice	Unit price	Real
OfferPriceInclTaxN1	Discounted sale price including tax	Real
OfferPriceN1	Unit price	Real
PriceAttributeGroupName	Price attribute group	String	60
PriceAttributeGroupType	Line group type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Site	Site	String	10
Size	Size	String	10
Style	Style	String	10
ThresholdApplyingLineDiscountMethod	Discount method	Enum
ThresholdLineQuantityLimit	Quantity limit	Real
ThresholdTierAmount	Amount	Real
TransferStatus	Staging to target status	Enum
UnitAppliesToAll	UnitAppliesToAll	Enum
UnitOfMeasureSymbol	Unit	String	10
Warehouse	Warehouse	String	10

GUPRetailDiscountV2Staging (Discount V2 - Pricing management)

Name	Label	Type	Length
BarCode	Bar code	String	80
Claimable	Claimable	Enum
ConcurrencyMode	Discount concurrency mode	Enum
CurrencyCode	Currency	String	3
DateValidationType	Date validation type	Enum
DefinitionGroup	Processing group	String	60
Description	Description	Bin/Memo/Container
DisabledSince	The discount has been disabled since	Date
Disclaimer	Disclaimer	Bin/Memo/Container
DiscountClaimPostingOffset	Claim offset posting	String	60
DiscountCode	Discount code	String	60
DiscountPercentValue	Percentage off	Real
DiscountVendorClaimGroupName	Discount claim group	String	60
DlvModeId	Mode of delivery	String	10
ExecutionId	Job ID	String	90
FreeItemCalculationMethod	Calculation type	Enum
FreeItemCriteriaType	Criteria type	Enum
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Exclusion	String	500
HeaderExclusionType	Price rule exclusion type	Enum
IncludeGenericCurrency	Include generic currency	Enum
IsDiscountCodeRequired	Coupon code required	Enum
IsSelected	Select	Enum
MatchAllAssociatedPriceGroups	Match all associated price groups	Enum
MaxCriteriaType	Max criteria type	Enum
MaxQtyOrAmount	Max	Real
MixAndMatchDealPrice	Deal price	Real
MixAndMatchDiscountAmount	Amount off	Real
MixAndMatchDiscountType	Calculation type	Enum
MixAndMatchLeastExpensiveMode	Multiple occurrences mode	Enum
MixAndMatchNoOfLeastExpensiveLines	Number of least expensive lines	Integer
MultibuyDiscountType	Calculation type	Enum
Name	Name	String	60
OfferId	Discount	String	20
OfferQuantityLimit	Quantity Limit	Integer
PeriodicDiscountType	Discount type	Enum
PriceAttributeGroupName	Price attribute group	String	60
PriceAttributeGroupType	Header group type	Enum
PriceComponentCodeName	Price component code	String	80
PricingPriorityNumber	Pricing priority	Integer
PrintDescriptionOnFiscalReceipt	Text for fiscal receipt	String	50
ProcessingStatus	Publish status	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Repeatable	Repeatable	Enum
ShouldUseInterval	Interval	Enum
Status	Status	Enum
ThresholdCountNonDiscountItems	Count non-discountable items toward threshold	Enum
TransferStatus	Staging to target status	Enum
UnitOfMeasureSymbol	Unit	String	10
ValidationPeriodId	Discount period number	String	10
ValidFrom	Effective	Date
ValidTo	Expiration	Date

GUPSalesAutomaticSalesDocumentHeaderChargeTableV2Staging (Automatic sales document charges table V2 - Pricing management)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
Description	Charge description	String	60
ExecutionId	Job ID	String	90
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Exclusion	String	500
HeaderExclusionType	Price rule exclusion type	Enum
IsSelected	Select	Enum
PriceAttributeGroupNameHeader	Price attribute group	String	60
PriceAttributeGroupTypeHeader	Header group type	Enum
PriceComponentCodeName	Price component code	String	80
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailAdvancedChargesDeliveryProrate	Prorate to matching sales lines	Enum
TransferStatus	Staging to target status	Enum

GUPSalesAutomaticSalesDocumentLineChargeTableV2Staging (Automatic sales document line charges table V2 - Pricing management)

Name	Label	Type	Length
AutoChargesConcurrencyMode	Auto charge concurrency mode	Enum
DefinitionGroup	Processing group	String	60
Description	Charge description	String	60
ExecutionId	Job ID	String	90
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Header exclusion	String	500
HeaderExclusionType	Header exclusion type	Enum
HeaderPriceAttributeGroupName	Header price attribute group	String	60
IsSelected	Select	Enum
Line1	Line1	String	1000
Line10	Line10	String	1000
LIne11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Line exclusion	String	500
LineExclusionType	Line exclusion type	Enum
LinePriceAttributeGroupName	Line price attribute group	String	60
PriceComponentCodeName	Price component code	String	80
PriceComponentCombination	Price attribute group combination	String	180
PriceComponentCombinationCodeName	Price component code	String	80
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

GUPSalesAutomaticSalesDocumentLineChargeV2Staging (Automatic sales document line charges V2 - Pricing management)

Name	Label	Type	Length
ChargeAccountingCurrencyCode	Charges currency code	String	3
ChargeCategory	Category	Enum
DefinitionGroup	Processing group	String	60
Description	Charge description	String	60
ExecutionId	Job ID	String	90
FromDate	From date	Date
InventLocationId	Warehouse	String	10
InventSiteId	Site	String	10
IsSelected	Select	Enum
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Exclusion	String	500
LineExclusionType	Price rule exclusion type	Enum
LineNumber	Line number	Real
PriceAttributeGroupNameLine	Price attribute group	String	60
PriceAttributeGroupTypeLine	Line group type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SalesChargeCode	Charges code	String	10
SalesDocumentCurrencyCode	Currency	String	3
SalesTaxGroupCode	Sales tax group	String	10
SpecificUnitSymbol	Unit	String	10
ToDate	To date	Date
TransferStatus	Staging to target status	Enum
Value	Charges value	Real
WillInvoiceProcessingKeepCharge	Keep	Enum

GUPTAMRebateAndDeductionsAgreementHeaderV2Staging (Rebate management agreement header V2 - Pricing management)

Name	Label	Type	Length
AgreementDescription	Description	String	60
AgreementModule	Module	Enum
AgreementNumber	Rebate management number	String	20
AveragePurchasePriceBasisCalculationMonthRange	Number of months	Integer
CalculationMethod	Calculation method	Enum
CustomerAccountNumber	Customer account	String	20
CustomerRebateAndDeductionsGroupId	Rebate management group	String	10
CustomerRebateReductionPrincipleId	Rebate reduction principle	String	10
DefinitionGroup	Processing group	String	60
DocumentNotes	Document notes	String	60
ExecutionId	Job ID	String	90
GuaranteePostingProfileId	Posting profile for guarantee	String	10
Header1	Header1	String	1000
Header10	Header10	String	1000
Header11	Header11	String	200
Header12	Header12	String	200
Header13	Header13	String	200
Header14	Header14	String	200
Header15	Header15	String	200
Header2	Header2	String	1000
Header3	Header3	String	1000
Header4	Header4	String	1000
Header5	Header5	String	1000
Header6	Header6	String	1000
Header7	Header7	String	1000
Header8	Header8	String	1000
Header9	Header9	String	1000
HeaderExclusion	Header exclusion	String	500
HeaderExclusionType	Header exclusion type	Enum
InventoryStatusId	Inventory status	String	10
IsSelected	Select	Enum
ItemBatchNumber	Batch number	String	20
ItemNumber	Item number	String	20
ItemSerialNumber	Serial number	String	20
LegalEntityId	Company	String	4
Line1	Line1	String	1000
Line10	Line10	String	1000
Line11	Line11	String	200
Line12	Line12	String	200
Line13	Line13	String	200
Line14	Line14	String	200
Line15	Line15	String	200
Line2	Line2	String	1000
Line3	Line3	String	1000
Line4	Line4	String	1000
Line5	Line5	String	1000
Line6	Line6	String	1000
Line7	Line7	String	1000
Line8	Line8	String	1000
Line9	Line9	String	1000
LineExclusion	Line exclusion	String	500
LineExclusionType	Line exclusion type	Enum
MatchedByOrderAccount	Matched by order account	Enum
MinimumAmount	Minimum amount	Real
OperationalSiteId	Site	String	10
PackedQuery	Packed query run	Bin/Memo/Container
PriceComponentCodeName	Price component code	String	80
PriceComponentCombinationName	Price attribute group combination	String	180
ProductColorId	Color	String	10
ProductConfigurationId	Configuration	String	50
ProductRebateAndDeductionsGroupId	Rebate management group	String	10
ProductSizeId	Size	String	10
ProductStyleId	Style	String	10
ProductUnitSymbolType	Unit type	Enum
RebateAgreementType	Rebate Agreement Type	String	60
RebateAndDeductionsDealNumber	Rebate management deal	String	20
RebateAndDeductionsPostingProfileId	Posting profile	String	10
RebateAndDeductionsStatusId	Rebate status	String	20
RebateAndDeductionsType	Type	Enum
RebateCalculationBasis	Basis	Enum
RebatePriceBasis	Price basis	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RetailProductVariantNumber	Variant number	String	10
SourceDocumentType	Transaction type	Enum
SupportNegativeTier	Auto negative tier	Enum
TransferStatus	Staging to target status	Enum
UnitSymbol	Unit	String	10
VendorAccountNumber	Vendor account	String	20
VendorRebateAndDeductionsGroupId	Rebate management group	String	10
VendorRebateCalculationTransactionBasis	Vendor rebate basis	Enum
WarehouseId	Warehouse	String	10
WarehouseLocationId	Location	String	10
WillRebateProcessingCalculationIncludeCreditNote	Include credit notes	Enum
WillRebateProcessingCalculationIncludeDiscountedAmount	Discounted amount	Enum
WillRebateProcessingCalculationIncludeFreeText	Include free text	Enum
WillRebateProcessingCalculationIncludePaidInvoicesOnly	Paid invoices only	Enum
WillRebateProcessingCalculationIncludeSettlementDiscount	Include settlement discount	Enum
WillRebateProcessingCalculationIncludeTax	Sales tax inclusive	Enum

HcmCourseTableInstructorStaging (Course Instructor Assignment)

Name	Label	Type	Length
Company	Company	String	4
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
hrmCourseAgendaId	Agenda	String	10
hrmCourseId	Course ID	String	10
hrmCourseSessionId	Session	String	10
hrmCourseSessionTrackId	Track	String	10
InstructorPartyNumber	Party ID	String	40
IsSelected	Select	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum

InventTransArchiveExcludeOrigin (Excluded inventory transaction origin references)

Name	Label	Type	Length
OriginReferenceCategory	Reference	Enum
OriginReferenceId	Number	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session	String	38

InventTransArchiveQueue (Inventory transaction consolidation batch queue)

Name	Label	Type	Length
AggregationComplete	Aggregation stage complete	Enum
BatchTaskId	Batch task Id	Big integer
BundleId	Bundle	Big integer
GroupNumber	Group	Integer
IsTransTypeOnlyAffectsLocationAndBelow	Inventory transactions only affects location and below	Enum
IsWhsItem	Uses warehouse management processes	Enum
LogComplete	Log stage complete	Enum
MustBeClosed	Inventory transactions must be closed	Enum
QueueState	Queue state	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session	String	38
WriteComplete	Write stage complete	Enum

InventTransArchiveQueueTrans (Inventory transaction consolidation queue transactions)

Name	Label	Type	Length
InventTrans	Reference	RecId
InventTransArchiveQueue	Consolidation processing queue	RecId
InventTransOrigin	Inventory transactions originator	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

InventTransArchiveRelatedReferenceCategory (Related reference)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReferenceCategory	Reference	Enum
RelatedReferenceCategory	Reference	Enum

LeaveBalanceActiveStaging (Leave balance active staging)

Name	Label	Type	Length
AccrualStartDate	Accrual start date	Date
BalanceRemaining	Balance	Real
BalanceType	Type	String	30
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
FirstName	First name	String	50
HideLeaveBalances	Hide leave balance	Enum
IsSelected	Select	Enum
LastName	Last name	String	50
MiddleName	Middle name	String	50
PersonnelNumber	Personnel number	String	25
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransferStatus	Staging to target status	Enum
Worker	Worker	RecId

LedgerJournalCleanUpTopPickProcessingQueue ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
LedgerJournalTable	Reference	RecId
ProcessId	ProcessId	Guid
ProcessingStatus	ProcessingStatus	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerPeriodCloseParameters (Parameters)

Name	Label	Type	Length
HoursForAtRisk	At risk threshold (hours)	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

LedgerPeriodCloseProjectTaskAuditLog (Project task audit log)

Name	Label	Type	Length
Comment	Comment	String	500
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
LedgerPeriodCloseAuditEventType	Audit event type	Enum
LedgerPeriodCloseProject	Reference	RecId
LedgerPeriodCloseProjectTaskRecId	LedgerPeriodCloseProjectTaskRecId	Big integer
NewValue	NewValue	String	500
OrigValue	OrigValue	String	500
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefFieldId	RefFieldId	Integer
RefFieldName	Reference field name	String	81
RefRecId	Reference	RecId

LedgerPeriodCloseProjectTaskLink (Links)

Name	Label	Type	Length
CompanyId	Company accounts ID	String	4
LedgerPeriodCloseProjectTaskRecId	LedgerPeriodCloseProjectTaskRecId	Big integer
LedgerPeriodCloseTaskLinkType	Link type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RefRecId	Reference	RecId

NumberSequenceListHistory ()

Name	Label	Type	Length
AssignmentCount	AssignmentCount	Integer
CleanUpCount	CleanUpCount	Integer
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
modifiedTransactionId	Modified ID	Big integer
NextRec	Unformatted number	Integer
NextRec64	Unformatted number	Big integer
NumberSeqListRecId	NumberSeqListRecId	Big integer
NumberSequenceId	Number sequence code	RecId
NumSeqListCreatedDatetime	NumSeqListCreatedDatetime	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SessionId	Session ID	Integer
SessionLoginDateTime	Session login date/time	Date time
Status	Status	Integer
TransId	Transaction	Big integer
UserId	Run by	String	20

ProjCorrectIntercompanyTrans (Correct project intercompany transactions)

Name	Label	Type	Length
CorrectedTransRecId	Corrected record ID	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrigTransRecId	Original record ID	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReversalTransRecId	Reversal record ID	RecId
TransactionOrigin	Transaction origin	Enum

PurchCopilotDMAMitigationAnalysisJob (Disruption mitigation analysis job)

Name	Label	Type	Length
ChosenMitigationAlternativeId	ChosenMitigationAlternativeId	Guid
ChosenMitigationAlternativeName	ChosenMitigationAlternativeName	String	10
EventRecId	Reference	RecId
ImpactAnalysisJobRecId	Reference	RecId
MitigationStatus	Mitigation status	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Mitigation analysis job status	Enum

ReconciliationAutomationLegalEntityParameters ()

Name	Label	Type	Length
Company	Company	String	4
EnableAgentLedger	EnableAgentLedger	Enum
EnableLedger	EnableLedger	Enum
FiscalCalendar	Fiscal calendar	RecId
Ledger	Ledger	Big integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RetailCDXUploadSessionDataStoreSummaryErrors (Errors by error code)

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

RetailCDXUploadSessionDataStoreSummaryJobsByStatus (Errors by job and status)

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

RetailDirPartyExternalIdentity (External id to dir party map)

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
ExternalIdentityId	External identifier	String	512
IsActivated	IsActivated	Enum
modifiedDateTime	Modified date and time	Date time
Party	Name	RecId
ProviderId	Provider record id	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer

RetailLocalizedTextStaging (Retail localized texts)

Name	Label	Type	Length
DefinitionGroup	Processing group	String	60
ExecutionId	Job ID	String	90
IsSelected	Select	Enum
LanguageId	Language ID	String	7
ModuleId	Module ID	Integer
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceType	Source type	Enum
Text	Text	String	250
TextId	TextId	String	150
TransferStatus	Staging to target status	Enum

SourceDocumentAuditTrailInsertMissingRecordsWorkingQueue (Queue with tasks for SourceDocumentAuditTrailInsertMissingRecords data maintenance job.)

Name	Label	Type	Length
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceRecId	Reference	RecId
SourceTableId	Reference table ID	Integer
ValidCreatedTransactionId	Created ID	Big integer

SourceDocumentDiagnosticEnable ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceID	SourceID	String	100

SourceDocumentDiagnosticMessage ()

Name	Label	Type	Length
createdDateTime	Created date and time	Date time
Message	Message	Bin/Memo/Container
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SourceID	SourceID	String	100

SubBillGenerateInvoiceStagingTable (Subscription billing generate invoice)

Name	Label	Type	Length
ParmId	Parameter ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubBillBillingSchedDetailRecId	Reference	RecId
SubBillSchedLineRecId	Reference	RecId

SubBillGenerateInvoiceTable (Subscription billing generate invoice)

Name	Label	Type	Length
ParmId	Parameter ID	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
SubBillBillingSchedDetailRecId	Reference	RecId
SubBillSchedLineRecId	Reference	RecId

VendFiscalDocumentNote_BR (Vendor fiscal note)

Name	Label	Type	Length
AccessKey	Access key	String	45
ComplementedFiscalDocument	Reference	RecId
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
Currency	Currency	String	3
DebitCreditNoteType	Business type	Enum
DefaultDimension	Dimension	RecId
Direction	Direction	Enum
DocumentDate	Invoice date	Date
FiscalDocumentNumber	Invoice	String	50
FiscalDocumentType_BR	Fiscal document type	RecId
FiscalEstablishment_BR	Fiscal establishment ID	RecId
InclTax	Prices include sales tax	Enum
Issuer	Fiscal document issuer	Enum
LedgerVoucher	Voucher	String	20
Purpose	Purpose	Enum
ReasonTableRef_BR	Reason table reference	RecId
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Status	Enum
ThirdPartyLogisticsPostalAddress	Postal address	RecId
TotalAmount	Total amount	Real
VendFinalUser	Final user	Enum
VendTable	Vendor account	String	20

VendFiscalDocumentNoteLine_BR (Vendor fiscal note line)

Name	Label	Type	Length
Amount	Net amount	Real
AmountFine	Fine amount	Real
AmountInterest	Interest amount	Real
CFOPTable	CFOP	RecId
DefaultDimension	Dimension	RecId
Description	Line description	String	1000
InventDim	Dimension number	String	20
ItemId	Item number	String	20
LedgerDimension	Main account	RecId
LineNum	Line number	Real
OriginalFiscalDocumentLine	Reference	RecId
OriginalLineAmount	Original line amount	Real
OriginalUnit	Unit	String	10
Quantity	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TaxGroup	Sales tax group	String	10
TaxItemGroup	Item sales tax group	String	10
VendFiscalDocumentNote	Reference	RecId

VendorInvoiceTotalsCacheTable ()

Name	Label	Type	Length
CashDisc	Amount	Real
createdDateTime	Created date and time	Date time
EndDisc	Amount	Real
InvoiceRoundOff	Amount	Real
modifiedDateTime	Modified date and time	Date time
ParmId	Parameter ID	String	20
PurchBalance	Amount	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Scope	Scope	Enum
SourceDocumentHeader	Source document	RecId

VRMGlobalVendorCreationLog (Global vendor creation log)

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

WHSItemStoragePolicyLocationDirective ()

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
RecId	Record-ID	RecId
recVersion	Record Version	Integer
WHSItemStoragePolicy	Reference	RecId
WHSLocDirTable	Reference	RecId
WorkTransType	Work order type	Enum
WorkType	Work type	Enum

WHSLoadArchiveTrans (Load archive transactions)

Name	Label	Type	Length
EndDateTime	To date	Date time
LoadDataAreaId	Legal entity	String	10
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Name	Name	String	60
RecId	Record-ID	RecId
recVersion	Record Version	Integer
StartDateTime	From date	Date time

WHSLoadLineHistory (Archived load line records)

Name	Label	Type	Length
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CrossDockEvaluatedQuantity	Cross docking evaluated quantity	Real
CrossDockQuantity	Planned cross docking quantity	Real
CrossDockReservedPhysical	Cross docking physical reserved quantity	Real
Invalid	Invalid	Enum
InventDimId	Dimension number	String	20
InventQty	Inventory quantity	Real
InventTransId	Lot ID	String	20
InventTransType	Reference	Enum
ItemId	Item number	String	20
ItemNetWeight	Net weight	Real
ItemTareWeight	Tare weight	Real
LoadClosedUTCDateTime	Closed	Date time
LoadDirection	Direction	Enum
LoadId	Load ID	String	20
LoadInProcessUTCDateTime	In process	Date time
LoadOpenUTCDateTime	Open	Date time
LoadReadyToShipUTCDateTime	Ready to ship	Date time
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderNum	Order number	String	20
OverDeliveryPct	Overdelivery	Real
PackingQty	Packing quantity	Real
ParentInventTransType	Reference	Enum
ParentOrderNum	Order number	String	20
PickedQty	Picked quantity	Real
QCQty	Quality control quantity	Real
Qty	Quantity	Real
QtyLeftToStructure	Quantity remaining	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReleaseToWarehouseId	Release to warehouse ID	String	20
ShipConsolidationPolicy	Shipment consolidation policy	RecId
ShipmentId	Shipment ID	String	20
TransportRequest	Transport request	Enum
UnderDeliveryPct	Underdelivery	Real
UOM	Unit	String	10
VolumeQty_BR	Volume quantity	Real
VolumeType_BR	Volume type	String	15
WorkCreatedQty	Work created quantity	Real

WHSLoadTableHistory (Archived load table records)

Name	Label	Type	Length
AccountNum	Account number	String	20
ActualGrossWeight	Actual gross weight	Real
ActualNetWeight	Actual weight	Real
ActualTareWeight	Actual tare weight	Real
ActualVolume	Actual volume	Real
AllowLoadSplitShipConfirm	Allow load split during ship confirm	Enum
ArchiveServiceJobId	Service job id	Guid
BillOfLadingId	Master bill of lading	String	25
BookingNum	Booking number	String	20
BrokerCode	Broker ID	String	20
CarbonEmission	CO2e	Real
CarbonEmissionUnit	CO2e Unit	String	10
CarNumber	Car number	String	20
CarrierCode	Shipping carrier	String	20
CarrierGroupCode	Carrier group	String	20
CarrierServiceCode	Carrier service	String	20
CarState_BR	State registered	String	10
createdBy	Created by	String	20
createdDateTime	Created date and time	Date time
CredManInCreditControl	In credit management	Enum
CustVendRef	Reference number	String	60
CutOffUTCDateTime	Cut off date and time	Date time
DestinationHubCode	Hub	String	20
DestinationName	Destination	String	60
DestinationPostalAddress	Postal address	RecId
ETA	ETA	Date time
ETD	Estimated time of departure	Date time
FinalDestination	Final destination	Enum
HouseBill	House bill	String	10
InspectionSeal	Inspection seal	String	10
Invalid	Invalid	Enum
InventLocationId	Warehouse	String	10
InventSiteId	Site	String	10
LastUpdateUTCDateTime	Last update date and time	Date time
LateShipReasonCode	Reason for late shipping	String	20
LoadArrivalUTCDateTime	Load arrival date and time	Date time
LoadBuildTemplateName	Load build template name	String	20
LoadDepth	Load depth	Real
LoadDirection	Direction	Enum
Loader	Loader	String	50
LoadFloorStack	Stack load on floor	Enum
LoadHeight	Load height	Real
LoadId	Load ID	String	20
LoadingStrategy	Loading strategy	Enum
LoadNetWeight	Net weight	Real
LoadPaysFreight	Freight payer	Enum
LoadReceivingCompletedUTCDateTime	Load receiving completed date and time	Date time
LoadReferenceNum	Load reference number	String	100
LoadSchedShipUTCDateTime	Scheduled load shipping date and time	Date time
LoadShipConfirmUTCDateTime	Load shipped confirmation date and time	Date time
LoadSplitShipConfirmPolicy	Load split shipment confirmation policy	Enum
LoadStatus	Load status	Enum
LoadTemplateId	Load template ID	String	20
LoadTipVolume	Load tip volume	Real
LoadTipWeight	Max. allowed load weight	Real
LoadUserDef1	User defined field 1	String	100
LoadUserDef2	User defined field 2	String	100
LoadUserDef3	User defined field 3	String	100
LoadWeight	Load weight	Real
LoadWidth	Load width	Real
MaxFreightPieces	Max. allowed number of freight pieces	Integer
ModeCode	Mode	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderNum	Order number	String	20
OriginHubCode	Hub	String	20
OriginName	Origin	String	60
OriginPostalAddress	Postal address	RecId
PackingSlipBackgroundPostingStatus	Load packing slip background posting status	Enum
PackingSlipCreationPolicy	Packing slip creation policy	Enum
PackingSlipType	Packing slip type	Enum
ProductReceiptProcessingStatus	Product receipt processing status	Enum
ProNum	Pro number	String	25
ReceivingCompletedDeliveryPolicy	Delivery policy	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
RequiredSailUTCDateTime	Required sail date and time	Date time
RouteCode	Route	String	20
SailUTCDateTime	Sail UTCdate time	Date time
SealNum	Seal number	String	50
ShippingContainerId	Shipping container ID	String	30
SystemTareWeight	System tare weight	Real
TractorNumber	Tractor number	String	30
TrailerNumber	Trailer number	String	30
TransportationTemplateId	Transportation template ID	String	20
VesselName	Vessel name	String	20
VoyageNum	Voyage number	String	10

WHSShipmentTableHistory (Archived shipment table records)

Name	Label	Type	Length
AccountNum	Account number	String	20
Address	Address	String	250
BillOfLadingId	Bill of lading ID	String	25
BrokerCode	Broker ID	String	20
CarrierCode	Shipping carrier	String	20
CarrierGroupCode	Carrier group	String	20
CarrierServiceCode	Carrier service	String	20
CountryRegionISOCode	ISO country code	String	2
createdDateTime	Created date and time	Date time
CustomerRef	Customer reference	String	60
CustomerReq	Customer requisition	String	20
DeliveryName	Delivery recipient	String	160
DeliveryPostalAddress	Postal address	RecId
DlvTermId	Delivery terms	String	10
DropOffUTCDateTime	Drop off date time	Date time
FreightTermCode	Freight term	String	20
HMIMAirWaybillNum	Air waybill ID	String	25
HMIMCarrOfMerchByRoadId	Carriage of Merchandise by Road ID	String	25
HMIMMultimodalDGId	Multimodal dangerous goods ID	String	25
InventLocationId	Warehouse	String	10
InventOwnerId	Inventory owner	String	40
InventSiteId	Site	String	10
LoadDirection	Direction	Enum
LoadId	Load ID	String	20
ManifestedWeight	Manifested weight	Real
ManifestedWeightUOM	Weight unit	String	10
ModeCode	Mode of delivery	String	20
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderLineInventTransLinkType	Shipment order line inventory transaction link type	Enum
OrderNum	Order number	String	20
OutboundShipmentProcessingPolicy	Outbound shipment processing policy	RecId
PreallocatedPackingSlipDocumentDate	Preallocated packing slip document date	Date
PreallocatedPackingSlipId	Preallocated packing slip id	String	20
ProNum	Pro number	String	25
ReceivingCompletedDocumentDate	Document date	Date
ReceivingCompletedPackingSlipId	Receiving completed packing slip Id	String	20
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Reference	Reference	String	20
RouteCode	Route	String	20
SCAC	SCAC	String	20
ShipConfirmUTCDateTime	Shipping confirmation date and time	Date time
ShipConsolidationPolicy	Shipment consolidation policy	RecId
ShipmentArrivalUTCDateTime	Shipment arrival date and time	Date time
ShipmentCreatedUTCDateTime	Shipment created date and time	Date time
ShipmentId	Shipment ID	String	20
ShipmentProcessingOwnership	Outbound shipment processing ownership	Enum
ShipmentStatus	Shipment status	Enum
SourceSystem	Source system	RecId
StopNum	Stop number for loads	Integer
WaveId	Wave ID	String	20
WaveLabelsPrinted	Printed	Enum
WaveLabelsPrintedBy	Printed by	String	20
WaveLabelsPrintedDateTime	Printed date/time	Date time
WayBill	Way bill number	String	25
WorkTransType	Work order type	Enum

WHSWorkInventTransHistory (Archived work invent trans records)

Name	Label	Type	Length
InventDimIdFrom	From dimension	String	20
InventDimIdTo	To dimension	String	20
InventoryTransactionOriginId	Warehouse inventory transaction origin id	Guid
InventQtyRemain	Remainder	Real
InventTransIdFrom	From transaction	String	20
InventTransIdParent	Lot ID	String	20
InventTransIdTo	To transaction	String	20
InventTransOriginIdSupply	Marked inventory transaction originator	RecId
ItemId	Item number	String	20
ItemSetId	ItemSetId	Guid
LineNum	Line number	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TransDateTime	Transaction time	Date time
WorkHasReservation	Reserve work	Enum
WorkId	Work ID	String	20

WHSWorkLineHistory (Archived work line records)

Name	Label	Type	Length
ActualTime	Actual time	Real
AllocatedWMSLocationId	Proposed location	String	10
AskForNewLicensePlate	Ask for new license plate	Enum
AvailPhysical	Available physical	Real
ContainerId	Container ID	String	25
createdDateTime	Created date and time	Date time
createdTransactionId	Created ID	Big integer
EstimatedTime	Estimated time	Real
ExtraInventHandlingQty	Extra inventory quantity	Real
FEFOBatchId	FEFO batch ID	String	20
InventDimId	Dimension number	String	20
InventoryTransactionOriginId	Warehouse inventory transaction origin id	Guid
InventQtyRemain	Inventory quantity remaining	Real
InventQtyWork	Inventory work quantity	Real
InventTransId	Lot ID	String	20
InventTransOriginIdSupply	Marked inventory transaction originator	RecId
IsAnchored	Anchored	Enum
ItemId	Item number	String	20
ItemSetId	ItemSetId	Guid
ItemSetIdNoBelowLocDim	ItemSetIdNoBelowLocDim	Guid
LineNum	Line number	Real
LoadId	Load ID	String	20
LoadLineRefRecId	Reference load line id	RecId
LocatedLPId	Located license plate ID	String	25
Mandatory	Mandatory	Enum
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderCommittedInventDimId	Dimension number	String	20
OrderNum	Order number	String	20
OrigPackingWorkTargetLicensePlateId	License plate	String	25
OutboundSortPosition	Reference	RecId
QtyRemain	Remaining quantity	Real
QtyWork	Work quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplenDemand	Needs replenishment	Enum
ShipmentId	Shipment ID	String	20
Skipped	Skipped	Enum
sortCode	Sort code	Integer
UnitId	Unit	String	10
UserId	User ID	String	10
WMSLocationId	Location	String	10
WorkClassId	Work class ID	String	10
WorkClosedUTCDateTime	Closed work	Date time
WorkCreationFailedOnReservation	Reservation failed	Enum
WorkId	Work ID	String	20
WorkInProcessUTCDateTime	Work in process	Date time
WorkStatus	Work status	Enum
WorkStop	Stop transaction	Enum
WorkTemplateLineRecId	Reference	RecId
WorkType	Work type	Enum
WorkTypeCustomCode	Custom work type	String	20
ZoneId	Zone ID	String	20

WHSWorkTableHistory (Archived work table records)

Name	Label	Type	Length
ActualTime	Actual time	Real
AutoExecute	Automatically process	Enum
CancelReplenWhenDemandCanceled	Cancel replenishment if demand has been canceled	Enum
ClusterProfileId	Cluster profile ID	String	20
CombinedWorkId	Combined work ID	String	20
ContainerId	Container ID	String	25
createdDateTime	Created date and time	Date time
CycleCountPlanOverview	Reference	RecId
DispositionCode	Disposition code	String	20
EstimatedTime	Estimated time	Real
ExecutedWithoutUserLocation	ExecutedWithoutUserLocation	Enum
Frozen	Blocked wave	Enum
HasWorkLineLoadLineDetails	Has Work line Load line details	Enum
ImmediateReplenishmentUnitId	Unit	String	10
InventJournalId	Journal	String	20
InventLocationId	Warehouse	String	10
InventoryAdjustmentJournalId	Warehouse inventory adjustment journal	String	20
InventoryTransactionMechanism	Warehouse inventory transaction mechanism	Enum
InventQualityOrderId	Quality order	String	20
InventSiteId	Site	String	10
IsGTDIssueSupport_RU	IsGTDIssueSupport_RU	Enum
IsPartialCycleCountWork	Partial cycle count	Enum
ITMGoodsInTransitId	Goods in transit number	String	20
ITMRegisteredLicensePlateId	Target license plate ID	String	25
LoadId	Load ID	String	20
LockedUser	Locked by	String	10
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
OrderNum	Order number	String	20
PackingWorkRemainingQtyCalculationMechanism	PackingWorkRemainingQtyCalculationMechanism	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
ReplenishmentDependentWorkBlockingPolicy	Block work for replenishment	Enum
ShipmentId	Shipment ID	String	20
TargetLicensePlateId	Target license plate ID	String	25
TransTxt	Description	String	60
UserManuallyAssigned	Manually assigned user	Enum
UseWorkForWaveReplen	Allow wave demand to use unreserved quantities	Enum
WarehouseInventoryTransactionGroupingMechanism	WarehouseInventoryTransactionGroupingMechanism	Enum
WaveId	Wave ID	String	20
WorkBuildId	Work creation number	String	20
WorkCancelledByUser	Canceled by user	String	20
WorkCancelledUTCDateTime	Canceled work	Date time
WorkClosedUTCDateTime	Closed work	Date time
WorkCountError	Work error message	String	30
WorkCreatedBy	User ID	String	20
WorkCreationFailedOnReservation	Reservation failed	Enum
WorkId	Work ID	String	20
WorkInProcessUTCDateTime	Work in process	Date time
WorkIsMultiSKU	Multiple SKU	Enum
WorkManuallyCompletedBy	Manually completed by	String	20
WorkPoolId	Work pool ID	String	20
WorkPriority	Work priority	Integer
WorkStatus	Work status	Enum
WorkTemplateCode	Work template	String	20
WorkTransType	Work order type	Enum

WHSWorkTablePostProcess (Work post processing)

Name	Label	Type	Length
LineType	Line type	Enum
RecId	Record-ID	RecId
recVersion	Record Version	Integer
Status	Line status	Enum
WorkId	Work ID	String	20

WHSWorkTransHistory (Archived work trans records)

Name	Label	Type	Length
InventDimId	Dimension number	String	20
InventTransId	Lot ID	String	20
ItemId	Item number	String	20
LineNum	Line number	Real
modifiedBy	Modified by	String	20
modifiedDateTime	Modified date and time	Date time
Qty	Quantity	Real
RecId	Record-ID	RecId
recVersion	Record Version	Integer
TargetLicensePlateId	Target license plate ID	String	25
TransDateTime	Transaction time	Date time
UOM	Unit	String	10
UserId	User ID	String	10
WorkId	Work ID	String	20
WorkTransId	Work transaction ID	String	20