Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

View CSV Layout for Exported Invoices

Category:File Layouts
Category:CSV’s

CSV Layout for Exported Invoices

File Layout for Invoice Exporting (csv format)

 

Number

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

 

Categories: