| |
|---|
Column Filter Show/Hide |
|
Delete |
|
Edit |
|
Excel |
|
Favorites |
|
Group By Show/Hide |
|
Help |
|
New |
|
Notes |
|
Quick Column Filter |
|
Refresh |
|
Saved Column Layout |
|
Fields | Description |
Checkbox |
|
1099 Type | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.TenNinetyNineTypeSK |
Address Line 1 | This represents the 'Address 1' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.AddressLine1 |
Address Line 2 | This represents the 'Address 2' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.AddressLine2 |
Address Line 3 | This represents the 'Address 3' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.AddressLine3 |
City | This represents the 'City' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.City |
Currency | This is required, but is only for information and does not drive any functionality. This is always editable from the Vendor Record View. Database Field: ERPx_APVendor.CurrencySK |
Default Payment Address ID | Identifies the Address ID on the Vendor account where the 'Payment' Default Address is set to "Yes". Each Vendor is required to have one, and only one, address ID identified as the Payment Default. The Address Identified as the default is the one that payments are automatically associated with. Database Field: ERPx_APVendorAddress.IsRemitTo = 1 |
Email | This represents the 'Email' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.Email |
GL-Accounts Payable | This is not required but if blank, transactions for this Vendor will not be able to be posted. This is always editable from the Vendor Record View. Database Field: ERPx_APVendor.APGLAcctRef |
GL-Purchases | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.APGLAcctRef |
GL-Terms Discount Taken | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.DiscTakenGLAcctRef |
GL-Write Off | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.WriteOffGLAcctRef |
Inactive | This is always editable from the Vendor Record View but only Vendors with no open transactions can be set to Inactive. Database Field: ERPx_APVendor.IsInactive |
On Hold | This is always editable from the Vendor Record View. Database Field: ERPx_APVendor.IsOnHold |
Payment Name | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.CheckName |
Payment Terms | This is required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.PaymentTermSK |
Phone | This represents the 'Phone' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.Phone1 |
State | This represents the 'State' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.State |
Tax ID | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.TaxID |
Tax Registration | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.TaxRegistration |
Vendor Account | This is not required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.VendorAccount |
Vendor Attribute Class | This is not required, but without it, attribute values cannot be assigned or edited for this account. This is always editable from the Vendor Record View. Database Field: ERPx_APVendor.AttributeClassSK |
Vendor Class ID | This is not required and is always editable from the Vendor Record View but changing it will not update any of the default vendor properties or accounts that are assigned on the new Class. Vendor Classes are managed in the Vendor Class master file. Database Fields: ERPx_APVendorClass.Description, ERPx_APVendor.VendorClassSK |
Vendor ID | Clicking on the hyperlink opens the record view for the selected Customer. This is required and is always editable from the Vendor Record View but only in systems that are not integrating Vendors with a third party system. To be editable, the "Vendor" 'Transaction Type on both the 'Inbound to NorthScope' and 'Outbound from NorthScope' Integration Modes must be set to "None" on the Integration Configuration page. Database Field: ERPx_APVendor.VendorID |
Vendor Name | This is required and is always editable from the Vendor Record View. Database Field: ERPx_APVendor.VendorName |
Zip | This represents the 'State' property from the Address ID that is assigned as the 'Payment Default'. This is not required and is always editable from the 'Addresses' tab of the Vendor Record View. Database Field: ERPx_APVendorAddress.Zip |