# View: ^1 Transactions

RotoID: PM0995
Protocol: Superview
DLL: PMTRANS

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Contract/Project/Category/Resour | CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSNUM

## Fields: 56

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 | ^2 Type | E A |
COSTNUM | 7 | Long | Cost Transaction Number | E A |
REVNUM | 8 | Long | Revenue Transaction Number | E A |
COSTREV | 9 | Integer | Cost or Revenue | E A |
DOCNUM | 10 | String*24 | Document Number | E A |
DOCTYPE | 11 | 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
TRANSDATE | 12 | Date | Transaction Date | E A |
FISCALYEAR | 13 | String*4 | Fiscal Year | E A | Mask: %04D
FISCALPER | 14 | 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
REFERENCE | 15 | String*60 | Document Reference | E A |
DESC | 16 | String*60 | Document Description | E A |
BILLTYPE | 17 | Integer | Billing Type | E A | List: 3 entries
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
TIMETYPE | 18 | Integer | Time Type | E A |
COSTCCY | 19 | String*3 | Cost Currency | E A |
ARITEM | 20 | String*16 | A/R Item No. | E A |
ARUOM | 21 | String*10 | A/R Unit of Measure | E A |
ICUOM | 22 | String*10 | ^7 | E A |
ITEMNO | 23 | String*24 | Item No. | E A |
LOCATION | 24 | String*6 | I/C Location | E A |
QUANTITY | 25 | BCD*10.5 | Transaction Quantity | E A |
UNITCOST | 26 | BCD*10.6 | Unit Cost | E A |
BILLRATE | 27 | BCD*10.6 | Billing Rate | E A |
EXTCOSTHM | 28 | BCD*10.3 | Extended Cost Amount | E A |
EXTCOSTSR | 29 | BCD*10.3 | Extended Cost Amount | E A |
EXTBILLHM | 30 | BCD*10.3 | Extended Billing Amount | E A |
EXTBILLSR | 31 | BCD*10.3 | Extended Billing Amount | E A |
BILLCCY | 32 | String*3 | Billing Currency | E A |
LABOR | 33 | Integer | Labor Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | 34 | BCD*10.6 | Labor Rate | E A |
LABORPER | 35 | BCD*5.5 | Labor Percentage | E A |
LABORSR | 36 | BCD*10.3 | Transaction Labor Amount | E A |
LABORHM | 37 | BCD*10.3 | Transaction Labor Amount | E A |
OVERHD | 38 | Integer | Overhead Type | E A | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | 39 | BCD*10.6 | Overhead Rate | E A |
HEADPER | 40 | BCD*5.5 | Overhead Percentage | E A |
OHSR | 41 | BCD*10.3 | Transaction Overhead Amount | E A |
OHHM | 42 | BCD*10.3 | Transaction Overhead Amount | E A |
MODULE | 43 | String*4 | Source Module | E A |
REVBILLED | 44 | 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
RRCOMPLETE | 45 | Integer | Has Revenue Recognition Been Run | E A | List: 3 entries
1 | = | Not Processed
2 | = | Selected for Processing
3 | = | Posted
CVACCT | 46 | String*45 | Cost Variance Account | E A |
WIPACCT | 47 | String*45 | WIP/COS Account | E A |
TRANACCT | 48 | String*45 | Transaction Account | E A |
REVACCT | 49 | String*45 | Revenue Account | E A |
OHACCT | 50 | String*45 | Overhead Account | E A |
LABACCT | 51 | String*45 | Labor Account | E A |
REVREC | 52 | 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 | 53 | Integer | Invoice Type | E A C | List: 2 entries
1 | = | Item
2 | = | Summary
EARNINGS | 54 | String*16 | Earnings Code | E A |
DATEBUS | 55 | Date | Posting Date | E A |
STAFFCODE | 56 | String*24 | Employee No. | E A |

This page was generated on 2008-May-01

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