NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for changing a record in Supplier Change Import.
Supplier Code |
Sequence Number (only for ship-from or remit-to address changes) |
Field to change (specify either the name or the number) |
New Data |
Example
Supplier Code |
Sequence Number |
Field to change |
New Data |
|
|
|
|
10000 |
|
supplier-name |
Supplier A New Name |
10000 |
1 |
60100 |
Ship-from New Name |
If the import file includes a sequence number for a non ship-from or remit-to field, the import process will error out.
The following table lists fields that can be updated. You can indicate a field by either its field name or its number.
Number |
Field |
Maximum Length |
Format |
Description |
Apprise Field |
10100 |
supplier-name |
40 |
Character |
Enter the name of the supplier. |
Supplier Name field on the Main tab in Supplier Maintenance |
10200 |
alt-search |
40 |
Character |
Enter an alternate name or acronym to use for browsing and searching for this supplier instead of the supplier's full name. |
Search Name field on the Main tab in Supplier Maintenance |
10300 |
active |
3 |
Yes/No |
Enter Yes or Y to mark the supplier as active. If you enter Yes or Y, the supplier appears in most Lookup windows, and can be selected in Voucher Entry and other windows where a supplier is entered. Enter No or N to mark the supplier as inactive. |
Active check box on the Main tab in Supplier Maintenance |
10400 |
discontinue-po |
3 |
Yes/No |
Enter Yes or Y to prevent purchase orders from being created for the supplier. If you enter Yes or Y, vouchers and payments can still be entered for the supplier, but purchase orders cannot be entered or imported for the supplier. Enter No or N to allow purchase orders to be created for the supplier. |
Discontinue Purchase Orders check box on the Main tab in Supplier Maintenance |
10500 |
temporary-supplier |
3 |
Yes/No |
Enter Yes or Y for temporary suppliers. If you enter Yes or Y, this supplier does not appear in most Lookup windows (such as from Voucher Entry). Note You can still manually enter the supplier code to enter invoices in Voucher Entry for a temporary supplier. Enter No or N if the supplier is not a temporary supplier. |
Temporary Supplier check box on the Main tab in Supplier Maintenance |
10600 |
start-date |
10 |
99/99/9999 |
Enter a start date for the supplier's services. This field is informational only. |
Start Date field on the Main tab in Supplier Maintenance |
10700 |
supplier-status |
8 |
Character |
Enter the current status of the supplier. You can enter one of the following statuses.
|
Status field on the Main tab in Supplier Maintenance |
10800 |
history-company |
20 |
Character |
Enter a parent supplier code of the supplier if one exists. If one does not exist, the supplier’s code is the parent supplier code. This field is informational only. |
Parent Supplier field on the Main tab in Supplier Maintenance |
10900 |
supplier-type |
7 |
Character |
Enter a supplier type by which to classify the supplier. You can enter one of the following supplier types:
|
Supplier Type field on the Main tab in Supplier Maintenance |
11000 |
supp-division |
12 |
Character |
Enter a valid division to which the supplier belongs. For information on setting up supplier divisions, see Supplier Division Maintenance. The supplier division is used in reports and EIS inquiries. |
Supplier Division field on the Main tab in Supplier Maintenance |
11100 |
group-id |
8 |
Character |
Enter a valid group to which the supplier belongs. For information on setting up supplier groups, see Supplier Group Maintenance. The supplier group is used in reports and EIS inquiries. |
Supplier Group field on the Main tab in Supplier Maintenance |
11200 |
royal-book-name |
12 |
Character |
Enter a valid royalty book for the supplier. For information on setting up royalty books, see Royalty Book Maintenance. |
Royalty Book field on the Main tab in Supplier Maintenance |
11300 |
address-1 |
60 |
Character |
Enter the first line of the supplier's address. |
Address 1 field on the Main tab in Supplier Maintenance |
11400 |
address-2 |
60 |
Character |
Enter the second line of the supplier's address. |
Address 2 field on the Main tab in Supplier Maintenance |
11450 |
address-3 |
60 |
Character |
Enter the third line of the supplier's address. |
Address 3 field on the Main tab in Supplier Maintenance |
11500 |
city |
40 |
Character |
Enter the city of the supplier's address. |
City field on the Main tab in Supplier Maintenance |
11600 |
state |
3 |
Character |
Enter a valid state or province of the supplier's address. For more information, see state codes. For information on setting up state and province codes, see State and Province Maintenance. |
State or Province field on the Main tab in Supplier Maintenance |
11700 |
zip |
30 |
Character |
Enter the postal code of the supplier's address. The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For more information on postal codes, see Postal Code Maintenance. |
Postal Code field on the Main tab in Supplier Maintenance |
11800 |
country |
10 |
Character |
Enter a valid country of the supplier's address. For more information, see country codes. For information on setting up country codes, see Country Maintenance. |
Country field on the Main tab in Supplier Maintenance |
11900 |
county |
20 |
Character |
Enter the county of the supplier's address. |
County field on the Main tab in Supplier Maintenance |
12000 |
phone |
16 |
Character |
Enter the supplier's phone number. The format of the telephone number is set up in Country Maintenance. |
Phone # field on the Main tab in Supplier Maintenance |
12100 |
fax |
16 |
Character |
Enter the supplier's fax number. |
Fax # field on the Main tab in Supplier Maintenance |
12200 |
email-address |
60 |
Character |
Enter the supplier's email address. This field is informational only. |
Email field on the Main tab in Supplier Maintenance |
12300 |
website |
30 |
Character |
Enter the supplier's website. |
Website field on the Main tab in Supplier Maintenance |
12400 |
default-currency |
8 |
Character |
Enter a valid default currency in which the supplier is normally paid. This currency is used as the default currency in Voucher Entry. |
Currency field on the Main tab in Supplier Maintenance |
12500 |
default-terms |
12 |
Character |
Enter valid default payment terms for the supplier. For information on setting up payment terms, see Payment Terms Maintenance. |
Payment Terms field on the Main tab in Supplier Maintenance |
12600 |
default-payment-method |
17 |
Character |
Enter the default payment method for the supplier. Enter one of the following:
|
Payment Method field on the Main tab in Supplier Maintenance |
12700 |
extended-due-days |
3 |
>>9 |
Enter a number between 0 and 365 for the number of extended due days. You can use this field to track a number of days late that you can pay the supplier without the supplier charging a fee. |
Extended Due Days field on the Main tab in Supplier Maintenance |
12800 |
default-discount |
6 |
>>9.99 |
Enter a standard discount from the supplier. This field is informational only. |
Standard Discount field on the Main tab in Supplier Maintenance |
12900 |
days-to-clear |
4 |
->>9 |
Enter the number of days it normally takes for the supplier to clear checks. This field is informational only. |
Days to Clear Checks field on the Main tab in Supplier Maintenance |
13000 |
supplier-cust-num |
20 |
Character |
Enter the supplier's account number for you. This number is printed on check remittance stubs to make it easy for the supplier's accounts receivable department to apply the payment. |
Supplier's Account Number field on the Main tab in Supplier Maintenance |
13100 |
dft-cash-acct-ptr |
8 |
Character |
Enter the default cash general ledger account used for payment of vouchers to the supplier. |
Default Cash Account field on the Main tab in Supplier Maintenance |
13200 |
invoice-cust |
15 |
Character |
Enter the customer code of the supplier for which to create invoices when using supplier allowances and/or invoice billbacks. For more information on supplier allowances, see Using Supplier Allowances. |
Invoice Customer Code field on the Main tab in Supplier Maintenance |
13300 |
default-billback-type |
12 |
Character |
Enter the billback type for the supplier. Enter one of the following:
|
Billback Type radio set on the Main tab in Supplier Maintenance |
13400 |
billback-detail |
3 |
Yes/No |
Enter Yes if you want to display billback detail on billback invoices for the supplier. Enter No if you do not want to display billback detail on billback invoices for the supplier. You can only set this field if the supplier's billback type is Invoice. |
Display Billback Detail on Invoice check box on the Main tab in Supplier Maintenance |
13500 |
consent-provided |
3 |
Yes/No |
Enter Yes if the data subjects have provided consents to use their personal data. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Supplier Maintenance. |
13600 |
consent-attached |
3 |
Yes/No |
Enter Yes if the data subjects' consents to use their personal data are attached using the standard attachment function in Supplier Maintenance. |
Consent Attached check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Supplier Maintenance. |
13700 |
consent-date |
10 |
99/99/9999 |
Enter the date on which the data subjects, that is, the suppliers, provided the consents to use their personal data. |
Consent Date field on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Main tab in Supplier Maintenance. |
|
|
|
|
|
|
20100 |
ap-mask |
38 |
Character |
Enter all or part of the accounts payable general ledger account to use when resolving the account from the supplier. The account must be unformatted (no hyphens, periods, etc.). Typically, this field is left blank (accounts payable accounts generally are resolved from the default general ledger accounts). For more information on accounts payable accounts, see Purchasing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
A/P Mask field on the Account Masks tab in Supplier Maintenance |
20200 |
pre-payment-mask |
38 |
Character |
Enter all or part of the prepayment general ledger account to use when resolving the account from the supplier. The account must be unformatted (no hyphens, periods, etc.). Typically, this field is left blank (accounts payable accounts generally are resolved from the default general ledger accounts). For more information on prepayment accounts, see Purchasing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Pre-payment Mask field on the Account Masks tab in Supplier Maintenance |
20300 |
ap-clearing-mask |
38 |
Character |
Enter all or part of the accounts payable clearing general ledger account to use when resolving the account from the supplier. The account must be unformatted (no hyphens, periods, etc.). Typically, this field is left blank (accounts payable accounts generally are resolved from the default general ledger accounts). For more information on accounts payable clearing accounts, see Purchasing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
A/P Clearing Mask field on the Account Masks tab in Supplier Maintenance |
20400 |
inbound-mask |
38 |
Character |
Enter all or part of the inbound general ledger account to use when resolving the account from the supplier. The account must be unformatted (no hyphens, periods, etc.). Typically, this field is left blank (accounts payable accounts generally are resolved from the default general ledger accounts). For more information on inbound accounts, see Purchasing Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Inbound Mask field on the Account Masks tab in Supplier Maintenance |
20500 |
royal-exp-mask |
38 |
Character |
Enter the royalty expense account for the supplier. If no royalty expense account is entered for a supplier, royalties for the supplier are posted to the default royalty expense account set up in Purchasing Control Maintenance. |
Royalty Expense Mask field on the Account Masks tab in Supplier Maintenance |
20600 |
royal-accr-mask |
38 |
Character |
Enter the royalty accrual account for the supplier. If no royalty accrual account is entered for a supplier, royalties for the supplier are posted to the default royalty accrual account set up in Purchasing Control Maintenance. |
Royalty Accrual Mask field on the Account Masks tab in Supplier Maintenance |
20700 |
input-vat-clearing-mask |
38 |
Character |
Enter all or part of the input VAT clearing general ledger account to use when resolving the account from the supplier. For more information on input VAT clearing accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Input VAT Clearing field on the Account Masks tab in Supplier Maintenance |
20800 |
input-vat-mask |
38 |
Character |
Enter all or part of the input VAT general ledger account to use when resolving the account from the supplier. For more information on input VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Input VAT field on the Account Masks tab in Supplier Maintenance |
20900 |
input-vat-write-off-mask |
38 |
Character |
Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the supplier. For more information on input VAT write-off accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Input VAT Write-off field on the Account Masks tab in Supplier Maintenance |
21000 |
input-vat-pending-mask |
38 |
Character |
Enter all or part of the input VAT pending general ledger account to use when resolving the account from the supplier. For more information on input VAT pending accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the supplier. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
Input VAT Pending field on the Account Masks tab in Supplier Maintenance |
|
|
|
|
|
|
30100 |
requires-po |
3 |
Yes/No |
Enter Yes or Y if a purchase order number must be entered in Voucher Entry for the supplier's vouchers. Enter No or N if a purchase order is not required for the supplier's vouchers. |
Requires Purchase Order check box on the Purchasing/Receiving tab in Supplier Maintenance |
30200 |
fob-key |
8 |
Character |
Enter a valid default FOB for the supplier. For information on setting up FOB's, see Freight On Board Maintenance. |
Default FOB field on the Purchasing/Receiving tab in Supplier Maintenance |
30300 |
default-shipper-id |
12 |
Character |
Enter a valid default shipper ID for the supplier. This is used as the default shipper ID on purchase orders for the supplier. For information on setting up shipper ID's, see Shipper Maintenance. |
Default Shipper field on the Purchasing/Receiving tab in Supplier Maintenance |
30400 |
default-cont-type-key |
8 |
Character |
Enter a valid default container type for the supplier. For information on setting up container types, see Container Type Maintenance. |
Default Container Type field on the Purchasing/Receiving tab in Supplier Maintenance |
30500 |
review-period |
8 |
Character |
Enter the average number of days between reviews of the supplier to determine reorders. This is used by DRP. |
Review Days field on the Purchasing/Receiving tab in Supplier Maintenance |
30600 |
last-review-date |
10 |
99/99/9999 |
Enter the last date the information for the supplier was reviewed. |
Last Review Date field on the Purchasing/Receiving tab in Supplier Maintenance |
30700 |
cost-date |
8 |
Character |
Enter a value to control the date used to calculate costs for products on the supplier's purchase orders from a cost matrix. Enter one of the following:
Example A purchase order is created with a purchase order date of 06/15/2020. The purchase order has one line item with a required date of 06/21/2020. A purchase cost matrix record exists for 06/18/2020 through 06/30/2020 for the ordered product. If the Purchase Order Date radio button is selected, the purchase cost matrix is not used because the purchase order date is outside the range of dates for the purchase cost matrix record. If the Required Date radio button is selected, the purchase cost matrix is used to calculate the price of the product on the purchase order. |
Cost Based On radio set on the Purchasing/Receiving tab in Supplier Maintenance |
30800 |
overage-percent |
6 |
>>9.99 |
Enter an overage percentage for the supplier. In Receiving Entry, if the receiving amount is greater than the purchase order amount by this percentage, then the software automatically takes action. Example If 10 is entered in this field, and the original purchase order quantity is 100, the system takes the appropriate action if the quantity of the product received is greater than 110. The action taken is based on the overage option for the supplier. For more information, see Purchase Additional Charges and Landed Cost FAQ. |
Overage Percent field on the Purchasing/Receiving tab in Supplier Maintenance |
30900 |
overage-option |
9 |
Character |
Enter an overage option to specify an action to perform if the warehouse receives more product for the supplier than the quantity ordered (by the percentage entered for the Overage Percent field). Enter one of the following values:
|
Absorb, Warn, and Send Back radio buttons on the Purchasing/Receiving tab in Supplier Maintenance |
31000 |
print-receiving-label |
3 |
Yes/No |
Enter Yes or Y to print receiving labels for the supplier when performing receiving from the supplier. Enter No or N to not print receiving labels for the supplier when performing receiving from the supplier. |
Print Receiving Labels check box on the Purchasing/Receiving tab in Supplier Maintenance |
31100 |
freight-supplier |
3 |
Yes/No |
Enter Yes or Y to indicate that the supplier is a freight supplier. This is informational only, and is used for custom reports and inquiries. Enter No or N to indicate that the supplier is not a freight supplier. |
Freight Supplier check box on the Purchasing/Receiving tab in Supplier Maintenance |
31200 |
freight-id |
12 |
Character |
Enter the supplier's freight ID used for reports and inquiries. This field is informational only. |
Freight ID field on the Purchasing/Receiving tab in Supplier Maintenance |
|
|
|
|
|
|
40100 |
requires-1099 |
3 |
Yes/No |
Enter Yes or Y if the supplier requires a 1099 to be filed. If you enter Yes or Y, you must enter the 1099 legal name, legal ID, and form type for the supplier. Enter No or N if the supplier does not require a 1099 to be filed. |
Requires 1099 check box on the 1099 Information tab in Supplier Maintenance |
40200 |
legal-name-1099 |
40 |
Character |
Enter the legal name of the supplier for tax forms. |
1099 Legal Name field on the 1099 Information tab in Supplier Maintenance |
40300 |
legal-id-1099 |
20 |
Character |
Enter the legal ID of the supplier for tax forms. |
1099 Legal ID field on the 1099 Information tab in Supplier Maintenance |
40400 |
type-1099 |
12 |
Character |
Enter a valid 1099 form type for the supplier. For information on setting up 1099 form types, see Form 1099 Reporting Box Maintenance. |
1099 Type field on the 1099 Information tab in Supplier Maintenance |
40500 |
default-box-id-1099 |
3 |
Character |
Enter a valid default 1099 reporting box to use for the supplier's vouchers. For information on setting up reporting boxes, see Form 1099 Reporting Box Maintenance. |
Reporting Box field on the 1099 Information tab in Supplier Maintenance |
40600 |
tax-id |
20 |
Character |
Enter the tax ID of the supplier. This field is informational only. |
Tax ID field on the 1099 Information tab in Supplier Maintenance |
|
|
|
|
|
|
50100 |
prod-code-mask |
40 |
Character |
If segmenting the product code, enter the portion of the segment that relates to the supplier. Example Your system is set up with product codes with four elements. The second element is used to indicate the supplier. You would enter the second element for each specific supplier in this field (leaving the other elements blank in this field). |
Product Code Mask field on the Other Options tab in Supplier Maintenance |
50200 |
edi-partner-key |
8 |
Character |
Enter a valid EDI trading partner ID for the supplier. For information on setting up EDI trading partners, see EDI Trading Partner Maintenance. |
EDI Trade ID field on the Other Options tab in Supplier Maintenance |
50300 |
country-of-origin |
10 |
Character |
Enter a valid country code of the C-TPAT country of origin for the supplier's products. |
C-TPAT Country of Origin field on the Other Options tab in Supplier Maintenance |
50400 |
vat-id |
30 |
Character |
Enter the supplier's tax identification number for VAT. Example For an Australian supplier, enter the supplier's Australian Business Number (ABN). |
Supplier VAT ID field on the Other Options tab in Supplier Maintenance |
50500 |
default-to-single |
3 |
Yes/No |
Enter Yes or Y if vouchers for the supplier use a single general ledger account by default. If you enter Yes or Y, the Single radio button is selected in Voucher Entry when a voucher is entered for the supplier. This overrides the default setting set up in Accounts Payable Control Maintenance. Enter No or N if vouchers for the supplier do not use a single general ledger account by default. |
Default Single G/L Account in Voucher Entry check box on the Other Options tab in Supplier Maintenance |
50600 |
prevent-qty-change |
3 |
Yes/No |
Enter Yes or Y to prevent quantity updates on purchase orders for the supplier. If you enter Yes or Y, enter a number of days before delivery that order quantity changes can be made for the prevent-qty-change-days field. Note If the Always Allow Quantity Change check box is selected for a user in User Extended Options, the user can always make quantity changes. Enter No or N to allow quantity updates on purchase orders for the supplier. |
Prevent Quantity Updates Within check box on the Other Options tab in Supplier Maintenance |
50700 |
prevent-qty-change-days |
4 |
>>>9 |
Enter the number of days before delivery that order quantity changes can be made on a purchase order for the supplier. For containers, the earliest scheduled delivery date for a purchase order line is compared to this value. For purchase orders that are not on containers, the ship date of the purchase order line is compared to this value. This field is only used if quantity updates are prevented for the supplier. |
Days field on the Other Options tab in Supplier Maintenance |
50800 |
send-remitt-advice |
3 |
Yes/No |
Enter Yes or Y to output remittance advices for payments to the supplier entered in Direct Deposit Payment Entry or Payment Entry. If you enter Yes or Y, remittance advices are only output to the supplier's contacts who are set up to receive remittance advices. Enter No or N to not output remittance advices for payments to the supplier entered in Direct Deposit Payment Entry or Payment Entry. |
Auto Print Remittance Advice check box on the Other Options tab in Supplier Maintenance |
50900 |
profit-group-code |
12 |
Character |
Enter a valid scorecard profit group code for the supplier. For information on setting up scorecard profit group codes, see Scorecard Profit Group Maintenance. |
Profit Group Code field on the Other Options tab in Supplier Maintenance |
51000 |
customer-option |
7 |
Character |
Enter one of the following:
|
Profitability Customer Option field on the Other Options tab in Supplier Maintenance |
51100 |
product-option |
7 |
Character |
Enter one of the following:
|
Profitability Product Option field on the Other Options tab in Supplier Maintenance |
51200 |
supplier-option |
7 |
Character |
Enter one of the following:
|
Profitability Supplier Option field on the Other Options tab in Supplier Maintenance |
51300 |
cf-supp-group-code |
8 |
Character |
Enter a valid cash flow supplier group for the supplier. The cash flow supplier group controls the rules for how and when cash is sent to the supplier. If this field is blank, the supplier is assigned to the default cash flow supplier group. For information on setting up cash flow supplier groups, see Cash Flow Supplier Group Maintenance. |
Group Code field on the Other Options tab in Supplier Maintenance |
51400 |
beer-license |
3 |
Yes/No |
Enter Yes or Y if the supplier is licensed to sell beer. Enter No or N if the supplier is not licensed to sell beer. |
Beer check box on the Other Options tab in Supplier Maintenance |
51500 |
wine-license |
3 |
Yes/No |
Enter Yes or Y if the supplier is licensed to sell wine. Enter No or N if the supplier is not licensed to sell wine. |
Wine check box on the Other Options tab in Supplier Maintenance |
51600 |
spirit-license |
3 |
Yes/No |
Enter Yes or Y if the supplier is licensed to sell spirits. Enter No or N if the supplier is not licensed to sell spirits. |
Spirits check box on the Other Options tab in Supplier Maintenance |
51700 |
distributor-id |
8 |
Character |
Enter a unique distributor ID number for use with the Vermont Information Processing (VIP) extract output in Generate Data Extract. |
Distributor ID field on the Other Options tab in Supplier Maintenance |
51800 |
supp-portal-site-id |
12 |
Character |
Enter a valid supplier portal site ID for the supplier. |
Selected Sites grid on the Other Options tab in Supplier Maintenance |
51900 |
lead-time |
3 |
>>9 |
Enter the lead time for the supplier. Note This is the actual number of days, not the number of business calendar days. This is used by DRP to calculate purchase order and blanket release delivery dates. You can override this value for specific locations in the Selected Locations grid. For more information, see DRP - Lead Time Calculation FAQ. |
Default Lead Time field on the Supplier Location tab in Supplier Maintenance |
52000 |
in-transit-lead-time |
3 |
>>9 |
Enter the default in-transit lead time for the supplier, which is the number of days between when the product is shipped and received. This is used by DRP to calculate purchase order and blanket release ship dates. You can override this value for specific locations for the supplier. For more information, see DRP - Lead Time Calculation FAQ. Example If the in-transit lead time is 10 days, and the purchase order delivery date is 06/15/2020, the purchase order ship date is calculated as 06/05/2020. |
Default In Transit Lead Time field on the Supplier Location tab in Supplier Maintenance |
52100 |
dflt-ship-debit-type |
1 |
Character |
Enter a value from 1-3 to indicate the default ship and debit type for the supplier. Enter one of the following:
|
Default Ship and Debit Type radio set on the Main tab in Supplier Maintenance |
52200 |
bvg-supp-id |
3 |
Character |
Enter a unique supplier ID number assigned by a third-party for use with data extracts output in Generate Data Extract. |
Supplier ID field on the Other Options tab in Supplier Maintenance |
|
|
|
|
|
|
Ship-From Address Fields |
|
|
|
|
|
60100 |
ship-from-name |
40 |
Character |
Enter a name for the supplier's ship-from address. |
Name field on the Ship From tab in Supplier Maintenance |
60200 |
ship-from-address1 |
60 |
Character |
Enter the first line of the supplier's ship-from address. |
Address 1 field on the Ship From tab in Supplier Maintenance |
60300 |
ship-from-address2 |
60 |
Character |
Enter the second line of the supplier's ship-from address. |
Address 2 field on the Ship From tab in Supplier Maintenance |
60400 |
ship-from-address3 |
60 |
Character |
Enter the third line of the supplier's ship-from address. |
Address 3 field on the Ship From tab in Supplier Maintenance |
60500 |
ship-from-city |
40 |
Character |
Enter the city of the supplier's ship-from address. |
City field on the Ship From tab in Supplier Maintenance |
60600 |
ship-from-state |
3 |
Character |
Enter a valid state or province of the supplier's ship-from address. |
State or Province field on the Ship From tab in Supplier Maintenance |
60700 |
ship-from-zip |
12 |
Character |
Enter a valid postal code of the supplier's ship-from address. |
Postal Code field on the Ship From tab in Supplier Maintenance |
60800 |
ship-from-country |
25 |
Character |
Enter a valid country of the supplier's ship-from address. |
Country field on the Ship From tab in Supplier Maintenance |
60900 |
ship-from-county |
20 |
Character |
Enter the county of the supplier's ship-from address. |
County field on the Ship From tab in Supplier Maintenance |
61000 |
primary-address |
3 |
Yes/No |
Enter Yes or Y if the ship-from address is the primary ship-from address for the supplier. You can only mark one ship-from address as the primary address for each supplier. The primary address is used as the default ship-from address when purchase orders are created in Purchase Order Maintenance. Enter No or N if the ship-from address is not the primary ship-from address for the supplier. |
Primary Address check box on the Ship From tab in Supplier Maintenance |
61100 |
ship-from-phone |
30 |
Character |
Enter a phone number for the supplier's ship-from address. |
Phone # field on the Ship From tab in Supplier Maintenance |
61200 |
ship-from-fax |
30 |
Character |
Enter a fax number for the supplier's ship-from address. |
Fax # field on the Ship From tab in Supplier Maintenance |
61300 |
ship-from-email |
60 |
Character |
Enter an email address for the supplier's ship-from address. |
Email field on the Ship From tab in Supplier Maintenance |
61400 |
vat-id |
30 |
Character |
Enter a VAT identification number for the supplier's ship-from address. |
Supplier VAT ID field on the Ship From tab in Supplier Maintenance |
61500 |
vat-supplier-code |
40 |
Character |
Enter the supplier code of the default VAT supplier to which you will pay VAT for purchase orders for the ship-from address. |
Default VAT Supplier field on the Ship From tab in Supplier Maintenance |
61600 |
ship-from-excise-id |
30 |
Character |
Enter the excise tax ID for the supplier's ship-from address if the address is a tax warehouse. |
Excise ID field on the Ship From tab in Supplier Maintenance |
61700 |
ship-from-consent-provided |
3 |
Yes/No |
Enter Yes if the data subjects have provided consents to use their personal data. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-From tab in Supplier Maintenance. |
61800 |
ship-from-consent-attached |
3 |
Yes/No |
Enter Yes if the data subjects' consents to use their personal data are attached using the standard attachment function in Supplier Maintenance. |
Consent Attached check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-From tab in Supplier Maintenance. |
61900 |
ship-from-consent-date |
10 |
99/99/9999 |
Enter the date on which the data subjects, that is, the suppliers, provided the consents to use their personal data. |
Consent Date field on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Ship-From tab in Supplier Maintenance. |
|
|
|
|
|
|
Remit-To Address Fields |
|
|
|
|
|
70100 |
remit-to-name |
40 |
Character |
Enter a name for the supplier's remit-to address. |
Name field on the Remit-To tab in Supplier Maintenance |
70200 |
remit-to-address1 |
60 |
Character |
Enter the first line of the supplier's remit-to address. |
Address 1 field on the Remit-To tab in Supplier Maintenance |
70300 |
remit-to-address2 |
60 |
Character |
Enter the second line of the supplier's remit-to address. |
Address 2 field on the Remit-To tab in Supplier Maintenance |
70400 |
remit-to-address3 |
60 |
Character |
Enter the third line of the supplier's remit-to address. |
Address 3 field on the Remit-To tab in Supplier Maintenance |
70500 |
remit-to-city |
40 |
Character |
Enter the city of the supplier's remit-to address. |
City field on the Remit-To tab in Supplier Maintenance |
70600 |
remit-to-phone |
30 |
Character |
Enter a phone number for the supplier's remit-to address. |
Phone # field on the Remit-To tab in Supplier Maintenance |
70700 |
remit-to-state |
3 |
Character |
Enter the state or province of the supplier's remit-to address. |
State or Province field on the Remit-To tab in Supplier Maintenance |
70800 |
remit-to-zip |
12 |
Character |
Enter the postal code of the supplier's remit-to address. |
Postal Code field on the Remit-To tab in Supplier Maintenance |
70900 |
remit-to-country |
10 |
Character |
Enter the country of the supplier's remit-to address. |
Country field on the Remit-To tab in Supplier Maintenance |
71000 |
remit-to-county |
20 |
Character |
Enter the county of the supplier's remit-to address. |
County field on the Remit-To tab in Supplier Maintenance |
71100 |
email-address |
60 |
Character |
Enter the email address for the supplier's remit-to address. |
Email Address field on the Remit-To tab in Supplier Maintenance |
71200 |
primary-address |
3 |
Yes/No |
Enter Yes or Y if the remit-to address is the primary remit-to address for the supplier. Enter No or N if the remit-to address is not the primary remit-to address for the supplier. |
Primary Address check box on the Remit-To tab in Supplier Maintenance |
71300 |
remit-to-consent-provided |
3 |
Yes/No |
Enter Yes if the data subjects have provided consent to use their personal data. |
Consent Provided check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Remit-To tab in Supplier Maintenance. |
71400 |
remit-to-consent-attached |
3 |
Yes/No |
Enter Yes if the data subjects' consent to use their personal data is attached using the standard attachment function in Supplier Maintenance. |
Consent Attached check box on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Remit-To tab in Supplier Maintenance. |
71500 |
remit-to-consent-date |
10 |
99/99/9999 |
Enter the date on which the data subjects, that is, the suppliers, provided the consent to use their personal data. |
Consent Date field on the GDPR Maintenance window, which opens when the GDPR button is clicked on the Remit-To tab in Supplier Maintenance. |
|
|
|
|
|
|
75100 |
bank-account-number |
20 |
Character |
Enter the supplier's bank account number. |
Bank Account Number field in Supplier Bank Account Maintenance |
75200 |
bank-code |
12 |
Character |
Enter a valid bank code for the supplier's bank account. For information on setting up bank codes, see Bank Code Maintenance. |
Bank Code field in Supplier Bank Account Maintenance |
75300 |
bank-iban |
40 |
Character |
Enter the International Bank Account Number (IBAN) for the supplier's bank account. |
IBAN field in Supplier Bank Account Maintenance |
75400 |
bank-aba-number |
20 |
Character |
Enter the supplier's ABA routing number. |
ABA Routing Number field in Supplier Bank Account Maintenance |
75500 |
bank-account-name |
40 |
Character |
Enter the bank account name for the supplier. |
Bank Account Name field in Supplier Bank Account Maintenance |
|
|
|
|
|
|
80100 |
usr-def-fld-1 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
first user-defined field on the Other Information tab in Supplier Maintenance |
80200 |
usr-def-fld-2 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
second user-defined field on the Other Information tab in Supplier Maintenance |
80300 |
usr-def-fld-3 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
third user-defined field on the Other Information tab in Supplier Maintenance |
80400 |
usr-def-fld-4 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
fourth user-defined field on the Other Information tab in Supplier Maintenance |
80500 |
usr-def-fld-5 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
fifth user-defined field on the Other Information tab in Supplier Maintenance |
80600 |
usr-def-fld-6 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
sixth user-defined field on the Other Information tab in Supplier Maintenance |
80700 |
usr-def-fld-7 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
seventh user-defined field on the Other Information tab in Supplier Maintenance |
80800 |
usr-def-fld-8 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
eighth user-defined field on the Other Information tab in Supplier Maintenance |
80900 |
usr-def-fld-9 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
ninth user-defined field on the Other Information tab in Supplier Maintenance |
81000 |
usr-def-fld-10 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
tenth user-defined field on the Other Information tab in Supplier Maintenance |
81100 |
usr-def-fld-11 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
eleventh user-defined field on the Other Information tab in Supplier Maintenance |
81200 |
usr-def-fld-12 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
twelfth user-defined field on the Other Information tab in Supplier Maintenance |
81300 |
usr-def-fld-13 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
thirteenth user-defined field on the Other Information tab in Supplier Maintenance |
81400 |
usr-def-fld-14 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
fourteenth user-defined field on the Other Information tab in Supplier Maintenance |
81500 |
usr-def-fld-15 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
fifteenth user-defined field on the Other Information tab in Supplier Maintenance |
81600 |
usr-def-fld-16 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
sixteenth user-defined field on the Other Information tab in Supplier Maintenance |
81700 |
usr-def-fld-17 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
seventeenth user-defined field on the Other Information tab in Supplier Maintenance |
81800 |
usr-def-fld-18 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
eighteenth user-defined field on the Other Information tab in Supplier Maintenance |
81900 |
usr-def-fld-19 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
nineteenth user-defined field on the Other Information tab in Supplier Maintenance |
82000 |
usr-def-fld-20 |
400 |
Character, Date, Decimal, Integer, or Logical |
Enter data for this user-defined field if necessary. For information on user-defined fields, see User Defined Fields Maintenance. |
twentieth user-defined field on the Other Information tab in Supplier Maintenance |
Before using this import, the following must be set up:
suppliers