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 |
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 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: