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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Primary Key | Primary Key | Normal | Code | 10 | Primary Key | nvarchar(20) |
2 | Automatic Cost Posting | Automatic Cost Posting | Normal | Boolean | 4 | Automatic Cost Posting | tinyint |
3 | Location Mandatory | Location Mandatory | Normal | Boolean | 4 | Location Mandatory | tinyint |
4 | Item Nos. | Item Nos. | Normal | Code | 20 | Item Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
30 | Automatic Cost Adjustment | Automatic Cost Adjustment | Normal | Option | 4 | Automatic Cost Adjustment | int |
Available options are:
| |||||||
40 | Prevent Negative Inventory | Prevent Negative Inventory | Normal | Boolean | 4 | Prevent Negative Inventory | tinyint |
45 | Variant Mandatory if Exists | Variant Mandatory if Exists | Normal | Boolean | 4 | Variant Mandatory if Exists | tinyint |
50 | Skip Prompt to Create Item | Skip Prompt to Create Item | Normal | Boolean | 4 | Skip Prompt to Create Item | tinyint |
51 | Copy Item Descr. to Entries | Copy Item Descr. to Entries | Normal | Boolean | 4 | Copy Item Descr_ to Entries | tinyint |
60 | Allow Inventory Adjustment | Allow Inventory Adjustment | Normal | Boolean | 4 | Allow Inventory Adjustment | tinyint |
180 | Invt. Cost Jnl. Template Name | Invt. Cost Jnl. Template Name | Normal | Code | 10 | Invt_ Cost Jnl_ Template Name | nvarchar(20) |
Key to join to the Gen. Journal Template table.Show/hide example querySELECT
[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] | |||||||
181 | Invt. Cost Jnl. Batch Name | Jnl. Batch Name Cost Posting | Normal | Code | 10 | Invt_ Cost Jnl_ Batch Name | nvarchar(20) |
5700 | Transfer Order Nos. | Transfer Order Nos. | Normal | Code | 20 | Transfer Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5701 | Posted Transfer Shpt. Nos. | Posted Transfer Shpt. Nos. | Normal | Code | 20 | Posted Transfer Shpt_ Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5702 | Posted Transfer Rcpt. Nos. | Posted Transfer Rcpt. Nos. | Normal | Code | 20 | Posted Transfer Rcpt_ Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5703 | Copy Comments Order to Shpt. | Copy Comments Order to Shpt. | Normal | Boolean | 4 | Copy Comments Order to Shpt_ | tinyint |
5704 | Copy Comments Order to Rcpt. | Copy Comments Order to Rcpt. | Normal | Boolean | 4 | Copy Comments Order to Rcpt_ | tinyint |
5718 | Nonstock Item Nos. | Catalog Item Nos. | Normal | Code | 20 | Nonstock Item Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5725 | Use Item References | Use Item References | Normal | Boolean | 4 | Use Item References | tinyint |
5790 | Outbound Whse. Handling Time | Outbound Whse. Handling Time | Normal | DateFormula | 32 | Outbound Whse_ Handling Time | varchar(32) |
5791 | Inbound Whse. Handling Time | Inbound Whse. Handling Time | Normal | DateFormula | 32 | Inbound Whse_ Handling Time | varchar(32) |
5800 | Expected Cost Posting to G/L | Expected Cost Posting to G/L | Normal | Boolean | 4 | Expected Cost Posting to G_L | tinyint |
5801 | Default Costing Method | Default Costing Method | Normal | Option | 4 | Default Costing Method | int |
Available options are:
| |||||||
5804 | Average Cost Calc. Type | Average Cost Calc. Type | Normal | Option | 4 | Average Cost Calc_ Type | int |
Available options are:
| |||||||
5805 | Average Cost Period | Average Cost Period | Normal | Option | 4 | Average Cost Period | int |
Available options are:
| |||||||
5849 | Allow Invt. Doc. Reservation | Allow Invt. Doc. Reservation | Normal | Boolean | 4 | Allow Invt_ Doc_ Reservation | tinyint |
5850 | Invt. Receipt Nos. | Invt. Receipt Nos. | Normal | Code | 20 | Invt_ Receipt Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5851 | Posted Invt. Receipt Nos. | Posted Invt. Receipt Nos. | Normal | Code | 20 | Posted Invt_ Receipt Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5852 | Invt. Shipment Nos. | Invt. Shipment Nos. | Normal | Code | 20 | Invt_ Shipment Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5853 | Posted Invt. Shipment Nos. | Posted Invt. Shipment Nos. | Normal | Code | 20 | Posted Invt_ Shipment Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5854 | Copy Comments to Invt. Doc. | Copy Comments to Invt. Doc. | Normal | Boolean | 4 | Copy Comments to Invt_ Doc_ | tinyint |
5855 | Direct Transfer Posting | Direct Transfer Posting | Normal | Option | 4 | Direct Transfer Posting | int |
Available options are:
| |||||||
5856 | Posted Direct Trans. Nos. | Posted Direct Trans. Nos. | Normal | Code | 20 | Posted Direct Trans_ Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5860 | Package Nos. | Package Nos. | Normal | Code | 20 | Package Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5875 | Phys. Invt. Order Nos. | Phys. Invt. Order Nos. | Normal | Code | 20 | Phys_ Invt_ Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
5876 | Posted Phys. Invt. Order Nos. | Posted Phys. Invt. Order Nos. | Normal | Code | 20 | Posted Phys_ Invt_ Order Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
6500 | Package Caption | Package Caption | Normal | Text | 30 | Package Caption | nvarchar(60) |
7101 | Item Group Dimension Code | Item Group Dimension Code | Normal | Code | 20 | Item Group Dimension Code | nvarchar(40) |
Key to join to the Dimension table.Show/hide example querySELECT
[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] | |||||||
7300 | Inventory Put-away Nos. | Inventory Put-away Nos. | Normal | Code | 20 | Inventory Put-away Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7301 | Inventory Pick Nos. | Inventory Pick Nos. | Normal | Code | 20 | Inventory Pick Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7302 | Posted Invt. Put-away Nos. | Posted Invt. Put-away Nos. | Normal | Code | 20 | Posted Invt_ Put-away Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7303 | Posted Invt. Pick Nos. | Posted Invt. Pick Nos. | Normal | Code | 20 | Posted Invt_ Pick Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7304 | Inventory Movement Nos. | Inventory Movement Nos. | Normal | Code | 20 | Inventory Movement Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7305 | Registered Invt. Movement Nos. | Registered Invt. Movement Nos. | Normal | Code | 20 | Registered Invt_ Movement Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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] | |||||||
7306 | Internal Movement Nos. | Internal Movement Nos. | Normal | Code | 20 | Internal Movement Nos_ | nvarchar(40) |
Key to join to the No. Series table.Show/hide example querySELECT
[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 | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[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] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[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] |