View: A/P Superview

RotoID: PM0302
Table: PMAP
Protocol: Header
DLL:PMAP

Compositions: 1

RotoID Tables Title DLL
PM0520 PMAPO A/P Optional Field PMAPO

Keys: 1

Title Fields
CNTBTCH

Fields: 117

Field Index Type Title Attributes Presentation
CNTBTCH 1 BCD*5.0 Batch Number E A K R 
CNTENT 2 BCD*4.0 Batch Entry Number E A 
CNTLINE 3 BCD*3.0 Batch Line Number E A 
TRANSDATE 4 Date Transaction Date E A 
DTEBTCH 5 Date Batch Date E A 
DOCDATE 6 Date Entry Date E A 
POSTSEQ 7 Long Posting Sequence E A 
FISCALYEAR 8 String*4 Fiscal Year E A  Mask: %04D
FISCALPER 9 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
DOCNUM 10 String*22 Document Number E A 
VENDORID 11 String*12 Vendor Number E A 
CCY 12 String*3 Transaction Currency E A 
RATETYPE 13 String*2 Rate Type E A 
RATEDATE 14 Date Rate Date E A 
RATEOP 15 Integer Rate Operator E A 
RATEOVER 16 Boolean Rate Override E A  List:2 entries
0 = False
1 = True
RATE 17 BCD*8.7 Exchange Rate E A 
DOCTYPE 18 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 19 Integer Transaction Type E A  List:26 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
12 = Insert
13 = Delete
14 = Edit
TRANSNUM 20 Long Transaction Number E A 
CONTRACT 21 String*16 ^1 E A 
PROJECT 22 String*16 ^2 E A 
CATEGORY 23 String*16 ^3 E A 
RESOURCE 24 String*24 Resource E A 
ARITEM 25 String*16 A/R Item Number E A 
ARUOM 26 String*10 Unit of Measure E A 
REFERENCE 27 String*60 Reference E A 
DESC 28 String*60 Description E A 
QUANTITY 29 BCD*10.5 Quantity E A 
UNITCOST 30 BCD*10.6 Unit Cost E A 
BILLRATE 31 BCD*10.6 Billing Rate E A 
TOTAMTSR 32 BCD*10.3 Total Amount (ex tax) E A 
TOTAMTHM 33 BCD*10.3 Total Amount (ex tax) E A 
TAXAMTSR 34 BCD*10.3 Tax Amount E A 
TAXAMTHM 35 BCD*10.3 Tax Amount E A 
RTAXAMTSR 36 BCD*10.3 Recoverable Tax E A 
RTAXAMTHM 37 BCD*10.3 Recoverable Tax E A 
TAMTSR 38 BCD*10.3 Total Amount (inc tax) E A 
TAMTHM 39 BCD*10.3 Total Amount (inc tax) E A 
PAYAMTSR 40 BCD*10.3 Amount Paid E A 
PAYAMTHM 41 BCD*10.3 Amount Paid E A 
REFDOC 42 String*22 Reference Document E A 
WIPACCT 43 String*45 Work in Progress Account E A 
COSTACCT 44 String*45 Cost Account E A 
OHACCT 45 String*45 Overhead Account E A 
OHSR 46 BCD*10.3 Overhead Amount E A 
OHHM 47 BCD*10.3 Overhead Amount E A 
LABACCT 48 String*45 Labor Account E A 
LABORSR 49 BCD*10.3 Labor Amount E A 
LABORHM 50 BCD*10.3 Labor Amount E A 
BILLTYPE 51 Integer Billing Type E A 
COMMENTS 52 String*250 Comments E A 
TAUTH1 53 String*12 Tax Authority 1 E A 
TAUTH2 54 String*12 Tax Authority 2 E A 
TAUTH3 55 String*12 Tax Authority 3 E A 
TAUTH4 56 String*12 Tax Authority 4 E A 
TAUTH5 57 String*12 Tax Authority 5 E A 
TCLASS1 58 Integer Customer/Vendor Tax Class 1 E A 
TCLASS2 59 Integer Customer/Vendor Tax Class 2 E A 
TCLASS3 60 Integer Customer/Vendor Tax Class 3 E A 
TCLASS4 61 Integer Customer/Vendor Tax Class 4 E A 
TCLASS5 62 Integer Customer/Vendor Tax Class 5 E A 
TITMCLSS1 63 Integer Item Tax Class 1 E A 
TITMCLSS2 64 Integer Item Tax Class 2 E A 
TITMCLSS3 65 Integer Item Tax Class 3 E A 
TITMCLSS4 66 Integer Item Tax Class 4 E A 
TITMCLSS5 67 Integer Item Tax Class 5 E A 
TINCLUDE1 68 Integer Tax Included 1 E A 
TINCLUDE2 69 Integer Tax Included 2 E A 
TINCLUDE3 70 Integer Tax Included 3 E A 
TINCLUDE4 71 Integer Tax Included 4 E A 
TINCLUDE5 72 Integer Tax Included 5 E A 
TAXBASES1 73 BCD*10.3 Tax Base 1 Source Currency E A 
TAXBASES2 74 BCD*10.3 Tax Base 2 Source Currency E A 
TAXBASES3 75 BCD*10.3 Tax Base 3 Source Currency E A 
TAXBASES4 76 BCD*10.3 Tax Base 4 Source Currency E A 
TAXBASES5 77 BCD*10.3 Tax Base 5 Source Currency E A 
TAXBASEH1 78 BCD*10.3 Tax Base 1 Functional Currency E A 
TAXBASEH2 79 BCD*10.3 Tax Base 2 Functional Currency E A 
TAXBASEH3 80 BCD*10.3 Tax Base 3 Functional Currency E A 
TAXBASEH4 81 BCD*10.3 Tax Base 4 Functional Currency E A 
TAXBASEH5 82 BCD*10.3 Tax Base 5 Functional Currency E A 
TAXAMTS1 83 BCD*10.3 Tax Amount 1 Source Currency E A 
TAXAMTS2 84 BCD*10.3 Tax Amount 2 Source Currency E A 
TAXAMTS3 85 BCD*10.3 Tax Amount 3 Source Currency E A 
TAXAMTS4 86 BCD*10.3 Tax Amount 4 Source Currency E A 
TAXAMTS5 87 BCD*10.3 Tax Amount 5 Source Currency E A 
TAXAMTH1 88 BCD*10.3 Tax Amount 1 Functional Currency E A 
TAXAMTH2 89 BCD*10.3 Tax Amount 2 Functional Currency E A 
TAXAMTH3 90 BCD*10.3 Tax Amount 3 Functional Currency E A 
TAXAMTH4 91 BCD*10.3 Tax Amount 4 Functional Currency E A 
TAXAMTH5 92 BCD*10.3 Tax Amount 5 Functional Currency E A 
TRANSREF 93 Long Transaction Reference E A 
TAMTRETSR 94 BCD*10.3 Retainage Amount (Source) E A 
TAMTRETHM 95 BCD*10.3 Retainage Amount (Functional) E A 
RETDUEDT 96 Date Retainage Due Date E A 
ORIGDOC 97 String*24 Original Document Number E A 
OVERHD 98 Integer Overhead Type E A 
OHEADRATE 99 BCD*10.6 Overhead Rate E A 
HEADPER 100 BCD*5.5 Overhead Percentage E A 
LABOR 101 Integer Labor Type E A 
LABORRATE 102 BCD*10.6 Labor Rate E A 
LABORPER 103 BCD*5.5 Labor Percentage E A 
ORIGAPP 104 String*2 Original Application E A 
VALUES 105 Long Optional Fields E A C 
DRILLSRCTY 106 Integer Drill Down Type E A 
DRILLDWNLK 107 BCD*10.0 Drill Down Link E A 
DRILLAPP 108 String*2 Drill Down Application E A 
EXPTAXSR 109 BCD*10.3 Expensed Tax (source) E A 
EXPTAXHM 110 BCD*10.3 Expensed Tax (functional) E A 
TXEXPCOMSR 111 BCD*10.3 Tax (exp) Committed (source) E A 
TXEXPCOMHM 112 BCD*10.3 Tax (exp) Committed (func) E A 
TXALLCOMSR 113 BCD*10.3 Tax (all) Committed (source) E A 
TXALLCOMHM 114 BCD*10.3 Tax (all) Committed (func) E A 
PROJSTAT 115 Integer ^2 Status E A  List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
STAGE 116 Integer Stage E A  List:2 entries
1 = Starting
2 = Ending
DATEBUS 117 Date Posting Date E A 

This page was generated on 2023-Aug-31

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