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:
|
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. |
Before using this import, the following must be set up:
billing customer codes
The following fields require table validations:
Billing Customer Code
Customer Code
Customer’s Reason Code
Chargeback Reason Code
Chargeback Status Code
Accounts Receivable Account Number
Related Reference Number
There must be a record of blank space(s) at the end of an import file.