SO_DailyDepositRecapWrk SO Daily Deposit Recap Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: SO_SalesJournal_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/SO"+%C$+"/SO_DailyDepositRecapWrk"+%S$+".M4T"
KPRIMARY: ARDivisionNo+PaymentType+InvoiceNo
Fld Column Name M/L TUR Description/Notes Class
1 GroupField. . . . . . . . . . 6 SNN Group Field . . . . . . . . . . 2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION Mask:00 3 ARDivisionDesc. . . . . . . . 30 SNN AR Division Description . . . .DESCRIPTION 4 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO 5 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . . 6 InvoiceType . . . . . . . . . 2 SNN Invoice Type. . . . . . . . . . 7 PaymentType . . . . . . . . . 6 SNN Payment Type. . . . . . . . . . 8 PaymentDesc . . . . . . . . . 30 SNN Payment Description . . . . . . 9 PaymentMethod . . . . . . . . 1 SNN Payment Method. . . . . . . . . 10 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE 11 BillToName. . . . . . . . . . 30 SNN Bill To Name. . . . . . . . . . 12 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . . 13 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . . 14 ExpirationDateYear. . . . . . 2 SNN Expiration Date Year. . . . . .YEAR2 15 OtherPaymentTypeRefNo . . . . 24 SNN Other Payment Type Reference Nu 16 CheckNoForDeposit . . . . . . 10 SNN Check Number For Deposit. . . .CHECKNO 17 AuthorizationCodeForDeposit . 16 SNN Authorization CodeFor Deposit . 18 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 19 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe 20 InvoiceAmt. . . . . . . . . . 13.2 NNN InvoiceAmount . . . . . . . . .AMOUNT Mask:###,###,###.00 21 DepositApplied. . . . . . . . 13.2 NNN Deposit Applied . . . . . . . .AMOUNT Mask:###,###,###.00 22 PaymentApplied. . . . . . . . 13.2 NNN Payment Applied . . . . . . . .AMOUNT Mask:###,###,###.00