View: Adjustment G/L Distributions

RotoID: AP0034
Table: APTCU
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:APTCU

Compositions: 1

RotoID Tables Title DLL
AP0033 APTCP Applied Payments APTCP

Keys: 1

Title Fields
Batch Adjustment Primary Key BATCHTYPE, CNTBTCH, CNTRMIT, CNTLINE, CNTSEQ

Fields: 49

Field Index Type Title Attributes Presentation
BATCHTYPE 1 String*2 Batch Type E A K R  Mask: %-2N
CNTBTCH 2 BCD*5.0 Batch Number E A K R 
CNTRMIT 3 BCD*4.0 Entry Number E A K R 
CNTLINE 4 BCD*3.0 Line Number E A K R 
CNTSEQ 5 BCD*3.0 Sequence No. E A K R 
CODTRXTYPE 6 Integer Transaction Type E A 
AMTDIST 7 BCD*10.3 Distribution Amount E A 
IDDISTCODE 8 String*6 Distribution Code E A  Mask: %-6N
IDACCT 9 String*45 Distribution G/L Account E A  Mask: %-45C
CONTRACT 10 String*16 Contract Code E A  Mask: %-16C
PROJECT 11 String*16 Project Code E A  Mask: %-16N
CATEGORY 12 String*16 Category Code E A  Mask: %-16N
RESOURCE 13 String*24 Project/Category Resource E A P  Mask: %-16N
TRANSNBR 14 Long Transaction Number E A C 
COSTCLASS 15 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 16 Integer Billing Type E A P  List:1 entries
0 =
AMTDISC 17 BCD*10.3 Discount Taken E A 
AMTPAYM 18 BCD*10.3 Applied Amount E A 
IDITEM 19 String*16 Item Number E A  Mask: %-16C
UNITMEAS 20 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 21 BCD*10.5 Quantity E A 
AMTCOST 22 BCD*10.6 Cost E A 
BILLDATE 23 Date Billing Date E A 
BILLRATE 24 BCD*10.6 Billing Rate E A 
BILLCURN 25 String*3 Billing Currency E A C  Mask: %-3N
RTGAMT 26 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 27 Date Retainage Due Date E A 
SWRTG 28 Integer Has Retainage E A C  List:2 entries
0 = No
1 = Yes
AMTDISTHC 29 BCD*10.3 Func. Distribution Amount E A C 
AMTDISCHC 30 BCD*10.3 Func. Discount Amount E A C 
AMTPAYMHC 31 BCD*10.3 Func. Applied Amount E A C 
RTGAMTHC 32 BCD*10.3 Func. Retainage Amount E A C 
TEXTDESC 33 String*60 Description E A 
TEXTREF 34 String*60 Reference E A 
DOCLINE 35 BCD*3.0 Apply Line Number E A 
AMTDUETC 36 BCD*10.3 Current Balance E A C 
AMTWHD1TC 37 BCD*10.3 Vend. Tax Withheld Amount 1 E A 
AMTWHD2TC 38 BCD*10.3 Vend. Tax Withheld Amount 2 E A 
AMTWHD3TC 39 BCD*10.3 Vend. Tax Withheld Amount 3 E A 
AMTWHD4TC 40 BCD*10.3 Vend. Tax Withheld Amount 4 E A 
AMTWHD5TC 41 BCD*10.3 Vend. Tax Withheld Amount 5 E A 
AMTWHD1HC 42 BCD*10.3 Func. Tax Withheld Amount 1 E A C 
AMTWHD2HC 43 BCD*10.3 Func. Tax Withheld Amount 2 E A C 
AMTWHD3HC 44 BCD*10.3 Func. Tax Withheld Amount 3 E A C 
AMTWHD4HC 45 BCD*10.3 Func. Tax Withheld Amount 4 E A C 
AMTWHD5HC 46 BCD*10.3 Func. Tax Withheld Amount 5 E A C 
AMTWHDTOT 47 BCD*10.3 Tax Withheld E A C 
PROJSTYLE 48 Integer Project Style E A 
UNFMTCONT 49 String*16 Unformatted Contract Code E A  Mask: %-16C

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