Supplier Change Import Format

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

Images\warning.gif 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.

  • Active - Allow invoices to be entered and paid.

  • On-Hold - Allow invoices to be entered, but they are put on hold and need to be released for payment. Additionally, the supplier cannot have invoices selected for payment.

  • On-Watch - This status is only used in custom reports and inquiries.

  • Other - This status is only used in custom reports and inquiries.

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:

  • Charge

  • Expense

  • None

  • Product

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:

  • ACH

  • Automatic Draft

  • Banker Acceptance

  • Cash

  • Check

  • Credit Card

  • Direct Debit

  • Direct Deposit

  • Exchange

  • Manual

  • Other

  • Pre-paid

  • Transfer

  • Wire

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:

  • Invoice

  • Voucher

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:

  • PO Date - Calculate costs for products on the supplier's purchase orders from a cost matrix based on the purchase order date.

  • Req Date - Calculate costs for products on the supplier's purchase orders from a cost matrix based on the line item required date.

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 - Keep excess product.

  • Send Back - Return excess product to the supplier.

  • Warn - Display a warning message.

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:

  • Require - Require customer cost allocation information to be entered in Voucher Entry or Voucher Edit when entering vouchers for the supplier.

  • Warn - Display a message after entering a voucher for a supplier in Voucher Entry or Voucher Edit without entering customer cost allocation information.

  • None - Permit vouchers to be entered for the supplier without entering customer cost allocation information in Voucher Entry or Voucher Edit.

Profitability Customer Option field on the Other Options tab in Supplier Maintenance

51100

product-option

7

Character

Enter one of the following:

  • Require - Require product cost allocation information to be entered in Voucher Entry or Voucher Edit when entering vouchers for the supplier.

  • Warn - Display a message after entering a voucher for a supplier in Voucher Entry or Voucher Edit without entering product cost allocation information.

  • None - Permit vouchers to be entered for the supplier without entering product cost allocation information in Voucher Entry or Voucher Edit.

Profitability Product Option field on the Other Options tab in Supplier Maintenance

51200

supplier-option

7

Character

Enter one of the following:

  • Require - Require supplier cost allocation information to be entered in Voucher Entry or Voucher Edit when entering vouchers for the supplier.

  • Warn - Display a message after entering a voucher for a supplier in Voucher Entry or Voucher Edit without entering supplier cost allocation information.

  • None - Permit vouchers to be entered for the supplier without entering supplier cost allocation information in Voucher Entry or Voucher Edit.

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:

  • 1 - Calculate the rebate based on quantity breaks

  • 2 - Calculate the rebate based on a specific price

  • 3 - Calculate the cost based on quantity breaks

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

Prerequisites

Before using this import, the following must be set up: