# View: A/R Superview

RotoID: PM0301
Table: PMAR
DLL: PMAR

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
PM0521 | PMARO | A/R Optional Field | PMARO

## Keys: 1

Title | Fields
--- | ---
| CNTBTCH

## Fields: 97

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 |
DOCTYPE | 19 | Integer | Document Type | E A | 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 | 20 | Integer | Transactions Type | E A | List: 22 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
12 | = | Insert
13 | = | Delete
14 | = | Edit
TRANSNUM | 21 | Long | Transaction Number | E A |
CONTRACT | 22 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 23 | String*16 | Project | E A | Mask: %-16N
CATEGORY | 24 | String*16 | Category | 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 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.