Standard Customer Sales Code #172

Other table in Microsoft Dynamics 365 Business Central. 19 fields, 0 records in Cronus demo.

The Standard Customer Sales Code table (ID 172) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 19 fields, with a primary key of Customer No., Code. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Customer No., Code.

All fields (19)

Standard Customer Sales Code — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Customer No. PK	Code	Normal	→ Customer #18
2	Code PK	Code	Normal	→ Standard Sales Code #170
3	Description	Text	Normal
4	Valid From Date	Date	Normal
5	Valid To date	Date	Normal
6	Payment Method Code	Code	Normal	→ Payment Method #289
7	Payment Terms Code	Code	Normal	→ Payment Terms #3
8	Direct Debit Mandate ID	Code	Normal	→ SEPA Direct Debit Mandate #1230
9	Blocked	Boolean	Normal
13	Currency Code	Code	Normal	→ Currency #4
15	Insert Rec. Lines On Quotes	Option	Normal
16	Insert Rec. Lines On Orders	Option	Normal
17	Insert Rec. Lines On Invoices	Option	Normal
18	Insert Rec. Lines On Cr. Memos	Option	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (7)

Tables referenced by fields on the Standard Customer Sales Code table through TableRelation properties.

Customer

#18 · Sales · via Customer No.

Standard Sales Code

#170 · Other · via Code

Payment Method

#289 · Other · via Payment Method Code

Payment Terms

#3 · General Ledger · via Payment Terms Code

SEPA Direct Debit Mandate

#1230 · Other · via Direct Debit Mandate ID

Currency

#4 · General Ledger · via Currency Code