List of D365FO entities

 


List of D365FO entities


1099 fields
Accepted currencies
Account structure activation
Account structure allowed values
Account structure relationships
Account structures
Account structures - active only
Account structures - draft only
Accountants
Accounting export result
Accounting export result line
Accounts for automatic transactions
Accrual basis earnings
Accrual schemes
Activate purchase prices and discounts
Activate sales prices and discounts
Additional BAS reconciliation account
Additional BAS report boxes
Additional sales tax report boxes
Advance holder groups
Advance invoice items
Advance report
Advanced rule criteria
Advanced rule structure activation
Advanced rule structure allowed values
Advanced rule structures
Advanced rule structures - active only
Advanced rule structures - draft only
Advanced rules
Affiliations for transactions
Aggregation parameters of payment schedule journals
Aging period definitions
Alcohol activity kinds
Alcohol production types
Allowance rate
Amendments to published requests for quotations
Applicant certificate competency
Applicant course competency
Applicant education competency
Applicant exam competency
Applicant position of trust competency
Applicant professional experience competency
Applicant project experience competency
Applicant skill competency
Application basket
Application bookmarks
Application email templates
Areas of responsibility
Asset undepreciated balance schedule
Assortment
Assortment channel lines
Assortment lookup channel group
Assortment product lines
Attachments
Attribute enumerate values
Attribute group
Attribute metadata
Auto tax header
Auto tax priority
Automatic purchase document charges
Automatic purchase document line charges
Automatic return disposition code charges
Automatic return reason code charges
Automatic sales document charges
Automatic sales document delivery charges
Automatic sales document line charges
Automatic sales document line delivery charges
Balance control accounts
Balance sheet definition
Bank account disbursements
Bank account trap
Bank accounts
Bank facility agreements
Bank facility groups
Bank facility types
Bank groups
Bank journal header
Bank journal line
Bank parameters
Bank positive pay transaction table
Bank posting profiles
Bank rules for payment fee
Bank statement account statement
Bank statement cash balance
Bank statement document
Bank statement format
Bank statement import methods for general journal
Bank statement report entry
Bank transaction groups
Bank transaction type
Banked tender transactions
Bar code mask
Bar code mask characters
Bar code mask segment
BAS fringe benefit reason codes
BAS PAYG reason codes
Batch attributes
Batch dispositions
Batch order by-products
Batch order co-products
Batch order formula lines
Batch orders
Benefit
Benefit accounting rule
Benefit accrual earning code
Benefit accrual plan
Benefit accrual rate
Benefit calculation rate detail
Benefit calculation rate header
Benefit earning basis
Benefit eligibility overrides
Benefit eligibility rules
Benefit external reporting
Benefit option
Benefit plan
Benefit plan default dimension
Benefit type
BI_ContractInvoiceSchedule
BI_CustomerTrans
BI_CustomerTransOpen
BI_OrderHeader
Bill of exchange layout
Bill of materials headers
Bill of materials headers and versions
Bill of materials journal names
Bill of materials lines
Bill of materials parameters
Bill of materials version document attachments
Bill of materials versions
BLWI country/region groups
BLWI currencies
BLWI parameters
BLWI transaction
Book shift depreciation
Broker differential reason codes
Budget account entries
Budget allocation term
Budget codes
Budget control configuration
Budget control configuration activation
Budget control cycle model
Budget control dimension attribute
Budget control documents and journals
Budget control group
Budget control group criteria
Budget control group over budget permissions
Budget control message level
Budget control over budget permissions
Budget control rule
Budget control rule criteria
Budget control rule over budget permissions
Budget cost elements
Budget cycle time span
Budget dimensions
Budget models
Budget parameters
Budget plan allocation schedules
Budget plan alternate layouts
Budget plan column rules
Budget plan columns
Budget plan layout elements
Budget plan parameter
Budget plan priorities
Budget plan priority constraint
Budget plan process
Budget plan process administration
Budget plan proposed asset
Budget plan proposed project
Budget plan scenarios
Budget plan stage allocations
Budget plan stage rule
Budget plan stages
Budget plan workflow stage
Budget planning process milestone
Budget plans
Budget revenue classification
Budget submodels
Budget transfer rules
Bundled jobs time allocation keys
Business classification of parties
Business classifications
Business segments
Business subsegments
Buyer groups
Buyers push
Buyers push line quantities
Buyers push lines
Cache table for policy violations on an expense line
Calculation frequency
Calculation frequency pay period
Calculation groups
Call center channel
Campaign cancellation reason codes
Campaign creation policies
Campaign email templates
Campaign groups
Campaign media types
Campaign targets
Campaign types
Capabilities
Card affiliation tier
Cash accounts
Cash advance accounts
Cash advances
Cash balance
Cash balance control for cash flow management journal name.
Cash declaration setup
Cash discount
Cash flow management payment priority.
Cash flow management payment request type.
Cash flow management payment schedule journal name.
Cash generating unit
Cash posting profiles
Cash receipts
Cash symbols
Catalog
Catalog channels
Catalog internal organization product attribute value
Catalog internal organization product attribute values - Version 2
Catalog price groups
Catalog product attribute value
Catalog product categories
Catalog products
Catalog request
Catalog translations
Catch weight item handling policy
Catch weight item handling policy V2
Catch weight tags
Category basic product properties
Category price rule groups
Category price rules
Category retail product properties
Cause of blocking
CDS Contacts
CDS purchase order line entity
CDS sales order headers
CDS sales order lines
CDS sales quotation header
Certificate competency
Certificate type
CGU group
CGU related assets
CGU shared assets allocation
Channel attribute groups
Channel attribute value
Channel category attribute
Channel languages
Channel reports
Channel users
Channel worker
Charges tolerances
Chart of accounts
Check layout
Circulating cards
Classroom groups
Classrooms
CODA - bank accounts
CODA - bank parameters
CODA - transaction
Collection agency fee setup
Collection agency grace period setup
Collection letter form printing configurations
Collection letter setup
Colors
Commerce Data Exchange: Real-time Service profile
Commission calculation
Commission customer group
Commission item group
Commission sales group
Commodity code
Commodity cost basis
Commodity pricing parameters
Commodity pricing templates
Commodity quantity and margin templates
Common data service customer contact persons
Common data service lead contact persons
Common data service product categories
Common data service product category assignments
Common data service vendor contact persons
Company chains
Compatible inventory profiles
Compensation fixed action table
Compensation fixed plan
Compensation job function
Compensation job type
Compensation merit increase target
Compensation pay frequency
Compensation performance allocation
Compensation performance allocation lines
Compensation performance plan
Compensation performance rating
Compensation plan eligibility rules
Compensation process table
Compensation regions
Compensation survey companies
Compensation variable plan
Compensation variable type
Compensation vesting rules
Complimentary closings
Configuration groups
Configurations
Consignment replenishment order headers
Consignment replenishment order lines
Consolidated invoice for customer
Consolidated invoice for vendor
Consolidation groups and accounts
Constraint-based product configuration model parameters
Continuity plan setup
Contribution and deduction limit of enrolled benefits
Cost flow assumption policies
Cost group profit percentages
Cost groups
Costing sheet node calculation factors
Costing sheet nodes and absorption basis
Costing versions
Counting groups
Coupon codes
Coupon discount
Coupon Usage
Coupons
Course competency
Course groups
Course instructors
Course locations
Course participants
Course type - certificates
Course type - education
Course type - skills
Course types
Courses
Covered beneficiary relationship
Covered dependent relationship
Credit card category codes
Credit card itemizations
Credit card transactions
Credit memo table
Criteria based picking workbench profiles
Cross dock
Cross dock line quantities
Cross dock lines
Currency exchange rate types for sales tax
Custom properties on destinations
Customer account statement form printing configurations
Customer address book
Customer Affiliations
Customer aged balances
Customer bank accounts
Customer charge groups
Customer classification groups
Customer definitions
Customer details
Customer facing form printing configurations
Customer free text invoice
Customer groups
Customer invoice journal header
Customer invoice journal line
Customer ledger accounts
Customer method of payment bank accounts
Customer parameters
Customer payment fee
Customer payment format
Customer payment journal fee
Customer payment journal header
Customer payment journal line
Customer payment journal line settled invoice
Customer payment method
Customer payment method specification
Customer payments
Customer postal addresses
Customer posting profiles
Customer reasons
Customer rebate agreement headers
Customer rebate agreement lines
Customer rebate agreement products
Customer rebate groups
Customer reference
Customer specific item batch attributes
Customer write-off reason codes
Customers
Customers V2
Data management
Data sources for payment schedule journals
Data validation checklist
Data validation project task
Data validation task area
Data validation task status
DataManagementTemplateDetailEntity
DataManagementTemplateEntity
DataManagementTemplateSourceDependencyEntity
DataManagementTemplateSourceEntity
Date intervals
Decision making roles
Default lean production flows
Default order settings
Deferred line
Definition group line entity
Definition group template header
Definition Groups
Delegate
Delivery charges groups
Delivery mode address lines
Delivery mode channel lines
Delivery mode product lines
Delivery Modes
Demand forecast entries
Demand forecast V2
Denominations
Depreciation rate schedule
Destination address delivery mode transportation time
Destination address transportation time
Destination based tax configurations table
Destination code
Destination warehouse delivery mode transportation time
Destination warehouse transportation time
Diagnosis areas
Diagnostic types
Dialog setup
Dimension attribute activation
Dimension matrix
DIOT concept tax code
Direct mailing categories
Direct mailing category items
Discount rate
Discount transactions
Discount validation period
Discussion types
Dispatch teams
Display fields
Disposable income definition
Disposable income definition - Benefit
Disposable income definition - Earning
Disposition code
DMF data project execution
Due date limits
Earning code
Earning code accounting rule
Earning code default dimension
Earning code detail
Earning code group
Earning code group earning code
Earning code related to worker and position
Earning external reporting
Earnings statement header
Earnings statement lines
Education and discipline category associations
Education competency
Education degree
Education discipline categories
Education disciplines
Electronic ICP declaration
Electronic OB declaration
Electronic tax certificates
Electronic tax declaration log
Electronic tax declaration parameters
Electronic tax declaration servers
Electronic tax declaration setup
Electronic tax error messages
Email categories
Email groups
Employee address book
Employee credit cards
Employee fixed compensation
Employee variable compensation enrollment
Employee variable compensation enrollment overrides
Employer tax region
Employment job functions
Employment term
End of day report
Entities for a processing group
Error codes
Ethnic origins
EU sales list
Exchange rate calculation rules for sales tax
Expedite codes
Expense and travel policy rule
Expense anticorruption translations
Expense category
Expense credit card type
Expense employee mapping
Expense fields visibility
Expense management parameters
Expense payment details
Expense payment method
Expense policy translations
Expense purpose for transactions
Expense purposes
Expense rate
Expense subcategory
Expense tax recovery configuration
Expense valid payment methods
Expenses
Export confirmation period
External item description customer groups
External item description vendor groups
External item descriptions for customers
External item descriptions for vendors
Externally maintained customer sales invoice headers
Externally maintained customer sales invoice lines
Factory gate
Features
Fee forecast
Financial dimension format
Financial dimension sets
Financial dimension value legal entity overrides
Financial dimensions
Financial period close template tasks
Financial reasons
Fiscal calendar
Fiscal calendar period
Fiscal document texts by customer
Fiscal document texts by product
Fiscal document texts by vendors
Fiscal LIFO journal tables
Fiscal LIFO reporting group
Fiscal register configurations
Fiscal transactions
Fixed asset acquisition method
Fixed asset activity codes
Fixed asset allocation rule lines
Fixed asset allocation rules
Fixed asset book
Fixed asset book setup
Fixed asset book setup derived book
Fixed asset book shift depreciation
Fixed asset book V2
Fixed asset condition
Fixed asset consumption factors
Fixed asset consumption units
Fixed asset depreciation profile manual schedules
Fixed asset depreciation profiles
Fixed asset equipment group
Fixed asset group book setup
Fixed asset group/book special depreciation allowance
Fixed asset groups
Fixed asset inventory to fixed asset transfer journal names
Fixed asset journal
Fixed asset locations
Fixed asset major type
Fixed asset parameters
Fixed asset posting profile
Fixed asset posting profile disposal
Fixed asset properties
Fixed asset property groups
Fixed asset provision types
Fixed asset retirement obligation
Fixed asset retirement obligation document
Fixed asset source types
Fixed asset special depreciation allowance setup
Fixed asset statement rows
Fixed assets
Fixed assets location transfer history entity
Fixed product options
Forecast models
Forecast position budget purpose account details
Forecast sub models
Foreign trade parameters
Form W2 Box reporting adjustment
Formula by-products
Formula co-products
Formula headers
Formula headers and versions
Formula line consumption intervals
Formula line consumption intervals V2
Formula lines
Formula lines V2
Formula version document attachments
Formula versions
Free text invoice form printing configurations
Full text index fields
Garnishment and tax levy details
Garnishment and tax levy rules
Gate entry
Gate entry line
GB/T 24589 parameters
General journal
General journal account entry
Gift card table
Global address book party relationships
Goal headings
Goals
Group of employees for project expense policy purposes
Hardware profile merchant info
Hardware stations
Historical external demand
Hotel
Hotel for course
Human resources parameters
Identification
Identification type
Import invoice numbers
Imported budget entries
Imported cost element dimension members
Imported cost object dimension members
Imported general ledger entries
Imported statistical dimension members
Imported statistical measures
Inbound queue entity
Include/exclude catalog
Include/exclude items
Income/expense account
Income/Expense transaction
Indirect Activity Categories
Indirect cost component
Indirect cost component group assignment rules
Indirect cost component groups
Inflation adjustment B-10
Info code groups
Info code table assignments
Info code transactions
Info code translation
Info codes
Info subcode translation
Injury and illness body parts
Injury and illness cost types
Injury and illness outcome types
Injury and illness severity levels
Injury and illness treatment types
Injury and illness types
Injury or illness costs
Injury or illness filings
Injury or illness incidents
Injury or illness treatments
INPC rates
Instance value of a customer.
Institution
Integration type
Intercompany accounting
Intercompany procurement policies
Intercompany procurement value mappings
Intercompany sales policies
Intercompany sales value mappings
Intercompany trading partnership
Interest codes
Interest codes with fees
Interest codes with ranges
Interest note form printing configurations
Interest types
Internal organization attribute group
Internal organization product attribute value
Internal organization product attribute values - Version 2
INTERVAT setup
INTERVAT tax declaration
Intrastat
Intrastat code
Intrastat to PRODCOM conversion
IntrastatCountryRegionParameterEntity
Inventory accounting KPI goals
Inventory adjustment headers
Inventory adjustment journal headers and lines
Inventory adjustment journal names
Inventory aisle
Inventory charge codes
Inventory counting journal headers
Inventory counting journal lines
Inventory counting journal names
Inventory dimensions parameters
Inventory movement headers
Inventory movement journal headers and lines
Inventory movement journal names
Inventory on-hand by site
Inventory on-hand by warehouse
Inventory on-hand by warehouse and inventory status
Inventory ownership change journal names
Inventory parameters
Inventory profile - posting profile
Inventory profiles
Inventory tag counting journal names
Inventory transaction combinations
Inventory transfer journal names
InventSiteGateEntity
Invoice totals tolerance setup
ISR Concepts setup
ISR rate table
Italian domestic tax transactions reports
Italian sales tax book sections
Italian sales tax books
Item - bar code
Item allocation keys
Item allocation lines
Item arrival journal headers
Item arrival journal lines
Item arrival journal names
Item batch attribute group attribute assignments
Item batches
Item charge groups
Item groups
Item model group inventory policies
Item price tolerance groups
Item quality groups
Item rebate groups
Item sampling
Item serial numbers
Item storage dimension group change request
JmgSiteSpecificManufacturingExecutionProductionOrderDefaultsEntity
Job - areas of responsibility
Job - certificates
Job - education
Job - screening
Job - skills
Job - tests
Job - work tasks
Job card production journal entries
Job runs
Job tasks
Job template - areas of responsibility
Job template - certificates
Job template - education
Job template - screening
Job template - skills
Job template - work tasks
Job template test
Job templates
Journal descriptions
Journal names
Keyboard mapping
Keyboard mapping groups
Kinds of by-product
Kit orders
Label generation
Label report setup
Labor union agreement
Labor unions
Language codes
Language text
Lasernet attachments and document handling
Lasernet Azure On-premises user mapping
Lasernet custom ports
Lasernet custom properties
Lasernet custom properties on destinations
Lasernet email bodies
Lasernet file formats
Lasernet language text
Lasernet naming patterns
Lasernet network printers
Lasernet overlay files
Lasernet overlay sets
Lasernet overlay type setup
Lasernet parameters
Lasernet printer profiles
Lasernet printers
Lasernet quick destinations
Lasernet related sources
Lasernet related sources fields
Lasernet report destinations
Lasernet report dialog setup
Lasernet report element
Lasernet report forms
Lasernet report identification helper
Lasernet reports
Lasernet servers
Lead priorities
Lead processing policies
Lead ratings
Lead types
Leads
Lean production flow models
Lean production flows
Lean schedule allocation keys
Lean schedule groups
Lean schedule items
Ledger allocation for main accounts
Ledger budgets and forecasts workspace parameters
Ledger fiscal calendar period
Ledger fiscal calendar year
Ledger journal table
Ledger parameters
Ledger posting definition for inventory
Ledger posting definition for procurement
Ledger posting definition for production
Ledger posting definition for sales
Ledger posting definition for standard cost variance
Ledger statement definition
Legal entities for payment schedule journals
Legal entity inventory owners
Line discount customer groups
Line discount item groups
Line discount vendor groups
Line of business
Linked product
Liquidity accounts
Liquidity dependent accounts
Loan
Loan items
Loan types
Loyalty card
Loyalty levels
Loyalty line transactions
Loyalty price groups
Loyalty program
Loyalty program translations
Loyalty redeem lines
Loyalty reward point transaction
Loyalty reward points
Loyalty scheme channels
Loyalty schemes
Loyalty tier
Loyalty tier price groups
Loyalty tier translation
Loyalty transaction
Main account
Main account categories
Main account legal entity overrides
Main account totaling account intervals
Main account translation
Manual premiums
Manufacturing execution production order defaults
Manufacturing execution production order defaults by site
Manufacturing execution production parameters
Marketing mail policies
Material handling equipment interface parameters
Matrix account
MCRCouponSalesOrderEntity
MCRCustomerCreditPaymentEntity
MCRCustomerInvoicePaymentEntity
MCRInstallmentPlanCustomerPaymentEntity
MCRSalesOrderCustomerPaymentEntity
Media
Media and master relations
Media resources
Media types
Merchandising event categories
Merchant
Mileage rate tiers
Mix and match line group setup
Mix and match line groups
Mixed reality guides entity
Modes of delivery
Multiline discount customer groups
Multiline discount item groups
Multiline discount vendor groups
Navigation Hierarchy
Nonconformance charge types
Nonconformance operation categories
Offline profile
Online store payment connectors
Open purchase line discount journal lines
Open purchase multi line discount journal lines
Open purchase price journal lines
Open purchase total discount journal lines
Open sales line discount journal lines
Open sales multi line discount journal lines
Open sales postage discount journal lines
Open sales price journal lines
Open sales total discount journal lines
Operations
Operations resource
Operations resource capability assignment
Opportunity maintenance policies
Opportunity probability rates
Opportunity reason codes
Opportunity source type options
Opportunity source types
Options
Order entry deadline groups
Order entry deadline parameters
Organizations for default retail assortment organization hierarchy
Origin payment codes
Outbound queue
PAC Combination item product
PAC Product combination
PAC Products
Package lines
Package table
Packages on purchase orders
Packaging box types
Packing material allocation lines
Packing material allocations
Packing material codes
Packing material fees
Packing material groups
Packing slip form printing configurations
Packing slip tracking information
Pay agreement exceptions
Pay agreement lines
Pay agreements
Pay cycle
Pay period
Pay statement benefit lines
Pay statement earning lines
Pay statement header
Pay statement tax lines
Pay types
Payment benefit accrual balance
Payment calendar
Payment calendar exception
Payment calendar rule
Payment card numbers
Payment card types
Payment day lines
Payment deduction types
Payment deduction write off reason code
Payment format code sets
Payment ID
Payment instruction
Payment methods
Payment order requisites for purchase agreements
Payment order requisites for sales agreements
Payment orders' statuses
Payment purpose codes
Payment schedule
Payment schedule lines
Payment transactions
PaymentOrderTypeEntity
Payments accounts of payment schedule journals
PaymTransCodesEntity
Payroll details for positions
Payroll Earning Statement Import
Payroll parameter
Payroll positive pay
Payroll premium earning policy rule type
Payroll tax accounting rule
Payroll tax code default dimension
Payroll tax code details
Payroll tax code header
Payroll tax external reporting
Payroll tax group
Payroll tax group code
Payroll tax transaction history
Pending and active item prices
Pending item prices
Pending route cost category unit costs
Per diem locations
Per diems
Performance journal
Performance journal source type
Performance period
Performance praise
Performance reviews
Period allocation categories
Periodic discount
Periodic discount line
Permissions
Person details
Person exam
Personal character types
Personnel action type roles
Personnel action types
Picking list form printing configurations
Piecework group members
Piecework groups
Planned time and attendance absence registrations
Policy violation justifications
Policy violations log
Port
POS button grid
POS button grid buttons
POS functionality profile
POS hardware profiles
POS layout images
POS operations
POS permission group
POS permission groups
POS permissions by position
POS registers
POS screen layout button grid zones
POS screen layout image zones
POS screen layout report zones
POS screen layout zones
POS screen layouts
POS seed data
POS skins
POS visual profiles
Position of trust competency
Position union agreement
Posting definition
Posting definition entry
Premium code
Price customer groups
Price point group
Price points
Price tolerance setup
Price vendor groups
Print layout
Printed form notes
Process results
Procurement catalog categories
Procurement catalog products
Procurement catalogs
Procurement category policies
Procurement charge codes
Procurement form sorting parameters
Procurement product category information page assignments
Procurement product category item sales tax group assignments
Procurement product category properties
Procurement product category questionnaire assignments
Procurement product category vendor assignments
Procurement product category vendor evaluation criterion group assignments
Procurement return actions
Procurement type document default values
Procurement type document entry policies
Procurement type document processing policies
PRODCOM
PRODCOM parameters
Product attribute enumeration type translations
Product attribute enumeration types
Product attribute group attribute assignments
Product attribute group translations
Product attribute metadata per channel
Product attribute translations
Product attribute value types
Product attribute values
Product attributes
Product categories
Product category assignments
Product category attributes
Product category category attribute group assignments
Product category commodity codes
Product category hierarchies
Product category hierarchy roles
Product category hierarchy translations
Product category information page translations
Product category information pages
Product category product attribute group assignments
Product category translations
Product color group line translations
Product color group lines
Product color groups
Product compliance parameters
Product configuration model versions
Product configuration models
Product default order settings
Product dimension groups
Product document attachments
Product entity attribute value entity
Product features
Product global trade item number assignments
Product kit
Product kit order journals
Product label setup
Product labels
Product master color translations
Product master colors
Product master configuration translations
Product master configurations
Product master size translations
Product master sizes
Product master style translations
Product master styles
Product parameters
Product receipt form printing configurations
Product relationship type translations
Product relationship types
Product relationships
Product section location
Product size group line translations
Product size group lines
Product size groups
Product specific item batch attributes
Product style group line translations
Product style group lines
Product style groups
Product translations
Product variants
Production bill of materials lines
Production control parameters
Production control parameters by site
Production groups
Production input journal names
Production journal names
Production order route job entity
Production order sequencing group lines
Production order sequencing groups
Production Order Sequencing Sequence Items
Production order sequencing sequence values
Production order sequencing sequences
Production orders
Production pools
Production route operations
Production units
Products
Products V2
Professional experience competency
Project - expense cost price
Project - expense sales price
Project - fee sales price
Project - hour cost price
Project - hour sales price
Project allocation key details
Project allocation keys
Project category
Project category group
Project contract
Project cost template
Project cost template line categories
Project cost template lines
Project customer retention term
Project customer retention term schedule
Project default offset accounts for expenses
Project expense forecasts
Project expense journal header
Project expense journal lines
Project expense policies
Project expense policy worker groups
Project experience competency
Project form setup
Project funding rule
Project funding source
Project general settings for collaboration workspaces
Project grant frequency
Project grant matching
Project grant type
Project grant type frequency
Project grantor type
Project grants
Project groups
Project hour forecasts
Project hour journal lines
Project hour journals
Project inventory consumption journal names
Project inventory dimensions for item consumption
Project invoice proposal
Project invoice proposal line - expense
Project invoice proposal line - hour
Project item forecasts
Project item journal header
Project item journal lines
Project item requirements
Project journal approval
Project journal approval details
Project journal description
Project journal lines for cost/sale beginning balances
Project journal lines for fee beginning balances
Project journal lines for on account beginning balances
Project journal names
Project ledger posting definition
Project line properties
Project line property
Project on-account forecasts
Project parameters
Project periods - employee
Project report sort fields
Project resource
Project resource default role setup
Project resource role
Project resource/category validation group
Project resource/category validation group lines
Project resource/project validation group
Project scheduling resource
Project scheduling resource details
Project stage
Project stage rule settings
Project timesheet weekly periods
Project transfer price
Project vendor contract language
Project vendor retention term
Project vendor retention term schedule
Project/category validation group
Project/category validation group lines
Projects
ProjValEmplProjSetupEntity
Promissory note layout
Promotion management fund customers
Promotion management fund usages
Promotion management marketing objectives
Promotion management payment deduction denial reasons
Prospect creation policies
Prospect relation types
Prospect statistics default values
Prospect statuses
Prospects
Published requests for quotations
Published requests for quotations and reply lines detail
Published requests for quotations delivery and payment details
Published requests for quotations header attachments
Published requests for quotations line
Purchase agreement classification
Purchase agreement classification translation
Purchase agreement form printing configurations
Purchase agreement lines
Purchase agreements
Purchase duty
Purchase duty transactions
Purchase inquiry form printing configurations
Purchase line update parameters
Purchase order charges
Purchase order form printing configurations
Purchase order headers V2
Purchase order line charges
Purchase order lines
Purchase orders
Purchase pools
Purchase requisition business justifications
Purchase requisition consumption category access policies
Purchase requisition form printing configurations
Purchase requisition lines
Purchase requisition maintenance delegations
Purchase requisition procurement catalog policies
Purchase requisition purpose policies
Purchase requisition replenishment access policies
Purchase requisition worker legal entity authorizations
Purchase requisition worker operating unit authorizations
Purchase requisitions
Purchase summary update parameters
Quality groups
Quality order creation policies
Quality order creation policies V2
Quality order line
Quality order line results
Quality orders
Quality test instruments
Quality test variable outcomes
Quality test variables
Quality tests
Quantity discount configuration
Quarantine zones
Quotation document conclusions
Quotation document introductions
Quotation document titles
Quotation prognosis
Quotation template groups
Quotation type
Rating level
Rating models
RB/SL factors
Reason codes
Reason of delivery
Rebate module parameters
Receipt format
Receipt list form printing configurations
Receipt numbering
Receipt profile
Receipt profile line
Reconciliation matching rule sets
Reconciliation matching rules
Reconciliation parameters
Recruitment media
Recruitment projects
Reduction entry document
Reference between info code group and info codes
Refund check authorization transaction
Refund check settlement transaction
Refund method setup
Regulated products
Regulated products regional lists
Regulatory establishment details
Regulatory establishments
Related sources
Related sources, relation fields
Released product creation
Released product creation V2
Released product document attachments
Released product variants
Released product warehouse defaults
Released products
Repair stages
Replenishment rule lines
Replenishment rules
Reply line summary of published requests for quotations
Report as finished production journal entries
Report Destinations
Report structure
Reporting agencies
Reports
Request for quotation form printing configurations
Request for quotation reply statuses
Request for quotation scoring method criteria
Request for quotation scoring methods
Request for quotation solicitation types
Resolutions
Resource calendar assignments
Resource group calendar assignments
Resource group membership
Resource groups
Resource parameters
Resource parameters by site
Resource requirements for route operation properties
Resource role characteristics
Restricted products
Restricted products regional lists
Restriction type for voucher
Retail affiliation price groups
Retail affiliation translations
Retail affiliations
Retail channel
Retail channel price groups
Retail channel reports configuration
Retail device types
Retail devices
Retail discount price groups
Retail event notification profile
Retail event notification setting
Retail Headquarters parameters
Retail info code lines
Retail internal organization products
Retail internal organizations
Retail Job POSPermission Group
Retail kit component sales price
Retail kit component substitute charge amount
Retail Kit Component Substitutes
Retail kit components
Retail Kit Configurations
Retail locator group member
Retail locator group owner
Retail locator groups
Retail loyalty scheme earn line
Retail loyalty tier rules
Retail online channel
Retail product media relationship
Retail register custom field
Retail Report POS permission groups
Retail reports localized strings
Retail shared Bing Maps parameters
Retail shared Bing parameters
Retail shared Facebook application parameters
Retail shared parameters
Retail shared Twitter application parameters
Retail staff
Retail store address book
Retail stores to deploy
Retail Transaction Address
Retail Transaction charges
Retail translations
Retail trial user
RetailCouponEntity
RetailDeliveryModeEntity
RetailNotificationSubscriptionsEntity
RetailPeriodCodeEntity
RetailPosBatchEntity
RetailPositionNotificationSubscriptionsEntity
RetailStoreSectionEntity
RetailStoreWorkShiftTranEntity
RetailTillLayoutConfigurationEntity
RetailWorkShiftSetupEntity
Retirement Benefit Plan Detail US
Return location
Return Policy Line
Return reason code groups
Return reason codes
Revaluation groups for fixed assets
Revenue allocation prices
Revenue schedules
Reverse charge sales list
Review impairment indicators
Reward point translation
Rounding method
Rounding method group
Route card production journal entries
Route cost category
Route groups
Route headers
Route operation properties
Route operation properties V2
Route operations
Route operations V2
Route versions
Safe tender transactions
Sales activity creation policies
Sales agreement classification
Sales agreement classification translation
Sales agreement form printing configurations
Sales charge codes
Sales delivery charge codes
Sales districts
Sales document event tracking setup
Sales form sorting parameters
Sales invoice form printing configurations
Sales invoice headers
Sales invoice lines
Sales order attributes
Sales order charges
Sales order confirmation form printing configurations
Sales order entry deadlines
Sales order headers V2
Sales order hold codes
Sales order line charges
Sales order line update parameters
Sales order lines
Sales order origin codes
Sales order pools
Sales orders
Sales package appearances
Sales price - subscription
Sales price smart rounding version currencies
Sales price smart rounding version rules
Sales price smart rounding versions
Sales product category legal entity defaults
Sales quotation form printing configurations
Sales quotation headers
Sales quotation headers V2
Sales rebate product freight groups
Sales rebate program types
Sales role responsibilities
Sales summary update parameters
Sales tax authorities
Sales tax book status
Sales tax code limits
Sales tax code values
Sales tax codes
Sales tax document set
Sales tax exempt code
Sales tax exempt numbers
Sales tax group details
Sales tax groups
Sales tax hierarchy
Sales tax item groups
Sales tax ledger posting groups
Sales tax ledger posting groups V2
Sales tax override group
Sales tax override group members
Sales tax overrides
Sales tax parameters
Sales tax parameters preset entity
Sales tax period setup
Sales tax reporting codes
Sales TMA customer groups
Sales transactions
Sales type document default values
Sales type document entry policies
Sales type document processing policies
Sales units
SalesOrderLineEntity
SalesRebateProductGroupEntity
Salutations
Screening type
Scripts
Seasons
Sellable released products
Service agreement groups
Service agreement headers
Service agreement lines
Service category
Service intervals
Service level agreement
Service management parameters
Service object groups
Service objects
Service order headers
Service order lines
Service repair conditions
Service stages
Service tasks
Service template groups
Set up calculation for invoice issue due date
Setoff hierarchy profile
Setup basis
Setup of kinds of activity
Shared assets and goodwill
Shifts
Shipment form printing configurations
Shipping bill numbers
Shipping carrier
Shipping carrier service
Signing limit agreement
Signing limit policy parameters
Signing limit revocation reason code
Site current postal addresses
Site dimension link policies
Site specific order settings
Sites
Sizes
Skill competency
Skill types
Skill-mapping - main
Skills
Source code setup
Spanish VAT books
Staff POS screen layouts
Stage reason codes
State 11
State custom declaration numbers
State holiday
Statement of transactions in cash
Statistics group
Statistics groups
Statistics procedure
Storage dimension groups
Store payment card setup
Store payment methods
Store payment methods for POS designer
Store POS screen layouts
Store product attributes
Store section
Store shelves
Store work shift transactions
Store work shifts
Stores
Styles
Subcode
Subscription group
Subscription parameters
Subscriptions
Supplemental hierarchy products by category
Supplementary item - customer groups
Supplementary item - item groups
Supplementary item - vendor groups
Supply forecast entries
Supported country regions
Survey code
Symptom areas
Tax adjustment codes by fiscal document for ICMS
Tax adjustment codes by fiscal document for ICMS and taxation codes
Tax adjustment codes by fiscal document posting definition
Tax adjustment codes for ICMS
Tax adjustment codes for IPI
Tax adjustment codes for PIS/COFINS
Tax adjustment codes posting definition
Tax adjustment observation codes
Tax agent
Tax branch
Tax code parameter value
Tax document
Tax integration import
Tax region
Tax reporting accounts
Tax transactions
Telemarketing cancellation reasons
Template BOMs
Terminal counter
Terms of delivery
Terms of employment
Terms of payment
Test
Test group test assignments
Test groups
The benefit codes in benefit group of the Total compensation statement section
The earning codes of the Total compensation statement section
The tax codes in tax groups of the Total compensation statement section
Threshold discount tiers
Time and attendance and manufacturing execution parameters
Time and attendance approval groups
Time and attendance calculation groups
Time and attendance calculation policies
Time and attendance flex groups
Time and attendance premium registrations
Time and attendance profile groups
Time and attendance profile types
Time and attendance time profile details
Time and attendance time profile lines
Time and attendance time profiles
Time window
Timesheet Headers
Timesheet Lines
TMV Base Sales invoice line - no range, no totals
TMV Sales invoice headers
TMV Sales invoice headers - Integration
TMV Sales invoice headers - no range
TMV Sales invoice line
TMV Sales invoice line - integration
TMV Sales invoice line - no range
TMV Sales invoice line - no range, no totals
TMV Sales order line - Integration
TMVSalesInvoiceLine_WriteBack
TMVSalesOrderHeaderCDSEntity_NoRange
TMVSalesOrderHeaderV2Entity_DMImport
TMVSalesOrderHeaderV2Entity_Integration
TMVSalesOrderHeaderV2Entity_NoRange
Total compensation statement sections header
Total discount customer groups
Total discount vendor groups
Tracking dimension groups
Tracking number groups
Trade agreement journal name
Trade agreement journal table
Trade agreement recalculation policies for purchase documents
Trade agreement recalculation policies for sales documents
Trade allowance agreement periods
Trade allowance management parameters
Transaction category
Transaction code mapping
Transaction codes
Transaction family
Transaction logging policies
Transaction posting definition budget
Transaction posting definition payable
Transaction posting definition purchasing
Transactions
Transfer order headers
Transfer order lines
Transport method
Transportation methods
Travel locations
Travel requisitions
Up-sell/cross-sell variables
Variable compensation level
VAT invoice description
VendCorrectionNoteEntity
Vendor bank accounts
Vendor catalog maintenance requests
Vendor catalog product name and description translations
Vendor catalog product purchase default order settings
Vendor catalog product purchase prices
Vendor catalog product sale prices
Vendor catalog products
Vendor charges group
Vendor evaluation criteria
Vendor evaluation criterion group translations
Vendor evaluation criterion groups
Vendor evaluation criterion translations
Vendor exception groups
Vendor facing form printing configurations
Vendor groups
Vendor inventory owners
Vendor invoice declaration
Vendor invoice document attachment
Vendor invoice form printing configurations
Vendor invoice header
Vendor invoice journal header
Vendor invoice journal line
Vendor invoice line
Vendor invoice register header
Vendor invoice register line
Vendor invoice sub line
Vendor ledger accounts
Vendor method of payment bank accounts
Vendor parameters
Vendor payment fee
Vendor payment fee groups
Vendor payment format
Vendor payment journal fee
Vendor payment journal header
Vendor payment journal line
Vendor payment journal line settled invoice
Vendor payment method
Vendor payment method specification
Vendor postal addresses
Vendor posting profile
Vendor price tolerance groups
Vendor reasons
Vendor rebate group
Vendor rebate parameters
Vendor sales price margin setup
Vendor sales price point setup
Vendor settlement for 1099s
Vendor, form parameters
Vendors
Vendors V2
Veteran status
Voucher type
Warehouse current postal addresses
Warehouse location parameters
Warehouse locations
Warehouses
Withholding tax authorities
Withholding tax code values
Withholding tax codes
Withholding tax component groups
Withholding tax components
Withholding tax group details
Withholding tax groups
Withholding tax limits
Withholding tax report setup
Withholding tax reporting codes
Withholding tax revenue types
Withholding tax settlement periods (India)
Work cycle
Work order document group members
Work order document group types
Work order document groups
Work period
Work shift setup
Worker bank accounts
Worker benefit accrual adjustment
Worker certificate competency
Worker course competency
Worker education competency
Worker enrolled benefit
Worker exam competency
Worker personal contact organization
Worker personal contact person
Worker position default tax region
Worker position of trust competency
Worker professional experience competency
Worker project experience competency
Worker resident tax region
Worker skill competency
Worker store mapping
Worker tax code
Worker tax code V2
Worker tax region
Workers responsible for quality
Working times scheduling properties
Working times scheduling property lines
Yearly tax communication
Zakat assets group
Zakat information
Zakat item codes
Zakat report names



