Table Customer

ID 18

Namespace: Microsoft.Sales.Customer

Properties

Name	Value
Caption	Customer
DataCaptionFields	1,2
DrillDownPageID	Microsoft.Sales.Customer."Customer List"
LookupPageID	Microsoft.Sales.Customer."Customer Lookup"
Permissions	TableData "Cust. Ledger Entry" = r, TableData Job = r, tabledata "VAT Business Posting Group" = R, TableData "VAT Registration Log" = rd, tabledata "Payment Terms" = R, TableData "Service Header" = r, TableData "Service Ledger Entry" = r, TableData "Service Item" = rm, TableData "Service Contract Header" = rm, TableData "Price List Header" = rd, TableData "Price List Line" = rd, #if not CLEAN23 TableData "Sales Price" = rd, TableData "Sales Line Discount" = rd, #endif TableData "Sales Price Access" = rd, TableData "Sales Discount Access" = rd, tabledata "Customer Templ." = rm, tabledata "General Ledger Setup" = r, tabledata "Sales & Receivables Setup" = r, tabledata "Marketing Setup" = r, tabledata Language = r, tabledata "Language Selection" = r
DataClassification	CustomerContent

Fields

Name	Type	Description
"No."	Code[20]
Name	Text[100]
"Search Name"	Code[100]
"Name 2"	Text[50]
Address	Text[100]
"Address 2"	Text[50]
City	Text[30]
Contact	Text[100]
"Phone No."	Text[30]
"Telex No."	Text[20]
"Document Sending Profile"	Code[20]
"Ship-to Code"	Code[10]
"Our Account No."	Text[20]
"Territory Code"	Code[10]
"Global Dimension 1 Code"	Code[20]
"Global Dimension 2 Code"	Code[20]
"Chain Name"	Code[10]
"Budgeted Amount"	Decimal
"Credit Limit (LCY)"	Decimal
"Customer Posting Group"	Code[20]
"Currency Code"	Code[10]
"Customer Price Group"	Code[10]
"Language Code"	Code[10]
"Registration Number"	Text[50]
"Statistics Group"	Integer
"Payment Terms Code"	Code[10]
"Fin. Charge Terms Code"	Code[10]
"Salesperson Code"	Code[20]
"Shipment Method Code"	Code[10]
"Shipping Agent Code"	Code[10]
"Place of Export"	Code[20]
"Invoice Disc. Code"	Code[20]
"Customer Disc. Group"	Code[20]
"Country/Region Code"	Code[10]
"Collection Method"	Code[20]
Amount	Decimal
Comment	Boolean
Blocked	Microsoft.Sales.Customer."Customer Blocked"
"Invoice Copies"	Integer
"Last Statement No."	Integer
"Print Statements"	Boolean
"Bill-to Customer No."	Code[20]
Priority	Integer
"Payment Method Code"	Code[10]
"Format Region"	Text[80]
"Last Modified Date Time"	DateTime
"Last Date Modified"	Date
"Date Filter"	Date
"Global Dimension 1 Filter"	Code[20]
"Global Dimension 2 Filter"	Code[20]
Balance	Decimal
"Balance (LCY)"	Decimal
"Net Change"	Decimal
"Net Change (LCY)"	Decimal
"Sales (LCY)"	Decimal
"Profit (LCY)"	Decimal
"Inv. Discounts (LCY)"	Decimal
"Pmt. Discounts (LCY)"	Decimal
"Balance Due"	Decimal
"Balance Due (LCY)"	Decimal
Payments	Decimal
"Invoice Amounts"	Decimal
"Cr. Memo Amounts"	Decimal
"Finance Charge Memo Amounts"	Decimal
"Payments (LCY)"	Decimal
"Inv. Amounts (LCY)"	Decimal
"Cr. Memo Amounts (LCY)"	Decimal
"Fin. Charge Memo Amounts (LCY)"	Decimal
"Outstanding Orders"	Decimal
"Shipped Not Invoiced"	Decimal
"Application Method"	Microsoft.Finance.ReceivablesPayables."Application Method"
"Prices Including VAT"	Boolean
"Location Code"	Code[10]
"Fax No."	Text[30]
"Telex Answer Back"	Text[20]
"VAT Registration No."	Text[20]
"Combine Shipments"	Boolean
"Gen. Bus. Posting Group"	Code[20]
Picture	Blob
GLN	Code[13]
"Post Code"	Code[20]
County	Text[30]
"EORI Number"	Text[40]
"Use GLN in Electronic Document"	Boolean
"Debit Amount"	Decimal
"Credit Amount"	Decimal
"Debit Amount (LCY)"	Decimal
"Credit Amount (LCY)"	Decimal
"E-Mail"	Text[80]
"Home Page"	Text[80]
"Reminder Terms Code"	Code[10]
"Reminder Amounts"	Decimal
"Reminder Amounts (LCY)"	Decimal
"No. Series"	Code[20]
"Tax Area Code"	Code[20]
"Tax Liable"	Boolean
"VAT Bus. Posting Group"	Code[20]
"Currency Filter"	Code[10]
"Outstanding Orders (LCY)"	Decimal
"Shipped Not Invoiced (LCY)"	Decimal
Reserve	Microsoft.Inventory.Tracking."Reserve Method"
"Block Payment Tolerance"	Boolean
"Pmt. Disc. Tolerance (LCY)"	Decimal
"Pmt. Tolerance (LCY)"	Decimal
"IC Partner Code"	Code[20]
Refunds	Decimal
"Refunds (LCY)"	Decimal
"Other Amounts"	Decimal
"Other Amounts (LCY)"	Decimal
"Prepayment %"	Decimal
"Outstanding Invoices (LCY)"	Decimal
"Outstanding Invoices"	Decimal
"Bill-to No. Of Archived Doc."	Integer
"Sell-to No. Of Archived Doc."	Integer
"Partner Type"	Microsoft.Foundation.Enums."Partner Type"
"Intrastat Partner Type"	Microsoft.Foundation.Enums."Partner Type"
"Exclude from Pmt. Practices"	Boolean
Image	Media
"Privacy Blocked"	Boolean
"Disable Search by Name"	Boolean
"Allow Multiple Posting Groups"	Boolean
"Preferred Bank Account Code"	Code[20]
"Coupled to CRM"	Boolean
"Coupled to Dataverse"	Boolean
"Cash Flow Payment Terms Code"	Code[10]
"Primary Contact No."	Code[20]
"Contact Type"	Microsoft.CRM.Contact."Contact Type"
"Mobile Phone No."	Text[30]
"Responsibility Center"	Code[10]
"Shipping Advice"	Microsoft.Foundation.Shipping."Sales Header Shipping Advice"
"Shipping Time"	DateFormula
"Shipping Agent Service Code"	Code[10]
"Service Zone Code"	Code[10]
"Contract Gain/Loss Amount"	Decimal
"Ship-to Filter"	Code[10]
"Outstanding Serv. Orders (LCY)"	Decimal
"Serv Shipped Not Invoiced(LCY)"	Decimal
"Outstanding Serv.Invoices(LCY)"	Decimal
"Price Calculation Method"	Microsoft.Pricing.Calculation."Price Calculation Method"
"Allow Line Disc."	Boolean
"No. of Quotes"	Integer
"No. of Blanket Orders"	Integer
"No. of Orders"	Integer
"No. of Invoices"	Integer
"No. of Return Orders"	Integer
"No. of Credit Memos"	Integer
"No. of Pstd. Shipments"	Integer
"No. of Pstd. Invoices"	Integer
"No. of Pstd. Return Receipts"	Integer
"No. of Pstd. Credit Memos"	Integer
"No. of Ship-to Addresses"	Integer
"Bill-To No. of Quotes"	Integer
"Bill-To No. of Blanket Orders"	Integer
"Bill-To No. of Orders"	Integer
"Bill-To No. of Invoices"	Integer
"Bill-To No. of Return Orders"	Integer
"Bill-To No. of Credit Memos"	Integer
"Bill-To No. of Pstd. Shipments"	Integer
"Bill-To No. of Pstd. Invoices"	Integer
"Bill-To No. of Pstd. Return R."	Integer
"Bill-To No. of Pstd. Cr. Memos"	Integer
"Base Calendar Code"	Code[10]
"Copy Sell-to Addr. to Qte From"	Microsoft.CRM.Contact."Contact Type"
"Validate EU Vat Reg. No."	Boolean
Id	Guid
"Currency Id"	Guid
"Payment Terms Id"	Guid
"Shipment Method Id"	Guid
"Payment Method Id"	Guid
"Tax Area ID"	Guid
"Tax Area Display Name"	Text[100]
"Contact ID"	Guid
"Contact Graph Id"	Text[250]
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemRowVersion	BigInteger

