# View: Check Job Details

RotoID: UP0056
Table: UPCHJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: UPCHJB

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0049 | UPCHKD | Check Details | UPCHKD
UP0144 | UPCHJO | Check Jobs Optional Fields Values | UPCHJO

## Keys: 1

Title | Fields
--- | ---
Check Job Line Number | EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO, JOBLINE

## Fields: 41

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
PEREND | 2 | Date | Period End Date | E A K R |
ENTRYSEQ | 3 | Long | Entry Sequence | E A K R |
CATEGORY | 4 | Integer | Category | E A K R | List: 10 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
7 | = | Federal Tax
8 | = | State Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED | 5 | String*6 | Earning/Deduction | E A K R | Mask: %-6N
LINETYPE | 6 | Integer | Type | E A K R | List: 9 entries
1 | = | Payment
2 | = | Accrual
3 | = | Regular
4 | = | Overtime
5 | = | Shift Differential
6 | = | n/a
7 | = | Normal Withholding
8 | = | Backup Withholding
9 | = | Supplemental Withholding
LINENO | 7 | Integer | Line Number | E A K R |
JOBLINE | 8 | Integer | Job Line Number | E A K R |
CONTRACT | 9 | String*16 | Contract Code | E A R | Mask: %-16C
PROJECT | 10 | String*16 | Project Code | E A R | Mask: %-16N
CCATEGORY | 11 | String*16 | Category Code | E A R | Mask: %-16N
IDCUST | 12 | String*12 | Customer | E A | Mask: %-12C
CURRCODE | 13 | String*3 | Billing Currency | E A | Mask: %-3C
STARTTIME | 14 | Integer | Start Time | E A |
STOPTIME | 15 | Integer | Stop Time | E A |
HOURS | 16 | BCD*4.3 | Hours | E A |
CNTBASE | 17 | BCD*10.3 | Pieces/Sales/Amt | E A |
BILLTYPE | 18 | Integer | Billing Type | E A P | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 19 | BCD*10.6 | Billing Rate | E A |
ARITEMNO | 20 | String*16 | A/R Item Number | E A | Mask: %-16C
ARUNIT | 21 | String*10 | A/R Item UOM | E A | Mask: %-10C
WIPACCT | 22 | String*45 | WIP/COS Acct | E A |
VALUES | 23 | Long | Number of Optional Fields | E A C |
CURRDESC | 24 | String*30 | Currency Description | E A |
UFMTCONTNO | 25 | String*16 | Unformatted Contract Code | E A | Mask: %-16C
PROJSTYLE | 26 | Integer | Project Style | E A | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | 27 | Integer | Project Type | E A | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 28 | Integer | Accounting Method | E A | List: 9 entries
0 | = |
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
7 | = | Completed Contract
8 | = | Accrual-Basis
BEXTEND | 29 | BCD*10.3 | Extended Billing Amount | E A |
EEXTEND | 30 | BCD*10.3 | Employee Extended Amount | E A |
GLOVERHEAD | 31 | String*45 | Overhead Account | E A |
GLLABOR | 32 | String*45 | Labor Burden Account | E A |
FCOVRHDAMT | 33 | BCD*10.3 | (FC) Overhead Amount | E A |
SCOVRHDAMT | 34 | BCD*10.3 | Overhead Amount | E A |
FCLABORAMT | 35 | BCD*10.3 | (FC) Labor Burden Amount | E A |
SCLABORAMT | 36 | BCD*10.3 | Labor Burden Amount | E A |
PMTRANSNUM | 37 | Long | PJC Transaction Number | E A |
COSTCLASS | 38 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | 39 | String*24 | Resource | E A P | Mask: %-16N
RESDESC | 40 | String*60 | Resource Description | E A |
PROCESSCMD | 100 | Integer | Process Command Code | E A C | List: 2 entries
0 | = | No Action
1 | = | Insert Optional Fields

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.