Table: ^1 Transactions

Table: PMTRAN
View: PM0111
Record length: 1781
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: 152

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.   

This page was generated on 2008-May-01

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