LLJV_Import.xls

The LLJV_Import.xls template applies to the Labor Distribution Journal Voucher (LLJV) document.

The basic format of the template is shown below in two parts.

LLJV_Import template format (fields listed in order required by template)

Column

Field Name

A

Chart Code

exclaim.gif    If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template.

B

Account Number

C

Sub-Account Number

D

Object

E

Type Code

F

Sub-Object Code

G

Project Code

H

Org Ref Id

I

Position Number

J

Employee ID

K

Employee Record

L

Earn Code

M

Pay Group

N

Salary Admin Plan

O

Grade

P

Run ID

Q

Period End

R

Pay FY

S

Pay Period

T

Pay Hours

U

Original Chart

exclaim.gif    If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template.

V

Original Account

W

Original Sub-Account

X

Original Object Code

Y

Original Sub-Object Code

Z

Company

AA

Set ID

AB

Debit (Enter an amount either the debit or credit field)

AC

Credit (Enter an amount either the debit or credit field)

More:

ND_Import.xls