Inventory Posting Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Posting Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5813

Table Type: Company

Table Name: Inventory Posting Setup
Database Table Name: CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5813

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Inventory Posting Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Location Code]
   ,[Invt_ Posting Group Code]
   ,[Inventory Account]
   ,[Description]
   ,[View All Accounts on Lookup]
   ,[Inventory Account (Interim)]
   ,[WIP Account]
   ,[Material Variance Account]
   ,[Capacity Variance Account]
   ,[Mfg_ Overhead Variance Account]
   ,[Cap_ Overhead Variance Account]
   ,[Subcontracted Variance Account]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Inventory Posting Setup].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[Inventory Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[Inventory Account (Interim)] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[WIP Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[Material Variance Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[Capacity Variance Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [Inventory Posting Setup].[Subcontracted Variance Account] = [G/L Account].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Posting Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Posting Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Posting Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Inventory Posting Setup].[Location Code] = [Location].[Code]
2Invt. Posting Group Code Primary Key SearchInvt. Posting Group CodeNormalCode20Invt_ Posting Group Codenvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Invt_ Posting Group Code]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Inventory Posting Setup].[Invt_ Posting Group Code] = [Inventory Posting Group].[Code]
6Inventory Account Primary Key SearchInventory AccountNormalCode20Inventory Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Inventory Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Inventory Account] = [G/L Account].[No_]
20Description SearchDescriptionNormalText100Descriptionnvarchar(200)
21View All Accounts on Lookup SearchView All Accounts on LookupNormalBoolean4View All Accounts on Lookuptinyint
5800Inventory Account (Interim) SearchInventory Account (Interim)NormalCode20Inventory Account (Interim)nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Inventory Account (Interim)]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Inventory Account (Interim)] = [G/L Account].[No_]
99000750WIP Account SearchWIP AccountNormalCode20WIP Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[WIP Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[WIP Account] = [G/L Account].[No_]
99000753Material Variance Account SearchMaterial Variance AccountNormalCode20Material Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Material Variance Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Material Variance Account] = [G/L Account].[No_]
99000754Capacity Variance Account SearchCapacity Variance AccountNormalCode20Capacity Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Capacity Variance Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Capacity Variance Account] = [G/L Account].[No_]
99000755Mfg. Overhead Variance Account SearchMfg. Overhead Variance AccountNormalCode20Mfg_ Overhead Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Mfg_ Overhead Variance Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Mfg_ Overhead Variance Account] = [G/L Account].[No_]
99000756Cap. Overhead Variance Account SearchCap. Overhead Variance AccountNormalCode20Cap_ Overhead Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Cap_ Overhead Variance Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Cap_ Overhead Variance Account] = [G/L Account].[No_]
99000757Subcontracted Variance Account SearchSubcontracted Variance AccountNormalCode20Subcontracted Variance Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[Subcontracted Variance Account]
	       ,[G/L Account].[No_]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
	              ON
	                     [Inventory Posting Setup].[Subcontracted Variance Account] = [G/L Account].[No_]
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [Inventory Posting Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Inventory Posting Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Inventory Posting Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Inventory Posting Setup table

Location
Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Posting Setup

Leave a Reply

Your email address will not be published. Required fields are marked *