Table 5355 CRM Invoice in 17

Jonas Paprotka, Base Application 17.5.22499.32099, checked 2026-09-20

App: Base Application

Versions1718 19 20 21 22 23 24 25 26 27 28 latest

Source29

Fields, 97

Id	Name	Type	Obsolete
1	InvoiceId	Guid	-
2	OpportunityId	Guid	-
3	PriorityCode	Option	-
4	SalesOrderId	Guid	-
5	OwningUser	Guid	-
6	OwningBusinessUnit	Guid	-
7	LastBackofficeSubmit	Date	-
8	PriceLevelId	Guid	-
9	AccountId	Guid	-
10	ContactId	Guid	-
11	InvoiceNumber	Text[100]	-
12	Name	Text[250]	-
13	Description	Blob	-
14	DiscountAmount	Decimal	-
15	FreightAmount	Decimal	-
16	TotalAmount	Decimal	-
17	TotalLineItemAmount	Decimal	-
18	TotalLineItemDiscountAmount	Decimal	-
19	TotalAmountLessFreight	Decimal	-
20	TotalDiscountAmount	Decimal	-
21	CreatedBy	Guid	-
22	TotalTax	Decimal	-
23	ShippingMethodCode	Option	Pending 16.0
This field is replaced by field 97 ShippingMethodCodeEnum
24	PaymentTermsCode	Option	Pending 16.0
This field is replaced by field 96 PaymentTermsCodeEnum
25	CreatedOn	DateTime	-
26	ModifiedBy	Guid	-
27	ModifiedOn	DateTime	-
28	StateCode	Option	-
29	StatusCode	Option	-
30	ShipTo_Name	Text[200]	-
31	VersionNumber	BigInteger	-
32	PricingErrorCode	Option	-
33	ShipTo_Line1	Text[250]	-
34	ShipTo_Line2	Text[250]	-
35	ShipTo_Line3	Text[250]	-
36	ShipTo_City	Text[80]	-
37	ShipTo_StateOrProvince	Text[50]	-
38	ShipTo_Country	Text[80]	-
39	ShipTo_PostalCode	Text[20]	-
40	WillCall	Boolean	-
41	ShipTo_Telephone	Text[50]	-
42	BillTo_Name	Text[200]	-
43	ShipTo_FreightTermsCode	Option	-
44	ShipTo_Fax	Text[50]	-
45	BillTo_Line1	Text[250]	-
46	BillTo_Line2	Text[250]	-
47	BillTo_Line3	Text[250]	-
48	BillTo_City	Text[80]	-
49	BillTo_StateOrProvince	Text[50]	-
50	BillTo_Country	Text[80]	-
51	BillTo_PostalCode	Text[20]	-
52	BillTo_Telephone	Text[50]	-
53	BillTo_Fax	Text[50]	-
54	DiscountPercentage	Decimal	-
55	ContactIdName	Text[160]	-
56	AccountIdName	Text[160]	-
57	OpportunityIdName	Text[250]	-
58	SalesOrderIdName	Text[250]	-
59	PriceLevelIdName	Text[100]	-
60	CreatedByName	Text[200]	-
61	ModifiedByName	Text[200]	-
62	CustomerId	Guid	-
63	CustomerIdType	Option	-
64	OwnerId	Guid	-
65	OwnerIdType	Option	-
66	IsPriceLocked	Boolean	-
67	DateDelivered	Date	-
68	DueDate	Date	-
69	TimeZoneRuleVersionNumber	Integer	-
70	ImportSequenceNumber	Integer	-
71	OverriddenCreatedOn	Date	-
72	ExchangeRate	Decimal	-
73	UTCConversionTimeZoneCode	Integer	-
74	TransactionCurrencyId	Guid	-
75	TransactionCurrencyIdName	Text[100]	-
76	TotalLineItemAmount_Base	Decimal	-
77	TotalLineItemDiscountAmount_Ba	Decimal	-
78	TotalTax_Base	Decimal	-
79	TotalAmountLessFreight_Base	Decimal	-
80	DiscountAmount_Base	Decimal	-
81	TotalAmount_Base	Decimal	-
82	FreightAmount_Base	Decimal	-
83	TotalDiscountAmount_Base	Decimal	-
84	CreatedOnBehalfBy	Guid	-
85	CreatedOnBehalfByName	Text[200]	-
86	ModifiedOnBehalfBy	Guid	-
87	ModifiedOnBehalfByName	Text[200]	-
88	OwningTeam	Guid	-
89	BillTo_Composite	Blob	-
90	ShipTo_Composite	Blob	-
91	ProcessId	Guid	-
92	StageId	Guid	-
93	EntityImageId	Guid	-
94	TraversedPath	Text[250]	-
95	CompanyId	Guid	-
96	PaymentTermsCodeEnum	Enum CDS Payment Terms Code	-
97	ShippingMethodCodeEnum	Enum CDS Shipping Agent Code	-

Keys, 2

Name	Fields	Obsolete
Key1, clustered	InvoiceId	-
Key2	Name	-