Table: Transfer Audit Charge

Table: BKJTFRD
View: BK0645
Record length: 2491
Flags: A R 

Keys: 1

Title  Flags  Fields

Posting Sequence/Key Sequence Ch  PSTSEQ, KEYSEQ, LINE

Fields: 142

Field  Type  Title  Presentation 

PSTSEQ  BCD*5.0  Posting Sequence   
KEYSEQ  BCD*5.0  Key Sequence   
LINE  Integer  Charge Line  List: 2 entries
0=Originating Bank
1=Destination Bank
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
BANK  String*8    Mask: %-8N
TYPE  String*6  Transfer Charge Transaction Type  Mask: %-6N
GLACCOUNT  String*45  Transfer Charge G/L Account  Mask: %-45C
SRCECURN  String*3  Transfer Charge Source Currency  Mask: %-3N
SRCEAMT  BCD*10.3  Transfer Charge Source Amount   
RATETYPE  String*2  Exchange Rate Type  Mask: %-2N
RATEDATE  Date  Exchange Rate Date   
RATE  BCD*8.7  Exchange Rate   
RATEOP  Integer  Rate Operation  List: 2 entries
1=Multiply
2=Divide
FAMOUNT  BCD*10.3  Transfer Charge Functional Amount   
GLACCHG  Boolean  Transfer Charge G/L Override   
GLACCOUNTD  String*60  Charge G/L Description   
SWTAXBL  Integer  Taxable  List: 2 entries
0=No
1=Yes
TXAMTCALC  Integer  Tax Amount Calculation  List: 2 entries
0=No
1=Yes
CODETAXGRP  String*12  Tax Group  Mask: %-12N
TAXAUTH1  String*12  Tax Authority 1  Mask: %-12N
TAXAUTH2  String*12  Tax Authority 2  Mask: %-12N
TAXAUTH3  String*12  Tax Authority 3  Mask: %-12N
TAXAUTH4  String*12  Tax Authority 4  Mask: %-12N
TAXAUTH5  String*12  Tax Authority 5  Mask: %-12N
TAXVCLSS1  Integer  Tax Vendor Class 1   
TAXVCLSS2  Integer  Tax Vendor Class 2   
TAXVCLSS3  Integer  Tax Vendor Class 3   
TAXVCLSS4  Integer  Tax Vendor Class 4   
TAXVCLSS5  Integer  Tax Vendor Class 5   
TAXICLSS1  Integer  Tax Item Class 1   
TAXICLSS2  Integer  Tax Item Class 2   
TAXICLSS3  Integer  Tax Item Class 3   
TAXICLSS4  Integer  Tax Item Class 4   
TAXICLSS5  Integer  Tax Item Class 5   
TAXINCL1  Integer  Tax Include 1  List: 2 entries
0=No
1=Yes
TAXINCL2  Integer  Tax Include 2  List: 2 entries
0=No
1=Yes
TAXINCL3  Integer  Tax Include 3  List: 2 entries
0=No
1=Yes
TAXINCL4  Integer  Tax Include 4  List: 2 entries
0=No
1=Yes
TAXINCL5  Integer  Tax Include 5  List: 2 entries
0=No
1=Yes
BASETAX1  BCD*10.3  Tax Base Amount 1   
BASETAX2  BCD*10.3  Tax Base Amount 2   
BASETAX3  BCD*10.3  Tax Base Amount 3   
BASETAX4  BCD*10.3  Tax Base Amount 4   
BASETAX5  BCD*10.3  Tax Base Amount 5   
BASETAXRC1  BCD*10.3  Tax Base Retainage amount1   
BASETAXRC2  BCD*10.3  Tax Base Retainage amount2   
BASETAXRC3  BCD*10.3  Tax Base Retainage amount3   
BASETAXRC4  BCD*10.3  Tax Base Retainage amount4   
BASETAXRC5  BCD*10.3  Tax Base Retainage amount5   
TXCALCBASE  Integer  Tax Base Calculation Method  List: 2 entries
0=No
1=Yes
AMTTAX1  BCD*10.3  Tax Amount 1   
AMTTAX2  BCD*10.3  Tax Amount 2   
AMTTAX3  BCD*10.3  Tax Amount 3   
AMTTAX4  BCD*10.3  Tax Amount 4   
AMTTAX5  BCD*10.3  Tax Amount 5   
AMTTXBL  BCD*10.3  Taxable AMount   
AMTNOTTXBL  BCD*10.3  Non Taxable Amount   
AMTTAXTOT  BCD*10.3  Tax Total   
AMTDOCTOT  BCD*10.3  Document Total Before Tax   
AMTNETTOT  BCD*10.3  Document Total Including Tax   
AMTDIST  BCD*10.3  Tax Distribution amount   
AMTINCLUDE  BCD*10.3  Total Included Amount   
AMTEXCLUDE  BCD*10.3  Total Excluded Amount   
AMTNETDIST  BCD*10.3  Tax Net Distribution Amount   
AMTGRODIST  BCD*10.3  Tax Gross Distribution Amount   
AMTEXPENS1  BCD*10.3  Tax Expense Amount 1   
AMTEXPENS2  BCD*10.3  Tax Expense Amount 2   
AMTEXPENS3  BCD*10.3  Tax Expense Amount 3   
AMTEXPENS4  BCD*10.3  Tax Expense Amount 4   
AMTEXPENS5  BCD*10.3  Tax Expense Amount 5   
AMTRECVRB1  BCD*10.3  Tax Recoverable AMount 1   
AMTRECVRB2  BCD*10.3  Tax Recoverable AMount 2   
AMTRECVRB3  BCD*10.3  Tax Recoverable AMount 3   
AMTRECVRB4  BCD*10.3  Tax Recoverable AMount 4   
AMTRECVRB5  BCD*10.3  Tax Recoverable AMount 5   
TOTAMTALOC  BCD*10.3  Total Tax Allocated Amount   
TXAMT1RC  BCD*10.3  Tax Reporting Amount 1   
TXAMT2RC  BCD*10.3  Tax Reporting Amount 2   
TXAMT3RC  BCD*10.3  Tax Reporting Amount 3   
TXAMT4RC  BCD*10.3  Tax Reporting Amount 4   
TXAMT5RC  BCD*10.3  Tax Reporting Amount 5   
TXALOCRC  BCD*10.3  Total Tax Reporting Allocated Amount   
TXEXPNSRC  BCD*10.3  Tax Reporting Expensed Amount   
TXRECVBRC  BCD*10.3  Tax Reporting Recoverable Amount   
TXTOTRC  BCD*10.3  Total Tax Reporting Amount   
TAXVERSION  Long  Tax Version   
TXCALCRMET  Integer  Tax Calculation Reporting Method  List: 2 entries
0=No
1=Yes
EXPNSACNT1  String*45  Tax Expense Account 1   
EXPNSACNT2  String*45  Tax Expense Account 2   
EXPNSACNT3  String*45  Tax Expense Account 3   
EXPNSACNT4  String*45  Tax Expense Account 4   
EXPNSACNT5  String*45  Tax Expense Account 5   
RECBLACNT1  String*45  Tax Recoverable Account 1   
RECBLACNT2  String*45  Tax Recoverable Account 2   
RECBLACNT3  String*45  Tax Recoverable Account 3   
RECBLACNT4  String*45  Tax Recoverable Account 4   
RECBLACNT5  String*45  Tax Recoverable Account 5   
CODECURNRC  String*3  Tax Reporting Currency Code  Mask: %-3N
TXGRPDESC  String*60  Tax Group Description   
TXAU1DESC  String*60  Tax Authority Description 1   
TXAU2DESC  String*60  Tax Authority Description 2   
TXAU3DESC  String*60  Tax Authority Description 3   
TXAU4DESC  String*60  Tax Authority Description 4   
TXAU5DESC  String*60  Tax Authority Description 5   
VCLS1DESC  String*60  Vendor Tax Class Description 1   
VCLS2DESC  String*60  Vendor Tax Class Description 2   
VCLS3DESC  String*60  Vendor Tax Class Description 3   
VCLS4DESC  String*60  Vendor Tax Class Description 4   
VCLS5DESC  String*60  Vendor Tax Class Description 5   
ICLS1DESC  String*60  Item Tax Class Description 1   
ICLS2DESC  String*60  Item Tax Class Description 2   
ICLS3DESC  String*60  Item Tax Class Description 3   
ICLS4DESC  String*60  Item Tax Class Description 4   
ICLS5DESC  String*60  Item Tax Class Description 5   
FUNGRODIS  BCD*10.3  Functional Gross Distribution Amount   
FUNTXEXP1  BCD*10.3  Functional Expensed Amount 1   
FUNTXEXP2  BCD*10.3  Functional Expensed Amount 2   
FUNTXEXP3  BCD*10.3  Functional Expensed Amount 3   
FUNTXEXP4  BCD*10.3  Functional Expensed Amount 4   
FUNTXEXP5  BCD*10.3  Functional Expensed Amount 5   
FUNTXRCB1  BCD*10.3  Functional Recoverable Amount 1   
FUNTXRCB2  BCD*10.3  Functional Recoverable Amount 2   
FUNTXRCB3  BCD*10.3  Functional Recoverable Amount 3   
FUNTXRCB4  BCD*10.3  Functional Recoverable Amount 4   
FUNTXRCB5  BCD*10.3  Functional Recoverable Amount 5   
RATERC  BCD*8.7  Tax Reporting Rate   
RATETYPERC  String*2  Tax Reporting Rate Type   
RATEDATERC  Date  Tax Reporting Rate Date   
RATEOPRC  Integer  Tax Reporting Rate Operation   
CURNRCDESC  String*60  Tax Reporting Currency Description   
RATERCDESC  String*60  Tax Reporting RateType Description   
TAXRATE1  BCD*8.7  Tax Rate 1   
TAXRATE2  BCD*8.7  Tax Rate 2   
TAXRATE3  BCD*8.7  Tax Rate 3   
TAXRATE4  BCD*8.7  Tax Rate 4   
TAXRATE5  BCD*8.7  Tax Rate 5   
FUNNETTAX  BCD*10.3  Functional Net of Tax   
FUNAMTALOC  BCD*10.3  Functional Total Tax Allocated   
FUNTOTTAX  BCD*10.3  Functional Tax Total   

This page was generated on 2008-May-01

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