# Table: Posting Journal Entries

Table: ARPJH
View: AR0408
Record length: 604
Flags: A R

## Keys: 1

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

## Fields: 70

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. |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
IDCUST | String*12 | Customer No. | Mask: %-12C
IDINVC | String*22 | Document No. | Mask: %-22C
CNTPAYM | BCD*3.0 | Payment No. |
TRANSTYPE | Integer | Document Type | List: 10 entries
1 | = | Invoice
2 | = | Debit Note
3 | = | Credit Note
4 | = | Interest
5 | = | Unapplied Cash
10 | = | Prepayment
11 | = | Receipt
14 | = | Adjustment
16 | = | Exchange Gain/Loss
19 | = | Refund
TRXTYPE | Integer | Transaction Type | List: 30 entries
11 | = | Invoice - Item Issued
12 | = | Invoice - Summary Entered
13 | = | Invoice - Recurring Charge
14 | = | Invoice - Summary Issued
15 | = | Invoice - Item Entered
21 | = | Debit Note - Item Issued
22 | = | Debit Note - Summary Entered
24 | = | Debit Note - Summary Issued
25 | = | Debit Note - Item Entered
31 | = | Credit Note - Item Issued
32 | = | Credit Note - Summary Entered
34 | = | Credit Note - Summary Issued
35 | = | Credit Note - Item Entered
40 | = | Interest Charge
81 | = | Adjustment - Posted
80 | = | Write-Off - Posted
2 | = | Unapplied Cash - Posted
57 | = | Prepayment - Posted
3 | = | Unapplied Cash - Applied
58 | = | Prepayment - Applied
43 | = | Credit Note Applied To
44 | = | Applied Credit Note
51 | = | Receipt - Posted
52 | = | Receipt - Applied
53 | = | Receipt - Reversed
69 | = | Unrealized Exchange Gain/Loss
73 | = | Refund - Posted
75 | = | Refund - Reversed
65 | = | Exchange Gain/Loss - Posted
85 | = | Receipt - Invoice Reversed
IDGRP | String*6 | Group Code | Mask: %-6N
IDACCTSET | String*6 | Account Set | Mask: %-6N
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
CODETERM | String*6 | Terms Code | Mask: %-6N
IDBILLCYC | String*6 | Billing Cycle | Mask: %-6N
IDCUSTSHP | String*6 | Ship-To Location Code | Mask: %-6C
DATEINVC | Date | Document Date |
DATEDISC | Date | Discount Date |
DATEDUE | Date | Due Date |
DATEBTCH | Date | Batch Date |
PCTDISC | BCD*5.5 | Discount Percentage |
SWNONRCVBL | Integer | Misc. Receipt Flag |
GLBATCH | String*6 | G/L Batch No. |
GLENTRY | String*5 | G/L Entry No. |
CNTADJNBR | BCD*5.0 | Adjustment Number |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
IDINVCAPPL | String*22 | Apply-To Doc. No. | Mask: %-22C
DESC | String*60 | Description |
IDBANK | String*8 | Bank Code | Mask: %-8N
IDRMIT | String*24 | Check/Receipt No. | Mask: %-24C
DATEDEPST | Date | Deposit Date |
DEPSTNBR | BCD*5.0 | Deposit Number |
CODECURNTC | String*3 | Currency Code (Source) | Mask: %-3N
RATETYPETC | String*2 | Rate Type (Source->Functional) | Mask: %-2N
RATEDATETC | Date | Rate Date (Source->Functional) |
RATEEXCHTC | BCD*8.7 | Exchange Rate (Source->Functional) |
RATEOPTC | Integer | Rate Operator (Source->Functional) |
SWRATETC | Integer | Rate Override (Source) |
CODECURNBC | String*3 | Currency Code (Bank) | Mask: %-3N
RATETYPEBC | String*2 | Rate Type (Bank->Functional) | Mask: %-2N
RATEDATEBC | Date | Rate Date (Bank->Functional) |
RATEEXCHBC | BCD*8.7 | Exchange Rate (Bank->Functional) |
RATEOPBC | Integer | Rate Operator (Bank->Functional) |
SWRATEBC | Integer | Rate Override (Bank) |
AMTINVCTC | BCD*10.3 | Document Total Less Retainage (Source) |
SWJOB | Integer | Job Related |
SWRTG | Integer | Retainage Invoice Flag | List: 2 entries
0 | = | No
1 | = | Yes
RTGTERMS | String*6 | Retainage Terms Code | Mask: %-6N
RTGDATEDUE | Date | Date Retainage Due |
SWRTGRATE | Integer | Retainage Exchange Rate |
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
RTGAMTTC | BCD*10.3 | Retainage Amount (Source) |
RTGAMTHC | BCD*10.3 | Retainage Amount (Functional) |
VALUES | Long | Optional Fields |
NAMERMIT | String*60 | Name on Check |
AMTTC | BCD*10.3 | Customer Amount |
AMTHC | BCD*10.3 | Functional Amount |
AMTBC | BCD*10.3 | Bank Amount |
DEPSEQ | Long | Deposit Serial Number |
DEPLINE | Long | Deposit Line Number |
PAYMCODE | String*12 | Payment Code | Mask: %-12N
PAYMTYPE | Integer | Payment Type | List: 5 entries
0 | = | (None)
1 | = | Cash
2 | = | Check
3 | = | Credit Card
4 | = | Other
CCTYPE | String*12 | C.C. Type | Mask: %-12N
TEXTREF | String*60 | Reference |
DATEBUS | Date | Posting Date |
REVINVC | Integer | Reverse Invoice |

This page was generated on 2008-May-01

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