# Table: Posting Journal Generated AP Details

Table: APPJAID
View: AP0517
Record length: 575
Flags: A R

## Keys: 1

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

## Fields: 65

Field | Type | Title | Presentation
--- | --- | --- | ---
TYPEBTCH | String*2 | Batch Type | Mask: %-2N
POSTSEQNCE | BCD*5.0 | Posting Sequence No. |
CNTBTCH | BCD*5.0 | Batch No. |
CNTITEM | BCD*4.0 | Entry No. |
CNTSEQENCE | Long | Sequence No. |
GENTYPE | Integer | Generation Type | List: 1 entries
1 | = | AI to AP
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
COMPID | String*6 | Generated Company | Mask: %-6N
GCNTBTCH | BCD*5.0 | Generated Batch No. |
GCNTITEM | BCD*4.0 | Generated Entry No. |
GCNTLINE | BCD*3.0 | Generated Line No. |
CONTRACT | String*16 | Contract Code | Mask: %-16C
PROJECT | String*16 | Project Code | Mask: %-16N
CATEGORY | String*16 | Category Code | Mask: %-16N
COSTCLASS | Integer | Cost Class | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | String*24 | Project/Category Resource | Mask: %-16N
BILLDATE | Date | Billing Date |
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLCURN | String*3 | Billing Currency | Mask: %-3N
BILLRATE | BCD*10.6 | Billing Rate |
IDITEM | String*16 | Item Number | Mask: %-16C
AMTCOST | BCD*10.6 | Cost |
QTYINVC | BCD*10.5 | Quantity |
UNITMEAS | String*10 | Unit of Measure | Mask: %-10C
IDDIST | String*6 | Distribution Code | Mask: %-6N
TEXTDESC | String*60 | Description |
IDGLACCT | String*45 | G/L Account | Mask: %-45C
AMTDIST | BCD*10.3 | Distributed Amount |
AMTDISTNET | BCD*10.3 | Distributed Amount Before Taxes |
AMTINCLTAX | BCD*10.3 | Tax Amount Included in Price |
AMTTOTTAX | BCD*10.3 | Total Tax Amount |
AMTTAXTOBE | BCD*10.3 | Tax Amount to be Allocated |
TAXCLASS1 | Integer | Tax Class 1 |
TAXCLASS2 | Integer | Tax Class 2 |
TAXCLASS3 | Integer | Tax Class 3 |
TAXCLASS4 | Integer | Tax Class 4 |
TAXCLASS5 | Integer | Tax Class 5 |
SWTAXINCL1 | Integer | Tax Inclusive 1 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | Integer | Tax Inclusive 2 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | Integer | Tax Inclusive 3 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | Integer | Tax Inclusive 4 | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | Integer | Tax Inclusive 5 | List: 2 entries
0 | = | No
1 | = | Yes
RATETAX1 | BCD*8.5 | Tax Rate 1 |
RATETAX2 | BCD*8.5 | Tax Rate 2 |
RATETAX3 | BCD*8.5 | Tax Rate 3 |
RATETAX4 | BCD*8.5 | Tax Rate 4 |
RATETAX5 | BCD*8.5 | Tax Rate 5 |
AMTTAXREC1 | BCD*10.3 | Recoverable Tax Amount 1 |
AMTTAXREC2 | BCD*10.3 | Recoverable Tax Amount 2 |
AMTTAXREC3 | BCD*10.3 | Recoverable Tax Amount 3 |
AMTTAXREC4 | BCD*10.3 | Recoverable Tax Amount 4 |
AMTTAXREC5 | BCD*10.3 | Recoverable Tax Amount 5 |
AMTTAXEXP1 | BCD*10.3 | Expense Sep. Tax Amount 1 |
AMTTAXEXP2 | BCD*10.3 | Expense Sep. Tax Amount 2 |
AMTTAXEXP3 | BCD*10.3 | Expense Sep. Tax Amount 3 |
AMTTAXEXP4 | BCD*10.3 | Expense Sep. Tax Amount 4 |
AMTTAXEXP5 | BCD*10.3 | Expense Sep. Tax Amount 5 |
AMTTAX1 | BCD*10.3 | Tax Amount 1 |
AMTTAX2 | BCD*10.3 | Tax Amount 2 |
AMTTAX3 | BCD*10.3 | Tax Amount 3 |
AMTTAX4 | BCD*10.3 | Tax Amount 4 |
AMTTAX5 | BCD*10.3 | Tax Amount 5 |

This page was generated on 2009-Nov-19

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