Table 42806 "SL Hist. Batch"
DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 1 connected objects and pages
DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| DataClassification | CustomerContent |
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 | Acct | Text[10] | Specifies the Account that the batch is associated with. via Page 42803 “SL Hist. Batch Entries” | |
| 2 | AutoRev | Integer | — | |
| 3 | AutoRevCopy | Integer | — | |
| 4 | BalanceType | Text[1] | Specifies the Balance Type of the batch. via Page 42803 “SL Hist. Batch Entries” | |
| 5 | BankAcct | Text[10] | — | |
| 6 | BankSub | Text[24] | — | |
| 7 | BaseCuryID | Text[4] | — | |
| 8 | BatNbr | Text[10] | Specifies the Batch Number that the entry belongs to. via Page 42803 “SL Hist. Batch Entries” | |
| 9 | BatType | Text[1] | — | |
| 10 | clearamt | Decimal | — | |
| 11 | Cleared | Integer | — | |
| 12 | CpnyID | Text[10] | Specifies the Company ID that the batch belongs to. via Page 42803 “SL Hist. Batch Entries” | |
| 13 | Crtd_DateTime | DateTime | — | |
| 14 | Crtd_Prog | Text[8] | — | |
| 15 | Crtd_User | Text[10] | — | |
| 16 | CrTot | Decimal | Specifies the credit total for the batch. via Page 42803 “SL Hist. Batch Entries” | |
| 17 | CtrlTot | Decimal | — | |
| 18 | CuryCrTot | Decimal | — | |
| 19 | CuryCtrlTot | Decimal | — | |
| 20 | CuryDepositAmt | Decimal | — | |
| 21 | CuryDrTot | Decimal | — | |
| 22 | CuryEffDate | DateTime | — | |
| 23 | CuryId | Text[4] | — | |
| 24 | CuryMultDiv | Text[1] | — | |
| 25 | CuryRate | Decimal | — | |
| 26 | CuryRateType | Text[6] | — | |
| 27 | Cycle | Integer | — | |
| 28 | DateClr | DateTime | — | |
| 29 | DateEnt | DateTime | — | |
| 30 | DepositAmt | Decimal | — | |
| 31 | Descr | Text[30] | Specifies the Description of the batch. via Page 42803 “SL Hist. Batch Entries” | |
| 32 | DrTot | Decimal | Specifies the debit total for the batch. via Page 42803 “SL Hist. Batch Entries” | |
| 33 | EditScrnNbr | Text[5] | — | |
| 34 | GLPostOpt | Text[1] | — | |
| 35 | JrnlType | Text[3] | Specifies the Journal Type that the batch belongs to. via Page 42803 “SL Hist. Batch Entries” | |
| 36 | LedgerID | Text[10] | Specifies the Ledger ID that the batch is posted to. via Page 42803 “SL Hist. Batch Entries” | |
| 37 | LUpd_DateTime | DateTime | — | |
| 38 | LUpd_Prog | Text[8] | — | |
| 39 | LUpd_User | Text[10] | — | |
| 40 | Module | Text[2] | Specifies the Module that the batch belongs to. via Page 42803 “SL Hist. Batch Entries” | |
| 41 | NbrCycle | Integer | — | |
| 42 | NoteID | Integer | — | |
| 43 | OrigBatNbr | Text[10] | — | |
| 44 | OrigCpnyID | Text[10] | — | |
| 45 | OrigScrnNbr | Text[5] | — | |
| 46 | PerEnt | Text[6] | Specifies the period that the batch was entered. via Page 42803 “SL Hist. Batch Entries” | |
| 47 | PerPost | Text[6] | Specifies the period that the batch was posted to. via Page 42803 “SL Hist. Batch Entries” | |
| 48 | Rlsed | Integer | — | |
| 49 | S4Future01 | Text[30] | — | |
| 50 | S4Future02 | Text[30] | — | |
| 51 | S4Future03 | Decimal | — | |
| 52 | S4Future04 | Decimal | — | |
| 53 | S4Future05 | Decimal | — | |
| 54 | S4Future06 | Decimal | — | |
| 55 | S4Future07 | DateTime | — | |
| 56 | S4Future08 | DateTime | — | |
| 57 | S4Future09 | Integer | — | |
| 58 | S4Future10 | Integer | — | |
| 59 | S4Future11 | Text[10] | — | |
| 60 | S4Future12 | Text[10] | — | |
| 61 | Status | Text[1] | Specifies the status of the batch. via Page 42803 “SL Hist. Batch Entries” | |
| 62 | Sub | Text[24] | Specifies the Subaccount that the batch is associated with. via Page 42803 “SL Hist. Batch Entries” | |
| 64 | User1 | Text[30] | — | |
| 65 | User2 | Text[30] | — | |
| 66 | User3 | Decimal | — | |
| 67 | User4 | Decimal | — | |
| 68 | User5 | Text[10] | — | |
| 69 | User6 | Text[10] | — | |
| 70 | User7 | DateTime | — | |
| 71 | User8 | DateTime | — | |
| 72 | VOBatNbrForPP | Text[10] | — |
Keys
- PK: Module, BatNbr (clustered)
Pages and codeunits on this table
- Page 42803 “SL Hist. Batch Entries” (source table)
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: "SL Hist. Batch"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.