Job Difference Buffer

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

Table Type: Company

Table Name: Job Difference Buffer
Database Table Name: CRONUS UK Ltd_$Job Difference Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1019

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 Job Difference Buffer can be queried.

Show/hide an example select of all columns

Show/hide an example select of all columns by name

Show/hide an example select of all columns including those from all joined tables

Show/hide columns in Job Difference Buffer table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

2Job Task No. Primary Key SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
3Type Primary Key SearchTypeNormalOption4Typeint
Available options are:
  • “Resource”
  • “Item”
  • “G/L Account”
4Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

5Variant Code Primary Key SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

6Unit of Measure code Primary Key SearchUnit of Measure codeNormalCode10Unit of Measure codenvarchar(20)
7Entry type Primary Key SearchEntry typeNormalOption4Entry typeint
Available options are:
  • “Budget”
  • “Usage”
8Work Type Code Primary Key SearchWork Type CodeNormalCode10Work Type Codenvarchar(20)
Key to join to the Work Type table.

Show/hide example query

9No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
10Quantity Primary Key SearchQuantityNormalDecimal12Quantitydecimal(38,38)
11Total Cost SearchTotal CostNormalDecimal12Total Costdecimal(38,38)
12Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
10010Budgeted Quantity SearchBudgeted QuantityNormalDecimal12
10011Budgeted Total Cost SearchBudgeted Total CostNormalDecimal12
10012Budgeted Line Amount SearchBudgeted Line AmountNormalDecimal12
10013Description SearchDescriptionNormalText50
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Job Difference Buffer table

Leave a Reply

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