Standard Customer Sales Code #172

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

19
Fields
0
Records
2
Primary key
0
FlowFields
8
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.FIELDTYPECLASSRELATION
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