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
|
Column |
Field Name |
|
A |
|
|
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
|
|
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: