Cost Days
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
20=Cost Days 1 |
LEAVES |
COSTING_DAYS_1 |
Size: 10 Format: ######.#### |
|
22=Cost Days 2 |
LEAVES |
COSTING_DAYS_2 |
Size: 10 Format: ######.#### |
|
24=Cost Days 3 |
LEAVES |
COSTING_DAYS_3 |
Size: 10 Format: ######.#### |
Cost Rule
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
21=Cost Rule 1 Code |
LEAVES |
COSTING_RULE_1_CODE |
Size: 10 |
|
21=Cost Rule 1 Description |
LEAVES |
COSTING_RULE_1_DESC |
Detailed Explanation of code. Size: 30 |
|
23=Cost Rule 2 Code |
LEAVES |
COSTING_RULE_2_CODE |
Size: 10 |
|
23=Cost Rule 2 Description |
LEAVES |
COSTING_RULE_2_DESC |
Detailed Explanation of code. Size: 30 |
|
25=Cost Rule 3 Code |
LEAVES |
COSTING_RULE_3_CODE |
Size: 10 |
|
25=Cost Rule 3 Description |
LEAVES |
COSTING_RULE_3_DESC |
Detailed Explanation of code. Size: 30 |
Leave Application
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
02=Leave Type |
LEAVES |
LEAVE_TYPE_CODE |
Size: 4 |
|
02=Leave Type |
LEAVES |
LEAVE_TYPE_DESC |
Detailed Explanation of code. Size: 30 |
|
03=Location |
LEAVES |
LOCATION_CODE |
Size: 4 |
|
03=Location |
LEAVES |
LOCATION_NAME |
Detailed Explanation of code. Size: 30 |
|
04=Position |
LEAVES |
POSITION_CODE |
Size: 8 |
|
04=Position |
LEAVES |
POSITION_DESC |
Detailed Explanation of code. Size: 30 |
|
05=Medical Form |
LEAVES |
MEDICAL_NOTE_YN |
Internal Lookup: Y=Yes, N=No, Size: 3 |
|
06=Docs |
LEAVES |
OTHER_DOCUMENTS_YN |
Internal Lookup: Y=Yes, N=No, Size: 3 |
|
07=Start Date |
LEAVES |
START_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
08=End Date |
LEAVES |
END_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
09=Week Days |
LEAVES |
DAYS_OF_WEEK |
Size: 7 |
|
10=Days |
LEAVES |
INTERFACED_DAYS |
Size: 10 Format: ######.#### |
|
12=Cost Rule |
LEAVES |
APPL_COST_RULE_CODE |
Size: 14 |
|
12=Cost Rule |
LEAVES |
APPL_COST_RULE_DESC |
Detailed Explanation of code. Size: 30 |
|
13=Comment |
LEAVES |
APPLICATION_COMMENT |
Size: 30 |
Leave Approval
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
14=Status |
LEAVES |
STATUS_CODE |
Internal Lookup: R=Requested, A=Approved, D=Denied, V=Under Review, C=Cancelled, Size: 4 |
|
15=Approval Date |
LEAVES |
APPROVED_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
16=Replacing Code |
LEAVES |
REPLACEMENT_TYPE_CODE |
Size: 10 |
|
16=Replacing Code |
LEAVES |
REPLACEMENT_TYPE_DESC |
Detailed Explanation of code. Size: 30 |
|
16=Replacing Type |
LEAVES |
APPR_REPL_TYPE_CODE |
Size: 10 |
|
17=Replacing Emp |
LEAVES |
REPLACING_EMPLOYEE_NAME |
Detailed Explanation of code. Size: 30 |
|
17=Replacing Emp |
LEAVES |
REPLACING_EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
18=Approving Emp |
LEAVES |
APPROVING_EMPLOYEE_NAME |
Detailed Explanation of code. Size: 30 |
|
18=Approving Emp |
LEAVES |
APPROVING_EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
19=Comment |
LEAVES |
APPROVED_COMMENT |
Size: 30 |
|
Time Used: |
LEAVES |
TOTAL_UNITS |
Size: 10 Format: ######.#### |
Other Costing Information
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
26=Customer # |
LEAVES |
CUSTOMER_NO |
Size: 10 |
|
27=Approv # |
LEAVES |
APPROVAL_NO |
Size: 10 |
|
29=Abs Cost Center |
LEAVES |
ABS_COST_CENTER |
Size: 10 |
|
30=Abs GL |
LEAVES |
ABS_GL_ACCOUNT_NO |
Size: 20 |
|
30=Abs GL |
LEAVES |
ABS_SL_ACCOUNT_NO |
Size: 10 |
|
31=Rep Cost Center |
LEAVES |
REP_COST_CENTER |
Size: 10 |
|
32=Rep GL |
LEAVES |
REP_GL_ACCOUNT_NO |
Size: 20 |
|
32=Rep GL |
LEAVES |
REP_SL_ACCOUNT_NO |
Size: 10 |
|
33=Supplmental Billing Info |
LEAVES |
SUPP_BILLING_COMMENT |
Size: 30 |