View: ^1 Transactions

RotoID: PM0111
Table: PMTRAN
Protocol: Header
DLL:PMTRAN

Compositions: 1

RotoID Tables Title DLL
PM0854 PMTRANO Transaction Optional Field PMTRANO

Keys: 10

Title Fields
Contract/Project/Category/Resour CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSNUM
Contract/Project/Category/Transa CONTRACT, PROJECT, CATEGORY, TRANSDATE
Revenue Recognition by Transacti CONTRACT, PROJECT, CATEGORY, RRCOMPLETE, TRANSDATE
Revenue Recognition by Fiscal Ye CONTRACT, PROJECT, CATEGORY, RRCOMPLETE, FISCALYEAR, FISCALPER
Contract/Project/Category/Resour CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSREF
Revenue Recognition Worksheet RRWORKID
Revenue Recognition RRCOMPLETE, CONTRACT, PROJECT, TRANSDATE
Generate Billing Worksheet (Item COSTREV, INVTYPE, BILLED, IDCUST, CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSDATE
Generate Billing Worksheet (Summ BILLED, BILLTYPE, IDCUST, CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSDATE
Billed/Contract/Project/Category BILLED, CONTRACT, PROJECT, CATEGORY, RESOURCE

Fields: 153

Field Index Type Title Attributes Presentation
CONTRACT 1 String*16 ^1 E A K R  Mask: %-16C
PROJECT 2 String*16 ^2 E A K R  Mask: %-16N
CATEGORY 3 String*16 ^3 E A K R  Mask: %-16N
RESOURCE 4 String*24 Resource E A K R  Mask: %-24C
TRANSNUM 5 Long Transaction Number E A K R 
PROJTYPE 6 Integer Project Type E A  List:4 entries
0 = None
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
TRANSDATE 7 Date Transaction Date E A 
DATELASTMN 8 Date Last Maintained A C 
FMTCONTNO 9 String*16 ^1 E A  Mask: %-16C
IDCUST 10 String*12 Customer Number E A  Mask: %-12C
VENDORID 11 String*12 Vendor E A  Mask: %-12C
DOCNUM 12 String*24 Document Number E A 
DOCDATE 13 Date Document Date E A 
MODULE 14 String*4 Source Module E A 
DOCTYPE 15 Integer Document Type E A  List:31 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
5 = Prepayment
6 = Unapplied Cash
7 = Material Usage
8 = Material Return
9 = Equipment Usage
10 = Timecard
11 = Charges
12 = Adjustment
13 = Retainage Invoice
14 = Retainage Credit Note
15 = Retainage Debit Note
16 = Purchase Order
17 = P/O Receipt
18 = P/O Return
19 = P/O Invoice
20 = P/O Credit Note
21 = P/O Debit Note
22 = Opening Balance
23 = Manual Check
24 = Cost
25 = Check Reversal
26 = Material Internal Usage
27 = Order Entry
28 = O/E Shipment
29 = O/E Invoice
30 = O/E Debit Note
31 = O/E Credit Note
TRANSTYPE 16 Integer Transaction Type E A  List:23 entries
1 = Posted
2 = Discount
3 = Write-off
4 = Apply From
5 = Apply To
6 = Payment/Receipt Reversal
7 = Rounding (multicurrency)
8 = Exchange Gain/Loss
9 = Unrealized Exchange Gain/Loss
10 = Adjustment
11 = Receipt/Payment
20 = Retainage Rounding
21 = Retainage Exchange Gain/Loss
22 = Retainage Unrealized Exchange Gain/Loss
23 = Opening Retainage Receivable
24 = Opening Retainage Payable
25 = Invoice Retainage Receivable
26 = Invoice Retainage Payable
28 = Opening Balance Reversal
29 = Refund
30 = Refund Reversal
31 = Exchange Gain/Loss
32 = Retainage Gain/Loss
COSTREV 17 Integer Cost or Revenue E A  List:3 entries
1 = Cost
2 = Revenue
3 = Other
REFDOC 18 String*24 Reference Document E A 
DTEBTCH 19 Date Batch Date E A 
CNTBTCH 20 BCD*5.0 Batch Number E A 
CNTENT 21 BCD*4.0 Batch Entry Number E A 
CNTLINE 22 BCD*3.0 Batch Line Number E A 
REFERENCE 23 String*60 Document Reference E A 
DESC 24 String*60 Document Description E A 
POSTSEQ 25 Long Posting Sequence E A 
CCY 26 String*3 Currency Code E A  Mask: %-3N
RATETYPE 27 String*2 Rate Type Code E A  Mask: %-2N
RATEOVER 28 Boolean Rate Override E A  List:2 entries
0 = False
1 = True
RATEDATE 29 Date Rate Date E A 
RATEOP 30 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATE 31 BCD*8.7 Exchange Rate E A 
FISCALYEAR 32 String*4 Fiscal Year E A  Mask: %04D
FISCALPER 33 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
BILLED 34 Integer Has The Cost Component Been Billed E A  List:7 entries
1 = Not Billed
2 = Selected for Processing
3 = Invoice Created
4 = Posted
5 = Deleted
6 = Moved
7 = On Hold
QUANTITY 35 BCD*10.5 Transaction Quantity E A 
CONVERSION 36 BCD*10.6 Conversion Factor E A 
ICUOM 37 String*10 ^7 E A  Mask: %-10c
ITEMNO 38 String*24 Item Number E A  Mask: %-24C
LOCATION 39 String*6 Location E A  Mask: %-6N
BILLTYPE 40 Integer Billing Type E A  List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
FIXEDBILL 41 Integer Bill Amount Based On E A  List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
EXPTYPE 42 Integer Timecard Expense Type E A  List:10 entries
0 = N/A
1 = Airfares
2 = Accommodation
3 = Meals
4 = Entertainment
5 = Taxi/Hire Car
6 = Tolls
7 = Telephone
8 = Parking
9 = Other
UNITRATE 43 BCD*10.6 Unit Rate E A 
EXTAMTSR 44 BCD*10.3 Extended Amount (Source) E A 
EXTAMTHM 45 BCD*10.3 Extended Amount (Functional) E A 
LABOR 46 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE 47 BCD*10.6 Labor Rate E A 
LABORPER 48 BCD*5.5 Labor Percentage E A 
LABORSR 49 BCD*10.3 Source Labor Amount E A 
LABORHM 50 BCD*10.3 Functional Labor Amount E A 
OVERHD 51 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE 52 BCD*10.6 Overhead Rate E A 
HEADPER 53 BCD*5.5 Overhead Percentage E A 
OHSR 54 BCD*10.3 Source Overhead Amount E A 
OHHM 55 BCD*10.3 Functional Overhead Amount E A 
COSTPLUS 56 BCD*5.5 Cost Plus Percentage E A 
TOTAMTSR 57 BCD*10.3 Srce. Total Amount Excl. Tax E A 
TOTAMTHM 58 BCD*10.3 Func. Total Amount Excl. Tax E A 
TAXAMTSR 59 BCD*10.3 Tax Amount (Source) E A 
TAXAMTHM 60 BCD*10.3 Tax Amount (Functional) E A 
TAMTSR 61 BCD*10.3 Srce. Total Amount Inc. Tax E A 
TAMTHM 62 BCD*10.3 Func. Total Amount Inc. Tax E A 
RRCOMPLETE 63 Integer Has Revenue Recognition Been Run E A  List:3 entries
1 = Not Processed
2 = Selected for Processing
3 = Posted
RCPAMTSR 64 BCD*10.3 Amount Received (Source) E A 
RCPAMTHM 65 BCD*10.3 Amount Received (Functional) E A 
PAYAMTSR 66 BCD*10.3 Amount Paid (Source) E A 
PAYAMTHM 67 BCD*10.3 Amount Paid E A 
USERID 68 String*8 User ID E A 
TAUTH1 69 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 70 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 71 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 72 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 73 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 74 Integer Tax Class 1 E A 
TCLASS2 75 Integer Tax Class 2 E A 
TCLASS3 76 Integer Tax Class 3 E A 
TCLASS4 77 Integer Tax Class 4 E A 
TCLASS5 78 Integer Tax Class 5 E A 
TICLASS1 79 Integer Item Tax Class 1 E A 
TICLASS2 80 Integer Item Tax Class 2 E A 
TICLASS3 81 Integer Item Tax Class 3 E A 
TICLASS4 82 Integer Item Tax Class 4 E A 
TICLASS5 83 Integer Item Tax Class 5 E A 
TINCLUDED1 84 Boolean Tax Included 1 E A 
TINCLUDED2 85 Boolean Tax Included 2 E A 
TINCLUDED3 86 Boolean Tax Included 3 E A 
TINCLUDED4 87 Boolean Tax Included 4 E A 
TINCLUDED5 88 Boolean Tax Included 5 E A 
TAXBASES1 89 BCD*10.3 Tax Base 1 (Source) E A 
TAXBASES2 90 BCD*10.3 Tax Base 2 (Source) E A 
TAXBASES3 91 BCD*10.3 Tax Base 3 (Source) E A 
TAXBASES4 92 BCD*10.3 Tax Base 4 (Source) E A 
TAXBASES5 93 BCD*10.3 Tax Base 5 (Source) E A 
TAXBASEH1 94 BCD*10.3 Tax Base 1 (Functional) E A 
TAXBASEH2 95 BCD*10.3 Tax Base 2 (Functional) E A 
TAXBASEH3 96 BCD*10.3 Tax Base 3 (Functional) E A 
TAXBASEH4 97 BCD*10.3 Tax Base 4 (Functional) E A 
TAXBASEH5 98 BCD*10.3 Tax Base 5 (Functional) E A 
TAXAMTS1 99 BCD*10.3 Tax Amount 1 (Source) E A 
TAXAMTS2 100 BCD*10.3 Tax Amount 2 (Source) E A 
TAXAMTS3 101 BCD*10.3 Tax Amount 3 (Source) E A 
TAXAMTS4 102 BCD*10.3 Tax Amount 4 (Source) E A 
TAXAMTS5 103 BCD*10.3 Tax Amount 5 (Source) E A 
TAXAMTH1 104 BCD*10.3 Tax Amount 1 (Functional) E A 
TAXAMTH2 105 BCD*10.3 Tax Amount 2 (Functional) E A 
TAXAMTH3 106 BCD*10.3 Tax Amount 3 (Functional) E A 
TAXAMTH4 107 BCD*10.3 Tax Amount 4 (Functional) E A 
TAXAMTH5 108 BCD*10.3 Tax Amount 5 (Functional) E A 
RTAXAMTSR 109 BCD*10.3 Recoverable Tax (Source) E A 
RTAXAMTHM 110 BCD*10.3 Recoverable Tax (Functional) E A 
CVAMT 111 BCD*10.3 Cost Variance Amount E A 
WIPACCT 112 String*45 WIP/COS Account E A  Mask: %-45C
TRANACCT 113 String*45 Transaction Account E A  Mask: %-45C
LABORACCT 114 String*45 Labor Account E A  Mask: %-45C
OHACCT 115 String*45 Overhead Account E A  Mask: %-45C
REVACCT 116 String*45 Revenue Account E A  Mask: %-45C
CVACCT 117 String*45 Cost Variance Account E A  Mask: %-45C
ARITEM 118 String*16 A/R Item No. E A  Mask: %-16C
ARUOM 119 String*10 A/R Unit of Measure E A  Mask: %-10C
TRANSREF 120 Long Transaction Reference E A 
OTHERREF 121 Long Cost/Revenue TRANSNUM E A 
COMMENTS 122 String*250 Comments E A 
TYPE 123 Integer Cost Class E A  List:7 entries
0 = None
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
TRANSQTY 124 BCD*10.5 Quantity E A 
RRWORKID 125 String*30 RR Worksheet Number E A 
BWWORKID 126 String*30 Billing Worksheet Number E A 
TAMTRETSR 127 BCD*10.3 Source Retainage Amount E A 
TAMTRETHM 128 BCD*10.3 Functional Retainage Amount E A 
RETDUEDT 129 Date Retainage Due Date E A 
ORIGDOC 130 String*24 Original Document Number E A 
REVREC 131 Integer Accounting Method E A C  List:7 entries
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
8 = Accrual-Basis
INVTYPE 132 Integer Invoice Type E A C  List:2 entries
1 = Item
2 = Summary
DAYENDSEQ 133 Long Day End Sequence E A 
DAYENDDATE 134 Date Day End Date E A 
ORIGAPP 135 String*2 Original Application E A 
VALUES 136 Long Optional Fields E A C 
DRILLSRCTY 137 Integer Drill Down Type E A 
DRILLDWNLK 138 BCD*10.0 Drill Down Link E A 
DRILLAPP 139 String*2 Drill Down Application E A 
EARNINGS 140 String*16 E A  Mask: %-16C
EXPTAXSR 141 BCD*10.3 Expensed Tax (source) E A 
EXPTAXHM 142 BCD*10.3 Expensed Tax (functional) E A 
COSTTYPE 143 String*10 E A  Mask: %-10N
ADDCOST 144 Integer Additional Cost Type E A  List:4 entries
0 = None (Item)
1 = Prorated
2 = Prorated Manually
3 = Expensed
PMVERSION 145 String*3 Current PM Version E A 
ADJREVTYPE 146 Integer Adjustment Revenue Type E A 
DATEBUS 147 Date Posting Date E A 
STAFFCODE 148 String*24 Employee No. E A 
LINENO 149 Integer E A 
CUSTNAME 1001 String*60 Customer Name A C 
VENDNAME 1002 String*60 Vendor Name A C 
LOCNAME 1003 String*60 Location Name A C 
HASOPT 1004 Boolean Optional Fields E A C  List:2 entries
0 = No
1 = Yes

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