AR_CashReceiptsHeader AR Cash Receipts Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CashReceipts_bus,BC_CommonImport SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CashReceiptsHeader.M4T"
KPRIMARY: DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo KBATCH: BatchNo+DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+CheckNo KUNENCRYPTED: Last4UnencryptedCreditCardNos+DepositNo+ARDivisionNo+CustomerNo+EncryptedCreditCardNo+Che ckNo KCUSTOMER: ARDivisionNo+CustomerNo+DepositNo+EncryptedCreditCardNo+CheckNo KCHECKNO: DepositNo+ARDivisionNo+CustomerNo+CheckNo+EncryptedCreditCardNo
Fld Column Name M/L TUR Description/Notes Class
1 DepositNo . . . . . . . . . . 5 SYY Deposit Number. . . . . . . . .DEPOSITNO FmtType:CHARNUM 2 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION Mask:00 FmtType:ZEROFILL 3 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ 4 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO DepVal:REQUIRED 5 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . .CHECKNO DepVal:REQUIRED 6 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . .PAYMENTTYPE ValGroup:CreditCard 7 DepositType . . . . . . . . . 1 SYY Deposit Type. . . . . . . . . . Valid:C,R Notes: C=Cash, R=cRedit 8 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . .NAME 9 OpenItemCustomer. . . . . . . 1 SYN Open Item Customer. . . . . . .YESNO Read Only:Y DfltVal:N Valid:Y,N 10 BatchNo . . . . . . . . . . . 5 SYN Batch Number. . . . . . . . . .BATCHNO Read Only:Y Mask:00000 FmtType:ALPHANUM 11 CreditCardCVV2No. . . . . . . 5 SNN Credit Card CVV2 Number . . . . ValGroup:CreditCard 12 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card ValGroup:CreditCard 13 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . . ValGroup:CreditCard 14 ExpirationDateMonth . . . . . 2 SNN Fiscal Period . . . . . . . . .FISCALPERIOD Mask:00 FmtType:ZEROFILL ValGroup:CreditCard 15 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas ValGroup:CreditCard 16 CorporateTaxOverrd. . . . . . 1 SYY Corporate Tax Overridden. . . .YESNO DfltVal:N Valid:Y,N ValGroup:CreditCard 17 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . . ValGroup:CreditCard 18 CreditCardTransactionID . . . 10 SNN Credit Card Transaction ID. . . ValGroup:CreditCard 19 CreditCardAuthorizationNo . . 16 SNN Credit Card Authorization Numbe ValGroup:CreditCard 20 AuthorizationDate . . . . . . 8 SNN Authorization Date. . . . . . .DATE ValGroup:CreditCard 21 AuthorizationTime . . . . . . 8 SNN Authorization Time. . . . . . . ValGroup:CreditCard 22 AVSAddress. . . . . . . . . . 30 SNN AVS Address Line. . . . . . . .ADDRESSLINE ValGroup:CreditCard 23 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY ValGroup:CreditCard 24 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE ValGroup:CreditCard 25 AVSZipCode. . . . . . . . . . 10 SYN AVS Zip Code. . . . . . . . . .ZIPCODE ValGroup:CreditCard 26 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . . ValGroup:CreditCard 27 PostingAmt. . . . . . . . . . 14.2 NNN Posting Amount. . . . . . . . . Mask:#,###,###,###.00- ChngTag:Sum 28 CustomerBalance . . . . . . . 14.2 NNN Customer Balance. . . . . . . . Mask:#,###,###,###.00- ChngTag:Sum 29 CorporateSalesTax . . . . . . 12.2 NNN Corporate Sales Tax . . . . . .MISCAMOUNT Mask:##,###,###.00- ValGroup:CreditCard ChngTag:Sum 30 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y ChngTag:Min Notes: YYYYMMDD 31 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y ChngTag:CopyMin/D ateCreated$ 32 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Min/DateCreated$ 33 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE Read Only:Y ChngTag:Max Notes: YYYYMMDD 34 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . . Read Only:Y ChngTag:CopyMax/D ateUpdated$ 35 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL ChngTag:Copy Max/DateUpdated$