Outstanding Bank Transaction

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

Table Type: Company

Table Name: Outstanding Bank Transaction
Database Table Name: CRONUS UK Ltd_$Outstanding Bank Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1284

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 Outstanding Bank Transaction 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 Outstanding Bank Transaction table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Entry No. SearchEntry No.NormalInteger4Entry No_int
2Posting Date Primary Key SearchPosting DateNormalDate4Posting Datedatetime
3Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “RefundDeposit”
4Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
5Bank Account No. SearchBank Account No.NormalCode20Bank Account No_nvarchar(40)
Key to join to the Bank Account table.

Show/hide example query

6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
8Type SearchTypeNormalOption4Typeint
Available options are:
  • “Bank Account Ledger Entry”
  • “Check Ledger Entry”
9Applied SearchAppliedNormalBoolean4Appliedtinyint
10Statement Type SearchStatement TypeNormalOption4Statement Typeint
Available options are:
  • “Bank Reconciliation”
  • “Payment Application”
11Statement No. SearchStatement No.NormalCode20Statement No_nvarchar(40)
10010Indentation SearchIndentationNormalInteger4
10011External Document No. SearchExternal Document No.NormalCode35
2000000000$systemId Primary Key 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 Outstanding Bank Transaction table

Leave a Reply

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