AR_CustomerCreditCardListWrk AR Customer Credit Card List WorkRel: 4.40 Bld: 398 8/28/2009 Bus Obj: AR_CustomerCreditCardList_rpt SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_CustomerCreditCardListWrk"+%S$+".M4T"
KPRIMARY: SortField
Fld Column Name M/L TUR Description/Notes Class
1 SortField . . . . . . . . . . 127 SNN Sort Field. . . . . . . . . . . 2 ARDivisionNo. . . . . . . . . 2 SNN AR Division Number. . . . . . . 3 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . . 4 CustomerName. . . . . . . . . 30 SNN Customer Name . . . . . . . . . 5 EncryptedCreditCardNo . . . . 24 SNN Encrypted Credit Card Number. . 6 PartiallyEncryptedCreditCardNo 24 SNN Partially Encrypted Credit Card 7 PaymentType . . . . . . . . . 5 SNN Payment Type. . . . . . . . . . 8 PaymentDesc . . . . . . . . . 30 SNN Payment Description . . . . . . 9 ExpirationDateYear. . . . . . 4 SNN Expiration Date Year. . . . . . 10 ExpirationDateMonth . . . . . 2 SNN Expiration Date Month . . . . . 11 CorporateCustIDPurchOrder . . 25 SNN Corporate Customer ID Purchase 12 CardholderName. . . . . . . . 30 SNN Cardholder Name . . . . . . . . 13 AVSAddress. . . . . . . . . . 30 SNN AVS Address . . . . . . . . . . 14 AVSCity . . . . . . . . . . . 20 SNN AVS City. . . . . . . . . . . . 15 AVSState. . . . . . . . . . . 2 SNN AVS State . . . . . . . . . . . 16 AVSZipCode. . . . . . . . . . 10 SNN AVS Zip Code. . . . . . . . . . 17 CreditCardComment . . . . . . 30 SNN Credit Card Comment . . . . . . 18 Last4UnencryptedCreditCardNos 4 SNN Last 4 Unencrypted Credit Card 19 FullCreditCardNo. . . . . . . 24 SNN Full Credit Card Number . . . . 20 PrimaryCreditCardNo . . . . . 1 SNN Primary Credit Card Number. . . 21 EBMEnabled. . . . . . . . . . 1 SNN e-Business Manager Enabled. . . 22 EBMUserID . . . . . . . . . . 15 SNN e-Business Manager User ID. . . 23 EBMUserName . . . . . . . . . 30 SNN e-Business Manager User Name. .