Chargeback Redistribution Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Chargeback Redistribution Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Billing Customer Code

12

Character

Yes

Enter a valid billing customer code.

B

2

Customer Code

12

Character

No

Enter the order/invoice customer code, if known. This field is validated. If this field is blank, the customer code defaults to the billing customer code.

C

3

Customer’s Reference Number

20

Character

Yes

Enter the reference number supplied by the customer to identify this chargeback.

D

4

Customer’s Reference Date

10

99/99/9999

Yes

Enter the date assigned by the customer to this chargeback.

E

5

Customer’s Reason Code

12

Character

No

Enter the customer’s own reason code for the chargeback. This field is validated.

F

6

Customer’s Expiration Date

10

99/99/9999

No

Enter the date assigned by the customer for this chargeback to expire (no longer disputable).

G

7

Customer’s Purchase Order Number Reference

20

Character

No

Enter the customer’s purchase order reference number.

H

8

Customer’s Return Authorization Number Reference

12

Character

No

Enter the customer’s return authorization number.

I

9

Chargeback Amount

19

->>>,>>>,>>>,>>9.99

Yes

Enter the amount of the chargeback.

J

10

Chargeback Reference Date

10

99/99/9999

Yes

Enter a date used for aging (reference date option).

K

11

Chargeback Reason Code

12

Character

No

Enter the reason for the chargeback. This field is validated.

The order of resolution is:

  1. Use the chargeback reason code of the customer’s reason code (if supplied).

  2. Use this chargeback reason code.

  3. If a chargeback reason code cannot be determined from 1. or 2., then use the customer/group/division default chargeback reason code.

L

12

Chargeback Due Date

10

99/99/9999

Yes

Enter a date used for aging (due date option).

M

13

Chargeback Status Code

12

Character

No

Enter the status of the chargeback. This field is validated. This field value is used only if the customer’s reason code does not specify a chargeback status code. If both are blank, then the customer/group/division default chargeback status code is used.

N

14

Accounts Receivable Account Number

30

Character

No

Enter the accounts receivable account number. This field is validated. If this field is blank, the system checks the customer, and then the system default.

O

15

Related Reference Number

12

Character

No

If this chargeback is related to a specific invoice, then enter the invoice reference number. This field is validated.

P

16

Store ID

12

Character

No

Enter a store ID for mass merchants that provide a store ID with every chargeback (to help with its tracking and resolution).

Q

17

Chargeback User Defined 1

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

R

18

Chargeback User Defined 2

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

S

19

Chargeback User Defined 3

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

T

20

Chargeback User Defined 4

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

U

21

Chargeback User Defined 5

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

V

22

Chargeback User Defined 6

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

W

23

Chargeback User Defined 7

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

X

24

Chargeback User Defined 8

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

Y

25

Chargeback User Defined 9

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

Z

26

Chargeback User Defined 10

400

Character, Date, Decimal, Integer, or Logical

No

Enter appropriate information for the chargeback for this user-defined field. For information on setting up the labels, formats, and validation for this field, see User Defined Fields Maintenance.

Prerequisites

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

Import Format Notes