AR_DepositHistoryWrk AR Deposit History Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_DepositTransactionReport_rpt
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_DepositHistoryWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . .
2 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . .PAYMENTTYPE
3 PaymentDesc . . . . . . . . . 30 SNN Payment Description . . . . . .
4 InvoiceNo . . . . . . . . . . 7 SNN Invoice Number. . . . . . . . .INVOICE
5 SequenceNo. . . . . . . . . . 6 SNN Sequence Number . . . . . . . .
6 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . .ARDIVISION
Mask:00
7 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
8 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .
9 OpenItemCustomer. . . . . . . 1 SNN Open Item Customer. . . . . . .
10 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE
11 InvoiceDate . . . . . . . . . 8 SNN Invoice Date. . . . . . . . . .DATE
12 SalesOrderNo. . . . . . . . . 7 SNN Sales Order Number. . . . . . .SALESORDERNO
13 ReferenceNo . . . . . . . . . 24 SNN Reference Number. . . . . . . .
14 CheckNo . . . . . . . . . . . 10 SNN Check Number. . . . . . . . . .CHECKNO
15 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card
16 FullCreditCardNo. . . . . . . 24 SNN Full Credit Card Number . . . .
17 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . .
18 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . .
19 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe
20 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . .
21 TransactionAmt. . . . . . . . 13.2 NNN Transaction Amount. . . . . . .AMOUNT
Mask:###,###,###.00