View: A/R Superview

RotoID: PM0301
Table: PMAR
Protocol: Header
DLL:PMAR

Compositions: 1

RotoID Tables Title DLL
PM0521 PMARO A/R Optional Field PMARO

Keys: 1

Title Fields
CNTBTCH

Fields: 119

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 
IDCUST 11 String*12 Customer Number E A  Mask: %-12C
CCY 12 String*3 Transaction Currency E A  Mask: %-3N
RATETYPE 13 String*2 Rate Type E A  Mask: %-2N
RATEDATE 14 Date Rate Date E A 
RATEOP 15 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 16 Boolean Rate Override E A  List:2 entries
0 = False
1 = True
RATE 17 BCD*8.7 Exchange Rate E A 
CSTREV 18 Integer Cost/Revenue E A  List:2 entries
1 = Cost
2 = Revenue
DOCTYPE 19 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 20 Integer Transactions 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 21 Long Transaction Number E A 
CONTRACT 22 String*16 ^1 E A  Mask: %-16C
PROJECT 23 String*16 ^2 E A  Mask: %-16N
CATEGORY 24 String*16 ^3 E A  Mask: %-16N
RESOURCE 25 String*24 Resource E A  Mask: %-24C
ARITEM 26 String*16 A/R Item Number E A  Mask: %-16C
ARUOM 27 String*10 Unit of Measure E A 
REFERENCE 28 String*60 Reference E A 
DESC 29 String*60 Description E A 
QUANTITY 30 BCD*10.5 Quantity E A 
UNITRATE 31 BCD*10.6 Unit Price/Unit Cost E A 
EXTAMTSR 32 BCD*10.3 Extended Amount E A 
EXTAMTHM 33 BCD*10.3 Extended Amount E A 
TOTAMTSR 34 BCD*10.3 Total Amount (ex tax) E A 
TOTAMTHM 35 BCD*10.3 Total Amount (ex tax) E A 
TAXAMTSR 36 BCD*10.3 Tax Amount E A 
TAXAMTHM 37 BCD*10.3 Tax Amount E A 
TAMTSR 38 BCD*10.3 Total Amount (inc tax) E A 
TAMTHM 39 BCD*10.3 Total Amount (inc tax) E A 
RCPAMTSR 40 BCD*10.3 Amount Received E A 
RCPAMTHM 41 BCD*10.3 Amount Received E A 
REFDOC 42 String*22 Reference Document E A 
WIPACCT 43 String*45 Work in Progress Account E A  Mask: %-45C
REVACCT 44 String*45 Billings/Sales Account E A  Mask: %-45C
TAUTH1 45 String*12 Tax Authority 1 E A  Mask: %-12N
TAUTH2 46 String*12 Tax Authority 2 E A  Mask: %-12N
TAUTH3 47 String*12 Tax Authority 3 E A  Mask: %-12N
TAUTH4 48 String*12 Tax Authority 4 E A  Mask: %-12N
TAUTH5 49 String*12 Tax Authority 5 E A  Mask: %-12N
TCLASS1 50 Integer Customer/Vendor Tax Class 1 E A 
TCLASS2 51 Integer Customer/Vendor Tax Class 2 E A 
TCLASS3 52 Integer Customer/Vendor Tax Class 3 E A 
TCLASS4 53 Integer Customer/Vendor Tax Class 4 E A 
TCLASS5 54 Integer Customer/Vendor Tax Class 5 E A 
TITMCLSS1 55 Integer Item Tax Class 1 E A 
TITMCLSS2 56 Integer Item Tax Class 2 E A 
TITMCLSS3 57 Integer Item Tax Class 3 E A 
TITMCLSS4 58 Integer Item Tax Class 4 E A 
TITMCLSS5 59 Integer Item Tax Class 5 E A 
TINCLUDE1 60 Integer Tax Included 1 E A 
TINCLUDE2 61 Integer Tax Included 2 E A 
TINCLUDE3 62 Integer Tax Included 3 E A 
TINCLUDE4 63 Integer Tax Included 4 E A 
TINCLUDE5 64 Integer Tax Included 5 E A 
TAXBASES1 65 BCD*10.3 Tax Base 1 Source Currency E A 
TAXBASES2 66 BCD*10.3 Tax Base 2 Source Currency E A 
TAXBASES3 67 BCD*10.3 Tax Base 3 Source Currency E A 
TAXBASES4 68 BCD*10.3 Tax Base 4 Source Currency E A 
TAXBASES5 69 BCD*10.3 Tax Base 5 Source Currency E A 
TAXBASEH1 70 BCD*10.3 Tax Base 1 Functional Currency E A 
TAXBASEH2 71 BCD*10.3 Tax Base 2 Functional Currency E A 
TAXBASEH3 72 BCD*10.3 Tax Base 3 Functional Currency E A 
TAXBASEH4 73 BCD*10.3 Tax Base 4 Functional Currency E A 
TAXBASEH5 74 BCD*10.3 Tax Base 5 Functional Currency E A 
TAXAMTS1 75 BCD*10.3 Tax Amount 1 Source Currency E A 
TAXAMTS2 76 BCD*10.3 Tax Amount 2 Source Currency E A 
TAXAMTS3 77 BCD*10.3 Tax Amount 3 Source Currency E A 
TAXAMTS4 78 BCD*10.3 Tax Amount 4 Source Currency E A 
TAXAMTS5 79 BCD*10.3 Tax Amount 5 Source Currency E A 
TAXAMTH1 80 BCD*10.3 Tax Amount 1 Functional Currency E A 
TAXAMTH2 81 BCD*10.3 Tax Amount 2 Functional Currency E A 
TAXAMTH3 82 BCD*10.3 Tax Amount 3 Functional Currency E A 
TAXAMTH4 83 BCD*10.3 Tax Amount 4 Functional Currency E A 
TAXAMTH5 84 BCD*10.3 Tax Amount 5 Functional Currency E A 
RTAXSR 85 BCD*10.3 Recoverable Tax Amount E A 
RTAXHM 86 BCD*10.3 Recoverable Tax Amount E A 
TRANSREF 87 Long Transaction Reference E A 
COMMENTS 88 String*250 Comments E A 
TAMTRETSR 89 BCD*10.3 Retainage Amount (Source) E A 
TAMTRETHM 90 BCD*10.3 Retainage Amount (Functional) E A 
RETDUEDT 91 Date Retainage Due Date E A 
ORIGDOC 92 String*24 Original Document Number E A 
ORIGAPP 93 String*2 Original Application E A 
VALUES 94 Long Optional Fields E A C 
DRILLSRCTY 95 Integer Drill Down Type E A 
DRILLDWNLK 96 BCD*10.0 Drill Down Link E A 
DRILLAPP 97 String*2 Drill Down Application E A 
PROJSTAT 98 Integer ^2 Status E A  List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
COSTQTY 99 BCD*10.5 Cost Quantity E A 
UNITCOST 100 BCD*10.6 Not in Use E A 
EXTCOSTSR 101 BCD*10.3 Extended Cost (Source) E A 
EXTCOSTHM 102 BCD*10.3 Extended Cost (Functional) E A 
OHEADACCT 103 String*45 Overhead Account E A 
OHEADSR 104 BCD*10.3 Overhead Amount E A 
OHEADHM 105 BCD*10.3 Overhead Amount E A 
LABACCT 106 String*45 Labor Account E A 
LABSR 107 BCD*10.3 Labor Amount E A 
LABHM 108 BCD*10.3 Labor Amount E A 
OHTYPE 109 Integer Overhead Type E A  List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHRATE 110 BCD*10.6 Overhead Rate E A 
OHPER 111 BCD*5.5 Overhead Percentage E A 
LABTYPE 112 Integer Labor Type E A  List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABRATE 113 BCD*10.6 Labor Rate E A 
LABPER 114 BCD*5.5 Labor Percentage E A 
TOTCOSTSR 115 BCD*10.3 Total Cost Amount (Source) E A 
TOTCOSTHM 116 BCD*10.3 Total Cost Amount (Functional) E A 
DETAILTYPE 117 Integer O/E Detail Line Type E A  List:2 entries
0 = Item
1 = Miscellaneous Charges
STAGE 118 Integer Stage E A  List:2 entries
1 = Starting
2 = Ending
DATEBUS 119 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).