Table: ^1 Transactions

Table: PMTRAN
View: PM0111
Record Length: 1783

Flags: A R 

Keys: 10

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

Fields: 153

Field Type Title Presentation
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 Mask: %-16N
RESOURCE String*24 Resource Mask: %-24C
TRANSNUM Long Transaction Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
PROJTYPE Integer Project Type List:4 entries
0 = None
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
TRANSDATE Date Transaction Date
DATELASTMN Date Last Maintained
FMTCONTNO String*16 ^1 Mask: %-16C
IDCUST String*12 Customer Number Mask: %-12C
VENDORID String*12 Vendor Mask: %-12C
DOCNUM String*24 Document Number
DOCDATE Date Document Date
MODULE String*4 Source Module
DOCTYPE Integer Document Type 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 Integer Transaction Type 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 Integer Cost or Revenue List:3 entries
1 = Cost
2 = Revenue
3 = Other
REFDOC String*24 Reference Document
DTEBTCH Date Batch Date
CNTBTCH BCD*5.0 Batch Number
CNTENT BCD*4.0 Batch Entry Number
CNTLINE BCD*3.0 Batch Line Number
REFERENCE String*60 Document Reference
DESC String*60 Document Description
POSTSEQ Long Posting Sequence
CCY String*3 Currency Code Mask: %-3N
RATETYPE String*2 Rate Type Code Mask: %-2N
RATEOVER Boolean Rate Override List:2 entries
0 = False
1 = True
RATEDATE Date Rate Date
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATE BCD*8.7 Exchange Rate
FISCALYEAR String*4 Fiscal Year Mask: %04D
FISCALPER Integer Fiscal Period 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 Integer Has The Cost Component Been Billed List:7 entries
1 = Not Billed
2 = Selected for Processing
3 = Invoice Created
4 = Posted
5 = Deleted
6 = Moved
7 = On Hold
QUANTITY BCD*10.5 Transaction Quantity
CONVERSION BCD*10.6 Conversion Factor
ICUOM String*10 ^7 Mask: %-10c
ITEMNO String*24 Item Number Mask: %-24C
LOCATION String*6 Location Mask: %-6N
BILLTYPE Integer Billing Type List:3 entries
2 = Billable
3 = No Charge
1 = Non-billable
FIXEDBILL Integer Bill Amount Based On List:2 entries
1 = Invoice This Amount
2 = Invoice Based on Exchange Rate
EXPTYPE Integer Timecard Expense Type 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 BCD*10.6 Unit Rate
EXTAMTSR BCD*10.3 Extended Amount (Source)
EXTAMTHM BCD*10.3 Extended Amount (Functional)
LABOR Integer Labor Type List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABORRATE BCD*10.6 Labor Rate
LABORPER BCD*5.5 Labor Percentage
LABORSR BCD*10.3 Source Labor Amount
LABORHM BCD*10.3 Functional Labor Amount
OVERHD Integer Overhead Type List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHEADRATE BCD*10.6 Overhead Rate
HEADPER BCD*5.5 Overhead Percentage
OHSR BCD*10.3 Source Overhead Amount
OHHM BCD*10.3 Functional Overhead Amount
COSTPLUS BCD*5.5 Cost Plus Percentage
TOTAMTSR BCD*10.3 Srce. Total Amount Excl. Tax
TOTAMTHM BCD*10.3 Func. Total Amount Excl. Tax
TAXAMTSR BCD*10.3 Tax Amount (Source)
TAXAMTHM BCD*10.3 Tax Amount (Functional)
TAMTSR BCD*10.3 Srce. Total Amount Inc. Tax
TAMTHM BCD*10.3 Func. Total Amount Inc. Tax
RRCOMPLETE Integer Has Revenue Recognition Been Run List:3 entries
1 = Not Processed
2 = Selected for Processing
3 = Posted
RCPAMTSR BCD*10.3 Amount Received (Source)
RCPAMTHM BCD*10.3 Amount Received (Functional)
PAYAMTSR BCD*10.3 Amount Paid (Source)
PAYAMTHM BCD*10.3 Amount Paid
USERID String*8 User ID
TAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAUTH5 String*12 Tax Authority 5 Mask: %-12N
TCLASS1 Integer Tax Class 1
TCLASS2 Integer Tax Class 2
TCLASS3 Integer Tax Class 3
TCLASS4 Integer Tax Class 4
TCLASS5 Integer Tax Class 5
TICLASS1 Integer Item Tax Class 1
TICLASS2 Integer Item Tax Class 2
TICLASS3 Integer Item Tax Class 3
TICLASS4 Integer Item Tax Class 4
TICLASS5 Integer Item Tax Class 5
TINCLUDED1 Boolean Tax Included 1
TINCLUDED2 Boolean Tax Included 2
TINCLUDED3 Boolean Tax Included 3
TINCLUDED4 Boolean Tax Included 4
TINCLUDED5 Boolean Tax Included 5
TAXBASES1 BCD*10.3 Tax Base 1 (Source)
TAXBASES2 BCD*10.3 Tax Base 2 (Source)
TAXBASES3 BCD*10.3 Tax Base 3 (Source)
TAXBASES4 BCD*10.3 Tax Base 4 (Source)
TAXBASES5 BCD*10.3 Tax Base 5 (Source)
TAXBASEH1 BCD*10.3 Tax Base 1 (Functional)
TAXBASEH2 BCD*10.3 Tax Base 2 (Functional)
TAXBASEH3 BCD*10.3 Tax Base 3 (Functional)
TAXBASEH4 BCD*10.3 Tax Base 4 (Functional)
TAXBASEH5 BCD*10.3 Tax Base 5 (Functional)
TAXAMTS1 BCD*10.3 Tax Amount 1 (Source)
TAXAMTS2 BCD*10.3 Tax Amount 2 (Source)
TAXAMTS3 BCD*10.3 Tax Amount 3 (Source)
TAXAMTS4 BCD*10.3 Tax Amount 4 (Source)
TAXAMTS5 BCD*10.3 Tax Amount 5 (Source)
TAXAMTH1 BCD*10.3 Tax Amount 1 (Functional)
TAXAMTH2 BCD*10.3 Tax Amount 2 (Functional)
TAXAMTH3 BCD*10.3 Tax Amount 3 (Functional)
TAXAMTH4 BCD*10.3 Tax Amount 4 (Functional)
TAXAMTH5 BCD*10.3 Tax Amount 5 (Functional)
RTAXAMTSR BCD*10.3 Recoverable Tax (Source)
RTAXAMTHM BCD*10.3 Recoverable Tax (Functional)
CVAMT BCD*10.3 Cost Variance Amount
WIPACCT String*45 WIP/COS Account Mask: %-45C
TRANACCT String*45 Transaction Account Mask: %-45C
LABORACCT String*45 Labor Account Mask: %-45C
OHACCT String*45 Overhead Account Mask: %-45C
REVACCT String*45 Revenue Account Mask: %-45C
CVACCT String*45 Cost Variance Account Mask: %-45C
ARITEM String*16 A/R Item No. Mask: %-16C
ARUOM String*10 A/R Unit of Measure Mask: %-10C
TRANSREF Long Transaction Reference
OTHERREF Long Cost/Revenue TRANSNUM
COMMENTS String*250 Comments
TYPE Integer Cost Class List:7 entries
0 = None
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
TRANSQTY BCD*10.5 Quantity
RRWORKID String*30 RR Worksheet Number
BWWORKID String*30 Billing Worksheet Number
TAMTRETSR BCD*10.3 Source Retainage Amount
TAMTRETHM BCD*10.3 Functional Retainage Amount
RETDUEDT Date Retainage Due Date
ORIGDOC String*24 Original Document Number
REVREC Integer Accounting Method 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 Integer Invoice Type List:2 entries
1 = Item
2 = Summary
DAYENDSEQ Long Day End Sequence
DAYENDDATE Date Day End Date
ORIGAPP String*2 Original Application
VALUES Long Optional Fields
DRILLSRCTY Integer Drill Down Type
DRILLDWNLK BCD*10.0 Drill Down Link
DRILLAPP String*2 Drill Down Application
EARNINGS String*16 Mask: %-16C
EXPTAXSR BCD*10.3 Expensed Tax (source)
EXPTAXHM BCD*10.3 Expensed Tax (functional)
COSTTYPE String*10 Mask: %-10N
ADDCOST Integer Additional Cost Type List:4 entries
0 = None (Item)
1 = Prorated
2 = Prorated Manually
3 = Expensed
PMVERSION String*3 Current PM Version
ADJREVTYPE Integer Adjustment Revenue Type
DATEBUS Date Posting Date
STAFFCODE String*24 Employee No.
LINENO Integer

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