AR_CashReceiptsDeposit AR Cash Receipts Deposit Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CashReceiptsDeposit_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsDeposit.M4T"
KPRIMARY: DepositNo
KBATCH: BatchNo+DepositNo
Fld Column Name M/L TUR Description/Notes Class
1 DepositNo . . . . . . . . . . 5 SYY Deposit Number. . . . . . . . .DEPOSITNO
FmtType:CHARNUM Next:DepositN
o$
2 BankCode. . . . . . . . . . . 1 SYY Bank Code . . . . . . . . . . .BANKCODE
3 DepositDate . . . . . . . . . 8 SNY Deposit Date. . . . . . . . . .DATE
4 DepositDesc . . . . . . . . . 30 SNN Deposit Description . . . . . .DESCRIPTION
5 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO
FmtType:ALPHANUM
6 CreditCardAuthorization . . . 1 SYN Credit Card Authorization . . .YESNO
DfltVal:N Valid:Y,N
7 CashDepositAmt. . . . . . . . 13.2 NNN Cash Deposit Amount . . . . . .
Mask:###,###,###.00-
8 CashBalanceAmt. . . . . . . . 13.2 NNN Cash Balance Amountt. . . . . .
Mask:###,###,###.00-
9 CreditDepositAmt. . . . . . . 13.2 NNN Credit Deposit Amount . . . . .
Mask:###,###,###.00-
10 CreditBalanceAmt. . . . . . . 13.2 NNN Credit Balance Amount . . . . .
Mask:###,###,###.00-
11 DepositBalance. . . . . . . . 13.2 NNN Deposit Balance . . . . . . . .
Read Only:Y Mask:###,###,
###.00-
12 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
13 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
14 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
15 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
16 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
17 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL