AP_CheckHistoryHeader AP Check History Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AP_PaymentHistory_bus,AP_CheckRegister_upd,AP_ManualCheckRegister_upd,PO_ReceiptRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/AP"+%C$+"/AP_CheckHistoryHeader.M4T"
KPRIMARY: BankCode+CheckNo+CheckSeqNo KVENDOR: APDivisionNo+VendorNo+BankCode+CheckNo+CheckSeqNo KVENDORNAME: VendorName+BankCode+CheckNo+CheckSeqNo KCHECKDATE: CheckDate+BankCode+CheckNo+CheckSeqNo
Fld Column Name M/L TUR Description/Notes Class
1 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE Notes: {AP_15$(1,1)} 2 CheckNo . . . . . . . . . . . 10 SYY AP Check Number . . . . . . . .APCHECKNO Notes: {AP_15$(2,6)} 3 CheckSeqNo. . . . . . . . . . 6 SYY Check Sequence Number . . . . . Mask:000000 FmtType:ZEROFILL Notes: {AP_15$(8,1)} 4 CheckType . . . . . . . . . . 1 SYN Check Type. . . . . . . . . . . Valid:A,C,M,R,V Notes: A=Auto, C=CreditCard, M=Manual, R=Reversal, V=Voided {AP_15$(9,1)} 5 CheckDate . . . . . . . . . . 8 SNN Check Date. . . . . . . . . . .DATE Notes: {AP_15$(10,6)} 6 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 FmtType:ZEROFILL Notes: {AP_15$(16,2)} 7 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ Notes: {AP_15$(18,7)} 8 VendorName. . . . . . . . . . 30 SNY Vendor Name . . . . . . . . . .NAME Notes: {AP_15$(25,30)} 9 SourceJournal . . . . . . . . 2 SNN Source Journal. . . . . . . . .SOURCEJOURNAL Notes: {AP_15$(55,2)} 10 SourceJournalBatchNo. . . . . 6 SNN Source Journal Batch Number . . Mask:000000 Notes: {AP_15$(57 ,4)} 11 CheckComment. . . . . . . . . 40 SNN Check Comment . . . . . . . . . Notes: {AP_15$(61,40)} 12 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE Notes: {AP_15$(101,6)} 13 TransferAPDivisionNo. . . . . 2 SNN Transfer AP Division Number. .APDIVISION Mask:00 FmtType:ZEROFILL 14 TransferVendorNo. . . . . . . 7 SYN Transfer Vendor Number. . . . .VENDORNO FmtType:MASTERNUM 15 TransferInvoiceNo . . . . . . 10 SNN Transfer AP Invoice Number. . .APINVOICE 16 TransferInvoiceDate . . . . . 8 SNN Transfer Invoice Date . . . . .DATE 17 TransferForm1099. . . . . . . 1 SNN Transfer Form 1099. . . . . . . 18 TransferBox1099 . . . . . . . 3 SNN Transfer Box 1099 . . . . . . . 19 TransferDiscountAmt . . . . . 13.2 NNN Transfer Discount Amount. . . .AMOUNT Mask:###,###,###.00 20 CheckAmt. . . . . . . . . . . 13.2 NNN Check Amount. . . . . . . . . .AMOUNT Mask:###,###,###.00- Notes: {AP_15[0]} 21 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 22 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y 23 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000