Table: A/R Superview

Table: PMAR
View: PM0301
Record Length: 1445

Flags: A R 

Keys: 1

Title Flags Fields
CNTBTCH

Fields: 123

Field Type Title Presentation
CNTBTCH BCD*5.0 Batch Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CNTENT BCD*4.0 Batch Entry Number
CNTLINE BCD*3.0 Batch Line Number
TRANSDATE Date Transaction Date
DTEBTCH Date Batch Date
DOCDATE Date Entry Date
POSTSEQ Long Posting Sequence
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
DOCNUM String*22 Document Number
IDCUST String*12 Customer Number Mask: %-12C
CCY String*3 Transaction Currency Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
RATEDATE Date Rate Date
RATEOP Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
RATEOVER Boolean Rate Override List:2 entries
0 = False
1 = True
RATE BCD*8.7 Exchange Rate
CSTREV Integer Cost/Revenue List:2 entries
1 = Cost
2 = Revenue
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 Transactions Type 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 Long Transaction Number
CONTRACT String*16 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 Mask: %-16N
RESOURCE String*24 Resource Mask: %-24C
ARITEM String*16 A/R Item Number Mask: %-16C
ARUOM String*10 Unit of Measure
REFERENCE String*60 Reference
DESC String*60 Description
QUANTITY BCD*10.5 Quantity
UNITRATE BCD*10.6 Unit Price/Unit Cost
EXTAMTSR BCD*10.3 Extended Amount
EXTAMTHM BCD*10.3 Extended Amount
TOTAMTSR BCD*10.3 Total Amount (ex tax)
TOTAMTHM BCD*10.3 Total Amount (ex tax)
TAXAMTSR BCD*10.3 Tax Amount
TAXAMTHM BCD*10.3 Tax Amount
TAMTSR BCD*10.3 Total Amount (inc tax)
TAMTHM BCD*10.3 Total Amount (inc tax)
RCPAMTSR BCD*10.3 Amount Received
RCPAMTHM BCD*10.3 Amount Received
REFDOC String*22 Reference Document
WIPACCT String*45 Work in Progress Account Mask: %-45C
REVACCT String*45 Billings/Sales Account Mask: %-45C
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 Customer/Vendor Tax Class 1
TCLASS2 Integer Customer/Vendor Tax Class 2
TCLASS3 Integer Customer/Vendor Tax Class 3
TCLASS4 Integer Customer/Vendor Tax Class 4
TCLASS5 Integer Customer/Vendor Tax Class 5
TITMCLSS1 Integer Item Tax Class 1
TITMCLSS2 Integer Item Tax Class 2
TITMCLSS3 Integer Item Tax Class 3
TITMCLSS4 Integer Item Tax Class 4
TITMCLSS5 Integer Item Tax Class 5
TINCLUDE1 Integer Tax Included 1
TINCLUDE2 Integer Tax Included 2
TINCLUDE3 Integer Tax Included 3
TINCLUDE4 Integer Tax Included 4
TINCLUDE5 Integer Tax Included 5
TAXBASES1 BCD*10.3 Tax Base 1 Source Currency
TAXBASES2 BCD*10.3 Tax Base 2 Source Currency
TAXBASES3 BCD*10.3 Tax Base 3 Source Currency
TAXBASES4 BCD*10.3 Tax Base 4 Source Currency
TAXBASES5 BCD*10.3 Tax Base 5 Source Currency
TAXBASEH1 BCD*10.3 Tax Base 1 Functional Currency
TAXBASEH2 BCD*10.3 Tax Base 2 Functional Currency
TAXBASEH3 BCD*10.3 Tax Base 3 Functional Currency
TAXBASEH4 BCD*10.3 Tax Base 4 Functional Currency
TAXBASEH5 BCD*10.3 Tax Base 5 Functional Currency
TAXAMTS1 BCD*10.3 Tax Amount 1 Source Currency
TAXAMTS2 BCD*10.3 Tax Amount 2 Source Currency
TAXAMTS3 BCD*10.3 Tax Amount 3 Source Currency
TAXAMTS4 BCD*10.3 Tax Amount 4 Source Currency
TAXAMTS5 BCD*10.3 Tax Amount 5 Source Currency
TAXAMTH1 BCD*10.3 Tax Amount 1 Functional Currency
TAXAMTH2 BCD*10.3 Tax Amount 2 Functional Currency
TAXAMTH3 BCD*10.3 Tax Amount 3 Functional Currency
TAXAMTH4 BCD*10.3 Tax Amount 4 Functional Currency
TAXAMTH5 BCD*10.3 Tax Amount 5 Functional Currency
RTAXSR BCD*10.3 Recoverable Tax Amount
RTAXHM BCD*10.3 Recoverable Tax Amount
TRANSREF Long Transaction Reference
COMMENTS String*250 Comments
TAMTRETSR BCD*10.3 Retainage Amount (Source)
TAMTRETHM BCD*10.3 Retainage Amount (Functional)
RETDUEDT Date Retainage Due Date
ORIGDOC String*24 Original Document Number
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
PROJSTAT Integer ^2 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
COSTQTY BCD*10.5 Cost Quantity
UNITCOST BCD*10.6 Not in Use
EXTCOSTSR BCD*10.3 Extended Cost (Source)
EXTCOSTHM BCD*10.3 Extended Cost (Functional)
OHEADACCT String*45 Overhead Account
OHEADSR BCD*10.3 Overhead Amount
OHEADHM BCD*10.3 Overhead Amount
LABACCT String*45 Labor Account
LABSR BCD*10.3 Labor Amount
LABHM BCD*10.3 Labor Amount
OHTYPE Integer Overhead Type List:3 entries
1 = None
2 = Flat Rate Per Unit
5 = Percentage of Cost
OHRATE BCD*10.6 Overhead Rate
OHPER BCD*5.5 Overhead Percentage
LABTYPE Integer Labor Type List:3 entries
1 = None
2 = Flat Rate Per Labor Hour/Unit
3 = Percentage of Labor Cost
LABRATE BCD*10.6 Labor Rate
LABPER BCD*5.5 Labor Percentage
TOTCOSTSR BCD*10.3 Total Cost Amount (Source)
TOTCOSTHM BCD*10.3 Total Cost Amount (Functional)
DETAILTYPE Integer O/E Detail Line Type List:2 entries
0 = Item
1 = Miscellaneous Charges
STAGE Integer Stage List:2 entries
1 = Starting
2 = Ending
DATEBUS Date Posting Date

This page was generated on 2021-Nov-24

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