# View: Bank Journal Transaction Details

RotoID: BK0650
Table: BKJTRAND
Protocol: Detail, Ordered revisions
DLL: BKJTRAND

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0655 | BKJTRANH | Bank Journal Transaction Header | BKJTRANH

## Keys: 1

Title | Fields
--- | ---
Bank Journal Transaction Detail | PSTSEQ, BANK, SERIAL, LINE

## Fields: 92

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
PSTSEQ | 1 | BCD*5.0 | Posting Sequence | E A K R |
BANK | 2 | String*8 | Bank Code | E A K R | Mask: %-8N
SERIAL | 3 | Long | Transaction Header Serial | E A K R |
LINE | 4 | Long | Transaction Detail Line | E A K R |
SRCEAPP | 5 | String*2 | Source Application | E A | Mask: %-2N
STATUS | 6 | Integer | Transaction Detail Status | E A | List: 12 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Cleared with write-off
11 | = | Cleared with exchange rate difference
12 | = | Cleared with credit card charge
TRANSTYPE | 7 | Integer | Transaction Type | E A | List: 2 entries
1 | = | Withdrawals
2 | = | Deposits
TYPE | 8 | Integer | Detail Transaction Type | E A | List: 7 entries
1 | = | Check
2 | = | EFT
3 | = | Transfer
4 | = | Service Charge
5 | = | Credit Card
6 | = | Cash
7 | = | Other
IDREMIT | 9 | String*24 | Remittance ID | E A |
DATEREMIT | 10 | Date | Transaction Date | E A |
BTCHNBR | 11 | BCD*5.0 | Batch Number | E A |
ENTRYNBR | 12 | BCD*4.0 | Entry Number | E A |
POSTSEQ | 13 | BCD*5.0 | Posting Sequence Number | E A |
REFERENCE | 14 | String*60 | Transaction Reference | E A |
COMMENT | 15 | String*60 | Transaction Description | E A |
PAYORID | 16 | String*12 | Payer Code | E A | Mask: %-12C
PAYORNAME | 17 | String*60 | Payee Name | E A |
VENDORNAME | 18 | String*60 | Vendor Name | E A |
SRCEAMOUNT | 19 | BCD*10.3 | Source Transaction Amount | E A |
FUNCAMOUNT | 20 | BCD*10.3 | Functional Transaction Amount | E A |
RATETYPE | 21 | String*2 | Exchange Rate Type | E A | Mask: %-2N
SRCECURN | 22 | String*3 | Receipt Currency | E A | Mask: %-3N
RATEDATE | 23 | Date | Exchange Rate Date | E A |
RATE | 24 | BCD*8.7 | Exchange Rate | E A |
RATESPREAD | 25 | BCD*8.7 | Rate Spread | E A |
RATEOP | 26 | Integer | Rate Operation | E A | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
DISTCODE | 27 | String*6 | Distribution Code | E A | Mask: %-6N
GLACCOUNT | 28 | String*45 | G/L Account | E A | Mask: %-45C
GLACCTOVR | 29 | Boolean | GL Account Override | E A |
CCTYPE | 30 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNUMBER | 31 | Binary*32 | Credit Card Number | E A |
CCNAME | 32 | String*60 | Cardholder Name | E A |
CCAUTHCODE | 33 | String*20 | Authorization Code | E A |
CCEXP | 34 | Date | Expiry Date | E A |
DDTYPE | 35 | Integer | Drilldown Type | E A |
DDLINK | 36 | BCD*10.0 | Drilldown Link | E A |
RECSTATUS | 37 | Integer | Reconciliation Status | E A | List: 12 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Cleared with write-off
11 | = | Cleared with exchange rate difference
12 | = | Cleared with credit card charge
RECSTATCHG | 38 | Date | Status Change Date | E A |
RECCOMMENT | 39 | String*60 | Reconciliation Description | E A |
RECCLEARED | 40 | BCD*10.3 | Cleared Amount | E A |
POSTDATE | 41 | Date | Reconciliation Posting Date | E A |
POSTYEAR | 42 | String*4 | Reconciliation Posting Year | E A | Mask: %04D
POSTPERIOD | 43 | Integer | Reconciliation Posting Period | E A |
RECONCILED | 44 | Boolean | Reconciled | E A |
RECPENDING | 45 | BCD*10.3 | Remaining In Transit Amount | E A |
RECERR | 46 | BCD*10.3 | Reconciliation Error | E A |
RECERRPEND | 47 | BCD*10.3 | Reconciliation Error Pending | E A |
RECEXGAIN | 48 | BCD*10.3 | Reconciliation Exchange Gain | E A |
RECEXLOSS | 49 | BCD*10.3 | Reconciliation Exchange Loss | E A |
RECSUGGEST | 50 | Integer | Reconciliation Suggestion | E A | List: 12 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Cleared with write-off
11 | = | Cleared with exchange rate difference
12 | = | Cleared with credit card charge
RECAMOUNT | 51 | BCD*10.3 | Transaction Amount | E A |
RECOUTSTND | 52 | BCD*10.3 | Outstanding Amount | E A |
RECTARGET | 53 | Integer | Reconciliation Target | E A |
RECCCC | 54 | BCD*10.3 | Reconciliation Credit Card Charge | E A |
RECWOSUM | 55 | BCD*10.3 | Write-Off Amount | E A |
CURFUNC | 56 | String*3 | Functional Currency | E A |
CURSTMT | 57 | String*3 | Statement Currency | E A |
SUMAMOUNT | 58 | BCD*10.3 | Summated Transaction Amount | E A |
RECSPREAD | 59 | BCD*10.3 | Reconciliation Spread | E A |
RECPAMOUNT | 60 | BCD*10.3 | Fiscal Transaction Remaining In Transit | E A |
RECPOUTSTD | 61 | BCD*10.3 | Fiscal Outstanding Amount | E A |
RECPWO | 62 | BCD*10.3 | Fiscal Write Offs | E A |
RECPERR | 63 | BCD*10.3 | Fiscal Bank Errors | E A |
RECPGAIN | 64 | BCD*10.3 | Fiscal Exchange Gain | E A |
RECPLOSS | 65 | BCD*10.3 | Fiscal Exchange Loss | E A |
RECPCCC | 66 | BCD*10.3 | Fiscal Credit Card Charge | E A |
RECPCLR | 67 | BCD*10.3 | Fiscal Cleared | E A |
RECPFUNAM | 68 | BCD*10.3 | Fiscal Functional Amount | E A |
RECPORIG | 69 | BCD*10.3 | Fiscal Original Transaction Amount | E A |
RECTBOOK | 70 | BCD*10.3 | Total Book Amount | E A |
RECPBOOK | 71 | BCD*10.3 | Fiscal Book Amount | E A |
RECTREMAIN | 72 | BCD*10.3 | Total Remaining Amount | E A |
RECPREMAIN | 73 | BCD*10.3 | Fiscal Remaining Amount | E A |
RECRWOSUM | 74 | BCD*10.3 | Fiscal Write-Off To This Period | E A |
RECFCLR | 75 | BCD*10.3 | Fiscal Cleared To Future | E A |
RECRCLR | 76 | BCD*10.3 | Fiscal Cleared To Current | E A |
RECWOSUMR | 77 | BCD*10.3 | Current Period's Write-Off | E A |
RECFCLRR | 78 | BCD*10.3 | Posted Fiscal Cleared To Future | E A |
PAYMCODE | 79 | String*12 | Payment Code | E A |
CHKFORM | 80 | String*6 | Check Stock Code | E A | Mask: %-6N
OFXTID | 81 | String*50 | OFX Transaction ID | E A |
RECDELTAF | 82 | BCD*10.3 | Future Reconciliation Delta | E A |
FSCYEAR | 83 | String*4 | Fiscal Year | E A | Mask: %04D
FSCPERIOD | 84 | Integer | Fiscal Period | E A |
REVDATE | 85 | Date | Reversal/Return Date | E A |
SRCEDOCNUM | 86 | String*22 | Source Document Number | E A |
CANREVINVC | 87 | Integer | Can Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 88 | Integer | Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETED | 89 | Integer | Reconciled and Journaled Transaction | E A | List: 2 entries
0 | = | Not Completed
10 | = | Completed
ENTRYTYPE | 90 | Integer | Entry Type | E A |
RECDELTA | 91 | BCD*10.3 | Reconciliation Amount Delta | E A |
POSTED | 92 | Date | Document Posted Date | E A |

This page was generated on 2009-Nov-19

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