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