Inventory 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
   [timestamp]
   ,[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]

Show/hide columns in Inventory Posting Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Location Code Primary Key Searchnvarchar(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]
3Invt_ Posting Group Code Primary Key Searchnvarchar(40)
4Inventory Account Searchnvarchar(40)
5Description Searchnvarchar(200)
6View All Accounts on Lookup Searchtinyint
7Inventory Account (Interim) Searchnvarchar(40)
8WIP Account Searchnvarchar(40)
9Material Variance Account Searchnvarchar(40)
10Capacity Variance Account Searchnvarchar(40)
11Mfg_ Overhead Variance Account Searchnvarchar(40)
12Cap_ Overhead Variance Account Searchnvarchar(40)
13Subcontracted Variance Account Searchnvarchar(40)
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Inventory Posting Setup table

Leave a Reply

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