Imports - Customers Import Information

Field

Value

Type/Size

Required for create new

Required for Update

Update Allowed

Facility

Required

int(5)

  •  
  •  
  •  

Customer Number

Required

char(10)

  •  
  •  
  •  

Abbreviation

Required (must be unique)

char(10)

  •  
  •  
  •  

Name

char(25)

  •  
  •  
  •  

Ship address 1

char(25)

  •  
  •  
  •  

Ship Address City

char(25)

  •  
  •  
  •  

Ship Zip Code

char(10)

  •  
  •  
  •  

Ship Phone

char(14)

  •  
  •  
  •  

Ship Contact

char(20)

  •  
  •  
  •  

Ship State

char(2)

  •  
  •  
  •  

Billing Address 1

char(25)

  •  
  •  
  •  

Billing Address City

char(25)

  •  
  •  
  •  

Billing Zip Code

char(10)

  •  
  •  
  •  

Billing Phone

char(14)

  •  
  •  
  •  

Billing Name

char(20)

  •  
  •  
  •  

Billing State

char(2)

  •  
  •  
  •  

Tax Rate

This should be the decimal version of the tax rate.
(i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Shop Rate

This should be the decimal version of the shop supply rate. (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Parts Markup

This should be the decimal version of the parts markup

(i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Labor Tax

This should be the decimal version of the labor tax rate. (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Labor Markup

This should be the decimal version of the labor markup. (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

GST Tax

This should be the decimal version of the GST tax rate.  (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Tire Markup

This should be the decimal version of the tire markup.    (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Outside Labor Markup

This should be the decimal version of the outside labor markup.(i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Outside Parts Markup

This should be the decimal version of the outside parts markup. (.07 for 7%)

decimal(1,4)

  •  
  •  
  •  

ACF Rate

This should be the decimal version of the ACF rate.        (i.e. .07 for 7%)

decimal(1,4)

  •  
  •  
  •  

Parts Account Code

char(25)

  •  
  •  
  •  

Supply Account Code

char(25)

  •  
  •  
  •  

Outside Account Code

char(25)

  •  
  •  
  •  

Labor Account Code

char(25)

  •  
  •  
  •  

Tax Account Code

char(25)

  •  
  •  
  •  

Tire Account Code

char(25)

  •  
  •  
  •  

Markup Percent Charged To

  • A = Average Price

  • S = Selling Price (Default)

char(1)

  •  
  •  
  •  

Finance Charge

  • Y = True

  • N = False (Default)

char(1)

  •  
  •  
  •  

GST Flag

  • B = Compounding (Default)

  • A = Linear

char(1)

  •  
  •  
  •  

Tax Outside Part

  • Y = True

  • N = False (Default)

char(1)

  •  
  •  
  •  

Type Code

char(2)

  •  
  •  
  •  

Misc Field

char(40)

  •  
  •  
  •  

Shop Supply Taxable

  • Y = True (Default)

  • N = False

char(1)

  •  
  •  
  •  

Terms

char(12)

  •  
  •  
  •  

Email Address

char(60)

  •  
  •  
  •  

Max Part Markup

int(4)

  •  
  •  
  •  

Max Outside Labor/Part Markup

int(4)

  •  
  •  
  •  

Hourly Labor Rate

decimal(4,2)

  •  
  •  
  •  

Use Labor Hourly Rate

  • Y = True

  • N = False (Default)

char(1)

  •  
  •  
  •  

Search