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