# Table: Contract Transactions

Table: PMTRAN
View: PM0111
Record length: 1747
Flags: A R

## Keys: 11

Title | Flags | Fields
--- | --- | ---
Contract/Project/Category/Resour |  | CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSNUM
Contract/Project/Category/Transa | D M | CONTRACT, PROJECT, CATEGORY, TRANSDATE
Contract/Project/Category/Curren | D M | CONTRACT, PROJECT, CATEGORY, CCY
Billed/Project Type/Customer/Con | D M | BILLED, PROJTYPE, IDCUST, CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSDATE
Billed/Customer/Project Type/Con | D M | BILLED, IDCUST, PROJTYPE, CONTRACT, PROJECT, CATEGORY, FISCALYEAR, FISCALPER
1/Project/Category/Revenue Run/T | D M | CONTRACT, PROJECT, CATEGORY, RRCOMPLETE, TRANSDATE
1/Project/Category/Revenue Run/F | D M | CONTRACT, PROJECT, CATEGORY, RRCOMPLETE, FISCALYEAR, FISCALPER
Contract/Project/Category/Resour | D M | CONTRACT, PROJECT, CATEGORY, RESOURCE, TRANSREF
Contract/Project/Category/Resour | D M | RRWORKID
Contract/Project/Category/Resour | D M | BWWORKID
Contract/Project/Category/Resour | D M | RRCOMPLETE, CONTRACT, PROJECT, TRANSDATE

## Fields: 148

Field | Type | Title | Presentation
--- | --- | --- | ---
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | 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 | Contract | 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: 22 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 Balances
TRANSTYPE | Integer | Transaction Type | List: 19 entries
1 | = | Posted
2 | = | Discount
3 | = | Write-off
4 | = | Apply From
5 | = | Apply To
6 | = | Payment/Receipt Reversal
7 | = | Rounding (multicurrency)
8 | = | Realized Exchange Gain/Loss
9 | = | Unrealized Exchange Gain/Loss
10 | = | Adjustment
11 | = | Receipt/Payment
20 | = | Retainage Rounding
21 | = | Retainage Realized 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
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 Bill | 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 | I/C Unit of Measure | 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 | Transaction Labor Amount (Source |
LABORHM | BCD*10.3 | Transaction Labor Amount (Functi |
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 | Transaction Overhead Amount (Sou |
OHHM | BCD*10.3 | Transaction Overhead Amount (Fun |
COSTPLUS | BCD*5.5 | Cost Plus Percentage |
TOTAMTSR | BCD*10.3 | Total Amount (ex tax) (Source) |
TOTAMTHM | BCD*10.3 | Total Amount (ex tax) (Functiona |
TAXAMTSR | BCD*10.3 | Tax Amount (Source) |
TAXAMTHM | BCD*10.3 | Tax Amount (Functional) |
TAMTSR | BCD*10.3 | Total Amount (inc tax) (Source) |
TAMTHM | BCD*10.3 | Total Amount (inc tax) (Function |
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 | EARNINGS | Mask: %-16C
EXPTAXSR | BCD*10.3 | Expensed Tax (source) |
EXPTAXHM | BCD*10.3 | Expensed Tax (functional) |
COSTTYPE | String*10 | COSTTYPE | Mask: %-10N
ADDCOST | Integer | Additional Cost Type | List: 4 entries
0 | = | None (Item)
1 | = | Prorated
2 | = | Prorated Manually
3 | = | Expensed

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.