Shpfy Payout – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SShpfy Payout

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

Table Type: Company

Table Name: Shpfy Payout
Database Table Name: CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb

Table Number: 30125

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 Shpfy Payout can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

Show/hide an example select of all columns by name

SELECT

   [Id]
   ,[Status]
   ,[Date]
   ,[Currency]
   ,[Amount]
   ,[Adjustments Fee Amount]
   ,[Adjustments Gross Amount]
   ,[Charges Fee Amount]
   ,[Charges Gross Amount]
   ,[Refunds Fee Amount]
   ,[Refunds Gross Amount]
   ,[Reserved Funds Fee Amount]
   ,[Reserved Funds Gross Amount]
   ,[Retried Payouts Fee Amount]
   ,[Retried Payouts Gross Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payout]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Payout].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Shpfy Payout].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Shpfy Payout table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Id	Id	Normal	BigInteger	8	Id	bigint
2	Status	Status	Normal	Option	4	Status	int
	Available options are: “Unknown” “Scheduled” “In Transit” “Paid” “Failed” “Canceled”
3	Date	Date	Normal	Date	4	Date	datetime
4	Currency	Currency	Normal	Code	10	Currency	nvarchar(20)
5	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
6	Adjustments Fee Amount	Adjustments Fee Amount	Normal	Decimal	12	Adjustments Fee Amount	decimal(38,38)
7	Adjustments Gross Amount	Adjustments Gross Amount	Normal	Decimal	12	Adjustments Gross Amount	decimal(38,38)
8	Charges Fee Amount	Charges Fee Amount	Normal	Decimal	12	Charges Fee Amount	decimal(38,38)
9	Charges Gross Amount	Charges Gross Amount	Normal	Decimal	12	Charges Gross Amount	decimal(38,38)
10	Refunds Fee Amount	Refunds Fee Amount	Normal	Decimal	12	Refunds Fee Amount	decimal(38,38)
11	Refunds Gross Amount	Refunds Gross Amount	Normal	Decimal	12	Refunds Gross Amount	decimal(38,38)
12	Reserved Funds Fee Amount	Reserved Funds Fee Amount	Normal	Decimal	12	Reserved Funds Fee Amount	decimal(38,38)
13	Reserved Funds Gross Amount	Reserved Funds Gross Amount	Normal	Decimal	12	Reserved Funds Gross Amount	decimal(38,38)
14	Retried Payouts Fee Amount	Retried Payouts Fee Amount	Normal	Decimal	12	Retried Payouts Fee Amount	decimal(38,38)
15	Retried Payouts Gross Amount	Retried Payouts Gross Amount	Normal	Decimal	12	Retried Payouts Gross Amount	decimal(38,38)
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 query SELECT [Shpfy Payout].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payout] LEFT JOIN [User] AS [User] ON [Shpfy Payout].[$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 query SELECT [Shpfy Payout].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Shpfy Payout$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Payout] LEFT JOIN [User] AS [User] ON [Shpfy Payout].[$systemModifiedBy] = [User].[User Security ID]