Table 47105 "SL PJTran"

HybridSL · Microsoft.DataMigration.SL · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	SL PJTran
Access	Internal
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
1	acct	Text[16]	—
2	alloc_flag	Text[1]	—
3	amount	Decimal	—
4	BaseCuryId	Text[4]	—
5	batch_id	Text[10]	—
6	batch_type	Text[4]	—
7	bill_batch_id	Text[10]	—
8	CpnyId	Text[10]	—
9	crtd_datetime	DateTime	—
10	crtd_prog	Text[8]	—
11	crtd_user	Text[10]	—
12	CuryEffDate	Date	—
13	CuryId	Text[4]	—
14	CuryMultDiv	Text[1]	—
15	CuryRate	Decimal	—
16	CuryRateType	Text[6]	—
17	CuryTranamt	Decimal	—
18	data1	Text[16]	—
19	detail_num	Integer	—
20	employee	Text[10]	—
21	fiscalno	Text[6]	—
22	gl_acct	Text[10]	—
23	gl_subacct	Text[24]	—
24	lupd_datetime	DateTime	—
25	lupd_prog	Text[8]	—
26	lupd_user	Text[10]	—
27	noteid	Integer	—
28	pjt_entity	Text[32]	—
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]	—
37	Subcontract	Text[16]	—
38	SubTask_Name	Text[50]	—
39	system_cd	Text[2]	—
40	TranProjCuryEffDate	Date	—
41	TranProjCuryId	Text[4]	—
42	TranProjCuryMultiDiv	Text[1]	—
43	TranProjCuryRate	Decimal	—
44	TranProjCuryRateType	Text[6]	—
45	trans_date	Date	—
46	tr_comment	Text[100]	—
47	tr_id01	Text[30]	—
48	tr_id02	Text[30]	—
49	tr_id03	Text[16]	—
50	tr_id04	Text[16]	—
51	tr_id05	Text[4]	—
52	tr_id06	Decimal	—
53	tr_id07	Decimal	—
54	tr_id08	Date	—
55	tr_id09	Date	—
56	tr_id10	Integer	—
57	tr_id23	Text[30]	—
58	tr_id24	Text[20]	—
59	tr_id25	Text[20]	—
60	tr_id26	Text[10]	—
61	tr_id27	Text[4]	—
62	tr_id28	Decimal	—
63	tr_id29	Date	—
64	tr_id30	Integer	—
65	tr_id31	Decimal	—
66	tr_id32	Decimal	—
67	tr_status	Text[10]	—
68	unit_of_measure	Text[10]	—
69	units	Decimal	—
70	user1	Text[30]	—
71	user2	Text[30]	—
72	user3	Decimal	—
73	user4	Decimal	—
74	vendor_num	Text[15]	—
75	voucher_line	Integer	—
76	voucher_num	Text[10]	—

Keys

Key1: fiscalno, system_cd, batch_id, detail_num (clustered)

Recent changes

2026-07-09 #9220 Backport SL Migration - Snapshot Project Transactions (main, BC30, feature, added)

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

Across versions