View: Posting Journal Generated AP Details

RotoID: AP0517
Table: APPJAID
Protocol: Flat
DLL:APPJAID

Keys: 1

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

Fields: 61

Field Index Type Title Attributes Presentation
TYPEBTCH 1 String*2 Batch Type E A K R  Mask: %-2N
POSTSEQNCE 2 BCD*5.0 Posting Sequence No. E A K R 
CNTBTCH 3 BCD*5.0 Batch No. E A K R 
CNTITEM 4 BCD*4.0 Entry No. E A K R 
CNTSEQENCE 5 Long Sequence No. E A K R 
GENTYPE 6 Integer Generation Type E A K R  List:1 entries
1 = AI to AP
COMPID 7 String*6 Generated Company E A  Mask: %-6N
GCNTBTCH 8 BCD*5.0 Generated Batch No. E A 
GCNTITEM 9 BCD*4.0 Generated Entry No. E A 
GCNTLINE 10 BCD*3.0 Generated Line No. E A 
CONTRACT 11 String*16 Contract Code E A  Mask: %-16C
PROJECT 12 String*16 Project Code E A  Mask: %-16N
CATEGORY 13 String*16 Category Code E A  Mask: %-16N
COSTCLASS 14 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 15 String*24 Project/Category Resource E A  Mask: %-16N
BILLDATE 16 Date Billing Date E A 
BILLTYPE 17 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLCURN 18 String*3 Billing Currency E A  Mask: %-3N
BILLRATE 19 BCD*10.6 Billing Rate E A 
IDITEM 20 String*16 Item Number E A  Mask: %-16C
AMTCOST 21 BCD*10.6 Cost E A 
QTYINVC 22 BCD*10.5 Quantity E A 
UNITMEAS 23 String*10 Unit of Measure E A  Mask: %-10C
IDDIST 24 String*6 Distribution Code E A  Mask: %-6N
TEXTDESC 25 String*60 Description E A 
IDGLACCT 26 String*45 G/L Account E A  Mask: %-45C
AMTDIST 27 BCD*10.3 Distributed Amount E A 
AMTDISTNET 28 BCD*10.3 Distributed Amount Before Taxes E A 
AMTINCLTAX 29 BCD*10.3 Tax Amount Included in Price E A 
AMTTOTTAX 30 BCD*10.3 Total Tax Amount E A 
AMTTAXTOBE 31 BCD*10.3 Tax Amount to be Allocated E A 
TAXCLASS1 50 Integer Tax Class 1 E A 
TAXCLASS2 51 Integer Tax Class 2 E A 
TAXCLASS3 52 Integer Tax Class 3 E A 
TAXCLASS4 53 Integer Tax Class 4 E A 
TAXCLASS5 54 Integer Tax Class 5 E A 
SWTAXINCL1 55 Integer Tax Inclusive 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 56 Integer Tax Inclusive 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 57 Integer Tax Inclusive 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 58 Integer Tax Inclusive 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 59 Integer Tax Inclusive 5 E A  List:2 entries
0 = No
1 = Yes
RATETAX1 60 BCD*8.5 Tax Rate 1 E A 
RATETAX2 61 BCD*8.5 Tax Rate 2 E A 
RATETAX3 62 BCD*8.5 Tax Rate 3 E A 
RATETAX4 63 BCD*8.5 Tax Rate 4 E A 
RATETAX5 64 BCD*8.5 Tax Rate 5 E A 
AMTTAXREC1 65 BCD*10.3 Recoverable Tax Amount 1 E A 
AMTTAXREC2 66 BCD*10.3 Recoverable Tax Amount 2 E A 
AMTTAXREC3 67 BCD*10.3 Recoverable Tax Amount 3 E A 
AMTTAXREC4 68 BCD*10.3 Recoverable Tax Amount 4 E A 
AMTTAXREC5 69 BCD*10.3 Recoverable Tax Amount 5 E A 
AMTTAXEXP1 70 BCD*10.3 Expense Sep. Tax Amount 1 E A 
AMTTAXEXP2 71 BCD*10.3 Expense Sep. Tax Amount 2 E A 
AMTTAXEXP3 72 BCD*10.3 Expense Sep. Tax Amount 3 E A 
AMTTAXEXP4 73 BCD*10.3 Expense Sep. Tax Amount 4 E A 
AMTTAXEXP5 74 BCD*10.3 Expense Sep. Tax Amount 5 E A 
AMTTAX1 75 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 76 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 77 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 78 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 79 BCD*10.3 Tax Amount 5 E A 

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