View: Timecard Audit

RotoID: PM0042
Table: PMTIMHA
Protocol: Flat
DLL:PMTIMHA

Keys: 5

Title Fields
Posting Sequence POSTSEQNO
Sequence/Posting Sequence SEQ, POSTSEQNO
Payroll Updated/Transaction Date PAYUPDATED, TRANSDATE
Payroll Updated/Transaction Date PAYUPDATED, PAYTYPE, ENDDATE
Timecard Number TIMECARDNO

Fields: 54

Field Index Type Title Attributes Presentation
POSTSEQNO 1 Long Posting Sequence E A K R 
SEQ 2 Long Sequence E A 
POSTDATE 3 Date Posting Date E A 
TIMECARDNO 4 String*16 Time Card Number E A  Mask: %-6N
TRANSDATE 5 Date Transaction Date E A 
FISCALYEAR 6 String*4 Fiscal Year E A  Mask: %04D
FISCALPER 7 Integer Fiscal Period E A  List:13 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
13 = 13
STAFFCODE 8 String*16 Employee Number E A  Mask: %-16N
NAME 9 String*60 Name E A 
REFERENCE 10 String*60 Reference E A 
DESC 11 String*60 Description E A 
BEGINDATE 12 Date Begin Date E A 
ENDDATE 13 Date End Date E A 
TOTCOSTSR 14 BCD*10.3 Total Cost E A 
TOTCOSTHM 15 BCD*10.3 Total Cost E A 
TOTBILLSR 16 BCD*10.3 Total Billable E A 
TOTBILLHM 17 BCD*10.3 Total Billable E A 
TOTQTY 18 BCD*10.2 Total Quantity E A 
ETOTCOSTSR 19 BCD*10.3 Expenses Total Cost E A 
ETOTCOSTHM 20 BCD*10.3 Expenses Total Cost E A 
ETOTBILLSR 21 BCD*10.3 Expenses Total Billable E A 
ETOTBILLHM 22 BCD*10.3 Expenses Total Billable E A 
ETOTQTY 23 BCD*10.2 Expenses Total Quantity E A 
CCY 24 String*3 Currency E A  Mask: %-3N
RATE 25 BCD*8.7 Exchange Rate E A 
RATETYPE 26 String*2 Rate Type E A  Mask: %-2N
RATEDATE 27 Date Rate Date E A 
RATEOP 28 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATESPREAD 29 BCD*8.7 Rate Spread E A 
PRINTSTAT 30 Boolean Printed E A  List:2 entries
0 = False
1 = True
TRANSTAT 31 Integer Transaction Status E A  List:4 entries
1 = Entered
2 = Imported
3 = Generated
4 = Posted
PAYUPDATED 32 Boolean Payroll Updated ? E A 
PAYROLLTC 33 String*6 Payroll Timecard Number E A 
PAYTYPE 34 Integer Payroll Type E A  List:3 entries
3 = None
1 = US Payroll
2 = Canadian Payroll
HMON 35 BCD*10.2 Monday Hours E A 
HTUE 36 BCD*10.2 Tuesday Hours E A 
HWED 37 BCD*10.2 Wednesday Hours E A 
HTHU 38 BCD*10.2 Thursday Hours E A 
HFRI 39 BCD*10.2 Friday Hours E A 
HSAT 40 BCD*10.2 Saturday Hours E A 
HSUN 41 BCD*10.2 Sunday Hours E A 
HWEEK 42 BCD*10.2 Weekly Hours E A 
VALUES 43 Long Optional Fields E A C 
CREATEBY 44 String*8 Created By E A C 
CREATEDT 45 Date Created On E A C 
CREATETM 46 Time Created At E A C 
APPROVEBY 47 String*8 Approved By E A C 
APPROVEDT 48 Date Approved On E A C 
APPROVETM 49 Time Approved At E A C 
POSTEDBY 50 String*8 Posted By E A C 
POSTEDDT 51 Date Posted On E A C 
POSTEDTM 52 Time Posted At E A C 
GLHDESC 53 String*60 G/L Entry Description E A 
DATEBUS 54 Date Posting Date E A 

This page was generated on 2022-Aug-18

© 2021 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).