Table Vendor
ID 23
Namespace: Microsoft.Purchases.Vendor
Properties
Name |
Value |
Caption |
Vendor
|
DataCaptionFields |
1,2
|
DrillDownPageID |
Microsoft.Purchases.Vendor."Vendor List"
|
LookupPageID |
Microsoft.Purchases.Vendor."Vendor Lookup"
|
Permissions |
TableData "Vendor Ledger Entry" = r,
TableData "Service Item" = rm,
TableData "Price List Header" = rd,
TableData "Price List Line" = rd,
#if not CLEAN23
TableData "Purchase Price" = rd,
TableData "Purchase Line Discount" = rd,
#endif
TableData "Purchase Price Access" = rd,
TableData "Purchase Discount Access" = rd,
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]
|
|
"Our Account No." |
Text[20]
|
|
"Territory Code" |
Code[10]
|
|
"Global Dimension 1 Code" |
Code[20]
|
|
"Global Dimension 2 Code" |
Code[20]
|
|
"Budgeted Amount" |
Decimal
|
|
"Vendor Posting Group" |
Code[20]
|
|
"Currency Code" |
Code[10]
|
|
"Language Code" |
Code[10]
|
|
"Registration Number" |
Text[50]
|
|
"Statistics Group" |
Integer
|
|
"Payment Terms Code" |
Code[10]
|
|
"Fin. Charge Terms Code" |
Code[10]
|
|
"Purchaser Code" |
Code[20]
|
|
"Shipment Method Code" |
Code[10]
|
|
"Shipping Agent Code" |
Code[10]
|
|
"Invoice Disc. Code" |
Code[20]
|
|
"Country/Region Code" |
Code[10]
|
|
Comment |
Boolean
|
|
Blocked |
Microsoft.Purchases.Vendor."Vendor Blocked"
|
|
"Pay-to Vendor 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
|
|
"Purchases (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
|
|
"Amt. Rcd. Not Invoiced" |
Decimal
|
|
"Application Method" |
Microsoft.Finance.ReceivablesPayables."Application Method"
|
|
"Prices Including VAT" |
Boolean
|
|
"Fax No." |
Text[30]
|
|
"Telex Answer Back" |
Text[20]
|
|
"VAT Registration No." |
Text[20]
|
|
"Gen. Bus. Posting Group" |
Code[20]
|
|
Picture |
Blob
|
|
GLN |
Code[13]
|
|
"Post Code" |
Code[20]
|
|
County |
Text[30]
|
|
"EORI Number" |
Text[40]
|
|
"Debit Amount" |
Decimal
|
|
"Credit Amount" |
Decimal
|
|
"Debit Amount (LCY)" |
Decimal
|
|
"Credit Amount (LCY)" |
Decimal
|
|
"E-Mail" |
Text[80]
|
|
"Home Page" |
Text[80]
|
|
"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
|
|
"Amt. Rcd. Not Invoiced (LCY)" |
Decimal
|
|
"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" |
Decimal
|
|
"Outstanding Invoices (LCY)" |
Decimal
|
|
"Pay-to No. Of Archived Doc." |
Integer
|
|
"Buy-from 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
|
|
"Company Size Code" |
Code[20]
|
|
Image |
Media
|
|
"Privacy Blocked" |
Boolean
|
|
"Disable Search by Name" |
Boolean
|
|
"Creditor No." |
Code[20]
|
|
"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]
|
|
"Mobile Phone No." |
Text[30]
|
|
"Responsibility Center" |
Code[10]
|
|
"Location Code" |
Code[10]
|
|
"Lead Time Calculation" |
DateFormula
|
|
"Price Calculation Method" |
Microsoft.Pricing.Calculation."Price Calculation Method"
|
|
"No. of Pstd. Receipts" |
Integer
|
|
"No. of Pstd. Invoices" |
Integer
|
|
"No. of Pstd. Return Shipments" |
Integer
|
|
"No. of Pstd. Credit Memos" |
Integer
|
|
"Pay-to No. of Orders" |
Integer
|
|
"Pay-to No. of Invoices" |
Integer
|
|
"Pay-to No. of Return Orders" |
Integer
|
|
"Pay-to No. of Credit Memos" |
Integer
|
|
"Pay-to No. of Pstd. Receipts" |
Integer
|
|
"Pay-to No. of Pstd. Invoices" |
Integer
|
|
"Pay-to No. of Pstd. Return S." |
Integer
|
|
"Pay-to No. of Pstd. Cr. Memos" |
Integer
|
|
"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 Order Addresses" |
Integer
|
|
"Pay-to No. of Quotes" |
Integer
|
|
"Pay-to No. of Blanket Orders" |
Integer
|
|
"No. of Incoming Documents" |
Integer
|
|
"Base Calendar Code" |
Code[10]
|
|
"Document Sending Profile" |
Code[20]
|
|
"Validate EU Vat Reg. No." |
Boolean
|
|
Id |
Guid
|
|
"Currency Id" |
Guid
|
|
"Payment Terms Id" |
Guid
|
|
"Payment Method Id" |
Guid
|
|
"Over-Receipt Code" |
Code[20]
|
|
SystemId |
Guid
|
|
SystemCreatedAt |
DateTime
|
|
SystemCreatedBy |
Guid
|
|
SystemModifiedAt |
DateTime
|
|
SystemModifiedBy |
Guid
|
|
SystemRowVersion |
BigInteger
|
|
Methods
AssistEdit
procedure AssistEdit(OldVend: Record Vendor): Boolean
Parameters
Name |
Type |
Description |
OldVend
|
Record Vendor
|
|
Returns
ValidateShortcutDimCode
procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])
Parameters
Name |
Type |
Description |
FieldNumber
|
Integer
|
|
ShortcutDimCode
|
Code[20]
|
|
ShowContact
SetInsertFromContact
procedure SetInsertFromContact(FromContact: Boolean)
Parameters
Name |
Type |
Description |
FromContact
|
Boolean
|
|
CheckBlockedVendOnDocs
procedure CheckBlockedVendOnDocs(Vend2: Record Vendor, Transaction: Boolean)
Parameters
Name |
Type |
Description |
Vend2
|
Record Vendor
|
|
Transaction
|
Boolean
|
|
CheckBlockedVendOnJnls
procedure CheckBlockedVendOnJnls(Vend2: Record Vendor, DocType: Enum "Gen. Journal Document Type", Transaction: Boolean)
Parameters
CreateAndShowNewInvoice
procedure CreateAndShowNewInvoice()
CreateAndShowNewCreditMemo
procedure CreateAndShowNewCreditMemo()
CreateAndShowNewPurchaseOrder
procedure CreateAndShowNewPurchaseOrder()
VendBlockedErrorMessage
procedure VendBlockedErrorMessage(Vend2: Record Vendor, Transaction: Boolean)
Parameters
Name |
Type |
Description |
Vend2
|
Record Vendor
|
|
Transaction
|
Boolean
|
|
VendPrivacyBlockedErrorMessage
procedure VendPrivacyBlockedErrorMessage(Vend2: Record Vendor, Transaction: Boolean)
Parameters
Name |
Type |
Description |
Vend2
|
Record Vendor
|
|
Transaction
|
Boolean
|
|
GetPrivacyBlockedGenericErrorText
procedure GetPrivacyBlockedGenericErrorText(Vend2: Record Vendor): Text[250]
Parameters
Name |
Type |
Description |
Vend2
|
Record Vendor
|
|
Returns
Type |
Description |
Text[250]
|
|
DisplayMap
CalcOverDueBalance
procedure CalcOverDueBalance(): Decimal
Returns
GetInvoicedPrepmtAmountLCY
procedure GetInvoicedPrepmtAmountLCY(): Decimal
Returns
GetPriceCalculationMethod
procedure GetPriceCalculationMethod(): Enum "Price Calculation Method"
Returns
GetTotalAmountLCY
procedure GetTotalAmountLCY(): Decimal
Returns
HasAddress
procedure HasAddress(): Boolean
Returns
GetBalanceAsCustomer
procedure GetBalanceAsCustomer(var LinkedCustomerNo: Code[20]): Decimal
Parameters
Name |
Type |
Description |
LinkedCustomerNo
|
Code[20]
|
|
Returns
GetLinkedCustomer
procedure GetLinkedCustomer(): Code[20]
Returns
Type |
Description |
Code[20]
|
|
GetVendorNo
procedure GetVendorNo(VendorText: Text[100]): Code[20]
Parameters
Name |
Type |
Description |
VendorText
|
Text[100]
|
|
Returns
Type |
Description |
Code[20]
|
|
GetVendorNoOpenCard
procedure GetVendorNoOpenCard(VendorText: Text[100], ShowVendorCard: Boolean): Code[20]
Parameters
Name |
Type |
Description |
VendorText
|
Text[100]
|
|
ShowVendorCard
|
Boolean
|
|
Returns
Type |
Description |
Code[20]
|
|
SelectVendor
procedure SelectVendor(var Vendor: Record Vendor): Boolean
Parameters
Name |
Type |
Description |
Vendor
|
Record Vendor
|
|
Returns
OpenVendorLedgerEntries
procedure OpenVendorLedgerEntries(FilterOnDueEntries: Boolean)
Parameters
Name |
Type |
Description |
FilterOnDueEntries
|
Boolean
|
|
GetInsertFromContact
procedure GetInsertFromContact(): Boolean
Returns
GetInsertFromTemplate
procedure GetInsertFromTemplate(): Boolean
Returns
SetInsertFromTemplate
procedure SetInsertFromTemplate(FromTemplate: Boolean)
Parameters
Name |
Type |
Description |
FromTemplate
|
Boolean
|
|
SetAddress
procedure SetAddress(VendorAddress: Text[100], VendorAddress2: Text[50], VendorPostCode: Code[20], VendorCity: Text[30], VendorCounty: Text[30], VendorCountryCode: Code[10], VendorContact: Text[100])
Parameters
Name |
Type |
Description |
VendorAddress
|
Text[100]
|
|
VendorAddress2
|
Text[50]
|
|
VendorPostCode
|
Code[20]
|
|
VendorCity
|
Text[30]
|
|
VendorCounty
|
Text[30]
|
|
VendorCountryCode
|
Code[10]
|
|
VendorContact
|
Text[100]
|
|
ToPriceSource
procedure ToPriceSource(var PriceSource: Record "Price Source" temporary)
Parameters
Name |
Type |
Description |
PriceSource
|
Record "Price Source" temporary
|
|
VATRegistrationValidation
procedure VATRegistrationValidation()
UpdateCurrencyId
procedure UpdateCurrencyId()
UpdatePaymentTermsId
procedure UpdatePaymentTermsId()
UpdatePaymentMethodId
procedure UpdatePaymentMethodId()
SetForceUpdateContact
procedure SetForceUpdateContact(NewForceUpdateContact: Boolean)
Parameters
Name |
Type |
Description |
NewForceUpdateContact
|
Boolean
|
|
UpdateReferencedIds
procedure UpdateReferencedIds()
GetReferencedIds
procedure GetReferencedIds(TempField: __MissingTypeSymbol__)
Parameters
Name |
Type |
Description |
TempField
|
__MissingTypeSymbol__
|
|
CheckAllowMultiplePostingGroups
procedure CheckAllowMultiplePostingGroups()
See also