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$