Methods

AssistEdit

procedure AssistEdit(OldCust: Record Customer): Boolean

Parameters

Name	Type	Description
OldCust	Record Customer

Returns

Type	Description
Boolean

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name	Type	Description
FieldNumber	Integer
ShortcutDimCode	Code[20]

ShowContact

procedure ShowContact()

SetInsertFromContact

procedure SetInsertFromContact(FromContact: Boolean)

Parameters

Name	Type	Description
FromContact	Boolean

CheckBlockedCustOnDocs

procedure CheckBlockedCustOnDocs(Cust2: Record Customer, DocType: Enum "Sales Document Type", Shipment: Boolean, Transaction: Boolean)

Parameters

Name	Type	Description
Cust2	Record Customer
DocType	Microsoft.Sales.Document."Sales Document Type"
Shipment	Boolean
Transaction	Boolean

CheckBlockedCustOnJnls

procedure CheckBlockedCustOnJnls(Cust2: Record Customer, DocType: Enum "Gen. Journal Document Type", Transaction: Boolean)

Parameters

Name	Type	Description
Cust2	Record Customer
DocType	Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type"
Transaction	Boolean

CheckBlockedCustOnJnls

procedure CheckBlockedCustOnJnls(Cust2: Record Customer, var GenJnlLine: Record "Gen. Journal Line", Transaction: Boolean)

