Payment Terms Import Format

A

1

Terms Type

2

>9

Yes

Enter a one- or two-digit code to indicate the terms type, as follows:

• 0 - Prepaid - The product was paid for before it was received.

• 1 - C.O.D. - Payment is due when the product is received.

Note You must set up a C.O.D. type payment terms code to use One Step Voucher and Payment Entry.

• 2 - Due in # of Days - Payment is due in a specific number of days.

• 3 - Due on Day of Month - Payment is due on a specific day of the month.

• 8 - C.O.D. Personal Checks NOT Accepted - Payment is received from a C.O.D. customer, but personal checks are not accepted as a form of payment. Certified checks and money orders are acceptable forms of payment. This payment terms type is only used with the UPS third-party interface.

• 9 - C.O.D. Personal Checks Accepted - Payment is received from a C.O.D. customer, and personal checks are accepted as a form of payment. This payment terms type is only used with the UPS third-party interface.

• 10 - Credit Card (Interface) - Credit card terms must be defined if you want to process orders for customers that pay by credit card. Customer credit card information is set up in Credit Card Number Entry.

Note You must set up a payment terms code for each credit card type that your customers use.

NOTE You cannot import prox terms, split terms, or calendar terms types.

B

2

Terms Code

12

Character

Yes

Enter a code for the payment terms.

C

3

Description

60

Character

No

Enter a description for the payment terms code.

D

4

Credit Hold Term

3

Yes/No

No

Enter Yes to automatically put all sales orders that use the payment terms code on credit hold. If this field is blank, it defaults to No. This field is not used for credit card terms or finance terms (Yes is entered for the Finance field).

Note You cannot enter Yes for this field and the Ignore Credit Check field (position 5).

E

5

Ignore Credit Check

3

Yes/No

No

Enter Yes to bypass the credit check during sales order entry for orders that use the payment terms code. If this field is blank, it defaults to No. This field is not used for credit card terms or finance terms (Yes is entered for the Finance field).

Note You cannot enter Yes for this field and the Credit Hold Term field (position 4).

F

6

Exclude Shipping Charge

3

Yes/No

No

Enter Yes to exclude shipping charges when calculating the eligible cash discount during payment application. If this field is blank, it defaults to No. This field is not used for prepaid, credit card, or finance terms (Yes is entered for the Finance field).

Note A charge is excluded only if the Freight Charge check box is selected for it in Order Entry Additional Charge Maintenance.

G

7

Exclude Tax

3

Yes/No

No

Enter Yes to exclude sales tax or VAT when calculating the eligible cash discount during payment application. If this field is blank, it defaults to No. This field is not used for prepaid or credit card terms.

H

8

Guaranteed Funds

3

Yes/No

No

Enter Yes if your system is integrated with the FedEx Ship Manager Server (FSMS), and the payment term is for a guaranteed funds payment, such as a cashier check, certified check, or money order. If this field is blank, it defaults to No. This field is only used for C.O.D. terms.

I

9

Discount Mask

38

Character

No

Enter the cash discounts general ledger discount mask for the payment terms code. You can enter all or part of the general ledger discount account number. The customer and sales locations are the other two areas where the cash discounts general ledger discount mask can be defined. For more information, see Account Resolution Order. This field is not used for prepaid and credit card terms.

J

10

Discount Percentage

7

>9.9999

No

Enter the discount percentage if the payment is made before the discount due date. This field is not used for prepaid and credit card terms.

K

11

Discount Days

3

>>9

No

Enter the number of days from the invoice date during which a discount is allowed. This field is not used for prepaid and credit card terms.

Example Invoice 123 has an invoice date of 6/30/2020 and the discount days for the payment terms code is 10. A cash discount is allowed if the invoice is paid on or before 7/10/2020.

L

12

Net Days

3

>>9

No

Enter the number of days from the invoice date to determine the due date. This field is not used for prepaid, due on day of month, and credit card terms.

Example Invoice 123 has an invoice date of 6/30/2020 and the net days of the payment terms code is 30. The invoice due date is 7/30/2020.

M

13

Day of Month

2

>9

Yes, only if 3 is entered for the Terms Type field

Enter the day of the month by which the payment should be made. This field is only used for due on day of month terms.

