Table 1897 "C5 LedTrans" (DK)
DK country layer · Microsoft.DataMigration.C5
Across versions
- BC23-28not present
- BC29-30present
DK country layer · Microsoft.DataMigration.C5 · captioned “C5 Ledger Entry” · BC29-30 · source at ea08af5e · facts from BC29
An object of the DK localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | C5 Ledger Entry |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | RecId | Integer | Row number caption | |
| 2 | LastChanged | Date | Last changed caption | |
| 3 | Account | Code[10] | — | |
| 4 | BudgetCode | Option | Budget code caption | |
| 5 | Department | Code[10] | — | |
| 6 | Date_ | Date | Date caption | |
| 7 | Voucher | Integer | — | |
| 8 | Txt | Text[40] | Text caption | |
| 9 | AmountMST | Decimal | Amount LCY caption | |
| 10 | AmountCur | Decimal | Amount in cur. caption | |
| 11 | Currency | Code[3] | — | |
| 12 | Vat | Code[10] | VAT caption | |
| 13 | VatAmount | Decimal | VAT amount LCY caption | |
| 14 | Qty | Decimal | — | |
| 15 | TransType | Option | Entry type caption | |
| 16 | DueDate | Date | Due caption | |
| 17 | Transaction | Integer | — | |
| 18 | CreatedBy | Integer | Created by caption | DataClassification EndUserIdentifiableInformation |
| 19 | JourNumber | Integer | Journal no. caption | |
| 20 | Amount2 | Decimal | Amount in caption | |
| 21 | LockAmount2 | Option | Lock Amount 2 caption | |
| 22 | Centre | Code[10] | Cost centre caption | |
| 23 | Purpose | Code[10] | — | |
| 24 | ReconcileNo | Integer | Reconciliation no. caption | |
| 25 | VatRepCounter | Integer | VAT report counter caption | |
| 26 | VatPeriodRecId | Integer | Settlement period caption |
Keys
- PK: RecId (clustered)
- AcountDateTransactionKey: Account, Date_, Transaction
- DateKey: Date_
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "C5 LedTrans"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A DK country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.