View: Unposted Entries

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

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 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).