Table: A/P Superview

Table: PMAP
View: PM0302
Record Length: 1433

Flags: A R 

Keys: 1

Title Flags Fields
CNTBTCH

Fields: 121

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
VENDORID String*12 Vendor Number
CCY String*3 Transaction Currency
RATETYPE String*2 Rate Type
RATEDATE Date Rate Date
RATEOP Integer Rate Operator
RATEOVER Boolean Rate Override List:2 entries
0 = False
1 = True
RATE BCD*8.7 Exchange Rate
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 Transaction 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
PROJECT String*16 ^2
CATEGORY String*16 ^3
RESOURCE String*24 Resource
ARITEM String*16 A/R Item Number
ARUOM String*10 Unit of Measure
REFERENCE String*60 Reference
DESC String*60 Description
QUANTITY BCD*10.5 Quantity
UNITCOST BCD*10.6 Unit Cost
BILLRATE BCD*10.6 Billing Rate
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
RTAXAMTSR BCD*10.3 Recoverable Tax
RTAXAMTHM BCD*10.3 Recoverable Tax
TAMTSR BCD*10.3 Total Amount (inc tax)
TAMTHM BCD*10.3 Total Amount (inc tax)
PAYAMTSR BCD*10.3 Amount Paid
PAYAMTHM BCD*10.3 Amount Paid
REFDOC String*22 Reference Document
WIPACCT String*45 Work in Progress Account
COSTACCT String*45 Cost Account
OHACCT String*45 Overhead Account
OHSR BCD*10.3 Overhead Amount
OHHM BCD*10.3 Overhead Amount
LABACCT String*45 Labor Account
LABORSR BCD*10.3 Labor Amount
LABORHM BCD*10.3 Labor Amount
BILLTYPE Integer Billing Type
COMMENTS String*250 Comments
TAUTH1 String*12 Tax Authority 1
TAUTH2 String*12 Tax Authority 2
TAUTH3 String*12 Tax Authority 3
TAUTH4 String*12 Tax Authority 4
TAUTH5 String*12 Tax Authority 5
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
TRANSREF Long Transaction Reference
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
OVERHD Integer Overhead Type
OHEADRATE BCD*10.6 Overhead Rate
HEADPER BCD*5.5 Overhead Percentage
LABOR Integer Labor Type
LABORRATE BCD*10.6 Labor Rate
LABORPER BCD*5.5 Labor Percentage
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
EXPTAXSR BCD*10.3 Expensed Tax (source)
EXPTAXHM BCD*10.3 Expensed Tax (functional)
TXEXPCOMSR BCD*10.3 Tax (exp) Committed (source)
TXEXPCOMHM BCD*10.3 Tax (exp) Committed (func)
TXALLCOMSR BCD*10.3 Tax (all) Committed (source)
TXALLCOMHM BCD*10.3 Tax (all) Committed (func)
PROJSTAT Integer ^2 Status List:7 entries
10 = Estimate
20 = Approved
30 = Open
40 = On Hold
70 = Inactive
60 = Completed
50 = Closed
STAGE Integer Stage List:2 entries
1 = Starting
2 = Ending
DATEBUS Date Posting Date

This page was generated on 2022-Aug-18

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