|
AP Open Item File: xxxAPITM.DBF (FUND Only)
|
Tag
|
Index
|
|
APITAPPLY
|
UPPER(APITVENDOR) + UPPER(APITAPPLY) + STR(APITATYPE,2,0) + UPPER(APITREF)
|
|
APITDATE
|
UPPER(APITVENDOR) + DTOS(APITDATE) + UPPER(APITREF) + STR(APITTYPE,2,0)
|
|
APITREF
|
UPPER(APITVENDOR) + UPPER(APITREF) + DTOS(APITDATE) + STR(APITTYPE,2,0)
|
|
APITVENDOR(U)
|
UPPER(APITVENDOR) + STR(APITTYPE,2,0) + DTOS(APITDATE) + UPPER(APITREF)
|
|
APITREF2
|
UPPER(APITREF) + DTOS(APITDATE) + STR(APITTYPE,2,0)
|
|
APITDISC
|
DTOS(APITDSDATE)
|
|
APITINVOIC
|
UPPER(APITVENDOR) + DTOS(APITDATE)
|
|
APITDATE2
|
DTOS(APITDATE) + UPPER(APITREF) + STR(APITTYPE,2,0)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.*
|
Vendor Number
|
APITVENDOR
|
CharCaps
|
20
|
|
|
2.*
|
Posting Reference/Invoice/Check #
|
APITREF
|
CharCaps
|
15
|
|
|
3.
|
Description
|
APITDES
|
Character
|
30
|
|
|
4.
|
PO Number
|
APITPONUM
|
CharCaps
|
20
|
|
|
5.*
|
Transaction Type
1=Invoice, 2=Credit Adjustment, 3=Payment Correction, 4=Payment, 5=Debit Adjustment, 6=Debit Invoice (Credit issued by Vendor - entered via Invoicing), 7=Unapplied Debit (Credit issued by Vendor - entered via Payments & Adjustments)
|
APITTYPE
|
Numeric
|
2
|
R:1-7
|
|
6.
|
Number of Dedicated Debit Lines
|
APITDRLINE
|
Numeric
|
3
|
|
|
7.
|
Total # of Detail Lines
|
APITLINES
|
Numeric
|
3
|
|
|
8.*
|
Invoice/Transaction Date
|
APITDATE
|
Date
|
|
R:block->fiscal end
|
|
9.
|
GL Date
|
APITGLDATE
|
Date
|
|
R:block->fiscal end
|
|
10.
|
Due Date
|
APITDUDATE
|
Date
|
|
|
|
11.
|
Discount Due Date
|
APITDSDATE
|
Date
|
|
|
|
12.
|
Original Amount
|
APITOAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
13.
|
Discount Amount
|
APITDAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
14.
|
Amount Remaining
|
APITRAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
15.
|
Unapplied Dedicated Remaining
|
APITUAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
16.
|
Total Charge Discount Dollars (Unused)
Total of all charge type invoice lines with the discount flag on (not adjustment line types).
|
APITCAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
17.
|
Paid Out Flag
|
APITPAID
|
Numeric
|
1
|
|
|
18.
|
BR Bank Code
|
APITBANK
|
CharCaps
|
3
|
|
|
19.
|
GL Cash Account
Field Length for Fund
|
APITCASH
|
CharCaps
|
30
45
|
|
|
20.
|
Apply To Reference
|
APITAPPLY
|
CharCaps
|
15
|
|
|
21.
|
Apply To Type
|
APITATYPE
|
Numeric
|
2
|
R: (See Types)
|
|
22.
|
Memo Field
|
APITMEMO
|
Memo
|
|
|
|
23.
|
Dr Amt that was applied to the Payment
|
APITUNPAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
24.
|
1099 Flag
|
APIT1099F
|
Numeric
|
1
|
|
|
25.
|
Check Comment
|
APITCOMENT
|
Character
|
30
|
|
|
26.
|
Check Comment Flag
|
APITCOMETF
|
Numeric
|
1
|
R:0-1
|
|
27.
|
CC Payment Flag
|
APITCCPMT
|
Numeric
|
1
|
|
|
28.*
|
Application User ID
|
APITUSERID
|
CharCaps
|
3
|
|
|
29.*
|
Transaction Batch Description
|
APITBATNUM
|
CharCaps
|
15
|
|
|
30.
|
Fund Number
|
APC_FUND
|
CharCaps
|
6
|
|
|
31.
|
Bank Account
|
APC_BKACT
|
CharCaps
|
3
|
|
| |
|
.jpg)
