# View: Posting Journal Generated AP Entries

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

## Compositions: 0

## 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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.