Table 23 Vendor in 19
- App
- Base Application
Fields, 138Keys, 17Procedures, 36Events, 31
Versions171819202122232425262728latest
Source29
Fields, 138
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | - | ||||
| 2 | Name | Text[100] | - | ||||
| 3 | Search Name | Code[100] | - | ||||
| 4 | Name 2 | Text[50] | - | ||||
| 5 | Address | Text[100] | - | ||||
| 6 | Address 2 | Text[50] | - | ||||
| 7 | City | Text[30] | - | ||||
| 8 | Contact | Text[100] | - | ||||
| 9 | Phone No. | Text[30] | - | ||||
| 10 | Telex No. | Text[20] | - | ||||
| 14 | Our Account No. | Text[20] | - | ||||
| 15 | Territory Code | Code[10] | - | ||||
| 16 | Global Dimension 1 Code | Code[20] | - | ||||
| 17 | Global Dimension 2 Code | Code[20] | - | ||||
| 19 | Budgeted Amount | Decimal | - | ||||
| 21 | Vendor Posting Group | Code[20] | - | ||||
| 22 | Currency Code | Code[10] | - | ||||
| 24 | Language Code | Code[10] | - | ||||
| 26 | Statistics Group | Integer | - | ||||
| 27 | Payment Terms Code | Code[10] | - | ||||
| 28 | Fin. Charge Terms Code | Code[10] | - | ||||
| 29 | Purchaser Code | Code[20] | - | ||||
| 30 | Shipment Method Code | Code[10] | - | ||||
| 31 | Shipping Agent Code | Code[10] | - | ||||
| 33 | Invoice Disc. Code | Code[20] | - | ||||
| 35 | Country/Region Code | Code[10] | - | ||||
| 38 | Comment | Boolean | - | ||||
| 39 | Blocked | Enum Vendor Blocked | - | ||||
| 45 | Pay-to Vendor No. | Code[20] | - | ||||
| 46 | Priority | Integer | - | ||||
| 47 | Payment Method Code | Code[10] | - | ||||
| 53 | Last Modified Date Time | DateTime | - | ||||
| 54 | Last Date Modified | Date | - | ||||
| 55 | Date Filter | Date | - | ||||
| 56 | Global Dimension 1 Filter | Code[20] | - | ||||
| 57 | Global Dimension 2 Filter | Code[20] | - | ||||
| 58 | Balance | Decimal | - | ||||
| 59 | Balance (LCY) | Decimal | - | ||||
| 60 | Net Change | Decimal | - | ||||
| 61 | Net Change (LCY) | Decimal | - | ||||
| 62 | Purchases (LCY) | Decimal | - | ||||
| 64 | Inv. Discounts (LCY) | Decimal | - | ||||
| 65 | Pmt. Discounts (LCY) | Decimal | - | ||||
| 66 | Balance Due | Decimal | - | ||||
| 67 | Balance Due (LCY) | Decimal | - | ||||
| 69 | Payments | Decimal | - | ||||
| 70 | Invoice Amounts | Decimal | - | ||||
| 71 | Cr. Memo Amounts | Decimal | - | ||||
| 72 | Finance Charge Memo Amounts | Decimal | - | ||||
| 74 | Payments (LCY) | Decimal | - | ||||
| 75 | Inv. Amounts (LCY) | Decimal | - | ||||
| 76 | Cr. Memo Amounts (LCY) | Decimal | - | ||||
| 77 | Fin. Charge Memo Amounts (LCY) | Decimal | - | ||||
| 78 | Outstanding Orders | Decimal | - | ||||
| 79 | Amt. Rcd. Not Invoiced | Decimal | - | ||||
| 80 | Application Method | Enum Application Method | - | ||||
| 82 | Prices Including VAT | Boolean | - | ||||
| 84 | Fax No. | Text[30] | - | ||||
| 85 | Telex Answer Back | Text[20] | - | ||||
| 86 | VAT Registration No. | Text[20] | - | ||||
| 88 | Gen. Bus. Posting Group | Code[20] | - | ||||
| 89 | Picture | Blob | Removed 18.0 | ||||
| Replaced by Image field | |||||||
| 90 | GLN | Code[13] | - | ||||
| 91 | Post Code | Code[20] | - | ||||
| 92 | County | Text[30] | - | ||||
| 93 | EORI Number | Text[40] | - | ||||
| 97 | Debit Amount | Decimal | - | ||||
| 98 | Credit Amount | Decimal | - | ||||
| 99 | Debit Amount (LCY) | Decimal | - | ||||
| 100 | Credit Amount (LCY) | Decimal | - | ||||
| 102 | Text[80] | - | |||||
| 103 | Home Page | Text[80] | - | ||||
| 104 | Reminder Amounts | Decimal | - | ||||
| 105 | Reminder Amounts (LCY) | Decimal | - | ||||
| 107 | No. Series | Code[20] | - | ||||
| 108 | Tax Area Code | Code[20] | - | ||||
| 109 | Tax Liable | Boolean | - | ||||
| 110 | VAT Bus. Posting Group | Code[20] | - | ||||
| 111 | Currency Filter | Code[10] | - | ||||
| 113 | Outstanding Orders (LCY) | Decimal | - | ||||
| 114 | Amt. Rcd. Not Invoiced (LCY) | Decimal | - | ||||
| 116 | Block Payment Tolerance | Boolean | - | ||||
| 117 | Pmt. Disc. Tolerance (LCY) | Decimal | - | ||||
| 118 | Pmt. Tolerance (LCY) | Decimal | - | ||||
| 119 | IC Partner Code | Code[20] | - | ||||
| 120 | Refunds | Decimal | - | ||||
| 121 | Refunds (LCY) | Decimal | - | ||||
| 122 | Other Amounts | Decimal | - | ||||
| 123 | Other Amounts (LCY) | Decimal | - | ||||
| 124 | Prepayment % | Decimal | - | ||||
| 125 | Outstanding Invoices | Decimal | - | ||||
| 126 | Outstanding Invoices (LCY) | Decimal | - | ||||
| 130 | Pay-to No. Of Archived Doc. | Integer | - | ||||
| 131 | Buy-from No. Of Archived Doc. | Integer | - | ||||
| 132 | Partner Type | Enum Partner Type | - | ||||
| 140 | Image | Media | - | ||||
| 150 | Privacy Blocked | Boolean | - | ||||
| 160 | Disable Search by Name | Boolean | - | ||||
| 170 | Creditor No. | Code[20] | - | ||||
| 288 | Preferred Bank Account Code | Code[20] | - | ||||
| 720 | Coupled to CRM | Boolean | - | ||||
| 840 | Cash Flow Payment Terms Code | Code[10] | - | ||||
| 5049 | Primary Contact No. | Code[20] | - | ||||
| 5061 | Mobile Phone No. | Text[30] | - | ||||
| 5700 | Responsibility Center | Code[10] | - | ||||
| 5701 | Location Code | Code[10] | - | ||||
| 5790 | Lead Time Calculation | DateFormula | - | ||||
| 7000 | Price Calculation Method | Enum Price Calculation Method | - | ||||
| 7177 | No. of Pstd. Receipts | Integer | - | ||||
| 7178 | No. of Pstd. Invoices | Integer | - | ||||
| 7179 | No. of Pstd. Return Shipments | Integer | - | ||||
| 7180 | No. of Pstd. Credit Memos | Integer | - | ||||
| 7181 | Pay-to No. of Orders | Integer | - | ||||
| 7182 | Pay-to No. of Invoices | Integer | - | ||||
| 7183 | Pay-to No. of Return Orders | Integer | - | ||||
| 7184 | Pay-to No. of Credit Memos | Integer | - | ||||
| 7185 | Pay-to No. of Pstd. Receipts | Integer | - | ||||
| 7186 | Pay-to No. of Pstd. Invoices | Integer | - | ||||
| 7187 | Pay-to No. of Pstd. Return S. | Integer | - | ||||
| 7188 | Pay-to No. of Pstd. Cr. Memos | Integer | - | ||||
| 7189 | No. of Quotes | Integer | - | ||||
| 7190 | No. of Blanket Orders | Integer | - | ||||
| 7191 | No. of Orders | Integer | - | ||||
| 7192 | No. of Invoices | Integer | - | ||||
| 7193 | No. of Return Orders | Integer | - | ||||
| 7194 | No. of Credit Memos | Integer | - | ||||
| 7195 | No. of Order Addresses | Integer | - | ||||
| 7196 | Pay-to No. of Quotes | Integer | - | ||||
| 7197 | Pay-to No. of Blanket Orders | Integer | - | ||||
| 7198 | No. of Incoming Documents | Integer | - | ||||
| 7600 | Base Calendar Code | Code[10] | - | ||||
| 7601 | Document Sending Profile | Code[20] | - | ||||
| 7602 | Validate EU Vat Reg. No. | Boolean | - | ||||
| 8000 | Id | Guid | Pending 15.0 | ||||
| This functionality will be replaced by the systemID field | |||||||
| 8001 | Currency Id | Guid | - | ||||
| 8002 | Payment Terms Id | Guid | - | ||||
| 8003 | Payment Method Id | Guid | - | ||||
| 8510 | Over-Receipt Code | Code[20] | - | ||||
Keys, 17
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Name | - |
| Key3 | Vendor Posting Group | - |
| Key4 | Currency Code | - |
| Key5 | Priority | - |
| Key6 | Country/Region Code | - |
| Key7 | Gen. Bus. Posting Group | - |
| Key8 | VAT Registration No. | - |
| Key9 | Name | - |
| Key10 | City | - |
| Key11 | Post Code | - |
| Key12 | Phone No. | - |
| Key13 | Contact | - |
| Key14 | Blocked | - |
| Key15 | SystemModifiedAt | - |
| Key16 | Coupled to CRM | - |
| Key21 | IC Partner Code | - |
Procedures, 36
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| AssistEdit | (Record Vendor) | Boolean | public | - | |||
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| ShowContact | () | public | - | ||||
| SetInsertFromContact | (Boolean) | public | - | ||||
| CheckBlockedVendOnDocs | (Record Vendor, Boolean) | public | - | ||||
| CheckBlockedVendOnJnls | (Record Vendor, Enum Gen. Journal Document Type, Boolean) | public | - | ||||
| CreateAndShowNewInvoice | () | public | - | ||||
| CreateAndShowNewCreditMemo | () | public | - | ||||
| CreateAndShowNewPurchaseOrder | () | public | - | ||||
| VendBlockedErrorMessage | (Record Vendor, Boolean) | public | - | ||||
| VendPrivacyBlockedErrorMessage | (Record Vendor, Boolean) | public | - | ||||
| GetPrivacyBlockedGenericErrorText | (Record Vendor) | Text[250] | public | - | |||
| DisplayMap | () | public | - | ||||
| CalcOverDueBalance | () | Decimal | public | - | |||
| GetInvoicedPrepmtAmountLCY | () | Decimal | public | - | |||
| GetPriceCalculationMethod | () | Enum Price Calculation Method | public | - | |||
| GetTotalAmountLCY | () | Decimal | public | - | |||
| HasAddress | () | Boolean | public | - | |||
| GetVendorNo | (Text[100]) | Code[20] | public | - | |||
| GetVendorNoOpenCard | (Text[100], Boolean) | Code[20] | public | - | |||
| SelectVendor | (var Record Vendor) | Boolean | public | - | |||
| LookupVendor | (var Record Vendor) | Boolean | public | - | |||
| OpenVendorLedgerEntries | (Boolean) | public | - | ||||
| GetInsertFromContact | () | Boolean | public | - | |||
| GetInsertFromTemplate | () | Boolean | public | - | |||
| SetInsertFromTemplate | (Boolean) | public | - | ||||
| SetAddress | (Text[100], Text[50], Code[20], Text[30], Text[30], Code[10], Text[100]) | public | - | ||||
| UpdateCurrencyId | () | public | - | ||||
| UpdatePaymentTermsId | () | public | - | ||||
| UpdatePaymentMethodId | () | public | - | ||||
| UpdateReferencedIds | () | public | - | ||||
| GetReferencedIds | (var Record Field) | public | - | ||||
| ValidatePricesIncludingVATOnAfterGetVATPostingSetup | (var Record VAT Posting Setup) | public | Pending 16.0 | ||||
| Replaced by the new implementation (V16) of price calculation. | |||||||
| ToPriceSource | (var Record Price Source) | public | - | ||||
| SetDefaultPurchaser | () | protected | - | ||||
| VATRegistrationValidation | () | public | - | ||||
Events, 31
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterValidateCity | (var Record Vendor, Record Vendor) | - | ||||
| Integration event | OnAfterValidatePostCode | (var Record Vendor, Record Vendor) | - | ||||
| Integration event | OnAfterValidateShortcutDimCode | (var Record Vendor, Record Vendor, Integer, var Code[20]) | - | ||||
| Integration event | OnAssistEditOnBeforeExit | (var Record Vendor) | - | ||||
| Integration event | OnBeforeIsContactUpdateNeeded | (Record Vendor, Record Vendor, var Boolean) | - | ||||
| Integration event | OnBeforeCheckBlockedVend | (Record Vendor, Option, Option, Boolean, var Boolean) | - | ||||
| Integration event | OnBeforeCheckOutstandingPurchaseDocuments | (Record Vendor, var Boolean) | - | ||||
| Integration event | OnBeforeGetVendorNoOpenCard | (Text, Boolean, var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeCalcOverdueBalance | (var Record Vendor, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeGetInvoicedPrepmtAmountLCY | (var Record Vendor, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeGetTotalAmountLCY | (var Record Vendor, var Decimal, var Boolean) | - | ||||
| Integration event | OnBeforeOnInsert | (var Record Vendor, var Boolean) | - | ||||
| Integration event | OnBeforeOpenVendorLedgerEntries | (var Record Vendor, var Record Detailed Vendor Ledg. Entry) | - | ||||
| Integration event | OnBeforeLookupCity | (var Record Vendor, var Record Post Code) | - | ||||
| Integration event | OnBeforeLookupPostCode | (var Record Vendor, var Record Post Code) | - | ||||
| Integration event | OnBeforeSetDefaultPurchaser | (var Record Vendor, var Boolean) | - | ||||
| Integration event | OnBeforeValidateCity | (var Record Vendor, var Record Post Code) | - | ||||
| Integration event | OnBeforeValidatePostCode | (var Record Vendor, var Record Post Code) | - | ||||
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Vendor, var Record Vendor, Integer, var Code[20], var Boolean) | - | ||||
| Integration event | OnGetVendorNoOpenCardOnBeforeVendorFindSet | (var Record Vendor) | - | ||||
| Integration event | OnGetVendorNoOpenCardOnAfterVendorSetFilterFromStart | (var Record Vendor) | - | ||||
| Integration event | OnGetVendorNoOpenCardOnAfterSetVendorWithoutQuote | (var Record Vendor) | - | ||||
| Integration event | OnGetVendorNoOpenCardonAfterSetvendorFilters | (var Record Vendor, var Text) | - | ||||
| Integration event | OnMarkVendorsWithSimilarNameOnBeforeVendorFindSet | (var Record Vendor) | - | ||||
| Integration event | OnShowContactOnBeforeOpenContactCard | (var Record Contact, var Integer) | - | ||||
| Integration event | OnShowContactOnBeforeOpenContactList | (var Record Contact, var Integer) | - | ||||
| Integration event | OnValidatePricesIncludingVATOnAfterGetVATPostingSetup | (var Record VAT Posting Setup) | Pending 16.0 | ||||
| Replaced by the new implementation (V16) of price calculation. | |||||||
| Integration event | OnAfterOnInsert | (var Record Vendor) | - | ||||
| Integration event | OnBeforeCreateNewVendor | (Text[100], Boolean, var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeValidateVATRegistrationNo | (var Record Vendor, Record Vendor, Integer, var Boolean) | - | ||||
| Integration event | OnBeforeVATRegistrationValidation | (var Record Vendor, var Boolean, Integer) | - | ||||