Table 47012 "SL Customer"

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

Properties

Property	Value
Caption	SL Customer
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	AccrRevAcct	Text[10]	—
2	AccrRevSub	Text[24]	—
3	AcctNbr	Text[30]	—
4	Addr1	Text[60]	—
5	Addr2	Text[60]	—
6	AgentID	Text[10]	—
7	ApplFinChrg	Integer	—
8	ArAcct	Text[10]	—
9	ArSub	Text[24]	—
10	Attn	Text[30]	—
11	AutoApply	Integer	—
12	BankID	Text[10]	—
13	BillAddr1	Text[60]	—
14	BillAddr2	Text[60]	—
15	BillAttn	Text[30]	—
16	BillCity	Text[30]	—
17	BillCountry	Text[3]	—
18	BillFax	Text[30]	—
19	BillName	Text[60]	—
20	BillPhone	Text[30]	—
21	BillSalut	Text[30]	—
22	BillState	Text[3]	—
23	BillThruProject	Integer	—
24	BillZip	Text[10]	—
25	CardExpDate	DateTime	—
26	CardHldrName	Text[60]	—
27	CardNbr	Text[20]	—
28	CardType	Text[1]	—
29	City	Text[30]	—
30	ClassId	Text[6]	—
31	ConsolInv	Integer	—
32	Country	Text[3]	—
33	CrLmt	Decimal	—
34	Crtd_DateTime	DateTime	—
35	Crtd_Prog	Text[8]	—
36	Crtd_User	Text[10]	—
37	CuryId	Text[4]	—
38	CuryPrcLvlRtTp	Text[6]	—
39	CuryRateType	Text[6]	—
40	CustFillPriority	Integer	—
41	CustId	Text[15]	—
42	DfltShipToId	Text[10]	—
43	DocPublishingFlag	Text[1]	—
44	DunMsg	Integer	—
45	EMailAddr	Text[80]	—
46	Fax	Text[30]	—
47	InvtSubst	Integer	—
48	LanguageID	Text[4]	—
49	LUpd_DateTime	DateTime	—
50	LUpd_Prog	Text[8]	—
51	LUpd_User	Text[10]	—
52	Name	Text[60]	—
53	NoteId	Integer	—
54	OneDraft	Integer	—
55	PerNbr	Text[6]	—
56	Phone	Text[30]	—
57	PmtMethod	Text[1]	—
58	PrcLvlId	Text[10]	—
59	PrePayAcct	Text[10]	—
60	PrePaySub	Text[24]	—
61	PriceClassID	Text[6]	—
62	PrtMCStmt	Integer	—
63	PrtStmt	Integer	—
64	S4Future01	Text[30]	—
65	S4Future02	Text[30]	—
66	S4Future03	Decimal	—
67	S4Future04	Decimal	—
68	S4Future05	Decimal	—
69	S4Future06	Decimal	—
70	S4Future07	DateTime	—
71	S4Future08	DateTime	—
72	S4Future09	Integer	—
73	S4Future10	Integer	—
74	S4Future11	Text[10]	—
75	S4Future12	Text[10]	—
76	Salut	Text[30]	—
77	SetupDate	DateTime	—
78	ShipCmplt	Integer	—
79	ShipPctAct	Text[1]	—
80	ShipPctMax	Decimal	—
81	SICCode1	Text[4]	—
82	SICCode2	Text[4]	—
83	SingleInvoice	Integer	—
84	SlsAcct	Text[10]	—
85	SlsperId	Text[10]	—
86	SlsSub	Text[24]	—
87	State	Text[3]	—
88	Status	Text[1]	—
89	StmtCycleId	Text[2]	—
90	StmtType	Text[1]	—
91	TaxDflt	Text[1]	—
92	TaxExemptNbr	Text[15]	—
93	TaxID00	Text[10]	—
94	TaxID01	Text[10]	—
95	TaxID02	Text[10]	—
96	TaxID03	Text[10]	—
97	TaxLocId	Text[15]	—
98	TaxRegNbr	Text[15]	—
99	Terms	Text[2]	—
100	Territory	Text[10]	—
101	TradeDisc	Decimal	—
102	User1	Text[30]	—
103	User2	Text[30]	—
104	User3	Decimal	—
105	User4	Decimal	—
106	User5	Text[10]	—
107	User6	Text[10]	—
108	User7	DateTime	—
109	User8	DateTime	—
110	Zip	Text[10]	—

Keys

Key1: CustId (clustered)

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

Across versions

Properties

Fields

Keys

Ask your agent

Evidence 1 sources