In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Extension of Transaction Number Field Length
To accommodate the requirements of customers who generate a large volume of inventory transactions, a QAD 2012 SE schema change increases the length of the Trans (tr_trnbr) field in the Inventory Transaction History (tr_hist) table from 8 characters to 10. The maximum value of that field is now 9999999999. The associated sequence definition has been updated to restart when the new maximum is exceeded.
Other fields that store the value from tr_trnbr have been similarly changed. The following table lists the fields that have been modified.
 
Field
Table
 
 
Field
Table
cctr_trnbr
cctr_hist
 
 
ieh_trnbr
ieh_hist
cncix_ship_trnbr
cncix_mstr
 
 
kbtrd_tr_trnbr
kbtrd_det
cncud_ship_trnbr
cncud_det
 
 
sbid_trnbr
sbid_det
cncu_trnbr
cncu_mstr
 
 
six_trnbr
six_ref
cnsix_receipt_trnbr
cnsix_mstr
 
 
trcs_trnbr
trcs_det
cnsud_receipt_trnbr
cnsud_det
 
 
trgl_trnbr
trgl_det
cnsu_trnbr
cnsu_mstr
 
 
tr_trnbr
tr_hist
ied_trnbr
ied_det
 
 
wlt_trnbr
wlt_mstr
Program changes throughout Standard Edition allow for this new field length in maintenance, processing, browse, reporting, and display functions.
Updating EDI eCommerce Document Definitions
If you use EDI eCommerce, you may need to adjust a value in your exchange and application document definitions to allow for the new transaction number field length.
In the document definitions, the user specifies the field name and the Maximum Size (in characters) that the value can be for the field. If the value being processed is greater in length than the maximum size specified, the document fails during processing.
Because the maximum value of tr_trnbr was 99999999, the maximum length value that is specified for this field in the document definitions is 8. With the new 10-character field (maximum value 99999999999), all EDI document definitions that include a maximum value of 8 for tr_trnbr must be increased to 10.