Example If the day of the month is 10 for a payment terms code, and an invoice is created with an invoice date of 6/25/2020 that uses the payment terms code, the due date is 7/10/2020.

N

14

Percent

6

>>9.99

No

Enter the percent of the total invoice to be charged for a C.O.D. shipment. This field is slated for functionality in a future release, and is only used for C.O.D personal checks not accepted and C.O.D. personal checks accepted terms.

O

15

Provider Charge

10

>>>,>>9.99

No

Enter any charge that the provider (e.g. UPS) charges for C.O.D. deliveries, which will be billed to the customer. This field is slated for functionality in a future release, and is only used for C.O.D personal checks not accepted and C.O.D. personal checks accepted terms.

P

16

Credit Card Authorization Valid for X Days

4

>>>9

No

Enter the number of days before the credit card is reauthorized. Credit cards are reauthorized when pick demands are printed if more than this many days has passed since the initial authorization. If you enter zero, the credit card is not reauthorized. This field is only used for credit card terms.

Q

17

Default Credit Card Terms

3

Yes/No

No

Enter Yes if the credit card payment terms are the default credit card payment terms. You can only make one payment terms code the default credit card terms. If this field is blank, it defaults to No.

The default credit card payment terms are used if the credit card type transmitted from Worldpay is not set up in Apprise. This field is only used for credit card terms.

R

18

Finance

3

Yes/No

No

Enter Yes if you are using a third-party financing institution (factoring your receivables) for the payment terms. For more information, see Finance Terms. If this field is blank, it defaults to No. This field is only used for prepaid, due in number of days, and due on day of month terms.

S

19

Institution Code

12

Character

Yes, only if the Finance field (position 18) is Yes

Enter a valid customer code of the institution that will be paying the invoices that use the payment terms code. This field is only used if you enter Yes for the Finance field (position 18).

Note The institution must be set up in Customer Maintenance and be a valid billing customer.

T

20

Factor Client Code

10

Character

No

Enter the client code of the factoring institution. This is typically a four- or six-digit code. This field is only used if you enter Yes for the Finance field (position 18).

U

21

Factor Terms Code

12

Character

No

Enter the factor terms code of the factoring institution. This field is only used if you enter Yes for the Finance field (position 18).

V

22

Credit Hold Required Date Threshold

9

>,>>>,>>9

No

Enter the maximum number of days an order's required date can be changed without the order being credit checked.

Example You enter 21 in this field. An order has a required date of 11/01/2020. If the order is updated to only change the required date to 11/15/2020, the order is not credit checked (because the date has only changed 14 days, which is less than 21). If the order is updated to change the required date to 12/31/2020, the order is credit checked (because the required date is changed by more than 21 days).

This field is only used if you enter Yes for the Finance field (position 18).

W

23

Approval Export Program

20

Character

No

If the factoring institution requires you to transmit order information for approval, enter the Apprise program (.p) used to export the data in Factor Order Approval Export (in the format required by the institution). This field is only used if you enter Yes for the Finance field (position 18).

For CIT, enter ordappexp-cit.p in this field.

For TCF Inventory Finance, enter ordappexp-TCF.p in this field.

For Wells Fargo, enter ordappexp-wf.p in this field.

For information on the export file format, see Factor Order Approval Export Format.

X

24

Approval Import Program

20

Character

No

If you receive order approval information from the factoring institution, enter the Apprise program (.p) used to import the data in Factor Order Approval Import (in the format required by the institution). This field is only used if you enter Yes for the Finance field (position 18).

For CIT, enter ordappimp-cit.p in this field.

For TCF Inventory Finance, enter ordappimp-TCF.p in this field.

For Wells Fargo, enter ordappimp-wf.p in this field.

For information on the import file format, see Factor Order Approval Import Format.

Y

25

Approval Expiration Days

9

>,>>>,>>9

No

Enter the number of days after approval is received from the factoring institution to put orders back on finance terms hold (indicating the approval has expired), and mark orders as not transmitted to the factoring institution. This defaults to zero. This field is only used if you enter Yes for the Finance field (position 18).

NOTE Order approval expiration is only checked when credit tasks are refreshed in Credit Task Refresh.