Parameters

Name	Type	Description
Cust2	Record Customer
GenJnlLine	Record "Gen. Journal Line"
Transaction	Boolean

CustBlockedErrorMessage

procedure CustBlockedErrorMessage(Cust2: Record Customer, Transaction: Boolean)

Parameters

Name	Type	Description
Cust2	Record Customer
Transaction	Boolean

CustPrivacyBlockedErrorMessage

procedure CustPrivacyBlockedErrorMessage(Cust2: Record Customer, Transaction: Boolean)

Parameters

Name	Type	Description
Cust2	Record Customer
Transaction	Boolean

GetPrivacyBlockedGenericErrorText

procedure GetPrivacyBlockedGenericErrorText(Cust2: Record Customer): Text[250]

Parameters

Name	Type	Description
Cust2	Record Customer

Returns

Type	Description
Text[250]

DisplayMap

procedure DisplayMap()

GetPriceCalculationMethod

procedure GetPriceCalculationMethod(): Enum "Price Calculation Method"

Returns

Type	Description
Microsoft.Pricing.Calculation."Price Calculation Method"

GetPrimaryContact

procedure GetPrimaryContact(CustomerNo: Code[20], var PrimaryContact: Record Contact)

Parameters

Name	Type	Description
CustomerNo	Code[20]
PrimaryContact	Record Contact

GetTotalAmountLCY

procedure GetTotalAmountLCY(): Decimal

Returns

Type	Description
Decimal

GetTotalAmountLCYUI

procedure GetTotalAmountLCYUI(): Decimal

Returns

Type	Description
Decimal

GetSalesLCY

procedure GetSalesLCY(): Decimal

Returns

Type	Description
Decimal

GetTopCustomerHeadlineQueryDocumentTypeFilter

procedure GetTopCustomerHeadlineQueryDocumentTypeFilter(): Text

Returns

Type	Description
Text

CalcAvailableCredit

procedure CalcAvailableCredit(): Decimal

Returns

Type	Description
Decimal

CalcAvailableCreditUI

procedure CalcAvailableCreditUI(): Decimal

Returns

Type	Description
Decimal

CalcOverdueBalance

procedure CalcOverdueBalance(): Decimal

Returns

Type	Description
Decimal

GetLegalEntityType

procedure GetLegalEntityType(): Text

Returns

Type	Description
Text

GetLegalEntityTypeLbl

procedure GetLegalEntityTypeLbl(): Text

Returns

Type	Description
Text

SetStyle

procedure SetStyle(): Text

Returns

Type	Description
Text

HasValidDDMandate

procedure HasValidDDMandate(Date: Date): Boolean

Parameters

Name	Type	Description
Date	Date

Returns

Type	Description
Boolean

GetReturnRcdNotInvAmountLCY

procedure GetReturnRcdNotInvAmountLCY(): Decimal

Returns

Type	Description
Decimal

GetInvoicedPrepmtAmountLCY

procedure GetInvoicedPrepmtAmountLCY(): Decimal

Returns

Type	Description
Decimal

CalcCreditLimitLCYExpendedPct

procedure CalcCreditLimitLCYExpendedPct(): Decimal

Returns

Type	Description
Decimal

CreateAndShowNewInvoice

procedure CreateAndShowNewInvoice()

CreateAndShowNewOrder

procedure CreateAndShowNewOrder()

CreateAndShowNewCreditMemo

procedure CreateAndShowNewCreditMemo()

CreateAndShowNewQuote

procedure CreateAndShowNewQuote()

GetBillToCustomerNo

procedure GetBillToCustomerNo(): Code[20]

Returns

Type	Description
Code[20]

HasAddressIgnoreCountryCode

procedure HasAddressIgnoreCountryCode(): Boolean

Returns

Type	Description
Boolean

HasAddress

procedure HasAddress(): Boolean

Returns

Type	Description
Boolean

HasDifferentAddress

procedure HasDifferentAddress(OtherCustomer: Record Customer): Boolean

