View: Payment Info

RotoID: YP0406
Table: YPPMTINF
Protocol: Flat
DLL:YPPMTINF

Keys: 2

Title Fields

Customer Number/Card ID IDCUSTIDCARD
Processing Code PROCESSCODIDCUSTIDCARD

Fields: 33

Field Index Type Title Attributes Presentation

IDCUST 1 String*12 Customer Number E A K R  Mask: %-12C
IDCARD 2 String*12 Card ID E A K R  Mask: %-12C
DESC 3 String*60 Card Description E A 
CARDTYPE 4 Integer Card Type E A  List:7 entries
0 =
3 = American Express
4 = Visa
5 = MasterCard
6 = Discover
7 = JCB
68 = Debit Card
PROCESSCOD 5 String*12 Processing Code E A 
DATELASTMN 6 Date Date Last Maintained E A C 
SWACTV 7 Integer Status E A  List:2 entries
0 = Inactive
1 = Active
DATEINACTV 8 Date Inactive Date E A C 
SWDEFCARD 9 Integer Default Card E A  List:2 entries
0 = No
1 = Yes
NAMEONCARD 10 String*103 Cardholder Name E A 
BLADDR1 11 String*50 Billing Address Line 1 E A 
BLADDR2 12 String*50 Billing Address Line 2 E A 
BLCITY 13 String*50 Billing City E A 
BLSTATE 14 String*50 Billing State E A 
BLCOUNTRY 15 String*50 Billing Country E A 
BLZIPCODE 16 String*50 Billing Zipcode E A 
VAULTID 17 String*36 Vault ID E A 
CARDNUMBER 18 String*30 Masked Card Number E A 
EXPDATE 19 String*4 Expiration Date E A 
CARDCMNT 20 String*255 Comment E A 
SWAUTOPAY 21 Integer Allow Auto Pay E A  List:2 entries
0 = No
1 = Yes
VNUMBER 50 String*30 Masked Credit Card Number E A C 
VEXPDATE 51 String*5 Expiration Date E A C 
VAMOUNT 52 BCD*10.3 Total Amount E A C 
VTAXAMT 53 BCD*10.3 Tax Amount E A 
VSUBAMT 54 BCD*10.3 Subtotal Amount E A C 
VTIME 55 String*50 Time E A C 
VAUTHCODE 56 String*50 Authorization Code E A C 
SWONETIME 57 Integer One Time Use Switch E A C 
VPROCCODE 58 Integer Processing Code E A C 
PROCESSCMD 59 Integer Processing Command E A C  List:2 entries
1 = Get default processing code
2 = Get default card's processing code, bank, and currency
BANK 60 String*8 Bank code E A C 
CURRENCY 61 String*3 Currency Code E A C