Column

Contains

Comments

A

Vendor #

Required on every line

B

Invoice #

Required on every line

C

Invoice Date

Required for new invoices.  MM/DD/CCYY or MMDDYY format

D

Invoice Amount

Required for new invoices.

E

Invoice Description

F

Hold Status

WD (when due) / NC (next check) / WS (when scheduled)

G

G/L Account

When blank, system will pull vendor default account or APG.

H

Distribution Amount

When blank, system will assume Invoice Amount.

I

Distribution Description

J

Scheduled Due Date

Only for scheduled payments  (Hold Status WS)

K

Scheduled Amount Due

Only for scheduled payments  (Hold Status WS)

L

Check Date

Manual Check batches:  required on 1^st line of invoice

M

Check ID

Manual Check batches:  required on 1^st line of invoice.

Up to 6 digit check number or full 12 digit e-payment id.

Checking account code (CKA) per batch header.

N

Check Amount Paid

Manual Check batches:  required on 1^st line of invoice.

O

Discount Taken

Manual Check batches:  optional.