# View: Payment G/L Distributions

RotoID: AP0037
Table: APTRK
DLL: APTRK

## Compositions: 0

## Keys: 2

Title | Fields
--- | ---
Bank / Batch / Entry | IDBANK, CNTBTCH, CNTENTRY, CNTLINE, CNTSEQ
Vendor / Document | IDVEND, IDINVC, CNTPAYM, IDRMIT, LONGSERIAL, TRXTYPE, CNTSEQOBP

## Fields: 121

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
IDBANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
CNTBTCH | 2 | BCD*5.0 | Batch Number | E A K R |
CNTENTRY | 3 | BCD*4.0 | Entry Number | E A K R |
CNTLINE | 4 | BCD*3.0 | Line Number | E A K R |
CNTSEQ | 5 | BCD*3.0 | Sequence No. | E A K R |
IDVEND | 6 | String*12 | Vendor Number | E A | Mask: %-12C
IDINVC | 7 | String*22 | Document Number | E A | Mask: %-22C
CNTPAYM | 8 | BCD*3.0 | Payment Number | E A |
IDRMIT | 9 | String*12 | Check Number | E A | Mask: %-12D
TRXTYPE | 10 | Integer | Document Type | E A |
CNTSEQOBP | 11 | BCD*3.0 | Applied Payment Sequence No. | E A |
DATEBTCH | 12 | Date | Batch Date | E A |
AMTDISTTC | 13 | BCD*10.3 | Vend. Distributed Amount | E A |
AMTDISTHC | 14 | BCD*10.3 | Func. Distributed Amount | E A |
IDDISTCODE | 15 | String*6 | Distribution Code | E A | Mask: %-6N
IDACCT | 16 | String*45 | G/L Account | E A | Mask: %-45C
TEXTGLREF | 17 | String*60 | G/L Reference | E A |
TEXTGLDESC | 18 | String*60 | G/L Description | E A |
CNTADJREF | 19 | BCD*5.0 | Adjustment Number | E A |
LONGSERIAL | 20 | Long | Check Serial Number | E A |
TAXCLASS1 | 21 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 22 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 23 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 24 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 25 | Integer | Tax Class 5 | E A |
SWTAXINCL1 | 26 | Integer | Tax Included 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL2 | 27 | Integer | Tax Included 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL3 | 28 | Integer | Tax Included 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL4 | 29 | Integer | Tax Included 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
SWTAXINCL5 | 30 | Integer | Tax Included 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXBSE1TC | 31 | BCD*10.3 | Tax Base 1 | E A |
TXBSE2TC | 32 | BCD*10.3 | Tax Base 2 | E A |
TXBSE3TC | 33 | BCD*10.3 | Tax Base 3 | E A |
TXBSE4TC | 34 | BCD*10.3 | Tax Base 4 | E A |
TXBSE5TC | 35 | BCD*10.3 | Tax Base 5 | E A |
RATETAX1 | 36 | BCD*8.5 | Tax Rate 1 | E A |
RATETAX2 | 37 | BCD*8.5 | Tax Rate 2 | E A |
RATETAX3 | 38 | BCD*8.5 | Tax Rate 3 | E A |
RATETAX4 | 39 | BCD*8.5 | Tax Rate 4 | E A |
RATETAX5 | 40 | BCD*8.5 | Tax Rate 5 | E A |
TXAMT1TC | 41 | BCD*10.3 | Tax Amount 1 | E A |
TXAMT2TC | 42 | BCD*10.3 | Tax Amount 2 | E A |
TXAMT3TC | 43 | BCD*10.3 | Tax Amount 3 | E A |
TXAMT4TC | 44 | BCD*10.3 | Tax Amount 4 | E A |
TXAMT5TC | 45 | BCD*10.3 | Tax Amount 5 | E A |
TXTOTTC | 46 | BCD*10.3 | Tax Total | E A |
AMTNETTC | 47 | BCD*10.3 | Dist. Amount Net of Taxes | E A |
AMTNETHC | 48 | BCD*10.3 | Func. Dist. Amount Net of Taxes | E A |
TXALLTC | 49 | BCD*10.3 | Tax Allocated Total | E A |
TXALL1TC | 50 | BCD*10.3 | Tax Allocated Amount 1 | E A |
TXALL2TC | 51 | BCD*10.3 | Tax Allocated Amount 2 | E A |
TXALL3TC | 52 | BCD*10.3 | Tax Allocated Amount 3 | E A |
TXALL4TC | 53 | BCD*10.3 | Tax Allocated Amount 4 | E A |
TXALL5TC | 54 | BCD*10.3 | Tax Allocated Amount 5 | E A |
TXREC1TC | 55 | BCD*10.3 | Tax Recoverable 1 | E A |
TXREC2TC | 56 | BCD*10.3 | Tax Recoverable 2 | E A |
TXREC3TC | 57 | BCD*10.3 | Tax Recoverable 3 | E A |
TXREC4TC | 58 | BCD*10.3 | Tax Recoverable 4 | E A |
TXREC5TC | 59 | BCD*10.3 | Tax Recoverable 5 | E A |
TXEXP1TC | 60 | BCD*10.3 | Tax Expensed 1 | E A |
TXEXP2TC | 61 | BCD*10.3 | Tax Expensed 2 | E A |
TXEXP3TC | 62 | BCD*10.3 | Tax Expensed 3 | E A |
TXEXP4TC | 63 | BCD*10.3 | Tax Expensed 4 | E A |
TXEXP5TC | 64 | BCD*10.3 | Tax Expensed 5 | E A |
TXAMT1RC | 65 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 66 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 67 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 68 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 69 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXTOTRC | 70 | BCD*10.3 | Tax Reporting Total | E A |
TXALLRC | 71 | BCD*10.3 | Tax Reporting Allocated Amount | E A |
TXREC1RC | 72 | BCD*10.3 | Tax Reporting Recoverable Amt 1 | E A |
TXREC2RC | 73 | BCD*10.3 | Tax Reporting Recoverable Amt 2 | E A |
TXREC3RC | 74 | BCD*10.3 | Tax Reporting Recoverable Amt 3 | E A |
TXREC4RC | 75 | BCD*10.3 | Tax Reporting Recoverable Amt 4 | E A |
TXREC5RC | 76 | BCD*10.3 | Tax Reporting Recoverable Amt 5 | E A |
TXEXP1RC | 77 | BCD*10.3 | Tax Reporting Expensed Amount 1 | E A |
TXEXP2RC | 78 | BCD*10.3 | Tax Reporting Expensed Amount 2 | E A |
TXEXP3RC | 79 | BCD*10.3 | Tax Reporting Expensed Amount 3 | E A |
TXEXP4RC | 80 | BCD*10.3 | Tax Reporting Expensed Amount 4 | E A |
TXEXP5RC | 81 | BCD*10.3 | Tax Reporting Expensed Amount 5 | E A |
TXBSE1HC | 82 | BCD*10.3 | Func. Tax Base 1 | E A |
TXBSE2HC | 83 | BCD*10.3 | Func. Tax Base 2 | E A |
TXBSE3HC | 84 | BCD*10.3 | Func. Tax Base 3 | E A |
TXBSE4HC | 85 | BCD*10.3 | Func. Tax Base 4 | E A |
TXBSE5HC | 86 | BCD*10.3 | Func. Tax Base 5 | E A |
TXAMT1HC | 87 | BCD*10.3 | Func. Tax Amount 1 | E A |
TXAMT2HC | 88 | BCD*10.3 | Func. Tax Amount 2 | E A |
TXAMT3HC | 89 | BCD*10.3 | Func. Tax Amount 3 | E A |
TXAMT4HC | 90 | BCD*10.3 | Func. Tax Amount 4 | E A |
TXAMT5HC | 91 | BCD*10.3 | Func. Tax Amount 5 | E A |
TXALLHC | 92 | BCD*10.3 | Func. Tax Allocated Total | E A |
TXALL1HC | 93 | BCD*10.3 | Func. Tax Allocated Amount 1 | E A |
TXALL2HC | 94 | BCD*10.3 | Func. Tax Allocated Amount 2 | E A |
TXALL3HC | 95 | BCD*10.3 | Func. Tax Allocated Amount 3 | E A |
TXALL4HC | 96 | BCD*10.3 | Func. Tax Allocated Amount 4 | E A |
TXALL5HC | 97 | BCD*10.3 | Func. Tax Allocated Amount 5 | E A |
TXREC1HC | 98 | BCD*10.3 | Func. Tax Recoverable 1 | E A |
TXREC2HC | 99 | BCD*10.3 | Func. Tax Recoverable 2 | E A |
TXREC3HC | 100 | BCD*10.3 | Func. Tax Recoverable 3 | E A |
TXREC4HC | 101 | BCD*10.3 | Func. Tax Recoverable 4 | E A |
TXREC5HC | 102 | BCD*10.3 | Func. Tax Recoverable 5 | E A |
TXEXP1HC | 103 | BCD*10.3 | Func. Tax Expensed 1 | E A |
TXEXP2HC | 104 | BCD*10.3 | Func. Tax Expensed 2 | E A |
TXEXP3HC | 105 | BCD*10.3 | Func. Tax Expensed 3 | E A |
TXEXP4HC | 106 | BCD*10.3 | Func. Tax Expensed 4 | E A |
TXEXP5HC | 107 | BCD*10.3 | Func. Tax Expensed 5 | E A |
TXTOTHC | 108 | BCD*10.3 | Func. Tax Total | E A |
CONTRACT | 109 | String*16 | Contract Code | E A | Mask: %-16C
PROJECT | 110 | String*16 | Project Code | E A | Mask: %-16N
CATEGORY | 111 | String*16 | Category Code | E A | Mask: %-16N
RESOURCE | 112 | String*24 | Project/Category Resource | E A P | Mask: %-16N
COSTCLASS | 113 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLTYPE | 114 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
IDITEM | 115 | String*16 | Item Number | E A | Mask: %-16C
UNITMEAS | 116 | String*10 | Unit of Measure | E A | Mask: %-10C
QTYINVC | 117 | BCD*10.5 | Quantity | E A |
AMTCOST | 118 | BCD*10.6 | Cost | E A |
BILLDATE | 119 | Date | Billing Date | E A |
BILLRATE | 120 | BCD*10.6 | Billing Rate | E A |
BILLCURN | 121 | String*3 | Billing Currency | E A | Mask: %-3N

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.