View CSV Layout for Exported Invoices
Category:File Layouts
Category:CSV’s
CSV Layout for Exported Invoices
File Layout for
Invoice Exporting (csv format)
|
|
Letter |
Title |
Content Description |
|
1 |
A |
Group
number |
Internal
Hudson group profile number |
|
2 |
B |
Client
Alias |
Customer
ID for target accounting system |
|
3 |
C |
Client
Name |
|
|
4 |
D |
Invoice
number |
|
|
5 |
E |
Total
invoice amount |
|
|
6 |
F |
Invoice
date |
|
|
7 |
G |
Transaction
date |
Configurable
for either the invoice date or the end of the period |
|
8 |
H |
Due
date |
Invoice
date + terms code |
|
9 |
I |
Terms
code |
|
|
10 |
J |
Status |
N-Normal,
V-Voided |
|
11 |
K |
AR
(cash) account number |
|
|
12 |
L |
AR
(cash) dept. number |
|
|
13 |
M |
Number
of distributions |
Indicates
the number of related records in this file |
|
14 |
N |
GL
(income) account number |
Specified
by service |
|
15 |
O |
GL
(income) dept number |
Specified
by service |
|
16 |
P |
Amount |
Distribution
by service |
|
17 |
Q |
Tax
type |
Specified
by service |
|
18 |
R |
Tax
authority |
Specified
by service |
