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