ChangeMoneyStatus
|
XML Tag |
Definition |
Rules |
|
comcorp |
5 digit field |
Five digit system number assigned to each corp. The corp number is unique only within one Tandem system. |
|
house |
6 character field |
House number. Numeric only |
|
cust |
2 character field |
Customer number. Numeric values only. |
|
opr |
3 character field |
3 character operator id, must be in Operator Id table. |
|
custlevelpin |
4 character field |
Four digit customer level pin |
|
lockacct_pid |
5 character field |
5 digit unique locking pid (1,001 - 65, 535) (05-23-2001) |
|
mnyoption |
1 character field |
1= Set Collections, 2= Set EFTS, 3= Set Refunds, 4= Set VIP, 5= Change Note Pad, 6= Change Tallies |
|
IF mnyoption = 1, only send tags within option1 |
||
|
IF mnyoption = 2, only send tags within option2 |
||
|
IF mnyoption = 3, only send tags within option3 |
||
|
IF mnyoption = 4, only send tags within option4 |
||
|
IF mnyoption = 5, only send tags within option5 |
||
|
IF mnyoption = 6, only send tags within option6 |
||
|
option1 |
option1 beginning delimiter |
|
|
cc_nextdate |
YYYY-MM-DD |
valid date, not in past or not greater than 999 days in the future; blank = close and clear; all other values in nextcollactivity and action products will be ignored. Only collection comments will be used. |
|
close_clear |
1 character field |
Y=close account to colections and clear holds, N=don't close account and clear holds |
|
cc_nextpath |
2 digit field |
valid value from the collpathprod table |
|
cc_nextstep |
2 digit field |
valid value from the collpathstep table |
|
cc_collector |
2 character field |
valid value in Code95 table, (207) the agency value or blanks (07/03/2001) |
|
cc_queue |
1 character field |
Y= in queue, N= not in queue |
|
ppvhold |
1 character field |
Y = hold, N=no hold |
|
upgradehold |
1 character field |
Y = hold, N=no hold |
|
transferhold |
1 character field |
Y = hold, N=no hold |
|
cmnt_commt |
350 characters |
Alpha-numeric, maximum charters = 350; amount of data stored dependent on ControlParams table, maximum length |
|
/option1 |
option1 ending delimiter |
|
|
option2 |
option2 beginning delimiter |
|
|
cefts_efttype |
1 digit field |
0 = remove efts or payment card information for account, 1=pre-authorized checking, 2=bank card, 3=payment card; (type 3 only valid if o3p_recurpaycard is set to "Y") |
|
c_form |
1 character field |
Only include tag if cefts_efttype = 0 |
|
c_mode |
1 character field |
Only include tag if cefts_efttype = 0 |
|
cefts_bank |
8 character field |
Only include tag if cefts_efttype = 1; valid value in BankCatalog Table |
|
cefts_finbr |
10 character field |
Only include tag if cefts_efttype = 1 |
|
cefts_cardtyp |
1 character field |
Only include tag if cefts_efttype = 2, 1=Visa, 2=Mastercard |
|
cefts_bacct |
19 character field |
Only include tag if cfts_efttype = 1 (maximum length = 17) and if cefts_efttype = 2 (maximum length = 19) |
|
paymentcardgroup |
|
Beginning paymentcardgroup delimiter |
|
This grouping of tags should only be present if cefts_efttype = 3. |
||
| If o3p_paycardreqsecond = 1, second card is required if setting account up as "recurring" payment type. | ||
| paymentcard | Beginning paymentcard delimiter | |
|
cpccrd_cardtype |
1 character field |
valid value in Code36 table (166) |
|
cpccrd_cardnumber |
19 characters |
Free-form entry |
| cpccrd_primsecond | 1 character field | 1=primary, 2=secondary, blank or NULL =other card or # to delete record |
|
cpccrd_cardname |
26 characters |
Free-form entry |
|
cpccrd_expiredate |
4 character field |
MMYY |
|
cpccrd_billaddress |
20 characters |
Free-form entry |
|
cpccrd_zipcode |
6 character field |
Valid values; zipcode |
|
cpccrd_zip4 |
4 character field |
Valid values; zip4 entry |
|
/paymentcard |
|
Ending paymentcard delimiter |
|
/paymentcardgroup |
|
Ending paymentcardgroup delimiter |
|
cefts_acctinf |
1 character field |
If cefts_efttype = 1, valid values; 1=checking and 2 = savings; if cefts_efttype = 2, valid values; Code36 table (141) |
|
cefts_encd |
1 character field |
Y= Encoded, N= Not encoded (if o2p_eftfmt = 2 or 4) pacinfo |
|
cefts_prenote |
1 character field |
Y or N (is only applicable if o2p_eftfmt = 3) |
|
/option2 |
option2 ending delimiter |
|
|
option3 |
|
option3 beginnning delimiter |
|
crf_stat |
1 character field |
Valid values: S = Force to Send, H = Force to Hold, W = Write-off Amount, T = Set to Transfer, D = Remove From Refunds |
|
/option3 |
option3 ending delimiter |
|
|
option4 |
option4 beginning delimiter |
|
|
c_vip |
1 character field |
Y = VIP, N= not VIP |
|
/option4 |
option4 ending delimiter |
|
|
option5 |
option5 beginnning delimiter |
|
|
cqnp_action |
2 character field |
Code95 (208) |
|
cqnp_ticklerdate |
date |
YYYY-MM-DD |
|
cqnp_note |
35 character field |
Free form comment for the collection Queue collector to use for this account. For the NotePad optn. Valid Values: |
|
/option5 |
option5 ending delimiter |
|
|
option6 |
option6 beginning delimiter |
|
|
talliesgroup |
talliesgroup beginning delimiter |
|
|
cst_tallycode |
2 digit field |
3=open to collctns 4=NPDcreated 5=NPD routed 6=NPD cmpltd 7=NSF checks 8=. Valid Values: Late fees 9=Writeoffs 10=Date ext 11=Partials 12=#Pymt |
|
cst_lastdate |
date |
YYYY-MM-DD |
|
cst_lifecnt |
5 digit field |
Number of times for each tally for the life of the account. |
|
cst_tallycurrentmonth |
2 digit field |
Tally count for account's current month. Valid Values: 1-99 |
|
cst_tallypreviousmonth |
2 digit field |
Tally count for account's previous month. Valid Values: 1-99 |
|
/talliesgroup |
talliesgroup ending delimiter |
|
|
/option6 |
option6 ending delimiter |
Output XML Tags
|
XML Tag |
Definition |
|
errorcode |
short |
|
errormessage |
char |
Change Log
|
5/7/01 |
Changed cmnt_comnt to cmnt_commt in the API code to reflect spreadsheet and tag consistency |
|
Changed cefts_encode to cefts_encd for consistency with GetCustEFTS API |
|
|
5/7/01 |
Changed YYMM to MMYY in cpccrd_expiredate field |
|
5/10/01 |
Modified ceft_prenote description |
|
5/22/01 |
Added code95 table # for agency table to collector tag |
|
5/23/01 |
Added lockacct_pid data field for locking functionality |
|
6/29/01 |
Added usage information concerning option1 functionality |
|
7/3/01 |
Change description of cc_collector field |
|
8/24/01 |
Updated cefts_encd and cefts_prenote tags for further clarity |
| 9/6/01 | New tag groupings and tags for Option 2 and "paymentcard" input. |
Usage
1. When executing option1 functionality, if the account is "waiting" (GetCustCollect API, field cc_waiting, 1 = waiting for NPD, 2 = waiting for DRD), then the only fields that can be changed are the "agency", "queue", "holds" and "comments" fields.
It can also "close the customer out of collections".2. In the new tag groupings for paymentcards up to 5 cards may be submitted at one time.
3. Rules for payment card grouping are the following. An account must always have a Primary Card. If setting up an account for the first time, there must be a primary card. If a primary card already exists then one is not necessary in the transaction. If the o3p_paycardreqsecond field is set to "Y" then a secondary card must be present in the transaction (unless one already exists in the database). If one of the 5 payment card records being sent is for deleting of a primary or secondary card then one of the other records must be a replacement for that card (unless deleting a secondary card and a secondary card is NOT required).
Associated XML Documents