Table: Posting Journal Generated AP Entries

Table: APPJAIH
View: AP0516
Record length: 701
Flags: A R 

Keys: 1

Title  Flags  Fields

Posted Entry/Generated AP Entry  TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM

Fields: 77

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.   
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.   
TEXTTRX  Integer  Document Type  List: 4 entries
1=Invoice
2=Debit Note
3=Credit Note
4=Interest
IDTRX  Integer  Transaction Type  List: 5 entries
12=Invoice - Summary Entered
13=Invoice - Recurring Charge
22=Debit Note - Summary Entered
32=Credit Note - Summary Entered
40=Interest Charge
INVCDESC  String*60  Invoice Description   
IDVEND  String*12  Vendor Number  Mask: %-12C
CODEVNDGRP  String*6  Vendor Group Code  Mask: %-6N
IDACCTSET  String*6  Account Set  Mask: %-6N
IDRMITTO  String*6  Remit-To Location  Mask: %-6N
IDINVC  String*22  Document Number  Mask: %-22C
INVCAPPLTO  String*22  Apply-to Document  Mask: %-22C
ORDRNBR  String*22  Order Number  Mask: %-22C
PONBR  String*22  PO Number  Mask: %-22C
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
DATEINVC  Date  Invoice Date   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
HCODECURN  String*3  Currency Code (Functional)  Mask: %-3N
CODECURN  String*3  Currency Code (Source)  Mask: %-3N
RATETYPE  String*2  Rate Type  Mask: %-2N
CODEOPER  Integer  Rate Operator  List: 2 entries
1=Multiply
2=Divide
EXCHRATEHC  BCD*8.7  Exchange Rate   
DATERATE  Date  Rate Date   
TERMCODE  String*6  Terms  Mask: %-6N
DATEDUE  Date  Due Date   
DATEDISC  Date  Discount Date   
PCTDISC  BCD*5.5  Discount Percentage   
AMTDSCBASE  BCD*10.3  Discount Base   
AMTDISCAVL  BCD*10.3  Discount Amount Available   
AMTDSBWTAX  BCD*10.3  Discount Base With Tax   
AMTDSBNTAX  BCD*10.3  Discount Base Without Tax   
CODETAXGRP  String*12  Tax Group  Mask: %-12N
SWTAXBL  Integer  Taxable  List: 2 entries
0=No
1=Yes
SWCALCTX  Integer  Tax Amount Control  List: 3 entries
0=Enter
1=Calculate
2=Distribute
AMTINVCTOT  BCD*10.3  Document Total Before Taxes   
AMTGROSTOT  BCD*10.3  Document Total Including Tax   
AMTTAXTOT  BCD*10.3  Total Tax Amount   
AMTRECTAX  BCD*10.3  Recoverable Taxes   
AMTEXPTAX  BCD*10.3  Expensed Separately Taxes   
AMTAXTOBE  BCD*10.3  Tax Amount to be Allocated   
ID1099CLAS  String*6  1099/CPRS Code  Mask: %-6N
AMT1099  BCD*10.3  1099/CPRS Amount   
IDDISTSET  String*6  Distribution Set  Mask: %-6N
AMTDISTSET  BCD*10.3  Distribution Set Amount   
VALUES  Long  Optional Fields   
DATEBUS  Date  Posting Date   
CODETAX1  String*12  Tax Authority 1   
CODETAX2  String*12  Tax Authority 2   
CODETAX3  String*12  Tax Authority 3   
CODETAX4  String*12  Tax Authority 4   
CODETAX5  String*12  Tax Authority 5   
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
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   
VENDNAME  String*60  Vendor Name   
RMITNAME  String*60  Remit-To Name   

This page was generated on 2009-Nov-19

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