# Table: Bank Transaction Details

Table: BKTRAND
View: BK0840
Record length: 804
Flags: A R

## Keys: 7

Title | Flags | Fields
--- | --- | ---
Bank Transaction Detail |  | BANK, SERIAL, LINE
Bank Reconciliation Fiscal Trans | D M | BANK, SERIAL, POSTYEAR, POSTPERIOD, LINE
Bank Fiscal Period Transaction | D M | BANK, SERIAL, FSCYEAR, FSCPERIOD, LINE
Header Context Remittance Date | D M | BANK, SERIAL, DATEREMIT, IDREMIT, LINE
Header Context Remiitance ID | D M | BANK, SERIAL, IDREMIT, DATEREMIT, LINE
Transaction Remittance Date | D M | BANK, DATEREMIT, IDREMIT, SERIAL, LINE
Transaction Remiitance ID | D M | BANK, IDREMIT, DATEREMIT, SERIAL, LINE

## Fields: 61

Field | Type | Title | Presentation
--- | --- | --- | ---
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: 8 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
6 | = | Cleared with bank error
4 | = | Reversed
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
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
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: 3 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
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 | List: 1 entries
0 | = |
RECONCILED | Boolean | Reconciled |
RECPENDING | BCD*10.3 | Remaining In Transit Amount |
PAYMCODE | String*12 | Payment Code |
CHKFORM | String*6 | Check Stock Code | Mask: %-6N
OFXTID | String*50 | OFX Transaction ID |
FSCYEAR | String*4 | Fiscal Year | Mask: %04D
FSCPERIOD | Integer | Fiscal Period | List: 13 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
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
PSTSEQ | BCD*5.0 | Posting Sequence |
ENTRYTYPE | Integer | Entry Type |
POSTED | Date | Document Posted Date |
LSTRECSTAT | Integer | Last Reconciliation Status |

This page was generated on 2009-Nov-19

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