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  |   Cloud ERP  |   Home  |   qad.com



  •     QAD Glossary

  • 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.