GetBoxRepairHistory
Input XML Tags
|
XML Tag |
Definition |
|
comcorp |
Five digit system number assigned to each corp. |
|
binv_bnumb |
14 character box serial number |
Output XML Tags
|
XML Tag |
Column Name |
Data Type |
Nullable |
Definition |
|
bpr_corp |
CORP |
INT UNSIGNED |
N |
Five digit accounting corp number assigned to each corp |
|
bpr_bnumb |
BNUMB |
CHAR(14) |
N |
Box serial number. Valid Values: Alpha/Numeric |
|
boxrepairhistorygroup |
Beginning boxrepairhistorygroup delimiter |
|||
|
bpr_brepdate |
BREPDATE |
DATETIME |
N |
Date/Time the device was repaired. Valid Values: YYYY-MM-DD:hh:mm:ss.nnnnnn |
|
bpr_problem |
PROBLEM |
CHAR(1) |
N |
Problem code. Valid Values: Code36 table (128) [06/13/2001] |
|
bpr_bxfixcode |
BXFIXCODE |
CHAR(1) |
N |
Box repair fix code. Valid Values: 0-9, A-Z ; Code36 table (129) |
|
bpr_who |
WHO |
CHAR(3) |
N |
ID of the operator responsible for making change. |
|
/boxrepairhistorygroup |
Ending boxrepairhistorygroup delimiter |
Source Tables
Change Log
|
6/13/01 |
Changed description for bpr_problem field. Code36 table (128) |
Usage
Associated XML Documents