Inventory Setup

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

Table Type: Company

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

Table Number: 313

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 Setup can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Automatic Cost Posting]
   ,[Location Mandatory]
   ,[Item Nos_]
   ,[Automatic Cost Adjustment]
   ,[Prevent Negative Inventory]
   ,[Variant Mandatory if Exists]
   ,[Skip Prompt to Create Item]
   ,[Copy Item Descr_ to Entries]
   ,[Allow Inventory Adjustment]
   ,[Invt_ Cost Jnl_ Template Name]
   ,[Invt_ Cost Jnl_ Batch Name]
   ,[Transfer Order Nos_]
   ,[Posted Transfer Shpt_ Nos_]
   ,[Posted Transfer Rcpt_ Nos_]
   ,[Copy Comments Order to Shpt_]
   ,[Copy Comments Order to Rcpt_]
   ,[Nonstock Item Nos_]
   ,[Use Item References]
   ,[Outbound Whse_ Handling Time]
   ,[Inbound Whse_ Handling Time]
   ,[Expected Cost Posting to G_L]
   ,[Default Costing Method]
   ,[Average Cost Calc_ Type]
   ,[Average Cost Period]
   ,[Allow Invt_ Doc_ Reservation]
   ,[Invt_ Receipt Nos_]
   ,[Posted Invt_ Receipt Nos_]
   ,[Invt_ Shipment Nos_]
   ,[Posted Invt_ Shipment Nos_]
   ,[Copy Comments to Invt_ Doc_]
   ,[Direct Transfer Posting]
   ,[Posted Direct Trans_ Nos_]
   ,[Package Nos_]
   ,[Phys_ Invt_ Order Nos_]
   ,[Posted Phys_ Invt_ Order Nos_]
   ,[Package Caption]
   ,[Item Group Dimension Code]
   ,[Inventory Put-away Nos_]
   ,[Inventory Pick Nos_]
   ,[Posted Invt_ Put-away Nos_]
   ,[Posted Invt_ Pick Nos_]
   ,[Inventory Movement Nos_]
   ,[Registered Invt_ Movement Nos_]
   ,[Internal Movement Nos_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Inventory 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 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Inventory Setup].[Item Group Dimension Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Automatic Cost Posting SearchAutomatic Cost PostingNormalBoolean4Automatic Cost Postingtinyint
3Location Mandatory SearchLocation MandatoryNormalBoolean4Location Mandatorytinyint
4Item Nos. SearchItem Nos.NormalCode20Item Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Item Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Item Nos_] = [No. Series].[Code]
30Automatic Cost Adjustment SearchAutomatic Cost AdjustmentNormalOption4Automatic Cost Adjustmentint
Available options are:
  • “Never”
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Always”
40Prevent Negative Inventory SearchPrevent Negative InventoryNormalBoolean4Prevent Negative Inventorytinyint
45Variant Mandatory if Exists SearchVariant Mandatory if ExistsNormalBoolean4Variant Mandatory if Existstinyint
50Skip Prompt to Create Item SearchSkip Prompt to Create ItemNormalBoolean4Skip Prompt to Create Itemtinyint
51Copy Item Descr. to Entries SearchCopy Item Descr. to EntriesNormalBoolean4Copy Item Descr_ to Entriestinyint
60Allow Inventory Adjustment SearchAllow Inventory AdjustmentNormalBoolean4Allow Inventory Adjustmenttinyint
180Invt. Cost Jnl. Template Name SearchInvt. Cost Jnl. Template NameNormalCode10Invt_ Cost Jnl_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
       [Inventory Setup].[Invt_ Cost Jnl_ Template Name]
       ,[Gen. Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
              ON
                     [Inventory Setup].[Invt_ Cost Jnl_ Template Name] = [Gen. Journal Template].[Name]
181Invt. Cost Jnl. Batch Name SearchJnl. Batch Name Cost PostingNormalCode10Invt_ Cost Jnl_ Batch Namenvarchar(20)
5700Transfer Order Nos. SearchTransfer Order Nos.NormalCode20Transfer Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Transfer Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Transfer Order Nos_] = [No. Series].[Code]
5701Posted Transfer Shpt. Nos. SearchPosted Transfer Shpt. Nos.NormalCode20Posted Transfer Shpt_ Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Transfer Shpt_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Transfer Shpt_ Nos_] = [No. Series].[Code]
5702Posted Transfer Rcpt. Nos. SearchPosted Transfer Rcpt. Nos.NormalCode20Posted Transfer Rcpt_ Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Transfer Rcpt_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Transfer Rcpt_ Nos_] = [No. Series].[Code]
5703Copy Comments Order to Shpt. SearchCopy Comments Order to Shpt.NormalBoolean4Copy Comments Order to Shpt_tinyint
5704Copy Comments Order to Rcpt. SearchCopy Comments Order to Rcpt.NormalBoolean4Copy Comments Order to Rcpt_tinyint
5718Nonstock Item Nos. SearchCatalog Item Nos.NormalCode20Nonstock Item Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Nonstock Item Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Nonstock Item Nos_] = [No. Series].[Code]
5725Use Item References SearchUse Item ReferencesNormalBoolean4Use Item Referencestinyint
5790Outbound Whse. Handling Time SearchOutbound Whse. Handling TimeNormalDateFormula32Outbound Whse_ Handling Timevarchar(32)
5791Inbound Whse. Handling Time SearchInbound Whse. Handling TimeNormalDateFormula32Inbound Whse_ Handling Timevarchar(32)
5800Expected Cost Posting to G/L SearchExpected Cost Posting to G/LNormalBoolean4Expected Cost Posting to G_Ltinyint
5801Default Costing Method SearchDefault Costing MethodNormalOption4Default Costing Methodint
Available options are:
  • “FIFO”
  • “LIFO”
  • “Specific”
  • “Average”
  • “Standard”
