GetCustPPVCreditLimit
Input XML Tags
|
XML Tag |
Definition |
Rules |
|
comcorp |
Five digit system number assigned to each corp. |
5 digit system number assigned to each corp |
|
house |
Six digit house number |
Up to six digit house number |
|
cust |
Two digit customer number |
Two digit customer number (1 – 99) |
|
opr |
Three character operator id |
3 characters, legal operator id |
Output XML Tags
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
comcorp |
CORP |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
house |
HOUSE |
CHAR(6) |
N |
Up to 6 digit house number |
|
cust |
CUST |
CHAR(2) |
N |
Up to 2 digit customer number |
|
ppvcreditlimit |
PPVCREDITLIMIT |
CHAR(8) |
N |
Cable system defined credit limit |
|
custbalance |
CUSTBALANCE |
CHAR(8) |
N |
Calculated customer balance (Customer balance + memocrdt + crdtprorat + twlprorate) |
|
availableppvcredit |
AVAILABLEPPVCREDIT |
CHAR(8) |
N |
Customer's available calculated credit (ppvcreditlimit value minus the custbalance value) |
|
vip |
VIP |
CHAR(1) |
N |
Y = VIP customer, N = non-VIP customer |