# Table: Bank Journal Transaction Details

Table: BKJTRAND
View: BK0650
Record length: 1124
Flags: A R

## Keys: 1

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

## Fields: 96

Field | Type | Title | Presentation
--- | --- | --- | ---
PSTSEQ | BCD*5.0 | Posting Sequence |
BANK | String*8 | Bank Code | Mask: %-8N
SERIAL | Long | Transaction Header Serial |
LINE | Long | Transaction Detail Line |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SRCEAPP | String*2 | Source Application | Mask: %-2N
STATUS | Integer | Transaction Detail Status | 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 | Integer | Transaction Type | List: 2 entries
1 | = | Withdrawals
2 | = | Deposits
TYPE | Integer | Detail Transaction Type | List: 7 entries
1 | = | Check
2 | = | EFT
3 | = | Transfer
4 | = | Service Charge
5 | = | Credit Card
6 | = | Cash
7 | = | Other
IDREMIT | String*24 | Remittance ID |
DATEREMIT | Date | Transaction Date |
BTCHNBR | BCD*5.0 | Batch Number |
ENTRYNBR | BCD*4.0 | Entry Number |
POSTSEQ | BCD*5.0 | Posting Sequence Number |
REFERENCE | String*60 | Transaction Reference |
COMMENT | String*60 | Transaction Description |
PAYORID | String*12 | Payer Code | Mask: %-12C
PAYORNAME | String*60 | Payee Name |
VENDORNAME | String*60 | Vendor Name |
SRCEAMOUNT | BCD*10.3 | Source Transaction Amount |
FUNCAMOUNT | BCD*10.3 | Functional Transaction Amount |
RATETYPE | String*2 | Exchange Rate Type | Mask: %-2N
SRCECURN | String*3 | Receipt Currency | Mask: %-3N
RATEDATE | Date | Exchange Rate Date |
RATE | BCD*8.7 | Exchange Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
RATEOP | Integer | Rate Operation | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
DISTCODE | String*6 | Distribution Code | Mask: %-6N
GLACCOUNT | String*45 | G/L Account | Mask: %-45C
GLACCTOVR | Boolean | GL Account Override |
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNUMBER | Binary*32 | Credit Card Number |
CCNAME | String*60 | Cardholder Name |
CCAUTHCODE | String*20 | Authorization Code |
CCEXP | Date | Expiry Date |
DDTYPE | Integer | Drilldown Type |
DDLINK | BCD*10.0 | Drilldown Link |
RECSTATUS | Integer | Reconciliation Status | 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 | Date | Status Change Date |
RECCOMMENT | String*60 | Reconciliation Description |
RECCLEARED | BCD*10.3 | Cleared Amount |
POSTDATE | Date | Reconciliation Posting Date |
POSTYEAR | String*4 | Reconciliation Posting Year | Mask: %04D
POSTPERIOD | Integer | Reconciliation Posting Period |
RECONCILED | Boolean | Reconciled |
RECPENDING | BCD*10.3 | Remaining In Transit Amount |
RECERR | BCD*10.3 | Reconciliation Error |
RECERRPEND | BCD*10.3 | Reconciliation Error Pending |
RECEXGAIN | BCD*10.3 | Reconciliation Exchange Gain |
RECEXLOSS | BCD*10.3 | Reconciliation Exchange Loss |
RECSUGGEST | Integer | Reconciliation Suggestion | 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 | BCD*10.3 | Transaction Amount |
RECOUTSTND | BCD*10.3 | Outstanding Amount |
RECTARGET | Integer | Reconciliation Target |
RECCCC | BCD*10.3 | Reconciliation Credit Card Charge |
RECWOSUM | BCD*10.3 | Write-Off Amount |
CURFUNC | String*3 | Functional Currency |
CURSTMT | String*3 | Statement Currency |
SUMAMOUNT | BCD*10.3 | Summated Transaction Amount |
RECSPREAD | BCD*10.3 | Reconciliation Spread |
RECPAMOUNT | BCD*10.3 | Fiscal Transaction Remaining In Transit |
RECPOUTSTD | BCD*10.3 | Fiscal Outstanding Amount |
RECPWO | BCD*10.3 | Fiscal Write Offs |
RECPERR | BCD*10.3 | Fiscal Bank Errors |
RECPGAIN | BCD*10.3 | Fiscal Exchange Gain |
RECPLOSS | BCD*10.3 | Fiscal Exchange Loss |
RECPCCC | BCD*10.3 | Fiscal Credit Card Charge |
RECPCLR | BCD*10.3 | Fiscal Cleared |
RECPFUNAM | BCD*10.3 | Fiscal Functional Amount |
RECPORIG | BCD*10.3 | Fiscal Original Transaction Amount |
RECTBOOK | BCD*10.3 | Total Book Amount |
RECPBOOK | BCD*10.3 | Fiscal Book Amount |
RECTREMAIN | BCD*10.3 | Total Remaining Amount |
RECPREMAIN | BCD*10.3 | Fiscal Remaining Amount |
RECRWOSUM | BCD*10.3 | Fiscal Write-Off To This Period |
RECFCLR | BCD*10.3 | Fiscal Cleared To Future |
RECRCLR | BCD*10.3 | Fiscal Cleared To Current |
RECWOSUMR | BCD*10.3 | Current Period's Write-Off |
RECFCLRR | BCD*10.3 | Posted Fiscal Cleared To Future |
PAYMCODE | String*12 | Payment Code |
CHKFORM | String*6 | Check Stock Code | Mask: %-6N
OFXTID | String*50 | OFX Transaction ID |
RECDELTAF | BCD*10.3 | Future Reconciliation Delta |
FSCYEAR | String*4 | Fiscal Year | Mask: %04D
FSCPERIOD | Integer | Fiscal Period |
REVDATE | Date | Reversal/Return Date |
SRCEDOCNUM | String*22 | Source Document Number |
CANREVINVC | Integer | Can Reverse Invoice | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | Integer | Reverse Invoice | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETED | Integer | Reconciled and Journaled Transaction | List: 2 entries
0 | = | Not Completed
10 | = | Completed
ENTRYTYPE | Integer | Entry Type |
RECDELTA | BCD*10.3 | Reconciliation Amount Delta |
POSTED | Date | Document Posted Date |

This page was generated on 2009-Nov-19

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