# 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: 152

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 |
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 2008-May-01

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