Purch_ Rcpt_ Line

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

Table Type: Company

Table Name: Purch_ Rcpt_ Line
Database Table Name: CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Purch_ Rcpt_ Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Buy-from Vendor No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Expected Receipt Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Unit Price (LCY)]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Item Rcpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Job No_]
   ,[Indirect Cost _]
   ,[Qty_ Rcd_ Not Invoiced]
   ,[Quantity Invoiced]
   ,[Order No_]
   ,[Order Line No_]
   ,[Pay-to Vendor No_]
   ,[Vendor Item No_]
   ,[Sales Order No_]
   ,[Sales Order Line No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Entry Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Line Type]
   ,[Job Unit Price]
   ,[Job Total Price]
   ,[Job Line Amount]
   ,[Job Line Discount Amount]
   ,[Job Line Discount _]
   ,[Job Unit Price (LCY)]
   ,[Job Total Price (LCY)]
   ,[Job Line Amount (LCY)]
   ,[Job Line Disc_ Amount (LCY)]
   ,[Job Currency Factor]
   ,[Job Currency Code]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Qty_ Invoiced (Base)]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Special Order Sales No_]
   ,[Special Order Sales Line No_]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[Lead Time Calculation]
   ,[Inbound Whse_ Handling Time]
   ,[Planned Receipt Date]
   ,[Order Date]
   ,[Item Charge Base Amount]
   ,[Correction]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Document Id]
   ,[Over-Receipt Quantity]
   ,[Over-Receipt Code]
   ,[Over-Receipt Code 2]
   ,[Routing No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Prod_ Order Line No_]
   ,[Overhead Rate]
   ,[Routing Reference No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Line].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purch_ Rcpt_ Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Purch_ Rcpt_ Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Rcpt_ Line].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purch_ Rcpt_ Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Purch_ Rcpt_ Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Purch_ Rcpt_ Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Purch_ Rcpt_ Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Purch_ Rcpt_ Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Purch_ Rcpt_ Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Purch_ Rcpt_ Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Buy-from Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purch_ Rcpt_ Line].[Buy-from Vendor No_] = [Vendor].[No_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Purch_ Rcpt_ Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Expected Receipt Date Searchdatetime
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Unit of Measure Searchnvarchar(100)
13Quantity Searchdecimal(38,38)
14Direct Unit Cost Searchdecimal(38,38)
15Unit Cost (LCY) Searchdecimal(38,38)
16VAT _ Searchdecimal(38,38)
17Line Discount _ Searchdecimal(38,38)
18Unit Price (LCY) Searchdecimal(38,38)
19Allow Invoice Disc_ Searchtinyint
20Gross Weight Searchdecimal(38,38)
21Net Weight Searchdecimal(38,38)
22Units per Parcel Searchdecimal(38,38)
23Unit Volume Searchdecimal(38,38)
24Appl_-to Item Entry Searchint
25Item Rcpt_ Entry No_ Searchint
26Shortcut Dimension 1 Code Searchnvarchar(40)
27Shortcut Dimension 2 Code Searchnvarchar(40)
28Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Purch_ Rcpt_ Line].[Job No_] = [Job].[Job No_]
29Indirect Cost _ Searchdecimal(38,38)
30Qty_ Rcd_ Not Invoiced Searchdecimal(38,38)
31Quantity Invoiced Searchdecimal(38,38)
32Order No_ Searchnvarchar(40)
33Order Line No_ Searchint
34Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purch_ Rcpt_ Line].[Pay-to Vendor No_] = [Vendor].[No_]
35Vendor Item No_ Searchnvarchar(100)
36Sales Order No_ Searchnvarchar(40)
37Sales Order Line No_ Searchint
38Gen_ Bus_ Posting Group Searchnvarchar(40)
39Gen_ Prod_ Posting Group Searchnvarchar(40)
40VAT Calculation Type Searchint
41Transaction Type Searchnvarchar(20)
42Transport Method Searchnvarchar(20)
43Attached to Line No_ Searchint
44Entry Point Searchnvarchar(20)
45Area Searchnvarchar(20)
46Transaction Specification Searchnvarchar(20)
47Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purch_ Rcpt_ Line].[Tax Area Code] = [Tax Area].[Code]
48Tax Liable Searchtinyint
49Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Purch_ Rcpt_ Line].[Tax Group Code] = [Tax Group].[Code]
50Use Tax Searchtinyint
51VAT Bus_ Posting Group Searchnvarchar(40)
52VAT Prod_ Posting Group Searchnvarchar(40)
53Blanket Order No_ Searchnvarchar(40)
54Blanket Order Line No_ Searchint
55VAT Base Amount Searchdecimal(38,38)
56Unit Cost Searchdecimal(38,38)
57IC Partner Ref_ Type Searchint
58IC Partner Reference Searchnvarchar(40)
59Posting Date Searchdatetime
60IC Item Reference No_ Searchnvarchar(100)
61Dimension Set ID Searchint
62Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Purch_ Rcpt_ Line].[Job Task No_] = [Job Task].[Job Task No_]
63Job Line Type Searchint
64Job Unit Price Searchdecimal(38,38)
65Job Total Price Searchdecimal(38,38)
66Job Line Amount Searchdecimal(38,38)
67Job Line Discount Amount Searchdecimal(38,38)
68Job Line Discount _ Searchdecimal(38,38)
69Job Unit Price (LCY) Searchdecimal(38,38)
70Job Total Price (LCY) Searchdecimal(38,38)
71Job Line Amount (LCY) Searchdecimal(38,38)
72Job Line Disc_ Amount (LCY) Searchdecimal(38,38)
73Job Currency Factor Searchdecimal(38,38)
74Job Currency Code Searchnvarchar(40)
75Prod_ Order No_ Searchnvarchar(40)
76Variant Code Searchnvarchar(20)
77Bin Code Searchnvarchar(40)
78Qty_ per Unit of Measure Searchdecimal(38,38)
79Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Purch_ Rcpt_ Line].[Unit of Measure Code] = [Unit of Measure].[Code]
80Quantity (Base) Searchdecimal(38,38)
81Qty_ Invoiced (Base) Searchdecimal(38,38)
82FA Posting Date Searchdatetime
83FA Posting Type Searchint
84Depreciation Book Code Searchnvarchar(20)
85Salvage Value Searchdecimal(38,38)
86Depr_ until FA Posting Date Searchtinyint
87Depr_ Acquisition Cost Searchtinyint
88Maintenance Code Searchnvarchar(20)
89Insurance No_ Searchnvarchar(40)
90Budgeted FA No_ Searchnvarchar(40)
91Duplicate in Depreciation Book Searchnvarchar(20)
92Use Duplication List Searchtinyint
93Responsibility Center Searchnvarchar(20)
94Cross-Reference No_ Searchnvarchar(40)
95Unit of Measure (Cross Ref_) Searchnvarchar(20)
96Cross-Reference Type Searchint
97Cross-Reference Type No_ Searchnvarchar(60)
98Item Reference No_ Searchnvarchar(100)
99Item Reference Unit of Measure Searchnvarchar(20)
100Item Reference Type Searchint
101Item Reference Type No_ Searchnvarchar(60)
102Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Purch_ Rcpt_ Line].[Item Category Code] = [Item Category].[Code]
103Nonstock Searchtinyint
104Purchasing Code Searchnvarchar(20)
105Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Purch_ Rcpt_ Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Rcpt_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Rcpt_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Purch_ Rcpt_ Line].[Product Group Code] = [Product Group].[Code]
106Special Order Sales No_ Searchnvarchar(40)
107Special Order Sales Line No_ Searchint
108Requested Receipt Date Searchdatetime
109Promised Receipt Date Searchdatetime
110Lead Time Calculation Searchvarchar(32)
111Inbound Whse_ Handling Time Searchvarchar(32)
112Planned Receipt Date Searchdatetime
113Order Date Searchdatetime
114Item Charge Base Amount Searchdecimal(38,38)
115Correction Searchtinyint
116Return Reason Code Searchnvarchar(20)
117Price Calculation Method Searchint
118Document Id Searchuniqueidentifier
119Over-Receipt Quantity Searchdecimal(38,38)
120Over-Receipt Code Searchnvarchar(20)
121Over-Receipt Code 2 Searchnvarchar(40)
122Routing No_ Searchnvarchar(40)
123Operation No_ Searchnvarchar(20)
124Work Center No_ Searchnvarchar(40)
125Prod_ Order Line No_ Searchint
126Overhead Rate Searchdecimal(38,38)
127Routing Reference No_ Searchint
128$systemId Searchuniqueidentifier
129$systemCreatedAt Searchdatetime
130$systemCreatedBy Searchuniqueidentifier
131$systemModifiedAt Searchdatetime
132$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purch_ Rcpt_ Line table

Leave a Reply

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