View: Adjustment G/L Distributions

RotoID: AR0045
Table: ARTCU
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:ARTCU

Compositions: 1

RotoID Tables Title DLL
AR0044 ARTCP Applied Receipts/Adjustments ARTCP

Keys: 1

Title Fields
Adjustment Seq. Number CODEPAYM, CNTBTCH, CNTITEM, CNTLINE, CNTSEQ

Fields: 44

Field Index Type Title Attributes Presentation
CODEPAYM 1 String*2 Batch Type E A K R  Mask: %-2N
CNTBTCH 2 BCD*5.0 Batch Number E A K R 
CNTITEM 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 C  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
AMTDISC 16 BCD*10.3 Discount Amount E A 
AMTPAYM 17 BCD*10.3 Applied Amount E A 
IDITEM 18 String*16 Item Number E A  Mask: %-16C
UNITMEAS 19 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 20 BCD*10.5 Quantity E A 
AMTCOST 21 BCD*10.6 Cost E A 
BILLDATE 22 Date Billing Date E A 
RTGAMT 23 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 24 Date Retainage Due Date E A 
SWRTG 25 Integer Has Retainage E A C  List:2 entries
0 = No
1 = Yes
AMTDISTHC 26 BCD*10.3 Func. Distribution Amount E A C 
AMTDISCHC 27 BCD*10.3 Func. Discount Amount E A C 
AMTPAYMHC 28 BCD*10.3 Func. Applied Amount E A C 
RTGAMTHC 29 BCD*10.3 Func. Retainage Amount E A C 
TEXTDESC 30 String*60 Description E A 
TEXTREF 31 String*60 Reference E A 
DOCLINE 32 BCD*3.0 Document Line Number E A 
AMTDUETC 33 BCD*10.3 Cust. Currency Amount Due E A C 
AMTWHD1TC 34 BCD*10.3 Cust. Tax Withheld Amount 1 E A 
AMTWHD2TC 35 BCD*10.3 Cust. Tax Withheld Amount 2 E A 
AMTWHD3TC 36 BCD*10.3 Cust. Tax Withheld Amount 3 E A 
AMTWHD4TC 37 BCD*10.3 Cust. Tax Withheld Amount 4 E A 
AMTWHD5TC 38 BCD*10.3 Cust. Tax Withheld Amount 5 E A 
AMTWHD1HC 39 BCD*10.3 Func. Tax Withheld Amount 1 E A C 
AMTWHD2HC 40 BCD*10.3 Func. Tax Withheld Amount 2 E A C 
AMTWHD3HC 41 BCD*10.3 Func. Tax Withheld Amount 3 E A C 
AMTWHD4HC 42 BCD*10.3 Func. Tax Withheld Amount 4 E A C 
AMTWHD5HC 43 BCD*10.3 Func. Tax Withheld Amount 5 E A C 
AMTWHDTOT 44 BCD*10.3 Tax Withheld Amount Total E A C 

This page was generated on 2023-Aug-31

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