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
   [timestamp]
   ,[Primary Key]
   ,[Automatic Cost Posting]
   ,[Location Mandatory]
   ,[Item Nos_]
   ,[Automatic Cost Adjustment]
   ,[Prevent Negative Inventory]
   ,[Skip Prompt to Create Item]
   ,[Copy Item Descr_ to Entries]
   ,[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 columns in Inventory Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Automatic Cost Posting Searchtinyint
4Location Mandatory Searchtinyint
5Item Nos_ Searchnvarchar(40)
6Automatic Cost Adjustment Searchint
7Prevent Negative Inventory Searchtinyint
8Skip Prompt to Create Item Searchtinyint
9Copy Item Descr_ to Entries Searchtinyint
10Invt_ Cost Jnl_ Template Name Searchnvarchar(20)
11Invt_ Cost Jnl_ Batch Name Searchnvarchar(20)
12Transfer Order Nos_ Searchnvarchar(40)
13Posted Transfer Shpt_ Nos_ Searchnvarchar(40)
14Posted Transfer Rcpt_ Nos_ Searchnvarchar(40)
15Copy Comments Order to Shpt_ Searchtinyint
16Copy Comments Order to Rcpt_ Searchtinyint
17Nonstock Item Nos_ Searchnvarchar(40)
18Use Item References Searchtinyint
19Outbound Whse_ Handling Time Searchvarchar(32)
20Inbound Whse_ Handling Time Searchvarchar(32)
21Expected Cost Posting to G_L Searchtinyint
22Default Costing Method Searchint
23Average Cost Calc_ Type Searchint
24Average Cost Period Searchint
25Allow Invt_ Doc_ Reservation Searchtinyint
26Invt_ Receipt Nos_ Searchnvarchar(40)
27Posted Invt_ Receipt Nos_ Searchnvarchar(40)
28Invt_ Shipment Nos_ Searchnvarchar(40)
29Posted Invt_ Shipment Nos_ Searchnvarchar(40)
30Copy Comments to Invt_ Doc_ Searchtinyint
31Direct Transfer Posting Searchint
32Posted Direct Trans_ Nos_ Searchnvarchar(40)
33Package Nos_ Searchnvarchar(40)
34Phys_ Invt_ Order Nos_ Searchnvarchar(40)
35Posted Phys_ Invt_ Order Nos_ Searchnvarchar(40)
36Package Caption Searchnvarchar(60)
37Item Group Dimension Code Searchnvarchar(40)
38Inventory Put-away Nos_ Searchnvarchar(40)
39Inventory Pick Nos_ Searchnvarchar(40)
40Posted Invt_ Put-away Nos_ Searchnvarchar(40)
41Posted Invt_ Pick Nos_ Searchnvarchar(40)
42Inventory Movement Nos_ Searchnvarchar(40)
43Registered Invt_ Movement Nos_ Searchnvarchar(40)
44Internal Movement Nos_ Searchnvarchar(40)
45$systemId Searchuniqueidentifier
46$systemCreatedAt Searchdatetime
47$systemCreatedBy Searchuniqueidentifier
48$systemModifiedAt Searchdatetime
49$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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