View: Posted Transactions

RotoID: GL0018
Table: GLPOST
Protocol: Flat
DLL:GLPOST

Keys: 5

Title Fields

Posted Transactions ACCTIDFISCALYRFISCALPERDSRCECURNSRCELEDGERSRCETYPEPOSTINGSEQCNTDETAIL
Dated Posting Sequence JRNLDATEPOSTINGSEQBATCHNBRENTRYNBRTRANSNBR
Posting Sequence POSTINGSEQBATCHNBRENTRYNBRTRANSNBR
Account Posting Sequence ACCTIDPOSTINGSEQBATCHNBRENTRYNBRTRANSNBR
Document Dated Posting Sequence ACCTIDDOCDATEPOSTINGSEQCNTDETAILBATCHNBRENTRYNBRTRANSNBR

Fields: 38

Field Index Type Title Attributes Presentation

ACCTID 1 String*45 Account Number E A K R  Mask: %-45C
FISCALYR 2 String*4 Fiscal Year E A K R  Mask: %04D
FISCALPERD 3 String*2 Fiscal Period E A K R  Mask: %02D
SRCECURN 4 String*3 Source Currency Code E A K R  Mask: %-3N
SRCELEDGER 5 String*2 Source Ledger Code E A K R  Mask: %-2A
SRCETYPE 6 String*2 Source Type Code E A K R  Mask: %-2N
POSTINGSEQ 7 BCD*4.0 Posting Sequence Number E A K R 
CNTDETAIL 8 BCD*4.0 Detail Count E A K R 
JRNLDATE 9 Date Journal Date E A 
BATCHNBR 10 String*6 Batch Number E A  Mask: %06D
ENTRYNBR 11 String*5 Journal Entry Number E A  Mask: %05D
TRANSNBR 12 BCD*4.0 Journal Transaction Number E A 
EDITALLOWD 13 Integer Reserved
CONSOLIDAT 14 Integer Consolidation Occurred on Post E A  List:2 entries
0 = No
1 = Yes
COMPANYID 15 String*8 Company ID E A 
JNLDTLDESC 16 String*60 Journal Detail Description E A 
JNLDTLREF 17 String*60 Journal Detail Reference E A 
TRANSAMT 18 BCD*10.3 Journal Transaction Amount E A T 
TRANSQTY 19 BCD*10.3 Journal Transaction Quantity E A T 
SCURNDEC 20 String*1 Nbr of Source Currency Decimals E A 
SCURNAMT 21 BCD*10.3 Source Currency Amount E A T 
HCURNCODE 22 String*3 Home Currency Code E A  Mask: %-3N
RATETYPE 23 String*2 Currency Rate Table Type E A  Mask: %-2N
SCURNCODE 24 String*3 Source Currency Code E A  Mask: %-3N
RATEDATE 25 Date Date of Currency Rate Selected E A 
CONVRATE 26 BCD*8.7 Currency Rate for Conversion E A 
RATESPREAD 27 BCD*8.7 Currency Rate Spread Allowed E A 
DATEMTCHCD 28 String*1 Code for Rate Date Matching E A 
RATEOPER 29 String*1 Currency Rate Operator E A 
DRILSRCTY 30 Integer Drill Down Type E A 
DRILLDWNLK 31 BCD*10.0 Drill Down Link Number E A 
DRILAPP 32 String*2 Drill Down Application Source E A  Mask: %-2A
RPTAMT 33 BCD*10.3 Report Currency Amount E A T 
VALUES 34 Long Optional Fields E A 
DOCDATE 35 Date Document Date E A 
TXRPTSTAT 36 Long Tax Reporting Status - KB 103720 E A 
TAXAUTH 37 String*12 Tax Authority E A C 
TXACCTTYPE 38 Integer Tax Account Type E A C  List:5 entries
0 = None
1 = Liability
2 = Expense
3 = Recoverable
4 = Allocated