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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).