Table 42825 "SL Hist. ARTran Archive"

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
1	Acct	Text[10]	Specifies the Account that the entry has been posted to. via Page 42801 “SL Hist. ARTran Entries”
2	AcctDist	Integer	—
3	BatNbr	Text[10]	Specifies the Batch Number that the entry belongs to. via Page 42801 “SL Hist. ARTran Entries”
4	CmmnPct	Decimal	—
5	CnvFact	Decimal	—
6	ContractID	Text[10]	—
7	CostType	Text[8]	—
8	CpnyID	Text[10]	Specifies the Company ID that the entry belongs to. via Page 42801 “SL Hist. ARTran Entries”
9	Crtd_DateTime	DateTime	—
10	Crtd_Prog	Text[8]	—
11	Crtd_User	Text[10]	—
12	CuryExtCost	Decimal	—
13	CuryId	Text[4]	—
14	CuryMultDiv	Text[1]	—
15	CuryRate	Decimal	—
16	CuryTaxAmt00	Decimal	—
17	CuryTaxAmt01	Decimal	—
18	CuryTaxAmt02	Decimal	—
19	CuryTaxAmt03	Decimal	—
20	CuryTranAmt	Decimal	—
21	CuryTxblAmt00	Decimal	—
22	CuryTxblAmt01	Decimal	—
23	CuryTxblAmt02	Decimal	—
24	CuryTxblAmt03	Decimal	—
25	CuryUnitPrice	Decimal	—
26	CustId	Text[15]	Specifies the Customer ID that the entry is associated with. via Page 42801 “SL Hist. ARTran Entries”
27	DrCr	Text[1]	—
28	Excpt	Integer	—
29	ExtCost	Decimal	—
30	ExtRefNbr	Text[15]	—
31	FiscYr	Text[4]	—
32	FlatRateLineNbr	Integer	—
33	InstallNbr	Integer	—
34	InvtId	Text[30]	—
35	JobRate	Decimal	—
36	JrnlType	Text[3]	—
37	LineId	Integer	—
38	LineNbr	Integer	—
39	LineRef	Text[5]	—
40	LUpd_DateTime	DateTime	—
41	LUpd_Prog	Text[8]	—
42	LUpd_User	Text[10]	—
43	MasterDocNbr	Text[10]	—
44	NoteId	Integer	—
45	OrdNbr	Text[15]	—
46	PC_Flag	Text[1]	—
47	PC_ID	Text[20]	—
48	PC_Status	Text[1]	—
49	PerEnt	Text[6]	—
50	PerPost	Text[6]	Specifies the period that the entry was posted to. via Page 42801 “SL Hist. ARTran Entries”
51	ProjectID	Text[16]	Specifies the Project ID that the entry is associated with. via Page 42801 “SL Hist. ARTran Entries”
52	Qty	Decimal	Specifies the quantity that was posted on the entry. via Page 42801 “SL Hist. ARTran Entries”
53	RecordID	Integer	—
54	RefNbr	Text[10]	Specifies the entry’s Reference Number via Page 42801 “SL Hist. ARTran Entries”
55	Rlsed	Integer	Specifies the entry’s Released status. via Page 42801 “SL Hist. ARTran Entries”
56	S4Future01	Text[30]	—
57	S4Future02	Text[30]	—
58	S4Future03	Decimal	—
59	S4Future04	Decimal	—
60	S4Future05	Decimal	—
61	S4Future06	Decimal	—
62	S4Future07	Date	—
63	S4Future08	Date	—
64	S4Future09	Integer	—
65	S4Future10	Integer	—
66	S4Future11	Text[10]	—
67	S4Future12	Text[10]	—
68	ServiceCallID	Text[10]	—
69	ServiceCallLineNbr	Integer	—
70	ServiceDate	Date	—
71	ShipperCpnyID	Text[10]	—
72	ShipperID	Text[15]	—
73	ShipperLineRef	Text[5]	—
74	SiteId	Text[10]	—
75	SlsperId	Text[10]	—
76	SpecificCostID	Text[25]	—
77	Sub	Text[24]	Specifies the Subaccount that the entry has been posted to. via Page 42801 “SL Hist. ARTran Entries”
78	TaskID	Text[32]	Specifies the Task ID that the entry is associated with. via Page 42801 “SL Hist. ARTran Entries”
79	TaxAmt00	Decimal	—
80	TaxAmt01	Decimal	—
81	TaxAmt02	Decimal	—
82	TaxAmt03	Decimal	—
83	TaxCalced	Text[1]	—
84	TaxCat	Text[10]	—
85	TaxId00	Text[10]	—
86	TaxId01	Text[10]	—
87	TaxId02	Text[10]	—
88	TaxId03	Text[10]	—
89	TaxIdDflt	Text[10]	—
90	TranAmt	Decimal	Specifies the Transaction Amount that was posted on the entry. via Page 42801 “SL Hist. ARTran Entries”
91	TranClass	Text[1]	—
92	TranDate	Date	Specifies the entry’s Transaction Date. via Page 42801 “SL Hist. ARTran Entries”
93	TranDesc	Text[30]	Specifies the entry’s Transaction Description. via Page 42801 “SL Hist. ARTran Entries”
94	TranType	Text[2]	Specifies the Transaction Type that the entry belongs to. via Page 42801 “SL Hist. ARTran Entries”
95	TxblAmt00	Decimal	—
96	TxblAmt01	Decimal	—
97	TxblAmt02	Decimal	—
98	TxblAmt03	Decimal	—
99	UnitDesc	Text[6]	—
100	UnitPrice	Decimal	Specifies the Unit Price that was posted on the entry. via Page 42801 “SL Hist. ARTran Entries”
101	User1	Text[30]	—
102	User2	Text[30]	—
103	User3	Decimal	—
104	User4	Decimal	—
105	User5	Text[10]	—
106	User6	Text[10]	—
107	User7	Date	—
108	User8	Date	—
109	WhseLoc	Text[10]	—

Keys

PK: CustId, TranType, RefNbr, LineNbr, RecordID (clustered)

Pages and codeunits on this table

Page 42801 “SL Hist. ARTran 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. ARTran Archive"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.