View: Open Document Details

RotoID: AP0200
Table: APOBLJ
Protocol: Flat
DLL:APOBLJ

Keys: 1

Title Fields
Vend. No./Doc. No./Line No. IDVEND, IDINVC, CNTLINE

Fields: 72

Field Index Type Title Attributes Presentation
IDVEND 1 String*12 Vendor Number E A K R  Mask: %-12C
IDINVC 2 String*22 Document Number E A K R  Mask: %-22C
CNTLINE 3 BCD*3.0 Line Number E A K R 
CONTRACT 4 String*16 Contract Code E A  Mask: %-16C
PROJECT 5 String*16 Project Code E A  Mask: %-16N
CATEGORY 6 String*16 Category Code E A  Mask: %-16N
RESOURCE 7 String*24 Project/Category Resource E A P  Mask: %-16N
TRANSNBR 8 Long Transaction Number E A 
COSTCLASS 9 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
IDDIST 10 String*6 Distribution Code E A  Mask: %-6N
IDGLACCT 11 String*45 G/L Account E A  Mask: %-45C
BILLTYPE 12 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
AMTINVCHC 13 BCD*10.3 Func. Currency Invoice Amount E A 
AMTDUEHC 14 BCD*10.3 Func. Currency Amount Due E A 
AMTINVCTC 15 BCD*10.3 Vend. Currency Invoice Amount E A 
AMTDUETC 16 BCD*10.3 Vend. Currency Amount Due E A 
IDITEM 17 String*16 Item Number E A  Mask: %-16C
UNITMEAS 18 String*10 Unit of Measure E A  Mask: %-10C
QTYINVC 19 BCD*10.5 Quantity E A 
AMTCOST 20 BCD*10.6 Cost E A 
BILLDATE 21 Date Billing Date E A 
BILLRATE 22 BCD*10.6 Billing Rate E A 
BILLCURN 23 String*3 Billing Currency E A  Mask: %-3N
SWDISCABL 24 Integer Discountable E A  List:2 entries
0 = No
1 = Yes
RTGDATEDUE 25 Date Date Retainage Due E A 
RTGOAMTHC 26 BCD*10.3 Func. Curr. Orig. Rtng. Amt. E A 
RTGAMTHC 27 BCD*10.3 Func. Curr. Retainage Amount E A 
RTGOAMTTC 28 BCD*10.3 Vend. Curr. Orig. Rtng. Amt. E A 
RTGAMTTC 29 BCD*10.3 Vend. Curr. Retainage Amount E A 
VALUES 30 Long Optional Fields E A 
RTGDISTTC 31 BCD*10.3 Retainage Distribution Amount E A 
TAXCLASS1 32 Integer Tax Class 1 E A 
TAXCLASS2 33 Integer Tax Class 2 E A 
TAXCLASS3 34 Integer Tax Class 3 E A 
TAXCLASS4 35 Integer Tax Class 4 E A 
TAXCLASS5 36 Integer Tax Class 5 E A 
SWTAXINCL1 37 Integer Tax Included 1 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL2 38 Integer Tax Included 2 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL3 39 Integer Tax Included 3 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL4 40 Integer Tax Included 4 E A  List:2 entries
0 = No
1 = Yes
SWTAXINCL5 41 Integer Tax Included 5 E A  List:2 entries
0 = No
1 = Yes
TXRATE1 42 BCD*8.5 Tax Rate 1 E A 
TXRATE2 43 BCD*8.5 Tax Rate 2 E A 
TXRATE3 44 BCD*8.5 Tax Rate 3 E A 
TXRATE4 45 BCD*8.5 Tax Rate 4 E A 
TXRATE5 46 BCD*8.5 Tax Rate 5 E A 
TXBSERT1TC 47 BCD*10.3 Vend. Retainage Tax Base 1 E A 
TXBSERT2TC 48 BCD*10.3 Vend. Retainage Tax Base 2 E A 
TXBSERT3TC 49 BCD*10.3 Vend. Retainage Tax Base 3 E A 
TXBSERT4TC 50 BCD*10.3 Vend. Retainage Tax Base 4 E A 
TXBSERT5TC 51 BCD*10.3 Vend. Retainage Tax Base 5 E A 
TXAMTRT1TC 52 BCD*10.3 Vend. Retainage Tax Amount 1 E A 
TXAMTRT2TC 53 BCD*10.3 Vend. Retainage Tax Amount 2 E A 
TXAMTRT3TC 54 BCD*10.3 Vend. Retainage Tax Amount 3 E A 
TXAMTRT4TC 55 BCD*10.3 Vend. Retainage Tax Amount 4 E A 
TXAMTRT5TC 56 BCD*10.3 Vend. Retainage Tax Amount 5 E A 
TXAMTRT1HC 57 BCD*10.3 Func. Retainage Tax Amount 1 E A 
TXAMTRT2HC 58 BCD*10.3 Func. Retainage Tax Amount 2 E A 
TXAMTRT3HC 59 BCD*10.3 Func. Retainage Tax Amount 3 E A 
TXAMTRT4HC 60 BCD*10.3 Func. Retainage Tax Amount 4 E A 
TXAMTRT5HC 61 BCD*10.3 Func. Retainage Tax Amount 5 E A 
TXALLRTHC 62 BCD*10.3 Func. Retainage Tax Allocated E A 
TXALLRTTC 63 BCD*10.3 Vend. Retainage Tax Allocated E A 
TXEXPRTHC 64 BCD*10.3 Func. Retainage Tax Expensed E A 
TXEXPRTTC 65 BCD*10.3 Vend. Retainage Tax Expensed E A 
TXALLACCT 66 String*45 Allocated Tax Account E A  Mask: %-45C
CNTLASTSEQ 67 Long Last Applied Payment Seq. No. E A 
OAMTWHT1TC 68 BCD*10.3 Orig Est Tax Withheld Amount 1 E A 
OAMTWHT2TC 69 BCD*10.3 Orig Est Tax Withheld Amount 2 E A 
OAMTWHT3TC 70 BCD*10.3 Orig Est Tax Withheld Amount 3 E A 
OAMTWHT4TC 71 BCD*10.3 Orig Est Tax Withheld Amount 4 E A 
OAMTWHT5TC 72 BCD*10.3 Orig Est Tax Withheld Amount 5 E A 

This page was generated on 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).