BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 42830 "SL Hist. PJTran"

DynamicsSLHistoricalData · Microsoft.DataMigration.SL.HistoricalData

Open in Claude42830.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 1 connected objects and pages

Page 42804 "SL Hist. PJTran Entries" (pages and codeunits on it)SL Hist. PJTran Entries

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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[16] Specifies the account category of the entry. via Page 42804 “SL Hist. PJTran Entries”
2 alloc_flag Text[1] Specifies the allocation flag of the entry. via Page 42804 “SL Hist. PJTran Entries”
3 amount Decimal Specifies the amount of the entry. via Page 42804 “SL Hist. PJTran Entries”
4 BaseCuryId Text[4] Specifies the base currency ID of the entry. via Page 42804 “SL Hist. PJTran Entries”
5 batch_id Text[10] Specifies the batch ID of the entry. via Page 42804 “SL Hist. PJTran Entries”
6 batch_type Text[4] Specifies the batch type of the entry. via Page 42804 “SL Hist. PJTran Entries”
7 bill_batch_id Text[10] Specifies the document number from T&E. via Page 42804 “SL Hist. PJTran Entries”
8 CpnyId Text[10] Specifies the Company ID that the entry belongs to. via Page 42804 “SL Hist. PJTran Entries”
9 crtd_datetime DateTime Specifies the creation date of the entry. via Page 42804 “SL Hist. PJTran Entries”
10 crtd_prog Text[8] Specifies the program that created the entry. via Page 42804 “SL Hist. PJTran Entries”
11 crtd_user Text[10] Specifies the user that created the entry. via Page 42804 “SL Hist. PJTran Entries”
12 CuryEffDate Date —
13 CuryId Text[4] Specifies the currency ID of the entry. via Page 42804 “SL Hist. PJTran Entries”
14 CuryMultDiv Text[1] —
15 CuryRate Decimal —
16 CuryRateType Text[6] —
17 CuryTranamt Decimal Specifies the currency amount of the entry. via Page 42804 “SL Hist. PJTran Entries”
18 data1 Text[16] —
19 detail_num Integer Specifies the detail number of the entry. via Page 42804 “SL Hist. PJTran Entries”
20 employee Text[10] Specifies the resource (employee) associated with the entry. via Page 42804 “SL Hist. PJTran Entries”
21 fiscalno Text[6] Specifies the fiscal period of the entry. via Page 42804 “SL Hist. PJTran Entries”
22 gl_acct Text[10] Specifies the G/L account of the entry. via Page 42804 “SL Hist. PJTran Entries”
23 gl_subacct Text[24] Specifies the subaccount of the entry. via Page 42804 “SL Hist. PJTran Entries”
24 lupd_datetime DateTime Specifies the last update date of the entry. via Page 42804 “SL Hist. PJTran Entries”
25 lupd_prog Text[8] Specifies the program that last updated the entry. via Page 42804 “SL Hist. PJTran Entries”
26 lupd_user Text[10] Specifies the user that last updated the entry. via Page 42804 “SL Hist. PJTran Entries”
27 noteid Integer —
28 pjt_entity Text[32] Specifies the task associated with the entry. via Page 42804 “SL Hist. PJTran Entries”
29 post_date Date —
30 ProjCury_amount Decimal —
31 ProjCuryEffDate Date —
32 ProjCuryId Text[4] —
33 ProjCuryMultiDiv Text[1] —
34 ProjCuryRate Decimal —
35 ProjCuryRateType Text[6] —
36 project Text[16] Specifies the Project that the entry belongs to. via Page 42804 “SL Hist. PJTran Entries”
37 Subcontract Text[16] Specifies the subcontract of the entry. via Page 42804 “SL Hist. PJTran Entries”
38 SubTask_Name Text[50] Specifies the subtask name associated with the entry. via Page 42804 “SL Hist. PJTran Entries”
39 system_cd Text[2] Specifies the system code of the entry. via Page 42804 “SL Hist. PJTran Entries”
40 TranProjCuryEffDate Date —
41 TranProjCuryId Text[4] —
42 TranProjCuryMultiDiv Text[1] —
43 TranProjCuryRate Decimal —
44 TranProjCuryRateType Text[6] —
45 trans_date Date Specifies the entry’s transaction date. via Page 42804 “SL Hist. PJTran Entries”
46 tr_comment Text[100] Specifies the transaction comment of the entry. via Page 42804 “SL Hist. PJTran Entries”
47 tr_id01 Text[30] Specifies the tr_id01 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
48 tr_id02 Text[30] Specifies the invoice number of the entry. via Page 42804 “SL Hist. PJTran Entries”
49 tr_id03 Text[16] Specifies the purchase order number of the entry. via Page 42804 “SL Hist. PJTran Entries”
50 tr_id04 Text[16] Specifies the source batch number of the entry. via Page 42804 “SL Hist. PJTran Entries”
51 tr_id05 Text[4] Specifies the labor class of the entry. via Page 42804 “SL Hist. PJTran Entries”
52 tr_id06 Decimal Specifies the tr_id06 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
53 tr_id07 Decimal Specifies the tr_id07 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
54 tr_id08 Date Specifies the invoice date of the entry. via Page 42804 “SL Hist. PJTran Entries”
55 tr_id09 Date Specifies the tr_id09 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
56 tr_id10 Integer Specifies the tr_id10 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
57 tr_id23 Text[30] Specifies the tr_id23 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
58 tr_id24 Text[20] Specifies the hours type, shift, and earn type of the entry. via Page 42804 “SL Hist. PJTran Entries”
59 tr_id25 Text[20] Specifies the tr_id25 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
60 tr_id26 Text[10] Specifies the utilization period of the entry. via Page 42804 “SL Hist. PJTran Entries”
61 tr_id27 Text[4] Specifies the tr_id27 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
62 tr_id28 Decimal Specifies the original cost of the allocated transaction. via Page 42804 “SL Hist. PJTran Entries”
63 tr_id29 Date Specifies the tr_id29 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
64 tr_id30 Integer Specifies the PJInvDet transaction ID of the entry. via Page 42804 “SL Hist. PJTran Entries”
65 tr_id31 Decimal Specifies the tr_id31 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
66 tr_id32 Decimal Specifies the tr_id32 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
67 tr_status Text[10] Specifies the transaction status of the entry. via Page 42804 “SL Hist. PJTran Entries”
68 unit_of_measure Text[10] Specifies the unit of measure of the entry. via Page 42804 “SL Hist. PJTran Entries”
69 units Decimal Specifies the units of the entry. via Page 42804 “SL Hist. PJTran Entries”
70 user1 Text[30] Specifies the user1 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
71 user2 Text[30] Specifies the user2 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
72 user3 Decimal Specifies the user3 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
73 user4 Decimal Specifies the user4 field of the entry. via Page 42804 “SL Hist. PJTran Entries”
74 vendor_num Text[15] Specifies the vendor number of the entry. via Page 42804 “SL Hist. PJTran Entries”
75 voucher_line Integer Specifies the line from the source transaction. via Page 42804 “SL Hist. PJTran Entries”
76 voucher_num Text[10] Specifies the reference number from the source transaction. via Page 42804 “SL Hist. PJTran Entries”

Keys

  • PK: fiscalno, system_cd, batch_id, detail_num (clustered)

Pages and codeunits on this table

Recent changes

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. PJTran"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources