Table: Payment G/L Distributions

Table: APTRK
View: AP0037
Record length: 1236
Flags: A R 

Keys: 2

Title  Flags  Fields

Bank / Batch / Entry  IDBANK, CNTBTCH, CNTENTRY, CNTLINE, CNTSEQ
Vendor / Document  D M  IDVEND, IDINVC, CNTPAYM, IDRMIT, LONGSERIAL, TRXTYPE, CNTSEQOBP

Fields: 125

Field  Type  Title  Presentation 

IDBANK  String*8  Bank Code  Mask: %-8N
CNTBTCH  BCD*5.0  Batch Number   
CNTENTRY  BCD*4.0  Entry Number   
CNTLINE  BCD*3.0  Line Number   
CNTSEQ  BCD*3.0  Sequence No.   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDVEND  String*12  Vendor Number  Mask: %-12C
IDINVC  String*22  Document Number  Mask: %-22C
CNTPAYM  BCD*3.0  Payment Number   
IDRMIT  String*12  Check Number  Mask: %-12D
TRXTYPE  Integer  Document Type   
CNTSEQOBP  BCD*3.0  Applied Payment Sequence No.   
DATEBTCH  Date  Batch Date   
AMTDISTTC  BCD*10.3  Vend. Distributed Amount   
AMTDISTHC  BCD*10.3  Func. Distributed Amount   
IDDISTCODE  String*6  Distribution Code  Mask: %-6N
IDACCT  String*45  G/L Account  Mask: %-45C
TEXTGLREF  String*60  G/L Reference   
TEXTGLDESC  String*60  G/L Description   
CNTADJREF  BCD*5.0  Adjustment Number   
LONGSERIAL  Long  Check Serial Number   
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 Included 1  List: 2 entries
0=No
1=Yes
SWTAXINCL2  Integer  Tax Included 2  List: 2 entries
0=No
1=Yes
SWTAXINCL3  Integer  Tax Included 3  List: 2 entries
0=No
1=Yes
SWTAXINCL4  Integer  Tax Included 4  List: 2 entries
0=No
1=Yes
SWTAXINCL5  Integer  Tax Included 5  List: 2 entries
0=No
1=Yes
TXBSE1TC  BCD*10.3  Tax Base 1   
TXBSE2TC  BCD*10.3  Tax Base 2   
TXBSE3TC  BCD*10.3  Tax Base 3   
TXBSE4TC  BCD*10.3  Tax Base 4   
TXBSE5TC  BCD*10.3  Tax Base 5   
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   
TXAMT1TC  BCD*10.3  Tax Amount 1   
TXAMT2TC  BCD*10.3  Tax Amount 2   
TXAMT3TC  BCD*10.3  Tax Amount 3   
TXAMT4TC  BCD*10.3  Tax Amount 4   
TXAMT5TC  BCD*10.3  Tax Amount 5   
TXTOTTC  BCD*10.3  Tax Total   
AMTNETTC  BCD*10.3  Dist. Amount Net of Taxes   
AMTNETHC  BCD*10.3  Func. Dist. Amount Net of Taxes   
TXALLTC  BCD*10.3  Tax Allocated Total   
TXALL1TC  BCD*10.3  Tax Allocated Amount 1   
TXALL2TC  BCD*10.3  Tax Allocated Amount 2   
TXALL3TC  BCD*10.3  Tax Allocated Amount 3   
TXALL4TC  BCD*10.3  Tax Allocated Amount 4   
TXALL5TC  BCD*10.3  Tax Allocated Amount 5   
TXREC1TC  BCD*10.3  Tax Recoverable 1   
TXREC2TC  BCD*10.3  Tax Recoverable 2   
TXREC3TC  BCD*10.3  Tax Recoverable 3   
TXREC4TC  BCD*10.3  Tax Recoverable 4   
TXREC5TC  BCD*10.3  Tax Recoverable 5   
TXEXP1TC  BCD*10.3  Tax Expensed 1   
TXEXP2TC  BCD*10.3  Tax Expensed 2   
TXEXP3TC  BCD*10.3  Tax Expensed 3   
TXEXP4TC  BCD*10.3  Tax Expensed 4   
TXEXP5TC  BCD*10.3  Tax Expensed 5   
TXAMT1RC  BCD*10.3  Tax Reporting Amount 1   
TXAMT2RC  BCD*10.3  Tax Reporting Amount 2   
TXAMT3RC  BCD*10.3  Tax Reporting Amount 3   
TXAMT4RC  BCD*10.3  Tax Reporting Amount 4   
TXAMT5RC  BCD*10.3  Tax Reporting Amount 5   
TXTOTRC  BCD*10.3  Tax Reporting Total   
TXALLRC  BCD*10.3  Tax Reporting Allocated Amount   
TXREC1RC  BCD*10.3  Tax Reporting Recoverable Amt 1   
TXREC2RC  BCD*10.3  Tax Reporting Recoverable Amt 2   
TXREC3RC  BCD*10.3  Tax Reporting Recoverable Amt 3   
TXREC4RC  BCD*10.3  Tax Reporting Recoverable Amt 4   
TXREC5RC  BCD*10.3  Tax Reporting Recoverable Amt 5   
TXEXP1RC  BCD*10.3  Tax Reporting Expensed Amount 1   
TXEXP2RC  BCD*10.3  Tax Reporting Expensed Amount 2   
TXEXP3RC  BCD*10.3  Tax Reporting Expensed Amount 3   
TXEXP4RC  BCD*10.3  Tax Reporting Expensed Amount 4   
TXEXP5RC  BCD*10.3  Tax Reporting Expensed Amount 5   
TXBSE1HC  BCD*10.3  Func. Tax Base 1   
TXBSE2HC  BCD*10.3  Func. Tax Base 2   
TXBSE3HC  BCD*10.3  Func. Tax Base 3   
TXBSE4HC  BCD*10.3  Func. Tax Base 4   
TXBSE5HC  BCD*10.3  Func. Tax Base 5   
TXAMT1HC  BCD*10.3  Func. Tax Amount 1   
TXAMT2HC  BCD*10.3  Func. Tax Amount 2   
TXAMT3HC  BCD*10.3  Func. Tax Amount 3   
TXAMT4HC  BCD*10.3  Func. Tax Amount 4   
TXAMT5HC  BCD*10.3  Func. Tax Amount 5   
TXALLHC  BCD*10.3  Func. Tax Allocated Total   
TXALL1HC  BCD*10.3  Func. Tax Allocated Amount 1   
TXALL2HC  BCD*10.3  Func. Tax Allocated Amount 2   
TXALL3HC  BCD*10.3  Func. Tax Allocated Amount 3   
TXALL4HC  BCD*10.3  Func. Tax Allocated Amount 4   
TXALL5HC  BCD*10.3  Func. Tax Allocated Amount 5   
TXREC1HC  BCD*10.3  Func. Tax Recoverable 1   
TXREC2HC  BCD*10.3  Func. Tax Recoverable 2   
TXREC3HC  BCD*10.3  Func. Tax Recoverable 3   
TXREC4HC  BCD*10.3  Func. Tax Recoverable 4   
TXREC5HC  BCD*10.3  Func. Tax Recoverable 5   
TXEXP1HC  BCD*10.3  Func. Tax Expensed 1   
TXEXP2HC  BCD*10.3  Func. Tax Expensed 2   
TXEXP3HC  BCD*10.3  Func. Tax Expensed 3   
TXEXP4HC  BCD*10.3  Func. Tax Expensed 4   
TXEXP5HC  BCD*10.3  Func. Tax Expensed 5   
TXTOTHC  BCD*10.3  Func. Tax Total   
CONTRACT  String*16  Contract Code  Mask: %-16C
PROJECT  String*16  Project Code  Mask: %-16N
CATEGORY  String*16  Category Code  Mask: %-16N
RESOURCE  String*24  Project/Category Resource  Mask: %-16N
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
IDITEM  String*16  Item Number  Mask: %-16C
UNITMEAS  String*10  Unit of Measure  Mask: %-10C
QTYINVC  BCD*10.5  Quantity   
AMTCOST  BCD*10.6  Cost   
BILLDATE  Date  Billing Date   
BILLRATE  BCD*10.6  Billing Rate   
BILLCURN  String*3  Billing Currency  Mask: %-3N

This page was generated on 2008-May-01

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