Table: Applied Payments

Table: APTCP
View: AP0033
Record Length: 567

Flags: A R 

Keys: 3

Title Flags Fields

Batch Number / Entry Number BATCHTYPECNTBTCHCNTRMITCNTLINE
Vendor Number / Document Number D M  IDVENDIDINVCCNTPAYM
Batch Type / Batch Number M  BATCHTYPECNTBTCHCNTRMITIDINVCCNTPAYM

Fields: 56

Field Type Title Presentation

BATCHTYPE String*2 Batch Type Mask: %-2N
CNTBTCH BCD*5.0 Batch Number
CNTRMIT BCD*4.0 Entry Number
CNTLINE BCD*3.0 Line Number
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
TRXTYPE Integer Transaction Type List:3 entries
51 = Payment - Posted
57 = Prepayment - Posted
81 = Adjustment - Posted
PYMTRESL String*2 Payment Resolution Mask: %-2N
AMTPAYM BCD*10.3 Payment Amount
AMTERNDISC BCD*10.3 Discount Amount Taken
CNTLASTSEQ BCD*3.0 Next Adj. Seq. No.
AMTADJTOT BCD*10.3 Adjustments Total
CNTADJ BCD*5.0 Generated Adjustment Number
TEXTADJ String*60 Description
GLREF String*60 Reference
IDPPD String*22 Generated PP No. Mask: %-22C
IDDOCMTCH String*22 PP Matching Doc. No. Mask: %-22C
CDAPPLYTO Integer PP Matching Doc. Type List:4 entries
1 = (None)
2 = Document Number
3 = PO Number
4 = Order Number
DATEACTVPP Date Activation Date
ADJTOTDBTC BCD*10.3 Adj. Debit Amt. - Vend. Curr
ADJTOTCRTC BCD*10.3 Adj. Credit Amt. - Vend. Curr
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
AMTPAYMTOT BCD*10.3 Job Total Payment Amount
AMTDISCTOT BCD*10.3 Job Total Discount Amount
APPLYMETH Integer Job Apply Method List:2 entries
0 = Prorate by Amount
1 = Top Down
RTGTOTDBTC BCD*10.3 Rtg. Debit Amt. - Vend. Curr
RTGTOTCRTC BCD*10.3 Rtg. Credit Amt. - Vend. Curr
RTGAMT BCD*10.3 Retainage Amount
RTGDATEDUE Date Retainage Due Date
RTGTERMS String*6 Retainage Terms Code Mask: %-6N
SWRTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
AMTPAYMHC BCD*10.3 Func. Payment Amount
AMTDISCHC BCD*10.3 Func. Discount Amount
AMTADJHC BCD*10.3 Func. Adjustments Total
RTGAMTHC BCD*10.3 Func. Retainage Amount
DOCTYPE Integer Document Type
AMTWHD1TC BCD*10.3 Vend. Tax Withheld Amount 1
AMTWHD2TC BCD*10.3 Vend. Tax Withheld Amount 2
AMTWHD3TC BCD*10.3 Vend. Tax Withheld Amount 3
AMTWHD4TC BCD*10.3 Vend. Tax Withheld Amount 4
AMTWHD5TC BCD*10.3 Vend. Tax Withheld Amount 5
AMTWHD1HC BCD*10.3 Func. Tax Withheld Amount 1
AMTWHD2HC BCD*10.3 Func. Tax Withheld Amount 2
AMTWHD3HC BCD*10.3 Func. Tax Withheld Amount 3
AMTWHD4HC BCD*10.3 Func. Tax Withheld Amount 4
AMTWHD5HC BCD*10.3 Func. Tax Withheld Amount 5
AMTWHD1DT BCD*10.3 Job Total Tax Withheld Amt 1
AMTWHD2DT BCD*10.3 Job Total Tax Withheld Amt 2
AMTWHD3DT BCD*10.3 Job Total Tax Withheld Amt 3
AMTWHD4DT BCD*10.3 Job Total Tax Withheld Amt 4
AMTWHD5DT BCD*10.3 Job Total Tax Withheld Amt 5