# View: Manual Check Job Details

RotoID: UP0043
Table: UPMCJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: UPMCJB

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0020 | UPMCDT | Manual Check Detail | UPMCDT
UP0142 | UPMCJO | Manual Check Jobs Opt Fields | UPMCJO

## Keys: 2

Title | Fields
--- | ---
Manual Check Job Line Number | EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, LINENUM, JOBLINE
Manual Check Job | EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, LINENUM, CONTRACT, PROJECT, CCATEGORY, JOBLINE

## Fields: 35

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
BANK | 2 | String*8 | Bank ID | E A K R | Mask: %-8N
CHECKNUM | 3 | BCD*5.0 | Check Number | E A K R |
PEREND | 4 | Date | Period End Date | E A K R |
CHECKDATE | 5 | Date | Check Date | E A K R |
LINENUM | 6 | Integer | Line Number | E A K R |
JOBLINE | 7 | Integer | Job Line Number | E A K R |
CONTRACT | 8 | String*16 | Contract Code | E A R | Mask: %-16C
PROJECT | 9 | String*16 | Project Code | E A R | Mask: %-16N
CCATEGORY | 10 | String*16 | Category Code | E A R | Mask: %-16N
IDCUST | 11 | String*12 | Customer | A R | Mask: %-12C
CURRCODE | 12 | String*3 | Billing Currency | A C | Mask: %-3C
STARTTIME | 13 | Integer | Start Time | E A X |
STOPTIME | 14 | Integer | Stop Time | E A X |
HOURS | 15 | BCD*4.3 | Hours | E A X |
CNTBASE | 16 | BCD*10.3 | Pieces/Sales/Amt | E A X |
BILLTYPE | 17 | Integer | Billing Type | A P X | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 18 | BCD*10.6 | Billing Rate | A X |
ARITEMNO | 19 | String*16 | A/R Item Number | A X | Mask: %-16C
ARUNIT | 20 | String*10 | A/R Item UOM | A X | Mask: %-10C
WIPACCT | 21 | String*45 | Regular WIP/COS Acct | E A X |
OTWIPACCT | 22 | String*45 | Overtime WIP/COS Acct | E A X |
STWIPACCT | 23 | String*45 | Shift WIP/COS Acct | E A X |
VALUES | 24 | Long | Number of Optional Fields | E A C X |
PROJSTYLE | 25 | Integer | Project Style | A C | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | 26 | Integer | Project Type | A C | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
UFMTCONTNO | 27 | String*16 | Unformatted Contract Code | A C | Mask: %-16C
REVREC | 28 | Integer | Accounting Method | A C | 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
COSTCLASS | 29 | Integer | Cost Class | A C | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
CURRDESC | 30 | String*30 | Currency Description | A C |
KEYACTION | 31 | Integer | INTERNAL USE - Key Action | A C |
ALLOWGLOVR | 32 | Boolean | Allow cost center overrides | A C |
PROCESSCMD | 33 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
RESOURCE | 50 | String*24 | Resource | E A P X | Mask: %-16N
RESDESC | 51 | String*60 | Resource Description | E A X |

This page was generated on 2008-May-02

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