Support Faryal's Cusine


Customer Address book relation for channel Database D365FO


Customer Address book relation for channel Database D365FO



Scenario:

Most of our D365FO Fellow are working with Retail where we sync customer with our channel database, and sometime we need to update the customer from POS as well, Sometime channel DB throw exception when while updating the customer information if AddressBook of the customer  customer is not properly set.

Its happens when we create customer using AX client or import them via DMF and didn't set the address book value.


So no need to worry using below code & query you can update the customers address book in bulk.

Image:




Code:

public void AddrssBookRelation()
    {
        DirAddressBookParty       dirAddressBookParty;
        DirAddressBook                   dirAddressBook;
        CustTable                              custTable;


        select RecId,Party from custTable
            where custTable.AccountNum==this.CustomerAccount;

        if(custTable)
        {
            select RecId from dirAddressBook
            where dirAddressBook.Name==this.CountryCode;

            if(dirAddressBook)
            {
                select RecId from dirAddressBookParty
                    where dirAddressBookParty.Party==custTable.Party && dirAddressBookParty.AddressBook==dirAddressBook.RecId;

                if(dirAddressBookParty.RecId==0)
                {
                    dirAddressBookParty.clear();
                    dirAddressBookParty.Party=custTable.Party;
                    dirAddressBookParty.AddressBook=dirAddressBook.RecId;
                    dirAddressBookParty.insert();
                }

            }
        }

    }



SQL Query:

INSERT INTO DirAddressBookParty (PARTY,ADDRESSBOOK,PARTITION)
select DISTINCT DirPartyLocation.PARTY,DirAddressBook.RECID,5637144576 from LogisticsPostalAddress
join DirPartyLocation on DirPartyLocation.LOCATION=LogisticsPostalAddress.LOCATION
Join LOGISTICSLOCATION on LOGISTICSLOCATION.RECID=LogisticsPostalAddress.LOCATION
join DirAddressBook on DirAddressBook.NAME=LogisticsPostalAddress.COUNTRYREGIONID
where DirPartyLocation.ISPRIMARY=1 and party in (select party from CUSTTABLE)
and LOGISTICSLOCATION.ISPOSTALADDRESS=1 and DirPartyLocation.ISPOSTALADDRESS=1 and DirPartyLocation.POSTALADDRESSROLES='Business'
and not exists (select 1 from DirAddressBookParty where DirAddressBookParty.PARTY=DirPartyLocation.PARTY and DirAddressBookParty.ADDRESSBOOK=DirAddressBook.RECID)
 and LogisticsPostalAddress.VALIDTO >=GETDate()

Support Faryal's Cusine


Virtual Fields Vs Computed Fields

  Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that y...