|
AP Open Item Line Detail File: xxxAPITD.DBF
|
Tag
|
Index
|
|
APIDAPPLY
|
UPPER(APIDVENDOR) + DTOS(APIDUDATE) + UPPER(APIDREF) + DTOS(APIDDATE)
|
|
APIDGLEXP
|
UPPER(APIDGLEXP) + DTOS(APIDXDATE) + UPPER(APIDVENDOR) + UPPER(APIDREF) + DTOS(APIDDATE)
|
|
APIDSTKDES
|
UPPER(APIDSTKDES) + UPPER(APIDVENDOR) + UPPER(APIDREF) + DTOS(APIDDATE)
|
|
APIDVENDOR(U)
|
UPPER(APIDVENDOR) + UPPER(APIDREF) + DTOS(APIDDATE) + STR(APIDTYPE,2,0) + STR(APIDDETAIL,3,0)
|
|
APIDFUND
|
UPPER(APIDVENDOR)
|
|
APIDGLEX2
|
UPPER(APIDGLEXP) + DTOS(APIDXDATE) + UPPER(APIDVENDOR) + UPPER(APIDREF) + DTOS(APIDDATE)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.*
|
Vendor Number
|
APIDVENDOR
|
CharCaps
|
20
|
|
|
2.*
|
Detail Line Number
|
APIDDETAIL
|
Numeric
|
3
|
|
|
3.
|
Description / Stock Number
(Caps if Stock #)
|
APIDSTKDES
|
Character
|
40
|
|
|
4.
|
GL Expense (Debit) Account
Field Length for Fund
|
APIDGLEXP
|
CharCaps
|
30
45
|
|
|
5.
|
GL Prepaid Account
Field Length for Fund
|
APIDGLPREP
|
CharCaps
|
30
45
|
|
|
6.*
|
OPEN Posting Reference
|
APIDREF
|
CharCaps
|
15
|
|
|
7.*
|
OPEN Transaction Type
|
APIDTYPE
|
Numeric
|
2
|
|
|
8.*
|
OPEN Invoice/Tran Date
|
APIDDATE
|
Date
|
|
|
|
9.
|
Line Type
1=Direct Expense, 2=Prepaid Expense, 3=Future Liability, 4=Job Cost (Unused), 5=Inventory, 6=Landing, 7=Purchase Discount, 9=Allocation, 19=Allocation Adjustment.
If APIDJCACT=1 (Job Code Activated), Line Type is for Job Cost: 1=Material, 3=Subcontractor, 4=Miscellaneous, 5=Reverse Material, 7=Reverse Subcontractor, 8= Reverse Miscellaneous.
|
APIDLTYPE
|
Numeric
|
2
|
|
|
10.
|
Allow Discount
0=No, 1=Yes
|
APIDDISCOK
|
Numeric
|
1
|
|
|
11.
|
Discount Amount
|
APIDDISC
|
Numeric
|
15
|
(12.2) R:0->
|
|
12.
|
Expense Flag
|
APIDEXPENS
|
Numeric
|
1
|
|
|
13.
|
Expense Date
|
APIDXDATE
|
Date
|
|
|
|
14.
|
'Reference to Apply to' (for Unapp)
|
APIDUREF
|
CharCaps
|
15
|
|
|
15.
|
Date of 'Ref to Apply to' (Unapp)
|
APIDUDATE
|
Date
|
|
|
|
16.
|
Type (1-3) of ‘Ref To Apply to’
|
APIDUTYPE
|
Numeric
|
1
|
R:1-3
|
|
17.
|
Serialized Inventory Flag
|
APIDSER
|
Numeric
|
1
|
|
|
18.
|
Serial Number
|
APIDSERIAL
|
CharCaps
|
20
|
|
|
19.
|
Ending Serial Number (Unused)
|
APIDENDSER
|
CharCaps
|
20
|
|
|
20.
|
Job Cost Job Code
|
APIDJCJOB
|
CharCaps
|
20
|
|
|
21.
|
Job Cost Phase Number
|
APIDJCPHM
|
CharCaps
|
20
|
|
|
22.
|
Job Cost Cost Code
|
APIDJCCST
|
CharCaps
|
20
|
|
|
23.
|
Job Cost Activiated
|
APIDJCACT
|
Numeric
|
1
|
|
|
24.
|
Job Cost Detail Number
|
APIDJCDET
|
Numeric
|
6
|
R:1-999,999
|
|
25.
|
Quantity
|
APIDQTY
|
Numeric
|
14
|
(9.4) R:0->
|
|
26.
|
Cost Per Unit
|
APIDUNCOST
|
Numeric
|
14
|
(9.4) R:0->
|
|
27.
|
Original Amount
|
APIDOAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
28.
|
Amount Remaining
|
APIDRAMT
|
Numeric
|
15
|
(12.2) R:0->
|
|
29.
|
Landing Amount
|
APIDRCOST
|
Numeric
|
15
|
(12.2) R:0->
|
|
30.
|
MLI Location
Used for MLI only, left blank in all other cases
|
APIDLOC
|
CharCaps
|
20
|
|
|
31.
|
1099 Type
|
APID1099T
|
Numeric
|
2
|
|
|
32.
|
Original Amount
|
APID1099TX
|
Numeric
|
15
|
(12.2) R:0->
|
| |
|
.jpg)
