Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/5877
Table Type: Company
Table Name: Phys. Invt. Record Header
Database Table Name: CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972
Table Number: 5877Due 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 Phys. Invt. Record Header can be queried.
SELECT
*
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
[Order No_]
,[Recording No_]
,[Description]
,[Status]
,[Person Responsible]
,[Allow Recording Without Order]
,[Date Recorded]
,[Time Recorded]
,[Person Recorded]
,[Recorded by User ID]
,[Location Code]
,[Bin Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972]
SELECT
*
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
ON
[Phys. Invt. Record Header].[Person Responsible] = [Employee].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
ON
[Phys. Invt. Record Header].[Person Recorded] = [Employee].[No_]
LEFT JOIN
[User] AS [User]
ON
[Phys. Invt. Record Header].[Recorded by User ID] = [User].[User Name]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Phys. Invt. Record Header].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Phys. Invt. Record Header].[Bin Code] = [Bin].[Code]
LEFT JOIN
[User] AS [User]
ON
[Phys. Invt. Record Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Phys. Invt. Record Header].[SystemModifiedBy] = [User].[User Security ID]
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|
| 1 | Order No.  | Order No. | Normal | Code | 20 | Order No_ | nvarchar(40) |
| 2 | Recording No.  | Recording No. | Normal | Integer | 4 | Recording No_ | int |
| 10 | Description | Description | Normal | Text | 100 | Description | nvarchar(200) |
| 11 | Status | Status | Normal | Option | 4 | Status | int |
| Available options are:
|
| 30 | Comment | Comment | FlowField | Boolean | 4 | | |
| 31 | Person Responsible | Person Responsible | Normal | Code | 20 | Person Responsible | nvarchar(40) |
| Key to join to the Employee table.SELECT
[Phys. Invt. Record Header].[Person Responsible]
,[Employee].[No_]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
ON
[Phys. Invt. Record Header].[Person Responsible] = [Employee].[No_] |
| 40 | Allow Recording Without Order | Allow Recording Without Order | Normal | Boolean | 4 | Allow Recording Without Order | tinyint |
| 100 | Date Recorded | Date Recorded | Normal | Date | 4 | Date Recorded | datetime |
| 101 | Time Recorded | Time Recorded | Normal | Time | 4 | Time Recorded | datetime |
| 102 | Person Recorded | Person Recorded | Normal | Code | 20 | Person Recorded | nvarchar(40) |
| Key to join to the Employee table.SELECT
[Phys. Invt. Record Header].[Person Recorded]
,[Employee].[No_]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[CRONUS UK Ltd_$Employee$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Employee]
ON
[Phys. Invt. Record Header].[Person Recorded] = [Employee].[No_] |
| 103 | Recorded by User ID | Created by User | Normal | Code | 50 | Recorded by User ID | nvarchar(100) |
| Key to join to the User table.SELECT
[Phys. Invt. Record Header].[Recorded by User ID]
,[User].[User Name]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[User] AS [User]
ON
[Phys. Invt. Record Header].[Recorded by User ID] = [User].[User Name] |
| 110 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
| Key to join to the Location table.SELECT
[Phys. Invt. Record Header].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Phys. Invt. Record Header].[Location Code] = [Location].[Code] |
| 111 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
| Key to join to the Bin table.SELECT
[Phys. Invt. Record Header].[Bin Code]
,[Bin].[Code]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
ON
[Phys. Invt. Record Header].[Bin Code] = [Bin].[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.SELECT
[Phys. Invt. Record Header].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[CRONUS UK Ltd_$Phys_ Invt_ Record Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Record Header]
LEFT JOIN
[User] AS [User]
ON
[Phys. Invt. Record Header].[$systemCreatedBy] = [User].[User Security ID] |
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
