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.