# View: Unposted Entries

RotoID: AR0095
Table: ARUNPSTH
Protocol: Flat
DLL: ARUNPSTH

## Compositions: 0

## Keys: 14

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

## Fields: 55

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SELSEQ | 1 | Long | Sequence No. | E A K R |
TRANSTYPE | 2 | Integer | Trans. Type | E A K R | 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 | 3 | BCD*5.0 | Batch No. | E A K R |
CNTITEM | 4 | BCD*4.0 | Entry No. | E A K R |
BATCHSTAT | 5 | Integer | Batch Status | E A | List: 4 entries
0 | = | Open
1 | = | Ready To Post
2 | = | Post In Progress
3 | = | Check Creation In Progress
SRCEAPPL | 6 | String*2 | Source Application | E A | Mask: %-2A
ENTEREDBY | 7 | String*8 | Entered By | E A |
TEXTREF | 8 | String*60 | Reference | E A |
TEXTDESC | 9 | String*60 | Description | E A |
IDCUST | 10 | String*12 | Customer No. | E A | Mask: %-12C
IDNATACCT | 11 | String*12 | National Account | E A | Mask: %-12C
IDINVC | 12 | String*22 | Document No. | E A | Mask: %-22C
APPLYBY | 13 | Integer | Apply By | E A | List: 5 entries
0 | = | (None)
1 | = | Document No.
2 | = | PO No.
3 | = | Order No.
4 | = | Shipment No.
INVCAPPLTO | 14 | String*22 | Apply To | E A | Mask: %-22C
RTGAPPLYTO | 15 | String*22 | Original Doc. No. | E A | Mask: %-22C
ORDRNBR | 16 | String*22 | Order No. | E A | Mask: %-22C
CUSTPO | 17 | String*22 | PO Number | E A | Mask: %-22C
SHIPNBR | 18 | String*22 | Shipment No. | E A | Mask: %-22C
IDRMIT | 19 | String*24 | Check/Receipt No. | E A | Mask: %-24C
PAYER | 20 | String*60 | Payer | E A |
DATETRANS | 21 | Date | Trans. Date | E A |
DATEBUS | 22 | Date | Posting Date | E A |
FISCYR | 23 | String*4 | Fiscal Year | E A | Mask: %04D
FISCPER | 24 | String*2 | Fiscal Period | E A | Mask: %02D
SWJOB | 25 | Integer | Job Related | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWITEM | 26 | Integer | Has Item | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWRTG | 27 | Integer | Has Retainage | E A | List: 2 entries
0 | = | No
1 | = | Yes
CODECURN | 28 | String*3 | Trans. Currency | E A | Mask: %-3N
EXCHRATEHC | 29 | BCD*8.7 | Exchange Rate | E A |
TRANSAMT | 30 | BCD*10.3 | Trans. Amt. | E A |
TRANSAMTHC | 31 | BCD*10.3 | Trans. Amt. (Home) | E A |
TAXAMT | 32 | BCD*10.3 | Tax Amt. | E A |
TAXAMTHC | 33 | BCD*10.3 | Tax Amt. (Home) | E A |
ADVAMT | 34 | BCD*10.3 | Prepay/Advance Amt. | E A |
ADVAMTHC | 35 | BCD*10.3 | Prepay/Advance Amt. (Home) | E A |
RTGAMT | 36 | BCD*10.3 | Rtg. Amt | E A |
RTGAMTHC | 37 | BCD*10.3 | Rtg. Amt. (Home) | E A |
UNAPLAMT | 38 | BCD*10.3 | Unapplied Amt. | E A |
UNAPLAMTHC | 39 | BCD*10.3 | Unapplied Amt. (Home) | E A |
PROCESSCMD | 50 | Integer | Process Command | E A C |
GENSEQ | 51 | Long | Generated Sequence No. | E A C |
FORCUST | 52 | String*12 | For Customer | E A C | Mask: %-12C
CHKNAT | 53 | Integer | Check National Accounts | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKIN | 54 | Integer | Check invoices | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKDB | 55 | Integer | Check Debit Notes | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKCR | 56 | Integer | Check Credit Notes | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKIT | 57 | Integer | Check Interest | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKPY | 58 | Integer | Check Receipts | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKPREP | 59 | Integer | Check Prepayments | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKUC | 60 | Integer | Check Unapplied Cash | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKAPPLY | 61 | Integer | Check Apply | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKMISC | 62 | Integer | Check Misc. Receipts | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKRF | 63 | Integer | Check Refunds | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKAD | 64 | Integer | Check Adjustments | E A C | List: 2 entries
0 | = | No
1 | = | Yes
CHKWO | 65 | Integer | Check Write-Offs | E A C | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

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