5804Average Cost Calc. Type SearchAverage Cost Calc. TypeNormalOption4Average Cost Calc_ Typeint
Available options are:
  • ” “
  • “Item”
  • “Item & Location & Variant”
5805Average Cost Period SearchAverage Cost PeriodNormalOption4Average Cost Periodint
Available options are:
  • ” “
  • “Day”
  • “Week”
  • “Month”
  • “Quarter”
  • “Year”
  • “Accounting Period”
5849Allow Invt. Doc. Reservation SearchAllow Invt. Doc. ReservationNormalBoolean4Allow Invt_ Doc_ Reservationtinyint
5850Invt. Receipt Nos. SearchInvt. Receipt Nos.NormalCode20Invt_ Receipt Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Invt_ Receipt Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Invt_ Receipt Nos_] = [No. Series].[Code]
5851Posted Invt. Receipt Nos. SearchPosted Invt. Receipt Nos.NormalCode20Posted Invt_ Receipt Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Invt_ Receipt Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Invt_ Receipt Nos_] = [No. Series].[Code]
5852Invt. Shipment Nos. SearchInvt. Shipment Nos.NormalCode20Invt_ Shipment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Invt_ Shipment Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Invt_ Shipment Nos_] = [No. Series].[Code]
5853Posted Invt. Shipment Nos. SearchPosted Invt. Shipment Nos.NormalCode20Posted Invt_ Shipment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Invt_ Shipment Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Invt_ Shipment Nos_] = [No. Series].[Code]
5854Copy Comments to Invt. Doc. SearchCopy Comments to Invt. Doc.NormalBoolean4Copy Comments to Invt_ Doc_tinyint
5855Direct Transfer Posting SearchDirect Transfer PostingNormalOption4Direct Transfer Postingint
Available options are:
  • “Receipt and Shipment”
  • “Direct Transfer”
5856Posted Direct Trans. Nos. SearchPosted Direct Trans. Nos.NormalCode20Posted Direct Trans_ Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Direct Trans_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Direct Trans_ Nos_] = [No. Series].[Code]
5860Package Nos. SearchPackage Nos.NormalCode20Package Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Package Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Package Nos_] = [No. Series].[Code]
5875Phys. Invt. Order Nos. SearchPhys. Invt. Order Nos.NormalCode20Phys_ Invt_ Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Phys_ Invt_ Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Phys_ Invt_ Order Nos_] = [No. Series].[Code]
5876Posted Phys. Invt. Order Nos. SearchPosted Phys. Invt. Order Nos.NormalCode20Posted Phys_ Invt_ Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Phys_ Invt_ Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Phys_ Invt_ Order Nos_] = [No. Series].[Code]
6500Package Caption SearchPackage CaptionNormalText30Package Captionnvarchar(60)
7101Item Group Dimension Code SearchItem Group Dimension CodeNormalCode20Item Group Dimension Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Inventory Setup].[Item Group Dimension Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Inventory Setup].[Item Group Dimension Code] = [Dimension].[Code]
7300Inventory Put-away Nos. SearchInventory Put-away Nos.NormalCode20Inventory Put-away Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Inventory Put-away Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Inventory Put-away Nos_] = [No. Series].[Code]
7301Inventory Pick Nos. SearchInventory Pick Nos.NormalCode20Inventory Pick Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Inventory Pick Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Inventory Pick Nos_] = [No. Series].[Code]
7302Posted Invt. Put-away Nos. SearchPosted Invt. Put-away Nos.NormalCode20Posted Invt_ Put-away Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Invt_ Put-away Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Invt_ Put-away Nos_] = [No. Series].[Code]
7303Posted Invt. Pick Nos. SearchPosted Invt. Pick Nos.NormalCode20Posted Invt_ Pick Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Posted Invt_ Pick Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Posted Invt_ Pick Nos_] = [No. Series].[Code]
7304Inventory Movement Nos. SearchInventory Movement Nos.NormalCode20Inventory Movement Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Inventory Movement Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Inventory Movement Nos_] = [No. Series].[Code]
7305Registered Invt. Movement Nos. SearchRegistered Invt. Movement Nos.NormalCode20Registered Invt_ Movement Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Registered Invt_ Movement Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Registered Invt_ Movement Nos_] = [No. Series].[Code]
7306Internal Movement Nos. SearchInternal Movement Nos.NormalCode20Internal Movement Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Inventory Setup].[Internal Movement Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Inventory Setup].[Internal Movement Nos_] = [No. Series].[Code]
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 Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Inventory Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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