# View: Posting Journal Generated AP Details

RotoID: AP0517
Table: APPJAID
Protocol: Flat
DLL: APPJAID

## Compositions: 0

## Keys: 1

Title | Fields
--- | ---
Posted Detail/Generated AP Detai | TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM, CNTSEQENCE, GENTYPE

## Fields: 61

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
TYPEBTCH | 1 | String*2 | Batch Type | E A K R | Mask: %-2N
POSTSEQNCE | 2 | BCD*5.0 | Posting Sequence No. | E A K R |
CNTBTCH | 3 | BCD*5.0 | Batch No. | E A K R |
CNTITEM | 4 | BCD*4.0 | Entry No. | E A K R |
CNTSEQENCE | 5 | Long | Sequence No. | E A K R |
GENTYPE | 6 | Integer | Generation Type | E A K R | List: 1 entries
1 | = | AI to AP
COMPID | 7 | String*6 | Generated Company | E A | Mask: %-6N
GCNTBTCH | 8 | BCD*5.0 | Generated Batch No. | E A |
GCNTITEM | 9 | BCD*4.0 | Generated Entry No. | E A |
GCNTLINE | 10 | BCD*3.0 | Generated Line No. | E A |
CONTRACT | 11 | String*16 | Contract Code | E A | Mask: %-16C
PROJECT | 12 | String*16 | Project Code | E A | Mask: %-16N
CATEGORY | 13 | String*16 | Category Code | E A | Mask: %-16N
COSTCLASS | 14 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | 15 | String*24 | Project/Category Resource | E A | Mask: %-16N
BILLDATE | 16 | Date | Billing Date | E A |
BILLTYPE | 17 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLCURN | 18 | String*3 | Billing Currency | E A | Mask: %-3N
BILLRATE | 19 | BCD*10.6 | Billing Rate | E A |
IDITEM | 20 | String*16 | Item Number | E A | Mask: %-16C
AMTCOST | 21 | BCD*10.6 | Cost | E A |
QTYINVC | 22 | BCD*10.5 | Quantity | E A |
UNITMEAS | 23 | String*10 | Unit of Measure | E A | Mask: %-10C
IDDIST | 24 | String*6 | Distribution Code | E A | Mask: %-6N
TEXTDESC | 25 | String*60 | Description | E A |
IDGLACCT | 26 | String*45 | G/L Account | E A | Mask: %-45C
AMTDIST | 27 | BCD*10.3 | Distributed Amount | E A |
AMTDISTNET | 28 | BCD*10.3 | Distributed Amount Before Taxes | E A |
AMTINCLTAX | 29 | BCD*10.3 | Tax Amount Included in Price | E A |
AMTTOTTAX | 30 | BCD*10.3 | Total Tax Amount | E A |
AMTTAXTOBE | 31 | BCD*10.3 | Tax Amount to be Allocated | E A |
TAXCLASS1 | 50 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 51 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 52 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 53 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 54 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 55 | Integer | Tax Inclusive 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 56 | Integer | Tax Inclusive 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 57 | Integer | Tax Inclusive 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 58 | Integer | Tax Inclusive 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 59 | Integer | Tax Inclusive 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
RATETAX1 | 60 | BCD*8.5 | Tax Rate 1 | E A |
RATETAX2 | 61 | BCD*8.5 | Tax Rate 2 | E A |
RATETAX3 | 62 | BCD*8.5 | Tax Rate 3 | E A |
RATETAX4 | 63 | BCD*8.5 | Tax Rate 4 | E A |
RATETAX5 | 64 | BCD*8.5 | Tax Rate 5 | E A |
AMTTAXREC1 | 65 | BCD*10.3 | Recoverable Tax Amount 1 | E A |
AMTTAXREC2 | 66 | BCD*10.3 | Recoverable Tax Amount 2 | E A |
AMTTAXREC3 | 67 | BCD*10.3 | Recoverable Tax Amount 3 | E A |
AMTTAXREC4 | 68 | BCD*10.3 | Recoverable Tax Amount 4 | E A |
AMTTAXREC5 | 69 | BCD*10.3 | Recoverable Tax Amount 5 | E A |
AMTTAXEXP1 | 70 | BCD*10.3 | Expense Sep. Tax Amount 1 | E A |
AMTTAXEXP2 | 71 | BCD*10.3 | Expense Sep. Tax Amount 2 | E A |
AMTTAXEXP3 | 72 | BCD*10.3 | Expense Sep. Tax Amount 3 | E A |
AMTTAXEXP4 | 73 | BCD*10.3 | Expense Sep. Tax Amount 4 | E A |
AMTTAXEXP5 | 74 | BCD*10.3 | Expense Sep. Tax Amount 5 | E A |
AMTTAX1 | 75 | BCD*10.3 | Tax Amount 1 | E A |
AMTTAX2 | 76 | BCD*10.3 | Tax Amount 2 | E A |
AMTTAX3 | 77 | BCD*10.3 | Tax Amount 3 | E A |
AMTTAX4 | 78 | BCD*10.3 | Tax Amount 4 | E A |
AMTTAX5 | 79 | BCD*10.3 | Tax Amount 5 | E A |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.