Parameters

Name	Type	Description
OtherCustomer	Record Customer

Returns

Type	Description
Boolean

GetBalanceAsVendor

procedure GetBalanceAsVendor(var LinkedVendorNo: Code[20]): Decimal

Parameters

Name	Type	Description
LinkedVendorNo	Code[20]

Returns

Type	Description
Decimal

GetLinkedVendor

procedure GetLinkedVendor(): Code[20]

Returns

Type	Description
Code[20]

GetCustNo

procedure GetCustNo(CustomerText: Text): Text

Parameters

Name	Type	Description
CustomerText	Text

Returns

Type	Description
Text

GetCustNoOpenCard

procedure GetCustNoOpenCard(CustomerText: Text, ShowCustomerCard: Boolean, ShowCreateCustomerOption: Boolean): Code[20]

Parameters

Name	Type	Description
CustomerText	Text
ShowCustomerCard	Boolean
ShowCreateCustomerOption	Boolean

Returns

Type	Description
Code[20]

CreateNewCustomer

procedure CreateNewCustomer(CustomerName: Text[100], ShowCustomerCard: Boolean): Code[20]

Parameters

Name	Type	Description
CustomerName	Text[100]
ShowCustomerCard	Boolean

Returns

Type	Description
Code[20]

SelectCustomer

procedure SelectCustomer(var Customer: Record Customer): Boolean

Parameters

Name	Type	Description
Customer	Record Customer

Returns

Type	Description
Boolean

ToPriceSource

procedure ToPriceSource(var PriceSource: Record "Price Source" temporary)

Parameters

Name	Type	Description
PriceSource	Record "Price Source" temporary

OpenCustomerLedgerEntries

procedure OpenCustomerLedgerEntries(FilterOnDueEntries: Boolean)

Parameters

Name	Type	Description
FilterOnDueEntries	Boolean

SetInsertFromTemplate

procedure SetInsertFromTemplate(FromTemplate: Boolean)

Parameters

Name	Type	Description
FromTemplate	Boolean

IsLookupRequested

procedure IsLookupRequested(): Boolean

Returns

Type	Description
Boolean

IsContactUpdateNeeded

procedure IsContactUpdateNeeded(): Boolean

Returns

Type	Description
Boolean

IsBlocked

procedure IsBlocked(): Boolean

Returns

Type	Description
Boolean

HasAnyOpenOrPostedDocuments

procedure HasAnyOpenOrPostedDocuments(): Boolean

Returns

Type	Description
Boolean

CopyFromNewCustomerTemplate

procedure CopyFromNewCustomerTemplate(CustomerTemplate: Record "Customer Templ.")

Parameters

Name	Type	Description
CustomerTemplate	Record "Customer Templ."

GetInsertFromContact

procedure GetInsertFromContact(): Boolean

Returns

Type	Description
Boolean

GetInsertFromTemplate

procedure GetInsertFromTemplate(): Boolean

Returns

Type	Description
Boolean

VATRegistrationValidation

procedure VATRegistrationValidation()

SetAddress

procedure SetAddress(CustomerAddress: Text[100], CustomerAddress2: Text[50], CustomerPostCode: Code[20], CustomerCity: Text[30], CustomerCounty: Text[30], CustomerCountryCode: Code[10], CustomerContact: Text[100])

Parameters

Name	Type	Description
CustomerAddress	Text[100]
CustomerAddress2	Text[50]
CustomerPostCode	Code[20]
CustomerCity	Text[30]
CustomerCounty	Text[30]
CustomerCountryCode	Code[10]
CustomerContact	Text[100]

FindByEmail

procedure FindByEmail(var Customer: Record Customer, Email: Text): Boolean

Parameters

Name	Type	Description
Customer	Record Customer
Email	Text

Returns

Type	Description
Boolean

UpdateReferencedIds

procedure UpdateReferencedIds()

GetReferencedIds

procedure GetReferencedIds(TempField: __MissingTypeSymbol__)

Parameters

Name	Type	Description
TempField	__MissingTypeSymbol__

SetForceUpdateContact

procedure SetForceUpdateContact(NewForceUpdateContact: Boolean)

Parameters

Name	Type	Description
NewForceUpdateContact	Boolean

UpdateCurrencyId

procedure UpdateCurrencyId()

UpdatePaymentTermsId

procedure UpdatePaymentTermsId()

UpdateShipmentMethodId

procedure UpdateShipmentMethodId()

UpdatePaymentMethodId

procedure UpdatePaymentMethodId()

UpdateTaxAreaId

procedure UpdateTaxAreaId()

CheckAllowMultiplePostingGroups

procedure CheckAllowMultiplePostingGroups()

See also

• Table