Table 42819 "SL Hist. GLTran"
DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData
Across versionsobsolete pending since 28.0
- BC23-28not present
- BC29-30present
DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| DataClassification | CustomerContent |
| ObsoleteState | Pending |
| ObsoleteTag | 28.0 |
| ObsoleteReason | Replaced by table SL Hist. GLTran Buffer. |
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] | — | |
| 2 | AppliedDate | DateTime | — | |
| 3 | BalanceType | Text[1] | — | |
| 4 | BaseCuryID | Text[4] | — | |
| 5 | BatNbr | Text[10] | — | |
| 6 | CpnyID | Text[10] | — | |
| 7 | CrAmt | Decimal | — | |
| 8 | Crtd_DateTime | DateTime | — | |
| 9 | Crtd_Prog | Text[8] | — | |
| 10 | Crtd_User | Text[10] | — | |
| 11 | CuryCrAmt | Decimal | — | |
| 12 | CuryDrAmt | Decimal | — | |
| 13 | CuryEffDate | DateTime | — | |
| 14 | CuryId | Text[4] | — | |
| 15 | CuryMultDiv | Text[1] | — | |
| 16 | CuryRate | Decimal | — | |
| 17 | CuryRateType | Text[6] | — | |
| 18 | DrAmt | Decimal | — | |
| 19 | EmployeeID | Text[10] | — | |
| 20 | ExtRefNbr | Text[15] | — | |
| 21 | FiscYr | Text[4] | — | |
| 22 | IC_Distribution | Integer | — | |
| 23 | Id | Text[20] | — | |
| 24 | JrnlType | Text[3] | — | |
| 25 | Labor_Class_Cd | Text[4] | — | |
| 26 | LedgerID | Text[10] | — | |
| 27 | LineId | Integer | — | |
| 28 | LineNbr | Integer | — | |
| 29 | LineRef | Text[5] | — | |
| 30 | LUpd_DateTime | DateTime | — | |
| 31 | LUpd_Prog | Text[8] | — | |
| 32 | LUpd_User | Text[10] | — | |
| 33 | Module | Text[2] | — | |
| 34 | NoteID | Integer | — | |
| 35 | OrigAcct | Text[10] | — | |
| 36 | OrigBatNbr | Text[10] | — | |
| 37 | OrigCpnyID | Text[10] | — | |
| 38 | OrigSub | Text[24] | — | |
| 39 | PC_Flag | Text[1] | — | |
| 40 | PC_ID | Text[20] | — | |
| 41 | PC_Status | Text[1] | — | |
| 42 | PerEnt | Text[6] | — | |
| 43 | PerPost | Text[6] | — | |
| 44 | Posted | Text[1] | — | |
| 45 | ProjectID | Text[16] | — | |
| 46 | Qty | Decimal | — | |
| 47 | RefNbr | Text[10] | — | |
| 48 | RevEntryOption | Text[1] | — | |
| 49 | Rlsed | Integer | — | |
| 50 | S4Future01 | Text[30] | — | |
| 52 | S4Future02 | Text[30] | — | |
| 53 | S4Future03 | Decimal | — | |
| 54 | S4Future04 | Decimal | — | |
| 55 | S4Future05 | Decimal | — | |
| 56 | S4Future06 | Decimal | — | |
| 57 | S4Future07 | DateTime | — | |
| 58 | S4Future08 | DateTime | — | |
| 59 | S4Future09 | Integer | — | |
| 60 | S4Future10 | Integer | — | |
| 61 | S4Future11 | Text[10] | — | |
| 63 | S4Future12 | Text[10] | — | |
| 64 | ServiceDate | DateTime | — | |
| 65 | Sub | Text[24] | — | |
| 66 | TaskID | Text[32] | — | |
| 67 | TranDate | DateTime | — | |
| 68 | TranDesc | Text[30] | — | |
| 69 | TranType | Text[2] | — | |
| 70 | Units | Decimal | — | |
| 71 | User1 | Text[30] | — | |
| 73 | User2 | Text[30] | — | |
| 74 | User3 | Decimal | — | |
| 75 | User4 | Decimal | — | |
| 76 | User5 | Text[10] | — | |
| 77 | User6 | Text[10] | — | |
| 78 | User7 | DateTime | — | |
| 79 | User8 | DateTime | — |
Keys
- Key1: Module, BatNbr, LineNbr (clustered)
Deprecations
- object: Pending 28.0 (#if not CLEANSCHEMA31), “Replaced by table SL Hist. GLTran Buffer.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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. GLTran"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.