| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | LAAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | LAPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | LALNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 4 | LALSCR | Long Service Change Reason | Character | UDC (75 LS) | 1 | 0 | Allow NULL? |
| 5 | LALSLD | Long Service Leave Date | Date | Generic Edit | 6 | 0 | |
| 6 | LALSLP | Long Service Leave Prorate Date | Date | Generic Edit | 6 | 0 | |
| 7 | LAAVLG | Long Service Accrued Gross | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 8 | LAAVLH | Long Service Accrued Hours | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 9 | LALCMM | Leave Transaction Comments | String | Generic Edit | 300 | 0 | Allow NULL? |
| 10 | LAEEXX | Employee Secured | String | Generic Edit | 2 | 0 | Allow NULL? |
| 11 | LAUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 12 | LAUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 13 | LAPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 14 | LAJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | LAUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |