Table: Bank Transaction Details

Table: BKTRAND
View: BK0840
Record Length: 681

Flags: A R 

Keys: 8

Title Flags Fields

Bank Transaction Detail BANKSERIALLINE
Bank Reconciliation Fiscal Trans M  BANKSERIALPOSTYEARPOSTPERIODLINE
Bank Fiscal Period Transaction M  BANKSERIALFSCYEARFSCPERIODLINE
Header Context Remittance Date M  BANKSERIALDATEREMITIDREMITLINE
Header Context Remittance ID M  BANKSERIALIDREMITDATEREMITLINE
Transaction Remittance Date M  BANKDATEREMITIDREMITSERIALLINE
Transaction Remittance ID M  BANKIDREMITDATEREMITSERIALLINE
Payer Code Remittance ID M  BANKSRCEAPPPAYORIDIDREMITSERIALLINE

Fields: 57

Field Type Title Presentation

BANK String*8 Bank Code Mask: %-8N
SERIAL ??? 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
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
RECLEVEL Integer Reconciled By List:2 entries
0 = Reconciled by Header
1 = Reconciled by Detail