View: Posting Journal Generated AP Entries

RotoID: AP0516
Table: APPJAIH
Protocol: Flat
DLL:APPJAIH

Keys: 1

Title Fields
Posted Entry/Generated AP Entry TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM

Fields: 73

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 
COMPID 5 String*6 Generated Company E A  Mask: %-6N
GCNTBTCH 6 BCD*5.0 Generated Batch No. E A 
GCNTITEM 7 BCD*4.0 Generated Entry No. E A 
TEXTTRX 8 Integer Document Type E A  List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
IDTRX 9 Integer Transaction Type E A  List:5 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
32 = Credit Note - Summary Entered
40 = Interest Charge
INVCDESC 10 String*60 Invoice Description E A 
IDVEND 11 String*12 Vendor Number E A  Mask: %-12C
CODEVNDGRP 12 String*6 Vendor Group Code E A  Mask: %-6N
IDACCTSET 13 String*6 Account Set E A  Mask: %-6N
IDRMITTO 14 String*6 Remit-To Location E A  Mask: %-6N
IDINVC 15 String*22 Document Number E A  Mask: %-22C
INVCAPPLTO 16 String*22 Apply-to Document E A  Mask: %-22C
ORDRNBR 17 String*22 Order Number E A  Mask: %-22C
PONBR 18 String*22 PO Number E A  Mask: %-22C
SWJOB 19 Integer Job Related E A  List:2 entries
0 = No
1 = Yes
DATEINVC 20 Date Invoice Date E A 
FISCYR 21 String*4 Fiscal Year E A  Mask: %04D
FISCPER 22 String*2 Fiscal Period E A  Mask: %02D
HCODECURN 23 String*3 Currency Code (Functional) E A  Mask: %-3N
CODECURN 24 String*3 Currency Code (Source) E A  Mask: %-3N
RATETYPE 25 String*2 Rate Type E A  Mask: %-2N
CODEOPER 26 Integer Rate Operator E A  List:2 entries
1 = Multiply
2 = Divide
EXCHRATEHC 27 BCD*8.7 Exchange Rate E A 
DATERATE 28 Date Rate Date E A 
TERMCODE 29 String*6 Terms E A  Mask: %-6N
DATEDUE 30 Date Due Date E A 
DATEDISC 31 Date Discount Date E A 
PCTDISC 32 BCD*5.5 Discount Percentage E A 
AMTDSCBASE 33 BCD*10.3 Discount Base E A 
AMTDISCAVL 34 BCD*10.3 Discount Amount Available E A 
AMTDSBWTAX 35 BCD*10.3 Discount Base With Tax E A 
AMTDSBNTAX 36 BCD*10.3 Discount Base Without Tax E A 
CODETAXGRP 37 String*12 Tax Group E A  Mask: %-12N
SWTAXBL 38 Integer Taxable E A  List:2 entries
0 = No
1 = Yes
SWCALCTX 39 Integer Tax Amount Control E A  List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
AMTINVCTOT 40 BCD*10.3 Document Total Before Taxes E A 
AMTGROSTOT 41 BCD*10.3 Document Total Including Tax E A 
AMTTAXTOT 42 BCD*10.3 Total Tax Amount E A 
AMTRECTAX 43 BCD*10.3 Recoverable Taxes E A 
AMTEXPTAX 44 BCD*10.3 Expensed Separately Taxes E A 
AMTAXTOBE 45 BCD*10.3 Tax Amount to be Allocated E A 
ID1099CLAS 46 String*6 1099/CPRS Code E A  Mask: %-6N
AMT1099 47 BCD*10.3 1099/CPRS Amount E A 
IDDISTSET 48 String*6 Distribution Set E A  Mask: %-6N
AMTDISTSET 49 BCD*10.3 Distribution Set Amount E A 
VALUES 50 Long Optional Fields E A 
DATEBUS 51 Date Posting Date E A 
CODETAX1 70 String*12 Tax Authority 1 E A 
CODETAX2 71 String*12 Tax Authority 2 E A 
CODETAX3 72 String*12 Tax Authority 3 E A 
CODETAX4 73 String*12 Tax Authority 4 E A 
CODETAX5 74 String*12 Tax Authority 5 E A 
TAXCLASS1 75 Integer Tax Class 1 E A 
TAXCLASS2 76 Integer Tax Class 2 E A 
TAXCLASS3 77 Integer Tax Class 3 E A 
TAXCLASS4 78 Integer Tax Class 4 E A 
TAXCLASS5 79 Integer Tax Class 5 E A 
SWTAXINCL1 80 Integer Tax Inclusive 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 81 Integer Tax Inclusive 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 82 Integer Tax Inclusive 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 83 Integer Tax Inclusive 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 84 Integer Tax Inclusive 5 E A  List:2 entries
0 = No
1 = Yes
AMTTAX1 85 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 86 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 87 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 88 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 89 BCD*10.3 Tax Amount 5 E A 
VENDNAME 100 String*60 Vendor Name E A 
RMITNAME 101 String*60 Remit-To Name 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).