Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/289
Table Type: Company
Table Name: Payment Method
Database Table Name: CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b
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 Payment Method can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Code]
,[AMC Bank Pmt_ Type]
,[Description]
,[Bal_ Account Type]
,[Bal_ Account No_]
,[Direct Debit]
,[Direct Debit Pmt_ Terms Code]
,[Pmt_ Export Line Definition]
,[Bank Data Conversion Pmt_ Type]
,[Use for Invoicing]
,[Last Modified Date Time]
,[Id]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Payment Method$16319982-4995-4fb1-8fb2-2b1e13773e3b]Show/hide columns in Payment Method table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(20) |
| 3 | AMC Bank Pmt_ Type | nvarchar(100) |
| 3 | Description | nvarchar(200) |
| 4 | Bal_ Account Type | int |
| 5 | Bal_ Account No_ | nvarchar(40) |
| 6 | Direct Debit | tinyint |
| 7 | Direct Debit Pmt_ Terms Code | nvarchar(20) |
| 8 | Pmt_ Export Line Definition | nvarchar(40) |
| 9 | Bank Data Conversion Pmt_ Type | nvarchar(100) |
| 10 | Use for Invoicing | tinyint |
| 11 | Last Modified Date Time | datetime |
| 12 | Id | uniqueidentifier |
| 13 | $systemId | uniqueidentifier |
| 14 | $systemCreatedAt | datetime |
| 15 | $systemCreatedBy | uniqueidentifier |
| 16 | $systemModifiedAt | datetime |
| 17 | $systemModifiedBy | uniqueidentifier |
Show/hide tables related to Payment Method table
CustomerCustomer TemplateCustomer Templ_Cust_ Ledger EntryEmployee Ledger EntryEmployee Payment BufferGen_ Journal LineJobMini Customer TemplateMini Vendor TemplateNative – PaymentPayment BufferPayment Method TranslationPayment Registration BufferPosted Gen_ Journal LinePurchase HeaderPurchase Header ArchivePurch_ Cr_ Memo Hdr_Purch_ Inv_ HeaderPurch_ Rcpt_ HeaderReturn Receipt HeaderReturn Shipment HeaderSales Cr_Memo HeaderSales HeaderSales Header ArchiveSales Invoice HeaderSales Shipment HeaderService Contract HeaderService Cr_Memo HeaderService HeaderService Invoice HeaderService Shipment HeaderStandard Customer Sales CodeVendorVendor Ledger EntryVendor Templ_