|
AP Temporary Header File: xxxAAT01.DBF (FUND Only)
|
Tag
|
Index
|
|
APTOAPPLY
|
UPPER(APTOVENDOR) + UPPER(APTOAPPLY) + STR(APTOATYPE,2,0) + STR(APTOTRNUM,5,0)
|
|
APTOREF
|
UPPER(APTOREF) + STR(APTOTRNUM,5,0)
|
|
APTOTRNUM(U)
|
STR(APTOTRNUM,5,0)
|
|
APTOVENDOR
|
UPPER(APTOVENDOR) + STR(APTOTRNUM,5,0)
|
|
APTOBANK
|
UPPER(APTOBANK) + UPPER(APTOREF) + STR(APTOTYPE,2,0)
|
|
APTOCODE
|
UPPER(APTOAPCOD) + UPPER(APTOVENDOR) + STR(APTOTRNUM,5,0)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.
|
Transaction Number
|
APTOTRNUM
|
Numeric
|
5
|
|
|
2.
|
Vendor Number
|
APTOVENDOR
|
CharCaps
|
20
|
|
|
3.
|
Check Number/Posting Reference
|
APTOREF
|
CharCaps
|
15
|
|
|
4.
|
Description
|
APTODES
|
Character
|
30
|
|
|
5.
|
GL Account
Field Length for Fund
|
APTOGL
|
CharCaps
|
30
45
|
|
|
6.
|
BR Bank Code
|
APTOBANK
|
CharCaps
|
3
|
|
|
7.
|
Transaction Type
|
APTOTYPE
|
Numeric
|
2
|
|
|
8.
|
Check Printed
0=N/A, 1=No, 2=Yes
|
APTOCPRINT
|
Numeric
|
1
|
R:0-2
|
|
9.
|
Total Number of Detail Lines
|
APTOLINES
|
Numeric
|
3
|
|
|
10.
|
Transaction Date
|
APTODATE
|
Date
|
|
|
|
11.
|
Apply to Reference
|
APTOAPPLY
|
CharCaps
|
15
|
|
|
12.
|
Apply to Type
|
APTOATYPE
|
Numeric
|
2
|
|
|
13.
|
Application Date for Unapplieds
|
APTOAPDATE
|
Date
|
|
|
|
14.
|
Transaction Amount
|
APTOAMOUNT
|
Numeric
|
15
|
(12.2) R:0->
|
|
15.
|
Discount Amount
|
APTODISC
|
Numeric
|
15
|
(12.2) R:0->
|
|
16.
|
Undedicated Amount (unapplieds)
|
APTOUNDED
|
Numeric
|
15
|
(12.2) R:0->
|
|
17.
|
Dedicated Amount (unapplieds)
|
APTODED
|
Numeric
|
15
|
(12.2) R:0->
|
|
18.
|
Total Debits (taken for this payment)
|
APTODEBITS
|
Numeric
|
15
|
(12.2) R:0->
|
|
19.
|
Posting Status
|
APTOSTATUS
|
Numeric
|
3
|
|
|
20.
|
Void Check in CR Flag (CR active)
|
APTOVOIDCK
|
Numeric
|
1
|
|
|
21.
|
Number of Checks Voided Before Actual
|
APTOBEFORE
|
Numeric
|
1
|
|
|
22.
|
Number of Checks Voided After Actual
|
APTOAFTER
|
Numeric
|
1
|
|
|
23.
|
For Type 8 (open item is 6/7)
|
APTOOPEN
|
Numeric
|
1
|
|
|
24.
|
For Type 4 (don't print check CR)
|
APTONOCHK
|
Numeric
|
1
|
|
|
25.
|
Vendor Name (used in lookups)
|
APTONAME
|
Character
|
35
|
|
|
26.
|
Open Item Key (for autogenerate)
|
APTOITMKEY
|
Character
|
45
|
|
|
27.
|
Memo Field
|
APTOMEMO
|
Memo
|
|
|
|
28.
|
EFT Transaction
0 - Normal Transaction; 1 - EFT Transaction
|
APTOEFT
|
Numeric
|
1
|
R:0-1
|
|
29.
|
EFT Account Code
|
APTOEFTACT
|
CharCaps
|
3
|
|
|
30.
|
Comment Line
|
APTOCOMENT
|
Character
|
30
|
|
|
31.
|
Unique Check Comments Flag
|
APTOCOMETF
|
Numeric
|
1
|
R:0-1
|
|
32.
|
PO/Description
|
APTOPODESC
|
Character
|
30
|
|
|
33.
|
CC Payment Flag
|
APTOCCPMT
|
Numeric
|
1
|
|
|
34.
|
CC Vendor
|
APTOCCVEN
|
Character
|
20
|
|
|
35.
|
CC Reversal #
|
APTOCCREV
|
Character
|
15
|
|
|
36.*
|
Application User ID
|
APTOUSERID
|
CharCaps
|
3
|
|
|
37.*
|
Transaction Batch Description
|
APTOBATNUM
|
CharCaps
|
15
|
|
|
38.
|
Fund Number
|
APTOFUND
|
CharCaps
|
6
|
|
|
39.
|
AP Code
|
APTOAPCOD
|
CharCaps
|
6
|
|
|
40.
|
Year to Date Purchase
|
APTOYTDPUR
|
Numeric
|
15
|
(12.2) R:0->
|
|
41.
|
Year to Date Returns
|
APTOYTDRTN
|
Numeric
|
15
|
(12.2) R:0->
|
|
42.
|
Total Due
|
APTODUE
|
Numeric
|
15
|
(12.2) R:0->
|
|
43.
|
Vendor Name
|
APTOVNAME
|
CharCaps
|
35
|
|
| |
|
.jpg)
