# Table: Unposted Entries

Table: ARUNPSTH
View: AR0095
Record length: 546
Flags: A R

## Keys: 14

Title | Flags | Fields
--- | --- | ---
Trans.Type/Batch/Entry |  | SELSEQ, TRANSTYPE, CNTBTCH, CNTITEM
Customer/Trans.Type/Batch/Entry | D M | SELSEQ, IDCUST, IDNATACCT, TRANSTYPE, CNTBTCH, CNTITEM
Trans. Date | D M | SELSEQ, DATETRANS, TRANSTYPE
Customer/Trans. Date | D M | SELSEQ, IDCUST, IDNATACCT, DATETRANS, TRANSTYPE
Order No. | D M | SELSEQ, ORDRNBR, TRANSTYPE
Customer/Order No. | D M | SELSEQ, IDCUST, IDNATACCT, ORDRNBR, TRANSTYPE
PO Number | D M | SELSEQ, CUSTPO, TRANSTYPE
Customer/PO Number | D M | SELSEQ, IDCUST, IDNATACCT, CUSTPO, TRANSTYPE
Shipment No. | D M | SELSEQ, SHIPNBR, TRANSTYPE
Customer/Shipment No. | D M | SELSEQ, IDCUST, IDNATACCT, SHIPNBR, TRANSTYPE
Check-Receipt No. | D M | SELSEQ, IDRMIT, TRANSTYPE
Customer/Check-Receipt No. | D M | SELSEQ, IDCUST, IDNATACCT, IDRMIT, TRANSTYPE
Document No. | D M | SELSEQ, IDINVC, TRANSTYPE
Customer/Document No. | D M | SELSEQ, IDCUST, IDNATACCT, IDINVC, TRANSTYPE

## Fields: 43

Field | Type | Title | Presentation
--- | --- | --- | ---
SELSEQ | Long | Sequence No. |
TRANSTYPE | Integer | Trans. Type | List: 12 entries
0 | = | Invoice
1 | = | Debit Note
2 | = | Credit Note
3 | = | Interest
4 | = | Receipt
5 | = | Prepayment
6 | = | Unapplied Cash
7 | = | Apply Document
8 | = | Misc. Receipt
9 | = | Refund
10 | = | Adjustment
11 | = | Write-off
CNTBTCH | BCD*5.0 | Batch No. |
CNTITEM | BCD*4.0 | Entry No. |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
BATCHSTAT | Integer | Batch Status | List: 4 entries
0 | = | Open
1 | = | Ready To Post
2 | = | Post In Progress
3 | = | Check Creation In Progress
SRCEAPPL | String*2 | Source Application | Mask: %-2A
ENTEREDBY | String*8 | Entered By |
TEXTREF | String*60 | Reference |
TEXTDESC | String*60 | Description |
IDCUST | String*12 | Customer No. | Mask: %-12C
IDNATACCT | String*12 | National Account | Mask: %-12C
IDINVC | String*22 | Document No. | Mask: %-22C
APPLYBY | Integer | Apply By | List: 5 entries
0 | = | (None)
1 | = | Document No.
2 | = | PO No.
3 | = | Order No.
4 | = | Shipment No.
INVCAPPLTO | String*22 | Apply To | Mask: %-22C
RTGAPPLYTO | String*22 | Original Doc. No. | Mask: %-22C
ORDRNBR | String*22 | Order No. | Mask: %-22C
CUSTPO | String*22 | PO Number | Mask: %-22C
SHIPNBR | String*22 | Shipment No. | Mask: %-22C
IDRMIT | String*24 | Check/Receipt No. | Mask: %-24C
PAYER | String*60 | Payer |
DATETRANS | Date | Trans. Date |
DATEBUS | Date | Posting Date |
FISCYR | String*4 | Fiscal Year | Mask: %04D
FISCPER | String*2 | Fiscal Period | Mask: %02D
SWJOB | Integer | Job Related | List: 2 entries
0 | = | No
1 | = | Yes
SWITEM | Integer | Has Item | List: 2 entries
0 | = | No
1 | = | Yes
SWRTG | Integer | Has Retainage | List: 2 entries
0 | = | No
1 | = | Yes
CODECURN | String*3 | Trans. Currency | Mask: %-3N
EXCHRATEHC | BCD*8.7 | Exchange Rate |
TRANSAMT | BCD*10.3 | Trans. Amt. |
TRANSAMTHC | BCD*10.3 | Trans. Amt. (Home) |
TAXAMT | BCD*10.3 | Tax Amt. |
TAXAMTHC | BCD*10.3 | Tax Amt. (Home) |
ADVAMT | BCD*10.3 | Prepay/Advance Amt. |
ADVAMTHC | BCD*10.3 | Prepay/Advance Amt. (Home) |
RTGAMT | BCD*10.3 | Rtg. Amt |
RTGAMTHC | BCD*10.3 | Rtg. Amt. (Home) |
UNAPLAMT | BCD*10.3 | Unapplied Amt. |
UNAPLAMTHC | BCD*10.3 | Unapplied Amt. (Home) |

This page was generated on 2009-Nov-19

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