Table: Adjustment G/L Distributions

Table: APTCU
View: AP0034
Record Length: 546

Flags: A R 

Keys: 1

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

Fields: 48

Field Type Title Presentation
BATCHTYPE String*2 Batch Type Mask: %-2N
CNTBTCH BCD*5.0 Batch Number
CNTRMIT BCD*4.0 Entry Number
CNTLINE BCD*3.0 Line Number
CNTSEQ BCD*3.0 Sequence No.
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CODTRXTYPE Integer Transaction Type
AMTDIST BCD*10.3 Distribution Amount
IDDISTCODE String*6 Distribution Code Mask: %-6N
IDACCT String*45 Distribution G/L Account Mask: %-45C
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CATEGORY String*16 Category Code Mask: %-16N
RESOURCE String*24 Project/Category Resource Mask: %-16N
TRANSNBR Long Transaction Number
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE Integer Billing Type List:1 entries
0 =
AMTDISC BCD*10.3 Discount Taken
AMTPAYM BCD*10.3 Applied Amount
IDITEM String*16 Item Number Mask: %-16C
UNITMEAS String*10 Unit of Measure Mask: %-10C
QTYINVC BCD*10.5 Quantity
AMTCOST BCD*10.6 Cost
BILLDATE Date Billing Date
BILLRATE BCD*10.6 Billing Rate
BILLCURN String*3 Billing Currency Mask: %-3N
RTGAMT BCD*10.3 Retainage Amount
RTGDATEDUE Date Retainage Due Date
AMTDISTHC BCD*10.3 Func. Distribution Amount
AMTDISCHC BCD*10.3 Func. Discount Amount
AMTPAYMHC BCD*10.3 Func. Applied Amount
RTGAMTHC BCD*10.3 Func. Retainage Amount
TEXTDESC String*60 Description
TEXTREF String*60 Reference
DOCLINE BCD*3.0 Apply Line Number
AMTWHD1TC BCD*10.3 Vend. Tax Withheld Amount 1
AMTWHD2TC BCD*10.3 Vend. Tax Withheld Amount 2
AMTWHD3TC BCD*10.3 Vend. Tax Withheld Amount 3
AMTWHD4TC BCD*10.3 Vend. Tax Withheld Amount 4
AMTWHD5TC BCD*10.3 Vend. Tax Withheld Amount 5
AMTWHD1HC BCD*10.3 Func. Tax Withheld Amount 1
AMTWHD2HC BCD*10.3 Func. Tax Withheld Amount 2
AMTWHD3HC BCD*10.3 Func. Tax Withheld Amount 3
AMTWHD4HC BCD*10.3 Func. Tax Withheld Amount 4
AMTWHD5HC BCD*10.3 Func. Tax Withheld Amount 5

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