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  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CATEGORY  String*16  Category  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  Project 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.