AR_CustomerCreditCard AR Customer Credit Card Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_CustomerCreditCard_bus
SQL Def: N SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerCreditCard.M4T"
KPRIMARY: ARDivisionNo+CustomerNo+EncryptedCreditCardNo
KUNENCRYPTED: Last4UnencryptedCreditCardNos+ARDivisionNo+CustomerNo+EncryptedCreditCardNo
KPAYMENT: PaymentType+ARDivisionNo+CustomerNo+EncryptedCreditCardNo
Fld Column Name M/L TUR Description/Notes Class
1 ARDivisionNo. . . . . . . . . 2 SNY AR Division Number. . . . . . .ARDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {AR_31$(1,2)}
2 CustomerNo. . . . . . . . . . 20 SYY Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$ Notes:
{AR_31$(3,7)}
3 EncryptedCreditCardNo . . . . 24 SNY Encrypted Credit Card Number. .ENCRYPTEDCREDITCARDNO
Notes: {AR_31$(10,24)}
4 PaymentType . . . . . . . . . 5 SYY Payment Type. . . . . . . . . .
Notes: {AR_31$(34,5)}
5 ExpirationDateYear. . . . . . 4 SNY Expiration Date Year. . . . . .YEAR
Mask:0000 Notes: {AR_31$(43,
2)}
6 ExpirationDateMonth . . . . . 2 SNY Expiration Date Month . . . . .MONTH
Mask:00 FmtType:ZEROFILL
Notes: {AR_31$(45,2)}
7 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID / Purchas
8 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . .
Notes: {AR_31$(47,30)}
9 AVSAddress. . . . . . . . . . 30 SNN AVS Address . . . . . . . . . .ADDRESSLINE
Notes: {AR_31$(77,30)}
10 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . .CITY
Notes: {AR_31$(107,20)}
11 AVSState. . . . . . . . . . . 2 SYN AVS State . . . . . . . . . . .STATE
Notes: {AR_31$(127,2)}
12 AVSZipCode. . . . . . . . . . 10 SYN AVS Zip Code. . . . . . . . . .ZIPCODE
Notes: {AR_31$(129,10)}
13 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . .
Notes: {AR_31$(139,30)}
14 EBMEnabled. . . . . . . . . . 1 SYN e-Business Manager Enabled. . .YESNO
DfltVal:N Valid:Y,N Notes:
{AR_31$(169,1)}
15 Last4UnencryptedCreditCardNos 4 SNY Last 4 Unencrypted Credit Card
Read Only:Y Notes: {AR_31$(17
0,4)}
16 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
17 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
18 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL
19 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
20 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
21 UserUpdatedKey. . . . . . . . 10 SYN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000
FmtType:ZEROFILL