# View: Posting Journal Entries

RotoID: AP0511
Table: APPJH
Protocol: Flat
DLL: APPJH

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Batch Type/Post. Seq./Batch/Entr | TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM

## Fields: 65

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 |
IDVEND | 5 | String*12 | Vendor No. | E A | Mask: %-12C
IDINVC | 6 | String*22 | Document No. | E A | Mask: %-22C
CNTPAYM | 7 | BCD*3.0 | Payment No. | E A |
TRANSTYPE | 8 | Integer | Document Type | E A | List: 8 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
10 | = | Prepayment
11 | = | Payment
14 | = | Adjustment
16 | = | Exchange Gain/Loss
TRXTYPE | 9 | Integer | Transaction Type | E A | List: 16 entries
12 | = | Invoice - Summary Entered
13 | = | Invoice - Recurring Charge
22 | = | Debit Note - Summary Entered
32 | = | Credit Note - Summary Entered
40 | = | Interest Charge
81 | = | Adjustment - Posted
57 | = | Prepayment - Posted
58 | = | Prepayment - Applied
43 | = | Credit Note Applied To
44 | = | Applied Credit Note
51 | = | Payment - Posted
52 | = | Payment - Applied
53 | = | Payment - Reversed
69 | = | Unrealized Exchange Gain/Loss
65 | = | Exchange Gain/Loss - Posted
94 | = | Payment - Invoice Reversed
IDGRP | 10 | String*6 | Group Code | E A | Mask: %-6N
IDACCTSET | 11 | String*6 | Account Set | E A | Mask: %-6N
CODETAXGRP | 12 | String*12 | Tax Group | E A | Mask: %-12N
CODETERM | 13 | String*6 | Terms Code | E A | Mask: %-6N
IDRMITTO | 14 | String*6 | Remit-To Location Code | E A | Mask: %-6N
DATEINVC | 15 | Date | Document Date | E A |
DATEDISC | 16 | Date | Discount Date | E A |
DATEDUE | 17 | Date | Due Date | E A |
DATEBTCH | 18 | Date | Batch Date | E A |
PCTDISC | 19 | BCD*5.5 | Discount Percentage | E A |
SWNONRCVBL | 20 | Integer | Misc. Payment Flag | E A |
SWSTATUS | 21 | Integer | Payment Edited Flag | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLBATCH | 22 | String*6 | G/L Batch No. | E A |
GLENTRY | 23 | String*5 | G/L Entry No. | E A |
CNTADJNBR | 24 | BCD*5.0 | Adjustment Number | E A |
FISCYR | 25 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 26 | String*2 | Fiscal Period | E A | Mask: %02D
IDINVCAPPL | 27 | String*22 | Apply-To Doc. No. | E A | Mask: %-22C
DESC | 28 | String*60 | Description | E A |
IDBANK | 29 | String*8 | Bank Code | E A | Mask: %-8N
IDRMIT | 30 | String*12 | Check/Receipt No. | E A | Mask: %-12D
LONGSERIAL | 31 | Long | Serial Number | E A |
MISCRMITTO | 32 | String*60 | Misc. Payment Remit-To | E A |
CODECURNTC | 33 | String*3 | Currency Code (Source) | E A | Mask: %-3N
RATETYPETC | 34 | String*2 | Rate Type (Source->Functional) | E A | Mask: %-2N
RATEDATETC | 35 | Date | Rate Date (Source->Functional) | E A |
RATEEXCHTC | 36 | BCD*8.7 | Exchange Rate (Source->Functional) | E A |
RATEOPTC | 37 | Integer | Rate Operator (Source->Functional) | E A |
SWRATETC | 38 | Integer | Rate Override (Source) | E A |
CODECURNBC | 39 | String*3 | Currency Code (Bank) | E A | Mask: %-3N
RATETYPEBC | 40 | String*2 | Rate Type (Bank->Functional) | E A | Mask: %-2N
RATEDATEBC | 41 | Date | Rate Date (Bank->Functional) | E A |
RATEEXCHBC | 42 | BCD*8.7 | Exchange Rate (Bank->Functional) | E A |
RATEOPBC | 43 | Integer | Rate Operator (Bank->Functional) | E A |
SWRATEBC | 44 | Integer | Rate Override (Bank) | E A |
AMTINVCTC | 45 | BCD*10.3 | Document Total Less Retainage (Source) | E A |
SWJOB | 46 | Integer | Job Related | E A |
SWRTG | 47 | Integer | Retainage Invoice Flag | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGTERMS | 48 | String*6 | Retainage Terms Code | E A | Mask: %-6N
RTGDATEDUE | 49 | Date | Date Retainage Due | E A |
SWRTGRATE | 50 | Integer | Retainage Exchange Rate | E A |
RTGAPPLYTO | 51 | String*22 | Original Doc. No. | E A | Mask: %-22C
RTGAMTTC | 52 | BCD*10.3 | Retainage Amount (Source) | E A |
RTGAMTHC | 53 | BCD*10.3 | Retainage Amount (Functional) | E A |
VALUES | 54 | Long | Optional Fields | E A |
ORIGCOMP | 55 | String*6 | Originator | E A | Mask: %-6N
IDDISTSET | 56 | String*6 | Distribution Set | E A | Mask: %-6N
AMTTC | 57 | BCD*10.3 | Check Amount Vend. Curr. | E A |
AMTHC | 58 | BCD*10.3 | Check Amount Func. Curr. | E A |
AMTBC | 59 | BCD*10.3 | Payment Amount | E A |
PAYMCODE | 60 | String*12 | Payment Code | E A | Mask: %-12N
PAYMTYPE | 61 | Integer | Payment Type | E A C | List: 5 entries
0 | = |
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | 62 | String*12 | C.C. Type | E A | Mask: %-12N
TEXTREF | 63 | String*60 | Reference | E A |
DATEBUS | 64 | Date | Posting Date | E A |
REVINVC | 65 | Integer | Reverse Invoice | E A |

This page was generated on 2009-Nov-19

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