Table: Payments/Adjustments

Table: APTCR
View: AP0031
Record length: 1676
Flags: A R 

Keys: 1

Title  Flags  Fields

Batch Payments Primary Key  BTCHTYPE, CNTBTCH, CNTENTR

Fields: 155

Field  Type  Title  Presentation 

BTCHTYPE  String*2  Batch Type  Mask: %-2N
CNTBTCH  BCD*5.0  Batch Number   
CNTENTR  BCD*4.0  Entry Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
IDRMIT  String*12  Check Number  Mask: %-12D
IDVEND  String*12  Vendor Number  Mask: %-12C
DATERMIT  Date  Payment Date/Adjustment Date   
TEXTRMIT  String*60  Entry Description   
NAMERMIT  String*60  Vendor / Payee Name   
AMTRMIT  BCD*10.3  Check Amount in Bank Curr.   
AMTRMITTC  BCD*10.3  Check Amount in Vendor Curr.   
RATEEXCHTC  BCD*8.7  Vendor Exchange Rate   
SWRATETC  Integer  Vendor Rate Overridden  List: 2 entries
0=No
1=Yes
CNTPAYMENT  BCD*3.0  Number of Payments Entered   
AMTPPAYTC  BCD*10.3  Total Prepay Vendor Curr.   
AMTDISCTC  BCD*10.3  Total Discount Vendor Curr.   
PAYMCODE  String*12  Payment Code  Mask: %-12N
CODECURN  String*3  Vendor Currency Code  Mask: %-3N
RATETYPEHC  String*2  Bank Rate Type  Mask: %-2N
RATEEXCHHC  BCD*8.7  Bank Exchange Rate   
SWRATEHC  Integer  Bank Rate Overridden  List: 2 entries
0=No
1=Yes
RMITTYPE  Integer  Payment Trans. Type  List: 5 entries
1=Payment
2=Prepayment
3=Apply Document
4=Misc. Payment
5=Adjustment
DOCTYPE  Integer  Document Type  List: 6 entries
1=(None)
2=Document Number
3=PO Number
4=Order Number
5=Prepayment
7=Credit Note
CNTLSTLINE  BCD*3.0  Last Line Number   
FISCYR  String*4  Fiscal Year  Mask: %04D
FISCPER  String*2  Fiscal Period  Mask: %02D
DATERATETC  Date  Vendor Rate Date   
RATETYPETC  String*2  Vendor Rate Type  Mask: %-2N
AMTADJTCUR  BCD*10.3  Total Payment Adj. Vendor Curr.   
DATERATEHC  Date  Bank Rate Date   
REMREAPLTC  BCD*10.3  Total Reapply Remaining Vendor Curr.   
ADJTOTDBHC  BCD*10.3  Adj. Debit Amt. Func. Curr.   
AMTRMITHC  BCD*10.3  Check Amount Func. Curr.   
DOCNBR  String*22  Document Number  Mask: %-22C
PAYMSTTS  Integer  Payment Edited  List: 3 entries
0=No
1=Yes
2=Deleted
SWPRNTRMIT  Integer  Check Print Required  List: 2 entries
0=No
1=Yes
IDRMITTO  String*6  Vendor Remit-To Location  Mask: %-6N
TXTRMITREF  String*60  Entry Reference   
ADJTOTCRHC  BCD*10.3  Adj. Credit Amt. Func. Curr.   
AMTADJHCUR  BCD*10.3  Total Adj. Amt. Func. Curr.   
CNTDEPSSEQ  Long  Check Sequence No.   
SWPRINTED  Integer  Check Printed Status  List: 2 entries
0=Not printed
1=Printed
TEXTSTRE1  String*60  Address Line 1   
TEXTSTRE2  String*60  Address Line 2   
TEXTSTRE3  String*60  Address Line 3   
TEXTSTRE4  String*60  Address Line 4   
NAMECITY  String*30  City   
CODESTTE  String*30  State   
CODEPSTL  String*20  Zip/Postal Code   
CODECTRY  String*30  Country   
CHECKLANG  String*3  Payment Language  List: 7 entries
1=ENG
2=FRA
3=ESN
4=AUS
5=MEX
6=CHN
7=CHT
OPERBANK  Integer  Bank Rate Operator  List: 2 entries
1=Multiply
2=Divide
OPERVEND  Integer  Vendor Rate Operator  List: 2 entries
1=Multiply
2=Divide
ADJTOTDBTC  BCD*10.3  Adj. Debit Amt. Vendor Curr.   
ADJTOTCRTC  BCD*10.3  Adj. Credit Amt. Vendor Curr.   
DATEACTVPP  Date  Prepay Activation Date   
SWJOB  Integer  Job Related  List: 2 entries
0=No
1=Yes
APPLYMETH  Integer  Job Apply Method  List: 2 entries
0=Prorate by Amount
1=Top Down
ERRBATCH  Long  Error Batch   
ERRENTRY  Long  Error Entry   
IDINVCMTCH  String*22  Matching Document Number  Mask: %-22C
VALUES  Long  Optional Fields   
SRCEAPPL  String*2  Source Application  Mask: %-2A
IDBANK  String*8  Bank Code  Mask: %-8N
CODECURNBC  String*3  Bank Currency Code  Mask: %-3N
PAYMTYPE  Integer  Payment Type  List: 5 entries
0=
1=Cash
2=Check
3=Credit Card
4=Other
CCTYPE  String*12  C.C. Type  Mask: %-12N
CCNUMBER  Binary*32  Encrypted C.C. Number   
CCNAME  String*60  C.C. Name   
CCEXP  Date  C.C. Expiry Date   
CCAUTHCODE  String*20  C.C. Auth. Code   
CASHACCT  String*45  Cash Account  Mask: %-45C
DRILLAPP  String*2  Drill Down Application Source  Mask: %-2A
DRILLTYPE  Integer  Drill Down Type   
DRILLDWNLK  BCD*10.0  Drill Down Link Number   
CODE1099  String*6  1099/CPRS Code  Mask: %-6N
AMT1099  BCD*10.3  1099/CPRS Amount   
SWTXAMTCTL  Integer  Calculate Tax Amount Control  List: 3 entries
0=Enter
1=Calculate
2=Distribute
SWTXBSECTL  Integer  Calculate Tax Base Control  List: 3 entries
0=Enter
1=Calculate
2=Distribute
CODETAXGRP  String*12  Tax Group  Mask: %-12N
TAXVERSION  Long  Tax State Version   
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 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   
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   
TXALLTC  BCD*10.3  Tax Allocated Total   
TXEXPTC  BCD*10.3  Tax Expensed Total   
TXRECTC  BCD*10.3  Tax Recoverable Total   
CODECURNRC  String*3  Tax Reporting Currency Code  Mask: %-3N
SWTXCTLRC  Integer  Tax Reporting Calculate Method  List: 3 entries
0=Enter
1=Calculate
2=Distribute
RATERC  BCD*8.7  Tax Reporting Exchange Rate   
RATETYPERC  String*2  Tax Reporting Rate Type  Mask: %-2N
RATEDATERC  Date  Tax Reporting Rate Date   
RATEOPRC  Integer  Tax Reporting Rate Operator  List: 2 entries
1=Multiply
2=Divide
SWRATERC  Integer  Tax Reporting Rate Override  List: 2 entries
0=No
1=Yes
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 Total   
TXEXPRC  BCD*10.3  Tax Reporting Expensed Total   
TXRECRC  BCD*10.3  Tax Reporting Recoverable Total   
AMTPPAYHC  BCD*10.3  Total Prepay Func. Curr.   
AMTDISCHC  BCD*10.3  Total Discount Func. Curr.   
REMREAPLHC  BCD*10.3  Total Reapply Remaining Func. Curr.   
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   
TXTOTHC  BCD*10.3  Func. Tax Total   
AMTNETHC  BCD*10.3  Func. Dist. Amount Net of Taxes   
TXALLHC  BCD*10.3  Func. Tax Allocated Total   
TXEXPHC  BCD*10.3  Func. Tax Expensed Total   
TXRECHC  BCD*10.3  Func. Tax Recoverable Total   
APVERSION  String*3  A/P Version Created In   
CNTACC  Long  Number of Advance Credit Claims   
AMTACCTC  BCD*10.3  Total Advance Credit Claim   
AMTACCHC  BCD*10.3  Func. Total Advance Credit Claim   
ENTEREDBY  String*8  Entered By   
DATEBUS  Date  Posting Date   
IDACCTSET  String*6  Account Set  Mask: %-6N

This page was generated on 2008-May-01

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