|
BR Temporary Register Report File: xxxBQuuu.DBF uuu = (base 36) Unique #
|
Tag
|
Index
|
|
BRCKCKNO
|
UPPER(BRBKCODE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCKTYPE) + STR(BRCDLNNO)
|
|
BRCKDATE2
|
UPPER(BRBKCODE) + DTOS(BRCKDATE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCKTYPE) + STR(BRCDLNNO)
|
|
BRCKTYPE2
|
UPPER(BRBKCODE) + STR(BRCKTYPE) + DTOS(BRCKDATE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKADCKOW
|
UPPER(BRBKCODE) + IIF(BRCKTYPE=3 .OR. BRCKTYPE=1,'0','1') + IIF(BRCKTYPE=0,'0','1') + IIF(BRCKTYPE=2 .OR. BRCKTYPE=4,'0','1') + DTOS(BRCKDATE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKDPCKAW
|
UPPER(BRBKCODE) +IIF(BRCKTYPE=1,'0','1') +IIF(BRCKTYPE=0,'0','1') +IIF(BRCKTYPE=3,'0','1') +IIF(BRCKTYPE=2 .OR. BRCKTYPE=4,'0','1')+IIF(BRCKTYPE=0,'00000000',DTOS(BRCKDATE))+UPPER(BRCKCKNO)+STR(BRCDUNIQ)+STR(BRCDLNNO)
|
|
BRCKCKADOW
|
UPPER(BRBKCODE) + IIF(BRCKTYPE=0,'0','1') + IIF(BRCKTYPE=3,'0','1') + IIF(BRCKTYPE=1,'0','1') + IIF(BRCKTYPE=2 .OR. BRCKTYPE=4,'0','1') + DTOS(BRCKDATE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKTYIT
|
UPPER(BRBKCODE) + STR(BRCKTYPE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKTYDTAM
|
UPPER(BRBKCODE) + STR(BRCKTYPE) + DTOS(BRCKDATE) + IIF(BRCKORIG<0,'0','1') + STR(BRCKORIG) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKDTTYIT
|
UPPER(BRBKCODE) + DTOS(BRCKDATE) + STR(BRCKTYPE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCDLNNO)
|
|
BRCKDATENW
|
UPPER(BRBKCODE) + DTOS(BRCKDATE) + UPPER(BRCKCKNO) + STR(BRCDUNIQ) + STR(BRCKTYPE) + STR(BRCDLNNO)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.
|
Check/Document Number
|
BRCKCKNO
|
CharCaps
|
20
|
|
|
2.
|
Payee/Transaction Description
|
BRCKDES
|
Character
|
35
|
|
|
3.
|
Memo Description
|
BRCKMEMO
|
Character
|
36
|
|
|
4.
|
Item Type
|
BRCKTYPE
|
Numeric
|
1
|
|
|
5.
|
Check Status Flag
|
BRCKSTATUS
|
Numeric
|
1
|
|
|
6.
|
Source Flag
|
BRCKSORC
|
CharCaps
|
2
|
|
|
7.
|
Check Date
|
BRCKDATE
|
Date
|
|
|
|
8.
|
Original Check Amount
|
BRCKORIG
|
Numeric
|
15
|
(11.2)
|
|
9.
|
Line Description
|
BRCDDES
|
Character
|
40
|
|
|
10.
|
GL Expense/Opposing Account Field Length for Fund
|
BRCDGL
|
CharCaps
|
30 45
|
|
|
11.
|
Invoice/Document
|
BRCDIVNO
|
CharCaps
|
15
|
|
|
12.
|
Line Item Amount
|
BRCDAMT
|
Numeric
|
15
|
(11.2)
|
|
13.
|
Unique # (BRCKUNIQ form Header)
|
BRCDUNIQ
|
Numeric
|
10
|
|
|
14.
|
Bank Account Code
|
BRBKCODE
|
CharCaps
|
3
|
|
|
15.
|
Activity Notes
|
BRCKNOTE
|
Memo
|
|
|
|
16.
|
Voided Check Date
|
BRCKVOID
|
Date
|
|
|
|
17.
|
Detail Line Number
|
BRCDLNNO
|
Numeric
|
3
|
|
|
18.
|
Category Code
|
BRCKCAT
|
CharCaps
|
6
|
|
|
19.
|
Application User ID
|
BRCKUSERID
|
Character
|
3
|
|
|
20.
|
Transaction Batch Description
|
BRCKBATNUM
|
Character
|
15
|
|
| |
|