Table: Posting Journal Generated AP Details

Table: APPJAID
View: AP0517
Record Length: 575

Flags: A R 

Keys: 1

Title Flags Fields
Posted Detail/Generated AP Detai TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM, CNTSEQENCE, GENTYPE

Fields: 65

Field Type Title Presentation
TYPEBTCH String*2 Batch Type Mask: %-2N
POSTSEQNCE BCD*5.0 Posting Sequence No.
CNTBTCH BCD*5.0 Batch No.
CNTITEM BCD*4.0 Entry No.
CNTSEQENCE Long Sequence No.
GENTYPE Integer Generation Type List:1 entries
1 = AI to AP
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
COMPID String*6 Generated Company Mask: %-6N
GCNTBTCH BCD*5.0 Generated Batch No.
GCNTITEM BCD*4.0 Generated Entry No.
GCNTLINE BCD*3.0 Generated Line No.
CONTRACT String*16 Contract Code Mask: %-16C
PROJECT String*16 Project Code Mask: %-16N
CATEGORY String*16 Category Code Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE String*24 Project/Category Resource Mask: %-16N
BILLDATE Date Billing Date
BILLTYPE Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLCURN String*3 Billing Currency Mask: %-3N
BILLRATE BCD*10.6 Billing Rate
IDITEM String*16 Item Number Mask: %-16C
AMTCOST BCD*10.6 Cost
QTYINVC BCD*10.5 Quantity
UNITMEAS String*10 Unit of Measure Mask: %-10C
IDDIST String*6 Distribution Code Mask: %-6N
TEXTDESC String*60 Description
IDGLACCT String*45 G/L Account Mask: %-45C
AMTDIST BCD*10.3 Distributed Amount
AMTDISTNET BCD*10.3 Distributed Amount Before Taxes
AMTINCLTAX BCD*10.3 Tax Amount Included in Price
AMTTOTTAX BCD*10.3 Total Tax Amount
AMTTAXTOBE BCD*10.3 Tax Amount to be Allocated
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
SWTAXINCL1 Integer Tax Inclusive 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Inclusive 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Inclusive 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Inclusive 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Inclusive 5 List:2 entries
0 = No
1 = Yes
RATETAX1 BCD*8.5 Tax Rate 1
RATETAX2 BCD*8.5 Tax Rate 2
RATETAX3 BCD*8.5 Tax Rate 3
RATETAX4 BCD*8.5 Tax Rate 4
RATETAX5 BCD*8.5 Tax Rate 5
AMTTAXREC1 BCD*10.3 Recoverable Tax Amount 1
AMTTAXREC2 BCD*10.3 Recoverable Tax Amount 2
AMTTAXREC3 BCD*10.3 Recoverable Tax Amount 3
AMTTAXREC4 BCD*10.3 Recoverable Tax Amount 4
AMTTAXREC5 BCD*10.3 Recoverable Tax Amount 5
AMTTAXEXP1 BCD*10.3 Expense Sep. Tax Amount 1
AMTTAXEXP2 BCD*10.3 Expense Sep. Tax Amount 2
AMTTAXEXP3 BCD*10.3 Expense Sep. Tax Amount 3
AMTTAXEXP4 BCD*10.3 Expense Sep. Tax Amount 4
AMTTAXEXP5 BCD*10.3 Expense Sep. Tax Amount 5
AMTTAX1 BCD*10.3 Tax Amount 1
AMTTAX2 BCD*10.3 Tax Amount 2
AMTTAX3 BCD*10.3 Tax Amount 3
AMTTAX4 BCD*10.3 Tax Amount 4
AMTTAX5 BCD*10.3 Tax Amount 5

This page was generated on 2021-Nov-24

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