Purchase Automatic Additional Charge Import Format

A

1

Record Type

3

Character

Yes

Enter HDR to specify the record is a header record.

B

2

Area

5

Character

Yes

Enter Order to specify the record is a header charge record.

Enter Item to specify the record is a line item charge record.

C

3

Harmonization Code

20

Character

No

Enter a valid harmonization code for which to set up purchase automatic additional charges. Leave this field blank to create a record for all harmonization codes. For information on setting up harmonization codes, see Harmonization Code Maintenance.

D

4

From Country Code

10

Character

Yes, only if a harmonization code is entered for the Harmonization Code field (position 3)

Enter a valid country code from which products are shipping for which to set up purchase automatic additional charges. Leave this field blank to create a record for all from countries. For information on setting up countries, see Country Maintenance.

E

5

To Country Code

10

Character

Yes, only if a harmonization code is entered for the Harmonization Code field (position 3)

Enter a valid country code to which products are shipping for which to set up purchase automatic additional charges. Leave this field blank to create a record for all to countries. For information on setting up countries, see Country Maintenance.

NOTE This field is ignored if a value is entered for the Purchase Order Ship-To Location Prefix field (position 6)

F

6

Purchase Order Ship-To Location Prefix

3

Character

No

Enter a valid location prefix of a ship-to location for which to set up purchase automatic additional charges. Leave this field blank to create a record for all ship-to locations. For information on setting up location prefixes, see Location Maintenance.

G

7

Supplier Code

15

Character

No

Enter a valid supplier code for which to set up purchase automatic additional charges. Leave this field blank to create a record for all suppliers. For information on setting up suppliers, see Supplier Maintenance.

H

8

Purchase Class

10

Character

No

Enter a valid purchase class for which to set up purchase automatic additional charges. Purchase classes define the class of a purchase order such as purchases, returns, transfers, etc. Leave this field blank to create a record for all purchase classes. For information on setting up purchase classes, see Purchase Class Maintenance.

I

9

Start Purchase Date

10

99/99/9999

Yes, only if a date is entered for the End Purchase Date field (position 10)

Enter the first date in a range of dates for which to set up purchase automatic additional charges. Leave this field and the End Purchase Date field (position 10) blank to create a record for all purchase dates.

J

10

End Purchase Date

10

99/99/9999

Yes, only if a date is entered for the Start Purchase Date field (position 9)

Enter the last date in a range of dates for which to set up purchase automatic additional charges. Leave this field and the Start Purchase Date field (position 9) blank to create a record for all purchase dates.

K

11

Ignore Year

3

Yes/No

No

Enter Yes to ignore the year for the date range entered for the Start Date and End Date fields (positions 9 and 10). If this field is blank, it defaults to No.

L

12

Product Code

40

Character

No

Enter a valid product code for which to set up purchase automatic additional charges. Leave this field blank to create a record for all products. For information on setting up products, see Product Maintenance.

NOTE If you enter a value for this field, do not enter a value for the Product Style Code field (position 13) or Product Category Code field (position 14).

M

13

Product Style Code

12

Character

No

Enter a valid product style code for which to set up purchase automatic additional charges. Leave this field blank to create a record for all product styles. For information on setting up product styles, see Style Maintenance.

NOTE If you enter a value for this field, do not enter a value for the Product Code field (position 12) or Product Category Code field (position 14).

N

14

Product Category Code

12

Character

Yes, only if a product subcategory is entered for the Product Subcategory Code field (position 15)

Enter a valid product category for which to set up purchase automatic additional charges. Leave this field blank to create a record for all product categories. For information on setting up product categories, see Product Category Maintenance.

NOTE If you enter a value for this field, do not enter a value for the Product Code field (position 12) or Product Style Code field (position 13).

O

15

Product Subcategory Code

12

Character

No

Enter a product subcategory for which to set up purchase automatic additional charges. Leave this field blank to create a record for all product subcategories. For information on setting up product subcategories, see Product Subcategory Maintenance.

NOTE This field is ignored if a value is entered for the Product Code field (position 12) or Product Style Code field (position 13).

A

1

Record Type

3

Character

Yes

Enter TRL to specify the record is a trailer record. Trailer records must appear immediately after the related header record in the import file.

B

2

Additional Charge

10

Character

Yes

Enter a valid purchase additional charge to set up as an automatic additional charge for the associated header record. For information on setting up purchase additional charges, see Purchase Additional Charge Maintenance.

Note If you enter a harmonization code in the Harmonization Code field for the header record, you must enter a purchase additional charge for this field that is set up as used in harmonization charges.

C

3

Charge Currency

8

Character

No

Enter a valid currency for the purchase automatic additional charge. If this field is blank, it defaults to the general ledger currency.

D

4

Charge Sign

1

Character

No

Enter - for a negative charge or + for a positive charge. If this field is blank, it defaults to +.

E

5

Additional Charge Amount/Percent

16

>>>,>>>,>>9.9999

Yes

Enter the amount or percentage of the additional charge. The additional charge entered for the Additional Charge field (position 2) determines whether this is an amount or percentage.